MES_Client/TGMES/Core.StlMes.Client.Mcp.Mch/Mat/ApplyAudit.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Tool;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
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;

namespace Core.StlMes.Client.Mcp.Mch.Mat
{
    public partial class ApplyAudit : FrmBase
    {

        private string[] plineCodes = { };

        public ApplyAudit()
        {
            InitializeComponent();
            IsLoadUserView = true;
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            StartTime1.Value =
                DateTime.Parse(DateTime.Now.AddDays(1 - DateTime.Now.Day).AddDays(-1).ToString("yyyy-MM-dd 21:00"));
            EndTime1.Value =
                DateTime.Parse(
                    DateTime.Now.AddDays(1 - DateTime.Now.Day).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd 20:59"));

            plineCodes = comm.GetPlineCode2(ValidDataPurviewIds, ob);

            EntityHelper.ShowGridCaption<YdmOverstockpipeApplyEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            comm.RefreshAndAutoSize(ultraGrid1);

        }


        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    Query();
                    break;
                case "AuditYK":
                    AuditYK();
                    break;
                case "Cancel":
                    CancelAudit();
                    break;
                case "Del":
                    Del();
                    break;
                case "CancelDel":
                    CancelDel();
                    break;
                case "Close":
                    Close();
                    break;
                case "Export":
                    Export();
                    break;

            }
        }

        public void AuditYK()
        {
            if (this.ultraOptionSet1.CheckedItem.DataValue.ToString().Equals("0"))
            {
                AuditOfflineYK();
            }
            else if (this.ultraOptionSet1.CheckedItem.DataValue.ToString().Equals("1"))
            {
                AuditYucaiYK();
            }
        }

        private void Chk1_CheckedChanged(object sender, EventArgs e)
        {
            this.ultraTextEditor1.Enabled = this.Chk1.Checked;
        }

        private void Chk2_CheckedChanged(object sender, EventArgs e)
        {
            this.judgeNoTextEditor2.Enabled = this.Chk2.Checked;
        }

        /// <summary>
        /// 查询申请信息
        /// </summary>
        public void Query()
        {
            var wf = new WaitingForm2("正在查询,请稍后....");

            try
            {
                Cursor = Cursors.WaitCursor;


                Dictionary<string, object> dic = new Dictionary<string, object>();



                if (chkTim1.Checked)
                    if (DateTime.Parse(StartTime1.Value.ToString()) > DateTime.Parse(EndTime1.Value.ToString()))
                    {
                        MessageUtil.ShowTips("选择时间区间错误,请重新选择!");
                        return;
                    }
                    else
                    {
                        dic.Add("start", StartTime1.Value.ToString("yyyy-MM-dd HH:mm:ss"));
                        dic.Add("end", EndTime1.Value.ToString("yyyy-MM-dd HH:mm:ss"));
                    }

                if(Chk1.Checked){
                    dic.Add("applyno",this.ultraTextEditor1.Text.ToString());
                }

                if (Chk2.Checked)
                {
                    dic.Add("judgeno",this.judgeNoTextEditor2.Text.ToString());
                }

                if(validChk.Checked){
                    dic.Add("validChk","包含无效");
                }
                else
                {
                    dic.Add("validChk", "不包含无效");
                }

                dic.Add("applytype", this.ultraOptionSet1.CheckedItem.DataValue.ToString());
                dic.Add("plineCodes", plineCodes);

                List<YdmOverstockpipeApplyEntity> listSource = EntityHelper.GetData<YdmOverstockpipeApplyEntity>(
                    "com.steering.mes.mcp.common.OverstockPipe.doQueryApply",
                    new object[] { dic }, ob);


                ydmOverstockpipeApplyEntityBindingSource.DataSource = listSource;
                comm.RefreshAndAutoSize(ultraGrid1);

                foreach(UltraGridRow ugr in this.ultraGrid1.Rows){
                    if (ugr.Cells["validflag"].Text.ToString().Equals("无效"))
                    {
                        ugr.Appearance.ForeColor = Color.Red;
                    }
                    else
                    {
                        ugr.Appearance.ForeColor = Color.Black;
                    }
                }

            }
            catch (Exception ex)
            {
                if (ex.Message.ToString2() != "")
                    MessageBox.Show(ex.Message);
            }
            finally
            {
                wf.Close();
                Cursor = Cursors.Default;
            }

        }

