MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/ZGCheck/frmZgGxCheck.cs

using Core.Mes.Client.Comm.Server;
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 Core.Mes.Client.Comm.Tool;
using System.Reflection;
using Infragistics.Win.UltraWinGrid;
using Core.StlMes.Client.PlnSaleOrd.PlanStove.entity;
using Core.StlMes.Client.PlnSaleOrd.PlanStove;
using Core.StlMes.Client.PlnSaleOrd.工序排产;

namespace Core.StlMes.Client.PlnSaleOrd.ZGCheck
{
    public partial class frmZgGxCheck :FrmBase
    {

        private bool isLoad = true;

        public frmZgGxCheck()
        {
            InitializeComponent();
        }
        private void frmZgGxCheck_Load(object sender, EventArgs e)
        {
            CommHelper.InsertColumn("Count", "工序订单条数", this.ultraGrid1.DisplayLayout.Bands[0], 5);
            init_Grid1();
            EntityHelper.ShowGridCaption<PlnOrderZgSEntity>(this.ultraGrid2.DisplayLayout.Bands[0]);
            this.ultraGrid1.AfterRowActivate += ultraGrid1_AfterRowActivate;
            
            CommHelper.SetColumsHide(this.ultraGrid2.DisplayLayout.Bands[0], new List<string>() { "Mstatus", "Mcount" });
            init_Grid2();
            PlanHelper.InitDropPline("D", "", this.DDL_2_PLINE, this.ob);
            this.DATE_2_CREATETIME.DateTime = DateTime.Now.AddMonths(-1);
        }

        private void init_Grid2()
        {
            #region Excel2Code 2016/7/7 15:53:22
            setColumnPosition1("PlineCode", 0);
            setColumnPosition1("GxProSeq", 1);
            setColumnPosition1("ProPlanId", 3);
            setColumnPosition1("GxPlanNo", 4);
            setColumnPosition1("RepairType", 5);
            setColumnPosition1("Mcount", 6);
            setColumnPosition1("Mstatus", 7);
            setColumnPosition1("IsRepairPln", 8);
            setColumnPosition1("ExeStatus", 9);
            setColumnPosition1("NumS", 10);
            setColumnPosition1("WeigthS", 11);
            setColumnPosition1("PlanUsetime", 12);
            setColumnPosition1("PlanTimeB", 13);
            setColumnPosition1("PlanTimeE", 14);
            setColumnPosition1("InwlDesc", 15);
            setColumnPosition1("OutwlDesc", 16);
            setColumnPosition1("OrderSource", 17);
            setColumnPosition1("OrderNo", 18);
            setColumnPosition1("OrderSeq", 19);
            setColumnPosition1("DeliveryNo", 20);
            setColumnPosition1("Steelname", 21);
            setColumnPosition1("Gradename", 22);
            setColumnPosition1("Outdiameter", 23);
            setColumnPosition1("Wallthick", 24);
            setColumnPosition1("Aimwallthick", 25);
            setColumnPosition1("Aimlength", 26);
            setColumnPosition1("RollLength", 27);
            setColumnPosition1("DiameterMandrel", 28);
            setColumnPosition1("DiameterGp", 29);
            setColumnPosition1("Lengthdisc", 30);
            setColumnPosition1("LenRollMax", 31);
            setColumnPosition1("LenRollMin", 32);
            setColumnPosition1("Aimoutdiameter", 33);
            setColumnPosition1("LenGpSingle", 34);
            setColumnPosition1("Isendgx", 35);
            setColumnPosition1("IfMonitorZg", 36);
            setColumnPosition1("LenCuthead", 37);
            setColumnPosition1("LenCutend", 38);
            setColumnPosition1("OutnumCut", 39);
            setColumnPosition1("PrdcrNo", 40);
            setColumnPosition1("CraftFileNo", 41);
            setColumnPosition1("MonitorPoint", 42);
            setColumnPosition1("CraftSeq", 43);
            setColumnPosition1("PassName", 44);
            setColumnPosition1("CraftFileMan", 45);
            setColumnPosition1("ReqBlId", 46);
            setColumnPosition1("InNumS", 47);
            setColumnPosition1("InWeightS", 48);
            setColumnPosition1("PlanGroupId", 49);
            setColumnPosition1("ProMonth", 50);
            setColumnPosition1("AddWtIn", 51);
            setColumnPosition1("AddNumIn", 52);
            setColumnPosition1("MatchWtIn", 53);
            setColumnPosition1("StationRoad", 54);
            setColumnPosition1("BatchedNum", 55);
            setColumnPosition1("Finishweight", 56);
            setColumnPosition1("Finishnum", 57);
            setColumnPosition1("IsPlanOk", 58);
            setColumnPosition1("GpreqIfOk", 59);
            setColumnPosition1("GpreqId", 60);
            setColumnPosition1("ZyBatchId", 61);
            setColumnPosition1("PlnDivideId", 62);
            setColumnPosition1("Cic", 63);
            setColumnPosition1("Pic", 64);
            setColumnPosition1("Sic", 65);
            setColumnPosition1("Dic", 66);
            setColumnPosition1("Wic", 67);
            setColumnPosition1("Gic", 68);
            #endregion
        }

