using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Format; 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.炉计划.Tool; 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 FrmPlanStoveE : FrmBase { private ArrayList _EntityList = null; private string[] plineCode = null;//获取产线代码 /// /// 虚拟炉计划id /// private string _heatPlanNo = ""; /// /// 行首背景色 /// private Color _backColor = new Color(); public FrmPlanStoveE() { this.IsLoadUserView = true; InitializeComponent(); } private void FrmPlanStoveE_Load(object sender, EventArgs e) { //订单排产 EntityHelper.ShowGridCaption(ultraGridZyE.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); //BaseHelper.setOtherColumnReadOnly(ultraGridZyE, new string[] { "CHC" }); BaseHelper.setUltraGridColumnMaxInput(ultraGridZyE, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW" }); BaseHelper.setUltraGridColumnBits(ultraGridZyE, new string[] { "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" }); BaseHelper.InitCellPosition(ultraGridZyE, 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(ultraGridZyE, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW" }); BaseHelper.GridColumnCount(ultraGridZyE, new string[] { "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" }); //BaseHelper.InitCellPositionMiddle(ultraGridZyE, new string[] { "Isendgx", "IfWlMatched", "IfMonitorZg" }); plineCode = PlanHelper.InitDropPlinePower("E", txtLine, this.ValidDataPurviewIds, this.ob); StoveHelper.ForbidSort(ultraGridZyE); //BaseHelper.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHC" }); BaseHelper.setUltraGridColumnMaxInput(ultraGrid1, new string[] { "RealOutdoubleWt", "RealIndoubleWt", "PlanIndoubleWt"}); BaseHelper.setUltraGridColumnBits(ultraGrid1, new string[] { "RealOutdoubleNum", "RealIndoubleNum", "PlanIndoubleNum"}); BaseHelper.InitCellPosition(ultraGrid1, 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","RealOutdoubleWt", "RealIndoubleWt", "RealOutdoubleNum", "RealIndoubleNum"}); BaseHelper.GridColumnSum(ultraGrid1, new string[] { "RealOutdoubleWt", "RealIndoubleWt", "PlanIndoubleWt" }); BaseHelper.GridColumnCount(ultraGrid1, new string[] { "RealOutdoubleNum", "RealIndoubleNum", "PlanIndoubleNum" }); StoveHelper.ForbidSort(ultraGrid1); InitDate(); BaseHelper.SetGroupBySum(ultraGrid1, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW", "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" }, "HeatPlanNo"); InitDate(); BaseHelper.InitComboEditor(ultraComboEditor1, "com.steering.pss.plnsaleord.planStove.FrmPlanStoveD.doQueryStorageNo", "STORAGE_NO", ob, true); } private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e) { StoveHelper.CustomMergedCellEvaluator merge = new StoveHelper.CustomMergedCellEvaluator("HeatPlanNo"); e.Layout.Bands[0].Columns["HeatPlanNo"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["HeatPlanNo"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["JudgeStoveNo"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["JudgeStoveNo"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["StoveNo"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["StoveNo"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnInsingleWt"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnInsingleWt"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnIndoubleWt"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnIndoubleWt"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnOutdoubleW"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnOutdoubleW"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnIndoubleNum"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnIndoubleNum"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnOutdoubleNum"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnOutdoubleNum"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["ZyBatchId"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["ZyBatchId"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["GxProSeq"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["GxProSeq"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["Planstatus"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["Planstatus"].MergedCellEvaluator = merge; } /// /// 初始时间 /// private void InitDate() { DateTime datetime = DateTime.Now; dateBegin.Value = datetime.AddDays(1 - datetime.Day); dateEnd.Value = datetime.AddDays(1 - datetime.Day).AddMonths(1).AddDays(-1); } private void chcLine_CheckedChanged(object sender, EventArgs e) { if (chcLine.Checked) { txtLine.Enabled = true; } else { txtLine.Enabled = false; } if (chcProPlanId.Checked) { txtProPlanId.Enabled = true; } else { txtProPlanId.Enabled = false; } if (chcOrderNo.Checked) { txtOrderNo.Enabled = true; } else { txtOrderNo.Enabled = false; } if (chcId.Checked) { txtId.Enabled = true; } else { txtId.Enabled = false; } if (chcTime.Checked) { dateBegin.Enabled = true; dateEnd.Enabled = true; } else { dateBegin.Enabled = false; dateEnd.Enabled = false; } if (chcJudgeNo.Checked) { txtJudgeNo.Enabled = true; } else { txtJudgeNo.Enabled = false; } if (txtFeedCheck.Checked) { txtFeedHeatNo.Enabled = true; } else { txtFeedHeatNo.Enabled = false; } } public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query"://查询 Query(); break; case "UpdateGoWhere": updateGoWhere(); break; case "UpdateLoadFlag": updateLoadFlag(); break; case"UpdateIsWeight": updateIsWeight(); break; case "Export": //导出 Export(); break; case "Close": //关闭 this.Close(); break; default: break; } } /// /// 标记是否过磅 /// private void updateIsWeight() { this.ultraGridZyE.UpdateData(); UltraGridRow row = this.ultraGridZyE.ActiveRow; if (row == null) { return; } ArrayList parmList = new ArrayList(); PlnZyDbkMEntity plnDbkTity = (PlnZyDbkMEntity)row.ListObject; string plnZgEntity = JSONFormat.Format(plnDbkTity); parmList.Add(plnZgEntity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveE"; ccp.MethodName = "updateIsWeight"; ccp.ServerParams = new object[] { parmList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("修改成功!")) { QueryM(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 标识库位不变 /// private void updateLoadFlag() { this.ultraGridZyE.UpdateData(); UltraGridRow row = this.ultraGridZyE.ActiveRow; if (row == null) { return; } ArrayList parmList = new ArrayList(); PlnZyDbkMEntity plnDbkTity = (PlnZyDbkMEntity)row.ListObject; string plnZgEntity = JSONFormat.Format(plnDbkTity); parmList.Add(plnZgEntity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveE"; ccp.MethodName = "updateLoadFlag"; ccp.ServerParams = new object[] { parmList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("修改成功!")) { QueryM(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 修改去向 /// private void updateGoWhere() { this.ultraGridZyE.UpdateData(); UltraGridRow row = this.ultraGridZyE.ActiveRow; if (row == null) { return; } ArrayList parmList = new ArrayList(); PlnZyDbkMEntity plnDbkTity = (PlnZyDbkMEntity)row.ListObject; plnDbkTity.GowhereCode = row.Cells["GowhereCode"].Value.ToString(); plnDbkTity.GowhereName = row.Cells["GowhereCode"].Text.ToString(); string plnZgEntity = JSONFormat.Format(plnDbkTity); parmList.Add(plnZgEntity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveE"; ccp.MethodName = "updateGoWhere"; ccp.ServerParams = new object[] { parmList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("修改成功!")) { QueryM(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } private void Query() { if (ultraExpandableGroupBox1.Expanded == false) { QueryC(); } else { QueryM(); } } private int activation = 0; /// /// 导出 /// private void Export() { if (activation < 2) { GridHelper.ulGridToExcel(ultraGridZyE, "镦拔扩炉计划主信息"); } else { GridHelper.ulGridToExcel(ultraGrid1, "镦拔扩炉计划详情"); } } /// /// 查询镦拔虚拟炉计划 /// private void QueryM() { //产线 string plineCode = ""; if (chcLine.Checked) { plineCode = txtLine.Value == null ? "" : txtLine.Value.ToString(); } //if (txtLine.Text.Equals("")) //{ // MessageUtil.ShowTips("请选择产线!"); // return; //} string timeBegin = ""; string timeEnd = ""; if (chcTime.Checked && dateBegin.Value != null && dateEnd.Value != null) { timeBegin = DateTime.Parse(dateBegin.Value.ToString()).ToString("yyyy-MM-dd"); timeEnd = DateTime.Parse(dateEnd.Value.ToString()).ToString("yyyy-MM-dd"); } string orderNo = ""; if (chcOrderNo.Checked) { orderNo = txtOrderNo.Text.Trim(); } string proPlanId = ""; if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); } string heatId = ""; if (chcId.Checked) { heatId = txtId.Text.Trim(); } string judgeNo = ""; if (chcJudgeNo.Checked) { judgeNo = txtJudgeNo.Text.Trim(); } string feedNo = ""; if (txtFeedCheck.Checked) { feedNo = txtFeedHeatNo.Text.Trim(); } //执行状态 string[] statusArr = contorlPlanStatusZy1.statusArr; List listSource = EntityHelper.GetData ("com.steering.pss.plnsaleord.planStove.FrmPlanStoveE.queryPlanStoveYzE", new object[] { timeBegin, timeEnd, plineCode, orderNo, proPlanId, heatId, statusArr, judgeNo, feedNo }, this.ob); plnZyDbkMEntityBindingSource.DataSource = listSource; foreach (UltraGridRow ugr in ultraGridZyE.Rows) { int countMess = 0; if (!_heatPlanNo.Equals("")) { if (ugr.Cells["HeatPlanNo"].Text.Trim().Equals(_heatPlanNo)) { ugr.Activate(); break; } } if (_EntityList != null) { for (int i = 0; i < _EntityList.Count; i++) { PlnZyDbkMEntity entity = (PlnZyDbkMEntity)_EntityList[i]; if (ugr.Cells["HeatPlanNo"].Text.Trim().Equals(entity.HeatPlanNo)) { ugr.Appearance.BackColor = Color.Wheat; ugr.Activate(); } } } } _EntityList = null; _heatPlanNo = ""; } /// /// 查询镦拔扩实际炉计划 /// private void QueryC() { //产线 string plineCode = ""; if (chcLine.Checked) { plineCode = txtLine.Value == null ? "" : txtLine.Value.ToString(); } //if (txtLine.Text.Equals("")) //{ // MessageUtil.ShowTips("请选择产线!"); // return; //} string timeBegin = ""; string timeEnd = ""; if (chcTime.Checked && dateBegin.Value != null && dateEnd.Value != null) { timeBegin = DateTime.Parse(dateBegin.Value.ToString()).ToString("yyyy-MM-dd"); timeEnd = DateTime.Parse(dateEnd.Value.ToString()).ToString("yyyy-MM-dd"); } string orderNo = ""; if (chcOrderNo.Checked) { orderNo = txtOrderNo.Text.Trim(); } string proPlanId = ""; if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); } string heatId = ""; if (chcId.Checked) { heatId = txtId.Text.Trim(); } string judgeNo = ""; if (chcJudgeNo.Checked) { judgeNo = txtJudgeNo.Text.Trim(); } string feedNo = ""; if (txtFeedCheck.Checked) { feedNo = txtFeedHeatNo.Text.Trim(); } //执行状态 string[] statusArr = contorlPlanStatusZy1.statusArr; List listSource = EntityHelper.GetData ("com.steering.pss.plnsaleord.planStove.FrmPlanStoveE.queryPlnZyDbkReadyById", new object[] { timeBegin, timeEnd, plineCode, orderNo, proPlanId, heatId, statusArr, judgeNo, feedNo }, this.ob); plnZyDbkReadyEntityBindingSource.DataSource = listSource; foreach (UltraGridRow ugr in ultraGrid1.Rows) { //没有实际炉计划,主炉计划变颜色 if (ugr.Cells["HeatPlanSqe"].Value.ToString().Equals("")) { //ugr.RowSelectorAppearance.BackColor = Color.GreenYellow; ugr.Appearance.BackColor = Color.Orange; } } } private void ultraGridZyE_AfterRowActivate(object sender, EventArgs e) { UltraGridRow row = ultraGridZyE.ActiveRow; if (row == null) return; QueryMRow(row.Cells["HeatPlanNo"].Text.ToString().Trim()); } private void QueryMRow(string heatPlanNo) { List listSourceM = EntityHelper.GetData ("com.steering.pss.plnsaleord.planStove.FrmPlanStoveE.queryPlanStoveRow", new object[] { heatPlanNo }, ob); plnZyDbkReadyEntityBindingSource.DataSource = listSourceM; foreach (UltraGridRow ugr in ultraGrid1.Rows) { //没有实际炉计划,主炉计划变颜色 if (ugr.Cells["HeatPlanSqe"].Value.ToString().Equals("")) { //ugr.RowSelectorAppearance.BackColor = Color.GreenYellow; ugr.Appearance.BackColor = Color.Orange; } } } private int splitterDistance = 0; int count1 = 0; int count2 = 0; private void ultraExpandableGroupBox1_ExpandedStateChanged(object sender, EventArgs e) { if (ultraExpandableGroupBox1.Expanded == false) { this.splitContainer1.SplitterDistance = 26; count1 = 26; } else { if (ultraExpandableGroupBox2.Expanded == false) { this.splitContainer1.SplitterDistance = splitContainer1.Size.Height - 26; } else { this.splitContainer1.SplitterDistance = splitterDistance == 0 ? splitContainer1.Size.Height / 2 : splitterDistance; } count1 = splitContainer1.Size.Height - 26; } } private void ultraExpandableGroupBox2_ExpandedStateChanged(object sender, EventArgs e) { if (ultraExpandableGroupBox2.Expanded == false) { if (count1 == 0) { count1 = splitContainer1.Size.Height - 26; } this.splitContainer1.SplitterDistance = count1; } else { if (ultraExpandableGroupBox1.Expanded == false) { this.splitContainer1.SplitterDistance = 26; } else { //this.splitContainer1.SplitterDistance = count1; this.splitContainer1.SplitterDistance = splitterDistance == 0 ? splitContainer1.Size.Height / 2 : splitterDistance; } } } private void ultraGridZyE_Click(object sender, EventArgs e) { activation = 1; } private void ultraGridZyE_ClickCell(object sender, ClickCellEventArgs e) { activation = 1; } private void ultraGrid1_Click(object sender, EventArgs e) { activation = 2; } private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e) { activation = 2; } } }