MES_Client/TGMES/Core.StlMes.Client.Plan.Order/FrmOrderStatusSet.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 Core.Mes.Client.Comm.Tool;
using Core.Mes.Client.Comm.Server;
using com.steering.pss.plan.order.model;
using Core.StlMes.Client.Plan.Order.PopupWindow;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm;
using Infragistics.Win.UltraWinEditors;

namespace Core.StlMes.Client.Plan.Order
{
    public partial class FrmOrderStatusSet : FrmBase
    {
        UltraComboEditor uceA = new UltraComboEditor();

        public FrmOrderStatusSet()
        {
            this.IsLoadUserView = true;
            InitializeComponent();
        }

        private void FrmOrderStatusSet_Load(object sender, EventArgs e)
        {
            EntityHelper.ShowGridCaption<PlnSaleorderSetEntity>(ultraGridStatus.DisplayLayout.Bands[0]);
            ultraDateTimeImportTime.DateTime = DateTime.Now;
            ultraDateTimeImportTimeTo.DateTime = DateTime.Now;
            ultraComboOrderStatusSet.SelectedIndex = 0;
            this.Controls.Add(uceA);
            uceA.Visible = false;
            DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderStatusSet.getBaseInfSort",
                new object[] { "1001" }, this.ob);
            uceA.DataSource = dt;
            uceA.DisplayMember = "BASENAME";
            uceA.ValueMember = "BASECODE";
            //ultraGridStatus.DisplayLayout.Bands[0].Columns["Orderfrom"].ValueList = PlanComm.GeneralValuelist(ref dt, "BASECODE", "BASENAME");
            ultraGridStatus.DisplayLayout.Bands[0].Columns["Orderfrom"].EditorComponent = uceA;
            ultraGridStatus.DisplayLayout.Bands[0].Columns["Orderfrom"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            DoQuery();
        }


        /// <summary>
        /// 重写基类toolBar方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    DoQuery();
                    break;
                case "Import":
                    DoImport();
                    break;
                case "Modefiy":
                    DoModefiy();
                    break;
                case "ModefiyMonth":
                    DoModefiyMonth();
                    break;
                case "Delete":
                    doDelete();
                    DoQuery();
                    break;
                case "ModefiyProSort":
                    DoModefiyProSort();
                    break;
                case "ModefiyOrderFrom":
                    DoModefiyOrderFrom();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery()
        {
            ArrayList param = new ArrayList();
            if (checkBoxForReqORDER_NO.Checked)
            {
                param.Add(this.ctrlForQueryORDER_NO.Value.ToString());
            }
            else
            {
                param.Add("");
            }

            if (checkBoxIsRollMonth.Checked)
            {
                param.Add("0");
                param.Add("0");
            }
            else
            {
                param.Add("");
                param.Add("");
            }

            if (checkBoxIsNot.Checked)
            {
                param.Add("0");
                param.Add("0");
            }
            else
            {
                param.Add("");
                param.Add("");
            }

            param.Add(this.ultraDateTimeImportTime.DateTime.ToString("yyyy-MM-dd"));
            param.Add(this.ultraDateTimeImportTimeTo.DateTime.ToString("yyyy-MM-dd"));

            List<PlnSaleorderSetEntity> listSorce = EntityHelper.GetData<PlnSaleorderSetEntity>(
                "com.steering.pss.plan.order.CoreOrderStatusSet.queryOrderSetLog", new object[] { param }, this.ob);
            this.slmbindingSourcePlnSaleorderSetEntity.DataSource = listSorce;
            PlanComm.setGridActivation(ultraGridStatus.DisplayLayout.Bands[0], "CHC");
        }

