using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using System.Collections; using Infragistics.Win.UltraWinGrid; namespace Core.LZMes.Client.QCM { public partial class QCM0105 : FrmBase { public QCM0105() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Add": this.DoAdd(); break; case "Update": this.DoUpdate(); break; case "Delete": this.DoDelete(); break; } } private void DoQuery() { //查询 try { this.dataSet1.Tables[0].Clear(); string deftDesc = this.textBox1.Text.Trim(); //缺陷描述 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM01.QCM0105.QueryDefect"; ccp.MethodName = "Query"; ccp.ServerParams = new object[] { deftDesc }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统发生异常,请与管理员联系", "提示"); } } private void DoAdd() { try { if (this.UserInfo.GetUserGroup() == 0 + "") { MessageBox.Show("常白班人员禁止对数据进行操作", "警告"); return; } if ("" == this.textBox2.Text || null == this.textBox2.Text) { MessageBox.Show("缺陷项目代码不能为空!", "警告"); this.textBox2.Focus(); return; } if (MessageBox.Show("确认保存?", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel) return; ArrayList al = new ArrayList(); al.Add(this.textBox2.Text.Trim()); //缺陷项目代码 al.Add(this.textBox3.Text.Trim()); //缺陷项目描述 al.Add(this.textBox4.Text.Trim()); //缺陷分类描述 al.Add(this.textBox5.Text.Trim()); //备注 al.Add(this.UserInfo.GetUserID()); //创建人ID al.Add(this.UserInfo.GetUserName()); //创建人 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM01.QCM0105.addDefect"; ccp.MethodName = "add"; ccp.ServerParams = new object[] { al }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); // if (0 != ccp.ReturnCode) return; if ("1" != ccp.ReturnObject.ToString()) { MessageBox.Show(ccp.ReturnObject.ToString(), "警告"); return; } this.textBox1.Text = al[1].ToString(); DoQuery(); MessageBox.Show("创建成功!"); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统发生异常,请与管理员联系", "提示"); } } private void DoUpdate() { try { if (this.UserInfo.GetUserGroup() == 0 + "") { MessageBox.Show("常白班人员禁止对数据进行操作", "警告"); return; } if (this.ultraGrid1.Selected.Rows.Count == 0) { MessageBox.Show("请选择要修改的数据!"); return; } //选择一行数据 UltraGridRow ugr = this.ultraGrid1.ActiveRow; string defeCode = ugr.Cells["DEFECT_CODE"].Value.ToString(); if (MessageBox.Show("确认修改?", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel) return; ArrayList al = new ArrayList(); al.Add(this.textBox3.Text.Trim()); //缺陷项目描述 al.Add(this.textBox4.Text.Trim()); //缺陷分类描述 al.Add(this.textBox5.Text.Trim()); //备注 al.Add(this.UserInfo.GetUserID()); //修改人ID al.Add(this.UserInfo.GetUserName()); //修改人 al.Add(defeCode); //缺陷项目代码 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM01.QCM0105.SaveDefect"; ccp.MethodName = "Save"; ccp.ServerParams = new object[] { al }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); //if (0 != ccp.ReturnCode) return; if ("1" != ccp.ReturnObject.ToString()) { MessageBox.Show(ccp.ReturnObject.ToString(), "警告"); return; } this.textBox1.Text = al[0].ToString(); DoQuery(); MessageBox.Show("修改成功!"); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统发生异常,请与管理员联系", "提示"); } } private void DoDelete() { try { if (this.UserInfo.GetUserGroup() == 0 + "") { MessageBox.Show("常白班人员禁止对数据进行操作", "警告"); return; } if (this.ultraGrid1.ActiveRow.Cells.Count == 0) { MessageBox.Show("请选择要修改的数据!"); return; } //选择一行数据 UltraGridRow ugr = this.ultraGrid1.ActiveRow; string defeCode = ugr.Cells["DEFECT_CODE"].Value.ToString(); if (MessageBox.Show(this, "是否确认删除?", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { return; } ArrayList al = new ArrayList(); al.Add(defeCode); //缺陷项目代码 al.Add(this.UserInfo.GetUserID()); //删除人ID al.Add(this.UserInfo.GetUserName());//删除人 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM01.QCM0105.removeDefect"; ccp.MethodName = "remove"; ccp.ServerParams = new object[] { al }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if ("1" != ccp.ReturnObject.ToString()) { MessageBox.Show(ccp.ReturnObject.ToString(), "警告"); return; } DoQuery(); MessageBox.Show("删除成功!"); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); MessageBox.Show("系统发生异常,请与管理员联系", "提示"); } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { this.textBox2.Text = this.ultraGrid1.ActiveRow.Cells["DEFECT_CODE"].Value.ToString(); this.textBox3.Text = this.ultraGrid1.ActiveRow.Cells["DEFECT_DESC"].Value.ToString(); this.textBox4.Text = this.ultraGrid1.ActiveRow.Cells["DEFECT_TYPE_DESC"].Value.ToString(); this.textBox5.Text = this.ultraGrid1.ActiveRow.Cells["MEMO"].Value.ToString(); } } }