XinYu_LZMES_Client/Core.LZMes.Client.UIE/UIE041/UIE041040.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;
using Infragistics.Win.UltraWinGrid;


namespace Core.LZMes.Client.UIE
{
    public partial class UIE041040 : FrmBase
    {
        public UIE041040()
        {
            InitializeComponent();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Export":
                    this.Export();
                    break;
            }
        }
        //public  void ultraGrid1_SortCompare(object sender, DataGridViewSortCompareEventArgs e)
        //{
        //    //   如果是学号或成绩列，则按浮点数处理
        //    if(e.Column.Name=="学号"|| e.Column.Name=="成绩")
        //    {
        //        e.SortResult = (Convert.ToDouble(e.CellValue1) - Convert.ToDouble(e.CellValue2) > 0) ? 1 : (Convert.ToDouble(e.CellValue1) - Convert.ToDouble(e.CellValue2) < 0)?-1:0;
        //    }
        //    //否则，按字符串比较
        //    else
        //    {
        //        e.SortResult = System.String.Compare(Convert.ToString(e.CellValue1), Convert.ToString(e.CellValue2));
        //    }
           
        //    // 如果发现两行相同，则按学号排序  
        //    if (e.SortResult == 0 && e.Column.Name != "连退生产量")
        //    {
        //        e.SortResult = Convert.ToInt32(ultraGrid1.Rows[e.RowIndex1].Cells["连退生产量"].Value.ToString()) -
        //                Convert.ToInt32(ultraGrid1.Rows[e.RowIndex2].Cells["连退生产量"].Value.ToString());
        //    }
        //    e.Handled = true;//不能省掉，不然没效果
        //} 

        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.dateTimePlanFrom.Value = firstDate;
            //this.dateTimePlanTo.Value = lastDate;
            this.delToDateFrom.Value = firstDate;
            this.DelToDateTo.Value = lastDate;

