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; namespace Core.LZMes.Client.UIE { public partial class UIE041010 : FrmBase { public UIE041010() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Save": this.DoUpdate(); break; } } private void DoQuery() { try { string areaType = "1"; this.dataSet1.Tables[0].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.InvokeID = "C06010103"; ccp.ServerName = "UIE.UIE01.UIE041010"; ccp.MethodName = "query01"; ccp.ServerParams = new object[] { areaType }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); Console.WriteLine(this.dataSet1.Tables[0].ToString()); } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } private void DoUpdate() { try { string used_yn = ""; string proc_rate = this.textBox3.Text; string proc_cd = this.textBox2.Text; if (this.checkBox1.Checked) { used_yn = "Y"; }else{ used_yn = "N"; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIE.UIE01.UIE041010"; ccp.MethodName = "update01"; ccp.ServerParams = new object[] { proc_rate, used_yn, proc_cd }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != 0) return; this.ultraGrid1.Refresh(); MessageBox.Show("修改数据成功!"); } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } private void checkBox1_CheckedChanged(object sender, EventArgs e) { if (!this.checkBox1.Checked) { this.textBox1.Text = ""; this.textBox2.Text = ""; this.textBox3.Text = ""; } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { string v_proc_rate = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraGrid1.ActiveRow.Cells["PROC_RATE"].Value)); string v_proc_nm = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraGrid1.ActiveRow.Cells["PROC_NM"].Value)); string v_proc_cd = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraGrid1.ActiveRow.Cells["PROC_CD"].Value)); string v_chk = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraGrid1.ActiveRow.Cells["USED_YN"].Value)); this.textBox3.Text = v_proc_rate; this.textBox1.Text = v_proc_nm; this.textBox2.Text = v_proc_cd; if (v_chk.Equals("Y")) { this.checkBox1.Checked = true; } else { this.checkBox1.Checked = false; } } } }