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 UIE041090 : FrmBase { public UIE041090() { InitializeComponent(); } public void init() { string commCodeCd = "A01004,E01010"; 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.ComboCoilType, ref dt, "A01004"); Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboNoOrdCauseCD, ref dt, "E01010"); } public string Condition { set { string array = value.Trim(); this.textCoilNO.Text = array; this.DoQuery(); } } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": this.DoQuery(); break; } } private void DoQuery() { try { string coilNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textCoilNO.Text)); this.dataSet1.Tables[0].Clear(); DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; ArrayList paramArray = new ArrayList(); paramArray.Add("UIE041090.Coil.Select"); paramArray.Add(coilNO); paramArray.Add(""); paramArray.Add(""); ccp.ServerParams = new object[] { paramArray }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); this.textCoilNO.Text = dt.Rows[0]["COIL_NO"].ToString(); this.textCAL_WGT.Text = dt.Rows[0]["CAL_WGT"].ToString(); this.textCOIL_CRE_DTIME.Text = dt.Rows[0]["COIL_CRE_DTIME"].ToString(); this.textCOIL_INDIA.Text = dt.Rows[0]["COIL_INDIA"].ToString(); this.textCOIL_LEN.Text = dt.Rows[0]["COIL_LEN"].ToString(); this.textCOIL_OUTDIA.Text = dt.Rows[0]["COIL_OUTDIA"].ToString(); this.textCOIL_STAT.Text = dt.Rows[0]["COIL_STAT"].ToString(); this.textCOIL_THK.Text = dt.Rows[0]["COIL_THK"].ToString(); this.textCOIL_WTH.Text = dt.Rows[0]["COIL_WTH"].ToString(); this.textCoilNO.Text = dt.Rows[0]["COIL_NO"].ToString(); this.textCUR_LOAD_LOC.Text = dt.Rows[0]["CUR_LOAD_LOC"].ToString(); this.textCUR_LOAD_LOC_DTIME.Text = dt.Rows[0]["CUR_LOAD_LOC_DTIME"].ToString(); this.textCUR_PROG_CD.Text = dt.Rows[0]["CUR_PROG_CD"].ToString(); this.textCUR_PROG_CD_DTIME.Text = dt.Rows[0]["CUR_PROG_CD_DTIME"].ToString(); this.textCUST_CD.Text = dt.Rows[0]["CUST_CD"].ToString(); this.textEXTSHAPE_DEC_DTIME.Text = dt.Rows[0]["EXTSHAPE_DEC_DTIME"].ToString(); this.textEXTSHAPE_DEC_GRD.Text = dt.Rows[0]["EXTSHAPE_DEC_GRD"].ToString(); this.textINGR_DEC_DTIME.Text = dt.Rows[0]["INGR_DEC_DTIME"].ToString(); this.textINGR_DEC_GRD.Text = dt.Rows[0]["INGR_DEC_GRD"].ToString(); this.textINSTR_COIL_INDIA.Text = dt.Rows[0]["INSTR_COIL_INDIA"].ToString(); this.textINSTR_COIL_LEN.Text = dt.Rows[0]["INSTR_COIL_LEN"].ToString(); this.textINSTR_COIL_OUTDIA.Text = dt.Rows[0]["INSTR_COIL_OUTDIA"].ToString(); this.textINSTR_COIL_THK.Text = dt.Rows[0]["INSTR_COIL_THK"].ToString(); this.textINSTR_COIL_WTH.Text = dt.Rows[0]["INSTR_COIL_WTH"].ToString(); this.textMATLQLTY_DEC_DTIME.Text = dt.Rows[0]["MATLQLTY_DEC_DTIME"].ToString(); this.textMATLQLTY_DEC_GRD.Text = dt.Rows[0]["MATLQLTY_DEC_GRD"].ToString(); this.textNONORD_CAUSE_CD.Text = dt.Rows[0]["NONORD_CAUSE_CD"].ToString(); this.textNONORD_OCR_DTIME.Text = dt.Rows[0]["NONORD_OCR_DTIME"].ToString(); this.textORD_SEQ.Text = dt.Rows[0]["ORD_SEQ"].ToString(); this.textORD_USE_CD.Text = dt.Rows[0]["ORD_USE_CD"].ToString(); this.textORDCUST_CD.Text = dt.Rows[0]["ORDCUST_CD"].ToString(); this.textORG_ORD_NO.Text = dt.Rows[0]["ORG_ORD_NO"].ToString(); this.textORG_ORD_SEQ.Text = dt.Rows[0]["ORG_ORD_SEQ"].ToString(); this.textSPEC_ABBSYM.Text = dt.Rows[0]["SPEC_ABBSYM"].ToString(); this.textSTL_GRD.Text = dt.Rows[0]["STL_GRD"].ToString(); this.textTOT_DEC_DTIME.Text = dt.Rows[0]["TOT_DEC_DTIME"].ToString(); this.textTOT_DEC_GRD.Text = dt.Rows[0]["TOT_DEC_GRD"].ToString(); } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } private void UIE041090_Load(object sender, EventArgs e) { init(); } } }