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 CoreFS.CA06; using Infragistics.Win; using Infragistics.Win.UltraWinEditors; 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 FrmSteelPlnZgMod : FrmBase { private OpeBase ob; public bool Flag = false; private string judgeStoveNo; private string actCount; private string actWeight; private string actLen; private string fixLen; private string fixNum; private string gradename; private string dimater; private string gptype; private string proPlanId; private string[] arrString = null; private string text = ""; private bool flag = false; public FrmSteelPlnZgMod(OpeBase _ob, ArrayList list,bool _flag) { if (list != null) { arrString = (string[])list.ToArray(typeof(string)); ob = _ob; judgeStoveNo = arrString[0].ToString(); actCount = arrString[1].ToString(); actWeight = arrString[2].ToString(); actLen = arrString[3].ToString(); fixLen = arrString[4].ToString(); fixNum = arrString[5].ToString(); gradename = arrString[6].ToString(); dimater = arrString[7].ToString(); gptype = arrString[8].ToString(); proPlanId = arrString[9].ToString(); flag = _flag; InitializeComponent(); } } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "Query": QueryZgS(); break; case "Library": Library(); break; case "AddCast": AddCast(); break; case "AddDz": AddDz(); break; case "Close": this.Close(); break; } } private void FrmSteelPlnZg_Load(object sender, EventArgs e) { PlanComm.setGridActivation(ultraGridZgMs.DisplayLayout.Bands[0], "CHC", "NumberRule", "ACT_COUNT"); PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 2, "LENGTH_GP", "ROLL_LENGTH", "DIAMETER_MANDREL", "AIMOUTDIAMETER", "AIMWALLTHICK", "AIMLENGTH", "OUTDIAMETER_ZG", "WALLTHICK_ZG"); PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 3, "WEIGTH_S", "WEIGTH_S_MIN", "GPREQ_WEIGHT", "MATCH_WT_IN", "ALLOWANCE", "FurnWt", "LjWeight", "OUT_WT", "Reall_WT", "REDUCED_WT", "ACT_WT"); PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 0, "NUM_S", "OUTNUM_CUT", "MULTIPLE_NUM", "PLAN_USETIME", "GPREQ_NUM", "PLANS_NUM", "MATCH_NUM_IN", "FurnNum", "LjNum", "OUT_NUM", "Reall_NUM", "DIAMETER_GP", "LEN_GP_SINGLE", "ACT_COUNT"); BaseHelper.GridColumnCount(ultraGridZgMs, new string[] { "MATCH_NUM_IN", "GPREQ_NUM", "Reall_NUM" }); BaseHelper.GridColumnSum(ultraGridZgMs, new string[] { "MATCH_WT_IN", "GPREQ_WEIGHT", "Reall_WT", "REDUCED_WT" }); //PlanComm.setGridActivation(ultraGrid1.DisplayLayout.Bands[0], "CHC", "NumberRule"); //PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 5, 2, // "DIAMETER_GP", "LENGTH_GP", "ROLL_LENGTH", "DIAMETER_MANDREL", "AIMOUTDIAMETER", "AIMWALLTHICK", // "LEN_GP_SINGLE", "AIMLENGTH", "OUTDIAMETER_ZG", "WALLTHICK_ZG"); //PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 5, 3, // "WEIGTH_S", "WEIGTH_S_MIN", "GPREQ_WEIGHT", "MATCH_WT_IN", "ALLOWANCE", "FurnWt", "LjWeight", "OUT_WT", "Reall_WT"); //PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 5, 0, // "NUM_S", "OUTNUM_CUT", "MULTIPLE_NUM", "PLAN_USETIME", "GPREQ_NUM", "PLANS_NUM", "MATCH_NUM_IN", "FurnNum", "LjNum", "OUT_NUM", "Reall_NUM"); //BaseHelper.GridColumnCount(ultraGrid1, new string[] { "MATCH_NUM_IN", "GPREQ_NUM", "Reall_NUM" }); //BaseHelper.GridColumnSum(ultraGrid1, new string[] { "MATCH_WT_IN", "GPREQ_WEIGHT", "Reall_WT" }); //设置列头名称 EntityHelper.ShowGridCaption(ultraGridCast.DisplayLayout.Bands[0]); BaseHelper.setOtherColumnReadOnly(ultraGridCast, new string[] { "CHC", "CanNum", "PlineCode", "PlineCodeA", "PlanTimeB", "PlanUsetime", "RepairType", "Memo", "ProgyMemo", "ManualNum", "CraftNo", "CutNumGp" }); BaseHelper.InitCellPosition(ultraGridCast, new string[] { "GxPlanNo", "OrderSeq", "DeliveryNo", "PlanWtS", "PlanNumS", "PlanUsetime", "GxProSeq", "PlnDivideId", "DiameterLz", "LenGpSingle", "CutNumGp", "CutLoseLen", "LengthLz", "WtCastOne", "CastNumCalc", "FurnaceNumCalc", "FurnaceWt", "PlanedWt", "PlanedNum", "Finishweight", "FinishNum", "CastNum", "FurnaceNum", "AddWtBegin", "AddWtEnd", "AddWtAhead", "AddWtNext", "CanWgt", "CanNum", "GradeSort", "ProcessingCostA", "TotalCostA", "ProcessingCostB", "TotalCostB", "ManualNum", "PlanWtSold", "PlanNumSold" }); BaseHelper.GridColumnSum(ultraGridCast, new string[] { "PlanWtS", "CanWgt" }); BaseHelper.GridColumnCount(ultraGridCast, new string[] { "PlanNumS", "CanNum" }); BaseHelper.setUltraGridColumnMaxInput(ultraGridCast, new string[] { "PlanWtS", "CanWgt", "PlanedWt", "PlanWtSold" }); BaseHelper.setUltraGridColumnBits(ultraGridCast, new string[] { "PlanNumS", "CanNum", "PlanedNum", "ManualNum" }); PlanHelper.InitRepairType(ultraGridCast, this); BaseHelper.ForbidSort(ultraGridCast); EntityHelper.ShowGridCaption(ultraGridDz.DisplayLayout.Bands[0]); BaseHelper.ForbidSort(ultraGridDz); BaseHelper.InitCellPosition(ultraGridDz, new string[] { "GxPlanNo", "DiameterOut", "LengthOut", "OutWtOne", "OutWtTot", "OutNumTot", "DiameterIn", "LengthIn", "WtOneIn", "InWeightS", "InNumS", "WeigthS", "NumS", "AddWtIn", "AddNumIn", "MatchWtIn", "MatchNumIn", "DzLoseAdd", "DzCutHeadEnd", "DzBurnLose", "GxProSeq", "PlanUsetime", "BatchedWt", "BatchedNum", "Finishweight", "Finishnum", "ProcessingCost", "TotalCost" }); BaseHelper.GridColumnSum(ultraGridDz, new string[] { "WeigthS", "BatchedWt" }); BaseHelper.GridColumnCount(ultraGridDz, new string[] { "NumS", "BatchedNum" }); BaseHelper.setOtherColumnReadOnly(ultraGridDz, new string[] { "CHC", "NumLk"}); BaseHelper.setColumnBackColor(ultraGridDz, new string[] { "NumLk" }); text= " 判定炉号:" + judgeStoveNo + " 总量:" + actWeight + " 倍尺支数:" + actCount + " 单倍支数:" + int.Parse(actCount)*int.Parse(fixNum); ultraGroupBox1.Text =text; if (dimater.Contains("t")) { ultraTabControl1.Tabs[1].Visible = false; ultraTabControl1.Tabs[2].Visible = true; ultraTabControl1.Tabs[0].Visible = false; ultraToolbarsManager1.Toolbars[0].Tools["Library"].SharedProps.Visible = false; ultraToolbarsManager1.Toolbars[0].Tools["AddCast"].SharedProps.Visible = false; ultraToolbarsManager1.Toolbars[0].Tools["AddDz"].SharedProps.Visible = true; //QueryOrderDz(); } else { ultraTabControl1.Tabs[1].Visible = true; ultraTabControl1.Tabs[2].Visible = false; ultraTabControl1.Tabs[0].Visible = false; ultraToolbarsManager1.Toolbars[0].Tools["Library"].SharedProps.Visible = false; ultraToolbarsManager1.Toolbars[0].Tools["AddCast"].SharedProps.Visible = true; ultraToolbarsManager1.Toolbars[0].Tools["AddDz"].SharedProps.Visible = false; } QueryZgS(); } private string dimaterGp = ""; private string lenGpSingle = ""; private void QueryZgS() { //dimaterGp = dimater; //if (gptype.Equals("锻坯"))//锻造 //{ DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.planStove.FrmPlanSteelMakMod.getOrderDiameter", new object[] { proPlanId }, ob); if (dt.Rows.Count > 0) { dimaterGp = dt.Rows[0]["DIAMETER_GP"].ToString(); lenGpSingle = dt.Rows[0]["LEN_GP_SINGLE"].ToString(); } //} if (ultraTabControl1.SelectedTab.Key.Equals("0")) { //Query(); } else if (ultraTabControl1.SelectedTab.Key.Equals("1")) { //Query(); QueryOrder(); } else { QueryOrderDz(); } } /// /// 查询无管坯需求轧管订单 /// private void Query() { DataTable dtZg = ServerHelper.GetData("com.steering.pss.plnsaleord.planStove.FrmPlanSteelMakMod.selectPlnOrderZgS", new object[] { gradename, dimaterGp, lenGpSingle, gptype }, ob); GridHelper.CopyDataToDatatable(dtZg, dataTable2, true); //GridHelper.RefreshAndAutoSize(ultraGrid1); #region 赋值LJ,装炉,出库 foreach (UltraGridRow ugr in ultraGrid1.Rows) { int numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString()); double wtLj = double.Parse(ugr.Cells["LjWeight"].Value.ToString()); double zsWt = double.Parse(ugr.Cells["REDUCED_WT"].Value.ToString()); int gpNum = 0; double gpWt = 0; if (ugr.Cells["GPREQ_NUM"].Text.Equals("")) { gpNum = 0; gpWt = 0; } else { gpNum = int.Parse(ugr.Cells["GPREQ_NUM"].Value.ToString()); gpWt = double.Parse(ugr.Cells["GPREQ_WEIGHT"].Value.ToString()); } if (gpNum - numLj < 0) { ugr.Cells["Reall_NUM"].Value = "0"; ugr.Cells["Reall_WT"].Value = "0"; } else { ugr.Cells["Reall_NUM"].Value = (gpNum - numLj).ToString(); ugr.Cells["Reall_WT"].Value = (gpWt - zsWt).ToString(); } ugr.Cells["ACT_COUNT"].Value = actCount; ugr.Cells["ACT_WT"].Value = actWeight; } #endregion //} ultraGrid1.UpdateData(); if (radioButton1.Checked) { dataTable1.DefaultView.RowFilter = "Reall_NUM >0 "; DataTable dt = dataTable2.DefaultView.ToTable(); _data1 = dataTable2.Copy(); GridHelper.CopyDataToDatatable(dt, dataTable2, true); } } /// /// 根据管坯需求号查询轧管订单 /// private void Query(string proPlanId) { DataTable dtZg = ServerHelper.GetData("com.steering.pss.plnsaleord.planStove.FrmPlanSteelMakMod.selectPlnOrderZgSGp", new object[] { proPlanId }, ob); GridHelper.CopyDataToDatatable(dtZg, dataTable2, true); //GridHelper.RefreshAndAutoSize(ultraGrid1); #region 赋值LJ,装炉,出库 foreach (UltraGridRow ugr in ultraGrid1.Rows) { int numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString()); double wtLj = double.Parse(ugr.Cells["LjWeight"].Value.ToString()); double zsWt = double.Parse(ugr.Cells["REDUCED_WT"].Value.ToString()); int gpNum = 0; double gpWt = 0; if (ugr.Cells["GPREQ_NUM"].Text.Equals("")) { gpNum = 0; gpWt = 0; } else { gpNum = int.Parse(ugr.Cells["GPREQ_NUM"].Value.ToString()); gpWt = double.Parse(ugr.Cells["GPREQ_WEIGHT"].Value.ToString()); } if (gpNum - numLj < 0) { ugr.Cells["Reall_NUM"].Value = "0"; ugr.Cells["Reall_WT"].Value = "0"; } else { ugr.Cells["Reall_NUM"].Value = (gpNum - numLj).ToString(); ugr.Cells["Reall_WT"].Value = (gpWt - wtLj).ToString("f3"); } ugr.Cells["ACT_COUNT"].Value = actCount; ugr.Cells["ACT_WT"].Value = actWeight; } #endregion //} ultraGrid1.UpdateData(); if (radioButton1.Checked) { dataTable1.DefaultView.RowFilter = "Reall_NUM >0 "; DataTable dt = dataTable2.DefaultView.ToTable(); _data1 = dataTable2.Copy(); GridHelper.CopyDataToDatatable(dt, dataTable2, true); } } /// /// 查询铸造订单 /// private void QueryOrder() { List listSourceCast = EntityHelper.GetData ("com.steering.pss.plnsaleord.planStove.FrmPlanSteelMakMod.getOrderBInfoByContion", new object[] { dimater, gradename, gptype }, ob); plnOrderCastSEntityBindingSource.DataSource = listSourceCast; } /// /// 查询锻造订单 /// private void QueryOrderDz() { List listSourceDz = EntityHelper.GetData ("com.steering.pss.plnsaleord.planStove.FrmPlanSteelMakMod.getOrderBInfoByContionDz", new object[] { gradename, dimater, fixLen, flag }, ob); plnOrderDzSOEntityBindingSource.DataSource = listSourceDz; } /// /// 利库 /// private void Library() { ultraGridZgMs.UpdateData(); UltraGridRow row = ultraGridZgMs.ActiveRow; if (row == null) return; ArrayList list = new ArrayList(); //if (!row.Cells["STATION_ROAD_LG"].Text.ToString().Equals(planRoute)) //{ // MessageUtil.ShowTips("炼钢工艺路径不同,不能利轧管计划!"); // return; //} if (double.Parse(row.Cells["Reall_WT"].Value.ToString()) - double.Parse(row.Cells["ACT_WT"].Value.ToString()) < 0.000002) { if (MessageUtil.ShowYesNoAndQuestion("判定炉号:" + judgeStoveNo + ",库存量大于轧管待冶炼量,是否利库!") == DialogResult.No) return; } //if (!lenGpSingle.Equals(row.Cells["LEN_GP_SINGLE"].Value.ToString())) //{ // MessageUtil.ShowTips("单倍坯长不一致(库存;" + fixLen + ",订单;" + row.Cells["LEN_GP_SINGLE"].Value.ToString() + "),不能利库"); // return; //} if (!dimaterGp.Equals(row.Cells["DIAMETER_GP"].Value.ToString())) { MessageUtil.ShowTips("断面不一致(库存;" + dimater + ",订单;" + row.Cells["DIAMETER_GP"].Value.ToString() + "),不能利库!"); return; } if (row.Cells["ACT_COUNT"].Value.ToString().Equals("0")) { MessageUtil.ShowTips("利库支数不能为零!"); return; } list.Add(row.Cells["PRO_PLAN_ID"].Text.ToString()); list.Add(row.Cells["GX_PLAN_NO"].Text.ToString()); list.Add(row.Cells["Reall_WT"].Value.ToString()); list.Add(judgeStoveNo); list.Add(actLen); list.Add(fixLen); list.Add(fixNum); list.Add(row.Cells["ACT_COUNT"].Value.ToString()); list.Add(dimater); list.Add(gptype); list.Add(row.Cells["LEN_GP_SINGLE"].Value.ToString()); if (MessageUtil.ShowYesNoAndQuestion("是否利库?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanSteelMakMod"; ccp.MethodName = "doAddLibraryLg"; 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("利库成功!")) { Query(); Flag = true; } } //利铸造 private void AddCast() { UltraGridRow rowZg = ultraGrid1.ActiveRow; if (rowZg == null) return; double lenGpSingleZ = double.Parse(rowZg.Cells["LEN_GP_SINGLE"].Text.ToString()); ultraGridZgMs.UpdateData(); UltraGridRow row = ultraGridCast.ActiveRow; if (row == null) return; ArrayList list = new ArrayList(); if (double.Parse(row.Cells["CanWgt"].Value.ToString()) - double.Parse(actWeight) < 0.000002) { if (MessageUtil.ShowYesNoAndQuestion("判定炉号:" + judgeStoveNo + ",库存量大于铸造待冶炼量,是否利库!") == DialogResult.No) return; } if (!dimater.Equals(row.Cells["DiameterLz"].Text.ToString().Trim())) { MessageUtil.ShowTips("断面不一致(库存;" + dimater + ",订单;" + row.Cells["DiameterLz"].Value.ToString() + "),不能利库"); return; } //if (double.Parse(actLen) % lenGpSingleZ != 0) //{ // MessageUtil.ShowTips("倍尺数不是整数,不能利库"); // return; //} list.Add(row.Cells["ProPlanId"].Text.ToString()); list.Add(row.Cells["GxPlanNo"].Text.ToString()); list.Add(row.Cells["CanWgt"].Value.ToString()); list.Add(judgeStoveNo); list.Add(actLen); list.Add(fixLen); list.Add(fixNum); list.Add(actCount); list.Add(dimater); list.Add(gptype); list.Add(actWeight); list.Add(lenGpSingleZ.ToString()); list.Add(gradename); string falg = "0"; if (MessageUtil.ShowYesNoAndQuestion("是否利库?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanSteelMakMod"; ccp.MethodName = "doAddCastLg"; 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("利库成功!")) { QueryOrder(); Flag = true; } } //利锻造 private void AddDz() { ultraGridDz.UpdateData(); UltraGridRow row = ultraGridDz.ActiveRow; if (row == null) return; ArrayList list = new ArrayList(); //if (double.Parse(row.Cells["CanWgt"].Value.ToString()) - double.Parse(actWeight) < 0.000002) //{ // if (MessageUtil.ShowYesNoAndQuestion("判定炉号:" + judgeStoveNo + ",库存量大于铸造待冶炼量,是否利库!") == DialogResult.No) return; //} //if (!lenGpSingle.Equals(row.Cells["LenGpSingle"].Value.ToString())) //{ // MessageUtil.ShowTips("单倍坯长不一致(库存;" + fixLen + ",订单;" + row.Cells["LenGpSingle"].Value.ToString() + "),不能利库"); // return; //} int countdZ = 0; int numDz = 0; foreach (UltraGridRow urg in ultraGridDz.Rows) { ArrayList list1 = new ArrayList(); if (Convert.ToBoolean(urg.Cells["CHC"].Text) == true) { countdZ++; if (!dimater.Equals(urg.Cells["DiameterIn"].Text.ToString().Trim())) { MessageUtil.ShowTips("断面不一致(库存;" + dimater + ",订单;" + row.Cells["DiameterIn"].Value.ToString() + "),不能利库"); return; } if (urg.Cells["NumLk"].Text.ToString().Equals("0")) { MessageUtil.ShowTips("请输入利库支数!"); return; } numDz += int.Parse(urg.Cells["NumLk"].Value.ToString()); list1.Add(urg.Cells["ProPlanId"].Text.ToString()); list1.Add(urg.Cells["GxPlanNo"].Text.ToString()); list1.Add(judgeStoveNo); list1.Add(actLen); list1.Add(fixLen); list1.Add(fixNum); list1.Add(urg.Cells["NumLk"].Text.ToString()); list1.Add(dimater); list1.Add(gptype); list.Add(list1); } } if (countdZ == 0) { MessageUtil.ShowTips("请勾选利库锻造订单信息!"); return; } if (numDz > int.Parse(actCount)) { MessageUtil.ShowTips("勾选利库总支数不能大于库存支数,请确认!"); return; } string falg = "0"; if (MessageUtil.ShowYesNoAndQuestion("是否利库?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanSteelMakMod"; ccp.MethodName = "doAddDzLg"; 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("利库成功!")) { QueryOrderDz(); Flag = true; } } /// /// 点击列事件 /// /// /// private void ultraGridZgMs_CellChange(object sender, CellEventArgs e) { UltraGridRow row = ultraGridZgMs.ActiveRow; ultraGridZgMs.UpdateData(); if (e.Cell.Column.Key.Equals("ACT_COUNT")) { if (e.Cell.Row.Cells["ACT_COUNT"].Value.ToString().Equals("") || e.Cell.Row.Cells["ACT_COUNT"].Value.ToString() == null) { e.Cell.Row.Cells["ACT_COUNT"].Value = actCount; e.Cell.Row.Cells["ACT_WT"].Value = actWeight; } else { int actCounta = int.Parse(e.Cell.Row.Cells["ACT_COUNT"].Value.ToString()); if (actCounta > int.Parse(actCount)) { e.Cell.Row.Cells["ACT_COUNT"].Value = actCount; e.Cell.Row.Cells["ACT_WT"].Value = actWeight; } else { //查询库存重量 DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.planStove.FrmPlanSteelMakMod.queryMatWeigth", new object[] { judgeStoveNo, fixNum, actLen, fixLen, actCounta.ToString(), flag }, ob); if (dt.Rows.Count > 0) { e.Cell.Row.Cells["ACT_WT"].Value = dt.Rows[0]["ACT_WEIGHT"].ToString(); } } } } } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { //if (ultraTabControl1.SelectedTab.Key.Equals("0")) //{ // ultraToolbarsManager1.Toolbars[0].Tools["Library"].SharedProps.Visible = true; // ultraToolbarsManager1.Toolbars[0].Tools["AddCast"].SharedProps.Visible = false; // ultraToolbarsManager1.Toolbars[0].Tools["AddDz"].SharedProps.Visible = false; // ultraToolbarsManager1.Toolbars[0].Tools["ControlContainerTool1"].SharedProps.Visible = true; // Query(); //} //else if (ultraTabControl1.SelectedTab.Key.Equals("1")) //{ // ultraToolbarsManager1.Toolbars[0].Tools["Library"].SharedProps.Visible = false; // ultraToolbarsManager1.Toolbars[0].Tools["AddCast"].SharedProps.Visible = true; // ultraToolbarsManager1.Toolbars[0].Tools["AddDz"].SharedProps.Visible = false; // ultraToolbarsManager1.Toolbars[0].Tools["ControlContainerTool1"].SharedProps.Visible = false; // QueryOrder(); //} //else if (ultraTabControl1.SelectedTab.Key.Equals("2")) //{ // ultraToolbarsManager1.Toolbars[0].Tools["Library"].SharedProps.Visible = false; // ultraToolbarsManager1.Toolbars[0].Tools["AddCast"].SharedProps.Visible = false; // ultraToolbarsManager1.Toolbars[0].Tools["AddDz"].SharedProps.Visible = true; // ultraToolbarsManager1.Toolbars[0].Tools["ControlContainerTool1"].SharedProps.Visible = false; // QueryOrderDz(); //} } private void FrmSteelPlnZg_Shown(object sender, EventArgs e) { //ultraToolbarsManager1.Toolbars[0].Tools["Library"].SharedProps.Visible = true; //ultraToolbarsManager1.Toolbars[0].Tools["AddCast"].SharedProps.Visible = false; //ultraToolbarsManager1.Toolbars[0].Tools["AddDz"].SharedProps.Visible = false; //ultraToolbarsManager1.Toolbars[0].Tools["ControlContainerTool1"].SharedProps.Visible = true; } private DataTable _data1; private void radioButton1_CheckedChanged(object sender, EventArgs e) { ultraGridZgMs.UpdateData(); //ultraGridZgMs.DataSource = dataTable1.DefaultView; if (radioButton1.Checked) { dataTable1.DefaultView.RowFilter = "Reall_NUM >0 "; DataTable dt = dataTable1.DefaultView.ToTable(); _data1 = dataTable1.Copy(); GridHelper.CopyDataToDatatable(dt, dataTable1, true); } else { GridHelper.CopyDataToDatatable(_data1, dataTable1, true); } ultraGridZgMs.Refresh(); ultraGridZgMs.Update(); } private void ultraGridDz_CellChange(object sender, CellEventArgs e) { UltraGridRow row = ultraGridDz.ActiveRow; ultraGridDz.UpdateData(); if (e.Cell.Column.Key.Equals("NumLk")) { if (e.Cell.Row.Cells["NumLk"].Value == null) { row.Cells["NumLk"].Value = int.Parse(row.Cells["NumS"].Value.ToString()) - int.Parse(row.Cells["BatchedNum"].Value.ToString()); row.Cells["WeightLk"].Value = (double.Parse(row.Cells["WeigthS"].Value.ToString()) - double.Parse(row.Cells["BatchedWt"].Value.ToString())).ToString("f3"); } else { string numLk = e.Cell.Row.Cells["NumLk"].Value.ToString(); if (!StringUtil.IsInt(numLk) || numLk == "0") { e.Cell.Row.Cells["WeightLk"].Value = "0"; } else { //查询库存重量 DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.planStove.FrmPlanSteelMakMod.queryMatWeigth", new object[] { judgeStoveNo, fixNum, actLen, fixLen, numLk, true }, ob); if (dt.Rows.Count > 0) { e.Cell.Row.Cells["WeightLk"].Value = dt.Rows[0]["ACT_WEIGHT"].ToString(); if (e.Cell.Row.Cells["WeightLk"].Value.Equals("0")) { row.Cells["NumLk"].Value = "0"; } } } } } int numDz = 0; foreach (UltraGridRow ugr in ultraGridDz.Rows) { if (Convert.ToBoolean(ugr.Cells["CHC"].Text) == true) { numDz += int.Parse(ugr.Cells["NumLk"].Value.ToString()); } } ultraGroupBox1.Text = text + " 利库总支数:" + numDz; } private void ultraGridDz_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGridDz.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHC"].Value = true; } } int numDz = 0; foreach (UltraGridRow ugr in ultraGridDz.Rows) { if (Convert.ToBoolean(ugr.Cells["CHC"].Text) == true) { numDz += int.Parse(ugr.Cells["NumLk"].Value.ToString()); } } ultraGroupBox1.Text = text + " 利库总支数:" + numDz; } private void ultraGridCast_AfterRowActivate(object sender, EventArgs e) { UltraGridRow row = ultraGridCast.ActiveRow; if (row == null) return; string proPlanId = row.Cells["ProPlanId"].Text.ToString(); Query(proPlanId); } } }