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.UIB { public partial class UIB100101 : FrmBase { public UIB100101() { InitializeComponent(); } string msQltyCD = null; string msDataCD = null; public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; case "Save": this.DoSave(); break; case "Delete": this.DoDelete(); break; } } public void DoQuery() { try { this.dataSet1.Tables[0].Clear(); ArrayList al = new ArrayList(); al.Add("UIB100101_01.SELECT"); al.Add(this.comboBox1.SelectedValue.ToString()); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComQuery"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { al }; ccp.SourceDataTable = this.dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { } } public void DoSave() { try { //if (this.UserInfo.GetUserID() != "1" // && this.UserInfo.GetUserID() != "zw" // && this.UserInfo.GetUserID() != "lyb" // && this.UserInfo.GetUserID() != "jc190") { MessageBox.Show("无修改权限!禁止修改!", "提示"); return; } if (MessageBox.Show("确定保存?", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel) return; ArrayList list = null; ArrayList al = new ArrayList(); foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["CHK"].Text == "True") { list = new ArrayList(); if (ugr.Cells["QLTY_CD_2_TP"].Text != "")//更新 { list.Add("UIB100101_01.UPDATE"); list.Add(ugr.Cells["QLTY_CD_2"].Value.ToString()); list.Add(ugr.Cells["QLTY_OPE_CD"].Text.Trim()); list.Add(ugr.Cells["QLTY_OPE_CFNM"].Text.Trim()); list.Add(ugr.Cells["COMP_CAL"].Text.Trim()); list.Add(ugr.Cells["QLTY_OPE_GRP"].Text.Trim()); list.Add(ugr.Cells["QLTY_DIS_SEQ"].Text.Trim()); list.Add(ugr.Cells["QLTY_DIS_LEN"].Text.Trim()); list.Add(ugr.Cells["CRCT_REG"].Text.Trim()); list.Add(ugr.Cells["OTHER_OPE_CD1"].Text.Trim()); list.Add(ugr.Cells["OTHER_OPE_CD2"].Text.Trim()); list.Add(ugr.Cells["OTHER_OPE_CD3"].Text.Trim()); list.Add(ugr.Cells["OTHER_OPE_CD4"].Text.Trim()); list.Add(ugr.Cells["MS_RMK"].Text.Trim()); list.Add(ugr.Cells["EDIT_TP"].Text.Trim()); list.Add(ugr.Cells["EDIT_TP"].Text.Trim()); list.Add(ugr.Cells["QLTY_CD_2_TP"].Value.ToString()); list.Add(ugr.Cells["QLTY_OPE_CD_TP"].Text.Trim()); } else { list.Add("UIB100101_01.INSERT"); list.Add(ugr.Cells["QLTY_CD_2"].Value.ToString()); list.Add(ugr.Cells["QLTY_OPE_CD"].Text.Trim()); list.Add(ugr.Cells["QLTY_OPE_CFNM"].Text.Trim()); list.Add(ugr.Cells["COMP_CAL"].Text.Trim()); list.Add(ugr.Cells["QLTY_OPE_GRP"].Text.Trim()); list.Add(ugr.Cells["QLTY_DIS_SEQ"].Text.Trim()); list.Add(ugr.Cells["QLTY_DIS_LEN"].Text.Trim()); list.Add(ugr.Cells["CRCT_REG"].Text.Trim()); list.Add(ugr.Cells["OTHER_OPE_CD1"].Text.Trim()); list.Add(ugr.Cells["OTHER_OPE_CD2"].Text.Trim()); list.Add(ugr.Cells["OTHER_OPE_CD3"].Text.Trim()); list.Add(ugr.Cells["OTHER_OPE_CD4"].Text.Trim()); list.Add(ugr.Cells["MS_RMK"].Text.Trim()); list.Add(ugr.Cells["EDIT_TP"].Text.Trim()); } al.Add(list); if (al.Count == 0) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComSave"; ccp.MethodName = "doSimpleSave"; ccp.ServerParams = new object[] { al }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); } } this.DoQuery(); } catch (Exception ex) { MessageBox.Show("操作异常" , "提示"); } ; } public void DoDelete() { //if (this.UserInfo.GetUserID() != "1" // && this.UserInfo.GetUserID() != "zw" // && this.UserInfo.GetUserID() != "lyb" // && this.UserInfo.GetUserID() != "jc190") { MessageBox.Show("无修改权限!禁止修改!", "提示"); return; } try { if (MessageBox.Show("确定删除?", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel) return; ArrayList al = new ArrayList(); foreach (UltraGridRow ugr in this.ultraGrid1.Rows) { if (ugr.Cells["CHK"].Text == "True") { ArrayList list = new ArrayList(); list.Add("UIB100101_01.DELETE"); list.Add(ugr.Cells["QLTY_CD_2"].Value.ToString()); list.Add(ugr.Cells["QLTY_OPE_CD"].Text.Trim()); al.Add(list); } } if (al.Count == 0) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComSave"; ccp.MethodName = "doSimpleSave"; ccp.ServerParams = new object[] { al }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.DoQuery(); } catch (Exception ex) { MessageBox.Show("操作异常" , "提示"); } } public void PageInit() { try { ArrayList alt = new ArrayList(); alt.Add("UIB100101_01.INITSELECT"); this.dataSet1.Tables[1].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.JHY.JHYComQuery"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { alt }; ccp.SourceDataTable = this.dataSet1.Tables[1]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void ultraGrid1_MouseDown(object sender, MouseEventArgs e) { } private void UIB100101_Load(object sender, EventArgs e) { PageInit(); this.ultraCombo1.Text = "ALL"; } } }