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 QCM0104 : FrmBase { public QCM0104() { 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 deteName = this.textBox1.Text.Trim(); //探伤项目描述 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM01.QCM0104.QueryDete"; ccp.MethodName = "Query"; ccp.ServerParams = new object[] { deteName }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void DoAdd() { //新增 try { if (this.UserInfo.GetUserGroup() == 0 + "") { MessageBox.Show("常白班人员禁止对数据进行操作", "警告"); return; } if ("" == this.textBox2.Text ) { MessageBox.Show("探伤项目代码不能为空!", "警告"); this.textBox2.Focus(); return; } if ("" == this.textBox3.Text) { MessageBox.Show("探伤项目描述不能为空!", "警告"); this.textBox3.Focus(); return; } if ("" == this.textBox4.Text) { MessageBox.Show("缺陷分类描述不能为空!", "警告"); this.textBox4.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.QCM0104.addDete"; ccp.MethodName = "add"; ccp.ServerParams = new object[] { al }; ccp = 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()); } } 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 deteName = ugr.Cells["DETECTION_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(deteName); //探伤代码 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM01.QCM0104.SaveDete"; ccp.MethodName = "Save"; ccp.ServerParams = new object[] { al }; ccp = 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()); } } 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 deteName = ugr.Cells["DETECTION_CODE"].Value.ToString(); if (MessageBox.Show(this, "是否确认删除?", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { return; } ArrayList al = new ArrayList(); al.Add(deteName); //探伤代码 al.Add(this.UserInfo.GetUserID()); //删除人ID al.Add(this.UserInfo.GetUserName());//删除人 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "QCM.QCM01.QCM0104.removeDete"; 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()); } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { this.textBox2.Text = this.ultraGrid1.ActiveRow.Cells["DETECTION_CODE"].Value.ToString(); this.textBox3.Text = this.ultraGrid1.ActiveRow.Cells["DETECTION_NAME"].Value.ToString(); this.textBox4.Text = this.ultraGrid1.ActiveRow.Cells["DEFECT_TYPE_DESC"].Value.ToString(); this.textBox5.Text = this.ultraGrid1.ActiveRow.Cells["MEMO"].Value.ToString(); } } }