        /// <summary>
        /// 离线转压库审核
        /// </summary>
        private void AuditOfflineYK()
        {
            ultraGrid1.UpdateData();
            var list = ydmOverstockpipeApplyEntityBindingSource.DataSource as List<YdmOverstockpipeApplyEntity>;
            list = list.Where(p =>p.Chk).ToList();
            if (!list.Any())
            {
                MessageBox.Show("请选择要转压库审核的数据!");
                return;
            }

            var list1 = list.Select(p => p.ApplyFlag).ToList();
            foreach (var item in list1)
            {
                if (!item.Equals("已申请"))
                {
                    MessageUtil.ShowTips("包含已经完成审核的数据,请重试!");
                    return;
                }
            }

            if (MessageUtil.ShowYesNoAndQuestion("确认通过审核?") == DialogResult.No) return;

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.common.OverstockPipe";
            ccp.MethodName = "AuditOfflineYK";
            ccp.ServerParams = new object[]{ 
                list.Select(JSONFormat.Format).ToList(),this.UserInfo.GetUserName() };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("审核通过!"))
                {
                    Query();
                }
            }
        }


        /// <summary>
        /// 余材压库审核
        /// </summary>
        public void AuditYucaiYK()
        {
            ultraGrid1.UpdateData();
            var list = ydmOverstockpipeApplyEntityBindingSource.DataSource as List<YdmOverstockpipeApplyEntity>;
            list = list.Where(p => p.Chk).ToList();
            if (!list.Any())
            {
                MessageBox.Show("请选择要转压库审核的数据!");
                return;
            }

            var list1 = list.Select(p => p.ApplyFlag).ToList();
            foreach (var item in list1)
            {
                if (!item.Equals("已申请"))
                {
                    MessageUtil.ShowTips("包含已经完成审核的数据,请重试!");
                    return;
                }
            }

            if (MessageUtil.ShowYesNoAndQuestion("确认通过审核?") == DialogResult.No)
                return;

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.common.OverstockPipe";
            ccp.MethodName = "AuditYucaiYK";
            ccp.ServerParams = new object[]
            {
                list.Select(JSONFormat.Format).ToList(), this.UserInfo.GetUserName()
            };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("审核通过!"))
                {
                    Query();
                }
            }
        }


        /// <summary>
        /// 压库审核撤销
        /// </summary>
        public void CancelAudit()
        {
            ultraGrid1.UpdateData();
            var list = ydmOverstockpipeApplyEntityBindingSource.DataSource as List<YdmOverstockpipeApplyEntity>;
            list = list.Where(p => p.Chk).ToList();
            if (!list.Any())
            {
                MessageBox.Show("请选择要撤销的数据!");
                return;
            }

            var list1 = list.Select(p => p.ApplyFlag).ToList();
            foreach (var item in list1)
            {
                if (item.Equals("已申请"))
                {
                    MessageUtil.ShowTips("尚未审核通过的数据无法撤销,请重试!");
                    return;
                }
            }

            foreach (var item in list.Select(JSONFormat.Format).ToList())
            {
                List<YdmOverstockpipeApplyEntity> listSource = EntityHelper.GetData<YdmOverstockpipeApplyEntity>(
                "com.steering.mes.mcp.common.OverstockPipe.doQueryYDMResult", new object[] { item }, this.ob);
                if (listSource.Any())
                {
                    MessageUtil.ShowTips("包含已经进行送判的数据,无法撤销审核,清重试!");
                    return;
                }
            }


            if (MessageUtil.ShowYesNoAndQuestion("确认撤销?") == DialogResult.No)
                return;

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.common.OverstockPipe";
            ccp.MethodName = "CancelAudit";
            ccp.ServerParams = new object[] { list.Select(JSONFormat.Format).ToList() };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销成功!"))
                {
                    Query();
                }
            }
        }


        /// <summary>
        /// 压库申请废除
        /// </summary>
        public void Del()
        {
            ultraGrid1.UpdateData();
            var list = ydmOverstockpipeApplyEntityBindingSource.DataSource as List<YdmOverstockpipeApplyEntity>;
            list = list.Where(p => p.Chk).ToList();
            if (!list.Any())
            {
                MessageUtil.ShowTips("请选择要废除的数据!");
                return;
            }

            var list1 = list.Select(p => p.Validflag).ToList();
            foreach (var item in list1)
            {
                if (item.Equals("无效"))
                {
                    MessageUtil.ShowTips("已经废除的数据无法再次废除,请重试!");
                    return;
                }
            }

            if (MessageUtil.ShowYesNoAndQuestion("确认废除?") == DialogResult.No)
                return;

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.common.OverstockPipe";
            ccp.MethodName = "Del";
            ccp.ServerParams = new object[] { list.Select(JSONFormat.Format).ToList() };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("废除成功!"))
                {
                    Query();
                }
            }
        }


        /// <summary>
        /// 压库申请废除撤销
        /// </summary>
        public void CancelDel()
        {
            ultraGrid1.UpdateData();
            var list = ydmOverstockpipeApplyEntityBindingSource.DataSource as List<YdmOverstockpipeApplyEntity>;
            list = list.Where(p => p.Chk).ToList();
            if (!list.Any())
            {
                MessageUtil.ShowTips("请选择要撤销的数据!");
                return;
            }

            var list1 = list.Select(p => p.Validflag).ToList();
            foreach (var item in list1)
            {
                if (item.Equals("有效"))
                {
                    MessageUtil.ShowTips("有效数据无法撤销废除,请重试!");
                    return;
                }
            }

            if (MessageUtil.ShowYesNoAndQuestion("确认撤销?") == DialogResult.No)
                return;

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.common.OverstockPipe";
            ccp.MethodName = "CancelDel";
            ccp.ServerParams = new object[] { list.Select(JSONFormat.Format).ToList() };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销成功!"))
                {
                    Query();
                }
            }
        }



        public void Export()
        {
            string title = "";
            title += "申请审核记录";
            GridHelper.ulGridToExcel(ultraGrid1, title);
        }

    }
}