XinYu_LZMES_Client/.svn/pristine/37/3741156883219ed4fcdcfdd5db4ee7a9dc949867.svn-base

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 UIE041080 : FrmBase
    {
        public UIE041080()
        {
            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 < 2) return;
                this.textOrdNO.Text = array[0];
                this.ComboORD_SEQ.Value = array[1];
                this.DoQuery();
            }
        }

        public void getOrdSeq()
        {
            try
            {
                string ordNO = this.textOrdNO.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.textOrdNO.Text));
                string ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboORD_SEQ.Value));
                ArrayList paramArray = new ArrayList();
                paramArray.Add("UIE041080.Order.Select");
                paramArray.Add(ordNO);
                paramArray.Add(ordSeq);

                DataTable dt = new DataTable();
                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);

                this.textPROD_WGT_MAX.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["PROD_WGT_MAX"]);
                this.textCUST_SPEC_NO.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["CUST_SPEC_NO"]);
                this.textORD_USEAGE_CD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_USEAGE_CD"]);
                this.textSPEC_ABBSYM.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["SPEC_ABBSYM"]);
                this.textCUST_CD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["CUST_CD"]);
                this.textSALE_CHR_CD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["SALE_CHR_CD"]);
                this.textORDCUST_CD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORDCUST_CD"]);
                this.textEMGMTR_NMG_CLF.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["EMGMTR_NMG_CLF"]);
                this.textSCARPING_PROC_YN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["SCARPING_PROC_YN"]);
                this.textORD_ENDBY.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_ENDBY"]);
                this.textORD_END_YN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_END_YN"]);
                this.textPROD_WGT_MAX.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["PROD_WGT_MAX"]);
                this.textORD_LEN_MAX.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_LEN_MAX"]);
                this.textORD_END_DATE.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_END_DATE"]);
                this.textSHIP_ENDBY.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["SHIP_ENDBY"]);
                this.textPROD_WGT_MIN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["PROD_WGT_MIN"]);
                this.textORD_LEN_MIN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_LEN_MIN"]);
                this.textSPM_PROC_YN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["SPM_PROC_YN"]);
                //this.textBox35.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["Box35"]);
                this.textRCVORD_CLF.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["RCVORD_CLF"]);
                this.textSHIP_FN_DATE.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["SHIP_FN_DATE"]);
                this.textWGT_ACVAL_MAX.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["WGT_ACVAL_MAX"]);
                this.textTHK_TOL_ERMAX.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["THK_TOL_ERMAX"]);
                this.textDEL_TO_DATE.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["DEL_TO_DATE"]);
                this.textSTKSALE_TP.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["STKSALE_TP"]);
                this.textSHIP_END_YN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["SHIP_END_YN"]);
                this.textWGT_ACVAL_MIN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["WGT_ACVAL_MIN"]);
                this.textTHK_TOL_ERMIN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["THK_TOL_ERMIN"]);
                this.textEXAMORG_CD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["EXAMORG_CD"]);
                this.textORD_CNCBY.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_CNCBY"]);
                this.textORD_CNC_YN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_CNC_YN"]);
                this.textORD_OUTDIA.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_OUTDIA"]);
                this.textORD_WGT.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_WGT"]);
                this.textORD_CNC_DTIME.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_CNC_DTIME"]);
                this.textORD_UDTBY.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_UDTBY"]);
                this.textORD_INDIA.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_INDIA"]);
                this.textORD_LEN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_LEN"]);
                this.textDLIV_TP.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["DLIV_TP"]);
                //this.textBox33.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["Box33"]);
                this.textPRODNM_CD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["PRODNM_CD"]);
                this.textORD_UDT_DTIME.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_UDT_DTIME"]);
                this.textWTH_TOL_ERMAX.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["WTH_TOL_ERMAX"]);
                this.textORD_WTH.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_WTH"]);
                this.textORD_ACT_DTIME.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_ACT_DTIME"]);
                this.textORD_PROG_CD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_PROG_CD"]);
                this.textORD_UDT_YN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_UDT_YN"]);
                this.textWTH_TOL_ERMIN.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["WTH_TOL_ERMIN"]);
                this.textORD_THK.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["ORD_THK"]);
                this.textCONTRACT_NO.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["CONTRACT_NO"]);
                this.textDDC_STL_GRD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["DDC_STL_GRD"]);
                this.textFAC_STL_GRD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["FAC_STL_GRD"]);
                this.textSPEC_STL_GRD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["SPEC_STL_GRD"]);
                this.textCUST_STL_GRD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["CUST_STL_GRD"]);
                this.textDEST_CD.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["DEST_CD"]);
                this.textBoxBUY_ABBSYM.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["BUY_ABBSYM"]); 
                this.textBoxPRODUCT_LX.Text = Common.FixDBManager.CheckNullStr(dt.Rows[0]["PRODUCT_LX"]); 
                

            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        private void textOrdNO_Leave(object sender, EventArgs e)
        {
            getOrdSeq();
        }

        private void ComboORD_SEQ_Leave(object sender, EventArgs e)
        {
            this.DoQuery();
        }
    }
}