            string commCodeCd = "B01004,E01001,A01001,E01003,A01020,A01004,A01012,E04002";
            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.ComboProductCD, ref dt, "A01004");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboOrdProc, ref dt, "E01001");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboOrdType, ref dt, "A01001");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboABNOR_ORD_CD, ref dt, "E01003");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboTransType, ref dt, "A01012");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ultraCombo1, ref dt, "E04002");

            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.ComboColdStlGrd, ref dt, "C_STL_GRD");

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

           // this.ultraGrid1.DisplayLayout.Override.SortComparisonType = HeaderClickAction.SortSingle; 
        }

        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 UIE042010_Load(object sender, EventArgs e)
        {
            init();
        }

        private void DoQuery()
        {
            

            try
            {
                this.dataSet1.Tables[0].Clear();
                ArrayList arrayParam = new ArrayList();
                arrayParam.Add("UIE041040.OrdPrc.Select");
                //合同号
                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);
                //产品名称
                string productNM = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboProductCD.Value));
                arrayParam.Add(productNM);
                //订单进度
                string ComboOrdProc = Convert.ToString(Convert.ToString(Common.FixDBManager.CheckNullStr(Common.FixDBManager.splitArray(this.ComboOrdProc.Value,','))));
                arrayParam.Add(ComboOrdProc);
                arrayParam.Add(ComboOrdProc);
                //异常订单类型
                string ComboABNOR_ORD_CD = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboABNOR_ORD_CD.Value));
                arrayParam.Add(ComboABNOR_ORD_CD);
                //客户名称
                string custNM = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textCustCD.Text));
                arrayParam.Add(custNM);
                //冷轧标准牌号
                string coldStlGrd = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboColdStlGrd.Value));
                arrayParam.Add(coldStlGrd);
                //热轧标准牌号
                string hotStlGrd = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboHotStlGrd.Value));
                arrayParam.Add(hotStlGrd);
                //交货期
                string delToDateFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.delToDateFrom.Value.ToString("yyyyMMdd")));
                arrayParam.Add(delToDateFrom);
                string delToDateTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.DelToDateTo.Value.ToString("yyyyMMdd")));
                arrayParam.Add(delToDateTo);
                //订货区分
                string ComboOrdType = Convert.ToString(Convert.ToString(Common.FixDBManager.CheckNullStr(Common.FixDBManager.splitArray(this.ComboOrdType.Value,','))));
                arrayParam.Add(ComboOrdType);
                arrayParam.Add(ComboOrdType);

                
                //订单预排期custNM

                //string planDateFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.dateTimePlanFrom.Value.ToString("yyyyMMdd")));
                //arrayParam.Add(planDateFrom);
                //string planDateTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.dateTimePlanTo.Value.ToString("yyyyMMdd")));
                //arrayParam.Add(planDateTo);
                //运输方式
                string transType = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboTransType.Value));
                arrayParam.Add(transType);
                //热轧订单宽度
                //string ordWthFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdWthFrom.Text));
                //arrayParam.Add(ordWthFrom);
                //string ordWthTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdWthTo.Text));
                //arrayParam.Add(ordWthTo);
                //热轧订单厚度
                //string ordThkFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdThkFrom.Text));
                //arrayParam.Add(ordThkFrom);
                //string ordThkTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdThkTo.Text));
                //arrayParam.Add(ordThkTo);
                //冷轧订单宽度
                //string coldOrdWthFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textColdOrdWthFrom.Text));
                //arrayParam.Add(coldOrdWthFrom);
                //string coldOrdWthTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textColdOrdWthTo.Text));
                //arrayParam.Add(coldOrdWthTo);
                //冷轧订单厚度
                //string coldOrdThkFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textColdOrdThkFrom.Text));
                //arrayParam.Add(coldOrdThkFrom);
                //string coldOrdThkTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textColdOrdThkTo.Text));
                //arrayParam.Add(coldOrdThkTo);
                //销售区域
                string saleArea = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textSaleArea.Text));
                arrayParam.Add(saleArea);

                string comboOrdprocLock = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraCombo1.Value));
                arrayParam.Add(comboOrdprocLock);
                //arrayParam.Add(ordNO);
                //arrayParam.Add(ordSeq);
                //arrayParam.Add(ordNO);
                //arrayParam.Add(ordSeq);
                //arrayParam.Add(ordNO);
                //arrayParam.Add(ordSeq);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ccp.ServerParams = new object[] { arrayParam };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

              //  ultraGrid1.DisplayLayout.Bands[0].Columns["ID"].SortComparer;

                //UltraGridBand band = this.ultraGrid1.DisplayLayout.Bands[2];
                //band.Override.AllowRowSummaries = AllowRowSummaries.BasedOnDataType;

                //SummarySettings maxSummary = band.Summaries.Add("", SummaryType.Sum, band.Columns["ORD_REM_WGT"]);

                //maxSummary.DisplayFormat = "Max = {0:####.00}";
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

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

        private void Export()
        {
            try
            {
                if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                {
                    string fileName = this.saveFileDialog1.FileName;
                    this.ultraGridExcelExporter1.Export(this.ultraGrid1,fileName);
                    System.Diagnostics.Process.Start(fileName);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }

        //订单整理
        private void ultraButton5_Click(object sender, EventArgs e)
        {
            string check = "";
            string ordNO = "";
            string ordSeq = "";
            string regID = this.UserInfo.GetUserID();
            string pgmID = "UIE041040";
            Hashtable paramHsmp;

            Infragistics.Win.UltraWinGrid.RowsCollection rs = this.ultraGrid1.Rows;
            if (rs.Count > 0)
            {
                for (int i = 0; i < rs.Count; i++)
                {
                    
                    paramHsmp = new Hashtable();
                    check = rs[i].Cells["CHK"].Text.Trim();
                    ordNO = rs[i].Cells["ORD_NO"].Text.Trim();
                    ordSeq = rs[i].Cells["ORD_SEQ"].Text.Trim();
                    
                    paramHsmp.Add("i1", ordNO);
                    paramHsmp.Add("i2", ordSeq);
                    paramHsmp.Add("i3", pgmID);
                    paramHsmp.Add("i4", regID);

                    if (ordNO == "" || ordSeq == "")
                    {
                        continue;
                    }
                    if (check == "")
                    {
                        continue;
                    }
                    try
                    {
                        if (check == "True")
                        {
                            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]);
                        }
                    }
                    catch (Exception EX)
                    {
                        MessageBox.Show(EX.ToString());
                    }
                }
                this.DoQuery();
            }
        }

        private void ugrd_RollPlan_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
        {
            try
            {
                if (this.ultraGrid1.ActiveRow != null)
                {
                    Core.LZMes.Client.UIB.UIB010301 frm = new Core.LZMes.Client.UIB.UIB010301();
                    frm.ob = this.ob;
                    frm.OrderNO = Common.FixDBManager.CheckNullStr(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Value);
                    frm.OrderSEQ = Common.FixDBManager.CheckNullStr(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Value); ;
                    frm.ShowDialog();
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }

        #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 clickColumnID = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveCell.Column.Key));
            if (!(clickColumnID.Equals("ORD_NO") || clickColumnID.Equals("ORD_SEQ") || clickColumnID.Equals("CUST_CD")))
            {
                return;
            }
            string clickNO = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveRow.Cells["ORD_NO"].Value));
            string clickSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveRow.Cells["ORD_SEQ"].Value));

            if (clickNO == null || clickNO == "") return;
            if (clickSeq == null || clickSeq == "") return;

            if (clickColumnID.Equals("ORD_NO"))
            {
                UIE041050 frm = new UIE041050();
                frm.ob = this.ob;
                frm.Condition = clickNO + "|" + clickSeq;
                frm.ShowDialog();
            }
            else if (clickColumnID.Equals("ORD_SEQ"))
            {
                UIE041080 frm = new UIE041080();
                frm.ob = this.ob;
                frm.Condition = clickNO + "|" + clickSeq;
                frm.ShowDialog();
            }
            else if (clickColumnID.Equals("CUST_CD"))
            {
                try
                {
                    if (this.ultraGrid1.ActiveRow != null)
                    {
                        Core.LZMes.Client.UIB.UIB010301 frm = new Core.LZMes.Client.UIB.UIB010301();
                        frm.ob = this.ob;
                        frm.OrderNO = Common.FixDBManager.CheckNullStr(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Value);
                        frm.OrderSEQ = Common.FixDBManager.CheckNullStr(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Value); ;
                        frm.ShowDialog();
                    }
                }
                catch (System.Exception ex)
                {
                    System.Diagnostics.Debug.WriteLine(ex.ToString());
                }
            }
            else
            {
                return;
            }
        }
        #endregion;

        private void ComboOrdProc_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
        {
            UltraGridColumn checkColumn = this.ComboOrdProc.DisplayLayout.Bands[0].Columns.Add("Selected");
            checkColumn.DataType = typeof(bool);

            // Show the checkbox column at the beginning
            checkColumn.Header.VisiblePosition = 0;

            //--
            this.ComboOrdProc.CheckedListSettings.EditorValueSource = Infragistics.Win.EditorWithComboValueSource.CheckedItems;

            // Hook this column up to the CheckedListSettings
            this.ComboOrdProc.CheckedListSettings.CheckStateMember = checkColumn.Key;

            // Ensure that the ValueMember is set to our other field
            this.ComboOrdProc.ValueMember = "LABEL";
        }

        private void ComboOrdType_InitializeLayout_1(object sender, InitializeLayoutEventArgs e)
        {
            UltraGridColumn checkColumn = this.ComboOrdType.DisplayLayout.Bands[0].Columns.Add("Selected");
            checkColumn.DataType = typeof(bool);

            // Show the checkbox column at the beginning
            checkColumn.Header.VisiblePosition = 0;

            //--
            this.ComboOrdType.CheckedListSettings.EditorValueSource = Infragistics.Win.EditorWithComboValueSource.CheckedItems;

            // Hook this column up to the CheckedListSettings
            this.ComboOrdType.CheckedListSettings.CheckStateMember = checkColumn.Key;

            // Ensure that the ValueMember is set to our other field
            this.ComboOrdType.ValueMember = "LABEL";
        }
        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    ugr.Cells["CHK"].Value = this.checkBox1.Checked;
                    ugr.Update();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        private void ultraGrid1_BeforeCellActivate(object sender, CancelableCellEventArgs e)
        {

        }
    }
}