XinYu_LZMES_Client/.svn/pristine/98/98ead44ac9a1eb20772a52cc047f354b4a636ba1.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 UIE043020 : FrmBase
    {
        string ordNO;
        string ordSeq;
        string matType;

        public UIE043020()
        {
            InitializeComponent();
        }
        #region "ToolBar Event"

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Confirm":
                    this.find();
                    break;
                case "Save":
                    this.Save();
                    this.DoQuery();
                    break;
            }
        }
        
        private void DoQuery()
        {
            try
            {

                string ordNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdNO.Text));
                string ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombOrdSeq.Value));
                string stlGrd = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombStlGrd.Value));
                string prodType = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombProdType.Value));
                string custCD = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombCustID.Value));
                string ordUseCD = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombUseCD.Value));
                string ordType = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombOrdType.Value));
                string abbsym = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombSpecAbbsym.Value));
                string shapeGrd = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombShapGrd.Value));
                string delToDateFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.DelToDateFrom.DateTime.ToString("yyyyMMdd")));
                string delToDataTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.DelToDateTo.DateTime.ToString("yyyyMMdd")));
                string ordThkFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdThkFrom.Text));
                string ordThkTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdThkTo.Text));
                string ordWgtFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdWgtFrom.Text));
                string ordWgtTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdWgtTo.Text));
                string ordWthFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdWthFrom.Text));
                string ordWthTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdWthTo.Text));


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

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ArrayList paramArray = new ArrayList();
                paramArray.Add("UIE043020_ORD.select");
                paramArray.Add(prodType);
                paramArray.Add(custCD);
                paramArray.Add(stlGrd);
                paramArray.Add(ordNO);
                paramArray.Add(ordSeq);
                paramArray.Add(ordType);
                paramArray.Add(delToDateFrom);
                paramArray.Add(delToDataTo);
                paramArray.Add(ordUseCD);
                paramArray.Add(abbsym);
                paramArray.Add(ordThkFrom);
                paramArray.Add(ordThkTo);
                paramArray.Add(ordWthFrom);
                paramArray.Add(ordWthTo);
                paramArray.Add(ordWgtFrom);
                paramArray.Add(ordWgtTo);

                ccp.ServerParams = new object[] { paramArray };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                System.Diagnostics.Debug.WriteLine(this.dataSet1.Tables[0].ToString());
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        public void find()
        {
            try
            {
                this.dataSet2.Tables[1].Clear();
                this.dataSet2.Tables[0].Clear();

                if(matType == null || "".Equals(matType)){
                    return;
                }else if(matType.Equals("PLTCM01")){
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ArrayList paramArray = new ArrayList();
                    paramArray.Add("UIE043020.HOTCoilComm.Select");
                    paramArray.Add(ordNO);
                    paramArray.Add(ordSeq);
                    ccp.ServerParams = new object[] { paramArray };
                    ccp.SourceDataTable = this.dataSet2.Tables[0];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                    ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    paramArray = new ArrayList();
                    paramArray.Add("UIE043020.HOTCoilComm_D.Select");
                    paramArray.Add(ordNO);
                    paramArray.Add(ordSeq);
                    ccp.ServerParams = new object[] { paramArray };
                    ccp.SourceDataTable = this.dataSet2.Tables[1];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                }
                else if (matType.Equals("PLTCM04"))//酸洗原料
                {
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ArrayList paramArray = new ArrayList();
                    paramArray.Add("UIE043020.SXHOTCoilComm.Select");
                    paramArray.Add(ordNO);
                    paramArray.Add(ordSeq);
                    ccp.ServerParams = new object[] { paramArray };
                    ccp.SourceDataTable = this.dataSet2.Tables[0];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                    ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    paramArray = new ArrayList();
                    paramArray.Add("UIE043020.HOTCoilComm_D.Select");
                    paramArray.Add(ordNO);
                    paramArray.Add(ordSeq);
                    ccp.ServerParams = new object[] { paramArray };
                    ccp.SourceDataTable = this.dataSet2.Tables[1];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                }
                else if (matType.Equals("PLTCM02"))
                {
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ArrayList paramArray = new ArrayList();
                    paramArray.Add("UIE043020.COLDCoilComm.Select");
                    paramArray.Add(ordNO);
                    paramArray.Add(ordSeq);
                    ccp.ServerParams = new object[] { paramArray };
                    ccp.SourceDataTable = this.dataSet2.Tables[0];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                    ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    paramArray = new ArrayList();
                    paramArray.Add("UIE043020.COLDCoilComm_D.Select");
                    paramArray.Add(ordNO);
                    paramArray.Add(ordSeq);
                    ccp.ServerParams = new object[] { paramArray };
                    ccp.SourceDataTable = this.dataSet2.Tables[1];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                }
                else if (matType.Equals("PLTCM03"))//酸洗成品
                {
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ArrayList paramArray = new ArrayList();
                    paramArray.Add("UIE043020.SuanxiCoilComm.Select");
                    paramArray.Add(ordNO);
                    paramArray.Add(ordSeq);
                    ccp.ServerParams = new object[] { paramArray };
                    ccp.SourceDataTable = this.dataSet2.Tables[0];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                    ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    paramArray = new ArrayList();
                    paramArray.Add("UIE043020.COLDCoilComm_D.Select");
                    paramArray.Add(ordNO);
                    paramArray.Add(ordSeq);
                    ccp.ServerParams = new object[] { paramArray };
                    ccp.SourceDataTable = this.dataSet2.Tables[1];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                }
                else if (matType.Equals("CAL01"))
                {
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ArrayList paramArray = new ArrayList();
                    paramArray.Add("UIE043020.CALCoilComm.Select");
                    paramArray.Add(ordNO);
                    paramArray.Add(ordSeq);
                    ccp.ServerParams = new object[] { paramArray };
                    ccp.SourceDataTable = this.dataSet2.Tables[0];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

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

        public void Save()
        {
            try
            {
                Hashtable paramHsmp = new Hashtable();
                StringBuilder strBf = new StringBuilder();

                this.ultraGrid2.UpdateData();
                DataRow[] selectedRows = dataSet2.Tables[0].Select("CHK ='True'");
                //this.ultraGrid2.ActiveRow.Cells["CHK"].Text == "True"
                string msg = "";
                string retCD = "";
                for (int i = 0; i < selectedRows.Length; i++)
                {
                    strBf.Append(selectedRows[i]["MAT_NO"]).Append("|");
                }

                string noOrderCD = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboNoOrderCD.Value));
                string repKind = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboMatType.Value));
                //操作人
                paramHsmp.Add("i1", this.UserInfo.GetUserID());
                //操作程序
                paramHsmp.Add("i2", "UIE043020");
                paramHsmp.Add("i3", noOrderCD);
                paramHsmp.Add("i4", strBf.ToString());
                paramHsmp.Add("i5", repKind);
                paramHsmp.Add("o6", retCD);
                paramHsmp.Add("o7", msg);


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

                //paramHsmp.Add("i1", this.UserInfo.GetUserID());
                ////操作程序
                //paramHsmp.Add("i2", "UIE043010");
                //paramHsmp.Add("i3", ordNO1);
                //paramHsmp.Add("i4", ordNO2);
                //paramHsmp.Add("i5", ordNO3);
                //paramHsmp.Add("i6", ordSeq1);
                //paramHsmp.Add("i7", ordSeq2);
                //paramHsmp.Add("i8", ordSeq3);
                //paramHsmp.Add("i9", primaryOrdNO);
                //paramHsmp.Add("i10", primaryOrdSeq);
                //paramHsmp.Add("i11", strBf.ToString());
                //paramHsmp.Add("o12", retCD);
                //paramHsmp.Add("o13", msg);
                //CoreClientParam ccp = new CoreClientParam();
                //ccp.ServerName = "UIB.COM.ComDBProcedure";
                //ccp.MethodName = "doXmlProcedure";
                //ccp.ServerParams = new Object[] { "UIE043010_ORD_REP.call", paramHsmp };
                //this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                //System.Diagnostics.Debug.WriteLine(this.dataSet1.Tables[0]);
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }

        }
        
        #endregion

        #region "Init"

        public void init()
        {
            string tt = System.DateTime.Today.Year.ToString() + "-" + System.DateTime.Today.Month.ToString() + "-" + "01 00:00:00";
            string tb = System.DateTime.Today.Year.ToString() + "-" + System.DateTime.Today.Month.ToString() + "-" + "28 00:00:00";
            System.DateTime firstDate = Convert.ToDateTime(tt);
            System.DateTime lastDate = Convert.ToDateTime(tb);
            this.DelToDateFrom.Value = firstDate;
            this.DelToDateTo.Value = lastDate;

            string commCodeCd = "A01007,A01004,A01001,B01016,E01010,E01014";
            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.CombUseCD, ref dt, "A01007");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.CombProdType, ref dt, "A01004");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.CombOrdType, ref dt, "A01001");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.CombShapGrd, ref dt, "B01016");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboNoOrderCD, ref dt, "E01010");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboMatType, ref dt, "E01014");
            ComboMatType.Value = "PLTCM01";

            dt = new DataTable();
            ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBQuery";
            ccp.MethodName = "doSimpleQuery";
            paramArray = new ArrayList();
            paramArray.Add("UIECOMM00_SELECT.C_STL_GRD");
            ccp.ServerParams = new object[] { paramArray };
            ccp.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.CombStlGrd, ref dt, "C_STL_GRD");
        }

        private void UIE043020_Load(object sender, EventArgs e)
        {
            init();
        }

        #endregion

        #region "Event"

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            ordNO = Convert.ToString(Common.FixDBManager.CheckNullStr(ultraGrid1.ActiveRow.Cells["ORD_NO"].Text));
            ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text));
            matType = Convert.ToString(Common.FixDBManager.CheckNullStr(ComboMatType.Value));
            find();
        }

        #endregion
    }
}