using com.steering.mes.zgmil.entity; 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.ZGMil.Common; using Core.StlMes.Client.ZGMil.Entity; using Core.StlMes.Client.ZGMil.NodeResultQuery; 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.ZGMil.Signature { public partial class FrmDownlineManage : FrmBase { private string[] plineCodes = { }; public FrmDownlineManage() { InitializeComponent(); this.IsLoadUserView = true; } private void FrmDownlineManage_Load(object sender, EventArgs e) { DateTime now = DateTime.Now; DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天 DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天 this.StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); this.EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid2.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid2.DisplayLayout.Bands[1]); EntityHelper.ShowGridCaption(ultraGrid3.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid4.DisplayLayout.Bands[0]); NativeMethodNew na = new NativeMethodNew(this.ob); Departm = UserInfo.GetDepartment(); PlineCode = na.GetPCode(Departm);//获取 用户 对应的产线 plineCodes = BaseMethod.GetPlineCode(ValidDataPurviewIds, ob); //天淮508机组产线自动生成炉号 if (PlineCode.Equals("C072")) { ultraGroupBox2.Visible = false; } InitBase(); InitCloum(); } UltraComboEditor uceProName = new UltraComboEditor();//品名 UltraComboEditor uceSteel = new UltraComboEditor();//钢级 UltraComboEditor uceSpec = new UltraComboEditor();//规格 UltraComboEditor uceModel = new UltraComboEditor();//扣型 UltraComboEditor uceSty = new UltraComboEditor();//标准类别 UltraComboEditor uceOrderNo = new UltraComboEditor();//工序合同 private string Departm = "";//部门 private string PlineCode = "";//产线 /// /// 绑定列 /// private void InitCloum() { //PipeManageClass.InitComboEditor1(uceProName, "com.steering.mes.signature.FrmDownlineManage.doQueryProName", "PRODUCCODE", "PRODUCNAME", this.ob, false); //PipeManageClass.BindColumn(uceProName, "Producname", this.Controls, this.ultraGrid1, 0); //PipeManageClass.InitComboEditor1(uceSteel, "com.steering.mes.signature.FrmDownlineManage.doQuerySteelName", "STEELCODE","STEELNAME", this.ob, false); //PipeManageClass.BindColumn(uceSteel, "Steelname", this.Controls, this.ultraGrid1, 0); //PipeManageClass.InitComboEditor1(uceSpec, "com.steering.mes.signature.FrmDownlineManage.doQuerySpecName", "SPEC_CODE","SPEC_NAME", this.ob, false); //PipeManageClass.BindColumn(uceSpec, "SpecName", this.Controls, this.ultraGrid1, 0); //PipeManageClass.InitComboEditor1(uceModel, "com.steering.mes.signature.FrmDownlineManage.doQueryModleName", "MODEL_CODE", "MODE_DESC",this.ob, false); //PipeManageClass.BindColumn(uceModel, "ModelDesc", this.Controls, this.ultraGrid1, 0); //PipeManageClass.InitComboEditor1(uceSty, "com.steering.mes.signature.FrmDownlineManage.doQueryStyName", "STD_STYLE","STD_STYLE_DESC", this.ob, false); //PipeManageClass.BindColumn(uceSty, "StdStyleDesc", this.Controls, this.ultraGrid1, 0); //NativeMethodNew na = new NativeMethodNew(this.ob); //string plinCode = na.GetPCode(this.UserInfo.GetDepartment()); //ArrayList list = new ArrayList(); //list.Add(plinCode); //PipeManageClass.InitComboEditor2(uceOrderNo, "com.steering.mes.signature.FrmDownlineManage.doQueryOrderNo", list, "ORDER_NO", this.ob, false); //PipeManageClass.BindColumn(uceOrderNo, "ContractNo", this.Controls, this.ultraGrid1, 0); } /// /// 绑定列 /// private void InitBase() { this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("0", "质检离线"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("1","未探伤离线"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("2", "已探伤离线"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("3", "矫直离线"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("4", "交库离线"); this.ultraGrid3.DisplayLayout.ValueLists[0].ValueListItems.Add("0", "质检离线"); this.ultraGrid3.DisplayLayout.ValueLists[0].ValueListItems.Add("1", "未探伤离线"); this.ultraGrid3.DisplayLayout.ValueLists[0].ValueListItems.Add("2", "已探伤离线"); this.ultraGrid3.DisplayLayout.ValueLists[0].ValueListItems.Add("3", "矫直离线"); this.ultraGrid3.DisplayLayout.ValueLists[0].ValueListItems.Add("4", "交库离线"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("0","未审核"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("1","审核通过"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("2","审核未通过"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("0","未完成"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("1","已完成"); } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": doQueryOffLine(); break; case "QueryFurnace": doQueryFurnace(); break; case "DoQueryQualityInspectionTrust": doQualityInspectionTrust(); break; case "doQuerySubcontract": doQuerySubcontract(); break; case "subcontract": subcontract(); break; case "subcontractN": subcontractN(); break; case "Cancelsubcontract": Cancelsubcontract(); break; case "subcontractComplete": subcontractComplete(); break; case"doPipe": doPipe(); break; case "Furnace": doFurnace(); break; case "CancelFurnace": cancelFurnace(); break; case "QualityInspectionTrust": qualityInspectionTrust(); break; case"CancelQualityInspectionTrust": cancelQualityInspectionTrust(); break; case"BackLine": doBackLine(); break; case"BackStaightLine": doBackStaightLine(); break; case "updateOrderLength": updateOrderLength(); break; case"BackPip": BackPip(); break; case"Print": subcontractPrint(); break; case "Excel": doExcel(); break; case "Take": doTake(); break; case "Close": this.Close(); break; } } /// /// 脱单 /// private void doTake() { this.ultraGrid1.UpdateData(); string jugeNo = this.txtJudgeStoveNo.Text.Trim(); string lotNo = this.txtLotNo.Text.Trim(); ArrayList parm = new ArrayList(); IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请勾选需要脱单的炉批信息!"); return; } foreach (UltraGridRow row in checkMagRows) { MilOfflineReslutEntity2 milOfflineResultEntity = (MilOfflineReslutEntity2)row.ListObject; if (milOfflineResultEntity.ZpFlag.ToString() == "组炉批") { MessageUtil.ShowTips("炉号" + milOfflineResultEntity.JudgeStoveNo.ToString() + "是其他炉批组炉批出来的,不允许脱单!"); return; } string milOffTity = JSONFormat.Format(milOfflineResultEntity); parm.Add(milOffTity); } if (MessageUtil.ShowYesNoAndQuestion("是否确认脱单?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "doTake"; ccp.ServerParams = new object[] { parm, this.UserInfo.GetUserName() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("脱单成功!")) { doQueryOffLine(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } private void doExcel() { if (this.ultraTabControl1.Tabs[0].Active) { GridHelper.ulGridToExcel(ultraGrid1, "离线组炉管理->下线实绩"); } else if (this.ultraTabControl1.Tabs[1].Active) { GridHelper.ulGridToExcel(ultraGrid2, "离线组炉管理->组炉实绩"); } else if (this.ultraTabControl1.Tabs[2].Active) { GridHelper.ulGridToExcel(ultraGrid3, "离线组炉管理->操作实绩"); } else if (this.ultraTabControl1.Tabs[3].Active) { GridHelper.ulGridToExcel(ultraGrid4, "离线组炉管理->委外实绩"); } } /// /// 委内加工 /// private void subcontractN() { this.ultraGrid1.UpdateData(); string plineCode = ""; int m = 0; IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要委外加工的主信息!"); return; } ArrayList parm = new ArrayList(); ArrayList parm2 = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { MilOfflineReslutEntity2 milOfflineResult = (MilOfflineReslutEntity2)uRow.ListObject; string milOfflineResultTity = JSONFormat.Format(milOfflineResult); parm.Add(milOfflineResultTity); plineCode = milOfflineResult.PlineCode.ToString(); DataTable ds = ServerHelper.GetData("com.steering.mes.signature.FrmDownlineManage.doQueryNodesPro", new object[] { milOfflineResult.JudgeStoveNo, milOfflineResult.OfflinePro, milOfflineResult.ProPlanId, milOfflineResult.GxPlanNo }, ob); if (ds.Rows[0][0].ToString() == "0") { m = m + 1; } } if (m > 0) { MessageUtil.ShowTips("本工序未结炉,不允许进行委外!"); return; } parm2.Add(this.UserInfo.GetUserName()); parm2.Add(this.UserInfo.GetUserGroup()); parm2.Add(this.UserInfo.GetUserOrder()); parm2.Add(this.UserInfo.GetUserID()); if (MessageUtil.ShowYesNoAndQuestion("是否确认委外加工?") == DialogResult.No) return; FrmSubCon subCon = new FrmSubCon(ob); if (subCon.ShowDialog() == DialogResult.OK) { parm2.Add(subCon.Remark);//委外说明 parm2.Add(subCon.SteelPipeProcess); parm2.Add(subCon.UlTesting); parm2.Add(subCon.TestType); parm2.Add(subCon.TestGrade); } else { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "doSubcontract"; ccp.ServerParams = new object[] { parm, parm2, plineCode, "0" }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("委托成功!")) { doQueryOffLine(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 委托单打印 /// private void subcontractPrint() { this.ultraGrid4.UpdateData(); string subContractNo = ""; IQueryable checkMagRows = this.ultraGrid4.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要打印的主信息!"); return; } foreach(UltraGridRow uRow in checkMagRows) { subContractNo = uRow.Cells["SubcontractNo"].Value.ToString(); } int m = checkMagRows.GroupBy(a => a.GetValue("SubcontractNo")).Count(); if(m>1) { MessageUtil.ShowTips("不是同一委托单号的,不允许同时打印!"); return; } string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilSubcontractNo.cpt&format=pdf&SUBCONTRACT_NO=" + subContractNo; FrmExcel fre = new FrmExcel(this.ob, strurl); fre.AutoSize = true; fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fre.WindowState = FormWindowState.Maximized; fre.Show(); } /// /// 查询下线实绩 /// private void doQueryOffLine() { string jugeNo = ""; string startTim = ""; string endTim = ""; string plinCode = ""; string offPro = ""; string contractNo = ""; NativeMethodNew na = new NativeMethodNew(this.ob); plinCode = na.GetPCode(this.UserInfo.GetDepartment()); if (!CheckQuery()) return; if (this.chkTim.Checked) { startTim = this.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if (this.chkJugeHeatNo.Checked) { jugeNo = this.txtJugeNo.Text.Trim(); } if(this.chkOpr.Checked) { offPro = this.cmbOpr.Value.ToString2(); } //TZH ADD 新增工序合同号 if (this.chkContractNo.Checked) { contractNo = this.txtContractNo.Text.Trim(); } ArrayList parm = new ArrayList(); parm.Add(jugeNo); parm.Add(plinCode); parm.Add(offPro); //TZH ADD 新增工序合同号 parm.Add(contractNo); List listSource = EntityHelper.GetData( "com.steering.mes.signature.FrmDownlineManage.doQueryOffLine", new object[] { parm, startTim, endTim, plineCodes }, this.ob); MilOfflineReslutEntity2bindingSource.DataSource = listSource; } /// /// 数据验证 /// /// private bool CheckQuery() { if (this.chkJugeHeatNo.Checked && string.IsNullOrEmpty(this.txtJugeNo.Text.Trim())) { MessageUtil.ShowWarning("请输入判定炉号!"); return false; } return true; } /// /// 查询组炉实绩 /// private void doQueryFurnace() { string jugeNo = ""; string startTim = ""; string endTim = ""; string plinCode = ""; NativeMethodNew na = new NativeMethodNew(this.ob); plinCode = na.GetPCode(this.UserInfo.GetDepartment()); if (!CheckQuery()) return; if (this.chkTim.Checked) { startTim = this.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if (this.chkJugeHeatNo.Checked) { jugeNo = this.txtJugeNo.Text.Trim(); } ArrayList parm = new ArrayList(); parm.Add(jugeNo); parm.Add(plinCode); List listSource = EntityHelper.GetData( "com.steering.mes.signature.FrmDownlineManage.doQueryFurnace", new object[] { parm, startTim, endTim, plineCodes }, this.ob); List listSource2 = EntityHelper.GetData( "com.steering.mes.signature.FrmDownlineManage.doQueryFurnaceChildRow", new object[] { parm, startTim, endTim, plineCodes }, this.ob); EntityHelper.AddEntityRelation(listSource, listSource2, "ZpJudgeStoveNo", "ZpJudgeStoveNo"); MilOfflineGroupEntitybindingSource.DataSource = listSource; } /// /// 查询二检委托\探伤返线实绩 /// private void doQualityInspectionTrust() { string jugeNo = ""; string startTim = ""; string endTim = ""; string plinCode = ""; NativeMethodNew na = new NativeMethodNew(this.ob); plinCode = na.GetPCode(this.UserInfo.GetDepartment()); if (!CheckQuery()) return; if (this.chkTim.Checked) { startTim = this.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if (this.chkJugeHeatNo.Checked) { jugeNo = this.txtJugeNo.Text.Trim(); } ArrayList parm = new ArrayList(); parm.Add(jugeNo); parm.Add(plinCode); List listSource = EntityHelper.GetData( "com.steering.mes.signature.FrmDownlineManage.doQualityInspectionTrust", new object[] { parm, startTim, endTim, plineCodes }, this.ob); MilOfflineResultDetiaEntitybindingSource.DataSource = listSource; } /// /// 委外单查询 /// private void doQuerySubcontract() { string jugeNo = ""; string startTim = ""; string endTim = ""; string plinCode = ""; NativeMethodNew na = new NativeMethodNew(this.ob); plinCode = na.GetPCode(this.UserInfo.GetDepartment()); if (!CheckQuery()) return; if (this.chkTim.Checked) { startTim = this.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if (this.chkJugeHeatNo.Checked) { jugeNo = this.txtJugeNo.Text.Trim(); } ArrayList parm = new ArrayList(); parm.Add(jugeNo); parm.Add(plinCode); parm.Add(this.subcontractStaus.Value.ToString2()); List listSource = EntityHelper.GetData( "com.steering.mes.signature.FrmDownlineManage.doQuerySubcontract", new object[] { parm, startTim, endTim, plineCodes }, this.ob); MilEntrustedBillEntitybindingSource.DataSource = listSource; } /// /// 查询仓库信息 /// /// /// private DataTable getStoreNo(string plineCode) { DataTable ds = ServerHelper.GetData("com.steering.mes.signature.FrmInOnlineStore.doQueryStoreNo", new object[] { plineCode }, ob); if (ds.Rows.Count > 0) { return ds; } else { return null; } } /// /// 入在线库 /// private void doPipe() { string strInbound = "800707";//入库类型 string strInMemo = ""; int m = 0; this.ultraGrid1.UpdateData(); IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要入库转移的主信息!"); return; } DataTable dtMemo = PipeManageClass.getComTypeInfo(strInbound, ob); if (dtMemo.Rows.Count >= 1) { strInMemo = dtMemo.Rows[0]["MEMO"].ToString(); } NativeMethodNew na = new NativeMethodNew(this.ob); string plinCode = na.GetPCode(this.UserInfo.GetDepartment()); ArrayList list = new ArrayList(); DataTable ds = getStoreNo(plinCode); if (ds == null) { MessageUtil.ShowTips("无轧管在线库基础信息,请维护!"); return; } list.Add(ds.Rows[0]["STORAGE_NO"].ToString()); list.Add(ds.Rows[0]["STORAGE_NO"].ToString() + "10101"); list.Add(ds.Rows[0]["STORAGE_TYPE_NO"].ToString()); list.Add(ds.Rows[0]["STORAGE_TYPE_NAME"].ToString()); list.Add(this.UserInfo.GetUserName()); list.Add(this.UserInfo.GetDeptid()); list.Add(this.UserInfo.GetDepartment()); list.Add(this.UserInfo.GetDeptid()); list.Add(this.UserInfo.GetDepartment()); //list.Add(PipeManageClass.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob)); //list.Add(PipeManageClass.GetDepartBySectionId(this.UserInfo.GetDeptid(), this.ob)); list.Add(UserInfo.GetUserOrder()); list.Add(UserInfo.GetUserGroup()); ArrayList parm = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { if (int.Parse(uRow.Cells["InstorageNum"].Value.ToString3()) + int.Parse(uRow.Cells["GroupNumCount"].Value.ToString3()) > int.Parse(uRow.Cells["ResidueNum"].Value.ToString3())) { m = m + 1; } MilOfflineReslutEntity2 milOfflineResult = (MilOfflineReslutEntity2)uRow.ListObject; string milOfflineResultTity = JSONFormat.Format(milOfflineResult); parm.Add(milOfflineResultTity); } if (m > 0) { MessageUtil.ShowTips("入库转移支数已超出下线剩余支数!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认入库转移?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "doPipe"; ccp.ServerParams = new object[] { list, parm, strInbound, strInMemo }; ccp = ob.ExecuteNonQuery(ccp,CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("入库转移成功!")) { doQueryOffLine(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 委外加工 /// private void subcontract() { this.ultraGrid1.UpdateData(); string plineCode = ""; int m = 0; IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要委外加工的主信息!"); return; } ArrayList parm = new ArrayList(); ArrayList parm2 = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { MilOfflineReslutEntity2 milOfflineResult = (MilOfflineReslutEntity2)uRow.ListObject; string milOfflineResultTity = JSONFormat.Format(milOfflineResult); parm.Add(milOfflineResultTity); plineCode = milOfflineResult.PlineCode.ToString(); DataTable ds = ServerHelper.GetData("com.steering.mes.signature.FrmDownlineManage.doQueryNodesPro", new object[] { milOfflineResult.JudgeStoveNo, milOfflineResult.OfflinePro, milOfflineResult.ProPlanId, milOfflineResult.GxPlanNo }, ob); if(ds.Rows[0][0].ToString() == "0") { m = m + 1; } } if(m>0) { MessageUtil.ShowTips("本工序未结炉,不允许进行委外!"); return; } parm2.Add(this.UserInfo.GetUserName()); parm2.Add(this.UserInfo.GetUserGroup()); parm2.Add(this.UserInfo.GetUserOrder()); parm2.Add(this.UserInfo.GetUserID()); if (MessageUtil.ShowYesNoAndQuestion("是否确认委外加工?") == DialogResult.No) return; FrmSubCon subCon = new FrmSubCon(ob); if (subCon.ShowDialog() == DialogResult.OK) { parm2.Add(subCon.Remark);//委外说明 parm2.Add(subCon.SteelPipeProcess); parm2.Add(subCon.UlTesting); parm2.Add(subCon.TestType); parm2.Add(subCon.TestGrade); } else { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "doSubcontract"; ccp.ServerParams = new object[] { parm, parm2, plineCode,"1" }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("委托成功!")) { doQueryOffLine(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 修改合同信息 /// /// private void updateOrder(ArrayList parm) { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "updateOrderLength"; ccp.ServerParams = new object[] { parm }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (!ccp.ReturnInfo.Equals("修改成功!")) { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 组炉后修改长度 /// private void updateOrderLength() { this.ultraGrid1.UpdateData(); IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要修改的主信息!"); return; } ArrayList parm = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { MilOfflineReslutEntity2 milOfflineResult = (MilOfflineReslutEntity2)uRow.ListObject; //if (!milOfflineResult.ZpFlag.Equals("组炉批")) //{ // MessageUtil.ShowTips("不是组炉出来的数据,不允许修改信息!"); // return; //} if (!milOfflineResult.Length.ToString().TryParseInt() && !milOfflineResult.Length.ToString().TryParseDouble()) { MessageUtil.ShowTips("长度只能是纯数字!"); return; } if (!milOfflineResult.Diameter.ToString().TryParseDouble() && !milOfflineResult.Diameter.ToString().TryParseInt()) { MessageUtil.ShowTips("外径只能是纯数字!"); return; } if (!milOfflineResult.Thickness.ToString().TryParseDouble() && !milOfflineResult.Thickness.ToString().TryParseInt()) { MessageUtil.ShowTips("壁厚只能是纯数字!"); return; } //milOfflineResult.Produccode = uRow.Cells["Producname"].Value.ToString(); //milOfflineResult.Producname = uRow.Cells["Producname"].Text.ToString(); //milOfflineResult.SpecCode = uRow.Cells["SpecName"].Value.ToString(); //milOfflineResult.SpecName = uRow.Cells["SpecName"].Text.ToString(); //milOfflineResult.Steelcode = uRow.Cells["Steelname"].Value.ToString(); //milOfflineResult.Steelname = uRow.Cells["Steelname"].Text.ToString(); //milOfflineResult.ModelCode = uRow.Cells["ModelDesc"].Value.ToString(); //milOfflineResult.ModelDesc = uRow.Cells["ModelDesc"].Text.ToString(); //milOfflineResult.StdStyle = uRow.Cells["StdStyleDesc"].Value.ToString(); //milOfflineResult.StdStyleDesc = uRow.Cells["StdStyleDesc"].Text.ToString(); string milOfflineResultTity = JSONFormat.Format(milOfflineResult); parm.Add(milOfflineResultTity); } if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "updateOrderLength"; ccp.ServerParams = new object[] { parm }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("修改成功!")) { doQueryOffLine(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 撤销委外实绩 /// private void Cancelsubcontract() { this.ultraGrid4.UpdateData(); IQueryable checkMagRows = this.ultraGrid4.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要操作的主信息!"); return; } ArrayList parm = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { MilEntrustedBillEntity milEntrustTity = (MilEntrustedBillEntity)uRow.ListObject; string milEntrustEntity = JSONFormat.Format(milEntrustTity); parm.Add(milEntrustEntity); } if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销委外加工?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "cancelSubcontract"; ccp.ServerParams = new object[] { parm }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("撤销成功!")) { doQuerySubcontract(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 委外加工完成 /// private void subcontractComplete() { this.ultraGrid4.UpdateData(); IQueryable checkMagRows = this.ultraGrid4.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要操作的主信息!"); return; } ArrayList parm = new ArrayList(); int m = 0; foreach (UltraGridRow uRow in checkMagRows) { if (int.Parse(uRow.Cells["SubcontractcompleteNum"].Value.ToString3()) + int.Parse(uRow.Cells["SubcontractscrapNum"].Value.ToString3()) > int.Parse(uRow.Cells["SubcontractNum"].Value.ToString3())) { m = m + 1; } MilEntrustedBillEntity milEntrustTity = (MilEntrustedBillEntity)uRow.ListObject; string milEntrustEntity = JSONFormat.Format(milEntrustTity); parm.Add(milEntrustEntity); } if (m > 1) { MessageUtil.ShowTips("委外回报实绩的支数不能大于委外出去加工支数!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认回报委外实绩?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "subcontractComplete"; ccp.ServerParams = new object[] { parm }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("委外加工完成!")) { doQuerySubcontract(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } //勾选主炉号的行 public static List UltraGridGetCHKMAINRows(UltraGrid grid, string columnName = "CHK1") { grid.UpdateData(); List list = new List(); RowsCollection rows = grid.Rows; foreach (var item in rows) { try { if (Convert.ToBoolean(item.Cells[columnName].Value) == true && item.Hidden == false && item.IsFilteredOut == false) { list.Add(item); } } catch { } } return list; } /// /// 组炉批 /// private void doFurnace() { this.ultraGrid1.UpdateData(); int m = 0; int n = 0; int y = 0; string jugeNo = ""; string lotNo = ""; if (PlineCode.Equals("C072")) { List list = UltraGridGetCHKMAINRows(ultraGrid1); if (list.Count == 0) { MessageBox.Show("请勾选主炉生产批号!", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //批号 lotNo = list[0].Cells["LotNo"].Value.ToString(); //炉号 jugeNo = ServerHelper.GetData("com.steering.mes.signature.FrmDownlineManage.doQueryZpJudgeStoveNo", new Object[] { "F"}, this.ob).Rows[0][0].ToString(); } else { jugeNo = this.txtJudgeStoveNo.Text.Trim(); lotNo = this.txtLotNo.Text.Trim(); } if (jugeNo.Equals("") || lotNo.Equals("")) { MessageUtil.ShowTips("组炉新炉号和新批号不能为空!"); return; } IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); IQueryable checkRows = this.ultraGrid1.Rows.AsQueryable().Where(a=>a.GetValue("CHK1") == "True" && a.GetValue("CHK") == "True"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请勾选需要组炉的炉批信息!"); return; } //if (checkMagRows.Count() == 1) //{ // MessageUtil.ShowTips("只勾选了单炉,不允许进行组炉批!"); // return; //} if (checkRows.Count() != 1) { MessageUtil.ShowTips("组炉主炉号只允许选择一条!"); return; } ArrayList parm = new ArrayList(); ArrayList parm1 = new ArrayList(); ArrayList parm2 = new ArrayList(); DataTable ds = new DataTable(); foreach (UltraGridRow row in checkMagRows) { MilOfflineReslutEntity2 milOfflineResultEntity = (MilOfflineReslutEntity2)row.ListObject; if (int.Parse(milOfflineResultEntity.GroupNumCount.ToString2()) <= 0) { MessageUtil.ShowTips("输入的操作支数需为正整数!"); return; } if (int.Parse(milOfflineResultEntity.GroupNumCount.ToString()) - int.Parse(milOfflineResultEntity.ResidueNum.ToString()) != 0) { MessageUtil.ShowTips("组炉时操作支数必须等于下线剩余支数!"); return; } ds = ServerHelper.GetData("com.steering.mes.signature.FrmDownlineManage.doQueryLxStore", new object[] { milOfflineResultEntity.JudgeStoveNo.ToString() }, ob); //if (int.Parse(milOfflineResultEntity.GroupNumCount.ToString3()) > int.Parse(ds.Rows[0][0].ToString())) //{ // MessageUtil.ShowTips("炉号" + milOfflineResultEntity.JudgeStoveNo.ToString() + "离线库存已不够,无法进行组炉!"); // return; //} if (milOfflineResultEntity.ZpFlag.ToString() == "组炉批") { MessageUtil.ShowTips("炉号" + milOfflineResultEntity.JudgeStoveNo.ToString() + "是其他炉批组炉批出来的,不允许重复组炉批!"); return; } if (!milOfflineResultEntity.GroupNumCount.Equals(milOfflineResultEntity.ResidueNum)) { MessageUtil.ShowTips("下线数据不允许拆分组炉批!"); return; } if (milOfflineResultEntity.OfflinePro.Equals("矫直")) { n = n + 1; } if (int.Parse(row.Cells["InstorageNum"].Value.ToString3()) > 0) { m = m + 1; } string milOffTity = JSONFormat.Format(milOfflineResultEntity); parm.Add(milOffTity); } if (m > 0) { MessageUtil.ShowTips("有炉已进行入在线库,不允许进行组炉批!"); return; } if (n > 0) { MessageUtil.ShowTips("矫直离线数据不允许进行组炉批!"); return; } int offlinePro = checkMagRows.GroupBy(a => a.GetValue("offlinePro")).Count(); if (offlinePro > 1) { MessageUtil.ShowTips("只有同工序的炉信息,才能进行组炉批!"); return; } int offlineType = checkMagRows.GroupBy(a => a.GetValue("offlineType")).Count(); if (offlineType>1) { MessageUtil.ShowTips("只有同种下线类型才能进行组炉!"); return; } int steel = checkMagRows.GroupBy(a => a.GetValue("Steelname")).Count(); if (steel >1) { MessageUtil.ShowTips("只有同钢级的炉信息,才能进行组炉批!"); return; } int grade = checkMagRows.GroupBy(a => a.GetValue("Gradename")).Count(); if (grade > 1) { MessageUtil.ShowTips("只有同钢种的炉信息,才能进行组炉批!"); return; } int actLengthRange = checkMagRows.GroupBy(a => a.GetValue("ActLenRange")).Count(); if (actLengthRange>1) { MessageUtil.ShowTips("只有同长度上下限的炉信息,才能进行组炉批!"); return; } int pipeSize = checkMagRows.GroupBy(a => a.GetValue("SpecName")).Count(); if (pipeSize > 1) { MessageUtil.ShowTips("只有同规格的炉信息,才能进行组炉批!"); return; } foreach (UltraGridRow uRow in checkRows) { MilOfflineReslutEntity2 milOfflineResultEntity1 = (MilOfflineReslutEntity2)uRow.ListObject; string milOffTity1 = JSONFormat.Format(milOfflineResultEntity1); parm1.Add(milOffTity1); } parm2.Add(jugeNo+"-01"); parm2.Add(lotNo); parm2.Add(this.UserInfo.GetUserName()); parm2.Add(this.UserInfo.GetUserGroup()); parm2.Add(this.UserInfo.GetUserOrder()); if (MessageUtil.ShowYesNoAndQuestion("是否确认组炉批?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "doFurnace"; ccp.ServerParams = new object[] { parm, parm1, parm2 }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("组炉批成功!")) { doQueryOffLine(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 撤销组炉 /// private void cancelFurnace() { this.ultraGrid2.UpdateData(); IQueryable checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请勾选需要撤销的炉批信息!"); return; } ArrayList parm = new ArrayList(); ArrayList parm1 = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { MilOfflineGroupEntity milOffGrouptity = (MilOfflineGroupEntity)uRow.ListObject; string milOffGroupEntity = JSONFormat.Format(milOffGrouptity); parm.Add(milOffGroupEntity); foreach (var offlineGroup in milOffGrouptity.QcmOfflineGroup) { parm1.Add(JSONFormat.Format(offlineGroup)); } } if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "doCancelFurnace"; ccp.ServerParams = new object[] { parm,parm1 }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("撤销成功!")) { doQueryFurnace(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 探伤返线 /// private void doBackLine() { this.ultraGrid1.UpdateData(); IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要探伤返线的主信息!"); return; } int m = 0; ArrayList parm = new ArrayList(); ArrayList parm2 = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { MilOfflineReslutEntity2 milOfflineResult = (MilOfflineReslutEntity2)uRow.ListObject; String OfflinePro = milOfflineResult.OfflinePro.ToString(); //下线工序 if (!milOfflineResult.OfflinePro.Equals("探伤")) { MessageUtil.ShowTips("此信息是" + OfflinePro + "离线数据,不能进行探伤返线!"); return; } if (milOfflineResult.ContractNo.Equals("")) { MessageUtil.ShowTips("此信息无合同信息,不能进行探伤返线!"); return; } if (int.Parse(milOfflineResult.GroupNumCount.ToString2()) < 1) { MessageUtil.ShowTips("输入的返线支数不对,不能进行探伤返线!"); return; } if (milOfflineResult.ZpFlag.Equals("组炉批")) { if (!milOfflineResult.GroupNumCount.Equals(milOfflineResult.OfflineNum)) { MessageUtil.ShowTips("组炉批的炉信息不允许分批返线!"); return; } } if (int.Parse(milOfflineResult.GroupNumCount.ToString3()) > int.Parse(milOfflineResult.ResidueNum.ToString3()) + int.Parse(milOfflineResult.InstorageNum.ToString3())) { m = m + 1; } string milOfflineResultTity = JSONFormat.Format(milOfflineResult); parm.Add(milOfflineResultTity); } updateOrder(parm); //修改合同信息 if (m > 0) { MessageUtil.ShowTips("输入操作支数不能大于剩余在库支数!"); return; } parm2.Add(this.UserInfo.GetUserName()); parm2.Add(this.UserInfo.GetUserGroup()); parm2.Add(this.UserInfo.GetUserOrder()); parm2.Add(this.UserInfo.GetUserID()); if (MessageUtil.ShowYesNoAndQuestion("是否确认返线?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "doBackLine"; ccp.ServerParams = new object[] { parm, parm2 }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("返线成功!")) { doQueryOffLine(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 矫直返线 /// private void doBackStaightLine() { this.ultraGrid1.UpdateData(); IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要矫直返线的主信息!"); return; } int m = 0; ArrayList parm = new ArrayList(); ArrayList parm2 = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { MilOfflineReslutEntity2 milOfflineResult = (MilOfflineReslutEntity2)uRow.ListObject; String OfflinePro = milOfflineResult.OfflinePro.ToString(); //下线工序 if (!milOfflineResult.OfflinePro.Equals("矫直")) { MessageUtil.ShowTips("此信息是" + OfflinePro + "离线数据,不能进行矫直返线!"); return; } if (milOfflineResult.ContractNo.Equals("")) { MessageUtil.ShowTips("此信息无合同信息,不能进行矫直返线!"); return; } if (int.Parse(milOfflineResult.GroupNumCount.ToString3()) > int.Parse(milOfflineResult.ResidueNum.ToString3()) + int.Parse(milOfflineResult.InstorageNum.ToString3())) { m = m + 1; } string milOfflineResultTity = JSONFormat.Format(milOfflineResult); parm.Add(milOfflineResultTity); } updateOrder(parm); //修改合同信息 if (m > 0) { MessageUtil.ShowTips("输入操作支数不能大于剩余在库支数!"); return; } parm2.Add(this.UserInfo.GetUserName()); parm2.Add(this.UserInfo.GetUserGroup()); parm2.Add(this.UserInfo.GetUserOrder()); parm2.Add(this.UserInfo.GetUserID()); if (MessageUtil.ShowYesNoAndQuestion("是否确认返线?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "doBackStaightLine"; ccp.ServerParams = new object[] { parm, parm2 }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("返线成功!")) { doQueryOffLine(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 质检委托 /// private void qualityInspectionTrust() { this.ultraGrid1.UpdateData(); IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要生成质检委托的主信息!"); return; } ArrayList parm = new ArrayList(); ArrayList parm2 = new ArrayList(); foreach(UltraGridRow uRow in checkMagRows) { MilOfflineReslutEntity2 milOfflineResult = (MilOfflineReslutEntity2)uRow.ListObject; String OfflinePro = milOfflineResult.OfflinePro.ToString(); //下线工序 if (milOfflineResult.OfflinePro.Equals("矫直")) { MessageUtil.ShowTips("此信息是" + OfflinePro + "离线数据,不能进行质检委托!"); return; } if (milOfflineResult.OfflinePro.Equals("交库")) { MessageUtil.ShowTips("此信息是" + OfflinePro + "离线数据,不能进行质检委托!"); return; } if (milOfflineResult.ContractNo.Equals("") && !milOfflineResult.LotNo.Equals("试轧料")) { MessageUtil.ShowTips("此信息无合同号,不能进行质检委托!"); return; } if (int.Parse(milOfflineResult.GroupNumCount.ToString2()) < 1 ) { MessageUtil.ShowTips("输入的返线支数不对,不能进行质检委托!"); return; } //MilOfflineReslutEntity2 milOfflineResult = (MilOfflineReslutEntity2)uRow.ListObject; string milOfflineResultTity = JSONFormat.Format(milOfflineResult); parm.Add(milOfflineResultTity); } updateOrder(parm); //修改合同信息 parm2.Add(this.UserInfo.GetUserName()); parm2.Add(this.UserInfo.GetUserGroup()); parm2.Add(this.UserInfo.GetUserOrder()); if (MessageUtil.ShowYesNoAndQuestion("是否确认生成质检委托?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "qualityInspectionTrust"; ccp.ServerParams = new object[] { parm,parm2 }; ccp = ob.ExecuteNonQuery(ccp,CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("委托成功!")) { doQueryOffLine(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 返线交库点 /// private void BackPip() { this.ultraGrid1.UpdateData(); //int m = 0; IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要返线的主信息!"); return; } ArrayList parm = new ArrayList(); ArrayList parm2 = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { MilOfflineReslutEntity2 milOfflineResult = (MilOfflineReslutEntity2)uRow.ListObject; String OfflinePro = milOfflineResult.OfflinePro.ToString(); //下线工序 if(!milOfflineResult.OfflinePro.Equals("交库")) { MessageUtil.ShowTips("此信息是" + OfflinePro + "离线数据,不能进行交库返线!"); return; } if (milOfflineResult.ContractNo.Equals("")) { MessageUtil.ShowTips("此信息无合同信息,不能进行交库返线!"); return; } if (int.Parse(milOfflineResult.GroupNumCount.ToString2()) < 1) { MessageUtil.ShowTips("输入的返线支数不对,不能进行交库返线!"); return; } String SubcontractcompleteWgt = milOfflineResult.SubcontractcompleteWgt.ToString(); //if (SubcontractcompleteWgt.Equals("") || SubcontractcompleteWgt.Equals("0")) //{ // MessageUtil.ShowTips("此信息是交库离线数据,没有做委内或者委外,不能进行交库返线!"); // return; //} string milOfflineResultTity = JSONFormat.Format(milOfflineResult); parm.Add(milOfflineResultTity); } parm2.Add(this.UserInfo.GetUserName()); parm2.Add(this.UserInfo.GetUserGroup()); parm2.Add(this.UserInfo.GetUserOrder()); parm2.Add(this.UserInfo.GetDeptid()); parm2.Add(this.UserInfo.GetDepartment()); if (MessageUtil.ShowYesNoAndQuestion("是否确认返线?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "backPipe"; ccp.ServerParams = new object[] { parm, parm2 }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("返线成功!")) { doQueryOffLine(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 撤销质检委托、探伤返线 /// private void cancelQualityInspectionTrust() { this.ultraGrid3.UpdateData(); IQueryable checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请勾选需要撤销的炉批信息!"); return; } string strInbound = "800707";//入库类型 string strInMemo = ""; ArrayList parm = new ArrayList(); int m = 0; foreach (UltraGridRow uRow in checkMagRows) { MilOfflineResultDetiaEntity milOffResultDetiatity = (MilOfflineResultDetiaEntity)uRow.ListObject; string milOffResultDetiaEntity = JSONFormat.Format(milOffResultDetiatity); parm.Add(milOffResultDetiaEntity); m = m + 1; } if (m > 1) { MessageUtil.ShowTips("不允许勾选多条记录撤销!"); return; } NativeMethodNew na = new NativeMethodNew(this.ob); string Departm = UserInfo.GetDepartment(); string plineCode = na.GetPCode(Departm);//获取 用户 对应的产线 DataTable sd = getStoreNo(plineCode); //取对应产线产出库 if (this.ultraGrid3.ActiveRow.Cells["OperationType"].Text.Equals("交库返线")) //撤销交库返线,取位置备份表仓库信息 { sd = ServerHelper.GetData("com.steering.mes.signature.FrmInOnlineStore.doQueryStoreNo", new object[] { plineCode, this.ultraGrid3.ActiveRow.Cells["JudgeStoveNo"].Text }, ob); } if (sd.Rows.Count < 1 ) { sd = getStoreNo(plineCode); //取对应产线产出库 } if (sd.Equals(null)) { MessageUtil.ShowTips("无轧管在线库基础信息,请维护!"); return; } DataTable dtMemo = PipeManageClass.getComTypeInfo(strInbound, ob); if (dtMemo.Rows.Count >= 1) { strInMemo = dtMemo.Rows[0]["MEMO"].ToString(); } ArrayList list = new ArrayList(); list.Add(sd.Rows[0]["STORAGE_NO"].ToString()); list.Add(sd.Rows[0]["STORAGE_NO"].ToString() + "10101"); list.Add(sd.Rows[0]["STORAGE_TYPE_NO"].ToString()); list.Add(sd.Rows[0]["STORAGE_TYPE_NAME"].ToString()); list.Add(this.UserInfo.GetDeptid()); list.Add(this.UserInfo.GetDepartment()); list.Add(this.UserInfo.GetDeptid()); list.Add(this.UserInfo.GetDepartment()); //list.Add(PipeManageClass.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob)); //list.Add(PipeManageClass.GetDepartBySectionId(this.UserInfo.GetDeptid(), this.ob)); list.Add(UserInfo.GetUserName()); if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.signature.FrmDownlineManage"; ccp.MethodName = "cancelQualityInspectionTrust"; ccp.ServerParams = new object[] { parm, list, strInbound, strInMemo, plineCode }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("撤销成功!")) { doQualityInspectionTrust(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } private void FrmDownlineManage_Shown(object sender, EventArgs e) { if (toolMenu == null) return; if (toolMenu.Toolbars[0].Tools.Exists("QueryFurnace")) { toolMenu.Toolbars[0].Tools["QueryFurnace"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoQueryQualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["DoQueryQualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace")) { toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelQualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["CancelQualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doQuerySubcontract")) { toolMenu.Toolbars[0].Tools["doQuerySubcontract"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Cancelsubcontract")) { toolMenu.Toolbars[0].Tools["Cancelsubcontract"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("subcontractComplete")) { toolMenu.Toolbars[0].Tools["subcontractComplete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; } ultraLabel4.Visible = false; subcontractStaus.Visible = false; } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (toolMenu == null) return; if (ultraTabControl1.SelectedTab.Key == "0") { if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Furnace")) { toolMenu.Toolbars[0].Tools["Furnace"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("BackLine")) { toolMenu.Toolbars[0].Tools["BackLine"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QueryFurnace")) { toolMenu.Toolbars[0].Tools["QueryFurnace"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoQueryQualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["DoQueryQualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace")) { toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelQualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["CancelQualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["QualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("doQuerySubcontract")) { toolMenu.Toolbars[0].Tools["doQuerySubcontract"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("subcontract")) { toolMenu.Toolbars[0].Tools["subcontract"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("subcontractComplete")) { toolMenu.Toolbars[0].Tools["subcontractComplete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Cancelsubcontract")) { toolMenu.Toolbars[0].Tools["Cancelsubcontract"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doPipe")) { toolMenu.Toolbars[0].Tools["doPipe"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("updateOrderLength")) { toolMenu.Toolbars[0].Tools["updateOrderLength"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("BackStaightLine")) { toolMenu.Toolbars[0].Tools["BackStaightLine"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("BackPip")) { toolMenu.Toolbars[0].Tools["BackPip"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("subcontractN")) { toolMenu.Toolbars[0].Tools["subcontractN"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Take")) { toolMenu.Toolbars[0].Tools["Take"].InstanceProps.Visible = DefaultableBoolean.True; } this.chkTim.Text = "生产日期"; this.chkOpr.Visible = true; this.cmbOpr.Visible = true; ultraLabel4.Visible = false; subcontractStaus.Visible = false; } else if (ultraTabControl1.SelectedTab.Key == "1") { if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Furnace")) { toolMenu.Toolbars[0].Tools["Furnace"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("BackLine")) { toolMenu.Toolbars[0].Tools["BackLine"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryFurnace")) { toolMenu.Toolbars[0].Tools["QueryFurnace"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("DoQueryQualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["DoQueryQualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace")) { toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("CancelQualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["CancelQualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["QualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doQuerySubcontract")) { toolMenu.Toolbars[0].Tools["doQuerySubcontract"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("subcontract")) { toolMenu.Toolbars[0].Tools["subcontract"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("subcontractComplete")) { toolMenu.Toolbars[0].Tools["subcontractComplete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Cancelsubcontract")) { toolMenu.Toolbars[0].Tools["Cancelsubcontract"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doPipe")) { toolMenu.Toolbars[0].Tools["doPipe"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateOrderLength")) { toolMenu.Toolbars[0].Tools["updateOrderLength"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("BackStaightLine")) { toolMenu.Toolbars[0].Tools["BackStaightLine"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("BackPip")) { toolMenu.Toolbars[0].Tools["BackPip"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("subcontractN")) { toolMenu.Toolbars[0].Tools["subcontractN"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Take")) { toolMenu.Toolbars[0].Tools["Take"].InstanceProps.Visible = DefaultableBoolean.False; } this.chkTim.Text = "组炉日期"; this.chkOpr.Visible = false; this.cmbOpr.Visible = false; ultraLabel4.Visible = false; subcontractStaus.Visible = false; } else if (ultraTabControl1.SelectedTab.Key == "2") { if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Furnace")) { toolMenu.Toolbars[0].Tools["Furnace"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("BackLine")) { toolMenu.Toolbars[0].Tools["BackLine"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryFurnace")) { toolMenu.Toolbars[0].Tools["QueryFurnace"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoQueryQualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["DoQueryQualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace")) { toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelQualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["CancelQualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["QualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doQuerySubcontract")) { toolMenu.Toolbars[0].Tools["doQuerySubcontract"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("subcontract")) { toolMenu.Toolbars[0].Tools["subcontract"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("subcontractComplete")) { toolMenu.Toolbars[0].Tools["subcontractComplete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Cancelsubcontract")) { toolMenu.Toolbars[0].Tools["Cancelsubcontract"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doPipe")) { toolMenu.Toolbars[0].Tools["doPipe"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateOrderLength")) { toolMenu.Toolbars[0].Tools["updateOrderLength"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("BackStaightLine")) { toolMenu.Toolbars[0].Tools["BackStaightLine"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("BackPip")) { toolMenu.Toolbars[0].Tools["BackPip"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("subcontractN")) { toolMenu.Toolbars[0].Tools["subcontractN"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Take")) { toolMenu.Toolbars[0].Tools["Take"].InstanceProps.Visible = DefaultableBoolean.False; } this.chkTim.Text = "操作日期"; this.chkOpr.Visible = false; this.cmbOpr.Visible = false; ultraLabel4.Visible = false; subcontractStaus.Visible = false; } else { if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Furnace")) { toolMenu.Toolbars[0].Tools["Furnace"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("BackLine")) { toolMenu.Toolbars[0].Tools["BackLine"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryFurnace")) { toolMenu.Toolbars[0].Tools["QueryFurnace"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoQueryQualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["DoQueryQualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace")) { toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelQualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["CancelQualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QualityInspectionTrust")) { toolMenu.Toolbars[0].Tools["QualityInspectionTrust"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doQuerySubcontract")) { toolMenu.Toolbars[0].Tools["doQuerySubcontract"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("subcontract")) { toolMenu.Toolbars[0].Tools["subcontract"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("subcontractComplete")) { toolMenu.Toolbars[0].Tools["subcontractComplete"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Cancelsubcontract")) { toolMenu.Toolbars[0].Tools["Cancelsubcontract"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("doPipe")) { toolMenu.Toolbars[0].Tools["doPipe"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateOrderLength")) { toolMenu.Toolbars[0].Tools["updateOrderLength"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Print")) { toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("BackStaightLine")) { toolMenu.Toolbars[0].Tools["BackStaightLine"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("BackPip")) { toolMenu.Toolbars[0].Tools["BackPip"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("subcontractN")) { toolMenu.Toolbars[0].Tools["subcontractN"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Take")) { toolMenu.Toolbars[0].Tools["Take"].InstanceProps.Visible = DefaultableBoolean.False; } this.chkTim.Text = "委外日期"; this.chkOpr.Visible = false; this.cmbOpr.Visible = false; ultraLabel4.Visible = true; subcontractStaus.Visible = true; } } private void chkTim_CheckedChanged(object sender, EventArgs e) { StartTime.Enabled = EndTime.Enabled = this.chkTim.Checked; } private void chkJugeHeatNo_CheckedChanged(object sender, EventArgs e) { this.txtJugeNo.Enabled = this.chkJugeHeatNo.Checked; } private void chkOpr_CheckedChanged(object sender, EventArgs e) { this.cmbOpr.Enabled = this.chkOpr.Checked; } private void ultraGrid1_CellChange(object sender, CellEventArgs e) { this.ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (e.Cell.Column.Key == "GroupNumCount") { if (uRow.Cells["OfflinePro"].Text == "交库") { doQueryOffLine(); MessageUtil.ShowTips("交库点离线支返线不允许拆分!"); } } } /// /// 改合同功能(屏蔽了,转下线后精整利库) /// /// /// private void ultraGrid1_ClickCellButton(object sender, CellEventArgs e) { // this.ultraGrid1.UpdateData(); // if (e.Cell.Column.Key == "ContractNo") // { // FrmOrderZgDialog orderZg = new FrmOrderZgDialog(this.ob); // orderZg.ShowDialog(); // SlmOrderLineEntity slmEntity = orderZg.SlmEntity; // if (slmEntity == null) // { // return; // } // e.Cell.Row.Cells["ContractNo"].Value = slmEntity.OrderNo + "/" + slmEntity.OrderSeq; // e.Cell.Row.Cells["Producname"].Value = slmEntity.Producname; // e.Cell.Row.Cells["produccode"].Value = slmEntity.Produccode; // e.Cell.Row.Cells["Steelname"].Value = slmEntity.Steelname; // e.Cell.Row.Cells["Steelcode"].Value = slmEntity.Steelcode; // e.Cell.Row.Cells["SpecName"].Value = slmEntity.SpecName; // e.Cell.Row.Cells["specCode"].Value = slmEntity.SpecCode; // e.Cell.Row.Cells["ModelDesc"].Value = slmEntity.ModelDesc; // e.Cell.Row.Cells["modelCode"].Value = slmEntity.ModelCode; // e.Cell.Row.Cells["StdStyleDesc"].Value = slmEntity.StdStyleDesc; // e.Cell.Row.Cells["stdStyle"].Value = slmEntity.StdStyle; // e.Cell.Row.Cells["StdName"].Value = slmEntity.StdName; // string[] str = slmEntity.SpecName.ToString().Split('x'); // e.Cell.Row.Cells["Diameter"].Value = str[0]; // e.Cell.Row.Cells["Thickness"].Value = str[1]; // e.Cell.Row.Cells["ImpProcess"].Value = slmEntity.CraftNo; // e.Cell.Row.Cells["ActLenRange"].Value = slmEntity.LengthRange; // e.Cell.Row.Cells["Length"].Value = slmEntity.RollLength; // e.Cell.Row.Cells["ProPlanId"].Value = slmEntity.ProPlanId; // e.Cell.Row.Cells["GxPlanNo"].Value = slmEntity.GxPlanNo; // } } } }