MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/FrmMatJgMImport.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.plnsaleord.order.model;
using Core.StlMes.Client.PlnSaleOrd.PopupWindow;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm;
using Infragistics.Win.UltraWinEditors;
using System.Globalization;

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

        public FrmMatJgMImport()
        {
            this.IsLoadUserView = true;
            InitializeComponent();
            EntityHelper.ShowGridCaption<PlnSaleordSetEntity>(ultraGridStatus.DisplayLayout.Bands[0]);
        }

        private void FrmOrderStatusSet_Load(object sender, EventArgs e)
        {
            ultraDateTimeImportTime.DateTime = DateTime.Now;
            ultraDateTimeImportTimeTo.DateTime = DateTime.Now;
            ultraComboOrderStatusSet.SelectedIndex = 0;
            PlanComm.setGridActivation(ultraGridStatus.DisplayLayout.Bands[0], "CHC");
            PlanComm.setGridDigitalCol(ultraGridStatus.DisplayLayout.Bands[0], 5, 0, "NumSetStatus");
            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 "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<PlnSaleordSetEntity> listSorce = EntityHelper.GetData<PlnSaleordSetEntity>(
                "com.steering.pss.plnsaleord.order.CoreOrderStatusSet.queryOrderSetLog", new object[] { param }, this.ob);
            this.slmbindingSourcePlnSaleordSetEntity.DataSource = listSorce;
        }

        /// <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)
                {
                    PlnSaleordSetEntity entity = new PlnSaleordSetEntity();
                    entity.UpdateMan = UserInfo.GetUserName();
                    entity.EndStatus = ultraComboOrderStatusSet.Value.ToString();
                    entity.PlnDivideId = uRow.Cells["PlnDivideId"].Value.ToString();
                    entity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                    list.Add(entity);
                }

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreOrderStatusSet";
                ccp.MethodName = "updateOrderStatus";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                WaitFromColse();
                if (ccp.ReturnCode != -1)
                {
                    if (MessageUtil.ShowYesNoAndQuestion(ccp.ReturnInfo + "\n是否删除同步记录？") == DialogResult.Yes)
                    {
                        doDelete();
                    }
                }
                else
                {
                    MessageUtil.ShowTips("同步失败！\n" + ccp.ReturnInfo);
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (!(ex is MESException))
                {
                    MessageBox.Show(ex.Message);
                }
            }
            DoQuery();
        }

        /// <summary>
        /// 同步月份
        /// </summary>
        private void DoModefiyMonth()
        {
            try
            {
                int defailNum = 0;
                ultraGridStatus.UpdateData();
                string messageErr = "";
                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)
                {
                    PlnSaleordSetEntity entity = new PlnSaleordSetEntity();
                    DateTime date = new DateTime();
                    if (DateTime.TryParseExact(uRow.Cells["RollMonth"].Value.ToString(),
                        "yyyy-MM", null, DateTimeStyles.None, out date))
                    {
                        entity.RollMonth = date.ToString("yyyy-MM");
                    }
                    else
                    {
                        messageErr = "月份格式有误！";
                        defailNum++;
                        continue;
                    }
                    entity.IfSetMonth = "1";
                    entity.PlnDivideId = uRow.Cells["PlnDivideId"].Value.ToString();
                    entity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                    list.Add(entity);
                }
                if (list.Count <= 0)
                {
                    WaitFromColse();
                    MessageUtil.ShowTips("0条同步成功，" + defailNum + "条同步失败。" + messageErr);
                    return;
                }

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreOrderStatusSet";
                ccp.MethodName = "updateOrderStatusMonth";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                WaitFromColse();
                if (ccp.ReturnCode != -1)
                {
                    if (MessageUtil.ShowYesNoAndQuestion(list.Count + "条同步成功，" + defailNum + "条同步失败。\n"
                        + messageErr + "\n是否删除同步记录？") == DialogResult.Yes)
                    {
                        doDelete();
                    }
                }
                else
                {
                    MessageUtil.ShowTips("同步失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (!(ex is MESException))
                {
                    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)
        //        {
        //            PlnSaleordSetEntity entity = new PlnSaleordSetEntity();
        //            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.plnsaleord.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)
        //        {
        //            PlnSaleordSetEntity entity = new PlnSaleordSetEntity();
        //            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.plnsaleord.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)
                {
                    PlnSaleordSetEntity entity = new PlnSaleordSetEntity();
                    entity.PlnDivideId = uRow.Cells["PlnDivideId"].Value.ToString();
                    entity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                    list.Add(entity);
                }

                int succed = ServerHelper.SetData("com.steering.pss.plnsaleord.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))
                {
                    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;
        }

    }
}