using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using Core.Mes.Client.Comm.Tool; using com.steering.pss.plnsaleord.order.model; using System.Collections; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm; using Core.StlMes.Client.PlnSaleOrd.Control; using Infragistics.Win; using Core.StlMes.Client.PlnSaleOrd.PopupWindow; using Core.StlMes.Client.PlnSaleOrd.工序排产; using Core.Mes.Client.Comm.Control; namespace Core.StlMes.Client.PlnSaleOrd { public partial class FrmOrdFinishSet : FrmBase { public FrmOrdFinishSet() { this.IsLoadUserView = true; InitializeComponent(); System.Threading.Thread t = new System.Threading.Thread(setGridColunmName); t.Start(); } private void setGridColunmName() { System.Threading.Thread.Sleep(3000); if (!this.IsDisposed) { Init(); } } public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query": //查询 DoQuery(GetQueryCondition()); break; case "FinishJk"://设置缴库完毕 DoFinishJk(); break; case "FinishSc"://设置生产完毕 DoFinishSc("0"); break; case "ApplyFill"://申请补量 DoApplyFill(); break; case "LookApplyFill"://查看补量 LookApplyFill(); break; case "ExportProc": PlanComm.Export(ref ultraGridSaleOrder, "计划" + DateTime.Now.ToString("yyyyMMdd")); break; case "QueryExp"://查询下发合同信息 comOrdExportCtrl1.DoQueryExp(); break; case "Export": //导出 comOrdExportCtrl1.DoExport(); break; case "MandFinishSc"://强制生产完毕 DoFinishSc("1"); break; case "Close": //关闭 this.Close(); break; } } private void FrmOrdFinishSet_Load(object sender, EventArgs e) { comOrdExportCtrl1.ComBLL(this.ob); comOrdExportCtrl1.UltraTextAcceptNo.Value = "X" + DateTime.Now.ToString("yyyyMM"); comOrdExportCtrl1.CheckBoxAcpStatus.Checked = true; comOrdExportCtrl1.UltraComboEditAcpStatus.SelectedIndex = 3; comOrdExportCtrl1.UltraDateTimeDELVRY_EDATEFrom.DateTime = DateTime.Now.AddMonths(-1); comOrdExportCtrl1.UltraDateTimeDELVRY_EDATETo.DateTime = DateTime.Now; comQueryPanel1.checkBoxForReqPORDERSTATUS.Enabled = false; comQueryPanel1.ultraTextEditorAcceptNo.Value = "X" + DateTime.Now.ToString("yyyyMMdd"); Init(); if (this.CustomInfo.Equals("@JkFinish")) { this.comQueryPanel1.checkBoxisBl.Visible = true; } //DoQuery(GetQueryCondition()); } private void Init() { EntityHelper.ShowGridCaption(ultraGridSaleOrder.DisplayLayout.Bands[0]); PlanComm.setGridActivation(this.ultraGridSaleOrder.DisplayLayout.Bands[0], "CHC"); //PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 3, // "OrderQty", "Orderweight", "Planweight", "Paydownweight", "Lengthmax", "Lengthmin", // "ReqQtysum", "ConfirmWtSum", "PaydownWtMin", "PaydownWtMax"); //PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 2, // "Totlength", "TotlengthM"); //PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 2, // "Outdiameter", "Wallthick", "LenToendMin", "LenRollMin", "LenRollMax", // "LenToendMax", "LengthJg", "HeightOrdMax", "HeightOrdMin"); //PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 0, // "Ordernum", "PaydownNum"); PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 3, "OrderQtyD", "PlanWtD", "FinishWt", "PlanWtBegin", "PlanPMain"); PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 2, "Outdiameter", "Wallthick", "Lengthmax", "Lengthmin", "TotLenOneP", "HeightNkMin", "HeightNkMax", "LenToendMin", "LenToendMax","DelvryRangeMin", "DelvryRangeMax", "LengthJg", "DimaterYlg", "HeightYlg", "HeightOrdMax", "HeightOrdMin", "AimWallthick", "RollLength", "ShrtLenRato", "LongLenRato", "LenRollMin", "LenRollMax"); PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 3, "AimLenEnd", "AimLenRoll", "SiglLen", "EndlenSpecstd", "DifrncLenMax", "AvgLenMin", "Longest", "Shortest", "ZOrderweight"); PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 0, "PlanNumD", "PlanNumBegin", "CutNumP", "ZOrdernum"); PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 3, 6, "WeightPerM"); PlanComm.setGridSummarySet(ultraGridSaleOrder, 0, "PlanNumD"); PlanComm.setGridSummarySet(ultraGridSaleOrder, 3, "OrderQtyD", "PlanWtD", "FinishWt", "PlanWtBegin", "PlanPMain"); switch (this.CustomInfo.ToString().Trim()) { case "@ScFinish": ultraTabControl1.Tabs[1].Visible = true; comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Clear(); comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("1", "在产合同"); comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("0", "全部"); comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0; break; case "@JkFinish": comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Clear(); comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("2", "已下发"); comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("3", "生产中"); comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成"); comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完成"); comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0; break; case "@PAYDOWN1": comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Clear(); comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成"); comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完成"); comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0; break; case "@PAYDOWN2": comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Clear(); comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成"); comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完成"); comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0; break; case "@PAYDOWN3": comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成"); comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完成"); comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0; break; } } /// /// 获取查询条件信息 /// /// 查询条件信息 private ArrayList GetQueryCondition() { ArrayList ary = new ArrayList(); string strRollmonth = ""; string strAcceptNo = "";//接收批次号 string strOrderNo = ""; //合同号 string haveJg = ""; //是否有接箍 string haveDj = ""; //是否有短节 string isGpOrder = ""; //是否是管坯合同 if (comQueryPanel1.checkBoxHvJg.Checked) { haveJg = "1"; } if (comQueryPanel1.checkBoxHvDj.Checked) { haveDj = "1"; } if (comQueryPanel1.checkBoxisGp.Checked) { isGpOrder = "1"; } if (comQueryPanel1.checkBoxAcceptNo.Checked) { strAcceptNo = comQueryPanel1.ultraTextEditorAcceptNo.Text.Trim(); } if (comQueryPanel1.checkBoxForReqORDER_NO.Checked) { strOrderNo = comQueryPanel1.ctrlForQueryORDER_NO.Text.Trim(); } if (comQueryPanel1.checkBoxRollMonth.Checked) { strRollmonth = comQueryPanel1.ultraDateTimeRollMonth.DateTime.ToString("yyyy-MM"); } ary.Add(strRollmonth); ary.Add(strAcceptNo); ary.Add(strOrderNo); ary.Add(haveJg); ary.Add(haveJg); ary.Add(haveDj); ary.Add(haveDj); ary.Add(isGpOrder); ary.Add(isGpOrder); return ary; } /// /// 查询 /// private void DoQuery(ArrayList ary) { if (this.CustomInfo.ToString().Trim().Equals("@ScFinish")) { string strStatus = ""; if (comQueryPanel1.checkBoxForReqPORDERSTATUS.Checked && comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex == 0) { strStatus = "1"; } this.slmPlnSaleordEntitybindingSource.DataSource = EntityHelper.GetData( "com.steering.pss.plnsaleord.order.CoreOrdFinishSet.querySaleOrderSc", new object[] { ary, strStatus }, this.ob); // ProducHelper.copyLZData(ultraGridSaleOrder,"S", this.ob); } else { string orderFrom = ""; //合同来源 ary.Add(comQueryPanel1.ctrlForQueryPORDERSTATUS.Value.ToString()); switch (this.CustomInfo.ToString().Trim()) { case "@PAYDOWN1": //销售公司 orderFrom = "100101"; break; case "@PAYDOWN2": //国贸公司 orderFrom = "100102"; break; case "@PAYDOWN3": //钢贸公司 orderFrom = "100103"; break; } string orderSource = comQueryPanel1.checkBoxisBl.Checked ? "" : "备料需求"; //排产分类 this.slmPlnSaleordEntitybindingSource.DataSource = EntityHelper.GetData( "com.steering.pss.plnsaleord.order.CoreOrdFinishSet.querySaleOrder", new object[] { ary, orderFrom, this.ValidDataPurviewIds, orderSource }, this.ob); } } /// /// 合同置为生产完成 /// private void DoFinishSc(string falg) { try { int defailNum = 0; string messageErr = ""; ultraGridSaleOrder.UpdateData(); ArrayList list = new ArrayList(); IQueryable checkRows = ultraGridSaleOrder.Rows.AsQueryable().Where(" CHC = 'True' "); if (checkRows.Count() == 0) { MessageUtil.ShowTips("未勾选合同!"); return; } foreach (UltraGridRow uRow in checkRows) { if ("生产完成".Equals(uRow.Cells["Planstatus"].Value.ToString())) { MessageUtil.ShowTips(uRow.Cells["OrderNoSeq"].Value.ToString() + "以生产完成"); return; } //查询合同状态 DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.querySaleStatus", new object[] { uRow.Cells["OrdLnDlyPk"].Value.ToString() }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { defailNum++; continue; } if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0) { ArrayList param = new ArrayList(); param.Add("4"); param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString()); param.Add(uRow.Cells["OrdLnPk"].Value.ToString()); param.Add(uRow.Cells["OrderNoSeq"].Value.ToString()); param.Add(uRow.Cells["PlnDivideId"].Value.ToString()); //paramLine.Add("12020502"); //paramLine.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString()); list.Add(param); } else { if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("4")) { messageErr = "交货行:" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/" + uRow.Cells["DeliveryNo"].Value.ToString() + "已经是" + dtStatus.Rows[0]["PORDERSTATUS1"].ToString() + "状态!"; } else { messageErr = "交货行:" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/" + uRow.Cells["DeliveryNo"].Value.ToString() + "还未下发!"; } defailNum++; continue; } } if (falg.Equals("1")) { foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (ugr.Cells["PROCESS_DESC"].Text.ToString().Equals("轧管")) { if (int.Parse(ugr.Cells["LJ_NUM"].Text.ToString()) - int.Parse(ugr.Cells["CK_NUM"].Text.ToString())!= 0) { MessageUtil.ShowTips("轧管排产计划有LJ支,未全部出库,请联系轧管相关人员删除炉计划!"); return; } if (!ugr.Cells["FURNA_NUM"].Text.ToString().Equals("0")) { MessageUtil.ShowTips("轧管排产计划已装炉,未全部出库,如需强制关闭,请联系轧管相关人员删除炉计划!"); return; } } } } if (list.Count <= 0) { MessageUtil.ShowTips("0条修改成功," + defailNum + "条修改失败。\n" + messageErr); return; } if (MessageUtil.ShowYesNoAndQuestion(falg.Equals("0") ? "是否将这些合同置为生产完成?(共" + list.Count + "条)" : "是否强制将这些合同置为生产完成?(共" + list.Count + "条)") == DialogResult.No) { return; } //if (MessageUtil.ShowQuestion("是否?").Equals(DialogResult.No)) //{ // return; //} PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreOrdFinishSet"; ccp.MethodName = "setModifySale"; ccp.ServerParams = new object[] { list, falg,this.UserInfo.GetUserName(),this.CustomInfo.ToString() }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("修改成功!")) { if (defailNum == 0) { MessageUtil.ShowTips("修改成功,共" + list.Count + "条。"); } else { MessageUtil.ShowTips(list.Count + "条修改成功," + defailNum + "条修改失败。\n" + messageErr); } DoQuery(GetQueryCondition()); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } else { MessageUtil.ShowError("修改失败!\n" + ccp.ReturnInfo); } } catch (Exception ex) { PlanComm.WaitFromColse(this.Cursor); if (!(ex is MESException)) { MessageUtil.ShowError(ex.Message); } } } /// /// 合同置为缴库完成 /// private void DoFinishJk() { try { int defailNum = 0; string messageErr = ""; ultraGridSaleOrder.UpdateData(); ArrayList list = new ArrayList(); IQueryable checkRows = ultraGridSaleOrder.Rows.AsQueryable().Where(" CHC = 'True' "); if (checkRows.Count() == 0) { MessageUtil.ShowTips("未勾选合同!"); return; } PlanComm.WaitFromOpen(this.Cursor); foreach (UltraGridRow uRow in checkRows) { ///查询合同状态 DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.querySaleStatus", new object[] { uRow.Cells["OrdLnDlyPk"].Value.ToString() }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { defailNum++; continue; } if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("4") || dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("5") || dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("2") || dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("3")) { ArrayList param = new ArrayList(); param.Add("5"); param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString()); param.Add(uRow.Cells["OrdLnPk"].Value.ToString()); param.Add(uRow.Cells["OrderNoSeq"].Value.ToString()); param.Add(uRow.Cells["PlnDivideId"].Value.ToString()); //paramLine.Add("12020602"); //paramLine.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString()); list.Add(param); } else { messageErr = "只有已下发到生产完毕的合同才能置为缴库完毕!"; defailNum++; continue; } } if (list.Count <= 0) { PlanComm.WaitFromColse(this.Cursor); MessageUtil.ShowTips("0条修改成功," + defailNum + "条修改失败。\n" + messageErr); return; } if (MessageUtil.ShowQuestion("是否将这些合同置为缴库完成?(共" + list.Count + "条)").Equals(DialogResult.No)) { PlanComm.WaitFromColse(this.Cursor); return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreOrdFinishSet"; ccp.MethodName = "setModifySale"; ccp.ServerParams = new object[] { list,"1",UserInfo.GetUserName() }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode != -1) { if (defailNum == 0) { MessageUtil.ShowTips("修改成功,共" + list.Count + "条。"); } else { MessageUtil.ShowTips(list.Count + "条修改成功," + defailNum + "条修改失败。\n" + messageErr); } } else { MessageUtil.ShowError("修改失败!" + ccp.ReturnInfo); } } catch (Exception ex) { PlanComm.WaitFromColse(this.Cursor); if (!(ex is MESException)) { MessageUtil.ShowError(ex.Message); } } DoQuery(GetQueryCondition()); } /// /// 补量申请 /// private void DoApplyFill() { UltraGridRow ugr = ultraGridSaleOrder.ActiveRow; if (ugr == null) { return; } if (ugr.Cells["OrderSeq"].Value.ToString().Length < 3) { MessageUtil.ShowTips("外部导入系统合同不允许补量!"); return; } if (Double.Parse(ugr.Cells["PorderstatusTime"].Value.ToString()) > 7) { MessageUtil.ShowTips("生产完成7天内可以补量,超过7天就不能补量!"); return; } ///查询合同状态 DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.querySaleStatus", new object[] { ugr.Cells["OrdLnDlyPk"].Value.ToString() }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { return; } if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("4")) { PlnSaleorderRNumEntity reqEntity = new PlnSaleorderRNumEntity(); reqEntity.OrdLnDlyPk = ugr.Cells["OrdLnDlyPk"].Value.ToString(); reqEntity.OrderNo = ugr.Cells["OrderNo"].Value.ToString(); reqEntity.OrderSeq = ugr.Cells["OrderSeq"].Value.ToString(); reqEntity.DeliveryNo = ugr.Cells["DeliveryNo"].Value.ToString(); reqEntity.OrderUnit = dtStatus.Rows[0]["ORDER_UNIT"].ToString(); FrmReqRequest reqRequest = new FrmReqRequest(this.ob, reqEntity, Convert.ToDouble(dtStatus.Rows[0]["ORDER_QTY"])); reqRequest.ShowDialog(); } else { MessageUtil.ShowTips("只有在生产完成的合同才允许补量!"); return; } } /// /// 查看补量申请 /// private void LookApplyFill() { UltraGridRow ugr = ultraGridSaleOrder.ActiveRow; if (ugr == null) { return; } if (ugr.Cells["OrderSeq"].Value.ToString().Length < 3) { MessageUtil.ShowTips("外部导入系统合同不允许补量!"); return; } ///查询合同状态 DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.querySaleStatus", new object[] { ugr.Cells["OrdLnDlyPk"].Value.ToString() }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { return; } PlnSaleorderRNumEntity reqEntity = new PlnSaleorderRNumEntity(); reqEntity.OrdLnDlyPk = ugr.Cells["OrdLnDlyPk"].Value.ToString(); reqEntity.OrderNo = ugr.Cells["OrderNo"].Value.ToString(); reqEntity.OrderSeq = ugr.Cells["OrderSeq"].Value.ToString(); reqEntity.DeliveryNo = ugr.Cells["DeliveryNo"].Value.ToString(); reqEntity.OrderUnit = dtStatus.Rows[0]["ORDER_UNIT"].ToString(); FrmReqRequest reqRequest = new FrmReqRequest(this.ob, reqEntity, Convert.ToDouble(dtStatus.Rows[0]["ORDER_QTY"])); reqRequest.UltraToolbarsReq.Tools["doAdd"].SharedProps.Visible = false; reqRequest.UltraToolbarsReq.Tools["doModify"].SharedProps.Visible = false; reqRequest.ShowDialog(); } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (toolMenu != null) { if (e.Tab.TabPage == ultraTabPageControlOrd) { setTab1Appearance(DefaultableBoolean.True); setTab2Appearance(DefaultableBoolean.False); } else if (e.Tab.TabPage == ultraTabPageControlExport) { setTab1Appearance(DefaultableBoolean.False); setTab2Appearance(DefaultableBoolean.True); } } } private void FrmOrdFinishSet_Shown(object sender, EventArgs e) { setTab1Appearance(DefaultableBoolean.True); setTab2Appearance(DefaultableBoolean.False); } private void setTab1Appearance(DefaultableBoolean appearance) { #region tab1显示或隐藏 if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("FinishJk")) { toolMenu.Toolbars[0].Tools["FinishJk"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("FinishSc")) { toolMenu.Toolbars[0].Tools["FinishSc"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("ExportProc")) { toolMenu.Toolbars[0].Tools["ExportProc"].InstanceProps.Visible = appearance; } #endregion } private void setTab2Appearance(DefaultableBoolean appearance) { #region tab1显示或隐藏 if (toolMenu.Toolbars[0].Tools.Exists("QueryExp")) { toolMenu.Toolbars[0].Tools["QueryExp"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("Import")) { toolMenu.Toolbars[0].Tools["Import"].InstanceProps.Visible = appearance; } #endregion } private void ultraGridSaleOrder_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGridSaleOrder.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHC"].Value = true; } } } private void ultraGridSaleOrder_AfterRowActivate(object sender, EventArgs e) { UltraGridRow row= ultraGridSaleOrder.ActiveRow; if (row == null) { return; } DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreOrdFinishSet.queryPlnExeStatus", new object[] { row.Cells["OrdLnDlyPk"].Value.ToString(), row.Cells["PlnDivideId"].Value.ToString() }, this.ob); GridHelper.CopyDataToDatatable(dt, dataTable1, true); //foreach (UltraGridRow ugr in ultraGrid1.Rows) //{ // if (ugr.Cells["PROCESS_DESC"].Text.ToString().Equals("轧管")) // { // DataTable dtlz = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryLZDataZg", new object[] { }, ob); // if (dtlz.Rows.Count > 0) // { // DataRow[] drs = dtlz.Select("订单号 ='" + ugr.Cells["PRO_PLAN_ID"].Value.ToString() + "' AND 序号='" + ugr.Cells["GX_PLAN_NO"].Value.ToString() + "'"); // if (drs != null && drs.Length > 0) // { // if (!drs[0]["装炉支"].ToString().Equals("")) // { // ugr.Cells["装炉支"].Value = drs[0]["装炉支"].ToString(); // ugr.Cells["装炉吨"].Value = drs[0]["装炉吨"].ToString(); // } // if (!drs[0]["LJ支"].ToString().Equals("")) // { // ugr.Cells["LJ支"].Value = drs[0]["LJ支"].ToString(); // ugr.Cells["LJ吨"].Value = drs[0]["LJ吨"].ToString(); // } // if (!drs[0]["出库支"].ToString().Equals("")) // { // ugr.Cells["出库支"].Value = drs[0]["出库支"].ToString(); // ugr.Cells["出库吨"].Value = drs[0]["出库吨"].ToString(); // } // } // } // } //} } } }