        private void setColumnPosition1(string key,int position)
        {
            CommHelper.SetColumnPosition(this.ultraGrid2.DisplayLayout.Bands[0], key, position);
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Export":
                    PlanComm.Export(ref this.ultraGrid1, DateTime.Now.ToString("yyyyMMdd"));
                    break;
                case "Close":
                    this.Close();
                    break;
                case "Query":
                    querySqlServer();
                    break;
            }
        }

        void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            this.ultraGrid1.UpdateData();
            string OrderNo = "";
            string OrderSeq = "";
            string srcOrder = this.ultraGrid1.ActiveRow.Cells["Orderno"].Text;
            string[] szSrcOrder = srcOrder.Split('/');
            if (szSrcOrder.Length > 1)
            {
                OrderNo = szSrcOrder[0];
                OrderSeq = szSrcOrder[1];
                var datasource = EntityHelper.GetData<PlnOrderZgSEntity>("com.steering.pss.plnsaleord.zgcheck.ZgGxCheck.queryZgOrderbyOrderNo", new Object[] { OrderNo, OrderSeq }, this.ob);
                this.plnOrderZgSEntityBindingSource.Clear();
                this.plnOrderZgSEntityBindingSource.DataSource = datasource;
            }
            //throw new NotImplementedException();
        }

        private void querySqlServer()
        {
            string PLINE = CB_2_PLINE.Checked ? (string.IsNullOrEmpty(this.DDL_2_PLINE.Text) ? "" : this.DDL_2_PLINE.Text) : "";
            string ORDERNO = CB_2_ORDERNO.Checked ? this.TB_2_ORDERNO.Text : "";
            string CreateTimeFrom = CB_2_CREATETIME.Checked ? this.DATE_2_CREATETIME.DateTime.ToString() : "";
            string CreateTimeTo = CB_2_CREATETIME.Checked ? this.DATE_2_CREATETIME_END.DateTime.ToString() : "";
            this.Cursor = Cursors.WaitCursor;
            var datasource = EntityHelper.GetData<V_ZG_PCORDERS_CXEntity>("com.steering.pss.plnsaleord.zgcheck.ZgGxCheck.getDataFromView", new Object[] { PLINE, CreateTimeFrom, CreateTimeTo, ORDERNO }, this.ob);
            this.ultraGrid1.DataSource = datasource;

            DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.zgcheck.ZgGxCheck.queryZgOrderbyOrderNo", new Object[] {"","" }, this.ob);
            foreach(var row in this.ultraGrid1.Rows)
            {
                string OrderNo = "";
                string OrderSeq = "";
                string srcOrder = row.Cells["Orderno"].Text;
                string[] szSrcOrder = srcOrder.Split('/');
                if (szSrcOrder.Length > 1)
                {
                    OrderNo = szSrcOrder[0];
                    OrderSeq = szSrcOrder[1];
                    var rows = dt.Select(string.Format("ORDER_NO='{0}' and ORDER_SEQ='{1}'",OrderNo,OrderSeq));
                    if (rows.Length > 0)
                    {
                        row.Cells["Count"].Value = rows.Length;
                    }
                    else
                    {
                        row.Cells["Count"].Value = 0;
                    }
                }
                else
                {
                    row.Cells["Count"].Value = 0;
                }
            }
            if (isLoad)
            {
                CommHelper.SetColumnAutoFitSize1(this.ultraGrid1.DisplayLayout.Bands[0]);
                isLoad = false;
            }
            this.Cursor = Cursors.Default;
        }

        private void init_Grid1()
        {
            #region Excel2Code 2016/7/7 11:21:45
            setColumnCation("Id", "ID");
            setColumnCation("OPDATE", "操作日期");
            setColumnCation("CX", "产线");
            setColumnCation("KONGXING", "孔型");
            setColumnCation("LGNO", "炼钢批次");
            setColumnCation("ZHANO", "轧次");
            setColumnCation("PLANMONTH", " 计划年月");
            setColumnCation("ORDERNO", "合同号");
            setColumnCation("JZ", "监制要求");
            setColumnCation("CUSTOMER", "客户名称");
            setColumnCation("KIND", "品种");
            setColumnCation("STEELLEVEL", "钢级");
            setColumnCation("WAIJING", "外径");
            setColumnCation("BIHOU", "壁厚");
            setColumnCation("KOUXING", "扣型");
            setColumnCation("LENGTHMIN", "长度下限");
            setColumnCation("LENGTHMAX", "长度上限");
            setColumnCation("LENGTHFIX", "长度修正");
            setColumnCation("LENGTHCP", "成品长度");
            setColumnCation("TARGET", "去向A B");
            setColumnCation("GYSTATUS", "工艺状态");
            setColumnCation("CPUNIT", "成品计划支");
            setColumnCation("CPWEIGHT", "成品计划吨");
            setColumnCation("LENGTHTO", "目标长度");
            setColumnCation("FQ", "分切");
            setColumnCation("QIET", "切头");
            setColumnCation("QIEW", "切尾");
            setColumnCation("ZHAPINO", "轧批号");
            setColumnCation("BMLENGTH", "保米长");
            setColumnCation("DBCLENGTH", "单倍尺长(管子)");
            setColumnCation("DCSL", "短尺随炉");
            setColumnCation("ORDERTYPE", "合同分类");
            setColumnCation("KZBIHOU", "控制壁厚");
            setColumnCation("KZBIHOUSTANDARD", "理论控制壁厚");
            setColumnCation("ZHALENGTH", "轧制长度");
            setColumnCation("DM", "断面");
            setColumnCation("DBPC", "单倍坯长");
            setColumnCation("BC", "倍尺");
            setColumnCation("ZGRELEASE", "轧管释放");
            setColumnCation("GYSHSTATUS", "工艺审核状态");
            setColumnCation("STEELGRADES", "钢种选择");
            setColumnCation("PIKIND", "管坯类别");
            setColumnCation("ZGSTANDARD", "轧管工序标准");
            setColumnCation("LGSTANDARD", "炼钢标准");
            setColumnCation("JIAGSTANDARD", "加工标准");
            setColumnCation("GYNO", "工艺号");
            setColumnCation("DUANCDESC", "短尺控制");
            setColumnCation("DUANCMIN", "短尺最短");
            setColumnCation("MINWEIGHT", "最低量t");
            setColumnCation("PLANWEIGHT", "计划量t");
            setColumnCation("PISOURCE", "料源");
            setColumnCation("LKWEIGHT", "利库重(坯)");
            setColumnCation("LKUNIT", "利库支(坯)");
            setColumnCation("STEELGRADE", "冶炼钢种");
            setColumnCation("JIATPIUNIT", "加投坯");
            setColumnCation("PLANPIUNIT", "计划(坯)支数");
            setColumnCation("PLANPIWEIGHT", "计划(坯)吨数");
            setColumnCation("ORDERSTATUS", "合同状态");
            setColumnCation("SCNO", "生产序号");
            setColumnCation("UNITH", "小时能力");
            setColumnCation("ZGUPLOADTYPE", "上传分类");
            setColumnCation("ORDERFJTK", "合同附加条款");
            setColumnCation("REMARK", "轧管计划员备注");
            setColumnCation("XBDIAMETER", "芯棒直径");
            setColumnCation("CPSTANDARD", "成品标准");
            setColumnCation("CPGC", "成品公差");
            setColumnCation("ZLWEIGHT", "装炉吨");
            setColumnCation("ZLWEIGHTFIX", "装炉吨修约");
            setColumnCation("GID", "上传批次值");
            setColumnCation("BLTYPE", "补量类型");
            #endregion

            #region Excel2Code 2016/7/7 14:59:51
            #region Excel2Code 2016/7/7 16:03:35
            setColumnPosition("Id", 0);
            setColumnPosition("OPDATE", 1);
            setColumnPosition("CX", 2);
            setColumnPosition("KONGXING", 3);
            setColumnPosition("ORDERNO", 4);
            setColumnPosition("ORDERTYPE", 6);
            setColumnPosition("BLTYPE", 7);
            setColumnPosition("ORDERSTATUS", 8);
            setColumnPosition("LGNO", 9);
            setColumnPosition("ZHANO", 10);
            setColumnPosition("PLANMONTH", 11);
            setColumnPosition("JZ", 12);
            setColumnPosition("CUSTOMER", 13);
            setColumnPosition("KIND", 14);
            setColumnPosition("STEELLEVEL", 15);
            setColumnPosition("WAIJING", 16);
            setColumnPosition("BIHOU", 17);
            setColumnPosition("KOUXING", 18);
            setColumnPosition("LENGTHMIN", 19);
            setColumnPosition("LENGTHMAX", 20);
            setColumnPosition("LENGTHFIX", 21);
            setColumnPosition("LENGTHCP", 22);
            setColumnPosition("TARGET", 23);
            setColumnPosition("GYSTATUS", 24);
            setColumnPosition("CPUNIT", 25);
            setColumnPosition("CPWEIGHT", 26);
            setColumnPosition("LENGTHTO", 27);
            setColumnPosition("FQ", 28);
            setColumnPosition("QIET", 29);
            setColumnPosition("QIEW", 30);
            setColumnPosition("ZHAPINO", 31);
            setColumnPosition("BMLENGTH", 32);
            setColumnPosition("DBCLENGTH", 33);
            setColumnPosition("DCSL", 34);
            setColumnPosition("KZBIHOU", 35);
            setColumnPosition("KZBIHOUSTANDARD", 36);
            setColumnPosition("ZHALENGTH", 37);
            setColumnPosition("DM", 38);
            setColumnPosition("DBPC", 39);
            setColumnPosition("BC", 40);
            setColumnPosition("ZGRELEASE", 41);
            setColumnPosition("GYSHSTATUS", 42);
            setColumnPosition("STEELGRADES", 43);
            setColumnPosition("PIKIND", 44);
            setColumnPosition("ZGSTANDARD", 45);
            setColumnPosition("LGSTANDARD", 46);
            setColumnPosition("JIAGSTANDARD", 47);
            setColumnPosition("GYNO", 48);
            setColumnPosition("DUANCDESC", 49);
            setColumnPosition("DUANCMIN", 50);
            setColumnPosition("MINWEIGHT", 51);
            setColumnPosition("PLANWEIGHT", 52);
            setColumnPosition("PISOURCE", 53);
            setColumnPosition("LKWEIGHT", 54);
            setColumnPosition("LKUNIT", 55);
            setColumnPosition("STEELGRADE", 56);
            setColumnPosition("JIATPIUNIT", 57);
            setColumnPosition("PLANPIUNIT", 58);
            setColumnPosition("PLANPIWEIGHT", 59);
            setColumnPosition("SCNO", 60);
            setColumnPosition("UNITH", 61);
            setColumnPosition("ZGUPLOADTYPE", 62);
            setColumnPosition("ORDERFJTK", 63);
            setColumnPosition("REMARK", 64);
            setColumnPosition("XBDIAMETER", 65);
            setColumnPosition("CPSTANDARD", 66);
            setColumnPosition("CPGC", 67);
            setColumnPosition("ZLWEIGHT", 68);
            setColumnPosition("ZLWEIGHTFIX", 69);
            setColumnPosition("GID", 70);
            #endregion

            #endregion

            //PlanComm.SetGridColNoEdit(this.ultraGrid1.DisplayLayout.Bands[0],new string[]{});

            PlanComm.SetGridColNoEdit(this.ultraGrid2.DisplayLayout.Bands[0],new string[]{});
        }

        private void setColumnPosition(string p1,int p2)
        {
            SetColumnPosition(this.ultraGrid1.DisplayLayout.Bands[0], p1, p2);
        }

        private void setColumnCation(string key,string caption)
        {
            GetFormatColumnName(ref  key);       
            try
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns[key].Header.Caption = caption;
            }
            catch
            {
            }
        }

        private void SetColumnPosition(Infragistics.Win.UltraWinGrid.UltraGridBand band, string key, int index)
        {
            GetFormatColumnName(ref  key);

            if (band.Columns.Exists(key) && band.Columns.Count > index)
            {
                band.Columns[key].Swap(GetSpecPositionCol(band, index));
                //band.Columns[key].Swap(band.Columns[index]);
            }
        }

        public static UltraGridColumn GetSpecPositionCol(UltraGridBand band, int position)
        {
            foreach (UltraGridColumn col in band.Columns)
            {
                if (col.Header.VisiblePosition == position)
                {
                    return col;
                }
            }
            return null;
        }

        private void GetFormatColumnName(ref string key)
        {
            key = key.ToLower();
            key = key.First().ToString().ToUpper()+key.Substring(1,key.Length-1);
        }

     
        private void CB_2_ORDERNO_CheckedChanged_1(object sender, EventArgs e)
        {
            if (CB_2_ORDERNO.Checked)
            {
                this.TB_2_ORDERNO.Enabled = true;
            }
            else
            {
                this.TB_2_ORDERNO.Enabled = false;
            }
        }

        private void CB_2_PLINE_CheckedChanged_1(object sender, EventArgs e)
        {
            if (CB_2_PLINE.Checked)
            {
                this.DDL_2_PLINE.Enabled = true;
            }
            else
            {
                this.DDL_2_PLINE.Enabled = false;
            }
            querySqlServer();
        }

        private void DDL_2_PLINE_ValueChanged(object sender, EventArgs e)
        {
            querySqlServer();
        }

        private void DATE_2_CREATETIME_ValueChanged(object sender, EventArgs e)
        {
            if (DATE_2_CREATETIME.DateTime >= DATE_2_CREATETIME_END.DateTime)
            {
                DATE_2_CREATETIME.DateTime = DATE_2_CREATETIME_END.DateTime.AddDays(-1);
            }
        }

        private void CB_2_CREATETIME_CheckedChanged_1(object sender, EventArgs e)
        {
            if (CB_2_CREATETIME.Checked)
            {
                this.DATE_2_CREATETIME.Enabled = true;
                this.DATE_2_CREATETIME_END.Enabled = true;
            }
            else
            {
                this.DATE_2_CREATETIME.Enabled = false;
                this.DATE_2_CREATETIME_END.Enabled = false;
            }
            querySqlServer();
        }

    }
}