MES_Client/TGMES/Core.StlMes.Client.Mcp/Coupling/FrmCouplingApplPro.cs

using com.steering.mes.mcp.entity;
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.BaseMethod;
using Core.StlMes.Client.Mcp.CollarMaterial;
using Core.StlMes.Client.Mcp.Common;
using Core.StlMes.Client.Mcp.Control;
using Core.StlMes.Client.Mcp.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.Coupling
{
    public partial class FrmCouplingApplPro : FrmBase
    {
        private string[] arr = null;
        private string[] starts = { };
        private string departm = "";//获取部门ID
        private string[] plineCode = null;//获取产线代码
        private string cutGx = "";//交库工序
        private string num = "";//支数
        private string pwt = "";//重量
        public FrmCouplingApplPro()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        private void FrmCouplingApplPro_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");
            EntityHelper.ShowGridCaption<CouplingMatMEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<Core.StlMes.Client.Mcp.Entity.PlnGxJgPropSEntity>(ultraGrid2.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<com.steering.mes.mcp.entity.QcmZgJugdeApplyEntity>(ultraGrid3.DisplayLayout.Bands[0]);
            this.IsLoadUserView = true;
            arr = this.ValidDataPurviewIds;
            //departm = UserInfo.GetDeptid();
            //plineCode = McpBaseHelper.GetPCodePline(departm, this.ob);
            ////获取交库工序
            //DataTable dt3 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700313" }, this.ob);
            //if (dt3.Rows.Count > 0)
            //{
            //    cutGx = dt3.Rows[0]["BASECODE"].ToString();
            //}
            //PipeManageClass.BindComBaseInfo(cmbStroage, this.ob);      
            QuerySinglePlan();
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "DoQuery":
                     if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        QuerySinglePlan(); 
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryZgJugdeApply();
                    }
                    break;
                case "DoDecision":
                    DoDecision();//转成品箍
                    break;
                case "cancelDoDecision":
                    cancelDoDecision();//撤销申请判定
                    break;
                
                    break;
                case "DoClose":
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 查询送判数据
        /// </summary>
        private void QueryZgJugdeApply()
        {

            string Woid = "";
            string jugeNo = "";
            string startTim = "";
            string endTim = "";
            ArrayList list = new ArrayList();

            if (this.chkwoId.Checked && this.txtWoId.Text.Trim() != "")
            {
                Woid = this.txtWoId.Text.Trim();
            }
            if (this.chkJuNo.Checked && this.txtJudgeStoveNO.Text.Trim() != "")
            {
                jugeNo = this.txtJudgeStoveNO.Text.Trim();
            }
            if (chkTim2.Checked)
            {
                if (DateTime.Parse(this.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");
                }
            }

            list.Add(startTim);
            list.Add(endTim);
            list.Add(jugeNo);
            list.Add(this.ultraOptionSet1.CheckedItem.DataValue.ToString());
            list.Add(Woid);
            QcmZgJudgebindingSource1.Clear();
            List<Core.StlMes.Client.Mcp.Entity.QcmZgJugdeApplyEntity> listSource = EntityHelper.GetData<Core.StlMes.Client.Mcp.Entity.QcmZgJugdeApplyEntity>(
            "com.steering.mes.mcp.coup.FrmCouplingApplPro.QueryZgJugdeApply", new object[] { list, arr }, this.ob);
            QcmZgbindingSource.DataSource = listSource;
           // WriteTextToGrid();

        }
        

        /// <summary>
        /// 撤销申请判定
        /// </summary>
        private void cancelDoDecision()
        {
            this.ultraGrid3.UpdateData();
            UltraGridRow uRow = this.ultraGrid3.ActiveRow;
            if (uRow == null) return;
            string plinCode = uRow.Cells["PlineCode"].Text.ToString();
            IQueryable<UltraGridRow> checkMags = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMags.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要撤销的成品箍信息!");
                return;
            }

            ArrayList parmList = new ArrayList();
            foreach (UltraGridRow row in checkMags)
            {
                Entity.QcmZgJugdeApplyEntity matBcEntity = (Entity.QcmZgJugdeApplyEntity)row.ListObject;
                string matEntity = JSONFormat.Format(matBcEntity);
                parmList.Add(matEntity);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmCouplingApplPro";
            ccp.MethodName = "cancelDoDecision";
            ccp.ServerParams = new object[] { parmList };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("撤销成功!"))
                {
                    string applyCode = ccp.ReturnObject.ToString();
                    QueryZgJugdeApply();
                    //this.txtMemo.Text = "";
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        private void QuerySinglePlan()
        {
            string Woid = "";
            string jugeNo = "";
            string startTim = "";
            string endTim = "";
            ArrayList list = new ArrayList();

            if (this.chkwoId.Checked && this.txtWoId.Text.Trim() != "")
            {
                Woid = this.txtWoId.Text.Trim();
            }
            if (this.chkJuNo.Checked && this.txtJudgeStoveNO.Text.Trim() != "")
            {
                jugeNo = this.txtJudgeStoveNO.Text.Trim();
            }
            if (chkTim2.Checked)
            {
                if (DateTime.Parse(this.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");
                }
            }

            list.Add(startTim);
            list.Add(endTim);
            list.Add(jugeNo);
            list.Add(this.ultraOptionSet1.CheckedItem.DataValue.ToString());
            list.Add(Woid);
            CouplingMatMbindingSource.Clear();
            List<CouplingMatMEntity> listSource = EntityHelper.GetData<CouplingMatMEntity>(
            "com.steering.mes.mcp.coup.FrmCouplingApplPro.doQueryMat", new object[] { list, arr }, this.ob);
            CouplingMatMbindingSource.DataSource = listSource;
            //double mater = 0.0;
            //double proWt = 0.0; 
            //double loadWt = 0.0;
            //foreach(UltraGridRow urg in ultraGrid1.Rows)
            //{
            //   proWt += Convert.ToDouble(urg.Cells["ProWt"].Value.ToString());
            //   loadWt += Convert.ToDouble(urg.Cells["RealBlWt"].Value.ToString());
            //}
            //mater = proWt / loadWt;
            //ultraGrid1.DisplayLayout.Bands[0].Summaries[9].DisplayFormat = Math.Round(mater*100, 2).ToString() + "%";


        }
        /// <summary>
        /// 编辑区Gird
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            string woid = "";
            string judgeNo = "";
            UltraGridRow urg = ultraGrid1.ActiveRow;
            if (urg == null)
            {
                return;
            }
            else
            {
                woid = urg.Cells["WoId"].Value.ToString();
                judgeNo = urg.Cells["JudgeStoveNo"].Value.ToString();
            }
            ultraGrid1.UpdateData();

            if (e.Cell.Column.Key.Equals("ProNum") && urg.Cells["ProNum"].Text != "")
            {
                if (num != "")
                {
                    urg.Cells["ProWt"].Value = (Convert.ToDouble(urg.Cells["ProNum"].Text) * (Convert.ToDouble(pwt) / Convert.ToDouble(num))).ToString("f3");
                }
                else
                {
                    MessageUtil.ShowTips("接箍库存为零，请检查!");
                    return;
                }
            }

            ArrayList list = new ArrayList();
            ArrayList array = new ArrayList();
            string spec = "";
            string codeJgBl = urg.Cells["CodeJgBl"].Value.ToString();
            IQueryable<UltraGridRow> checkMags = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            List<string> specs = new List<string>();
            foreach (UltraGridRow row in checkMags)
            {
                CouplingMatMEntity matBcEntity = (CouplingMatMEntity)row.ListObject;
                if (matBcEntity.SpecJgDesc == null || matBcEntity.SpecJgDesc.Equals(""))
                {
                    MessageUtil.ShowTips("接箍规格为空请检查!");
                    return;
                }              
                specs.Add(matBcEntity.SpecJgDesc);
            }
            //spec = "('" + string.Join("','", specs) + "')";
            spec = string.Join("','", specs);
            List<PlnGxJgPropSEntity> listSource = EntityHelper.GetData<PlnGxJgPropSEntity>(
         "com.steering.mes.mcp.coup.FrmCouplingApplPro.doQueryMat", new object[] { spec, codeJgBl }, this.ob);
            bindingSource1.DataSource = listSource;
        }
        /// <summary>
        /// 转成品箍
        /// </summary>
        private void DoDecision() 
        {
            this.ultraGrid1.UpdateData();
            this.ultraGrid2.UpdateData();
            UltraGridRow sRow = this.ultraGrid1.ActiveRow;
            if (sRow == null) return;
            string PlinCode = sRow.Cells["PlineCode"].Value.ToString();
            string judgeNo = sRow.Cells["JudgeStoveNo"].Value.ToString();
            string batchNo = sRow.Cells["BatchNo"].Value.ToString();
            IQueryable<UltraGridRow> checkMags = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMags.Count() == 0)
            {
                MessageUtil.ShowTips("请选择半成品箍信息!");
                return;
            }

            ArrayList parmList = new ArrayList();
            foreach (UltraGridRow row in checkMags)
            {

                CouplingMatMEntity matBcEntity = (CouplingMatMEntity)row.ListObject;
                //if (!matBcEntity.DeterNo.Equals(""))
                //{
                //    MessageUtil.ShowTips("炉批已进行送判，不允许重复送判!");
                //    return;
                //}
                if(Convert.ToInt64(matBcEntity.ProNum)>Convert.ToInt64(num))
                {
                    MessageUtil.ShowTips("转成品箍数量不能大于库存数量!");
                    return;
                }
                string specJg = "";
                UltraGridRow urg = ultraGrid2.ActiveRow;
                if (urg != null)
                {
                    specJg = urg.Cells["SpecJgDesc"].Text;
                }
                if (matBcEntity.SpecJgDesc != specJg)
                {
                    MessageUtil.ShowTips("半成品规格与所选合同规格不匹配!");
                    return;
                }
                string matEntity = JSONFormat.Format(matBcEntity);
                parmList.Add(matEntity);
            }
            ArrayList list = new ArrayList();
            UltraGridRow uug = ultraGrid2.ActiveRow;
            if(uug==null)
            {
                MessageUtil.ShowTips("请选择合同信息!");
                return;
            }
            else
            {
                PlnGxJgPropSEntity plnSaleEntity = (PlnGxJgPropSEntity)uug.ListObject;
                string plnEntity = JSONFormat.Format(plnSaleEntity);
                list.Add(plnEntity);
            }
            //IQueryable<UltraGridRow> checksMags = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
            //if (checksMags.Count() == 0)
            //{
            //    MessageUtil.ShowTips("请选择合同信息!");
            //    return;
            //}
         
            //foreach (UltraGridRow row in checksMags)
            //{
            //    PlnSaleordEntity plnSaleEntity = (PlnSaleordEntity)row.ListObject;
            //    string plnEntity = JSONFormat.Format(plnSaleEntity);
            //    list.Add(plnEntity);
            //}

            //if (!matBcEntity.DeterNo.Equals(""))
            //{
            //    MessageUtil.ShowTips("炉批已进行送判，不允许重复送判!");
            //    return;
            //}
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmCouplingApplPro";
            ccp.MethodName = "doDecision";
            ccp.ServerParams = new object[] { parmList,UserInfo.GetUserName(),list,num };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {

                if (ccp.ReturnInfo.Equals("转成品箍成功!"))
                {
                    QuerySinglePlan();
                    MessageUtil.ShowTips("转成品箍成功!");
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        /// <summary>
        /// ultraGrid2 触发事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null)
            {
                //List<CouplingComInfoEntity> listSource = new List<Entity.CouplingComInfoEntity>();
                //CouplingComInfoEntity.DataSource = listSource;
                //GridHelper.RefreshAndAutoSize(ultraGrid3);

            }
            else
            {
                //List<CouplingComInfoEntity> listSource = EntityHelper.GetData<CouplingComInfoEntity>
                //    ("com.steering.mes.mcp.coup.FrmInLibrary.doQueryInfoResult", new object[] { row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() }, this.ob);
                //CouplingComInfoEntity.DataSource = listSource;
                //GridHelper.RefreshAndAutoSize(ultraGrid3);

            }
        }
   
        private void chkStarts_CheckedChanged(object sender, EventArgs e)
        {
            if (chkJuNo.Checked) { txtJudgeStoveNO.Enabled = true; } else { txtJudgeStoveNO.Enabled = false; }
           // if (chkPlnNo.Checked) { txtPlnNo.Enabled = true; } else { txtPlnNo.Enabled = false; }
            if (chkwoId.Checked) { txtWoId.Enabled = true; } else { txtWoId.Enabled = false; }
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                chkTim2.Text = "入库日期";
                toolMenu.Toolbars[0].Tools["DoDecision"].InstanceProps.Visible = DefaultableBoolean.True;
                toolMenu.Toolbars[0].Tools["cancelDoDecision"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                chkTim2.Text = "送判日期";
                toolMenu.Toolbars[0].Tools["DoDecision"].InstanceProps.Visible = DefaultableBoolean.False;
                toolMenu.Toolbars[0].Tools["cancelDoDecision"].InstanceProps.Visible = DefaultableBoolean.True;
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            QueryPlnOrd();
        }

        private void QueryPlnOrd()
        {
            UltraGridRow urg = ultraGrid1.ActiveRow;
            string spec = urg.Cells["SpecJgDesc"].Value.ToString();
            string codeJgBl = urg.Cells["CodeJgBl"].Value.ToString();
            List<PlnGxJgPropSEntity> listSource = EntityHelper.GetData<PlnGxJgPropSEntity>
                ("com.steering.mes.mcp.coup.FrmCouplingApplPro.doQueryplnSaleorder", new object[] { spec, codeJgBl }, this.ob);
            bindingSource1.DataSource = listSource;
            GridHelper.RefreshAndAutoSize(ultraGrid2);
            UltraGridRow row = ultraGrid1.ActiveRow;
            if(row==null)
            {
                return;
            }
            else
            {
                num = row.Cells["ProNum"].Text.ToString();
                pwt = row.Cells["ProWt"].Text.ToString();
            }

        }
        /// <summary>
        /// 查询炉批信息
        /// </summary>
        //   private void doQueryJudgeBath(string woid, string judgeNo, string jugdeApplyCode)
        //   {
        //       UltraGridRow uRow = this.ultraGrid1.ActiveRow;
        //       if (uRow == null)
        //       {
        //           return;
        //       }
        //       List<CouplingMatMEntity1> listSource = EntityHelper.GetData<CouplingMatMEntity1>(
        //       "com.steering.mes.mcp.coup.FrmCouplingApplPro.doQueryJudgeBath", new object[] { woid, judgeNo, jugdeApplyCode, this.ultraOptionSet1.CheckedItem.DataValue.ToString() }, this.ob);
        //       CouplingMatMbindingSource1.DataSource = listSource;
        //       foreach (UltraGridRow row in this.ultraGrid2.Rows)
        //       {
        //           row.Cells["CHK"].Value = "True";
        //           row.Update();
        //       }
        //       List<Core.StlMes.Client.Mcp.Entity.QcmZgJugdeApplyEntity> listSource1 = EntityHelper.GetData<Core.StlMes.Client.Mcp.Entity.QcmZgJugdeApplyEntity>(
        //"com.steering.mes.mcp.coup.FrmCouplingApplPro.doQueryQcmZgApplyData", new object[] { uRow.Cells["JudgeStoveNo"].Text }, this.ob);
        //       if(listSource1.Count>0)
        //       {
        //           ultraGrid2.DisplayLayout.Bands[0].Columns["isFlag"].Header.Caption = "前工序是否紧急放行";
        //           foreach (UltraGridRow row in this.ultraGrid2.Rows)
        //           {
        //               row.Cells["isFlag"].Value = "是";
        //           }
        //       }
        //       else
        //       {
        //           ultraGrid2.DisplayLayout.Bands[0].Columns["isFlag"].Header.Caption = "前工序是否紧急放行";
        //           foreach (UltraGridRow row in this.ultraGrid2.Rows)
        //           {
        //               row.Cells["isFlag"].Value = "否";
        //           }
        //       }
        //   }

        private void ultraGrid3_ClickCellButton(object sender, CellEventArgs e)
        {
            this.ultraGrid3.UpdateData();
            if (e.Cell.Column.Key == "JugdeApplyCode")
            {
                string jugdeApplyCode = ultraGrid3.ActiveRow.Cells["JugdeApplyCode"].Value.ToString();
                string judgeStoveNo = ultraGrid3.ActiveRow.Cells["JudgeStoveNo"].Value.ToString();
                string ordenNo = ultraGrid3.ActiveRow.Cells["ProOrderNo"].Value.ToString();
                FrmQcmAddAsk orderZg = new FrmQcmAddAsk(jugdeApplyCode, judgeStoveNo, ordenNo, this.ob);
                orderZg.ShowDialog();

            }
        }

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

    }
}