MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/炉计划/FrmRollTubeLibraryDbk.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.PlnSaleOrd.BaseMethod;
using Core.StlMes.Client.PlnSaleOrd.工序排产;
using Core.StlMes.Client.PlnSaleOrd.工序排产.entity;
using Core.StlMes.Client.PlnSaleOrd.炼钢计划;
using Core.StlMes.Client.PlnSaleOrd.炉计划.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.PlnSaleOrd.炉计划
{
    public partial class FrmRollTubeLibraryDbk : FrmBase
    {
        private string[] plineCode = null;//获取产线代码
        DataTable dtPlinGroup = null;
        private string _ProPlanId = "";
        private string _GxPlanNo = "";
        public FrmRollTubeLibraryDbk()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        private void FrmRollTubeLibraryDbk_Load(object sender, EventArgs e)
        {
            EntityHelper.ShowGridCaption<MatBcTrackEntity>(entityGrid1.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PlnOrderDbkSOEntity>(ultraGridDbks.DisplayLayout.Bands[0]);
            BaseHelper.setUltraGridColumnMaxInput(ultraGridDbks, new string[] { "WeigthS", "MinWgt" });
            BaseHelper.InitCellPosition(ultraGridDbks, new string[] {"CountNum", "GxPlanNo", "OrderSeq", "DeliveryNo", "WeigthS", "NumS", "PlanUsetime", "GxProSeq", "PlnDivideId", "Outdiameter", "Wallthick", "Lengthmax", "Lengthmin", "Aimlength",
                "OutdiameterIn", "WallthickIn", "LengthmaxIn", "LengthminIn", "Aimoutdiameter", "Aimwallthick", "LenCuthead", "LenCutend" ,"AddWtIn","AddNumIn","MatchWtIn","MatchNumIn",           "BatchedWt","BatchedNum","Finishweight","Finishnum","InNumS","InWeightS","FinishWgt","UnfinishWgt","UnfinishNum","MinWgt","RealBatchWt","RealBatchNum","StockNumMononer","StockNumLiku"});
            BaseHelper.GridColumnSum(ultraGridDbks, new string[] { "WeigthS" });
            BaseHelper.GridColumnCount(ultraGridDbks, new string[] { "NumS" });
            BaseHelper.InitCellPositionMiddle(ultraGridDbks, new string[] { "IsRepairPln", "Isendgx", "IfMonitorDbk", "IsPlanOk", "IfStoveIssued", "IfZyReady", "IfZyM", "IsOnloadLine" });
            BaseHelper.setUltraGridColumnColor(ultraGridDbks, new string[] { "CraftFileNo", "CraftFileLv2G" }, Color.GreenYellow);
            plineCode = PlanHelper.InitDropPlinePower("E", comPline, this.ValidDataPurviewIds, this.ob);
            PlanHelper.InitRepairType(ultraGridDbks, this);
            PlanHelper.InitEditPline("E", "", ultraGridDbks, this);
            BaseHelper.setOtherColumnReadOnly(ultraGridDbks, new string[] { "CHC", "PlanTimeB", "RepairType", "PlanUsetime", "PlineCode", "Memo" });
            BaseHelper.setColumnBackColor(ultraGridDbks, new string[] { "StockNumLiku" });
            ultraGridDbks.DisplayLayout.Bands[0].Columns["StockNumLiku"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Button;

            EntityHelper.ShowGridCaption<PlnZyDbkMEntity>(ultraGridZyD.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PlnZyDbkCEntity>(ultraGridZyD.DisplayLayout.Bands[1]);
            BaseHelper.setOtherColumnReadOnly(ultraGridZyD, new string[] { "CHC" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGridZyD, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW" });
            BaseHelper.setUltraGridColumnBits(ultraGridZyD, new string[] { "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" });
            BaseHelper.InitCellPosition(ultraGridZyD, new string[] { "GxProSeq", "GxPlanNo","OrderSeq", "DeliveryNo", "PlnInsingleNum", "PlnInsingleWt",  "PlnIndoubleNum","PlnIndoubleWt","PlnOutsingleNum","PlnOutsingleW" ,"PlnOutdoubleNum","PlnOutdoubleW","OutdiameterIn","WallthickIn","LengthIn","LengthmaxIn",
                "LengthminIn","OutnumCut","Aimoutdiameter","Aimwallthick","AimlengthMax","Aimlength","AimlengthMin","LenCutend","LenCuthead","CraftSeq"});
            BaseHelper.GridColumnSum(ultraGridZyD, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW" });
            BaseHelper.GridColumnCount(ultraGridZyD, new string[] { "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" });
            SteelHelper.ForbidSort(ultraGridZyD);
            BaseHelper.InitCellPositionC(ultraGridZyD, new string[] { "GxPlanNo", "OutdiameterIn", "WallthickIn", "OutnumCut", "LengthIn", "LengthmaxIn", "LengthminIn",  "PlanIndoubleNum", "PlanIndoubleWt", "RealIndoubleNum", "RealIndoubleWt", "RealOutdoubleNum", "RealOutdoubleWt" });
  
 
            txtPlanTimeE1.Value = DateTime.Now.ToString("yyyy-MM");
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query"://查询
                    Query();
                    break;
               case "TakeSingle"://删除
                     DoDelete();
                    //DoTakeSingle();
                    break;
                case "Close": //关闭
                    this.Close();
                    break;
                default:
                    break;
            }
        }
        private void chcPline_CheckedChanged(object sender, EventArgs e)
        {
            if (chcPline.Checked) { comPline.Enabled = true; } else { comPline.Enabled = false; }
            if (chcOrderNo.Checked) { txtOrderNo.Enabled = true; } else { txtOrderNo.Enabled = false; }
            if (chcProPlanId.Checked) { txtProPlanId.Enabled = true; } else { txtProPlanId.Enabled = false; }
            if (chcPlanTimeE.Checked) { txtPlanTimeE1.Enabled = true; } else { txtPlanTimeE1.Enabled = false; }
            if (chcSyte.Checked) { txtSyte.Enabled = true; } else { txtSyte.Enabled = false; }
            if (chcJudgeNo.Checked) { txtJudgeNo.Enabled = true; } else { txtJudgeNo.Enabled = false; }
        }
        //查询
        private void Query()
        {
            if (ultraTabControl1.SelectedTab.Key.Equals("0"))
            {
                QueryZg();
            }
            else
            {
                QueryLk();
            }
        }
        private List<PlnOrderDbkSOEntity> listSource = null;
        private void QueryZg()
        {
            //产线
            string comPlineCode = "";
            if (chcPline.Checked)
            {
                comPlineCode = comPline.Value == null ? "" : comPline.Value.ToString();
            }
            WaitingForm2 wf3 = new WaitingForm2("正在刷新，请稍候....");
            try
            {
                this.Cursor = Cursors.WaitCursor;
                //执行状态
                string[] statusArr = contorlPlanStatus1.statusArr;
                //合同号
                string orderNo = "";
                if (chcOrderNo.Checked) { orderNo = txtOrderNo.Text.Trim(); }
                string proPlanId = "";
                if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); }
                string planTimeE1 = "";
                if (chcPlanTimeE.Checked && txtPlanTimeE1.Value != null)
                {
                    planTimeE1 = DateTime.Parse(txtPlanTimeE1.Value.ToString()).ToString("yyyy-MM");
                }
                if (plineCode == null)
                {
                    MessageUtil.ShowTips("该用户没有镦拔扩产线查看权限！");
                    return;
                }
                listSource = null;
                listSource = EntityHelper.GetData<PlnOrderDbkSOEntity>
                ("com.steering.pss.plnsaleord.planStove.FrmRollTubeLibraryDbk.queryPlanOrderD", new object[] { plineCode, proPlanId, orderNo, statusArr, planTimeE1, comPlineCode }, this.ob);
                plnOrderDbkSOEntityBindingSource.DataSource = listSource;
              
                //激活操作行代码
                foreach (UltraGridRow ugr in ultraGridDbks.Rows)
                {
                    if (!_ProPlanId.Equals("") && !_GxPlanNo.Equals(""))
                    {
                        if (ugr.Cells["ProPlanId"].Text.Trim().Equals(_ProPlanId) && ugr.Cells["GxPlanNo"].Text.Trim().Equals(_GxPlanNo))
                        {
                            ugr.Activate();
                            break;
                        }
                    }
                }
                _ProPlanId = "";
                _GxPlanNo = "";
            }
            finally 
            {
                wf3.Close();
                this.Cursor = Cursors.Default;
            }
        }
        /// <summary>
        /// 利库日志查询
        /// </summary>
        private void QueryLk()
        {
            string styeSj = "";
            string judgeNo = "";
            if (chcSyte.Checked)
            {
                if (txtSyte.Text.ToString().Trim().Equals(""))
                {
                    MessageUtil.ShowTips("事件类型不能为空,请选择!");
                    return;
                }else
                {
                    styeSj = txtSyte.Text.ToString();
                }
            }
            if (chcJudgeNo.Checked)
            {
                if (txtJudgeNo.Text.ToString().Trim().Equals(""))
                {
                    MessageUtil.ShowTips("判定炉号不能为空,请选择!");
                    return;
                }
                else
                {
                    judgeNo = txtJudgeNo.Text.ToString();
                }
            }
            List<MatBcTrackEntity> listSource = EntityHelper.GetData<MatBcTrackEntity>
               ("com.steering.pss.plnsaleord.planStove.FrmRollTubeLibraryDbk.queryMatGpTrack", new object[] { styeSj, judgeNo }, this.ob);
            matBcTrackEntityBindingSource.DataSource = listSource;
            GridHelper.RefreshAndAutoSize(entityGrid1);
        }
        /// <summary>
        /// 删除炉计划
        /// </summary>
        private void DoDelete()
        {
            UltraGridRow row = ultraGridZyD.ActiveRow;
            if (row == null) { MessageUtil.ShowTips("无炉计划信息!"); return; }
            UltraGridRow rowzG = ultraGridDbks.ActiveRow;
            _ProPlanId = rowzG.Cells["ProPlanId"].Text.ToString();
            _GxPlanNo = rowzG.Cells["GxPlanNo"].Text.ToString();
            ArrayList list = new ArrayList();
            int countChc = 0;
            foreach (UltraGridRow urg in ultraGridZyD.Rows)
            {
                ArrayList list1 = new ArrayList();
                if (Convert.ToBoolean(urg.Cells["CHC"].Text) == true && !urg.HasParent())
                {
                    countChc++;
                    if (!urg.Cells["Planstatus"].Text.ToString().Trim().Equals("计划"))
                    {
                        MessageUtil.ShowTips("您选择炉计划已不是计划状态,不能删除炉计划!");
                        return;
                    }

                    list1.Add(urg.Cells["HeatPlanNo"].Text.ToString().Trim());
                    list.Add(list1);
                }
            }
            if (countChc == 0)
            {
                MessageUtil.ShowTips("请勾选炉计划主信息!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认删除炉计划?") ==
      DialogResult.No)
                return;
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmRollTubeLibraryDbk";
            ccp.MethodName = "doDelete";
            ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName()};
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("删除成功!"))
            {
                QueryZg();
                //QueryPlnZgM(_ProPlanId, _GxPlanNo);
            }
        }       
        /// <summary>
        /// 订单信息触发事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGridDbks_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow row = ultraGridDbks.ActiveRow;
            if (row == null) return;

            QueryPlnZgM(row.Cells["ProPlanId"].Value.ToString(), row.Cells["GxPlanNo"].Value.ToString());
        }

        /// <summary>
        /// 查询轧管订单对应炉计划
        /// </summary>
        /// <param name="proPlanId"></param>
        /// <param name="gxPlanNo"></param>
        private void QueryPlnZgM(string proPlanId, string gxPlanNo)
        {
            List<PlnZyDbkMEOntity> listSourceM = EntityHelper.GetData<PlnZyDbkMEOntity>
         ("com.steering.pss.plnsaleord.planStove.FrmRollTubeLibraryDbk.queryPlanStoveD", new object[] { proPlanId, gxPlanNo }, ob);
            List<PlnZyDbkCEntity> listSourceC = EntityHelper.GetData<PlnZyDbkCEntity>
                ("com.steering.pss.plnsaleord.planStove.FrmRollTubeLibraryDbk.queryPlanStoveDc", new object[] { proPlanId, gxPlanNo }, ob);
            EntityHelper.AddEntityRelation<PlnZyDbkMEOntity, PlnZyDbkCEntity>(listSourceM, listSourceC, "HeatPlanNo", "HeatPlanNo");
            plnZyDbkEOntityBindingSource.DataSource = listSourceM;
            GridHelper.RefreshAndAutoSize(ultraGridZyD);
        }

        private void ultraGridDbks_ClickCellButton(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGridDbks.ActiveRow;
            if (row == null) return;
            if (e.Cell.Column.Key.Equals("StockNumLiku"))
            {

                string exeStatus = row.GetValue("ExeStatus");
                //if (!exeStatus.Equals("计划")&& !exeStatus.Equals("生产中"))
                //{
                //    return;
                //}
                string porderstatus = "";//合同状态
                DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.doQueryPorderstatus", new object[] { row.Cells["OrdLnDlyPk"].Text.Trim() }, ob);
                if (dt.Rows.Count > 0)
                {
                    porderstatus = dt.Rows[0]["PORDERSTATUS"].ToString();
                }
                if (porderstatus.Equals("4") || porderstatus.Equals("5"))
                {
                    MessageUtil.ShowTips("该合同已生产完成或关闭，请联系销售！");
                    return;
                }
                string proPlanId = row.GetValue("ProPlanId");
                string gxPlanNo = row.GetValue("GxPlanNo");
                string supplyUnitCode = row.GetValue("SupplyUnitCode");
                FrmPlanMaterialDbk frmPlanMat = new FrmPlanMaterialDbk(proPlanId, gxPlanNo, this.UserInfo.GetUserName(), this.ob, exeStatus, supplyUnitCode);
                frmPlanMat.ShowDialog();
                bool flag = frmPlanMat.Flag;
                if (flag) { Query(); }//如果有修改数据，则刷新页面
            }
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;

            if (e.Tab.TabControl.SelectedTab.Key.Equals("0"))
            {
                if (toolMenu.Toolbars[0].Tools.Exists("TakeSingle")) { toolMenu.Toolbars[0].Tools["TakeSingle"].InstanceProps.Visible = DefaultableBoolean.True; }
            }
            else
            {
                if (toolMenu.Toolbars[0].Tools.Exists("TakeSingle")) { toolMenu.Toolbars[0].Tools["TakeSingle"].InstanceProps.Visible = DefaultableBoolean.False; }
            }
        }

        private void FrmRollTubeLibraryDbk_Shown(object sender, EventArgs e)
        {
            if (toolMenu.Toolbars[0].Tools.Exists("TakeSingle")) { toolMenu.Toolbars[0].Tools["TakeSingle"].InstanceProps.Visible = DefaultableBoolean.True; }
        }

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

        /// <summary>
        /// 过滤可排产量
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void chcPlaned_CheckedChanged(object sender, EventArgs e)
        {
            UltraGridRow row = ultraGridDbks.ActiveRow;
            if (row == null) return;
            ultraGridDbks.UpdateData();
            if (chcPlaned.Checked)
            {
                GridHelper.AddUlGridFilter(ultraGridDbks);
                plnOrderDbkSOEntityBindingSource.DataSource = listSource.Where(w => w.ReallWt > 0).ToList();
            }
            else
            {
                plnOrderDbkSOEntityBindingSource.DataSource = listSource;
            }
            ultraGridDbks.Refresh();
            ultraGridDbks.Update();
        }

       
      }
}