MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/FrmQueryOrdProcInf.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 Core.Mes.Client.Comm.Tool;
using com.steering.pss.plnsaleord.order.model;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm;
using Core.Mes.Client.Comm.Control;

namespace Core.StlMes.Client.PlnSaleOrd
{
    public partial class FrmQueryOrdProcInf : FrmBase
    {
        public FrmQueryOrdProcInf()
        {
            this.IsLoadUserView = true;
            InitializeComponent();
            System.Threading.Thread t = new System.Threading.Thread(setGridColunmName);
            t.Start();
        }

        private void setGridColunmName()
        {
            System.Threading.Thread.Sleep(3000);
            if (!this.IsDisposed)
            {
                Init();
            }
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query":  //查询
                    DoQuery(GetQueryCondition());
                    break;
                case "LookCraftFile"://查看工艺文件
                    DoLookCraftFile();
                    break;
                case "Export":
                    GridHelper.ulGridToExcel(ultraGridSaleOrderProc, "排产综合信息");
                    break;
                case "MonthStatist"://统计报表
                    DoMonthStatist();
                    break;
                case "Close":  //关闭
                    this.Close();
                    break;
            }
        }

        private void Init()
        {
            EntityHelper.ShowGridCaption<PlnSaleOrderQueryEntity>(ultraGridSaleOrderProc.DisplayLayout.Bands[0]);

            ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["OrderAddDesc"].EditorComponent = ultraFileLook;
            ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["OrderAddDesc"].ButtonDisplayStyle
                = Infragistics.Win.UltraWinGrid.ButtonDisplayStyle.Always;
            PlanComm.setGridActivation(this.ultraGridSaleOrderProc.DisplayLayout.Bands[0]);
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 7, 3,
                        "OrderQtyD", "PlanWtD", "FinishWt", "planWtBegin", "PlanPMain", "Lengthmax", "Lengthmin");
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 5, 2,
                "Outdiameter", "Wallthick", "TotLenOneP", "LenRollMin", "LenRollMax",
                "HeightNkMin", "HeightNkMax", "LenToendMin", "LenToendMax",
                "LengthJg", "DimaterYlg", "HeightYlg", "HeightOrdMax", "HeightOrdMin",
                "AimWallthick", "RollLength", "ShrtLenRato", "LongLenRato");
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 5, 3,
                 "AimLenEnd", "AimLenRoll", "SiglLen", "EndlenSpecstd", "DifrncLenMax",
                 "AvgLenMin", "Longest", "Shortest", "ZOrderweight");
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 5, 0,
                 "PlanNumD", "planNumBegin", "CutNumP", "ZOrdernum");
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 3, 6,
                 "WeightPerM");
            PlanComm.setGridSummarySet(ultraGridSaleOrderProc, 0, "PlanNumD");
            PlanComm.setGridSummarySet(ultraGridSaleOrderProc, 3,
                "OrderQtyD", "PlanWtD", "FinishWt", "planWtBegin", "PlanPMain");
        }

        private void FrmQueryOrdProcInf_Load(object sender, EventArgs e)
        {
            comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Items.Add("1", "已接收");
            comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Items.Add("2", "已下发");
            comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Items.Add("3", "生产中");
            comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成");
            comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完毕");
            comQueryPanlInf1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0;
            comQueryPanlInf1.ultraDateTimeRollMonth.DateTime = DateTime.Now;
            comQueryPanlInf1.ultraTextEditorAcceptNo.Value = "X" + DateTime.Now.ToString("yyyyMMdd");
            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            this.RegStartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            this.RegEndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            Init();
        }

        /// <summary>
        /// 获取查询条件信息
        /// </summary>
        /// <returns>查询条件信息</returns>
        private ArrayList GetQueryCondition()
        {
            ArrayList ary = new ArrayList();
            string strRollmonth = "";
            string strAcceptNo = "";//接收批次号
            string strOrderNo = "";  //合同号
            string strOrderStatus = "";  //合同状态
            string ordSource = "";//合同来源

            if (comQueryPanlInf1.checkBoxAcceptNo.Checked)
            {
                strAcceptNo = comQueryPanlInf1.ultraTextEditorAcceptNo.Text.Trim();
            }

            if (comQueryPanlInf1.checkBoxForReqORDER_NO.Checked)
            {
                strOrderNo = comQueryPanlInf1.ctrlForQueryORDER_NO.Text.Trim();
            }

            if (comQueryPanlInf1.checkBoxForReqPORDERSTATUS.Checked)
            {
                strOrderStatus = comQueryPanlInf1.ctrlForQueryPORDERSTATUS.Value.ToString();
            }

            if (comQueryPanlInf1.checkBoxRollMonth.Checked)
            {
                strRollmonth = comQueryPanlInf1.ultraDateTimeRollMonth.DateTime.ToString("yyyy-MM");
            }
            if (comQueryPanlInf1.checkBoxOrdSource.Checked)
            {
                ordSource = comQueryPanlInf1.ultraComboOrdSource.Value.ToString();
            }

            ary.Add(comQueryPanlInf1.checkBoxHvJg.Checked);
            ary.Add(comQueryPanlInf1.checkBoxAddZz.Checked);
            ary.Add(comQueryPanlInf1.checkBoxBk.Checked);
            ary.Add(comQueryPanlInf1.checkBoxDc.Checked);
            ary.Add(comQueryPanlInf1.checkBoxInSpec.Checked);
            ary.Add(strRollmonth);
            ary.Add(strAcceptNo);
            ary.Add(strOrderNo);
            ary.Add(strOrderStatus);
            ary.Add(ordSource);
            return ary;
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery(ArrayList ary)
        {
            string startTim = "";
            string endTime = "";
            if (this.ultraCheckEditor1.Checked)
            {
                startTim = this.RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
                endTime = this.RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
            }
            slmSaleOrderEntitybindingSource.DataSource = EntityHelper.GetData<PlnSaleOrderQueryEntity>(
                "com.steering.pss.plnsaleord.order.CoreQueryOrdProcInf.queryOrdProcInf",
                new object[] { ary,startTim,endTime }, this.ob);
        }

        /// <summary>
        /// 查看上传工艺文件
        /// </summary>
        private void DoLookCraftFile()
        {
            UltraGridRow ugr = this.ultraGridSaleOrderProc.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            DataTable dtPath = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreSaleOrderReceive.queryCraftFilePath",
                       new object[] { ugr.Cells["OrdLnDlyPk"].Value.ToString(), ugr.Cells["PlnDivideId"].Value.ToString() }, this.ob);
            if (dtPath != null && dtPath.Rows.Count > 0)
            {
                ArrayList listPIC = new ArrayList();
                foreach (DataRow dr in dtPath.Rows)
                {
                    listPIC.Add(dr["CRAFT_PATH"].ToString());
                }
                dlgOrderAskLook orderAsk = new dlgOrderAskLook(this.ob, listPIC);
                orderAsk.Text = "查看上传工艺文件";
                orderAsk.Show();
            }
        }

        /// <summary>
        /// 排产月统计查询
        /// </summary>
        private void DoMonthStatist()
        {
            FrmReqRollMonth outPut = new FrmReqRollMonth();
            outPut.Show();
        }

        private void ultraFileLook_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            try
            {
                UltraGridRow ugr = ultraGridSaleOrderProc.ActiveRow;
                if (ugr == null)
                {
                    return;
                }
                string askNo = ugr.Cells["AddAskNo"].Value.ToString();
                ArrayList listPIC = new ArrayList();
                DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.queryAddAsk",
                    new object[] { askNo }, this.ob);
                if (dt != null && dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        listPIC.Add(dr["PIC"].ToString());
                    }
                }
                dlgOrderAskLook orderAsk = new dlgOrderAskLook(this.ob, listPIC);
                orderAsk.Show();
            }
            catch (Exception ex)
            {
                if (!(ex is MESException))
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e)
        {
            this.RegStartTime.Enabled = this.RegEndTime.Enabled = this.ultraCheckEditor1.Checked;
        }
    }
}