XinYu_LZMES_Client/Core.LZMes.Client.UIE/UIE041/UIE041090.cs

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();
        }
    }
}