XinYu_LZMES_Client/.svn/pristine/9b/9ba313b188f780149ec55efb1545b3ec32b5487b.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 UIE041050 : FrmBase
    {
        public UIE041050()
        {
            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.comboOrdSeq.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.comboOrdSeq, ref dt, "ORD_SEQ");
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        private void DoQuery()
        {
            System.Collections.ArrayList arrayParam = new System.Collections.ArrayList();
            //合同号
            string ordNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdNO.Text));
            arrayParam.Add(ordNO);
            //订单号
            string ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.comboOrdSeq.Value));
            arrayParam.Add(ordSeq);

            if (ordNO == "" || ordSeq == "")
            {
                System.Windows.Forms.MessageBox.Show("订单号或则订单序号不能为空!");
                return;
            }
            
            try
            {

                CoreClientParam ccp = new CoreClientParam();

                DataTable dttb = new DataTable();
                //ccp.ServerName = "UIE.UIE01.UIE042020";
                //ccp.MethodName = "query01";
                //ccp.ServerParams = arrayParam.ToArray();
                //ccp.SourceDataTable = dttb;
                //this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ArrayList paramArray = new ArrayList();
                paramArray.Add("UIE041050.OrdPrc.Select");
                paramArray.Add(ordNO);
                paramArray.Add(ordSeq);
                ccp.ServerParams = new object[] { paramArray };
                ccp.SourceDataTable = dttb;
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                string ORD_PROG_CD = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["ORD_PROG_CD"]));
                string PRODNM_CD = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PRODNM_CD"]));
                string CUST_CD = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["CUST_CD"]));
                string RCVORD_CLF = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["RCVORD_CLF"]));
                string DEL_TO_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["DEL_TO_DATE"]));
                string ABNOR_ORD_CD = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["ABNOR_ORD_CD"]));
                string SMS_DUE_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["SMS_DUE_DATE"]));
                string MILL_DUE_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["MILL_DUE_DATE"]));
                string PLTCM_DUE_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PLTCM_DUE_DATE"]));
                string CAL_DUE_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["CAL_DUE_DATE"]));
                string PROD_HOLD_CD = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PROD_HOLD_CD"]));
                string PROD_HOLD_DTIME = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PROD_HOLD_DTIME"]));
                string PROD_END_GP = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PROD_END_GP"]));
                string PROD_END_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PROD_END_DATE"]));
                string SHIP_END_DATE = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["SHIP_END_DATE"]));
                string ORD_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["ORD_WGT"]));
                string DESIGN_SLAB_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["DESIGN_SLAB_WGT"]));
                string ORD_PRC_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["ORD_PRC_WGT"]));
                string ORD_REM_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["ORD_REM_WGT"]));
                string PROD_END_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["PROD_END_WGT"]));
                string SHIP_END_WGT = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["SHIP_END_WGT"]));

                this.text_ORD_PROG_CD.Text = ORD_PROG_CD;
                this.text_PRODNM_CD.Text = PRODNM_CD;
                this.text_CUST_CD.Text = CUST_CD;
                this.text_RCVORD_CLF.Text = RCVORD_CLF;
                this.text_DEL_TO_DATE.Text = DEL_TO_DATE;
                this.text_ABNOR_ORD_CD.Text = ABNOR_ORD_CD;
                this.text_SMS_DUE_DATE.Text = SMS_DUE_DATE;
                this.text_MILL_DUE_DATE.Text = MILL_DUE_DATE;
                this.text_PLTCM_DUE_DATE.Text = PLTCM_DUE_DATE;
                this.text_CAL_DUE_DATE.Text = CAL_DUE_DATE;
                this.text_PROD_HOLD_CD.Text = PROD_HOLD_CD;
                this.text_PROD_HOLD_DTIME.Text = PROD_HOLD_DTIME;
                this.text_PROD_END_GP.Text = PROD_END_GP;
                this.text_PROD_END_DATE.Text = PROD_END_DATE;
                this.text_SHIP_END_DATE.Text = SHIP_END_DATE;
                this.text_ORD_WGT.Text = ORD_WGT;
                this.text_ORD_PRC_WGT.Text = ORD_PRC_WGT;
                this.text_ORD_REM_WGT.Text = ORD_REM_WGT;
                this.text_PROD_END_WGT.Text = PROD_END_WGT;
                this.text_SHIP_END_WGT.Text = SHIP_END_WGT;


                this.dataSet1.Tables[0].Clear();

                ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                paramArray = new ArrayList();
                paramArray.Add("UIE041050.OrdPrcDet.Select");
                paramArray.Add(ordNO);
                paramArray.Add(ordSeq);
                ccp.ServerParams = new object[] { paramArray };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        //订单整理
        private void ultraButton5_Click(object sender, EventArgs e)
        {
            string ordNO    = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdNO.Text));
            string ordSeq   = Convert.ToString(Common.FixDBManager.CheckNullStr(this.comboOrdSeq.Value));
            string regID    = this.UserInfo.GetUserID();
            string pgmID    = "UIE041050";

            Hashtable paramHsmp = new Hashtable();

            paramHsmp.Add("i1", ordNO);
            paramHsmp.Add("i2", ordSeq);
            paramHsmp.Add("i3", pgmID);
            paramHsmp.Add("i4", regID);

            if (ordNO == "" || ordSeq == "")
            {
                System.Windows.Forms.MessageBox.Show("订单号或则订单序号不能为空!");
                return;
            }

            try
            {
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBProcedure";
                ccp.MethodName = "doXmlProcedure";
                ccp.ServerParams = new Object[] { "UIE041050_OSREARRANGE.call", paramHsmp };
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                System.Diagnostics.Debug.WriteLine(this.dataSet1.Tables[0]);

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

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

        #region
        /// <summary>
        /// 点击进程量，弹出物料详细信息界面，获取详细的物料进程信息
        /// </summary>
        /// <param name="sender">控件</param>
        /// <param name="e"></param>
        private void ultraGrid1_AfterCellActivate(object sender, EventArgs e)
        {
            Infragistics.Win.UltraWinGrid.UltraGrid tt = (Infragistics.Win.UltraWinGrid.UltraGrid)sender;
            string procCD = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveRow.Cells["PROC_CD"].Value));
            string procWgt = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveCell.Value));
            string clickNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdNO.Text));
            string clickColumnID = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveCell.Column.Key));
            string clickColumnWGT = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveCell.Value));
            string clickSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.comboOrdSeq.Value));

            //指示待机
            if (clickColumnID.Equals("INS_WGT"))
            {
                procCD = procCD + "A";
            }//作业待机
            else if (clickColumnID.Equals("WRK_WGT"))
            {
                procCD = procCD + "B";
            }//判定待机
            else if (clickColumnID.Equals("EST_WGT"))
            {
                procCD = procCD + "D";
            }//作业完成
            else if (clickColumnID.Equals("END_WGT"))
            {
                procCD = procCD + "F";
            }
            else
            {
                return;
            }
            if (clickColumnWGT == null || clickColumnWGT == "" || clickColumnWGT == "0") return;
            if (clickNO == null || clickNO == "") return;
            if (clickSeq == null || clickSeq == "") return;
            if (procCD == null || procCD == "") return;
            if (procWgt == null || procCD == "") return;

            UIE041070 frm = new UIE041070();
            frm.ob = this.ob;
            frm.Condition = clickNO + "|" + clickSeq + "|" + procCD;
            frm.ShowDialog();
        }
        #endregion;

        //订单详细信息查询
        private void ultraButton4_Click(object sender, EventArgs e)
        {

        }
        //生产结束指定
        private void ultraButton3_Click(object sender, EventArgs e)
        {

        }
        //生产保留指定
        private void ultraButton1_Click(object sender, EventArgs e)
        {

        }
        //紧急订单指定
        private void ultraButton2_Click(object sender, EventArgs e)
        {

        }
    }
}