MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/FrmPlnOrdPriority.cs

using com.steering.pss.plnsaleord.order.model;
using Core.Mes.Client.Comm;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using CoreFS.CA06;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.StlMes.Client.PlnSaleOrd
{
    public partial class FrmPlnOrdPriority : FrmBase
    {
        UltraComboEditor uceA = new UltraComboEditor();
        public FrmPlnOrdPriority()
        {
            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 "ModifyPrio"://合同紧急度
                    DoModifyPrio();
                    break;
                case "RefresDate"://刷新加载数据
                    RefresDate();
                    DoQuery(GetQueryCondition());
                    break;
                case"Export":
                    exportData();
                    break;
                case "Close":  //关闭
                    this.Close();
                    break;
            }
        }

        private void exportData()
        {
            GridHelper.ulGridToExcel(ultraGridSaleOrder, "合同信息数据汇总");
        }

        private void FrmPlnOrdPriority_Load(object sender, EventArgs e)
        {
            comQueryPanelProdu1.ctrlForQueryPORDERSTATUS.Items.Add("1", "已接收");
            comQueryPanelProdu1.ctrlForQueryPORDERSTATUS.Items.Add("2", "已下发");
            comQueryPanelProdu1.ctrlForQueryPORDERSTATUS.Items.Add("3", "生产中");
            comQueryPanelProdu1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成");
            comQueryPanelProdu1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完成");
            comQueryPanelProdu1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0;
            comQueryPanelProdu1.ultraComboFinishEditor.SelectedIndex = 0;
            comQueryPanelProdu1.checkBoxForReqPORDERSTATUS.Checked = false;
            comQueryPanelProdu1.checkBoxIsConfirm.Text = "未录入";
            comQueryPanelProdu1.checkBoxIsConfirm.Visible = true;
            comQueryPanelProdu1.ultraTextEditorAcceptNo.Value = "X" + DateTime.Now.ToString("yyyyMMdd");

            Init(); 
            timer1.Start();
            RefresDate();
        }

        private void Init()
        {
            EntityHelper.ShowGridCaption<PlnSaleOrderQueryEntity>(ultraGridSaleOrder.DisplayLayout.Bands[0]);
            this.Controls.Add(uceA);
            uceA.Visible = false;
            ultraGridSaleOrder.DisplayLayout.Bands[0].Columns["OrderAddDesc"].EditorComponent = ultraFileLook;
            ultraGridSaleOrder.DisplayLayout.Bands[0].Columns["OrderAddDesc"].ButtonDisplayStyle
                = Infragistics.Win.UltraWinGrid.ButtonDisplayStyle.Always;
            PlanComm.setGridActivation(this.ultraGridSaleOrder.DisplayLayout.Bands[0], "CHC", "Priority", "PriorityMemo");
            PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 7, 3,
                        "OrderQtyD", "PlanWtD", "FinishWt", "planWtBegin", "PlanPMain", "Lengthmax", "Lengthmin");
            PlanComm.setGridDigitalCol(ultraGridSaleOrder.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(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 3,
                 "AimLenEnd", "AimLenRoll", "SiglLen", "EndlenSpecstd", "DifrncLenMax",
                 "AvgLenMin", "Longest", "Shortest", "ZOrderweight");
            PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 0,
                 "PlanNumD", "planNumBegin", "CutNumP", "ZOrdernum");
            PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 3, 6,
                 "WeightPerM");
            PlanComm.setGridSummarySet(ultraGridSaleOrder, 0, "PlanNumD");
            PlanComm.setGridSummarySet(ultraGridSaleOrder, 3,
                "OrderQtyD", "PlanWtD", "FinishWt", "planWtBegin", "PlanPMain");
        }

        /// <summary>
        /// 刷新
        /// </summary>
        private void RefresDate()
        {
            DataTable tableBaseInfo = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.queryBaseinfoAll",
                new object[] { }, this.ob);

            if (tableBaseInfo != null)
            {
                //合同紧急度
                tableBaseInfo.DefaultView.RowFilter = "SORTCODE='2006'";
                DataTable dtPrior = tableBaseInfo.DefaultView.ToTable();
                if (dtPrior != null && dtPrior.Rows.Count > 0)
                {
                    foreach(DataRow row in dtPrior.Rows)
                    {
                        DataRow newRow = dtPrior.NewRow();
                        newRow["BASECODE"] = "";
                        newRow["BASENAME"] = "";
                        newRow["SORTCODE"] = "";
                        dtPrior.Rows.Add(newRow);
                        break;
                    }
                    uceA.DataSource = dtPrior;
                    uceA.DisplayMember = "BASENAME";
                    uceA.ValueMember = "BASECODE";
                    ultraGridSaleOrder.DisplayLayout.Bands[0].Columns["Priority"].EditorComponent
                        = uceA;
                    ultraGridSaleOrder.DisplayLayout.Bands[0].Columns["Priority"].Style =
                        Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                }
            }
        }

        /// <summary>
        /// 获取查询条件信息
        /// </summary>
        /// <returns>查询条件信息</returns>
        private ArrayList GetQueryCondition()
        {
            ArrayList ary = new ArrayList();
            string strRollmonth = "";
            string strAcceptNo = "";//接收批次号
            string strOrderNo = "";  //合同号
            string strOrderStatus = "";  //合同状态
            string haveJg = "";     //是否有接箍
            string haveDj = "";     //是否有短节
            string isGpOrder = "";  //是否是管坯合同

            if (comQueryPanelProdu1.checkBoxHvJg.Checked)
            {
                haveJg = "1";
            }

            if (comQueryPanelProdu1.checkBoxHvDj.Checked)
            {
                haveDj = "1";
            }

            if (comQueryPanelProdu1.checkBoxisGp.Checked)
            {
                isGpOrder = "1";
            }

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

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

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

            if (comQueryPanelProdu1.checkBoxRollMonth.Checked)
            {
                strRollmonth = comQueryPanelProdu1.ultraDateTimeRollMonth.DateTime.ToString("yyyy-MM");
            }

            ary.Add(strRollmonth);
            ary.Add(strAcceptNo);
            ary.Add(strOrderNo);
            ary.Add(strOrderStatus);
            ary.Add(haveJg);
            ary.Add(haveJg);
            ary.Add(haveDj);
            ary.Add(haveDj);
            ary.Add(isGpOrder);
            ary.Add(isGpOrder);
            return ary;
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery(ArrayList ary)
        {
            string strFinish = "";
            if (this.comQueryPanelProdu1.checkBoxFinish.Checked)
            {
                strFinish = comQueryPanelProdu1.ultraComboFinishEditor.Value.ToString();
            }
            this.slmPlnSaleordEntitybindingSource.DataSource = EntityHelper.GetData<PlnSaleOrderQueryEntity>(
                "com.steering.pss.plnsaleord.order.CorePlnOrdPriority.querySaleOrder",
                new object[] { ary, strFinish, comQueryPanelProdu1.checkBoxIsConfirm.Checked,this.CustomInfo.ToString2() }, this.ob);
        }

        /// <summary>
        /// 紧急度修改
        /// </summary>
        private void DoModifyPrio()
        {
            try
            {
                int defailNum = 0;
                string messageErr = "";
                this.ultraGridSaleOrder.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGridSaleOrder.Rows.AsQueryable().Where("CHC = 'True'");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选任何合同！");
                    return;
                }
                PlanComm.WaitFromOpen(this.Cursor);
                foreach (UltraGridRow uRow in checkRows)
                {
                    ArrayList param = new ArrayList();
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnOrdPriority.querySaleStatus",
                           new object[] { uRow.Cells["OrdLnDlyPk"].Value.ToString(), uRow.Cells["PlnDivideId"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        defailNum++;
                        messageErr = "未找到"+ uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                            + uRow.Cells["DeliveryNo"].Value.ToString() + "的记录！";
                        continue;
                    }
                    param.Add(uRow.Cells["Priority"].Value.ToString());
                    param.Add(uRow.Cells["PriorityMemo"].Value.ToString());
                    param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                    param.Add(uRow.Cells["PlnDivideId"].Value.ToString());
                    param.Add(uRow.Cells["Priority"].Value.ToString());
                    param.Add(uRow.Cells["PriorityMemo"].Value.ToString());
                    param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                    param.Add(uRow.Cells["Priority"].Value.ToString());
                    param.Add(uRow.Cells["PriorityMemo"].Value.ToString());
                    param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                    param.Add(uRow.Cells["Priority"].Value.ToString());
                    param.Add(uRow.Cells["PriorityMemo"].Value.ToString());
                    param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                    param.Add(uRow.Cells["Priority"].Value.ToString());
                    param.Add(uRow.Cells["PriorityMemo"].Value.ToString());
                    param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                    list.Add(param);
                }
                if (list.Count == 0)
                {
                    PlanComm.WaitFromColse(this.Cursor);
                    MessageUtil.ShowTips("0条保存成功，" + defailNum + "条保存失败。\n" + messageErr);
                    return;
                }

                int succeed = ServerHelper.SetData("com.steering.pss.plnsaleord.order.CorePlnOrdPriority.savePlnOrdPriority",
                     new object[] { list }, this.ob);
                PlanComm.WaitFromColse(this.Cursor);
                if (succeed > 0)
                {
                    if (defailNum == 0)
                    {
                        MessageUtil.ShowTips("保存成功，共" + list.Count + "条。");
                    }
                    else
                    {
                        MessageUtil.ShowTips(list.Count + "条保存成功，" + defailNum + "条保存失败。\n" + messageErr);
                    }
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
            DoQuery(GetQueryCondition());
        }


        private void ultraGridSaleOrder_KeyUp(object sender, KeyEventArgs e)
        {
            PlanComm.setGridCopyActColumn(this.ultraGridSaleOrder, "CHC", e,
                "Priority", "PriorityMemo");
        }

        private void ultraGridSaleOrder_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGridSaleOrder.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHC"].Value = true;
                }
            }
        }

        /// <summary>
        /// 查看附加要求贴图
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraFileLook_EditorButtonClick(object sender,
            Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            try
            {
                UltraGridRow ugr = ultraGridSaleOrder.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 timer1_Tick(object sender, EventArgs e)
        {
            Init();
        }
    }
}