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 FrmPlanStoveH : FrmBase { private ArrayList _EntityList = null; private string[] plineCode = null;//获取产线代码 /// /// 虚拟炉计划id /// private string _heatPlanNo = ""; /// /// 行首背景色 /// private Color _backColor = new Color(); public FrmPlanStoveH() { this.IsLoadUserView = true; InitializeComponent(); } private void FrmPlanStoveG_Load(object sender, EventArgs e) { //订单排产 EntityHelper.ShowGridCaption(ultraGridZy.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); BaseHelper.setOtherColumnReadOnly(ultraGridZy, new string[] { "CHC" }); BaseHelper.setUltraGridColumnMaxInput(ultraGridZy, new string[] { "PlanBlWt","Singleweight" }); BaseHelper.setUltraGridColumnBits(ultraGridZy, new string[] { "SingleCutNun", "PlanBlNum", "PlanJgNum"}); BaseHelper.InitCellPosition(ultraGridZy, new string[] { "GxProSeq", "GxPlanNo","PlanBlWt", "Diameter", "SingleCutNun","PlanBlNum","PlanJgNum","Aimlength","CheckJVal","Outdiameter","Wallthick", "LengthMax","LengthMin","AimCutLen","AimlengthBl","MinH","MinD"}); BaseHelper.GridColumnSum(ultraGridZy, new string[] { "PlanBlWt" }); BaseHelper.GridColumnCount(ultraGridZy, new string[] { "PlanBlNum", "PlanJgNum"}); plineCode = PlanHelper.InitDropPlinePower("H", txtLine, this.ValidDataPurviewIds, this.ob); StoveHelper.ForbidSort(ultraGridZy); BaseHelper.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHC" }); BaseHelper.setUltraGridColumnMaxInput(ultraGrid1, new string[] { "PlanBlWt", "Singleweight", "UseBlWt" }); BaseHelper.setUltraGridColumnBits(ultraGrid1, new string[] { "SingleCutNun", "PlanBlNum", "PlanJgNum", "UseBlNum", "OutJgNum" }); BaseHelper.InitCellPosition(ultraGrid1, new string[] { "GxProSeq", "GxPlanNo","PlanBlWt", "Diameter", "SingleCutNun","PlanBlNum","PlanJgNum","Aimlength","CheckJVal","Outdiameter","Wallthick", "LengthMax","LengthMin","AimCutLen","AimlengthBl","MinH","MinD","UseBlNum", "UseBlWt", "OutJgNum"}); BaseHelper.GridColumnSum(ultraGrid1, new string[] { "UseBlWt"}); BaseHelper.GridColumnCount(ultraGrid1, new string[] { "OutJgNum", "UseBlNum" }); StoveHelper.ForbidSort(ultraGrid1); InitDate(); BaseHelper.SetGroupBySum(ultraGrid1, new string[] { "PlanBlWt", "PlanBlNum", "PlanJgNum" }, "HeatPlanNo"); } 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["PlanBlNum"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlanBlNum"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlanBlWt"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlanBlWt"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlanJgNum"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlanJgNum"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["FlagStoveNo"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["FlagStoveNo"].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; } } public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query"://查询 Query(); break; case "Export": //导出 Export(); break; case "UpdateLoadFlag": updateLoadFlag(); break; case "Close": //关闭 this.Close(); break; default: break; } } /// /// 标识库位不变 /// private void updateLoadFlag() { this.ultraGridZy.UpdateData(); UltraGridRow row = this.ultraGridZy.ActiveRow; if (row == null) { return; } ArrayList parmList = new ArrayList(); PlnZyJgMEntity plnDbkTity = (PlnZyJgMEntity)row.ListObject; string plnZgEntity = JSONFormat.Format(plnDbkTity); parmList.Add(plnZgEntity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveH"; 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 Query() { if (ultraExpandableGroupBox1.Expanded == false) { QueryC(); } else { QueryM(); } } private int activation = 0; /// /// 导出 /// private void Export() { if (activation < 2) { GridHelper.ulGridToExcel(ultraGridZy, "接箍炉计划主信息"); } 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[] statusArr = contorlPlanStatusZy1.statusArr; List listSource = EntityHelper.GetData ("com.steering.pss.plnsaleord.planStove.FrmPlanStoveH.queryPlanStoveYzH", new object[] { timeBegin, timeEnd, plineCode, orderNo, proPlanId, heatId, statusArr, judgeNo, "" }, this.ob); plnZyJgMEntityBindingSource.DataSource = listSource; foreach (UltraGridRow ugr in ultraGridZy.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++) { PlnZyJgxMEntity entity = (PlnZyJgxMEntity)_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 = ""; //执行状态 string[] statusArr = contorlPlanStatusZy1.statusArr; List listSource = EntityHelper.GetData ("com.steering.pss.plnsaleord.planStove.FrmPlanStoveH.queryPlnZyDbkReadyById", new object[] { timeBegin, timeEnd, plineCode, orderNo, proPlanId, heatId, statusArr, judgeNo, "" }, this.ob); plnZyJgReadyEntityBindingSource.DataSource = listSource; foreach (UltraGridRow ugr in ultraGrid1.Rows) { //没有实际炉计划,主炉计划变颜色 if (ugr.Cells["HeatPlanSqe"].Value.ToString().Equals("")) { ugr.Appearance.BackColor = Color.Orange; } } } private void ultraGridZy_AfterRowActivate(object sender, EventArgs e) { UltraGridRow row = ultraGridZy.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.FrmPlanStoveH.queryPlanStoveRow", new object[] { heatPlanNo }, ob); plnZyJgReadyEntityBindingSource.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 ultraGridZy_Click(object sender, EventArgs e) { activation = 1; } private void ultraGridZy_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; } } }