MES_Client/TGMES/Core.StlMes.Client.Mcp.Mch/MchResult/FrmMchInStore.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Mcp.Mch.Entity;
using CoreFS.CA06;
using Infragistics.Win;
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.Mcp.Mch.MchResult
{
    public partial class FrmMchInStore : FrmBase
    {
        private string _plineCode;

        protected List<HttSignatureEntity> Names = new List<HttSignatureEntity>();

        public FrmMchInStore()
        {
            InitializeComponent();
        }
        private string[] plineCode = null;
        private void FrmMchInStore_Load(object sender, EventArgs e)
        {
            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            this.StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            this.EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            this.StartTime1.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            this.EndTime1.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            EntityHelper.ShowGridCaption<PlnZyJgxMEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PortMchBatchSampleResultEntity>(ultraGrid2.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<YdmBcInlistEntity>(ultraGrid3.DisplayLayout.Bands[0]);
            plineCode = comm.GetPlineCode(this.ValidDataPurviewIds,"G", this.CustomInfo, ob);
        }
        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "DoQuery":
                    QuerySinglePlan();
                    break;
                case"DoQueryInList":
                    doQueryInList();
                    break;
                case"DoSave":
                    doSave();
                    break;
                case"DoBeside":
                    doBeside();
                    break;
                case"CancelBeside":
                    cancelBeside();
                    break;
                case"CancelPipe":
                    cancelPipe();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        /// <summary>
        /// 查询炉计划
        /// </summary>
        private void QuerySinglePlan()
        {
            string startTim = "";
            string endTim = "";
            string lotNo = "";
            string judgeNo = "";
            string nodeStaus = "";
            
            if (this.chkJugeHeatNo.Checked && this.txtJugeNo.Text.Trim() != "")
            {
                judgeNo = this.txtJugeNo.Text.Trim();
            }
            if (chkTim.Checked)
            {
                if (DateTime.Parse(StartTime.Value.ToString()) > DateTime.Parse(EndTime.Value.ToString()))
                {
                    MessageUtil.ShowTips("选择的前面时间不能大于后面的时间!");
                    return;
                }
                else
                {
                    startTim = this.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
                    endTim = this.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
                }
            }
            if (this.chkLotNo.Checked && this.txtLotNo.Text.Trim() != "")
            {
                lotNo = this.txtLotNo.Text.Trim();
            }
            nodeStaus = this.ultraOptionSet2.CheckedItem.DataValue.ToString();
            ArrayList parmList = new ArrayList();
            parmList.Add(startTim);
            parmList.Add(endTim);
            parmList.Add(lotNo);
            parmList.Add(judgeNo);
            parmList.Add(nodeStaus);
            List<PlnZyJgxMEntity> listSource = EntityHelper.GetData<PlnZyJgxMEntity>(
        "com.steering.mes.mcp.Vrp.FrmMchInStore.querySinglePlan", new object[] { parmList, plineCode }, this.ob);
            PlnZyJgxMEntitybindingSource.DataSource = listSource;

        }

        /// <summary>
        /// 查询交库实绩
        /// </summary>
        private void doQueryInList()
        {
            string lotNo = "";
            string jugeNo = "";
            string startTim = "";
            string endTim = "";
            if (this.chkpipeJudgeNo.Checked && this.pipeJudgeNo.Text.Trim() != "")
            {
                jugeNo = this.pipeJudgeNo.Text.Trim();
            }
            if(this.chkPipeLotNo.Checked && this.pipeLotNo.Text.Trim() != "")
            {
                lotNo = pipeLotNo.Text.Trim();
            }
            if (this.chkPipeTim.Checked)
            {
                if (DateTime.Parse(StartTime1.Value.ToString()) > DateTime.Parse(EndTime1.Value.ToString()))
                {
                    MessageUtil.ShowTips("选择的前面时间不能大于后面的时间!");
                    return;
                }
                else
                {
                    startTim = this.StartTime1.Value.ToString("yyyy-MM-dd");
                    endTim = this.EndTime1.Value.ToString("yyyy-MM-dd");
                }
            }
            ArrayList list = new ArrayList();
            list.Add(startTim);
            list.Add(endTim);
            list.Add(lotNo);
            list.Add(jugeNo);

            List<YdmBcInlistEntity> listSource = EntityHelper.GetData<YdmBcInlistEntity>(
         "com.steering.mes.mcp.Vrp.FrmMchInStore.doQueryInList", new object[] { list, plineCode }, this.ob);
            YdmBcInlistEntitybindingSource.DataSource = listSource;
        }

        /// <summary>
        /// 交库
        /// </summary>
        private void doSave()
        {
            this.ultraGrid2.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow == null)
            {
                return;
            }
            if (this.ultraGrid4.Rows.Count > 0)
            {
                foreach (UltraGridRow row in ultraGrid4.Rows)
                {
                    if (row.Cells["CHK2"].Text == "")
                    {
                        MessageUtil.ShowTips("有附加要求分项没有确认,不允许交库!");
                        return;
                    }
                }
            }

            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要交库的信息!");
                return;
            }
            List<PortMchBatchSampleResultEntity> parmList = new List<PortMchBatchSampleResultEntity>();
            foreach (UltraGridRow row in checkMagRows)
            {
                PortMchBatchSampleResultEntity portTity = (PortMchBatchSampleResultEntity)row.ListObject;
                if (portTity.PhyBatchNo.Equals(""))
                {
                    MessageUtil.ShowTips("性能批号为空,不允许交库!");
                    return;
                }
         
                if (!portTity.OutnumCut.Value.Equals(1))
                {
                    MessageUtil.ShowTips("没有分切完成,不允许交库!");
                    return;
                }
                if (portTity.IsSamplePipe.Equals("样管"))
                {
                    portTity.IsSamplePipe = "1";
                }
                else
                {
                    portTity.IsSamplePipe = "0";
                }
                parmList.Add(portTity);
            }

            if (parmList.Any(p => p.TrFlag != "1" && p.TrFlag != "是"))
            {
                if (MessageUtil.ShowYesNoAndQuestion("管未过测量点，是否仍然下线入库？?") == DialogResult.No)
                    return;
            }


            PlnZyJgxMEntity plnZyTity = (PlnZyJgxMEntity)uRow.ListObject;

            if (!string.IsNullOrEmpty(plnZyTity.PlineCodeW))
            {
                if (MessageUtil.ShowYesNoAndQuestion("该炉已经由委内到" + plnZyTity.PlineNameW + "; 若需返回原产线,请离线委内至原产线, 是否继续下线, 下线管所属权将属于" + plnZyTity.PlineNameW + "") == DialogResult.No)
                    return;
            }

            if(string.IsNullOrEmpty(plnZyTity.OutwlId))
            {
                MessageUtil.ShowTips("炉计划没有物料码, 不允许交库!");
                return;
            }
            string plnZyEntity = JSONFormat.Format(plnZyTity);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmMchInStore";
            ccp.MethodName = "doSave";
            ccp.ServerParams = new object[] { parmList.Select(JSONFormat.Format).ToList(), plnZyEntity, name.Text == "" ? UserInfo.GetUserName() : name.Text, UserInfo.GetDeptid(), cmbBc.SelectedIndex > -1 ? cmbBc.SelectedItem.DataValue.ToString2() : UserInfo.GetUserOrder(), cmbBz.SelectedIndex > -1 ? cmbBz.SelectedItem.DataValue.ToString2() : UserInfo.GetUserGroup() };
            ccp = ob.ExecuteNonQuery(ccp,CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("交库成功!"))
                {
                    QuerySinglePlan();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }

        /// <summary>
        /// 撤销交库
        /// </summary>
        private void cancelPipe()
        {
            this.ultraGrid3.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要撤销交库的信息!");
                return;
            }
            ArrayList parmList = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                YdmBcInlistEntity ydmBcTity = (YdmBcInlistEntity)row.ListObject;
                string ydmBcEntity = JSONFormat.Format(ydmBcTity);
                parmList.Add(ydmBcEntity);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmMchInStore";
            ccp.MethodName = "cancelPipe";
            ccp.ServerParams = new object[] { parmList };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("撤销成功!"))
                {
                    doQueryInList();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }


        /// <summary>
        /// 结炉
        /// </summary>
        private void doBeside()
        {
            this.ultraGrid1.UpdateData();
            UltraGridRow row = this.ultraGrid1.ActiveRow;
            if (row == null)
            {
                return;
            }
            PlnZyJgxMEntity plnEntity = (PlnZyJgxMEntity)row.ListObject;
            string plnTity = JSONFormat.Format(plnEntity);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmMchInStore";
            ccp.MethodName = "doBeside";
            ccp.ServerParams = new object[] { plnTity };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("结炉成功!"))
                {
                    QuerySinglePlan();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        /// <summary>
        /// 撤销结炉
        /// </summary>
        private void cancelBeside()
        {
            this.ultraGrid1.UpdateData();
            UltraGridRow row = this.ultraGrid1.ActiveRow;
            if (row == null)
            {
                return;
            }
            PlnZyJgxMEntity plnEntity = (PlnZyJgxMEntity)row.ListObject;
            string plnTity = JSONFormat.Format(plnEntity);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmMchInStore";
            ccp.MethodName = "cancelDoBeside";
            ccp.ServerParams = new object[] { plnTity };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("结炉回退成功!"))
                {
                    QuerySinglePlan();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }

        private void chkTim_CheckedChanged(object sender, EventArgs e)
        {
            this.StartTime.Enabled = this.EndTime.Enabled = this.chkTim.Checked;
        }

        private void chkLotNo_CheckedChanged(object sender, EventArgs e)
        {
            this.txtLotNo.Enabled = this.chkLotNo.Checked;
        }

        private void chkJugeHeatNo_CheckedChanged(object sender, EventArgs e)
        {
            this.txtJugeNo.Enabled = this.chkJugeHeatNo.Checked;
        }

        private void chkPipeTim_CheckedChanged(object sender, EventArgs e)
        {
            this.StartTime1.Enabled = this.EndTime1.Enabled = this.chkPipeTim.Checked;
        }

        private void chkPipeLotNo_CheckedChanged(object sender, EventArgs e)
        {
            this.pipeLotNo.Enabled = this.chkPipeLotNo.Checked;
        }

        private void chkpipeJudgeNo_CheckedChanged(object sender, EventArgs e)
        {
            this.pipeJudgeNo.Enabled = this.chkpipeJudgeNo.Checked;
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if(ultraTabControl1.SelectedTab.Key == "0")
            {
                if (toolMenu == null) return;
                if (toolMenu.Toolbars[0].Tools.Exists("DoQuery"))
                {
                    toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoSave"))
                {
                    toolMenu.Toolbars[0].Tools["DoSave"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoBeside"))
                {
                    toolMenu.Toolbars[0].Tools["DoBeside"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelBeside"))
                {
                    toolMenu.Toolbars[0].Tools["CancelBeside"].InstanceProps.Visible = DefaultableBoolean.True;
                }

                if (toolMenu.Toolbars[0].Tools.Exists("DoQueryInList"))
                {
                    toolMenu.Toolbars[0].Tools["DoQueryInList"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelPipe"))
                {
                    toolMenu.Toolbars[0].Tools["CancelPipe"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }else if(ultraTabControl1.SelectedTab.Key == "1")
            {
                if (toolMenu == null) return;
                if (toolMenu.Toolbars[0].Tools.Exists("DoQuery"))
                {
                    toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoSave"))
                {
                    toolMenu.Toolbars[0].Tools["DoSave"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoBeside"))
                {
                    toolMenu.Toolbars[0].Tools["DoBeside"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelBeside"))
                {
                    toolMenu.Toolbars[0].Tools["CancelBeside"].InstanceProps.Visible = DefaultableBoolean.False;
                }

                if (toolMenu.Toolbars[0].Tools.Exists("DoQueryInList"))
                {
                    toolMenu.Toolbars[0].Tools["DoQueryInList"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelPipe"))
                {
                    toolMenu.Toolbars[0].Tools["CancelPipe"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }

        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
          

            portMchBatchControl1.ob = ob;
            portMchBatchControl1.userName = this.UserInfo.GetUserName();
            portMchBatchControl1.Shift = this.UserInfo.GetUserOrder();
            portMchBatchControl1.Group = this.UserInfo.GetUserGroup();
            portMchBatchControl1.DisableFiltering();
            portMchBatchControl1.SetDeleteReason("701511");
            portMchBatchControl1.MchWasteChange += () => ultraGrid1_AfterRowActivate(null, null);

            cmbBc.Value = this.UserInfo.GetUserOrder();
            cmbBz.Value = this.UserInfo.GetUserGroup();
            name.Value = this.UserInfo.GetUserName();
            

        }

        private void FrmMchInStore_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null) return;
            if (toolMenu.Toolbars[0].Tools.Exists("DoQueryInList"))
            {
                toolMenu.Toolbars[0].Tools["DoQueryInList"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelPipe"))
            {
                toolMenu.Toolbars[0].Tools["CancelPipe"].InstanceProps.Visible = DefaultableBoolean.False;
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            this.ultraGrid1.UpdateData();
            UltraGridRow row = this.ultraGrid1.ActiveRow;
            if(row == null)
            {
                this.ultraGrid2.UpdateData();
                return;
            }
            doQueryVrpRack(row.Cells["HeatPlanNo"].Text, row.Cells["JudgeStoveNo"].Text, row.Cells["BatchNo"].Text);
            //下线  -701311
            portMchBatchControl1.Query(row.Cells["HeatPlanNo"].Text, row.Cells["BatchNo"].Text, "701311");

            var PlineCode = row.Cells["PlineCode"].Value.ToString2();
            if (_plineCode != PlineCode)
            {
                Names = EntityHelper.GetData<HttSignatureEntity>(
                    "com.steering.mes.mcp.heatTreatment.FrmHttCrackDetectResult.getHttSign",
                    new object[] { PlineCode, "11" }, ob);


                name.DisplayMember = "UserName";
                name.ValueMember = "UserName";
                _plineCode = PlineCode;
            }
            name.DataSource = Names.Where(p => p.ColGroup == (cmbBz.SelectedIndex>-1?cmbBz.SelectedItem.DataValue.ToString2():"")).ToList();

            //附加要求分项
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpApplyNew.QueryQcmAddAsk", new object[] { row.Cells["OrdLnDlyPk"].Text  }, ob);
            GridHelper.CopyDataToDatatable(dt, this.dataTable1, true);
            GridHelper.RefreshAndAutoSize(this.ultraGrid4);
        }

        private void doQueryVrpRack(string heatPlanNo, string judgeNo, string batchNo)
        {
            List<PortMchBatchSampleResultEntity> listSource = EntityHelper.GetData<PortMchBatchSampleResultEntity>(
          "com.steering.mes.mcp.Vrp.FrmMchInStore.doQueryVrpRack", new object[] { heatPlanNo, judgeNo, batchNo }, this.ob);
            PortMchBatchSampleResultEntitybindingSource.DataSource = listSource;
            foreach (UltraGridRow row in this.ultraGrid2.Rows)
            {
                row.Cells["CHK"].Value = "True";
            }
        }

        private void ultraGrid2_CellChange(object sender, CellEventArgs e)
        {
            UltraGridRow row  = this.ultraGrid2.ActiveRow;
            if (e.Cell.Column.Key == "ActCount")
            {
                if (!StringUtil.IsInt(row.Cells["ActCount"].Text))
                {
                    MessageUtil.ShowTips("支数应为整数!");
                    return;
                }
                DataTable ds = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmMchInStore.doQueryStausRack", new object[] { row.Cells["HeatPlanNo"].Text, row.Cells["JudgeStoveNo"].Text, row.Cells["PhyBatchNo"].Text, row.Cells["IsSamplePipe"].Text }, ob);
                if (int.Parse(row.Cells["ActCount"].Text) > int.Parse(ds.Rows[0][0].ToString()))
                {
                    MessageUtil.ShowTips("炉批下所输入交库支数不能大于能交库支数!");
                    return;
                }
                DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmMchInStore.doQueryStausRackWgt", new object[] { row.Cells["HeatPlanNo"].Text, row.Cells["JudgeStoveNo"].Text, row.Cells["PhyBatchNo"].Text, row.Cells["IsSamplePipe"].Text, row.Cells["ActCount"].Text }, ob);
                row.Cells["ActWeight"].Value = dt.Rows[0][0].ToString();
            }
        }

        private void cmbBz_ValueChanged(object sender, EventArgs e)
        {
            name.DataSource = Names.Where(p => p.ColGroup == (cmbBz.SelectedIndex > -1 ? cmbBz.SelectedItem.DataValue.ToString2() : "")).ToList();
        }

        private void ultraGrid4_ClickCell(object sender, ClickCellEventArgs e)
        {
            if (e.Cell.Column.Key == "CHK2")
            {
                if (e.Cell.Text.Trim() == "")
                {
                    e.Cell.Value = "√";
                }
                else
                {
                    e.Cell.Value = "";
                }
            }
            
        }
    }
}