using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Server; using Core.StlMes.Client.PlnSaleOrd.BaseMethod; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; using System; 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.炼钢计划.control { public partial class FrmOrderZgPln : FrmBase { private string proPlanId = ""; private OpeBase ob; public FrmOrderZgPln(string _proPlanId, OpeBase _ob) { InitializeComponent(); proPlanId = _proPlanId; ob = _ob; this.IsLoadUserView = true; } private void FrmOrderZgPln_Load(object sender, EventArgs e) { PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 2, "OUTDIAMETER", "WALLTHICK", "LEN_ROLL_MAX", "LEN_ROLL_MIN", "AIMOUTDIAMETER", "AIMLENGTH", "DIAMETER_GP", "LENGTH_GP", "ROLL_LENGTH", "DIAMETER_MANDREL", "AIMWALLTHICK", "LEN_GP_SINGLE", "LEN_CUTHEAD", "LEN_CUTEND", "TUBE_END_RATIO"); PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 3, "IN_WEIGHT_S", "WEIGTH_S", "BATCHED_WT", "FINISHWEIGHT", "WEIGTH_S_MIN", "GPREQ_WEIGHT", "FurnWt", "LjWeight", "Reall_WT", "ALLOWANCE", "MATCH_WT_IN", "OUT_WT","OUT_NUM"); PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 0, "FINISHNUM", "BATCHED_NUM", "NUM_S", "IN_NUM_S", "OUTNUM_CUT", "MULTIPLE_NUM", "PLAN_USETIME", "GPREQ_NUM", "PLANS_NUM", "FurnNum", "LjNum", "Reall_NUM", "MATCH_NUM_IN", "OUT_NUM"); BaseHelper.GridColumnSum(ultraGridZgMs, new string[] { "WEIGTH_S", "WEIGTH_S_MIN", "GPREQ_WEIGHT", "FurnWt", "LjWeight", "Reall_WT","MATCH_WT_IN","OUT_WT"}); BaseHelper.GridColumnCount(ultraGridZgMs, new string[] { "NUM_S", "GPREQ_NUM", "FurnNum", "LjNum", "Reall_NUM", "MATCH_NUM_IN","OUT_NUM" }); Query(); } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "Query": Query(); break; case "Close": this.Close(); break; } } private void Query() { //DataTable dtlz = new DataTable(); DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelPlnZg.doPlnZgQuery", new object[] { proPlanId }, this.ob); GridHelper.CopyDataToDatatable(dt, dataTable4, true); //if (dt.Rows.Count > 0) //{ // dtlz = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryLZDataZg", new object[] { }, ob); //} foreach (UltraGridRow ugr in ultraGridZgMs.Rows) { //int numz = 0; //double wtz = 0; int numLj = 0; double wtLj = 0; //int batNum = 0; //double batWt = 0; //if (dtlz.Rows.Count > 0) //{ // DataRow[] drs = dtlz.Select("订单号 ='" + ugr.Cells["PRO_PLAN_ID"].Value.ToString() + "' AND 序号='" + ugr.Cells["GX_PLAN_NO"].Value.ToString() + "'"); // if (drs != null && drs.Length > 0) // { // //if(dtlz.Rows.Count>0){ // if (!drs[0]["装炉支"].ToString().Equals("")) // { // ugr.Cells["FurnNum"].Value = drs[0]["装炉支"].ToString(); // ugr.Cells["FurnWt"].Value = drs[0]["装炉吨"].ToString(); // numz = int.Parse(ugr.Cells["FurnNum"].Value.ToString()); // wtz = double.Parse(ugr.Cells["FurnWt"].Value.ToString()); // } // else // { // numz = 0; // wtz = 0; // } // if (!drs[0]["LJ支"].ToString().Equals("")) // { // ugr.Cells["LjNum"].Value = drs[0]["LJ支"].ToString(); // ugr.Cells["LjWeight"].Value = drs[0]["LJ吨"].ToString(); // numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString()); // wtLj = double.Parse(ugr.Cells["LjWeight"].Value.ToString()); // } // else // { // numLj = 0; // wtLj = 0; // } // if (!drs[0]["出库支"].ToString().Equals("")) // { // ugr.Cells["OUT_NUM"].Value = drs[0]["出库支"].ToString(); // ugr.Cells["OUT_WT"].Value = drs[0]["出库吨"].ToString(); // batNum = int.Parse(ugr.Cells["OUT_NUM"].Value.ToString()); // batWt = double.Parse(ugr.Cells["OUT_WT"].Value.ToString()); // } // else // { // batNum = 0; // batWt = 0; // } // } //} //if (ugr.Cells["LjNum"].Value.Equals("0")) //{ // numLj = int.Parse(ugr.Cells["MATCH_NUM_IN"].Value.ToString()); // wtLj = double.Parse(ugr.Cells["MATCH_WT_IN"].Value.ToString()); //} //else //{ numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString()); wtLj = double.Parse(ugr.Cells["LjWeight"].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()); } double matcInWt = double.Parse(ugr.Cells["MATCH_WT_IN"].Value.ToString()); int matcInNum = int.Parse(ugr.Cells["MATCH_NUM_IN"].Value.ToString()); if (gpNum - numLj - matcInNum < 0) { ugr.Cells["Reall_NUM"].Value = "0"; } else { ugr.Cells["Reall_NUM"].Value = (gpNum - numLj).ToString(); } if (gpWt - wtLj - matcInWt < 0) { ugr.Cells["Reall_WT"].Value = "0"; } else { ugr.Cells["Reall_WT"].Value = (gpWt - - wtLj ).ToString(); } if (!ugr.Cells["Reall_WT"].Text.ToString().Equals("")) { } string[] groupCic = null; if (!ugr.Cells["CIC_GROUP_GP"].Text.Equals("")) { groupCic = ugr.Cells["CIC_GROUP_GP"].Text.ToString().Split(','); } string cic = ""; DataTable dtcic = ServerHelper.GetData("com.steering.pss.plnsaleord.GpOptimize.FrmGradeAnalysis.getQueryGradeZl", new object[] { groupCic, "0" }, this.ob); if (dtcic.Rows.Count > 0) { for (int z = 0; z < dtcic.Rows.Count; z++) { cic += dtcic.Rows[z]["CIC"].ToString() + ","; } cic = cic.Substring(0, cic.Length - 1); } ugr.Cells["CIC_GROUP_GP"].Value = cic; } } } }