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; using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Format; 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 Core.StlMes.Client.PlnSaleOrd.OrderManage.froms; using Newtonsoft.Json; using Core.StlMes.Client.PlnSaleOrd.窗体; using Core.Mes.Client.Comm; using Core.StlMes.Client.PlnSaleOrd.PopupWindow; using Core.StlMes.Client.PlnSaleOrd.炉计划.Entity; using Core.StlMes.Client.PlnSaleOrd.炉计划.Tool; namespace Core.StlMes.Client.PlnSaleOrd { ///custominfo==0　表示轧管排产查询界面 /// /// 坯料测算 /// public partial class FrmPlnOrderZgSMES : FrmBase { private string departm = "";//获取部门ID private string[] plineCode = null;//获取产线代码 /// /// 订单编号 /// private string _ProPlanId = ""; DataTable dtPlinGroup = null; /// /// 排产序号 /// private string _GxPlanNo = ""; UltraComboEditor uceDimaM = new UltraComboEditor();//芯棒直径 /// /// 行首背景色 /// private Color _backColor = new Color(); string proPlanId = ""; string gxPlanNo = ""; /// /// 调整行集合 /// private ArrayList _entityList = null; public FrmPlnOrderZgSMES() { InitializeComponent(); this.IsLoadUserView = true; } public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query"://查询 Query(); break; //case "Capacity"://产线能力维护 // Capacity(); // break; //case "AddRepairPlan"://检修计划 // AddRepairPlan(); // break; //case "DeleteRepairPlan"://删除检修计划 // DeleteRepairPlan(); // break; //case "PlineChange"://产线调整 // PlineChange(); // break; //case "TimeChange"://时间调整 // TimeChange(); // break; //case "StatusChange"://状态调整 // StatusChange(); // break; //case "InitData"://耗时初始化 // InitData(); // break; //case "Spit"://拆分订单 // Spit(); // break; //case "Merge"://合并订单 // Merge(); // break; //case "Issued"://确认下发 // Issued("0"); // break; //case "CancelIssued"://取消下发 // Issued("1"); // break; //case "SetPlanFinish"://设置合同完成 // SetPlanFinish(); // break; case "ModifyGpAimWall"://重算 ModifyGpAimWall(); break; //case "UpdateCrop"://修改切头尾 // UpdateCrop(); // break; //case "UpdateDiameM"://修改芯棒直径 // UpdateDiameM(); // break; //case "ModifyThicknesWall"://修改控制壁厚 // ModifyThicknesWall(); // break; case "Recalculate"://保存 Recalculate(); break; case "Recalculate2"://上传 Recalculate2(); break; case "Export": //导出 GridHelper.ulGridToExcel(ultraGridZgS, "轧管排产信息"); break; //case "UpdateMonth"://修改排产月份 // UpdateMonth(); // break; //case "ApplyApproval"://申请审批 // ApplyApproval(); // break; //case "ModifyBatter"://修改坯子 // ModifyBatter(); // break; //case "UpdateGroupGp"://修改索引码 // UpdateGroupGp(); // break; //case "Confirm"://炉计划下发 // Issued("2"); // break; //case "UinConfirm"://取消炉计划下发 // Issued("3"); // break; //case "UpdateBatch"://修改轧批号 // UpdateBatch(); // break; //case "Decision"://修改判定字头 // DoDecision(); // break; //case "ProMemo"://工艺备注修改 // DoProMemo("0"); // break; //case "UpdateMemo"://计划备注修改 // DoProMemo("1"); // break; //case "Import"://导入 // DoImport(); // break; //case "UpdatePase"://主被动修改 // DoUpdatePase(); // break; //case "ModifyProcess"://手动获取工艺 // DoModifyProcess(); // break; //case "AgainProcess"://重新获取工艺 // doAgainProcess(); // break; //case "SortOrderZg": // sortOrderZg(); // break; case"Print": printData(); break; //case"Notice": // tabNotice(); // break; //case "UpdateOrderTeam"://修改是否协同 // UpdateOrderTeam(); // break; case "Close": //关闭 this.Close(); break; default: break; } } private void UpdateOrderTeam() { this.ultraGridZgS.UpdateData(); IQueryable checkMagRows = this.ultraGridZgS.Rows.AsQueryable().Where(" CHC = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要操作的数据信息!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRows) { PlnOrderZgSOEntity plnOrderZgsTity = (PlnOrderZgSOEntity)row.ListObject; string plnOrderZgsEntity = JSONFormat.Format(plnOrderZgsTity); parmList.Add(plnOrderZgsEntity); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.processOrder.base.ProducHelper"; ccp.MethodName = "UpdateOrderTeam"; ccp.ServerParams = new object[] { parmList, "D" }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("修改成功!")) { Query(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 标识监制信息 /// private void tabNotice() { this.ultraGridZgS.UpdateData(); IQueryable checkMagRows = this.ultraGridZgS.Rows.AsQueryable().Where(" CHC = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要操作的监制信息!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRows) { PlnOrderZgSOEntity plnOrderZgsTity = (PlnOrderZgSOEntity)row.ListObject; string plnOrderZgsEntity = JSONFormat.Format(plnOrderZgsTity); parmList.Add(plnOrderZgsEntity); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.processOrder.base.ProducHelper"; ccp.MethodName = "tabNotice"; ccp.ServerParams = new object[] { parmList, UserInfo.GetUserName(),"D" }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("标识监制成功!")) { Query(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 重新排序订单 /// private void sortOrderZg() { //string plineCode = ""; //plineCode = comPline.Value == null ? "" : comPline.Value.ToString(); //if (plineCode.Equals("")) //{ // MessageUtil.ShowTips("请选择产线!"); // return; //} CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.planStove.StoveHelper"; ccp.MethodName = "sortOrderZg"; ccp.ServerParams = new object[] { plineCode }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("重新排序成功!")) { Query(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 打印检验要点 /// private void printData() { // string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilTestKey2.cpt&PROCESS_CODE=D"; string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepEntrustLabel.cpt&CHECK_NO=72A340800091&JUDGE_STOVE_NO=A34080009&PROCESS_CODE=D"; FrmRepExcel fBug = new FrmRepExcel(ob, strurl); // fBug.AutoSize = true; // fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fBug.Text = "检验要点打印"; fBug.ShowDialog(); } private void FrmPlnOrderZgS_Load(object sender, EventArgs e) { if (CustomInfo == null) { CustomInfo = ""; } //设置列头名称 EntityHelper.ShowGridCaption(ultraGridZgS.DisplayLayout.Bands[0]); if (CustomInfo == "0") { PlanComm.setGridActivation(this.ultraGridZgS.DisplayLayout.Bands[0], "CHC");//, "OutsBilletFl" } else { BaseHelper.setOtherColumnReadOnly(ultraGridZgS, new string[] { "CHC", "Mgcd", "DiameterMandrel", "Zzcd", "Ggfqs", "Cpcd", "Qt", "Qw", "Bcs", "Dbcplcd", "Gpzj", "WgH", "WgD", "QuantityPurchased", "RulerLength", "Ssl", "Jhlc" }); //tzh 后续改颜色 BaseHelper.setColumnBackColor(ultraGridZgS, new string[] { "Pass", "Mgcd", "DiameterMandrel", "Zzcd", "Ggfqs", "Cpcd", "Qt", "Qw", "Bcs", "Dbcplcd", "Gpzj", "WgH", "WgD", "HtcgzlMax", "HtcgzlMin", "QuantityPurchased", "RulerLength", "Dbcplzl", "Ssl", "Mz", "Jhlc", "Zzzl", "Zzcd", "Dbcplcd", "QuantityPurchased" }); //BaseHelper.setColumnBackColor2(ultraGridZgS, new string[] { "Mgbh", "Mgwj" }); // EntityHelper.setColumnShowOrHidden(ultraGridZgS, new string[] { "OrderTeam" }, false); } // BaseHelper.InitCellPosition(ultraGridZgS, new string[] { "GxPlanNo", "OrderSeq", "DeliveryNo", "Outdiameter", "Wallthick", // "LenRollMax", "LenRollMin", "Aimoutdiameter", "Aimwallthick", "Aimlength", "DiameterGp", "LenGpSingle", "RollLength", // "LenCuthead", "LenCutend", "OutnumCut", "DiameterMandrel", "InWeightS", "InNumS", "WeigthS", "NumS", "AddWtIn", // "AddNumIn", "MatchWtIn", "MatchNumIn", "GxProSeq", "PlanUsetime", "BatchedWt", "BatchedNum", "Finishweight", // "Finishnum", "ProcessingCost", "TotalCost" ,"FinishWgt","UnfinishWgt","UnfinishNum","OutdiameterZg","WallthickZg","GpreqNum","GpreqWeight","TubeEndRatio","WeigthSMin","PlansNum","TimeDiffer","AfProNum","AmountDifference","LjNum","LjWeight","FurnaNum","FurnaWeight","CkNum","CkWeight","HrCapcty","ExpectWt","ExpectNum","PendNum","PendWeight","ReducedWt","LjWeightB","LjNumB" }); // BaseHelper.setUltraGridColumnMaxInput(ultraGridZgS, new string[] { "WeigthS", "WeigthSMin", "GpreqWeight", "InWeightS", "AddWtIn", "MatchWtIn", "BatchedWt", "AmountDifference", "UnfinishWgt", "LjWeight", "FurnaWeight", "CkWeight", "ExpectWt", "PendWeight", "ReducedWt", "LjWeightB" }); //// plineCode = PlanHelper.InitDropPlinePower("D", comPline, this.ValidDataPurviewIds, this.ob); //PlanHelper.InitRepairType(ultraGridZgS, this); //PlanHelper.InitEditPline("D", "", ultraGridZgS, this); /// comPline.SelectedIndex = 0; if (CustomInfo != "0") { BaseHelper.ForbidSort(ultraGridZgS); } // BaseHelper.GridColumnSum(ultraGridZgS, new string[] { "WeigthS", "WeigthSMin", "GpreqWeight", "PendWeight", "ReducedWt", "LjWeight", "ExpectWt", "FurnaWeight", "CkWeight", "LjWeightB" }); // BaseHelper.GridColumnCount(ultraGridZgS, new string[] { "NumS", "GpreqNum", "PlansNum", "PendNum", "LjNumB", "LjNum", "FurnaNum", "CkNum", }); // BaseHelper.setUltraGridColumnColor(ultraGridZgS, new string[] { "CraftFileNo", "CraftFileLv2G", "Gradename", "DiameterGp" }, Color.GreenYellow); // PlanHelper.InitEditGroup("1219", ultraGridZgS, this, "OutsStlPipeFl"); _backColor = ultraGridZgS.DisplayLayout.Override.RowSelectorAppearance.BackColor; //InitTime(); InitColorStyle(); } /// /// 初始化列状态 /// private void InitColorStyle() { //ultraGridZgS.DisplayLayout.Bands[0].Columns["PlanTimeB"].Format = "yyyy-MM-dd HH:mm:ss"; //ultraGridZgS.DisplayLayout.Bands[0].Columns["PlanTimeB"].MaskInput = "yyyy-mm-dd hh:mm:ss"; //ultraGridZgS.DisplayLayout.Bands[0].Columns["PlanTimeB"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DateTime; //ultraGridZgS.DisplayLayout.Bands[0].Columns["CraftFileLv2G"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton; //ultraGridZgS.DisplayLayout.Bands[0].Columns["CraftFileNo"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton; //ultraGridZgS.DisplayLayout.Bands[0].Columns["Gradename"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton; //ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterGp"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton; //ultraGridZgS.DisplayLayout.Bands[0].Columns["AfInfo"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton; //ultraGridZgS.DisplayLayout.Bands[0].Columns["AfInfo"].CellAppearance.BackColor = Color.GreenYellow; //ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton; //ultraGridZgS.DisplayLayout.Bands[0].Columns["AfProLin"].CellAppearance.BackColor = Color.GreenYellow; //ultraGridZgS.DisplayLayout.Bands[0].Columns["TimeDiffer"].CellAppearance.BackColor = Color.GreenYellow; //ultraGridZgS.DisplayLayout.Bands[0].Columns["AfProNum"].CellAppearance.BackColor = Color.GreenYellow; //ultraGridZgS.DisplayLayout.Bands[0].Columns["AfProLin"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton; //ultraGridZgS.DisplayLayout.Bands[0].Columns["ProdGradename"].CellAppearance.BackColor = Color.Wheat; UltraNumericEditor[] uneArr = new UltraNumericEditor[3]; for (int i = 0; i < uneArr.Length; i++) { uneArr [i]= new UltraNumericEditor(); uneArr[i].NumericType =NumericType.Double; if (i == 1) { uneArr[i].MaskInput = "nnnnn"; } else { uneArr[i].MaskInput = "nnnnn.nn"; } uneArr[i].SpinButtonDisplayStyle = Infragistics.Win.ButtonDisplayStyle.Always; this.Controls.Add(uneArr[i]); uneArr[i].Visible = false; } //uneArr[0].SpinIncrement = 0.01; //uneArr[1].SpinIncrement = 50; //uneArr[2].SpinIncrement =10; //ultraGridZgS.DisplayLayout.Bands[0].Columns["Outdiameter"].EditorComponent = uneArr[0]; //ultraGridZgS.DisplayLayout.Bands[0].Columns["Wallthick"].EditorComponent = uneArr[0]; //ultraGridZgS.DisplayLayout.Bands[0].Columns["OutdiameterZg"].EditorComponent = uneArr[0]; //ultraGridZgS.DisplayLayout.Bands[0].Columns["WallthickZg"].EditorComponent = uneArr[0]; ////ultraGridZgS.DisplayLayout.Bands[0].Columns["PipeLengthMin"].EditorComponent = uneArr[0]; ////ultraGridZgS.DisplayLayout.Bands[0].Columns["PipeLengthMax"].EditorComponent = uneArr[0]; //ultraGridZgS.DisplayLayout.Bands[0].Columns["Aimoutdiameter"].EditorComponent = uneArr[0]; //ultraGridZgS.DisplayLayout.Bands[0].Columns["Aimwallthick"].EditorComponent = uneArr[0]; //ultraGridZgS.DisplayLayout.Bands[0].Columns["Aimlength"].EditorComponent = uneArr[0]; //ultraGridZgS.DisplayLayout.Bands[0].Columns["RollLength"].EditorComponent = uneArr[0]; //ultraGridZgS.DisplayLayout.Bands[0].Columns["LenGpSingle"].EditorComponent = uneArr[2]; //ultraGridZgS.DisplayLayout.Bands[0].Columns["LenCuthead"].EditorComponent = uneArr[1]; //ultraGridZgS.DisplayLayout.Bands[0].Columns["LenCutend"].EditorComponent = uneArr[1]; decisionFlsg(false); } private void decisionFlsg( Boolean b) { if (b) { UltraComboEditor uceAbc = new UltraComboEditor(); ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].EditorComponent = uceAbc; ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList; ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].EditorComponent = uceAbc; ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList; ValueList vlistSteel1 = new ValueList(); ; vlistSteel1.ValueListItems.Insert(0, "1", "1"); vlistSteel1.ValueListItems.Insert(1, "2", "2"); vlistSteel1.ValueListItems.Insert(2, "3", "3"); vlistSteel1.ValueListItems.Insert(3, "4", "4"); vlistSteel1.ValueListItems.Insert(4, "5", "5"); vlistSteel1.ValueListItems.Insert(5, "6", "6"); ultraGridZgS.DisplayLayout.Bands[0].Columns["Ggfqs"].ValueList = vlistSteel1; ultraGridZgS.DisplayLayout.Bands[0].Columns["Ggfqs"].CellActivation = Activation.AllowEdit; ultraGridZgS.DisplayLayout.Bands[0].Columns["Bcs"].ValueList = vlistSteel1; ultraGridZgS.DisplayLayout.Bands[0].Columns["Bcs"].CellActivation = Activation.AllowEdit; DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryMandrelSpec", new object[] { "1" }, this.ob); if (dt != null && dt.Rows.Count > 0) { ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt, "XX", "XX"); //vlistSteel.ValueListItems.Insert(0, "", ""); ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].ValueList = vlistSteel; ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].CellActivation = Activation.AllowEdit; } DataTable dt1 = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryMandrelSpec", new object[] { "2" }, this.ob); if (dt1 != null && dt1.Rows.Count > 0) { ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt1, "XX", "XX"); //vlistSteel.ValueListItems.Insert(0, "", ""); ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].ValueList = vlistSteel; ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].CellActivation = Activation.AllowEdit; } DataTable dt2 = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryMandrelSpec", new object[] { "3" }, this.ob); if (dt2 != null && dt2.Rows.Count > 0) { ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt2, "XX", "XX"); //vlistSteel.ValueListItems.Insert(0, "", ""); ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgwj"].ValueList = vlistSteel; ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgwj"].CellActivation = Activation.AllowEdit; } DataTable dt3 = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryMandrelSpec", new object[] { "4" }, this.ob); if (dt3 != null && dt3.Rows.Count > 0) { ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt3, "XX", "XX"); //vlistSteel.ValueListItems.Insert(0, "", ""); ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgbh"].ValueList = vlistSteel; ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgbh"].CellActivation = Activation.AllowEdit; } } //else { // ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].EditorComponent = null; // ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Default; // ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].CellActivation = Activation.ActivateOnly; // ultraGridZgS.DisplayLayout.Bands[0].Columns["Xbzj"].EditorComponent = null; // ultraGridZgS.DisplayLayout.Bands[0].Columns["Xbzj"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Default; // ultraGridZgS.DisplayLayout.Bands[0].Columns["Xbzj"].CellActivation = Activation.ActivateOnly; // ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgwj"].EditorComponent = null; // ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgwj"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Default; // ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgwj"].CellActivation = Activation.ActivateOnly; // ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgbh"].EditorComponent = null; // ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgbh"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Default; // ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgbh"].CellActivation = Activation.ActivateOnly; //} } private void InitTime() { DateTime now = DateTime.Now; DateTime d1 = new DateTime(now.Year, now.Month, 1); DateTime d2 = d1.AddMonths(1).AddSeconds(-1); //txtPlanTimeB1.Value = d1; //txtPlanTimeB2.Value = d2; //txtPlanTimeE1.Value = d1; //txtPlanTimeE2.Value = d2; } /// /// 初始化芯棒直径 /// /// 产线 /// 孔型编码 /// 控制外径 /// 控制壁厚 //private void InitDimaM(string plineCode, string passCode, string aimoutdiameter, string aimwallthick) //{ // DataTable dt1 = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnProcessOrd.queryPlnMandrelId", new object[] { plineCode, passCode, aimoutdiameter,aimwallthick }, this.ob); // UltraComboEditor uce = new UltraComboEditor(); // ultraGridZgS.Controls.Add(uce); // uce.Visible = false; // uce.DropDownListWidth = -1; // uce.DropDownStyle = DropDownStyle.DropDownList; // uce.DataSource = dt1; // uce.DisplayMember = "DIAMETER_MANDREL"; // uce.ValueMember = "MANDREL_ID"; // ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].EditorComponent = uce; // ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList; //} private void chcPline_CheckedChanged(object sender, EventArgs e) { //if (chcPline.Checked) { comPline.ReadOnly = false; } else { comPline.ReadOnly = true; } if (chcOrderNo.Checked) { txtPlanNo.ReadOnly = false; } else { txtPlanNo.ReadOnly = true; } //if (chcProPlanId.Checked) { txtProPlanId.ReadOnly = false; } else { txtProPlanId.ReadOnly = true; } //if (chcPlanTimeB.Checked) { txtPlanTimeB1.ReadOnly = false; txtPlanTimeB2.ReadOnly = false; } else { txtPlanTimeB1.ReadOnly = true; txtPlanTimeB2.ReadOnly = true; } //if (chcPlanTimeE.Checked) { txtPlanTimeE1.ReadOnly = false; txtPlanTimeE2.ReadOnly = false; } else { txtPlanTimeE1.ReadOnly = true; txtPlanTimeE2.ReadOnly = true; } } private void ultraGridZgS_InitializeRow(object sender, InitializeRowEventArgs e) { PlanHelper.ControlCellEdit(e.Row); } /// /// 查询 /// private void Query() { WaitingForm2 wf3 = new WaitingForm2("正在刷新，请稍候...."); try { this.Cursor = Cursors.WaitCursor; //执行状态 // string[] statusArr = contorlPlanStatus1.statusArr; //合同号 string orderNo = ""; if (chcOrderNo.Checked) { orderNo = txtPlanNo.Text.Trim(); } List listSource = EntityHelper.GetData ("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlanOrderCxMes", new object[] { orderNo }, this.ob); TPoDemandPlanBindingSource.DataSource = listSource; // dtPlinGroup = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlinCodeGroup", null, this.ob); _entityList = null; _ProPlanId = ""; _ProPlanId = ""; } finally { wf3.Close(); this.Cursor = Cursors.Default; } } /// /// 修改切头尾数据 /// private void UpdateCrop() { try { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = new ArrayList(); IQueryable checkRows = ultraGridZgS.Rows.AsQueryable().Where("CHC = 'True'"); if (checkRows.Count() == 0) { MessageUtil.ShowWarning("请选择订单!"); return; } PlanComm.WaitFromOpen(this.Cursor); foreach (UltraGridRow uRow in checkRows) { ArrayList param = new ArrayList(); param.Add(UserInfo.GetUserName()); param.Add(uRow.Cells["ProPlanId"].Value.ToString()); param.Add(uRow.Cells["GxPlanNo"].Value.ToString()); param.Add(uRow.Cells["InwlId"].Text); param.Add(uRow.Cells["OutwlId"].Text); param.Add(uRow.Cells["PlineCode"].Value.ToString()); list.Add(param); } if (list.Count == 0) { PlanComm.WaitFromColse(this.Cursor); MessageUtil.ShowTips("0条修改成功，" + messageErr.Count + "条修改失败。\n" + messageErr[0]); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.processOrder.base.ProducHelper"; ccp.MethodName = "updateCrop"; ccp.ServerParams = new object[] { list, UserInfo.GetUserName() }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("批量获取切头尾成功！")) { Query(); } } catch (Exception ex) { PlanComm.WaitFromColse(this.Cursor); if (!(ex is MESException)) { MessageUtil.ShowError(ex.Message); } } } /// /// 初始化 /// private void InitData() { ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); bool flag = ProducHelper.InitData(list, "D", this.ob); if (flag) { _ProPlanId = ((PlnOrderZgSEntity)list[0]).ProPlanId; _GxPlanNo = ((PlnOrderZgSEntity)list[0]).GxPlanNo; Query(); } } private void ultraGridZgS_AfterRowActivate(object sender, EventArgs e) { UltraGridRow ugrAc = ultraGridZgS.ActiveRow; if (ugrAc == null) { return; } //foreach (UltraGridRow ugr in ultraGridZgS.Rows) //{ // if (ugr.Cells["ProPlanId"].Text.Equals(ugrAc.Cells["ProPlanId"].Text)) // { // ugr.RowSelectorAppearance.BackColor = Color.LightGreen; // } // else // { // ugr.RowSelectorAppearance.BackColor = _backColor; // } // if (ugr.Cells["PlanUsetime"].Value == null || ugr.Cells["PlanUsetime"].Value.ToString().Equals("") || Convert.ToDouble(ugr.Cells["PlanUsetime"].Value.ToString()) <= 0) // { // ugr.Cells["PlanUsetime"].Appearance.BackColor = Color.MistyRose; // } // if (ugr.Cells["ExeStatus"].Value.ToString().Equals("生产中")) // { // ugr.Cells["PlanTimeB"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128); // } // if (ugr.Cells["IsRepairPln"].Text.Equals("是")) // { // ugr.Cells["PlanUsetime"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128); // ugr.Cells["RepairType"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128); // } //} //proPlanId = ugrAc.Cells["ProPlanId"].Text.ToString(); //gxPlanNo = ugrAc.Cells["GxPlanNo"].Text.ToString(); // doQueryActual(proPlanId, gxPlanNo); } /// /// 虚拟炉计划 /// /// /// private void doQueryVirtual(string proPlanId, string gxPlanNo) { DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.doQueryVirtual", new object[] { proPlanId, gxPlanNo }, this.ob); // GridHelper.CopyDataToDatatable(dt, dataTable1, true); } /// /// 实际炉计划 /// /// /// private void doQueryActual(string proPlanId, string gxPlanNo) { // List listSourceM = EntityHelper.GetData //("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.doQueryActual", new object[] { proPlanId, gxPlanNo }, ob); // plnZyZgMCEntityBindingSource.DataSource = listSourceM; // foreach (UltraGridRow ugr in ultraGrid1.Rows) // { // ugr.Cells["DELETE"].Value = "删除炉计划"; // //没有实际炉计划，主炉计划变颜色 // if (ugr.Cells["ActuaWt"].Value.ToString().Equals("")) // { // //ugr.RowSelectorAppearance.BackColor = Color.GreenYellow; // ugr.Appearance.BackColor = Color.Orange; // } // if (!string.IsNullOrEmpty(ugr.Cells["ApplyDesc"].Value.ToString2())) // { // ugr.Appearance.BackColor = Color.Red; // } // //if (!ugr.Cells["Planstatus"].Value.ToString().Equals("计划") && ugr.Cells["Planstatus"].Value.ToString().Equals("下发")) // //{ // // if (int.Parse(ugr.Cells["ActCount"].Value.ToString()) > 0) // // { // // ugr.Cells["ActCount"].Column.CellAppearance.BackColor = Color.; // // } // //} // } } private void ultraGridZgS_CellChange(object sender, CellEventArgs e) { try { ultraGridZgS.UpdateData(); if (e.Cell.Column.Key.Equals("CHC")) { IQueryable chcRows = ultraGridZgS.Rows.AsQueryable().Where(a => a.GetValue("CHC") == "True"); if (chcRows != null && chcRows.Count() > 0) { decisionFlsg(true); } else { decisionFlsg(false); } } //TZH 2024.8.16 add 自动计算 foreach (var ultraGridRow in ultraGridZgS.Rows) { if ((bool)ultraGridRow.Cells["CHC"].Value) { decimal Ggfqs = 0; if (ultraGridRow.Cells["Ggfqs"].Value.ToString() != "") { Ggfqs = decimal.Parse((ultraGridRow.Cells["Ggfqs"].Value.ToString()));//钢管分切数 } decimal Cpcd = 0; if (ultraGridRow.Cells["Cpcd"].Value.ToString() != "") { Cpcd = decimal.Parse(ultraGridRow.Cells["Cpcd"].Value.ToString());//成品长度 } decimal Qt = 0; if (ultraGridRow.Cells["Qt"].Value.ToString() != "") { Qt = decimal.Parse(ultraGridRow.Cells["Qt"].Value.ToString());//切头 } decimal Qw = 0; if (ultraGridRow.Cells["Qw"].Value.ToString()!="") { Qw = decimal.Parse(ultraGridRow.Cells["Qw"].Value.ToString()); //切尾 } decimal ContractedQuantity=0; if (ultraGridRow.Cells["ContractedQuantity"].Value.ToString()!="") { ContractedQuantity = decimal.Parse(ultraGridRow.Cells["ContractedQuantity"].Value.ToString()); //合同量 } decimal Jhlc = 0; if (ultraGridRow.Cells["Jhlc"].Value.ToString() != "") { Jhlc = decimal.Parse(ultraGridRow.Cells["Jhlc"].Value.ToString()); //交货量差 } decimal OuterDiam = 0; if (ultraGridRow.Cells["OuterDiam"].Value.ToString()!="") { OuterDiam = decimal.Parse(ultraGridRow.Cells["OuterDiam"].Value.ToString()); //外径 } decimal ControlsThickness = 0; if (ultraGridRow.Cells["ControlsThickness"].Value.ToString() != "") { ControlsThickness = decimal.Parse(ultraGridRow.Cells["ControlsThickness"].Value.ToString()); //控制壁厚 } decimal Dbcplzl = 0; if(ultraGridRow.Cells["Dbcplzl"].Value.ToString()!="") { Dbcplzl = decimal.Parse(ultraGridRow.Cells["Dbcplzl"].Value.ToString()); //单倍尺坯料重量 } decimal Zzcd = 0; if(ultraGridRow.Cells["Zzcd"].Value.ToString()!="") { Zzcd = decimal.Parse(ultraGridRow.Cells["Zzcd"].Value.ToString()); //轧制长度 } decimal Zzzl = 0; if(ultraGridRow.Cells["Zzzl"].Value.ToString()!="") { Zzzl = decimal.Parse(ultraGridRow.Cells["Zzzl"].Value.ToString()); //轧制重量 } decimal Mz = 0; if(ultraGridRow.Cells["Mz"].Value.ToString()!="") { Mz = decimal.Parse(ultraGridRow.Cells["Mz"].Value.ToString()); //米重 } decimal Dbcplcd = 0; if(ultraGridRow.Cells["Dbcplcd"].Value.ToString()!="") { Dbcplcd = decimal.Parse(ultraGridRow.Cells["Dbcplcd"].Value.ToString()); //单倍尺坯料长度 } decimal Ssl = 0; if (ultraGridRow.Cells["Ssl"].Value.ToString()!="") { Ssl = decimal.Parse(ultraGridRow.Cells["Ssl"].Value.ToString()); //烧损率 } decimal Gpzj = 0; if (ultraGridRow.Cells["Gpzj"].Value.ToString()!="") { Gpzj = decimal.Parse(ultraGridRow.Cells["Gpzj"].Value.ToString()); //管坯直径 } decimal WgD = 0; if (ultraGridRow.Cells["WgD"].Value.ToString()!="") { WgD = decimal.Parse(ultraGridRow.Cells["WgD"].Value.ToString()); //毛管外径 } decimal WgH = 0; if (ultraGridRow.Cells["WgH"].Value.ToString()!="") { WgH = decimal.Parse(ultraGridRow.Cells["WgH"].Value.ToString()); //毛管壁厚 } UltraComboEditor uceAbc = new UltraComboEditor(); ultraGridZgS.DisplayLayout.Bands[0].Columns["Gpzj"].EditorComponent = uceAbc; ultraGridZgS.DisplayLayout.Bands[0].Columns["Gpzj"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList; ValueList vlistSteel = new ValueList(); ; vlistSteel.ValueListItems.Insert(0, "380", "380"); vlistSteel.ValueListItems.Insert(1, "390", "390"); vlistSteel.ValueListItems.Insert(2, "400", "400"); vlistSteel.ValueListItems.Insert(3, "450", "450"); vlistSteel.ValueListItems.Insert(4, "460", "460"); vlistSteel.ValueListItems.Insert(5, "500", "500"); ultraGridZgS.DisplayLayout.Bands[0].Columns["Gpzj"].ValueList = vlistSteel; ultraGridZgS.DisplayLayout.Bands[0].Columns["Gpzj"].CellActivation = Activation.AllowEdit; if (ultraGridRow.Cells["Gpzj"].Value.ToString() != "") { if (ultraGridRow.Cells["Gpzj"].Value.Equals("380")) { ultraGridRow.Cells["Mz"].Value = "0.885"; Mz = decimal.Parse("0.885"); } if (ultraGridRow.Cells["Gpzj"].Value.Equals("390")) { ultraGridRow.Cells["Mz"].Value = "0.94"; Mz = decimal.Parse("0.94"); } if (ultraGridRow.Cells["Gpzj"].Value.Equals("400")) { ultraGridRow.Cells["Mz"].Value = "0.995"; Mz = decimal.Parse("0.995"); } if (ultraGridRow.Cells["Gpzj"].Value.Equals("450")) { ultraGridRow.Cells["Mz"].Value = "1.24"; Mz = decimal.Parse("1.24"); } if (ultraGridRow.Cells["Gpzj"].Value.Equals("460")) { ultraGridRow.Cells["Mz"].Value = "1.3"; Mz = decimal.Parse("1.3"); } if (ultraGridRow.Cells["Gpzj"].Value.Equals("500")) { ultraGridRow.Cells["Mz"].Value = "1.532"; Mz = decimal.Parse("1.532 "); } } //tzh 9.16 ultraGridRow.Cells["Ssl"].Value = "0.975"; //暂时不用 tzh if (ultraGridRow.Cells["Pass"].Value.ToString() != "" && ultraGridRow.Cells["DiameterMandrel"].Value.ToString() != "") { DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryMandrelSpec", new object[] { ultraGridRow.Cells["Pass"].Value.ToString(), ultraGridRow.Cells["DiameterMandrel"].Value.ToString() }, this.ob); if (dt != null && dt.Rows.Count > 0) { //ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt, "XX", "XX"); ultraGridRow.Cells["WgD"].Value = dt.Rows[0][0]; ultraGridRow.Cells["WgH"].Value = dt.Rows[0][1]; } //ultraGridRow.Cells["Mgwj"].Value = ""; //ultraGridRow.Cells["Mgbh"].Value = ""; } if (ultraGridRow.Cells["Ggfqs"].Value.ToString() != "" && ultraGridRow.Cells["Cpcd"].Value.ToString() != "" && ultraGridRow.Cells["Qt"].Value.ToString() != ""&& ultraGridRow.Cells["Qw"].Value.ToString() != "") { ultraGridRow.Cells["Zzcd"].Value = Ggfqs * Cpcd + Qt / 1000 + Qw / 1000; Zzcd = Ggfqs * Cpcd + Qt/1000 + Qw/1000 ; } if (ultraGridRow.Cells["OuterDiam"].Value.ToString() != "" && ultraGridRow.Cells["ControlsThickness"].Value.ToString() != "" && Zzcd != 0) { //轧制重量公式：(外径-控制壁厚)*控制壁厚*轧制长度/1000 ultraGridRow.Cells["Zzzl"].Value = (OuterDiam - ControlsThickness) * ControlsThickness * Zzcd * decimal.Parse("0.02466 ") / 1000; Zzzl = (OuterDiam - ControlsThickness) * ControlsThickness * Zzcd * decimal.Parse("0.02466 ") / 1000; } if (ultraGridRow.Cells["Zzzl"].Value.ToString() != "" && ultraGridRow.Cells["Ssl"].Value.ToString() != "" && Zzzl != 0) { //单倍尺坯料长度公式：轧制重量/1.532*1000/烧损率Ssl默认写成0.975 按照要求数据取整而且十位取整 ultraGridRow.Cells["Dbcplcd"].Value = Math.Floor((Zzzl / decimal.Parse("1.532") * 1000 / decimal.Parse("0.975")) / 10) *10; Dbcplcd = Zzzl / decimal.Parse("1.532") * 1000 / decimal.Parse("0.975"); } if (ultraGridRow.Cells["Mz"].Value.ToString() != "" && Dbcplcd != 0) { //单倍尺坯料重量公式：米重*单倍尺坯料长度 ultraGridRow.Cells["Dbcplzl"].Value = Mz * Dbcplcd / 1000; Dbcplzl = Mz * Dbcplcd / 1000; } if (ultraGridRow.Cells["ContractedQuantity"].Value.ToString() != "" && ultraGridRow.Cells["Jhlc"].Value.ToString() != "" && ultraGridRow.Cells["OuterDiam"].Value.ToString() != "" && ultraGridRow.Cells["ControlsThickness"].Value.ToString() != "" && ultraGridRow.Cells["Cpcd"].Value.ToString() != "" && ultraGridRow.Cells["Ggfqs"].Value.ToString() != "" && Dbcplzl != 0) { //采购量Max公式：（(合同量+（合同量*交货量差))/((外径-控制壁厚)*控制壁厚*成品长度*0.02466/1000)/钢管分切数*单倍尺坯料重量 ultraGridRow.Cells["HtcgzlMax"].Value = ((ContractedQuantity + (ContractedQuantity * Jhlc)) / ((OuterDiam - ControlsThickness) * ControlsThickness * Cpcd * decimal.Parse("0.02466") / 1000) / Ggfqs * Dbcplzl); //采购量Min公式：（合同量/((外径-控制壁厚)*控制壁厚*成品长度*0.02466/1000)/钢管分切数*单倍尺坯料重量 ultraGridRow.Cells["HtcgzlMin"].Value = ((ContractedQuantity) / ((OuterDiam - ControlsThickness) * ControlsThickness * Cpcd * decimal.Parse("0.02466") / 1000) / Ggfqs * Dbcplzl); //ultraGridRow.Cells["QuantityPurchased"].Value = ((ContractedQuantity + (ContractedQuantity * Jhlc)) / ((OuterDiam - ControlsThickness) * ControlsThickness * Cpcd * decimal.Parse("0.02466") / 1000) / Ggfqs * Dbcplzl); } if (ultraGridRow.Cells["Gpzj"].Value.ToString() != "" && ultraGridRow.Cells["WgD"].Value.ToString() != "" && ultraGridRow.Cells["WgH"].Value.ToString() != "" && Dbcplcd != 0) { //毛管长度公式：((管坯直径/2)*(管坯直径/2))*单倍尺坯料长度/(((毛管外径/2)*(毛管外径/2))-(((毛管外径/2)-毛管壁厚)*((毛管外径/2)-毛管壁厚)))/1000 ultraGridRow.Cells["Mgcd"].Value = ((Gpzj / 2) * (Gpzj / 2)) * Dbcplcd / (((WgD / 2) * (WgD / 2)) - (((WgD / 2) - WgH) * ((WgD / 2) - WgH))) / 1000; } } } } catch (Exception) { } } /// /// 删除检修计划 /// public void DeleteRepairPlan() { ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); bool flag = ProducHelper.DeleteRepairPlan(list, "D", this.ob); if (flag) { _ProPlanId = ((PlnOrderZgSEntity)list[0]).ProPlanId; _GxPlanNo = ((PlnOrderZgSEntity)list[0]).GxPlanNo; Query(); } } private void comPline_ValueChanged(object sender, EventArgs e) { //if (comPline == null) //{ return; } //else //{ if (!CustomInfo.Equals("0")) { } } } /// /// 下发(取消) /// private void Issued(string isFlag) { IQueryable checkRows = ultraGridZgS.Rows.AsQueryable().Where("CHC = 'True'"); if (checkRows.Count() == 0) { MessageUtil.ShowWarning("请选择订单!"); return; } if (isFlag.Equals("0")) {int count=0; foreach (UltraGridRow row in checkRows) { if (row.Cells["LenCuthead"].Text.Trim().Equals("")) { MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",切头无数据，不允许确认！"); return; } if (row.Cells["LenCutend"].Text.Trim().Equals("")) { MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",切尾无数据，不允许确认！"); return; } if (!row.Cells["Verify1"].Text.Trim().Equals("")) { string str = row.Cells["Verify1"].Text.Trim(); string[] strArray = str.Split(new char[2] { '：', 'm' }); double len = double.Parse(strArray[1].ToString()); if (len - 4 > 0) { if (MessageUtil.ShowYesNoAndQuestion("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",管余长大于4m,是否确认！") == DialogResult.No) return; } if (len < 0) { if (MessageUtil.ShowYesNoAndQuestion("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",管余长小于0,是否确认！") == DialogResult.No) return; } } if (double.Parse(row.Cells["Aimlength"].Value.ToString()) >= 13.5 && row.Cells["WholeBacklogDesc"].Text.Trim().Contains("热处理")) { if (MessageUtil.ShowYesNoAndQuestion("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",目标长度可能超限,需热处理确认长度,是否确认！") == DialogResult.No) return; } //if (!row.Cells["Verify2"].Text.Trim().Equals("")) //{ // MessageUtil.ShowTips("长度超出范围！"); // return; //} int numS = 0;//排产支 int plansNum = 0;//计划产出支 if (!row.Cells["NumS"].Text.ToString().Trim().Equals("")) { numS = int.Parse(row.Cells["NumS"].Value.ToString()); } if (!row.Cells["PlansNum"].Text.ToString().Trim().Equals("")) { plansNum = int.Parse(row.Cells["PlansNum"].Value.ToString()); } if (numS <= 0) { MessageUtil.ShowTips("排产支数小于等于0！"); return; } int num = plansNum / numS; if (!row.Cells["Verify3"].Text.Trim().Equals("") || num > 2) { count++; //if (MessageUtil.ShowYesNoAndQuestion("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",连轧后长度小于托管机最短,脱不出或计划产出支除以排产支大于2,是否继续？") == DialogResult.No) return; } //if (row.Cells["CicGp"].Text.Trim().Equals("")) //{ // MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",钢种索引码为空！"); // return; //} if (!row.Cells["LengthdiscN"].Text.Trim().Equals("") && row.Cells["ApplyStatus"].Text.Trim().Equals("")) { MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",推荐合同长度未申请！"); return; } if (row.Cells["ApplyStatus"].Text.Trim().Equals("申请")) { MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",推荐合同长度未审核！"); return; } } if (count>0) { if (MessageUtil.ShowYesNoAndQuestion("其中有" + count + "条,连轧后长度小于托管机最短,脱不出或计划产出支除以排产支大于2,是否继续？") == DialogResult.No) return; } } else if (isFlag.Equals("2")) { string porderstatus = "";//合同状态 foreach (UltraGridRow row in checkRows) { 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; } //if (row.Cells["IsPlanOk"].Text.Trim().Equals("是")) //{ // MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",未确认,不允许炉计划下发！"); // return; //} //if (row.Cells["ZyBatchId"].Text.Equals("")) //{ // MessageUtil.ShowWarning("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",轧批号不能为空!"); // return; //} } } //else if (isFlag.Equals("3")) //{//取消炉计划下发 // foreach (UltraGridRow row in checkRows) // { // int numz = 0; // double wtz = 0; // if (!row.Cells["FurnaNum"].Text.ToString().Equals("")) // { // numz = int.Parse(row.Cells["FurnaNum"].Value.ToString()); // wtz = double.Parse(row.Cells["FurnaWeight"].Value.ToString()); // } // int numLj = 0; // double wtLj = 0; // if (!row.Cells["LjNum"].Text.ToString().Equals("")) // { // numLj = int.Parse(row.Cells["LjNum"].Value.ToString()); // wtLj = double.Parse(row.Cells["LjWeight"].Value.ToString()); // } // int batNum = 0; // double batWt = 0; // if (!row.Cells["CkNum"].Text.ToString().Equals("")) // { // batNum = int.Parse(row.Cells["CkNum"].Value.ToString()); // batWt = double.Parse(row.Cells["CkWeight"].Value.ToString()); // } // //int num = numz + numLj + batNum; // if (numz > 0) // { // MessageUtil.ShowWarning("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",已装炉,不能撤销下发!"); // return; // } // if (numLj > 0) // { // MessageUtil.ShowWarning("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",已LJ,不能撤销下发!"); // return; // } // if (batNum > 0) // { // MessageUtil.ShowWarning("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",已出库,不能撤销下发!"); // return; // } // } //} //else if (isFlag.Equals("1")) //{ // foreach (UltraGridRow row in checkRows) // { // if (row.Cells["IfStoveIssued"].Text.Trim().Equals("是")) // { // MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",已炉计划下发！"); // return; // } // } //} ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); bool flag = ProducHelper.issuedPlanOrder(list, UserInfo.GetUserName(), isFlag, "D", this.ob); if (flag) { _ProPlanId = ((PlnOrderZgSEntity)list[0]).ProPlanId; _GxPlanNo = ((PlnOrderZgSEntity)list[0]).GxPlanNo; Query(); } } private void ultraGridZgS_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGridZgS.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHC"].Value = true; } } } private void ultraGridZgS_ClickCellButton(object sender, CellEventArgs e) { UltraGridRow row = ultraGridZgS.ActiveRow; if (e.Cell.Column.Key.Equals("CraftFileNo")) { string filePath = row.GetValue("CraftPath"); dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, filePath); askDown.Show(); } else if (e.Cell.Column.Key.Equals("CraftFileLv2G")) { string craftFileLv2G = row.GetValue("CraftFileLv2GPath"); dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, craftFileLv2G); askDown.Show(); } else if (e.Cell.Column.Key.Equals("DiameterGp")) { string exeStatus = row.GetValue("ExeStatus"); if (!exeStatus.Equals("计划") && !exeStatus.Equals("生产中")) { return; } string ordLnDlyPk = row.GetValue("OrdLnDlyPk"); string proPlanId = row.GetValue("ProPlanId"); string gxPlanNo = row.GetValue("GxPlanNo"); string gradeCode = row.GetValue("GradeCode"); if (gradeCode.Equals("")) { return; } string[] groupCic = null; if (!row.GetValue("GradeCode").Equals("")) { groupCic = row.Cells["CicGroupGp"].Text.ToString().Split(','); } string cicGp = row.GetValue("CicGp"); //int numz = 0; //double wtz = 0; //if (!row.Cells["FurnaNum"].Text.ToString().Equals("")) //{ // numz = int.Parse(row.Cells["FurnaNum"].Value.ToString()); // wtz = double.Parse(row.Cells["FurnaWeight"].Value.ToString()); //} int numLj = 0; double wtLj = 0; //if (!row.Cells["LjNum"].Value.ToString().Equals("0")) //{ numLj = int.Parse(row.Cells["LjNum"].Value.ToString()); wtLj = double.Parse(row.Cells["LjWeight"].Value.ToString()); //} //else //{ // numLj = int.Parse(row.Cells["MatchNumIn"].Value.ToString()); // wtLj = double.Parse(row.Cells["MatchWtIn"].Value.ToString()); //} //int batNum = 0; //double batWt = 0; //if (!row.Cells["CkNum"].Text.ToString().Equals("")) //{ // batNum = int.Parse(row.Cells["CkNum"].Value.ToString()); // batWt = double.Parse(row.Cells["CkWeight"].Value.ToString()); //} //int num = numz + numLj + batNum; int num = numLj; FrmBomConfirm frmBomConfirm = new FrmBomConfirm(ordLnDlyPk, proPlanId, gxPlanNo, this.ob, groupCic, cicGp,num); frmBomConfirm.ShowDialog(); bool flag = frmBomConfirm.Flag; if (flag) { Query(); }//如果有修改数据，则刷新页面 } else if (e.Cell.Column.Key.Equals("Gradename")) { string exeStatus = row.GetValue("ExeStatus"); if (!exeStatus.Equals("计划") && !exeStatus.Equals("生产中")) { return; } string ordLnDlyPk = row.GetValue("OrdLnDlyPk"); string proPlanId = row.GetValue("ProPlanId"); string gxPlanNo = row.GetValue("GxPlanNo"); string gradeCode = row.GetValue("GradeCode"); if (gradeCode.Equals("")) { return; } string[] groupCic = null; if (!row.GetValue("GradeCode").Equals("")) { groupCic = row.Cells["CicGroupGp"].Text.ToString().Split(','); } string cicGp = row.GetValue("CicGp"); int numz = 0; double wtz = 0; //if (!row.Cells["FurnaNum"].Text.ToString().Equals("")) //{ // numz = int.Parse(row.Cells["FurnaNum"].Value.ToString()); // wtz = double.Parse(row.Cells["FurnaWeight"].Value.ToString()); //} int numLj = 0; double wtLj = 0; //if (!row.Cells["LjNum"].Text.ToString().Equals("")) //{ numLj = int.Parse(row.Cells["LjNum"].Value.ToString()); wtLj = double.Parse(row.Cells["LjWeight"].Value.ToString()); //} //int batNum = 0; //double batWt = 0; //if (!row.Cells["CkNum"].Text.ToString().Equals("")) //{ // batNum = int.Parse(row.Cells["CkNum"].Value.ToString()); // batWt = double.Parse(row.Cells["CkWeight"].Value.ToString()); //} int num = numLj ; FrmBomConfirm frmBomConfirm = new FrmBomConfirm(ordLnDlyPk, proPlanId, gxPlanNo, this.ob, groupCic, cicGp,num); frmBomConfirm.ShowDialog(); bool flag = frmBomConfirm.Flag; if (flag) { Query(); }//如果有修改数据，则刷新页面 } else if (e.Cell.Column.Key.Equals("AfProLin")) { string proPlanId = row.GetValue("ProPlanId"); string afInfo = row.GetValue("AfInfo"); if (afInfo == null || afInfo.Length == 0) { return; } FrmPreGxInfo frmPreGxInfo = new FrmPreGxInfo(proPlanId, "D", "Af", this.ob); frmPreGxInfo.ShowDialog(); } else if (e.Cell.Column.Key.Equals("DiameterMandrel")) { //InitDimaM(ugr.Cells["PlineCode"].Text.ToString().Trim(), ugr.Cells["PassCode"].Text.ToString().Trim(), ugr.Cells["Aimoutdiameter"].Text.ToString().Trim(), ugr.Cells["Aimwallthick"].Text.ToString().Trim()); FrmDiameterMandrel frmDm = new FrmDiameterMandrel(row.GetValue("PlineCode"), row.GetValue("PassCode"), row.GetValue("Aimoutdiameter"), row.GetValue("Aimwallthick"), this.ob); frmDm.AutoSize = true; //frmDm.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); frmDm.Text = "芯棒直径"; frmDm.ShowDialog(); if (frmDm.DialogResult == System.Windows.Forms.DialogResult.OK) { //获取弹出窗体的属性值 row.Cells["DiameterMandrel"].Value = frmDm.DiameterMandrel; if (!frmDm.LenSingerBill.Equals("0") && double.Parse(frmDm.LenSingerBill) < double.Parse(row.Cells["LenGpSingle"].Value.ToString())) { row.Cells["LenGpSingle"].Value = frmDm.LenSingerBill; } } } else if (e.Cell.Column.Key.Equals("ApplyNo")) { UndoApply(); } else if (e.Cell.Column.Key.Equals("LengthdiscN")) { if (row.GetValue("OrdLnDlyPk").Contains("ZZBY-")) { MessageUtil.ShowTips("该合同是备料需求合同,不允许修改推荐长度描述！"); return; } if (row.GetValue("ApplyStatus") == "审批通过" || row.GetValue("ApplyStatus") == "审批不通过") { MessageUtil.ShowTips("该合同:" + row.GetValue("OrderNo") + ",已" + row.GetValue("ApplyStatus") + ",不允许修改推荐长度描述！"); return; } string len = row.GetValue("LenNo");//合同长度编码 string LenNoN = row.GetValue("LenNoN");//推荐长度编码 frmOrderLenPln lenPln = new frmOrderLenPln(ob, len, LenNoN); lenPln.ShowDialog(); if (lenPln.DialogResult == System.Windows.Forms.DialogResult.OK) { //获取弹出窗体的属性值 row.Cells["LenNoN"].Value = lenPln.LenNo; row.Cells["LengthdiscN"].Value = lenPln.LengthdiscN; } } } /// /// 设置完成 /// private void SetPlanFinish() { ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); bool flag = ProducHelper.SetPlanFinish(list, UserInfo.GetUserName(), "D", this.ob); if (flag) { _ProPlanId = ((PlnOrderZgSEntity)list[0]).ProPlanId; _GxPlanNo = ((PlnOrderZgSEntity)list[0]).GxPlanNo; Query(); } } /// /// 调整单倍坯长 /// private void ModifyGpAimWall() { this.ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (TPoDemandPlanEntity entity in list) { if (entity.QuantityPurchased == null) { MessageUtil.ShowTips("请输入采购量!"); return; } jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否报错?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "modifyGpAimWall"; ccp.ServerParams = new object[] { jsonList, "0" }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips("修改成功!"); if (ccp.ReturnObject != null) { List message = (List)JsonConvert.DeserializeObject( ccp.ReturnObject.ToString(), typeof(List)); if (message.Count == 0) { MessageUtil.ShowTips(list.Count - message.Count + "条修改成功，" + message.Count + "条修改失败。"); } else { MessageUtil.ShowTips(list.Count - message.Count + "条修改成功，" + message.Count + "条修改失败。\n" + message[0]); } if (list.Count - message.Count>0) { Query(); } } } } /// /// 调整控制壁厚 /// private void ModifyThicknesWall() { this.ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (PlnOrderZgSEntity entity in list) { if (entity.IsRepairPln.Equals("是")) { MessageUtil.ShowTips("检修计划不能调整控制壁厚!"); return; } jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否修改控制壁厚?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "modifyThicknesWall"; ccp.ServerParams = new object[] { jsonList,this.UserInfo.GetUserName() }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("调整控制壁厚成功!")) { Query(); } } /// /// 修改芯棒直接 /// private void UpdateDiameM() { try { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = new ArrayList(); //IQueryable checkRows = ultraGridZgS.Rows.AsQueryable().Where("CHC = 'True'"); ArrayList list1 = ProducHelper.GetChcRows(ultraGridZgS); if (list1 == null || list1.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } foreach (PlnOrderZgSEntity entity in list1) { if (entity.IsRepairPln.Equals("是")) { MessageUtil.ShowTips("检修计划不能调整芯棒!"); return; } if (entity.DiameterMandrel==null||entity.DiameterMandrel.Equals("")) { PlanComm.WaitFromColse(this.Cursor); MessageUtil.ShowWarning("芯棒不能为空,请选择芯棒!"); return; } ArrayList param = new ArrayList(); param.Add(entity.ProPlanId); param.Add(entity.GxPlanNo); param.Add(entity.DiameterMandrel.ToString()); list.Add(param); } if (list.Count == 0) { PlanComm.WaitFromColse(this.Cursor); MessageUtil.ShowTips("0条修改成功，" + messageErr.Count + "条修改失败。\n" + messageErr[0]); return; } if (MessageUtil.ShowYesNoAndQuestion("是否调整芯棒直径?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.processOrder.base.ProducHelper"; ccp.MethodName = "updateDimaM"; ccp.ServerParams = new object[] { list }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("芯棒直径调整成功！")) { Query(); } } catch (Exception ex) { PlanComm.WaitFromColse(this.Cursor); if (!(ex is MESException)) { MessageUtil.ShowError(ex.Message); } } } /// /// 保存 /// private void Recalculate() { try { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (TPoDemandPlanEntity entity in list) { if (entity.QuantityPurchased == null) { MessageUtil.ShowTips("请输入采购量!"); return; } jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否保存结果?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "recalculate3"; ccp.ServerParams = new object[] { jsonList }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("保存完成!")) { Query(); } } catch (Exception ex) { PlanComm.WaitFromColse(this.Cursor); if (!(ex is MESException)) { MessageUtil.ShowError(ex.Message); } } } /// /// 上传 /// private void Recalculate2() { try { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (TPoDemandPlanEntity entity in list) { if (entity.QuantityPurchased == null) { MessageUtil.ShowTips("请输入采购量!"); return; } if (entity.QuantityPurchased == '0') { MessageUtil.ShowTips("采购量不能为0!"); return; } jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否上传结果?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "recalculate4"; ccp.ServerParams = new object[] { jsonList }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("上传完成!")) { Query(); } } catch (Exception ex) { PlanComm.WaitFromColse(this.Cursor); if (!(ex is MESException)) { MessageUtil.ShowError(ex.Message); } } } /// ///修改排产月份 /// private void UpdateMonth() { try { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (PlnOrderZgSEntity entity in list) { entity.ProMonth = DateTime.Parse(entity.ProMonth.ToString()).ToString("yyyy-MM"); jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否调整生产年月?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "updateMonth"; ccp.ServerParams = new object[] { jsonList }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("调整成功!")) { //ArrayList list1 = ProducHelper.GetChcRows(ultraGridZgS); //bool flag =InitDataMonth(list1, "D", this.ob); //if (flag) //{ // _ProPlanId = ((PlnOrderZgSEntity)list[0]).ProPlanId; // _GxPlanNo = ((PlnOrderZgSEntity)list[0]).GxPlanNo; Query(); //} } } catch (Exception ex) { MessageUtil.ShowTips("请输入正确的时间格式!"); } } public static bool InitDataMonth(ArrayList entityList, string processCode, OpeBase ob) { if (entityList == null) { MessageUtil.ShowWarning("请选择订单!"); return false; } ArrayList jsonlist = new ArrayList(); foreach (Object obj in entityList) { ProducEntity entity = ProducHelper.GenerationProEntity(obj, processCode); if (entity.IfStoveIssued.Equals("是")) { MessageUtil.ShowWarning("订单编号(" + entity.ProPlanId + ") 炉计划下发!"); return false; } if (entity.PlanUseTime == null || entity.PlanUseTime.Equals("")) { MessageUtil.ShowWarning("计划耗时不能为空!"); return false; } jsonlist.Add(entity.JsonStr); } string[] param = PlanHelper.SetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.initData", new object[] { jsonlist, processCode }, ob); if (param == null) { MessageUtil.ShowTips("服务端处理失败!"); return false; } else { //MessageUtil.ShowTips(param[1]); if ((bool.Parse(param[0]))) { return true; } else { return false; } } } /// /// 申请审批 /// private void ApplyApproval() { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (PlnOrderZgSEntity entity in list) { if (entity.LenNoN == null) { MessageUtil.ShowTips("无推荐长度,不允许申请！"); return; } jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否申请?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "applyApproval"; ccp.ServerParams = new object[] { jsonList, this.UserInfo.GetUserName() }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("申请成功!")) { Query(); } } /// /// 撤销申请单 /// private void UndoApply() { ultraGridZgS.UpdateData(); UltraGridRow ugrM = ultraGridZgS.ActiveRow; if (ugrM == null) { return; } if (ugrM.Cells["ApplyNo"].Text.ToString().Equals("")) { MessageUtil.ShowTips("合同号：" + ugrM.Cells["OrderNo"].Value.ToString() + "未申请,不允许此操作！"); return; } ArrayList jsonList = new ArrayList(); jsonList.Add(ugrM.Cells["ApplyNo"].Value.ToString()); jsonList.Add(ugrM.Cells["OrdLnDlyPk"].Value.ToString()); jsonList.Add(ugrM.Cells["ProPlanId"].Value.ToString()); jsonList.Add(ugrM.Cells["GxPlanNo"].Value.ToString()); jsonList.Add(ugrM.Cells["LenNoN"].Value.ToString()); if (MessageUtil.ShowYesNoAndQuestion("是否撤销申请?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "undoApplyApproval"; ccp.ServerParams = new object[] { jsonList }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("撤销申请成功!")) { Query(); } } /// /// 修改坯子 /// private void ModifyBatter() { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (PlnOrderZgSEntity entity in list) { entity.OutsBilletFl.ToString(); jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否修改?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "modifyBatter"; ccp.ServerParams = new object[] { jsonList, this.UserInfo.GetUserName() }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { Query(); } } private void ultraGridZgS_KeyUp(object sender, KeyEventArgs e) { PlanComm.setGridCopyActColumn(this.ultraGridZgS, "CHC", e, "OutsBilletFl", "ProMonth"); } /// /// 修改索引码 /// private void UpdateGroupGp() { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (PlnOrderZgSEntity entity in list) { entity.OutsBilletFl.ToString(); jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否修改?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "updateGroupGp"; ccp.ServerParams = new object[] { jsonList }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { Query(); } } /// /// 修改轧批号 /// private void UpdateBatch() { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (PlnOrderZgSEntity entity in list) { entity.ZyBatchId.ToString(); jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否轧批号修改?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "updateBatch"; ccp.ServerParams = new object[] { jsonList }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { Query(); } } /// /// 修改判定字头 /// private void DoDecision() { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (PlnOrderZgSEntity entity in list) { entity.Decision.ToString(); jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否判定字头修改?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "doDecision"; ccp.ServerParams = new object[] { jsonList }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { Query(); } } /// /// 导入 /// private void DoImport() { try { OpenFileDialog dialog = new OpenFileDialog(); if (dialog.ShowDialog() == DialogResult.OK) { FrmImportSetPlnZg import = new FrmImportSetPlnZg(this.ob); import.ModelPatch = dialog.FileName; import.ShowDialog(); } Query(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } /// /// 修改工艺备注 /// private void DoProMemo(string falsg) { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (PlnOrderZgSEntity entity in list) { entity.Memo.ToString(); jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion(falsg.Equals("0") ? "是否工艺备注修改?" : "是否计划备注修改?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "doProMemo"; ccp.ServerParams = new object[] { jsonList, falsg }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { Query(); } } /// /// 主被动修改 /// private void DoUpdatePase() { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (PlnOrderZgSEntity entity in list) { entity.Passive.ToString(); jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否确认修改主被动?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp"; ccp.MethodName = "doUpdatePase"; ccp.ServerParams = new object[] { jsonList }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { Query(); } } private int splitterDistance = 0; private void ultraExpandableGroupBox1_ExpandedStateChanged(object sender, EventArgs e) { //if (ultraExpandableGroupBox1.Expanded == false) //{ // this.splitContainer1.SplitterDistance = splitContainer1.Size.Height - 26; //} //else //{ // this.splitContainer1.SplitterDistance = splitterDistance == 0 ? splitContainer1.Size.Height / 2 : splitterDistance; //} } private void ultraGrid1_ClickCellButton(object sender, CellEventArgs e) { //if (e.Cell.Column.Key.Equals("DELETE")) //{ // //UltraGridRow row = ultraGrid1.ActiveRow; // int countChc = 0; // if (!row.Cells["Planstatus"].Text.ToString().Trim().Equals("计划")) // { // MessageUtil.ShowTips("您选择轧管炉计划已不是计划状态,不能删除炉计划!"); // return; // } // if (MessageUtil.ShowYesNoAndQuestion("是否确认删除炉计划?") ==DialogResult.No) // return; // PlanComm.WaitFromOpen(this.Cursor); // CoreClientParam ccp = new CoreClientParam(); // ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmRollTubeLibraryZg"; // ccp.MethodName = "doDeleteZGC"; // ccp.ServerParams = new object[] { row.Cells["HeatPlanNo"].Text.ToString().Trim(), row.Cells["HeatPlanSqe"].Text.ToString().Trim(), 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("删除成功!")) // { // doQueryActual(proPlanId, gxPlanNo); // } //} } 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["FlagStoveNo"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["FlagStoveNo"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["Memo"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["Memo"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["StoveNo"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["StoveNo"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnInsingleWt"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnInsingleWt"].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["TotMumM"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["TotMumM"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["totWeightM"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["totWeightM"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["FeedHeatNo"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["FeedHeatNo"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["LenGpSingle"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["LenGpSingle"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["Planstatus"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["Planstatus"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellEvaluator = merge; e.Layout.Bands[0].Columns["ReducedWt"].MergedCellStyle = MergedCellStyle.Always; e.Layout.Bands[0].Columns["ReducedWt"].MergedCellEvaluator = merge; } /// /// 订单层重新获取工艺 /// private void DoModifyProcess() { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (PlnOrderZgSEntity entity in list) { entity.Passive.ToString(); jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否手动获取工艺?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.planStove.StoveHelper"; ccp.MethodName = "DoModifyProcess"; ccp.ServerParams = new object[] { jsonList, "D" }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("获取成功!")) { Query(); } } /// /// 订单终止 /// private void doTermination() { ArrayList messageErr = new ArrayList(); ultraGridZgS.UpdateData(); ArrayList list = ProducHelper.GetChcRows(ultraGridZgS); if (list == null || list.Count == 0) { MessageUtil.ShowTips("请选择订单！"); return; } ArrayList jsonList = new ArrayList(); foreach (PlnOrderZgSEntity entity in list) { entity.Passive.ToString(); if (!entity.ExeStatus.Equals("计划")) { MessageUtil.ShowTips("订单不是计划状态不能关闭!"); return; } jsonList.Add(JSONFormat.Format(entity)); } if (MessageUtil.ShowYesNoAndQuestion("是否终止订单?") == DialogResult.No) { return; } PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.planStove.StoveHelper"; ccp.MethodName = "doTermination"; ccp.ServerParams = new object[] { jsonList, "D" }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("终止成功!")) { Query(); } } #region 炉计划层操作 /// /// 炉计划按钮点击事件 /// /// /// private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "DeleteStatr"://删除剩余炉计划 doDeleteStatr(); break; case "AgainProcess"://重新获取工艺 doAgainProcess(); break; case "LuClose"://手动关闭炉计划 doLuClose(); break; default: break; } } /// /// 删除剩余炉计划 /// private void doDeleteStatr() { //UltraGridRow row = ultraGrid1.ActiveRow; //if (row == null) return; //int countM = 0; //int countC = 0; //ArrayList list = new ArrayList(); //foreach (UltraGridRow item in ultraGrid1.Rows) //{ // if (Convert.ToBoolean(item.Cells["CHC"].Text) == true) // { // countM++; // ArrayList list1 = new ArrayList(); // if (item.Cells["Planstatus"].Text.ToString().Equals("计划") || item.Cells["Planstatus"].Text.ToString().Equals("下发")) // { // MessageUtil.ShowTips("选中该炉计划是计划/下发状态,不能删除!"); // return; // } // list1.Add(item.Cells["HeatPlanNo"].Text.ToString().Trim()); // list1.Add(item.Cells["HeatPlanSqe"].Text.ToString().Trim()); // list.Add(list1); // } //} //if (countM == 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.FrmPlanStoveD"; //ccp.MethodName = "doDeleteStatr"; //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("删除成功!")) //{ // doQueryActual(proPlanId, gxPlanNo); //} } /// /// 重新获取工艺 /// private void doAgainProcess() { //UltraGridRow row = ultraGrid1.ActiveRow; //if (row == null) return; //int countM = 0; //ArrayList list = new ArrayList(); //foreach (UltraGridRow item in ultraGrid1.Rows) //{ // if (Convert.ToBoolean(item.Cells["CHC"].Text) == true) // { // countM++; // ArrayList list1 = new ArrayList(); // list1.Add(item.Cells["HeatPlanNo"].Text.ToString().Trim()); // list1.Add(item.Cells["HeatPlanSqe"].Text.ToString().Trim()); // list.Add(list1); // } //} //if (countM == 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.StoveHelper"; //ccp.MethodName = "doAgainProcess"; //ccp.ServerParams = new object[] { list, proPlanId, gxPlanNo, "D" }; //ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); //PlanComm.WaitFromColse(this.Cursor); //if (ccp.ReturnCode == -1) return; //MessageUtil.ShowTips(ccp.ReturnInfo); //if (ccp.ReturnInfo.Equals("获取成功!")) //{ // doQueryActual(proPlanId, gxPlanNo); //} } /// /// 手动关闭炉计划 /// private void doLuClose() { //UltraGridRow row = ultraGrid1.ActiveRow; //if (row == null) return; //int countM = 0; //ArrayList list = new ArrayList(); //string heatPlanNo = ""; //foreach (UltraGridRow item in ultraGrid1.Rows) //{ // if (Convert.ToBoolean(item.Cells["CHC"].Text) == true) // { // countM++; // ArrayList list1 = new ArrayList(); // if (item.Cells["Planstatus"].Text.ToString().Equals("关闭")) // { // MessageUtil.ShowTips("选中该炉计划是关闭状态,不能重复关闭!"); // return; // } // if (!heatPlanNo.Equals(item.Cells["HeatPlanNo"].Text.ToString())) // { // heatPlanNo = item.Cells["HeatPlanNo"].Text.ToString().Trim(); // list1.Add(item.Cells["HeatPlanNo"].Text.ToString().Trim()); // list.Add(list1); // } // } //} //if (countM == 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.FrmPlanStoveD"; //ccp.MethodName = "doLuClose"; //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("关闭成功!")) //{ // doQueryActual(proPlanId, gxPlanNo); //} } #endregion private void chkLotNo_CheckedChanged(object sender, EventArgs e) { //lotNoStart.Enabled = lotNoEnd.Enabled = chkLotNo.Checked; } private void cmbPro_EditorButtonClick(object sender, EditorButtonEventArgs e) { this.ultraGridZgS.UpdateData(); UltraGridRow row = this.ultraGridZgS.ActiveRow; if (row == null) { return; } FrmProInformation fp = new FrmProInformation(ob, row.Cells["PrdcrNo"].Text, row.Cells["IndexSeq"].Text, "D"); fp.ShowDialog(); } private void ultraGridZgS_DoubleClickHeader(object sender, DoubleClickHeaderEventArgs e) { } } }