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 System.Collections; using System.IO; using System.Diagnostics; using Infragistics.Win.UltraWinGrid; using Infragistics.Win; using Infragistics.Win.UltraWinGrid.ExcelExport; using Infragistics.Excel; using CoreFS.CA06; using CoreFS.SA06; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm; using Core.Mes.Client.Comm.Tool; using com.steering.pss.plan.order; using com.steering.pss.plan.order.model; namespace Core.StlMes.Client.Plan.Order { /// /// 销售合同处理 /// @author：杨天海 /// @version：v1.2 /// @date:2015.09.23 /// public partial class FrmPlnOrderJgDj : FrmBase { //用于计算可分离容器的大小。 private int _splitterDistance = 0; private bool _groupBox2ExpandedChanged = false; public FrmPlnOrderJgDj() { this.IsLoadUserView = true; InitializeComponent(); } public FrmPlnOrderJgDj(OpeBase ob) { this.ob = ob; InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query": //查询 doQuery(GetQueryCondition()); break; case "ProcessJG"://接箍处理 doProcessJg(); break; case "CancelJg"://取消接箍合同 doCancelJg(); break; case "ProcessDJ"://短节处理 doProcessDj(); break; case "CancelDj"://取消短节合同 doCancelDj(); break; case "QueryJgl": //接箍料编制查询 QueryJGl(); break; case "SaveJg": //保存接箍合同 UpdateJgOrder(); break; case "Plait": //接箍料需求保存 doPlait(); break; case "AddPlait": //加入现有接箍料需求 doAddPlait(); break; case "Delete": //删除接箍需求 Delete(); break; case "DeleteOne": //删除接箍需求单量 DeleteOne(); break; case "RefresDate"://刷新加载数据 RefresDate(); break; case "Close": //关闭 this.Close(); break; } } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "Save"://更新短节备料信息 UpdateDjBl(ultraGrid3); break; case "ConfirmZg"://轧管确认 ConfirmBlZg(ultraGrid3); break; case "ConfirmBj"://镦拔扩确认 ConfirmBlBj(ultraGrid3); break; case "ConfirmRcl"://热处理确认 ConfirmBlRcl(ultraGrid3); break; case "Iussed"://短节需求下发 IssuedBlNeed(ultraGrid3); break; case "CancelIssued"://取消下发 CancelBlIssued(ultraGrid3); break; case "Export": doExportBl("DJBL"); break; } } /// /// 备料轧管确认 /// private void ConfirmBlZg(UltraGrid ugrid) { try { ugrid.UpdateData(); ArrayList list = new ArrayList(); IQueryable checkRows = ugrid.Rows.AsQueryable().Where(" CHC = 'True' "); if (checkRows.Count() == 0) { MessageUtil.ShowTips("未勾选保存的备料！"); return; } foreach (UltraGridRow uRow in checkRows) { ///查询合同状态 DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBLbyReqBlId", new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { break; } if (dtStatus.Rows[0]["PLANSTATUS"].ToString().Equals("0")) { ArrayList param = new ArrayList(); param.Add("1"); param.Add(uRow.Cells["GROUP_ROLL"].Value.ToString()); param.Add(uRow.Cells["DIMATER_YLG"].Value.ToString()); param.Add(uRow.Cells["HEIGHT_YLG"].Value.ToString()); param.Add(uRow.Cells["REQ_BL_ID"].Value.ToString()); list.Add(param); } } if (list.Count == 0) { return; } int suceed = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.confirmBlZg", new object[] { list }, this.ob); if (suceed > 0) { MessageUtil.ShowTips("保存成功！"); } else { MessageUtil.ShowTips("保存失败！"); } } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } if (ugrid != ultraGrid3) { QueryJGl(); } else { doQuery(GetQueryCondition()); } } /// /// 镦拔扩确认 /// private void ConfirmBlBj(UltraGrid ugrid) { try { ugrid.UpdateData(); ArrayList list = new ArrayList(); IQueryable checkRows = ugrid.Rows.AsQueryable().Where(" CHC = 'True' "); if (checkRows.Count() == 0) { MessageUtil.ShowTips("未勾选要保存的备料！"); return; } foreach (UltraGridRow uRow in checkRows) { ///查询合同状态 DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBLbyReqBlId", new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { break; } if (dtStatus.Rows[0]["PLANSTATUS"].ToString().Equals("0")) { ArrayList param = new ArrayList(); if (uRow.Cells["BJ_TYPE"].Value.ToString().Equals("") || uRow.Cells["BJ_TYPE"].Value.ToString().Equals("/")) { param.Add("2"); } else { param.Add("1"); } param.Add(uRow.Cells["E_IN_MATERIAL_NO"].Value.ToString()); param.Add(uRow.Cells["E_IN_MATERIAL_NO"].Text.Trim()); param.Add(uRow.Cells["DIMATER_YLG"].Value.ToString()); param.Add(uRow.Cells["HEIGHT_YLG"].Value.ToString()); param.Add(uRow.Cells["BJ_TYPE"].Value.ToString()); param.Add(uRow.Cells["REQ_BL_ID"].Value.ToString()); list.Add(param); } } if (list.Count == 0) { return; } int suceed = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.confirmBlBj", new object[] { list }, this.ob); if (suceed > 0) { MessageUtil.ShowTips("保存成功！"); } else { MessageUtil.ShowTips("保存失败！"); } } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } if (ugrid != ultraGrid3) { QueryJGl(); } else { doQuery(GetQueryCondition()); } } /// /// 热处理确认 /// private void ConfirmBlRcl(UltraGrid ugrid) { try { ugrid.UpdateData(); ArrayList list = new ArrayList(); IQueryable checkRows = ugrid.Rows.AsQueryable().Where(" CHC = 'True' "); if (checkRows.Count() == 0) { MessageUtil.ShowTips("未勾选要保存的备料！"); return; } foreach (UltraGridRow uRow in checkRows) { ///查询合同状态 DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBLbyReqBlId", new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { break; } if (dtStatus.Rows[0]["PLANSTATUS"].ToString().Equals("0")) { ArrayList param = new ArrayList(); if (uRow.Cells["GROUP_RCL"].Value.ToString().Equals("") || uRow.Cells["GROUP_RCL"].Value.ToString().Equals("/")) { param.Add("2"); } else { param.Add("1"); } param.Add(uRow.Cells["GROUP_RCL"].Value.ToString()); param.Add(uRow.Cells["REQ_BL_ID"].Value.ToString()); list.Add(param); } } if (list.Count == 0) { return; } int suceed = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.confirmBlRcl", new object[] { list }, this.ob); if (suceed > 0) { MessageUtil.ShowTips("保存成功！"); } else { MessageUtil.ShowTips("保存失败！"); } } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } if (ugrid != ultraGrid3) { QueryJGl(); } else { doQuery(GetQueryCondition()); } } private void ultraToolbarsManager2_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "Save"://保存接箍料信息 UpdateDjBl(ultraGrid6); break; case "ConfirmZg"://轧管确认 ConfirmBlZg(ultraGrid6); break; case "ConfirmBj"://镦拔扩确认 ConfirmBlBj(ultraGrid6); break; case "ConfirmRcl"://热处理确认 ConfirmBlRcl(ultraGrid6); break; case "Iussed": //接箍料需求下发 IssuedBlNeed(ultraGrid6); break; case "CancelIssued"://取消下发 CancelBlIssued(ultraGrid6); break; case "Export": doExportBl("JGL"); break; } } private void ultraToolbarsManager3_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "Iussed"://合同下发 OrderJgIssued(); break; case "CancelIssued"://取消下发 CancelJgIssued(); break; } } /// /// 页面加载 /// /// /// private void FrmSaleOrderOP_Load(object sender, EventArgs e) { ctrlForQueryPORDERSTATUS.SelectedIndex = 0; this.ultraTextEditorAcceptNo.Value = DateTime.Now.ToString("yyMM") + "X" + DateTime.Now.ToString("MMdd"); RefresDate(); } /// /// 刷新加载数据 /// private void RefresDate() { DataTable tableBaseInfo = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBaseinfoAll", new object[] { }, this.ob); DataTable tableBlbjtype = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getBjProcessC", new object[] { }, this.ob); DataTable tableBlPline = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBlZgPline", new object[] { }, this.ob); DataTable tableGrade = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBaseGrade", new object[] { }, this.ob); //热处理组 ValueList vlistS1 = PlanComm.GeneralValuelist(ref tableBaseInfo, "BASECODE", "BASENAME"); vlistS1.ValueListItems.Insert(0, "/", "/"); ultraGrid3.DisplayLayout.Bands[0].Columns["GROUP_RCL"].ValueList = vlistS1; ValueList vlistS2 = PlanComm.GeneralValuelist(ref tableBaseInfo, "BASECODE", "BASENAME"); vlistS2.ValueListItems.Insert(0, "/", "/"); ultraGrid6.DisplayLayout.Bands[0].Columns["GROUP_RCL"].ValueList = vlistS2; ValueList vlistSteel1 = PlanComm.GeneralValuelist(ref tableBlbjtype, "PROCESS_DESC_C", "PROCESS_DESC_C"); vlistSteel1.ValueListItems.Insert(0, "/", "/"); ultraGrid3.DisplayLayout.Bands[0].Columns["BJ_TYPE"].ValueList = vlistSteel1; ValueList vlistSteel2 = PlanComm.GeneralValuelist(ref tableBlbjtype, "PROCESS_DESC_C", "PROCESS_DESC_C"); vlistSteel2.ValueListItems.Insert(0, "/", "/"); ultraGrid6.DisplayLayout.Bands[0].Columns["BJ_TYPE"].ValueList = vlistSteel2; ultraGrid3.DisplayLayout.Bands[0].Columns["GROUP_ROLL"].ValueList = PlanComm.GeneralValuelist(ref tableBlPline, "PLINE_CODE", "PLINE_NAME"); ultraGrid6.DisplayLayout.Bands[0].Columns["GROUP_ROLL"].ValueList = PlanComm.GeneralValuelist(ref tableBlPline, "PLINE_CODE", "PLINE_NAME"); ultraGrid3.DisplayLayout.Bands[0].Columns["GRADECODE"].ValueList = PlanComm.GeneralValuelist(ref tableGrade, "GRADECODE", "GRADENAME"); ultraGrid6.DisplayLayout.Bands[0].Columns["GRADECODE"].ValueList = PlanComm.GeneralValuelist(ref tableGrade, "GRADECODE", "GRADENAME"); doQuery(GetQueryCondition()); } /// /// 获取查询条件信息 /// /// 查询条件信息 private ArrayList GetQueryCondition() { ArrayList ary = new ArrayList(); string strRollmonth = ""; string strAcceptNo = "";//接收批次号 string strOrderNo = ""; //合同号 string strOrderStatus = ""; //合同状态 string haveJg = ""; //是否有接箍 string haveDj = ""; //是否有短节 if (this.checkBoxHvJg.Checked) { haveJg = "1"; } if (this.checkBoxHvDj.Checked) { haveDj = "1"; } if (this.checkBoxAcceptNo.Checked) { strAcceptNo = this.ultraTextEditorAcceptNo.Text.Trim(); } if (checkBoxForReqORDER_NO.Checked) { strOrderNo = ctrlForQueryORDER_NO.Text.Trim(); } if (checkBoxForReqPORDERSTATUS.Checked) { strOrderStatus = ctrlForQueryPORDERSTATUS.Value.ToString(); } if (checkBoxRollMonth.Checked) { strRollmonth = ultraDateTimeRollMonth.DateTime.ToString("yyyy-MM"); } ary.Add(strRollmonth); ary.Add(strAcceptNo); ary.Add(strOrderNo); ary.Add(strOrderStatus); ary.Add(haveJg); ary.Add(haveJg); ary.Add(haveDj); ary.Add(haveDj); return ary; } /// /// 根据信息栏查询 /// /// 查询条件信息 private void doQuery(ArrayList ary) { try { if (ary == null) { return; } DataTable dt1 = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.querySaleOrder", new object[] { ary }, this.ob); GridHelper.CopyDataToDatatable(dt1, dataTable1, true); DataTable dt2 = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryJgOrder", new object[] { ary }, this.ob); GridHelper.CopyDataToDatatable(dt2, dataTable2, true); DataTable dt3 = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryDjBlNeed", new object[] { ary }, this.ob); GridHelper.CopyDataToDatatable(dt3, dataTable3, true); ///设置ultraGrid1单元格不可编辑 PlanComm.setGridActivation(ultraGrid1.DisplayLayout.Bands[0], "CHC"); ///设置ultraGrid2单元格不可编辑 PlanComm.setGridActivation(ultraGrid2.DisplayLayout.Bands[0], "CHC"); #region ultraGrid3表格查询 foreach (UltraGridRow uRow in ultraGrid3.Rows) { if (!uRow.Cells["PLANSTATUS"].Value.ToString().Equals("待处理")) { uRow.Cells["JGBL_REQ_WEIGHT"].Activation = Activation.ActivateOnly; uRow.Cells["MATCHWEIGHT"].Activation = Activation.ActivateOnly; uRow.Cells["INDEX_SEQ"].Activation = Activation.ActivateOnly; } } #endregion ///设置ultraGrid3单元格不可编辑 string[] strColum3 = new string[] { "CHC", "JGBL_REQ_WEIGHT", "MATCHWEIGHT", "GRADECODE", "GROUP_RCL","DIMATER_YLG","HEIGHT_YLG", "BJ_TYPE", "GROUP_ROLL" }; PlanComm.setGridActivation(ultraGrid3.DisplayLayout.Bands[0], strColum3); } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } } /// /// 查询销售合同对应接箍和备料合同 /// /// /// private void ultraGrid1_BeforeRowActivate(object sender, RowEventArgs e) { #region 查询接箍短节 string orderNo = e.Row.Cells["ORDER_NO"].Value.ToString(); string orderSeq = e.Row.Cells["ORDER_SEQ"].Value.ToString(); string deliveryNo = e.Row.Cells["DELIVERY_NO"].Value.ToString(); foreach (UltraGridRow uRow in ultraGrid2.Rows) { if (uRow.Cells["ORDER_NO"].Value.ToString().Equals(orderNo) && uRow.Cells["ORDER_SEQ"].Value.ToString().Equals(orderSeq) && uRow.Cells["DELIVERY_NO"].Value.ToString().Equals(deliveryNo)) { ultraGrid2.ActiveRow = uRow; uRow.Appearance.ForeColor = System.Drawing.Color.DarkBlue; } else { uRow.Appearance.ForeColor = System.Drawing.Color.Black; } } foreach (UltraGridRow uRow in ultraGrid3.Rows) { if (uRow.Cells["ORDER_NO"].Value.ToString().Equals(orderNo) && uRow.Cells["ORDER_SEQ"].Value.ToString().Equals(orderSeq) && uRow.Cells["DELIVERY_NO"].Value.ToString().Equals(deliveryNo)) { ultraGrid3.ActiveRow = uRow; uRow.Appearance.ForeColor = System.Drawing.Color.DarkBlue; } else { uRow.Appearance.ForeColor = System.Drawing.Color.Black; } } #endregion } /// /// 接箍料编制查询 /// private void QueryJGl() { try { DataTable dtJg = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryJgDeal", new object[] { }, this.ob); GridHelper.CopyDataToDatatable(dtJg, dataTable5, true); PlanComm.setGridDigitalColMaxInput(ultraGrid5.DisplayLayout.Bands[0], 5, 2, "OUTDIAMETER", "WALLTHICK", "AIMWALLTHICK", "AIMLENGTH"); PlanComm.setGridDigitalColMaxInput(ultraGrid5.DisplayLayout.Bands[0], 5, 3, "SINGLEWEIGHT", "ORDERWEIGHT", "MATCHWEIGHT"); PlanComm.setGridDigitalColMaxInput(ultraGrid5.DisplayLayout.Bands[0], 5, 0, "ORDERNUM", "MATCHNUM", "JGWT_BLREQ"); ///设置grid不可编辑 PlanComm.setGridActivation(ultraGrid5.DisplayLayout.Bands[0], "CHC", "MATCHNUM", "BUYCHOOSE"); DataTable dtEdit = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryJgDealedit", new object[] { }, this.ob); GridHelper.CopyDataToDatatable(dtEdit, dataTable7, true); foreach (UltraGridRow uRow in ultraGrid7.Rows) { uRow.Cells["SINGLE_ADDLEN"].Value = 10; } ///设置grid不可编辑 PlanComm.setGridActivation(ultraGrid7.DisplayLayout.Bands[0], "CHC", "NUM_JG", "SINGLE_ADDLEN"); foreach (UltraGridRow uRow in ultraGrid7.Rows) { uRow.Cells["NUM_JG"].Activation = Activation.ActivateOnly; } DataTable dtJgl = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryJgBlNeed", new object[] { }, this.ob); GridHelper.CopyDataToDatatable(dtJgl, dataTable6, true); ///设置grid不可编辑 string[] strColumn = new string[] { "CHC", "MATCHWEIGHT", "GRADECODE", "GROUP_RCL", "DIMATER_YLG","HEIGHT_YLG", "BJ_TYPE", "GROUP_ROLL", "INDEX_SEQ" }; PlanComm.setGridActivation(ultraGrid6.DisplayLayout.Bands[0], strColumn); PlanComm.setGridDigitalColMaxInput(ultraGrid6.DisplayLayout.Bands[0], 5, 2, "OUTDIAMETER", "WALLTHICK", "AIMWALLTHICK", "LENGTHMAX", "LENGTHMIN", "AIMLENGTH"); PlanComm.setGridDigitalColMaxInput(ultraGrid6.DisplayLayout.Bands[0], 5, 3, "SINGLEWEIGHT", "JGBL_REQ_WEIGHT", "MATCHWEIGHT"); PlanComm.setGridDigitalColMaxInput(ultraGrid6.DisplayLayout.Bands[0], 5, 0, "JGBL_REQ_NUM", "MATCHNUM"); dataTable4.Clear(); } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } } /// /// 备料导出 /// private void doExportBl(string bjType) { string url = ""; if (bjType.Equals("JGL")) { url = "http://localhost:8075/WebReport/ReportServer?reportlet=ReqPlnBlJgOrder.cpt"; } else { url = "http://localhost:8075/WebReport/ReportServer?reportlet=ReqPlnBlDjOrder.cpt"; } FrmOutExcel outPut = new FrmOutExcel(url); outPut.ShowDialog(); } /// /// 更新短节备料信息 /// private void UpdateDjBl(UltraGrid ugrid) { try { ugrid.UpdateData(); IQueryable checkRows = ugrid.Rows.AsQueryable().Where(" CHC = 'True'"); ArrayList list = new ArrayList(); ///如果没有勾选待处理的条目，提示。 if (checkRows.Count() == 0) { MessageUtil.ShowTips("未勾选要保存的备料！"); return; } foreach (UltraGridRow uRow in checkRows) { ArrayList parms = new ArrayList(); parms.Add(uRow.Cells["JGBL_REQ_WEIGHT"].Value.ToString()); parms.Add(uRow.Cells["JGBL_REQ_NUM"].Value.ToString()); parms.Add(uRow.Cells["MATCHWEIGHT"].Value.ToString()); parms.Add(uRow.Cells["MATCHNUM"].Value.ToString()); parms.Add(uRow.Cells["GRADECODE"].Value.ToString()); parms.Add(uRow.Cells["REQ_BL_ID"].Value.ToString()); list.Add(parms); } int suceed = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.UpdateDjblRcl", new object[] { list }, this.ob); if (suceed > 0) { MessageUtil.ShowTips("保存成功！"); } else { MessageUtil.ShowTips("保存失败！"); } } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } if (ugrid != ultraGrid3) { QueryJGl(); } else { doQuery(GetQueryCondition()); } } /// /// 保存接箍合同利库量和外购量信息 /// private void UpdateJgOrder() { try { ArrayList list = new ArrayList(); bool isChecked = false; foreach (UltraGridRow uRow in ultraGrid5.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text)) { ArrayList parms = new ArrayList(); isChecked = true; parms.Add(uRow.Cells["MATCHWEIGHT"].Value.ToString()); parms.Add(uRow.Cells["MATCHNUM"].Value.ToString()); if (Convert.ToBoolean(uRow.Cells["BUYCHOOSE"].Text)) { int buyplannum = Convert.ToInt32(uRow.Cells["ORDERNUM"].Value) - Convert.ToInt32(uRow.Cells["MATCHNUM"].Value) - Convert.ToInt32(uRow.Cells["JGWT_BLREQ"].Value); double buyplanweight = buyplannum * Convert.ToDouble(uRow.Cells["SINGLEWEIGHT"].Value) / 1000; parms.Add("1");//有无外购计划(1-有，0-无) parms.Add(buyplanweight.ToString()); parms.Add(buyplannum); } else { parms.Add("0"); parms.Add("0"); parms.Add("0"); } parms.Add(uRow.Cells["JG_ORDERNO"].Value.ToString()); list.Add(parms); } } ///如果没有勾选待处理的条目，提示。接箍合同 if (!isChecked) { MessageUtil.ShowTips("未勾选待要保存的接箍合同！"); return; } ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.updateLkwgWeight", new object[] { list }, this.ob); } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } QueryJGl(); } /// /// 查询产品码 /// /// 备料品名、标准、钢级、标准类别 /// 产品码 public string QueryPsc(string producCode, string stdCode, string steelCode, string stdStyle) { try { ArrayList param = new ArrayList(); param.Add(producCode); param.Add(stdCode); param.Add(steelCode); param.Add(stdStyle); param.Add(stdStyle); param.Add(stdStyle); DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryblPsc", new object[] { param }, this.ob); if (dt != null && dt.Rows.Count > 0) { return dt.Rows[0]["PSC"].ToString(); } else { return ""; } } catch { return ""; } } /// /// 查询产品码与冶金规范对应关系\ /// /// 产品码 /// 冶金规范码 public string QueryPscForMsc(string strPsc) { try { DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryPscForMsc", new object[] { strPsc }, this.ob); if (dt != null && dt.Rows.Count > 0) { return dt.Rows[0]["MSC"].ToString(); } else { return ""; } } catch { return ""; } } /// /// 根据备料冶金规范查找制程索引 /// /// 冶金规范码 /// 制程索引号集合 private DataTable QueryBlIndex(string strMsc) { try { ArrayList parms = new ArrayList(); parms.Add(strMsc); DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryMscIndex", new object[] { parms }, this.ob); return dt; } catch { return null; } } /// /// 查询备料工序 /// /// 冶金规范 /// 全程产线 /// 工序列表 private DataTable QueryBlProcess(string strMsc, string msc_pline) { try { ArrayList parms = new ArrayList(); parms.Add(strMsc); parms.Add(msc_pline); DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBlProcess", new object[] { parms }, this.ob); return dt; } catch { return null; } } /// /// 查询接箍码 /// /// Design_Key /// 接箍码表 private DataTable QueryJgCode(string strDesgin_key) { try { DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryJgCode", new object[] { strDesgin_key }, this.ob); return dt; } catch { return null; } } /// /// 查询短节备料码 /// /// desgin_key /// 短节备料码集合 public DataTable QueryBlCode(string strDesgin_key) { try { DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBlCode", new object[] { strDesgin_key }, this.ob); return dt; } catch { return null; } } /// /// 查询一组短节备料码 /// /// 质量设计主键 /// 备料组号 /// private DataTable queryBlCodeByGp(string designKey, string gourpNum) { try { ArrayList param = new ArrayList(); param.Add(designKey); param.Add(gourpNum); DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBlCodeByGp", new object[] { param }, this.ob); return dt; } catch { return null; } } /// /// 查询接箍系数 /// /// private double queryCoeffiJg(int year, int month) { double coeffiJg = 1; ArrayList param = new ArrayList(); param.Add(year); param.Add(month); DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryPutRate", new object[] { param }, this.ob); if (dt != null && dt.Rows.Count > 0) { double.TryParse(dt.Rows[0]["COEFFI_JG"].ToString(), out coeffiJg); } return coeffiJg; } /// /// 接箍处理 /// private void doProcessJg() { try { ultraGrid1.UpdateData(); IQueryable checkRows = ultraGrid1.Rows.AsQueryable().Where("CHC = 'True'"); if (checkRows.Count() == 0) { MessageUtil.ShowTips("未勾选合同！"); return; } WaitFromOpen(); ArrayList listupdate = new ArrayList(); ArrayList list = new ArrayList(); foreach (UltraGridRow uRow in checkRows) { ArrayList status = new ArrayList(); status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString()); DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.querySaleStatus", new object[] { status }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { break; } if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1")) { if (dtStatus.Rows[0]["JGORD_IS_OK"].ToString().Equals("1")) { WaitFromColse(); MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已处理接箍！"); return; } if (dtStatus.Rows[0]["JGORD_IS_OK"].ToString().Equals("2")) { WaitFromColse(); MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "没有接箍！"); return; } if (dtStatus.Rows[0]["PLAN_NUM"].ToString().Equals("") || dtStatus.Rows[0]["PLAN_NUM"].ToString().Equals("0")) { WaitFromColse(); MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "合同计划支数未知，请检查合同信息！"); return; } string strDesgin_key = uRow.Cells["DESGIN_KEY"].Value.ToString(); DataTable dtjg = QueryJgCode(strDesgin_key); ArrayList param = new ArrayList(); double weightSale = 0; if (dtjg.Rows.Count > 0 && dtjg != null) { int JGnum = 0; foreach (DataRow dr in dtjg.Rows) { #region 接箍需求信息处理 JGnum++; string strCodeJg = dr["CODE_JG"].ToString();//接箍码 ArrayList parms = new ArrayList(); //接箍合同号（合同号_合同行号_交货编码_G01） string strJGorderno = uRow.Cells["ORDER_NO"].Value.ToString() + uRow.Cells["ORDER_SEQ"].Value.ToString() + uRow.Cells["DELIVERY_NO"].Value.ToString() + "_G" + JGnum.ToString().PadLeft(2, '0'); double single_weight = 0; //接箍个单量 double weightJg = 0; //接箍合同量 PlnOrderJgEntity jgEntity = new PlnOrderJgEntity(); DataTable dtjgbase = QueryJgBase(strCodeJg); if (dtjgbase == null || dtjgbase.Rows.Count <= 0) { WaitFromColse(); MessageUtil.ShowTips("未找到接箍码为："+strCodeJg + "的基础信息，请查看接箍码维护信息！"); return; } single_weight = Convert.ToDouble(dtjgbase.Rows[0]["WEIGHT_JG"]) / 1000; weightJg = Convert.ToInt32(dtStatus.Rows[0]["PLAN_NUM"]) * single_weight; weightSale += weightJg; jgEntity.JgOrderno = strJGorderno; jgEntity.OrderNo = uRow.Cells["ORDER_NO"].Value.ToString(); jgEntity.OrderSeq = uRow.Cells["ORDER_SEQ"].Value.ToString(); jgEntity.DeliveryNo = uRow.Cells["DELIVERY_NO"].Value.ToString(); jgEntity.BuyerId = uRow.Cells["BUYER_ID"].Value.ToString(); jgEntity.BuyerName = uRow.Cells["BUYER_NAME"].Value.ToString(); jgEntity.DelvryEdate = uRow.Cells["DELVRY_EDATE"].Value.ToString(); jgEntity.Ordercontact = uRow.Cells["ORDERCONTACT"].Value.ToString(); jgEntity.PrdcrNo = uRow.Cells["PRDCR_NO"].Value.ToString(); jgEntity.IfMonitorJg = "0"; jgEntity.Psc = uRow.Cells["PSC"].Value.ToString(); jgEntity.Msc = uRow.Cells["MSC"].Value.ToString(); jgEntity.CodeJg = strCodeJg; jgEntity.Steelcode = dtjgbase.Rows[0]["STEELCODE_JG"].ToString(); jgEntity.Steelname = dtjgbase.Rows[0]["STEELCODE_JG_DESC"].ToString(); jgEntity.Outdiameter = dtjgbase.Rows[0]["DIAMETER_JG"].ToString(); jgEntity.Wallthick = dtjgbase.Rows[0]["HEIGHT_JG"].ToString(); jgEntity.ModelCode = dtjgbase.Rows[0]["MODEL_CODE"].ToString(); jgEntity.ModelDesc = dtjgbase.Rows[0]["MODEL_DESC"].ToString(); jgEntity.Aimlength = dtjgbase.Rows[0]["LENGTH_JG"].ToString(); jgEntity.Singleweight = dtjgbase.Rows[0]["WEIGHT_JG"].ToString(); jgEntity.Orderweight = weightJg.ToString(); jgEntity.Ordernum = dtStatus.Rows[0]["PLAN_NUM"].ToString(); jgEntity.CreateName = CoreUserInfo.UserInfo.GetUserName(); DataTable dtPro = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryPrdcrLst", new object[] { jgEntity.PrdcrNo }, this.ob); if (dtPro != null && dtPro.Rows.Count > 0) { jgEntity.Monitordemand = dtPro.Rows[0]["PROCESS_DESC"].ToString(); jgEntity.IfMonitorJg = "1"; } list.Add(jgEntity); #endregion } } #region 更新销售合同 weightSale = weightSale * queryCoeffiJg(DateTime.Now.Year, DateTime.Now.Month); param.Add("1"); param.Add("0"); param.Add(weightSale.ToString());//更新销售合同排产量=计划量-接箍量*系数 param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString()); listupdate.Add(param); #endregion } else { WaitFromColse(); if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0) { MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已下发，不能修改！"); } else { MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "未接收！"); } return; } } int succed = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.tranSactionJg", new object[] { list, listupdate }, this.ob); WaitFromColse(); if (succed > 0) { MessageUtil.ShowTips("接箍处理成功！"); } else { MessageUtil.ShowTips("接箍处理失败！"); } } catch (Exception ex) { WaitFromColse(); if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } doQuery(GetQueryCondition()); } /// /// 撤消接箍处理 /// private void doCancelJg() { try { ArrayList list = new ArrayList(); ultraGrid1.UpdateData(); IQueryable checkRows = ultraGrid1.Rows.AsQueryable().Where("CHC = 'True'"); if (checkRows.Count() == 0) { MessageUtil.ShowTips("未勾选合同！"); return; } WaitFromOpen(); foreach (UltraGridRow uRow in checkRows) { ArrayList status = new ArrayList(); status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString()); DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.querySaleStatus", new object[] { status }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { break; } if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1")) { if (!dtStatus.Rows[0]["JGORD_IS_OK"].ToString().Equals("1")) { WaitFromColse(); Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" +uRow.Cells["ORDER_SEQ"].Value.ToString() + "没有接箍合同！"); return; } ArrayList param = new ArrayList(); param.Add(CoreUserInfo.UserInfo.GetUserName()); param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString()); list.Add(param); } else if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0) { WaitFromColse(); Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" +uRow.Cells["ORDER_SEQ"].Value.ToString() + "已下发，不能撤销！"); return; } else if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") < 0) { WaitFromColse(); Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "还未接收！"); return; } } int succed = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.doCancelJg", new object[] { list }, this.ob); WaitFromColse(); if (succed > 0) { MessageUtil.ShowTips("撤消接箍合同成功！"); } else { MessageUtil.ShowTips("撤消接箍合同失败！"); } } catch (Exception ex) { WaitFromColse(); if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } doQuery(GetQueryCondition()); } /// /// 短节处理 /// private void doProcessDj() { try { ultraGrid1.UpdateData(); IQueryable checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHC = 'True'"); if (checkRows.Count() == 0) { MessageUtil.ShowTips("未勾选合同！"); return; } ArrayList paramBL = new ArrayList(); ArrayList paramUpdate = new ArrayList(); WaitFromOpen(); foreach (UltraGridRow uRow in checkRows) { ArrayList status = new ArrayList(); status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString()); DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.querySaleStatus", new object[] { status }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { break; } if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1")) { if (dtStatus.Rows[0]["DJBL_REQ_IS_OK"].ToString().Equals("2")) { WaitFromColse(); MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "没有短节！"); return; } if (dtStatus.Rows[0]["DJBL_REQ_IS_OK"].ToString().Equals("1")) { WaitFromColse(); MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已处理短节！"); return; } string strDesgin_key = uRow.Cells["DESGIN_KEY"].Value.ToString(); DataTable dtBl = queryBlCodeByGp(strDesgin_key, uRow.Cells["BL_GROUP_NUM"].Value.ToString()); ArrayList listupdate = new ArrayList(); if (dtBl.Rows.Count > 0 && dtBl != null) { foreach (DataRow dr in dtBl.Rows) { string strCodeBl = dr["PSC_BL"].ToString();//备料码 DataTable dtbllist = QueryBlList(strCodeBl); if (dtbllist != null && dtbllist.Rows.Count > 0) { ArrayList parms = new ArrayList(); double planNum = Convert.ToInt32(uRow.Cells["PLAN_NUM"].Value); #region 备料清单信息 double min_d = Convert.ToDouble(dtbllist.Rows[0]["MIN_D"]); double min_h = Convert.ToDouble(dtbllist.Rows[0]["MIN_H"]); double Weight_One = PlanComm.WeightOfMi(min_d, min_h);//米单重(吨/米) string strPSC = "";//产品码 double aimlength = (Convert.ToDouble(dtbllist.Rows[0]["MAX_L"]) + Convert.ToDouble(dtbllist.Rows[0]["MIN_L"])) / 2; double singleweight = aimlength * Weight_One;//单重 double eatchBlnum = aimlength / //每只备料管可切短节支数。 Convert.ToDouble(uRow.Cells["LENGTHMAX"].Value); string specSameSale = "0"; if (uRow.Cells["OUTDIAMETER"].Value.ToString().Equals(dtbllist.Rows[0]["MIN_D"].ToString()) && uRow.Cells["WALLTHICK"].Value.ToString().Equals(dtbllist.Rows[0]["MIN_H"].ToString()) && uRow.Cells["STEELCODE"].Value.ToString().Equals(dtbllist.Rows[0]["STEELCODE"].ToString())) { specSameSale = "1"; } parms.Add("短节备料"); parms.Add(uRow.Cells["ORDER_NO"].Value.ToString()); parms.Add(uRow.Cells["ORDER_SEQ"].Value.ToString()); parms.Add(uRow.Cells["DELIVERY_NO"].Value.ToString()); parms.Add(strCodeBl); parms.Add("0"); //计划状态 parms.Add(CoreUserInfo.UserInfo.GetUserName()); parms.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); parms.Add(dtbllist.Rows[0]["STEELCODE"].ToString()); parms.Add(dtbllist.Rows[0]["STEELNAME"].ToString()); parms.Add("");//钢种代码 parms.Add(dtbllist.Rows[0]["MIN_D"].ToString());//外径 parms.Add(dtbllist.Rows[0]["MIN_H"].ToString());//壁厚 parms.Add("");//控制壁厚 parms.Add(dtbllist.Rows[0]["MAX_L"].ToString()); parms.Add(dtbllist.Rows[0]["MIN_L"].ToString()); parms.Add(aimlength.ToString());//控制长度 parms.Add(dtbllist.Rows[0]["STD_CODE"].ToString()); parms.Add(dtbllist.Rows[0]["STD_NAME"].ToString()); strPSC = QueryPsc(dtbllist.Rows[0]["PRODUCCODE"].ToString(), dtbllist.Rows[0]["STD_CODE"].ToString(), dtbllist.Rows[0]["STEELCODE"].ToString(), dtbllist.Rows[0]["STD_STYLE"].ToString()); parms.Add(QueryPscForMsc(strPSC)); parms.Add(singleweight.ToString()); //单重 #endregion if (planNum % eatchBlnum == 0) { parms.Add((int)(planNum / eatchBlnum) * singleweight);//备料需求量 parms.Add((int)(planNum / eatchBlnum));//备料需求支数 } else { parms.Add(((int)(planNum / eatchBlnum) + 1) * singleweight); parms.Add((int)(planNum / eatchBlnum) + 1); } parms.Add(specSameSale); paramBL.Add(parms); } else { WaitFromColse(); MessageUtil.ShowError("备料码：" + strCodeBl + "未找到基础信息，请查看备料码是否已作废。"); return; } } } //完成短节 listupdate.Add("1"); listupdate.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString()); paramUpdate.Add(listupdate); } else if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") < 0) { WaitFromColse(); MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "还未接收！"); return; } else { WaitFromColse(); MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已下发！"); return; } } int isSucceed = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.tranSactionDj", new object[] { paramBL, paramUpdate }, this.ob); WaitFromColse(); if (isSucceed > 0) { MessageUtil.ShowTips("短节处理成功！"); } else { MessageUtil.ShowError("短节处理失败！"); } } catch (Exception ex) { WaitFromColse(); if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } doQuery(GetQueryCondition()); } /// /// 撤消短节合同 /// private void doCancelDj() { try { ultraGrid1.UpdateData(); IQueryable checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHC = 'True'"); if (checkRows.Count() == 0) { MessageUtil.ShowTips("未勾选合同！"); return; } ArrayList list = new ArrayList(); WaitFromOpen(); foreach (UltraGridRow uRow in checkRows) { ArrayList status = new ArrayList(); status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString()); DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.querySaleStatus", new object[] { status }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { break; } if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1")) { ArrayList param = new ArrayList(); if (!dtStatus.Rows[0]["DJBL_REQ_IS_OK"].ToString().Equals("1")) { WaitFromColse(); Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "没有短节合同！"); return; } param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString()); list.Add(param); } else if(dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") < 0) { WaitFromColse(); MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "还未接收！"); return; } } if (list.Count == 0) { WaitFromColse(); return; } int succed = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.doCancelDj", new object[] { list }, this.ob); WaitFromColse(); if (succed > 0) { MessageUtil.ShowTips("撤消短节合同成功！"); } else { MessageUtil.ShowTips("撤消短节合同失败！"); } } catch (Exception ex) { WaitFromColse(); if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } doQuery(GetQueryCondition()); } /// /// 根据备料信息中备料码找冶金规范码 /// /// 备料码 /// 冶金规范码 private string BlForMsc(string blcode) { DataTable dtbllist = QueryBlList(blcode); if (dtbllist != null && dtbllist.Rows.Count > 0) { string strPSC = ""; strPSC = QueryPsc(dtbllist.Rows[0]["PRODUCCODE"].ToString(), dtbllist.Rows[0]["STD_CODE"].ToString(), dtbllist.Rows[0]["STEELCODE"].ToString(), dtbllist.Rows[0]["STD_STYLE"].ToString()); if (strPSC != "") { return QueryPscForMsc(strPSC); } else { return ""; } } return ""; } /// /// 新建接箍料需求信息 /// private void doPlait() { try { ArrayList list_Rel = new ArrayList(); ArrayList list_Jgl = new ArrayList(); ArrayList list = new ArrayList(); ArrayList ary = new ArrayList(); #region 筛选、记录备料码种类 foreach (UltraGridRow uRow in ultraGrid7.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text)) { if (uRow.Cells["JGBL_SUMLENTH"].Value.Equals("0") || uRow.Cells["JGBL_SUMLENTH"].Value.Equals("")) { MessageUtil.ShowTips("合同：" + uRow.Cells["JG_ORDERNO"].Value.ToString() + ",备料：" + uRow.Cells["CODE_JG_BL"].Value.ToString() + "的项未知备料需求量！"); return; } if (!ary.Contains(uRow.Cells["CODE_JG_BL"].Value.ToString())) { ary.Add(uRow.Cells["CODE_JG_BL"].Value.ToString()); } } } if (ary.Count == 0) { MessageUtil.ShowTips("未指定要新建的接箍料信息！"); return; } #endregion #region 保存信息接箍料需求信息和接箍与备料关系 for (int i = 0; i < ary.Count; i++) { string JglCode = ary[i].ToString(); //接箍备料码 DataTable dtbllist = QueryBlList(JglCode); if (dtbllist != null && dtbllist.Rows.Count > 0) { ArrayList parms_Jgl = new ArrayList(); double min_d = Convert.ToDouble(dtbllist.Rows[0]["MIN_D"]); //外径 double min_h = Convert.ToDouble(dtbllist.Rows[0]["MIN_H"]); //壁厚 double Weight_One = PlanComm.WeightOfMi(min_d, min_h); //接箍料米单重 string gradecode = "";//钢种代码 string steelcode = dtbllist.Rows[0]["STEELCODE"].ToString();//钢级代码 string steelname = dtbllist.Rows[0]["STEELNAME"].ToString();//钢级名称 double outdiameter = Convert.ToDouble(dtbllist.Rows[0]["MIN_D"]);//外径 double wallthick = Convert.ToDouble(dtbllist.Rows[0]["MIN_H"]);//壁厚 double aimwallthick = 0;//控制壁厚 double lengthmax = Convert.ToDouble(dtbllist.Rows[0]["MAX_L"]);//最大长度 double lengthmin = Convert.ToDouble(dtbllist.Rows[0]["MIN_L"]);//最小长度 double aimlength = (lengthmax + lengthmin) / 2;//控制长度 double singleweight = (aimlength * Weight_One);//备料单重 string std_code = dtbllist.Rows[0]["STD_CODE"].ToString();//标准代码 string std_name = dtbllist.Rows[0]["STD_NAME"].ToString();//标准名称 int jgbl_req_num = 0;//备料支数 double jgbl_req_weight = 0;//备料需求量 double jgbl_sumlenth = 0;//备料总长度 foreach (UltraGridRow uRow in ultraGrid7.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text) && uRow.Cells["CODE_JG_BL"].Value.ToString().Equals(JglCode)) { ArrayList parms_Rel = new ArrayList(); int Num_Jgl = 0; //单个合同接箍料需求支数 double Len_Jgl = Convert.ToDouble(uRow.Cells["JGBL_SUMLENTH"].Value);//单个合同接箍料长度 double Weihgt_Jgl = Len_Jgl * Weight_One;//单个合同接箍料需求量 if ((Len_Jgl % aimlength) == 0) { Num_Jgl = (int)(Len_Jgl / aimlength); } else { Num_Jgl = (int)(Len_Jgl / aimlength) + 1; } jgbl_sumlenth += Len_Jgl; #region 接箍及接箍料关系 parms_Rel.Add(uRow.Cells["JG_ORDERNO"].Value.ToString()); parms_Rel.Add(i.ToString()); parms_Rel.Add(uRow.Cells["CODE_JG"].Value.ToString()); parms_Rel.Add(uRow.Cells["OUTDIAMETER"].Value.ToString()); parms_Rel.Add(uRow.Cells["AIMLENGTH"].Value.ToString()); parms_Rel.Add(uRow.Cells["WALLTHICK"].Value.ToString()); parms_Rel.Add(steelcode); parms_Rel.Add(steelname); parms_Rel.Add(uRow.Cells["SINGLEWEIGHT_JG"].Value.ToString()); parms_Rel.Add(JglCode); parms_Rel.Add(aimlength.ToString()); parms_Rel.Add(singleweight.ToString()); parms_Rel.Add(Weihgt_Jgl.ToString()); parms_Rel.Add(Num_Jgl.ToString()); parms_Rel.Add(uRow.Cells["WEIGHT_JG"].Value.ToString()); parms_Rel.Add(uRow.Cells["NUM_JG"].Value.ToString()); parms_Rel.Add(uRow.Cells["SINGLE_ADDLEN"].Value.ToString()); parms_Rel.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName()); #endregion list_Rel.Add(parms_Rel); } } if ((jgbl_sumlenth % aimlength) == 0) { jgbl_req_num = (int)(jgbl_sumlenth / aimlength); } else { jgbl_req_num = (int)(jgbl_sumlenth / aimlength) + 1; } jgbl_req_weight = jgbl_sumlenth * Weight_One; #region 接箍料需求信息 parms_Jgl.Add(i.ToString()); parms_Jgl.Add("接箍料"); parms_Jgl.Add(steelcode); parms_Jgl.Add(steelname); parms_Jgl.Add(gradecode);//钢种代码 parms_Jgl.Add(outdiameter.ToString()); parms_Jgl.Add(wallthick.ToString()); parms_Jgl.Add(aimwallthick.ToString());//控制壁厚 parms_Jgl.Add(lengthmax.ToString()); parms_Jgl.Add(lengthmin.ToString()); parms_Jgl.Add(aimlength.ToString());//控制长度 parms_Jgl.Add(JglCode); parms_Jgl.Add(singleweight.ToString()); parms_Jgl.Add(jgbl_req_weight.ToString()); parms_Jgl.Add(jgbl_req_num.ToString()); parms_Jgl.Add("0"); parms_Jgl.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName()); parms_Jgl.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); parms_Jgl.Add(std_code); parms_Jgl.Add(std_name); parms_Jgl.Add(BlForMsc(JglCode)); #endregion list_Jgl.Add(parms_Jgl); } else { MessageUtil.ShowError("备料码：" + JglCode + "未找到基础信息，请查看备料码是否已作废。"); return; } } #endregion ///更新接箍合同已做备料需求个数 foreach (UltraGridRow uRow in ultraGrid7.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text)) { ArrayList parms = new ArrayList(); int jgwt_blreq = Convert.ToInt32(uRow.Cells["NUM_JG"].Value); parms.Add(jgwt_blreq.ToString()); parms.Add(uRow.Cells["JG_ORDERNO"].Value.ToString()); list.Add(parms); } } int succed = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.saveJglNeed", new object[] { list_Jgl, list_Rel, list }, this.ob); if (succed > 0) { MessageUtil.ShowTips("新建需求成功！"); } else { MessageUtil.ShowTips("新建需求失败！"); return; } } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } QueryJGl(); } /// /// 加入现有接箍料需求 /// private void doAddPlait() { try { string code_jg_bl = "";//备料码 string req_bl_id = "";//备料需求编号 double jgbl_req_weight = 0;//备料需求量 int jgbl_req_num = 0;//备料需求支数 ArrayList listUpdateRel = new ArrayList(); ArrayList list_Rel = new ArrayList(); ArrayList listupdate = new ArrayList(); ArrayList list = new ArrayList(); int count = 0; #region 筛选加入条件 foreach (UltraGridRow uRow in ultraGrid6.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text)) { count++; code_jg_bl = uRow.Cells["CODE_JG_BL"].Value.ToString(); req_bl_id = uRow.Cells["REQ_BL_ID"].Value.ToString(); } } if (count == 1) { bool isChecked = false; foreach (UltraGridRow uRow in ultraGrid7.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text)) { isChecked = true; if (code_jg_bl != uRow.Cells["CODE_JG_BL"].Value.ToString()) { MessageUtil.ShowError("所选择的条目备料码" + "与要加入的备料需求的备料码有不同，请重新选择！"); return; } } } ///如果没有勾选待处理的条目，提示。 if (!isChecked) { MessageUtil.ShowTips("未选择要加入现有需求的信息！"); return; } } else { if (count == 0) { MessageUtil.ShowTips("请选择一条现有的接箍料需求！"); return; } MessageUtil.ShowError("您选择了多条接箍料需求，" + "无法确定您需要将需求加入那条现有需求中！"); return; } #endregion #region 接箍备料对应关系信息 DataTable dtbllist = QueryBlList(code_jg_bl); if (dtbllist != null && dtbllist.Rows.Count > 0) { double outdiameter = Convert.ToDouble(dtbllist.Rows[0]["MIN_D"]);//外径 double wallthick = Convert.ToDouble(dtbllist.Rows[0]["MIN_H"]);//壁厚 double Weight_One = PlanComm.WeightOfMi(outdiameter, wallthick); //接箍料米单重 string steelcode = dtbllist.Rows[0]["STEELCODE"].ToString();//钢级代码 string steelname = dtbllist.Rows[0]["STEELNAME"].ToString();//钢级名称 double lengthmax = Convert.ToDouble(dtbllist.Rows[0]["MAX_L"]);//最大长度 double lengthmin = Convert.ToDouble(dtbllist.Rows[0]["MIN_L"]);//最小长度 double aimlength = (lengthmax + lengthmin) / 2;//控制长度 double singleweight = (aimlength * Weight_One);//备料单重 string std_code = dtbllist.Rows[0]["STD_CODE"].ToString();//标准代码 string std_name = dtbllist.Rows[0]["STD_NAME"].ToString();//标准名称 double jgbl_sumlenth = 0;//备料总长度 foreach (UltraGridRow uRow in ultraGrid7.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text)) { if (uRow.Cells["JGBL_SUMLENTH"].Value.Equals("0") || uRow.Cells["JGBL_SUMLENTH"].Value.Equals("")) { Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同：" + uRow.Cells["JG_ORDERNO"].Value.ToString() + ",备料：" + uRow.Cells["CODE_JG_BL"].Value.ToString() + "的项未知备料需求量！"); return; } bool bl = false; int Num_Jgl = 0; //单个合同接箍料需求支数 double Len_Jgl = Convert.ToDouble(uRow.Cells["JGBL_SUMLENTH"].Value);//单个合同接箍料长度 double Weihgt_Jgl = Len_Jgl * Weight_One;//单个合同接箍料需求量 if ((Len_Jgl % aimlength) == 0) { Num_Jgl = (int)(Len_Jgl / aimlength); } else { Num_Jgl = (int)(Len_Jgl / aimlength) + 1; } jgbl_sumlenth += Len_Jgl; DataTable dtRel = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryRelation", new object[] { req_bl_id }, this.ob); foreach (DataRow dr in dtRel.Rows) { if (uRow.Cells["JG_ORDERNO"].Value.ToString().Equals( dr["JG_ORDERNO"].ToString())) { #region 有相同对应关系的情况，更新对应关系的需求量 bl = true; ArrayList parms = new ArrayList(); parms.Add(Weihgt_Jgl.ToString()); parms.Add(Num_Jgl.ToString()); parms.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName()); parms.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); parms.Add(req_bl_id); parms.Add(uRow.Cells["JG_ORDERNO"].Value.ToString()); listUpdateRel.Add(parms); #endregion } } if (bl == false) { #region 没有相同对应关系的情况，新增一条对应关系 ArrayList parms_Rel = new ArrayList(); parms_Rel.Add(uRow.Cells["JG_ORDERNO"].Value.ToString()); parms_Rel.Add(req_bl_id); parms_Rel.Add(uRow.Cells["CODE_JG"].Value.ToString()); parms_Rel.Add(uRow.Cells["OUTDIAMETER"].Value.ToString()); parms_Rel.Add(uRow.Cells["AIMLENGTH"].Value.ToString()); parms_Rel.Add(uRow.Cells["WALLTHICK"].Value.ToString()); parms_Rel.Add(steelcode); parms_Rel.Add(steelname); parms_Rel.Add(uRow.Cells["SINGLEWEIGHT_JG"].Value.ToString()); parms_Rel.Add(code_jg_bl); parms_Rel.Add(aimlength.ToString()); parms_Rel.Add(singleweight.ToString()); parms_Rel.Add(Weihgt_Jgl.ToString()); parms_Rel.Add(Num_Jgl.ToString()); parms_Rel.Add(uRow.Cells["WEIGHT_JG"].Value.ToString()); parms_Rel.Add(uRow.Cells["NUM_JG"].Value.ToString()); parms_Rel.Add(uRow.Cells["SINGLE_ADDLEN"].Value.ToString()); parms_Rel.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName()); list_Rel.Add(parms_Rel); #endregion } } } //计算备料总量 if ((jgbl_sumlenth % aimlength) == 0) { jgbl_req_num = (int)(jgbl_sumlenth / aimlength); } else { jgbl_req_num = (int)(jgbl_sumlenth / aimlength) + 1; } jgbl_req_weight = jgbl_sumlenth * Weight_One; } else { MessageUtil.ShowError("备料码：" + code_jg_bl + "未找到基础信息，请查看备料码是否已作废。"); return; } #endregion list.Add(jgbl_req_weight.ToString()); list.Add(jgbl_req_num.ToString()); list.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName()); list.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); list.Add(req_bl_id); ///更新接箍合同已做备料需求量 foreach (UltraGridRow uRow in ultraGrid7.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text)) { ArrayList parms = new ArrayList(); int jgwt_blreq = Convert.ToInt32(uRow.Cells["NUM_JG"].Value); parms.Add(jgwt_blreq); parms.Add(uRow.Cells["JG_ORDERNO"].Value.ToString()); listupdate.Add(parms); } } ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.updateJglNeed", new object[] { list, listUpdateRel, list_Rel, listupdate }, this.ob); } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } QueryJGl(); } /// /// 删除接箍料需求 /// private void Delete() { try { ArrayList listJg = new ArrayList(); ArrayList listRel = new ArrayList(); ArrayList list = new ArrayList(); bool bl = false; foreach (UltraGridRow uRow in ultraGrid6.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text) && uRow.Cells["BLTYPE"].Value.ToString() == "接箍料") { ArrayList parms = new ArrayList(); bl = true; parms.Add(uRow.Cells["REQ_BL_ID"].Value.ToString()); listJg.Add(parms); DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryRelation", new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob); foreach (DataRow dr in dt.Rows) { ArrayList paramrel = new ArrayList(); ArrayList parmUpadte = new ArrayList(); paramrel.Add(dr["JG_ORDERNO"].ToString()); paramrel.Add(dr["REQ_BL_ID"].ToString()); listRel.Add(paramrel); ///更新接箍合同已做备料需求个数 parmUpadte.Add("-" + dr["NUM_JG"].ToString()); parmUpadte.Add(dr["JG_ORDERNO"].ToString()); list.Add(parmUpadte); } } } if (bl) { if (MessageBox.Show("是否要删除该备料需求？", "警告", MessageBoxButtons.OKCancel) != DialogResult.OK) { return; } ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.deleteBlNeed", new object[] { listRel, listJg, list }, this.ob); } else { Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("请选择要删除的接箍料需求！"); return; } } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } QueryJGl(); } /// /// 删除接箍料需求单量 /// private void DeleteOne() { try { ArrayList list_Rel = new ArrayList(); ArrayList list_Jgl = new ArrayList(); ArrayList list = new ArrayList(); ArrayList ary = new ArrayList(); foreach (UltraGridRow uRow in ultraGrid4.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text) && !ary.Contains(uRow.Cells["REQ_BL_ID"].Value.ToString())) { ary.Add(uRow.Cells["REQ_BL_ID"].Value.ToString()); } } if (ary.Count > 0) { #region 删除接箍料与接箍对应关系信息，和接箍料需求量减少信息 for (int i = 0; i < ary.Count; i++) { double jgbl_req_weight = 0; int jgbl_req_num = 0; ArrayList parms_Jgl = new ArrayList(); foreach (UltraGridRow uRow in ultraGrid4.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text) && uRow.Cells["REQ_BL_ID"].Value.ToString().Equals(ary[i].ToString())) { ArrayList parms_Rel = new ArrayList(); ArrayList parmUpadte = new ArrayList(); jgbl_req_weight += Convert.ToDouble(uRow.Cells["JGBL_REQ_WEIGHT"].Value); jgbl_req_num += Convert.ToInt32(uRow.Cells["JGBL_REQ_NUM"].Value); parms_Rel.Add(uRow.Cells["JG_ORDERNO"].Value.ToString()); parms_Rel.Add(uRow.Cells["REQ_BL_ID"].Value.ToString()); list_Rel.Add(parms_Rel); ///更新接箍合同已做备料需求个数 parmUpadte.Add("-" + uRow.Cells["NUM_JG"].Value.ToString()); parmUpadte.Add(uRow.Cells["JG_ORDERNO"].Value.ToString()); list.Add(parmUpadte); } } foreach (UltraGridRow uRow in ultraGrid6.Rows) { if (uRow.Cells["REQ_BL_ID"].Value.ToString().Equals(ary[i].ToString())) { jgbl_req_weight = - jgbl_req_weight; jgbl_req_num = - jgbl_req_num; } } parms_Jgl.Add(jgbl_req_weight); parms_Jgl.Add(jgbl_req_num); parms_Jgl.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName()); parms_Jgl.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); parms_Jgl.Add(ary[i].ToString()); list_Jgl.Add(parms_Jgl); } #endregion if (MessageBox.Show("是否要删除这些备料需求量？", "警告", MessageBoxButtons.OKCancel) == DialogResult.OK) { ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.deleteJglOne", new object[] { list_Rel, list_Jgl, list }, this.ob); } } else { MessageUtil.ShowTips("请至少选择一条接箍料需求单量！"); return; } } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } QueryJGl(); } /// /// 查询接箍基础表 /// /// 接箍码 private DataTable QueryJgBase(string strCodeJg) { try { DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryJgBase", new object[] { strCodeJg }, this.ob); return dt; } catch { return null; } } /// /// 查询备料清单表 /// /// 备料码 public DataTable QueryBlList(string strCodeJg) { try { DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBlList", new object[] { strCodeJg }, this.ob); return dt; } catch { return null; } } /// /// 接箍合同下发 /// private void OrderJgIssued() { try { bool isChecked = false; ArrayList list = new ArrayList(); foreach (UltraGridRow uRow in ultraGrid2.Rows) { if (Convert.ToBoolean(uRow.Cells["CHC"].Text)) { ArrayList parms = new ArrayList(); DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryJgbyOrderno", new object[] { uRow.Cells["JG_ORDERNO"].Value.ToString() }, this.ob); if (dt == null && dt.Rows.Count <= 0) { break; } isChecked = true; if (dt.Rows[0]["JGORDERSTATUS"].ToString().Equals("1")) { parms.Add("2"); parms.Add(DateTime.Now.ToString("yyyy/MM/dd")); parms.Add(uRow.Cells["JG_ORDERNO"].Value.ToString()); list.Add(parms); } else if (dt.Rows[0]["JGORDERSTATUS"].ToString().CompareTo("1") < 0) { MessageUtil.ShowTips("接箍合同" + uRow.Cells["JG_ORDERNO"].Value.ToString() + "未完成配料！"); return; } else { MessageUtil.ShowTips("接箍合同" + uRow.Cells["JG_ORDERNO"].Value.ToString() + "已经下发过了！"); return; } } } if (isChecked) { int result = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.issuedJgOrder", new object[] { list }, this.ob); if (Convert.ToBoolean(result)) { MessageUtil.ShowTips("下发成功！"); } } else { MessageUtil.ShowTips("请勾选您要下发的接箍合同！"); return; } } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } doQuery(GetQueryCondition()); } /// /// 接箍合同取消下发 /// private void CancelJgIssued() { try { ultraGrid2.UpdateData(); ArrayList list = new ArrayList(); IQueryable checkedRows = ultraGrid2.Rows.AsQueryable().Where("CHC = 'True'"); if (checkedRows.Count() == 0) { MessageUtil.ShowTips("未勾选要取消下发的接箍合同！"); return; } foreach (UltraGridRow uRow in checkedRows) { ArrayList param = new ArrayList(); DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryJgbyOrderno", new object[] { uRow.Cells["JG_ORDERNO"].Value.ToString() }, this.ob); if (dt == null && dt.Rows.Count <= 0) { break; } if (dt.Rows[0]["JGORDERSTATUS"].ToString().CompareTo("2") < 0) { MessageUtil.ShowTips("接箍合同" + uRow.Cells["JG_ORDERNO"].Value.ToString() + "还未下发！"); return; } param.Add(uRow.Cells["JG_ORDERNO"].Value.ToString()); list.Add(param); } int succed = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.cancelJgIssued", new object[] { list }, this.ob); if (succed > 0) { MessageUtil.ShowTips("取消下发成功！"); } else { MessageUtil.ShowTips("取消下发失败！"); } } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } doQuery(GetQueryCondition()); } /// /// 备料取消下发 /// private void CancelBlIssued(UltraGrid ugrid) { try { ugrid.UpdateData(); ArrayList list = new ArrayList(); IQueryable checkedRows = ugrid.Rows.AsQueryable().Where("CHC = 'True'"); if (checkedRows.Count() == 0) { MessageUtil.ShowTips("未勾选要取消下发的备料！"); return; } foreach (UltraGridRow uRow in checkedRows) { ArrayList param = new ArrayList(); DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBLbyReqBlId", new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { break; } if (dtStatus.Rows[0]["PLANSTATUS"].ToString().CompareTo("1") < 0) { MessageUtil.ShowTips("备料" + uRow.Cells["REQ_BL_ID"].Value.ToString() + "未下发，不能取消下发！"); return; } param.Add(uRow.Cells["REQ_BL_ID"].Value.ToString()); list.Add(param); } int succed = ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.cancelBlIssued", new object[] { list }, this.ob); if (succed > 0) { MessageUtil.ShowTips("取消下发成功！"); } else { MessageUtil.ShowTips("取消下发失败！"); } } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } if (ugrid != ultraGrid3) { QueryJGl(); } else { doQuery(GetQueryCondition()); } } /// /// 备料需求下发 /// private void IssuedBlNeed(UltraGrid ugrid) { try { ugrid.UpdateData(); ArrayList list = new ArrayList(); IQueryable checkedRows = ugrid.Rows.AsQueryable().Where("CHC = 'True'"); if (checkedRows.Count() == 0) { MessageUtil.ShowTips("未勾选要下发的备料！"); return; } foreach (UltraGridRow uRow in checkedRows) { DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryBLbyReqBlId", new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob); if (dtStatus == null || dtStatus.Rows.Count <= 0) { break; } if (dtStatus.Rows[0]["PLANSTATUS"].ToString().CompareTo("0") > 0) { MessageUtil.ShowTips("备料" + uRow.Cells["REQ_BL_ID"].Value.ToString() + "已经下发过了！"); return; } #region 判断是否可以下发 if (uRow.Cells["JGBL_REQ_WEIGHT"].Value.ToString().Equals("0")) { Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("短节备料" + uRow.Cells["REQ_BL_ID"].Value.ToString() + "需求量未知！"); return; } if (!dtStatus.Rows[0]["IF_ALLOW_ISSUE"].ToString().Equals("1")) { MessageUtil.ShowTips("需求" + uRow.Cells["REQ_BL_ID"].Value.ToString() + "还不可以下发！"); return; } #endregion ArrayList parms = new ArrayList(); parms.Add(uRow.Cells["REQ_BL_ID"].Value.ToString()); list.Add(parms); } if (!Convert.ToBoolean(ServerHelper.SetData("com.steering.pss.plan.order." + "CorePlnOrderJgDj.issuedJglNeed", new object[] { list }, this.ob))) { MessageUtil.ShowTips("下发失败！"); return; } MessageUtil.ShowTips("下发成功！"); } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } if (ugrid != ultraGrid3) { QueryJGl(); } else { doQuery(GetQueryCondition()); } } /// /// 备料列数据变化时变化 /// /// /// private void ultraGrid3_AfterCellUpdate(object sender, CellEventArgs e) { #region 短节备料需求量、利库量填写时计算 if (e.Cell.Column.Key == "JGBL_REQ_WEIGHT" && e.Cell.Row.Cells["JGBL_REQ_WEIGHT"].DataChanged) { double jgbl_req_weight = 0; int jgbl_req_num = 0; e.Cell.Row.Update(); if (double.TryParse(e.Cell.Row.Cells["JGBL_REQ_WEIGHT"].Value.ToString(), out jgbl_req_weight)) { double singleweight = Convert.ToDouble(e.Cell.Row.Cells["SINGLEWEIGHT"].Value); if ((jgbl_req_weight % singleweight) == 0) { jgbl_req_num = (int)(jgbl_req_weight / singleweight); } else { jgbl_req_num = (int)(jgbl_req_weight / singleweight) + 1; } } else { e.Cell.Row.Cells["JGBL_REQ_WEIGHT"].Value = "0"; } e.Cell.Row.Cells["JGBL_REQ_NUM"].Value = jgbl_req_num.ToString(); e.Cell.Row.Update(); } if (e.Cell.Column.Key == "MATCHWEIGHT" && e.Cell.Row.Cells["MATCHWEIGHT"].DataChanged) { double jgbl_req_weight = 0; int jgbl_req_num = 0; e.Cell.Row.Update(); if (double.TryParse(e.Cell.Row.Cells["MATCHWEIGHT"].Value.ToString(), out jgbl_req_weight)) { double singleweight = Convert.ToDouble(e.Cell.Row.Cells["SINGLEWEIGHT"].Value); if ((jgbl_req_weight % singleweight) == 0) { jgbl_req_num = (int)(jgbl_req_weight / singleweight); } else { jgbl_req_num = (int)(jgbl_req_weight / singleweight) + 1; } } else { e.Cell.Row.Cells["MATCHWEIGHT"].Value = "0"; } e.Cell.Row.Cells["MATCHNUM"].Value = jgbl_req_num.ToString(); e.Cell.Row.Update(); } #endregion } /// /// 接箍合同填写利库量 /// /// /// private void ultraGrid5_AfterCellUpdate(object sender, CellEventArgs e) { if (e.Cell.Column.Key == "MATCHNUM" && e.Cell.Row.Cells["MATCHNUM"].DataChanged) { int matchnum = 0; double singleweight = Convert.ToDouble(e.Cell.Row.Cells["SINGLEWEIGHT"].Value);//箍单重(kg) if (int.TryParse(e.Cell.Row.Cells["MATCHNUM"].Value.ToString(), out matchnum)) { e.Cell.Row.Cells["MATCHWEIGHT"].Value = (matchnum * singleweight / 1000).ToString(); } else { e.Cell.Row.Cells["MATCHNUM"].Value = "0"; } e.Cell.Row.Update(); } } /// /// 输入要做备料需求的接箍个数 /// /// /// private void ultraGrid7_AfterCellUpdate(object sender, CellEventArgs e) { if (e.Cell.Column.Key == "NUM_JG") { if (e.Cell.Row.Cells["NUM_JG"].DataChanged && Convert.ToBoolean(e.Cell.Row.Cells["CHC"].Text)) { computJglLen(e.Cell.Row); e.Cell.Row.Update(); } } if (e.Cell.Column.Key.Equals("SINGLE_ADDLEN")) { double addlen = 0; if (!double.TryParse(e.Cell.Row.Cells["SINGLE_ADDLEN"].Value.ToString(),out addlen)) { e.Cell.Row.Cells["SINGLE_ADDLEN"].Value=0; } } } /// /// 根据接箍个数，算接箍料长度，重量 /// /// private void computJglLen(UltraGridRow uRow) { int Num_Jg = 0; if (int.TryParse(uRow.Cells["NUM_JG"].Value.ToString(), out Num_Jg)) { //接箍料长度=接箍个数*（接箍长度+单个接箍切损长度） double jgbl_sumlenth = Num_Jg * (Convert.ToDouble(uRow.Cells["AIMLENGTH"].Value) + Convert.ToDouble(uRow.Cells["SINGLE_ADDLEN"].Value)) / 1000; double singleweight_jg = Convert.ToDouble(uRow.Cells["SINGLEWEIGHT_JG"].Value);//接箍单重(kg) //接箍料目标长度取长度上下限中间值 double JglAimlenth = (Convert.ToDouble(uRow.Cells["MIN_L"].Value) + Convert.ToDouble(uRow.Cells["MAX_L"].Value)) / 2; int numJgl = 0; //接箍料支数 double weight_jg = singleweight_jg * Num_Jg / 1000;//接箍重量 double min_d = Convert.ToDouble(uRow.Cells["MIN_D"].Value); //备料外径 double min_h = Convert.ToDouble(uRow.Cells["MIN_H"].Value); //备料壁厚 double Weight_One = PlanComm.WeightOfMi(min_d, min_h); //接箍料米单重 if ((jgbl_sumlenth % JglAimlenth) == 0) { numJgl = (int)(jgbl_sumlenth / JglAimlenth); } else { numJgl = (int)(jgbl_sumlenth / JglAimlenth) + 1; } uRow.Cells["NUM_JGBL"].Value = numJgl; uRow.Cells["JGBL_SUMLENTH"].Value = Math.Round(jgbl_sumlenth,2); uRow.Cells["WEIGHT_JG"].Value = Math.Round(weight_jg,3); uRow.Cells["JGBL_REQ_WEIGHT"].Value = Math.Round(Weight_One * jgbl_sumlenth,3); } else { uRow.Cells["NUM_JG"].Value = 0; } } /// /// 选择接箍合同备料 /// /// /// private void ultraGrid7_CellChange(object sender, CellEventArgs e) { if (e.Cell.Column.Key == "CHC") { setJgleditNum(e.Cell.Row); } } /// /// 接箍料编辑表勾选时的操作 /// /// 勾选行 private void setJgleditNum(UltraGridRow cRow) { if (Convert.ToBoolean(cRow.Cells["CHC"].Text)) { ultraGrid7.UpdateData(); IQueryable listRow = ultraGrid7.Rows.AsQueryable().Where(" CHC = 'True'"); listRow = listRow.Where(" JG_ORDERNO = '" + cRow.Cells["JG_ORDERNO"].Value.ToString() + "'"); listRow = listRow.Where(" CODE_JG_BL != '" + cRow.Cells["CODE_JG_BL"].Value.ToString() + "'"); foreach (UltraGridRow uRow in listRow.ToArray()) { uRow.Cells["CHC"].Value = false; uRow.Cells["NUM_JG"].Activation = Activation.ActivateOnly; uRow.Cells["NUM_JG"].Value = ""; uRow.Cells["WEIGHT_JG"].Value = ""; uRow.Cells["NUM_JGBL"].Value = ""; uRow.Cells["JGBL_SUMLENTH"].Value = ""; uRow.Cells["JGBL_REQ_WEIGHT"].Value = ""; } ultraGrid5.UpdateData(); listRow = ultraGrid5.Rows.AsQueryable().Where(" JG_ORDERNO = '" + cRow.Cells["JG_ORDERNO"].Value.ToString() + "'"); foreach (UltraGridRow uRow in listRow.ToArray()) { int num_jg = Convert.ToInt32(uRow.Cells["ORDERNUM"].Value) - Convert.ToInt32(uRow.Cells["MATCHNUM"].Value) - Convert.ToInt32(uRow.Cells["JGWT_BLREQ"].Value); cRow.Cells["NUM_JG"].Value = num_jg; break; } cRow.Cells["NUM_JG"].Activation = Activation.AllowEdit; cRow.Update(); } if (!Convert.ToBoolean(cRow.Cells["CHC"].Text)) { cRow.Cells["NUM_JG"].Activation = Activation.ActivateOnly; cRow.Cells["NUM_JG"].Value = ""; cRow.Cells["WEIGHT_JG"].Value = ""; cRow.Cells["NUM_JGBL"].Value = ""; cRow.Cells["JGBL_SUMLENTH"].Value = ""; cRow.Cells["JGBL_REQ_WEIGHT"].Value = ""; cRow.Update(); } ultraGrid7.UpdateData(); ultraGrid5.UpdateData(); } private void FrmSaleOrderOP_Shown(object sender, EventArgs e) { setTab2Appearance(DefaultableBoolean.False); } private void ultraGrid7_BeforeRowActivate(object sender, RowEventArgs e) { foreach (UltraGridRow uRow in ultraGrid7.Rows) { uRow.Appearance.BackColor = System.Drawing.Color.White; } foreach (UltraGridRow uRow in ultraGrid7.Rows) { if (uRow.Cells["CODE_JG_BL"].Value.Equals(e.Row.Cells["CODE_JG_BL"].Value)) { uRow.Appearance.BackColor = System.Drawing.Color.PaleGreen; } } } /// /// 选择tab页面时，菜单变化 /// /// /// private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (toolMenu != null) { if (e.Tab.TabPage == ultraTabPageOrder) { setTab1Appearance(DefaultableBoolean.True); setTab2Appearance(DefaultableBoolean.False); if (toolMenu.Toolbars[0].Tools.Exists("RefresDate")) { toolMenu.Toolbars[0].Tools["RefresDate"].InstanceProps.Visible = DefaultableBoolean.True; } } if (e.Tab.TabPage == ultraTabPageJgdeal) { setTab1Appearance(DefaultableBoolean.False); setTab2Appearance(DefaultableBoolean.True); if (toolMenu.Toolbars[0].Tools.Exists("RefresDate")) { toolMenu.Toolbars[0].Tools["RefresDate"].InstanceProps.Visible = DefaultableBoolean.True; } } } } 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("ProcessJG")) { toolMenu.Toolbars[0].Tools["ProcessJG"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("CancelJg")) { toolMenu.Toolbars[0].Tools["CancelJg"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("ProcessDj")) { toolMenu.Toolbars[0].Tools["ProcessDj"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("CancelDj")) { toolMenu.Toolbars[0].Tools["CancelDj"].InstanceProps.Visible = appearance; } #endregion } private void setTab2Appearance(DefaultableBoolean appearance) { #region tab2显示或隐藏 if (toolMenu.Toolbars[0].Tools.Exists("QueryJgl")) { toolMenu.Toolbars[0].Tools["QueryJgl"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("SaveJg")) { toolMenu.Toolbars[0].Tools["SaveJg"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("Plait")) { toolMenu.Toolbars[0].Tools["Plait"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("AddPlait")) { toolMenu.Toolbars[0].Tools["AddPlait"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = appearance; } if (toolMenu.Toolbars[0].Tools.Exists("DeleteOne")) { toolMenu.Toolbars[0].Tools["DeleteOne"].InstanceProps.Visible = appearance; } #endregion } private void checkBoxForReqORDER_NO_CheckedChanged(object sender, EventArgs e) { if (checkBoxForReqORDER_NO.Checked) { ctrlForQueryORDER_NO.Enabled = true; } else { ctrlForQueryORDER_NO.Enabled = false; } } private void checkBoxForReqPORDERSTATUS_CheckedChanged(object sender, EventArgs e) { if (checkBoxForReqPORDERSTATUS.Checked) { ctrlForQueryPORDERSTATUS.Enabled = true; } else { ctrlForQueryPORDERSTATUS.Enabled = false; } } /// /// 选择备料组 /// /// /// private void ultraGrid1_ClickCellButton(object sender, CellEventArgs e) { if (e.Cell.Column.Key.Equals("BL_GROUP_NUM") && (e.Cell.Row.Cells["PORDERSTATUS"].Value.ToString().Equals("待接收") || e.Cell.Row.Cells["PORDERSTATUS"].Value.ToString().Equals("已接收"))) { //选择短节备料组 FrmGroupofDjBl ChooseGroup = new FrmGroupofDjBl(this.ob); int orderNum = 0; int.TryParse(e.Cell.Row.Cells["PLAN_NUM"].Value.ToString(), out orderNum); ChooseGroup.Desgin_key = e.Cell.Row.Cells["DESGIN_KEY"].Value.ToString(); ChooseGroup.Group_num = e.Cell.Row.Cells["BL_GROUP_NUM"].Value.ToString(); ChooseGroup.Plan_num = e.Cell.Row.Cells["PLAN_NUM"].Value.ToString(); ChooseGroup.Order_no = e.Cell.Row.Cells["ORDER_NO"].Value.ToString(); ChooseGroup.Order_seq = e.Cell.Row.Cells["ORDER_SEQ"].Value.ToString(); ChooseGroup.Delivery_no = e.Cell.Row.Cells["DELIVERY_NO"].Value.ToString(); ChooseGroup.Lengthdisc = e.Cell.Row.Cells["LENGTHDISC"].Value.ToString(); ChooseGroup.LengthMax = Convert.ToDouble(e.Cell.Row.Cells["LENGTHMAX"].Value); ChooseGroup.OrderNum = orderNum; ChooseGroup.Outdiameter = e.Cell.Row.Cells["OUTDIAMETER"].Value.ToString(); ChooseGroup.Wallthick = e.Cell.Row.Cells["WALLTHICK"].Value.ToString(); ChooseGroup.Steelcode = e.Cell.Row.Cells["STEELCODE"].Value.ToString(); ChooseGroup.Steelname = e.Cell.Row.Cells["STEELNAME"].Value.ToString(); ChooseGroup.ShowDialog(); //判断是否需要更新合同备料组 if (!e.Cell.Row.Cells["BL_GROUP_NUM"].Value.ToString().Equals(ChooseGroup.Group_num)) { try { ArrayList parms = new ArrayList(); e.Cell.Row.Cells["BL_GROUP_NUM"].Value = ChooseGroup.Group_num; parms.Add(e.Cell.Row.Cells["BL_GROUP_NUM"].Value.ToString()); parms.Add(e.Cell.Row.Cells["ORD_PK"].Value.ToString()); parms.Add(e.Cell.Row.Cells["ORD_LN_PK"].Value.ToString()); parms.Add(e.Cell.Row.Cells["ORD_LN_DLY_PK"].Value.ToString()); ServerHelper.SetData("com.steering.pss.plan.order.CorePlnOrderJgDj.updateDjBlGroup", new object[] { parms }, this.ob); } catch (Exception ex) { if (ex is MESException) { } else { MessageBox.Show(ex.Message); } } } if (ChooseGroup.IsCreatOk) { doQuery(GetQueryCondition()); } } } private void checkBoxAcceptNo_CheckedChanged(object sender, EventArgs e) { if (checkBoxAcceptNo.Checked) { ultraTextEditorAcceptNo.Enabled = true; } else { ultraTextEditorAcceptNo.Enabled = false; } } private void ultraGrid7_DoubleClickRow(object sender, DoubleClickRowEventArgs e) { ultraGrid5.UpdateData(); ultraGrid7.UpdateData(); IQueryable listRow = ultraGrid7.Rows.AsQueryable().Where(" CODE_JG_BL = '" + e.Row.Cells["CODE_JG_BL"].Value.ToString() + "'"); foreach (UltraGridRow uRow in listRow.ToArray()) { uRow.Cells["CHC"].Value = true; IQueryable rows = ultraGrid5.Rows.AsQueryable().Where(" JG_ORDERNO = '" + uRow.Cells["JG_ORDERNO"].Value.ToString() + "'"); uRow.Cells["NUM_JG"].Activation = Activation.AllowEdit; foreach (UltraGridRow cRow in rows) { int num_jg = Convert.ToInt32(cRow.Cells["ORDERNUM"].Value) - Convert.ToInt32(cRow.Cells["MATCHNUM"].Value) - Convert.ToInt32(cRow.Cells["JGWT_BLREQ"].Value); uRow.Cells["NUM_JG"].Value = num_jg; break; } } listRow = ultraGrid7.Rows.AsQueryable().Where(" CODE_JG_BL != '" + e.Row.Cells["CODE_JG_BL"].Value.ToString() + "'"); foreach (UltraGridRow uRow in listRow.ToArray()) { uRow.Cells["CHC"].Value = false; uRow.Cells["NUM_JG"].Activation = Activation.ActivateOnly; uRow.Cells["NUM_JG"].Value = ""; uRow.Cells["WEIGHT_JG"].Value = ""; uRow.Cells["NUM_JGBL"].Value = ""; uRow.Cells["JGBL_SUMLENTH"].Value = ""; uRow.Cells["JGBL_REQ_WEIGHT"].Value = ""; } ultraGrid5.UpdateData(); ultraGrid7.UpdateData(); } private void splitContainer1_SplitterMoved(object sender, SplitterEventArgs e) { if (_groupBox2ExpandedChanged == false) { _splitterDistance = splitContainer1.SplitterDistance; if (splitContainer1.SplitterDistance >= 1) { ultraExpandableGroupBox2.Expanded = true; } } if (splitContainer1.Panel2Collapsed) { ultraExpandableGroupBox2.Visible = false; } } private void ultraExpandableGroupBox2_ExpandedStateChanged(object sender, EventArgs e) { _groupBox2ExpandedChanged = true; if (ultraExpandableGroupBox2.Expanded == false) { splitContainer1.SplitterDistance = this.Width; } else { splitContainer1.SplitterDistance = _splitterDistance; } _groupBox2ExpandedChanged = false; } private void ultraGrid1_CellDataError(object sender, CellDataErrorEventArgs e) { e.RaiseErrorEvent = false; } private void ultraGrid5_AfterRowActivate(object sender, EventArgs e) { UltraGridRow ugr = ultraGrid5.ActiveRow; if (ugr == null) { return; } foreach (UltraGridRow uRow in ultraGrid7.Rows) { if (uRow.Cells["JG_ORDERNO"].Value.ToString().Equals( ugr.Cells["JG_ORDERNO"].Value.ToString())) { ultraGrid7.ActiveRow = uRow; uRow.Appearance.ForeColor = System.Drawing.Color.DarkBlue; } else { uRow.Appearance.ForeColor = System.Drawing.Color.Black; } } } private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { try { for (int i = 0; i < ultraGrid1.Selected.Rows.Count; i++) { if (ultraGrid1.Selected.Rows[i].GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { ultraGrid1.Selected.Rows[i].Cells["CHC"].Value = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "出错"); } } private void ultraGrid7_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGrid7.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHC"].Value = true; setJgleditNum(uRow); } } } private void ultraGrid6_CellChange(object sender, CellEventArgs e) { if (e.Cell.Column.Key.Equals("BJ_TYPE")) { if (e.Cell.Row.Cells["BJ_TYPE"].Value.ToString().Equals("") || e.Cell.Row.Cells["BJ_TYPE"].Value.ToString().Equals("/")) { e.Cell.Row.Cells["DIMATER_YLG"].Value = ""; e.Cell.Row.Cells["DIMATER_YLG"].ValueList = null; e.Cell.Row.Cells["HEIGHT_YLG"].Value = ""; e.Cell.Row.Cells["HEIGHT_YLG"].ValueList = null; } else { ArrayList param = new ArrayList(); param.Add(e.Cell.Row.Cells["BJ_TYPE"].Value.ToString()); param.Add(e.Cell.Row.Cells["OUTDIAMETER"].Value.ToString()); param.Add(e.Cell.Row.Cells["WALLTHICK"].Value.ToString()); DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryRollRupset", new object[] { param }, this.ob); e.Cell.Row.Cells["DIMATER_YLG"].ValueList = PlanComm.GeneralValuelist(ref dt, "MIN_D", "MIN_D"); e.Cell.Row.Cells["HEIGHT_YLG"].ValueList = PlanComm.GeneralValuelist(ref dt, "MIN_H", "MIN_H"); if (dt != null && dt.Rows.Count > 0) { if (e.Cell.Row.Cells["DIMATER_YLG"].Value.ToString().Equals("")) { e.Cell.Row.Cells["DIMATER_YLG"].Value = dt.Rows[0]["MIN_D"].ToString(); } if (e.Cell.Row.Cells["HEIGHT_YLG"].Value.ToString().Equals("")) { e.Cell.Row.Cells["HEIGHT_YLG"].Value = dt.Rows[0]["MIN_H"].ToString(); } } } } } private void ultraGrid6_AfterRowActivate(object sender, EventArgs e) { UltraGridRow ugr = ultraGrid6.ActiveRow; if (ugr == null) { return; } DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryRelation", new object[] { ugr.Cells["REQ_BL_ID"].Value.ToString() }, this.ob); GridHelper.CopyDataToDatatable(dt, dataTable4, true); } private void ultraGrid3_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGrid3.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHC"].Value = true; } } } private void ultraGrid2_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGrid2.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHC"].Value = true; } } } private void ultraGrid6_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGrid6.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHC"].Value = true; } } } private void ultraGrid5_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGrid5.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHC"].Value = true; } } } private void checkBoxRollMonth_CheckedChanged(object sender, EventArgs e) { if (checkBoxRollMonth.Checked == false) { ultraDateTimeRollMonth.Enabled = false; } else { ultraDateTimeRollMonth.Enabled = true; } } /// /// 等待窗口 /// private void WaitFromOpen() { this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待 if (Constant.WaitingForm == null) { Constant.WaitingForm = new WaitingForm(); } Constant.WaitingForm.ShowToUser = true; Constant.WaitingForm.Show(); Constant.WaitingForm.Update(); } /// /// 关闭等待 /// private void WaitFromColse() { this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } } }