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; namespace Core.LZMes.Client.UIE { public partial class UIE041070 : FrmBase { public UIE041070() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; } } public string Condition { set { string[] array = value.Trim().Split(new char[] { '|' }); if (array.Length < 3) return; this.textORD_NO.Text = array[0]; this.ComboORD_SEQ.Value = array[1]; this.ComboPROG_CD.Value = array[2]; this.DoQuery(); } } public void init() { string commCodeCd = "E01002"; DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; ArrayList paramArray = new ArrayList(); paramArray.Add("UIECOMM00_SELECT.COMM_CODE"); paramArray.Add(commCodeCd); ccp.ServerParams = new object[] { paramArray }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboPROG_CD, ref dt, "E01002"); } public void getOrdSeq() { try { string ordNO = this.textORD_NO.Text; DataTable dt = new DataTable(); ArrayList paramArray = new ArrayList(); paramArray.Add("UIECOMM00_SELECT.ORD_SEQ"); paramArray.Add(ordNO); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; ccp.ServerParams = new object[] { paramArray }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboORD_SEQ, ref dt, "ORD_SEQ"); } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } private void DoQuery() { try { string ordNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textORD_NO.Text)); string ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboORD_SEQ.Value)); string progCD = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboPROG_CD.Value)); this.dataSet1.Tables[0].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; ArrayList paramArray = new ArrayList(); paramArray.Add("UIE041070.COIL.Select"); paramArray.Add(ordNO); paramArray.Add(ordSeq); paramArray.Add(progCD); paramArray.Add(ordNO); paramArray.Add(ordSeq); paramArray.Add(progCD); paramArray.Add(ordNO); paramArray.Add(ordSeq); paramArray.Add(progCD); paramArray.Add(ordNO); paramArray.Add(ordSeq); paramArray.Add(progCD); paramArray.Add(ordNO); paramArray.Add(ordSeq); paramArray.Add(progCD); paramArray.Add(ordNO); // paramArray.Add(ordSeq);// paramArray.Add(progCD);// ccp.ServerParams = new object[] { paramArray}; 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 UIE041070_Load(object sender, EventArgs e) { init(); } private void textORD_NO_Leave(object sender, EventArgs e) { this.getOrdSeq(); } private void ultraGrid1_AfterCellActivate(object sender, EventArgs e) { Infragistics.Win.UltraWinGrid.UltraGrid tt = (Infragistics.Win.UltraWinGrid.UltraGrid)sender; string matNO = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveRow.Cells["MAT_NO"].Value)); UIE041090 frm = new UIE041090(); frm.ob = this.ob; frm.Condition = matNO; frm.ShowDialog(); } } }