        /// <summary>
        /// 导入
        /// </summary>
        private void DoImport()
        {
            try
            {
                OpenFileDialog dialog = new OpenFileDialog();
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    FrmImportSetOrder import = new FrmImportSetOrder(this.ob);
                    import.ModelPatch = dialog.FileName;
                    import.ShowDialog();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            DoQuery();
        }

        /// <summary>
        /// 同步
        /// </summary>
        private void DoModefiy()
        {
            try
            {
                ultraGridStatus.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkedRows = ultraGridStatus.Rows.AsQueryable().Where(" CHC = True");
                if (checkedRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选任何行！");
                    return;
                }
                WaitFromOpen();
                foreach (UltraGridRow uRow in checkedRows)
                {
                    PlnSaleorderSetEntity entity = new PlnSaleorderSetEntity();
                    entity.EndStatus = ultraComboOrderStatusSet.Value.ToString();
                    entity.OrderNoSeq = uRow.Cells["OrderNoSeq"].Value.ToString();
                    entity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                    list.Add(entity);
                }

                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderStatusSet.updateOrderStatus",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("同步成功！\n是否删除同步记录？") == DialogResult.Yes)
                    {
                        doDelete();
                    }
                }
                else
                {
                    MessageUtil.ShowTips("同步失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            DoQuery();
        }

        /// <summary>
        /// 同步月份
        /// </summary>
        private void DoModefiyMonth()
        {
            try
            {
                ultraGridStatus.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkedRows = ultraGridStatus.Rows.AsQueryable().Where(" CHC = True");
                if (checkedRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选任何行！");
                    return;
                }
                WaitFromOpen();
                foreach (UltraGridRow uRow in checkedRows)
                {
                    PlnSaleorderSetEntity entity = new PlnSaleorderSetEntity();
                    entity.RollMonth = uRow.Cells["RollMonth"].Value.ToString();
                    entity.IfSetMonth = "1";
                    entity.OrderNoSeq = uRow.Cells["OrderNoSeq"].Value.ToString();
                    entity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                    list.Add(entity);
                }

                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderStatusSet.updateOrderStatusMonth",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("同步成功！\n是否删除同步记录？") == DialogResult.Yes)
                    {
                        doDelete();
                    }
                }
                else
                {
                    MessageUtil.ShowTips("同步失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            DoQuery();
        }

        /// <summary>
        /// 同步生产分类
        /// </summary>
        private void DoModefiyProSort()
        {
            try
            {
                ultraGridStatus.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkedRows = ultraGridStatus.Rows.AsQueryable().Where(" CHC = True");
                if (checkedRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选任何行！");
                    return;
                }
                WaitFromOpen();
                foreach (UltraGridRow uRow in checkedRows)
                {
                    PlnSaleorderSetEntity entity = new PlnSaleorderSetEntity();
                    entity.ProduceSort = uRow.Cells["ProduceSort"].Value.ToString();
                    entity.OrderNoSeq = uRow.Cells["OrderNoSeq"].Value.ToString();
                    entity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                    list.Add(entity);
                }

                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderStatusSet.updateProSort",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("同步成功！\n是否删除同步记录？") == DialogResult.Yes)
                    {
                        doDelete();
                    }
                }
                else
                {
                    MessageUtil.ShowTips("同步失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            DoQuery();
        }

        /// <summary>
        /// 同步来源
        /// </summary>
        private void DoModefiyOrderFrom()
        {
            try
            {
                ultraGridStatus.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkedRows = ultraGridStatus.Rows.AsQueryable().Where(" CHC = True");
                if (checkedRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选任何行！");
                    return;
                }
                WaitFromOpen();
                foreach (UltraGridRow uRow in checkedRows)
                {
                    PlnSaleorderSetEntity entity = new PlnSaleorderSetEntity();
                    entity.Orderfrom = uRow.Cells["Orderfrom"].Value.ToString();
                    entity.OrderNoSeq = uRow.Cells["OrderNoSeq"].Value.ToString();
                    entity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                    list.Add(entity);
                }

                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderStatusSet.updateOrderfrom",
                    new object[] { list }, this.ob); 
                WaitFromColse();
                if (succed > 0)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("同步成功！\n是否删除同步记录？") == DialogResult.Yes)
                    {
                        doDelete();
                    }
                }
                else
                {
                    MessageUtil.ShowTips("同步失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            DoQuery();
        }

        /// <summary>
        /// 删除
        /// </summary>
        private void doDelete() 
        {
            try
            {
                ultraGridStatus.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkedRows = ultraGridStatus.Rows.AsQueryable().Where(" CHC = True");
                if (checkedRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选任何行！");
                    return;
                }
                WaitFromOpen();
                foreach (UltraGridRow uRow in checkedRows)
                {
                    PlnSaleorderSetEntity entity = new PlnSaleorderSetEntity();
                    entity.OrderNoSeq = uRow.Cells["OrderNoSeq"].Value.ToString();
                    entity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                    list.Add(entity);
                }

                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderStatusSet.deleteOrderStatus",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    MessageUtil.ShowTips("删除成功！");
                }
                else
                {
                    MessageUtil.ShowTips("删除失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        private void checkBoxForReqORDER_NO_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxForReqORDER_NO.Checked)
            {
                ctrlForQueryORDER_NO.Enabled = true;
            }
            else
            {
                ctrlForQueryORDER_NO.Enabled = false;
            }
        }

        private void ultraDateTimeImportTime_ValueChanged(object sender, EventArgs e)
        {
            ultraDateTimeImportTimeTo.MinDate = ultraDateTimeImportTime.DateTime.Date;
        }

        private void ultraDateTimeImportTimeTo_ValueChanged(object sender, EventArgs e)
        {
            ultraDateTimeImportTime.MaxDate = ultraDateTimeImportTimeTo.DateTime.AddDays(1).Date.AddSeconds(-1);
        }

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


        /// <summary>
        /// 等待窗口
        /// </summary>
        private void WaitFromOpen()
        {
            this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
            if (Constant.WaitingForm == null)
            {
                Constant.WaitingForm = new WaitingForm();
            }
            Constant.WaitingForm.ShowToUser = true;
            Constant.WaitingForm.Show();
            Constant.WaitingForm.Update();
        }

        /// <summary>
        /// 关闭等待
        /// </summary>
        private void WaitFromColse()
        {
            this.Cursor = Cursors.Default;
            Constant.WaitingForm.ShowToUser = false;
            Constant.WaitingForm.Close();
            Constant.WaitingForm = null;
        }

    }
}