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 com.steering.mes.mcp.entity; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Control; using System.Collections; using Infragistics.Win.UltraWinGrid; using Core.StlMes.Client.Mcp.Common; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Mcp.CollarMaterial; using Core.StlMes.Client.Mcp.Control; using Core.StlMes.Client.Mcp.Coupling; using Core.StlMes.Client.Mcp.Entity; using Core.StlMes.Client.Mcp.BaseMethod; using Core.StlMes.Client.Mcp.Report; namespace Core.StlMes.Client.Coup { public partial class FrmThreadInspectResult : FrmBase { private string departm = "";//获取部门ID private string[] plineCode = null;//获取产线代码 private string lwGx = "";//螺纹检验工序代码 private string lwName = "";//螺纹工序名称 private string LiXian = "";//离线支数 private string StrMemo = "";//备注 private string[] plineCodes; private int CutPiece = 0; private int threadinspPiece = 0; ArrayList listF = new ArrayList(); public FrmThreadInspectResult() { InitializeComponent(); this.IsLoadUserView = true; } protected override void OnLoad(EventArgs e) { base.OnLoad(e); this.ultraGrid2.DisplayLayout.Override.AllowAddNew = Infragistics.Win.UltraWinGrid.AllowAddNew.TemplateOnBottom; this.ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False; this.ultraGrid2.DisplayLayout.Override.HeaderClickAction = Infragistics.Win.UltraWinGrid.HeaderClickAction.Select; ////禁控件过滤 //this.coupWoIdPlanControl1.Grid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False; //this.coupThreadInspectControl1.Grid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False; //设置计划区控件只读 //this.coupWoIdPlanControl1.SetAllColumnsActiveOnly(); //coupWoIdPlanControl1.Ob = this.ob; initControl(); } private void FrmThreadInspectResult_Load(object sender, EventArgs e) { EntityHelper.ShowGridCaption(ultraGridWoId.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid3.DisplayLayout.Bands[0]); departm = UserInfo.GetDeptid(); //plineCode = McpBaseHelper.GetPCodePline(departm, this.ob); plineCodes = comm.GetPlineCode(this.ValidDataPurviewIds, "H", ob); //McpBaseHelper.InitPlineUnit(cmbCname, plineCode, this.ob); //获取螺纹工序 DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700306" }, this.ob); if (dt2.Rows.Count > 0) { lwGx = dt2.Rows[0]["BASECODE"].ToString(); lwName = dt2.Rows[0]["BASENAME"].ToString(); } } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "DoQuery": QuerySinglePlan(); break; case "DoSave": DoSave(); break; case "DoUpdate": DoUpdate(); break; case "DoDelete": DoDelete(); break; case "DoBeside"://结炉 DoBeside(); break; case "UndoBeside"://撤销结炉 UndoBeside(); break; case "Offline"://离线 Offline(); break; case "unOffline"://撤销离线 unOffline(); break; case "Confirm": confirm();//确认 break; case "CancelConfirm": cancelConfirm(); break; case "DoClose": this.Close(); break; } } /// /// 取消确认 /// private void cancelConfirm() { ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("无螺纹检验实绩！"); return; } UltraGridRow row = this.ultraGridWoId.ActiveRow; if (row == null) { MessageUtil.ShowTips("无工单信息，不允许此操作！"); } ArrayList list1 = new ArrayList(); int UpdaCount = 0; foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { if (ugr.Cells["CONFIRM"].Value.ToString().Equals("0")) { MessageUtil.ShowTips("选中有没确认实绩，不允许取消确认！"); return; } UpdaCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["RESULT_NO"].Text.ToString()); list.Add(UserInfo.GetUserName()); list.Add(DateTime.Now.ToString()); list1.Add(list); } } if (UpdaCount == 0) { MessageUtil.ShowTips("请选择螺纹检验实绩数据！"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否取消确认螺纹检验实绩?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); try { this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待 if (Constant.WaitingForm == null) { Constant.WaitingForm = new WaitingForm(); } Constant.WaitingForm.ShowToUser = true; Constant.WaitingForm.Show(); Constant.WaitingForm.Update(); ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService"; ccp.MethodName = "getCancelConfirm"; ccp.ServerParams = new object[] { list1 }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } catch (Exception ex) { this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("取消确认成功!")) { QuerySinglePlan(); } } } /// /// 确认 /// private void confirm() { ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("无螺纹检验实绩！"); return; } UltraGridRow row = this.ultraGridWoId.ActiveRow; if (row == null) { MessageUtil.ShowTips("无工单信息，不允许此操作！"); } ArrayList list1 = new ArrayList(); int UpdaCount = 0; foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { if (ugr.Cells["CONFIRM"].Value.ToString().Equals("1")) { MessageUtil.ShowTips("选中有已确认实绩，不允许再次确认！"); return; } UpdaCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["RESULT_NO"].Text.ToString()); list.Add(UserInfo.GetUserName()); list.Add(DateTime.Now.ToString()); list1.Add(list); } } if (UpdaCount == 0) { MessageUtil.ShowTips("请选择螺纹检验实绩数据！"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认螺纹检验实绩?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); try { this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待 if (Constant.WaitingForm == null) { Constant.WaitingForm = new WaitingForm(); } Constant.WaitingForm.ShowToUser = true; Constant.WaitingForm.Show(); Constant.WaitingForm.Update(); ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService"; ccp.MethodName = "getConfirm"; ccp.ServerParams = new object[] { list1 }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } catch (Exception ex) { this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("确认成功!")) { QuerySinglePlan(); } } } private void Offline() { string _strat = ""; //UltraGridRow row1 = ultraGrid1.ActiveRow; //if (row1 == null) //{ // MessageUtil.ShowTips("没有螺纹实绩不能离线！"); // return; //} OffLineCut frm = new OffLineCut(); frm.ShowDialog(); LiXian = frm.StrNum; _strat = frm.Strat; StrMemo = frm.StrMemo; if (_strat.Equals("2")) return; if (LiXian.Equals("") || LiXian.Equals("0")) { MessageUtil.ShowTips("离线支数不能为空！"); return; } UltraGridRow row = ultraGridWoId.ActiveRow; if (row == null) return; if (row.Cells["ZyBillStatus"].Value.ToString() == "生产完成") { MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作！"); return; } string woId = row.Cells["WoId"].Value.ToString(); //查询切断实绩支数和 DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResult", new object[] { row.Cells["WoId"].Value.ToString() }, this.ob); //VrpLoadingResultEntity result1 = new VrpLoadingResultEntity(); //this.planExpanQuery1.Value = result; string pronum = "";//锯切支数 string cutnum = "";//锯切个数 if (dt.Rows.Count > 0) { pronum = dt.Rows[0]["PRO_NUM"].ToString(); cutnum = dt.Rows[0]["CUT_NUM"].ToString(); } else { pronum = "0"; cutnum = "0"; } if (!row.Cells["Ifsplit"].Value.Equals("1")) { if (Convert.ToInt32(LiXian) > Convert.ToInt32(cutnum) - Convert.ToInt32(threadinspPiece) - Convert.ToInt32(offlinePiece.Value)) { MessageUtil.ShowTips("离线个数不能大于锯切个数减去已经喷砂和离线个数的差！"); return; } } offlinePiece.Value = Convert.ToInt32(LiXian) + Convert.ToInt32(offlinePiece.Value); //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成")) //{ // MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！"); // return; //} //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryCouplingcominfo", new object[] { woId, lwGx }, this.ob); //if (dt.Rows[0]["STATION_STATUS"].ToString().Equals("2")) //{ // MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!"); // return; //} string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ArrayList list = new ArrayList(); list.Add(LiXian); list.Add(row.Cells["WoId"].Text.ToString()); list.Add(row.Cells["HeatPlanNo"].Text.ToString()); list.Add(row.Cells["JudgeStoveNo"].Text.ToString()); list.Add(row.Cells["BatchNo"].Text.ToString()); list.Add(row.Cells["PlineCode"].Text.ToString()); list.Add(row.Cells["PlineName"].Text.ToString()); list.Add(this.UserInfo.GetUserName()); list.Add(this.UserInfo.GetUserOrder()); list.Add(this.UserInfo.GetUserGroup()); list.Add(time); list.Add(""); list.Add(StrMemo); list.Add(row.Cells["BatchGroudNo"].Value.ToString()); CoreClientParam ccp = new CoreClientParam(); try { this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待 if (Constant.WaitingForm == null) { Constant.WaitingForm = new WaitingForm(); } Constant.WaitingForm.ShowToUser = true; Constant.WaitingForm.Show(); Constant.WaitingForm.Update(); ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService"; ccp.MethodName = "lixianThreadingResult"; ccp.ServerParams = new object[] { list, lwGx,lwName }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } catch (Exception ex) { this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("离线成功!")) { QuerySinglePlan(); //DoClean(); } } } //撤销离线 private void unOffline() { ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("螺纹实绩无数据！"); return; } UltraGridRow row = this.ultraGridWoId.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("无工单信息，不允许此操作！"); } if (row.Cells["ZyBillStatus"].Value.ToString() == "生产完成") { MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作！"); return; } string woId = row.Cells["WoId"].Value.ToString(); //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("生产完成")) //{ // MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作！"); // return; //} //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryCouplingcominfo", new object[] { woId, lwGx }, this.ob); //if (dt.Rows[0]["STATION_STATUS"].ToString().Equals("2")) //{ // MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!"); // return; //} //if(!QueryStatusGd(row.Cells["WO_ID"].Value.ToString(), row.Cells["ZY_PLAN_ID"].Value.ToString())) return; ArrayList list1 = new ArrayList(); int UpdaCount = 0; foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { UpdaCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["RESULT_NO"].Text.ToString()); list.Add(ugr.Cells["OFF_NUM"].Text.ToString()); list1.Add(list); } } if (UpdaCount == 0) { MessageUtil.ShowTips("请选择离线数据！"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否撤销离线?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); try { this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待 if (Constant.WaitingForm == null) { Constant.WaitingForm = new WaitingForm(); } Constant.WaitingForm.ShowToUser = true; Constant.WaitingForm.Show(); Constant.WaitingForm.Update(); ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService"; ccp.MethodName = "unlixianThreadingResult"; ccp.ServerParams = new object[] { list1, row.Cells["WoId"].Text.ToString(), lwGx }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } catch (Exception ex) { this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("撤销离线成功！")) { QuerySinglePlan(); } } /// /// 按回车键触发查询按钮 /// /// /// private void ContPublic_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { QuerySinglePlan(); } } /// /// 简单查询 /// private void QuerySinglePlan() { string woId = ""; string[] starts = { }; string judgeStoveNo = ""; string plnNo = ""; #region 条件 if (chkStarts.Checked) { if (string.IsNullOrEmpty(cmbStarts.Text.Trim())) { MessageUtil.ShowTips("请选择工单状态！"); return; } else { starts = (cmbStarts.Value as List).Select(p => p.ToString().Trim()).ToArray(); } } if (chkwoId.Checked) { if (chkwoId.Checked && string.IsNullOrEmpty(txtWoId.Text.Trim())) { MessageUtil.ShowTips("请输入工单号！"); return; } else { woId = txtWoId.Text.ToString().Trim(); } } else { woId = ""; } if (chkPlnNo.Checked) { if (chkPlnNo.Checked && string.IsNullOrEmpty(txtPlnNo.Text.Trim())) { MessageUtil.ShowTips("请输入炉次计划号！"); return; } else { plnNo = txtPlnNo.Text.ToString().Trim(); } } else { plnNo = ""; } if (chkJuNo.Checked) { if (chkJuNo.Checked && string.IsNullOrEmpty(txtJudgeStoveNO.Text.Trim())) { //MessageUtil.ShowTips("请输入炉号！"); //return; judgeStoveNo = ""; } else { judgeStoveNo = txtJudgeStoveNO.Text.ToString().Trim(); } } else { judgeStoveNo = ""; } #endregion List listSource = EntityHelper.GetData ("com.steering.mes.mcp.coup.CoupLoadingService.getQueryWoId1", new object[] { woId, plnNo, judgeStoveNo, starts, plineCodes }, this.ob); plnZyJgWorkbillEntitySource.DataSource = listSource; //GridHelper.RefreshAndAutoSize(ultraGridWoId); // List listSource1 = EntityHelper.GetData //("com.steering.mes.mcp.coup.CoupLoadingService.ulgetQueryWoId", new object[] { woId, plnNo, judgeStoveNo, starts, plineCode[0].ToString() }, this.ob); // bindingSource1.DataSource = listSource1; // GridHelper.RefreshAndAutoSize(ultraGrid1); } /// /// 螺纹检验详情 /// /// /// private void ultraGridWoId_AfterRowActivate(object sender, EventArgs e) { UltraGridRow row = ultraGridWoId.ActiveRow; if (row == null) return; string planNO = row.Cells["HeatPlanNo"].Value.ToString(); string plinCode = row.Cells["PlineCode"].Value.ToString(); string woId = row.Cells["WoId"].Value.ToString(); //this.coupThreadInspectControl1.Value.QualiriedPcs = BaseHelper.piecesJg(woId, plineCode,ob); getCoupThreadInspectResult(woId); } /// /// 查询螺纹检验实绩 /// /// private void getCoupThreadInspectResult(string woId) { DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.ThreadInspectResultService.getThreadInspectResult", new object[] { woId }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dtSelfChecked, true); foreach (UltraGridRow urg in ultraGrid1.Rows) { if (urg.Cells["CONFIRM"].Value.Equals("1")) { urg.Appearance.BackColor = Color.LightGreen; } } if (dt.Rows.Count == 0) { this.initControl(); } } /// /// 接箍加工计划详情 /// /// //private void getCoupProcessPlan(string planNo,string woId) //{ // DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, planNo }, this.ob); // if (dt != null && dt.Rows.Count > 0) // { // this.coupWoIdPlanControl1.Value.PlineName = dt.Rows[0]["PLINE_NAME"].ToString(); // this.coupWoIdPlanControl1.Value.CutMachGrpNm = dt.Rows[0]["CUT_MACH_GRP_NM"].ToString(); // this.coupWoIdPlanControl1.Value.Memo = dt.Rows[0]["MEMO"].ToString(); // this.coupWoIdPlanControl1.Value.ZyPlanId = dt.Rows[0]["ZY_PLAN_ID"].ToString(); // this.coupWoIdPlanControl1.Value.IfMonitorJg = dt.Rows[0]["IF_MONITOR_JG"].ToString(); // this.coupWoIdPlanControl1.Value.LoadPieces = dt.Rows[0]["LOAD_PIECES"].ToString(); // this.coupWoIdPlanControl1.Value.LoadWeight = dt.Rows[0]["LOAD_WEIGHT"].ToString(); // this.coupWoIdPlanControl1.Value.ProPlanId = dt.Rows[0]["PRO_PLAN_ID"].ToString(); // this.coupWoIdPlanControl1.Value.Steelname = dt.Rows[0]["STEELNAME"].ToString(); // this.coupWoIdPlanControl1.Value.Gradename = dt.Rows[0]["GRADENAME"].ToString(); // this.coupWoIdPlanControl1.Value.JglDesc = dt.Rows[0]["JGL_DESC"].ToString(); // this.coupWoIdPlanControl1.Value.CodeJg = dt.Rows[0]["CODE_JG"].ToString(); // this.coupWoIdPlanControl1.Value.ModelDesc = dt.Rows[0]["MODEL_DESC"].ToString(); // this.coupWoIdPlanControl1.Value.SpecJgDesc = dt.Rows[0]["SPEC_JG_DESC"].ToString(); // this.coupWoIdPlanControl1.Value.StyleJg = dt.Rows[0]["STYLE_JG"].ToString(); // this.coupWoIdPlanControl1.Value.PlanJgNum = dt.Rows[0]["PLAN_JG_NUM"].ToString(); // this.coupWoIdPlanControl1.Value.CsJgNum = dt.Rows[0]["CS_JG_NUM"].ToString(); // this.coupWoIdPlanControl1.Value.XqJgNum = dt.Rows[0]["XQ_JG_NUM"].ToString(); // this.coupWoIdPlanControl1.Value.InstoreNum = dt.Rows[0]["INSTORE_NUM"].ToString(); // this.coupWoIdPlanControl1.Value.BlWlDesc = dt.Rows[0]["BL_WL_DESC"].ToString(); // //this.coupWoIdPlanControl1.Value.LoadWeight = ""; // this.coupWoIdPlanControl1.UpdateData(); // } //} /// /// 初始化控件 /// private void initControl() { UltraGridRow row = ultraGridWoId.ActiveRow; if (row == null) return; //查询切断实绩支数和 DataTable dtCut = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultPiece", new object[] { row.Cells["WoId"].Value.ToString() }, this.ob); string pronum = ""; if (dtCut.Rows.Count > 0) { pronum = dtCut.Rows[0]["PRO_NUM"].ToString(); } else { pronum = "0"; } CutPiece = Convert.ToInt32(pronum); //查询螺纹检验实绩支数和 DataTable dtThread = ServerHelper.GetData("com.steering.mes.mcp.coup.ThreadInspectResultService.getthreadinspResult", new object[] { row.Cells["WoId"].Value.ToString() }, this.ob); if (dtThread.Rows.Count > 0) { threadinspPiece = Convert.ToInt32(dtThread.Rows[0]["PRO_NUM"].ToString()); } else { threadinspPiece = 0; } InspectResult result = new InspectResult(); //if (CutPiece - threadNum <= 0) //{ // result.InspectPieces = Convert.ToString(0); // threadinspPiece = 0; //} //else //{ // result.InspectPieces = Convert.ToString(CutPiece - threadNum); // threadinspPiece = CutPiece - threadNum; //} txtBC.Value = UserInfo.GetUserOrder(); txtBz.Value = UserInfo.GetUserGroup(); txtUser.Value = UserInfo.GetUserName(); ProducerTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); //UltraGridRow row = ultraGrid4.ActiveRow; //if (row != null) { result.InspectPieces =row.Cells["LATHE_OK_NUM"].Text.ToString(); } } /// /// 判断状态 /// /// /// private bool QueryStatusGd(string woId, string planNO) { DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, planNO }, this.ob); if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单已生产完成,不允许此操作！"); return false; } if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成")) { MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！"); return false; } return true; } /// /// 保存 /// private void DoSave() { this.saveThreadInspectResult(); } /// /// 螺纹检验实绩保存 /// private void saveThreadInspectResult() { string AddCount = "0"; UltraGridRow row = ultraGridWoId.ActiveRow; if (row == null) { MessageUtil.ShowTips("无工单信息！"); return; } UltraGridRow rowMat = ultraGrid1.ActiveRow; //if(!QueryStatusGd(row.Cells["WO_ID"].Value.ToString(), row.Cells["ZY_PLAN_ID"].Value.ToString())) return; //if (!row.Cells["zyBillStatus"].Value.ToString().Equals("生产中")) //{ // MessageUtil.ShowTips("此工单不是生产中,不允许此操作！"); // return; //} string zYgNo = row.Cells["HeatPlanNo"].Value.ToString(); string woId = row.Cells["WoId"].Value.ToString(); //ComCoupBug ccb = new ComCoupBug(); //string fail = ccb.Strat; //string failNum = ccb.StrNum; //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成")) //{ // MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！"); // return; //} InspectResult result = new InspectResult(); result.WoId = row.Cells["WoId"].Text.ToString(); result.PlineCode = row.Cells["PlineCode"].Value.ToString(); result.RejectedPcs = ultraNumericEditor2.Value.ToString(); result.QualiriedPcs = numQualified.Value.ToString(); result.InspectPieces = numPieces.Value.ToString(); result.ColShft = txtBC.Value.ToString(); result.ColGroup = txtBz.Value.ToString(); result.ColTime = ProducerTime.Value.ToString(); result.ColUser = txtUser.Text.ToString(); result.Memo = txtMemo.Text.ToString(); result.RepairedPcs = "0"; ArrayList list = new ArrayList(); for (int i = 0; i < ultraGrid2.Rows.Count; i++) { UltraGridRow checkrow = ultraGrid2.Rows[i]; if (Convert.ToBoolean(checkrow.Cells["CHECK"].Text) == true) { //UltraGridRow rowug = ultraGrid1.ActiveRow; //if (rowug == null) { MessageUtil.ShowTips("无螺纹实绩信息！"); return; } AddCount = "1"; ThreadInspectSelfCheck thsf = getSelfcheck(checkrow); //thsf.ResultNo = rowug.Cells["RESULT_NO"].Value.ToString(); thsf.ZyPlanId = zYgNo; thsf.PlineCode = row.Cells["PlineCode"].Value.ToString(); thsf.WoId = woId; list.Add(thsf); } } //if (Convert.ToInt32(this.coupThreadInspectControl1.Value.QualiriedPcs) > threadinspPiece) //{ // MessageUtil.ShowTips("螺纹检验个数大于加工最大可切个数!"); // return; //} //if (AddCount == 0) { MessageUtil.ShowTips("请选择抽检记录！"); return; } //double PlnCount = 0;//计划个数 //double CutCount = 0;//实际个数 //DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob); //if (dt1.Rows.Count > 0) //{ // PlnCount = Double.Parse(dt1.Rows[0]["THREAD_PLN_NUM"].ToString()); // CutCount = Double.Parse(dt1.Rows[0]["THREAD_CHK_OK_NUM"].ToString()); //} //// + Double.Parse(numQualified.Value.ToString()) //if (CutCount > PlnCount) //{ // if (MessageUtil.ShowYesNoAndQuestion("实际螺纹检验个数超过计划螺纹检验个数是否新增！") == DialogResult.No) { return; } //} if (MessageUtil.ShowYesNoAndQuestion("是否保存螺纹检验?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); try { this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待 if (Constant.WaitingForm == null) { Constant.WaitingForm = new WaitingForm(); } Constant.WaitingForm.ShowToUser = true; Constant.WaitingForm.Show(); Constant.WaitingForm.Update(); ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService"; ccp.MethodName = "saveThreadInspectResult"; ccp.ServerParams = new object[] { lwGx, result, list, AddCount, woId, listF }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } catch (Exception ex) { this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("保存成功！")) { QuerySinglePlan(); DoClean(); } } /// /// 保存自检记录数据 /// private void saveSelfcheckPipNo() { Infragistics.Win.UltraWinGrid.UltraGridRow row = ultraGridWoId.ActiveRow; if (row != null) { ArrayList list = new ArrayList(); for (int i = 0; i < ultraGrid2.Rows.Count; i++) { UltraGridRow checkrow = ultraGrid2.Rows[i]; if (Convert.ToBoolean(checkrow.Cells["CHECK"].Value)) { ThreadInspectSelfCheck thsf = getSelfcheck(checkrow); thsf.ZyPlanId = row.Cells["ZY_PLAN_ID"].Value.ToString(); list.Add(thsf); } } ServerHelper.SetData("com.steering.mes.mcp.coup.ThreadInspectResultService.saveThreadInspectSelfcheck", new object[] { list }, this.ob); } } /// /// 自检记录显示数据 /// public void selectPipeNO(string planNo,string woId) { DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.ThreadInspectResultService.getThreadInspectSelfcheck", new object[] { planNo, woId }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dtInspectPIN, true); } /// /// 取自检记录行数据 /// /// /// private ThreadInspectSelfCheck getSelfcheck(UltraGridRow checkrow) { ThreadInspectSelfCheck tisc = new ThreadInspectSelfCheck(); tisc.CouplingNo = checkrow.Cells["COUPLING_NO"].Value.ToString().Trim(); tisc.Taper = checkrow.Cells["TAPER"].Value.ToString().Trim(); tisc.Lead = checkrow.Cells["LEAD"].Value.ToString().Trim(); tisc.Height = checkrow.Cells["HEIGHT"].Value.ToString().Trim(); tisc.PdiameterOvality = checkrow.Cells["PDIAMETER_OVALITY"].Value.ToString().Trim(); tisc.Brokenthread = checkrow.Cells["BROKENTHREAD"].Value.ToString().Trim(); tisc.Al = checkrow.Cells["AL"].Value.ToString().Trim(); tisc.RunOut = checkrow.Cells["RUN_OUT"].Value.ToString().Trim(); tisc.Chamfer = checkrow.Cells["CHAMFER"].Value.ToString().Trim(); tisc.Threadform = checkrow.Cells["THREADFORM"].Value.ToString().Trim(); tisc.Result = checkrow.Cells["RESULT"].Value.ToString().Trim(); tisc.ResultNo = checkrow.Cells["RESULT_NO"].Value.ToString().Trim(); tisc.ZyPlanId = checkrow.Cells["ZY_PLAN_ID"].Value.ToString().Trim(); tisc.PlineCode = checkrow.Cells["PLINE_CODE"].Value.ToString().Trim(); tisc.WoId = checkrow.Cells["WO_ID"].Value.ToString().Trim(); return tisc; } /// /// 自检记录序号自加1 /// /// /// private void ultraGrid2_AfterRowInsert(object sender, Infragistics.Win.UltraWinGrid.RowEventArgs e) { e.Row.Cells["COUPLING_NO"].Value = e.Row.Index; //(e.Row.Index == 0 ? 1 : Convert.ToInt32(((Infragistics.Win.UltraWinGrid.UltraGrid)sender).Rows[e.Row.Index - 1].Cells["COUPLING_NO"].Value) + 1); e.Row.Cells["CHECK"].Value = true; } /// /// 修改 /// private void DoUpdate() { if (ultraTabControl2.Tabs.TabControl.SelectedTab.Key.Equals("0")) { DoInspUpdate(); } else { DoThreUpdate(); } } /// /// 抽检修改 /// private void DoInspUpdate() { ultraGrid2.UpdateData(); UltraGridRow row = ultraGridWoId.ActiveRow; if (row == null) { MessageUtil.ShowTips("无工单计划！"); return; } UltraGridRow rowMat = ultraGrid2.ActiveRow; if (rowMat == null) { MessageUtil.ShowTips("无抽检记录！"); return; } string woId = row.Cells["WoId"].Value.ToString(); int update = 0; ArrayList list = new ArrayList(); for (int i = 0; i < ultraGrid2.Rows.Count; i++) { UltraGridRow checkrow = ultraGrid2.Rows[i]; if (Convert.ToBoolean(checkrow.Cells["CHECK"].Text) == true) { update += 1; if (checkrow.Cells["RESULT_NO"].Text.Trim().Equals("")) { MessageUtil.ShowTips("有选中未新增的数据，请核对！"); return; } ThreadInspectSelfCheck thsf = getSelfcheck(checkrow); list.Add(thsf); } } if (update == 0) { MessageUtil.ShowTips("请选择抽检记录！"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否修改抽检记录?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); try { this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待 if (Constant.WaitingForm == null) { Constant.WaitingForm = new WaitingForm(); } Constant.WaitingForm.ShowToUser = true; Constant.WaitingForm.Show(); Constant.WaitingForm.Update(); ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService"; ccp.MethodName = "doInspUpdate"; ccp.ServerParams = new object[] { list, woId }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } catch (Exception ex) { this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改抽检记录成功！")) { QuerySinglePlan(); DoClean(); } } /// /// 螺纹检验修改 /// private void DoThreUpdate() { ultraGrid1.UpdateData(); UltraGridRow row = ultraGridWoId.ActiveRow; if (row == null) { MessageUtil.ShowTips("无工单信息！"); return; } UltraGridRow rowMat = ultraGrid1.ActiveRow; if (rowMat == null) { MessageUtil.ShowTips("无螺纹检验实绩！"); return; } if(rowMat.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是")) { MessageUtil.ShowTips("此工序已经离线，不允许此操作！"); return; } //if (!row.Cells["zyBillStatus"].Value.ToString().Equals("生产中")) //{ // MessageUtil.ShowTips("此工单不是生产中,不允许此操作！"); // return; //} string zYgNo = row.Cells["HeatPlanNo"].Value.ToString(); string woId = row.Cells["WoId"].Value.ToString(); //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成")) //{ // MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！"); // return; //} ArrayList list = new ArrayList(); list.Add(rowMat.Cells["WO_ID"].Value.ToString()); list.Add(rowMat.Cells["RESULT_NO"].Value.ToString()); list.Add(rowMat.Cells["PLINE_CODE"].Value.ToString()); list.Add(rowMat.Cells["INSPECT_PIECES"].Value.ToString()); list.Add(rowMat.Cells["QUALIRIED_PCS"].Value.ToString()); list.Add(rowMat.Cells["REJECTED_PCS"].Value.ToString()); list.Add(rowMat.Cells["COL_SHIFT"].Value.ToString()); list.Add(rowMat.Cells["COL_GROUP"].Value.ToString()); list.Add(rowMat.Cells["COL_USER"].Value.ToString()); list.Add(rowMat.Cells["COL_TIME"].Value.ToString()); list.Add(rowMat.Cells["MEMO"].Value.ToString()); //double PlnCount = 0;//计划个数 //double CutCount = 0;//实际个数 //DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob); //if (dt1.Rows.Count > 0) //{ // PlnCount = Double.Parse(dt1.Rows[0]["THREAD_PLN_NUM"].ToString()); // CutCount = Double.Parse(dt1.Rows[0]["THREAD_CHK_OK_NUM"].ToString()); //} // + Double.Parse(numQualified.Value.ToString()) //if (CutCount > PlnCount) //{ // if (MessageUtil.ShowYesNoAndQuestion("实际螺纹检验个数超过计划螺纹检验个数是否修改！") == DialogResult.No) { return; } //} if (MessageUtil.ShowYesNoAndQuestion("是否修改螺纹检验实绩?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); try { this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待 if (Constant.WaitingForm == null) { Constant.WaitingForm = new WaitingForm(); } Constant.WaitingForm.ShowToUser = true; Constant.WaitingForm.Show(); Constant.WaitingForm.Update(); ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService"; ccp.MethodName = "doThreUpdate"; ccp.ServerParams = new object[] { lwGx, list,woId }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } catch (Exception ex) { this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功！")) { QuerySinglePlan(); DoClean(); } } /// /// 删除 /// private void DoDelete() { if (ultraTabControl2.Tabs.TabControl.SelectedTab.Key.Equals("0")) { DoInspDelete(); DoClean(); } else { DoThreDelete(); DoClean(); } } /// /// 抽检删除 /// private void DoInspDelete() { ultraGrid2.UpdateData(); UltraGridRow rowMat = ultraGrid2.ActiveRow; if (rowMat == null) { MessageUtil.ShowTips("无抽检记录！"); return; } UltraGridRow row = ultraGridWoId.ActiveRow; if (row == null) { MessageUtil.ShowTips("无工单信息！"); return; } //string zYgNo = rowMat.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = row.Cells["WoId"].Value.ToString(); //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); //if (dt.Rows.Count < 0) return; //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成")) //{ // MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！"); // return; //} if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成")) //{ // MessageUtil.ShowTips("此工单已结炉,不允许此操作！"); // return; //} int update = 0; ArrayList list = new ArrayList(); for (int i = 0; i < ultraGrid2.Rows.Count; i++) { UltraGridRow checkrow = ultraGrid2.Rows[i]; if (Convert.ToBoolean(checkrow.Cells["CHECK"].Text) == true) { update += 1; if (checkrow.Cells["RESULT_NO"].Text.Trim().Equals("")) { MessageUtil.ShowTips("有选中未新增的数据，请核对！"); return; } ThreadInspectSelfCheck thsf = getSelfcheck(checkrow); list.Add(thsf); } } if (update == 0) { MessageUtil.ShowTips("请选择抽检记录！"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否删除抽检记录?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); try { this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待 if (Constant.WaitingForm == null) { Constant.WaitingForm = new WaitingForm(); } Constant.WaitingForm.ShowToUser = true; Constant.WaitingForm.Show(); Constant.WaitingForm.Update(); ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService"; ccp.MethodName = "doInspDelete"; ccp.ServerParams = new object[] { list, woId }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } catch (Exception ex) { this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("删除抽检记录成功！")) { QuerySinglePlan(); } } /// /// 螺纹实绩删除 /// private void DoThreDelete() { ultraGrid1.UpdateData(); UltraGridRow row = ultraGridWoId.ActiveRow; if (row == null) { MessageUtil.ShowTips("无工单信息！"); return; } UltraGridRow rowMat = ultraGrid1.ActiveRow; if (rowMat == null) { MessageUtil.ShowTips("无螺纹检验实绩！"); return; } if (rowMat.Cells["CONFIRM"].Value.ToString().Equals("1")) { MessageUtil.ShowTips("选中的螺纹检验实绩已经确认，不允许删除！"); return; } //if (!row.Cells["zyBillStatus"].Value.ToString().Equals("生产中")) //{ // MessageUtil.ShowTips("此工单不是生产中,不允许此操作！"); // return; //} string zYgNo = row.Cells["HeatPlanNo"].Value.ToString(); string woId = row.Cells["WoId"].Value.ToString(); string plinCode = row.Cells["PlineCode"].Value.ToString(); //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成")) //{ // MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！"); // return; //} int UpdaCount = 0; ArrayList list1 = new ArrayList(); foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是")) { MessageUtil.ShowTips("此工序已经离线，不允许此操作！"); return; } if (ugr.Cells["OFF_NUM"].Text != "0" && ugr.Cells["OFF_NUM"].Text != "") { MessageUtil.ShowTips("存在离线支数，不允许此操作！"); return; } UpdaCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["RESULT_NO"].Text.Trim()); list.Add(ugr.Cells["PLINE_CODE"].Text.Trim()); list.Add(ugr.Cells["REJECTED_PCS"].Text.Trim()); list1.Add(list); } } if (UpdaCount == 0) { MessageUtil.ShowTips("请选择螺纹检验实绩!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否删除螺纹检验实绩?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); try { this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待 if (Constant.WaitingForm == null) { Constant.WaitingForm = new WaitingForm(); } Constant.WaitingForm.ShowToUser = true; Constant.WaitingForm.Show(); Constant.WaitingForm.Update(); ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService"; ccp.MethodName = "doThreDelete"; ccp.ServerParams = new object[] { lwGx, list1, woId}; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } catch (Exception ex) { this.Cursor = Cursors.Default; Constant.WaitingForm.ShowToUser = false; Constant.WaitingForm.Close(); Constant.WaitingForm = null; } if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("删除成功！")) { QuerySinglePlan(); } } /// /// 结炉 /// private void DoBeside() { UltraGridRow uRow = this.ultraGridWoId.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("请选择需要结炉的工单号!"); return; } //if (uRow.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成") //{ // MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作！"); // return; //} //string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WoId"].Value.ToString(); //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成")) //{ // MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！"); // return; //} //ArrayList list = new ArrayList(); //list.Add(zYgNo); //list.Add(lwGx); //list.Add(woId); if (MessageUtil.ShowYesNoAndQuestion("是否结单?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService"; ccp.MethodName = "doBeside"; ccp.ServerParams = new object[] { lwGx,woId }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("结单成功!")) { QuerySinglePlan(); } } } /// /// 撤销结炉 /// private void UndoBeside() { UltraGridRow uRow = this.ultraGridWoId.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("请选择需要撤销结炉的工单号!"); return; } //string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WoId"].Value.ToString(); //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); //if (!dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成")) //{ // MessageUtil.ShowTips("此工单螺纹检验工序点未结炉,不允许此操作！"); // return; //} //ArrayList list = new ArrayList(); //list.Add(zYgNo); //list.Add(lwGx); //list.Add(woId); if (MessageUtil.ShowYesNoAndQuestion("是否撤销结单?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService"; ccp.MethodName = "undoBeside"; ccp.ServerParams = new object[] { lwGx,woId }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("撤销结单成功!")) { QuerySinglePlan(); } } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { string zYgNo = ""; string woId = ""; UltraGridRow row = ultraGrid1.ActiveRow; if (row != null) { zYgNo = row.Cells["RESULT_NO"].Value.ToString(); woId = row.Cells["WO_ID"].Value.ToString(); //if (row.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("否")) //{ //if (Convert.ToBoolean(row.Cells["CHK"].Text) == true) //{ //this.coupThreadInspectControl1.Value.InspectPieces = row.Cells["INSPECT_PIECES"].Text.ToString(); //this.coupThreadInspectControl1.Value.QualiriedPcs = row.Cells["QUALIRIED_PCS"].Text.ToString(); //this.coupThreadInspectControl1.Value.RepairedPcs = row.Cells["REPAIRED_PCS"].Text.ToString(); //this.coupThreadInspectControl1.Value.RepairedReason1 = row.Cells["REPAIRED_REASON1"].Text.ToString(); //this.coupThreadInspectControl1.Value.RepairedPcs1 = row.Cells["REPAIRED_PCS1"].Text.ToString() == "0" ? null : row.Cells["REPAIRED_PCS1"].Text.ToString(); //this.coupThreadInspectControl1.Value.RepairedReason2 = row.Cells["REPAIRED_REASON2"].Text.ToString(); //this.coupThreadInspectControl1.Value.RepairedPcs2 = row.Cells["REPAIRED_PCS2"].Text.ToString() == "0" ? null : row.Cells["REPAIRED_PCS2"].Text.ToString(); //this.coupThreadInspectControl1.Value.RepairedReason3 = row.Cells["REPAIRED_REASON3"].Text.ToString(); //this.coupThreadInspectControl1.Value.RepairedPcs3 = row.Cells["REPAIRED_PCS3"].Text.ToString() == "0" ? null : row.Cells["REPAIRED_PCS3"].Text.ToString(); //this.coupThreadInspectControl1.Value.RepairedReason4 = row.Cells["REPAIRED_REASON4"].Text.ToString(); //this.coupThreadInspectControl1.Value.RepairedPcs4 = row.Cells["REPAIRED_PCS4"].Text.ToString() == "0" ? null : row.Cells["REPAIRED_PCS4"].Text.ToString(); //this.coupThreadInspectControl1.Value .ColShft = row.Cells["COL_SHIFT"].Value.ToString(); //this.coupThreadInspectControl1.Value.ColGroup = row.Cells["COL_GROUP"].Value.ToString(); //this.coupThreadInspectControl1.Value.ColUser = row.Cells["COL_USER"].Text.ToString(); ////this.coupThreadInspectControl1.Value.ColTime = row.Cells["COL_TIME"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedPcs = row.Cells["REJECTED_PCS"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedPcs1 = row.Cells["REJECTED_PCS1"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS1"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedPcs2 = row.Cells["REJECTED_PCS2"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS2"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedPcs3 = row.Cells["REJECTED_PCS3"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS3"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedPcs4 = row.Cells["REJECTED_PCS4"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS4"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedPcs5 = row.Cells["REJECTED_PCS5"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS5"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedPcs6 = row.Cells["REJECTED_PCS6"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS6"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedPcs7 = row.Cells["REJECTED_PCS7"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS7"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedPcs8 = row.Cells["REJECTED_PCS8"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS8"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedReason1 = row.Cells["REJECTED_REASON1"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedReason2 = row.Cells["REJECTED_REASON2"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedReason3 = row.Cells["REJECTED_REASON3"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedReason4 = row.Cells["REJECTED_REASON4"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedReason5 = row.Cells["REJECTED_REASON5"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedReason6 = row.Cells["REJECTED_REASON6"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedReason7 = row.Cells["REJECTED_REASON7"].Text.ToString(); //this.coupThreadInspectControl1.Value.RejectedReason8 = row.Cells["REJECTED_REASON8"].Text.ToString(); //this.coupThreadInspectControl1.UpdateData(); //} //else //{ // this.initControl(); //} //} //selectPipeNO(zYgNo, woId); } else { this.initControl(); } selectPipeNO(zYgNo, woId); } private void chkStarts_CheckedChanged(object sender, EventArgs e) { if (chkStarts.Checked) { cmbStarts.Enabled = true; } else { cmbStarts.Enabled = false; } if (chkJuNo.Checked) { txtJudgeStoveNO.Enabled = true; } else { txtJudgeStoveNO.Enabled = false; } if (chkPlnNo.Checked) { txtPlnNo.Enabled = true; } else { txtPlnNo.Enabled = false; } if (chkwoId.Checked) { txtWoId.Enabled = true; } else { txtWoId.Enabled = false; } } private void craftImg_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { UltraGridRow row = ultraGridWoId.ActiveRow; if (row == null) return; string orderNo = row.Cells["OrderNoSeq"].Text.ToString(); string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilCouplingProcess2.cpt" + "&ORDER_NO=" + orderNo; FrmRepExcel down = new FrmRepExcel(ob, strurl); down.Text = "接箍二级工艺"; down.Visible = false; down.Size = new Size(740, this.Height); down.WindowState = FormWindowState.Maximized; down.ShowDialog(); } private void ultraGrid1_CellChange(object sender, CellEventArgs e) { UltraGridRow row = ultraGrid1.ActiveRow; if (row == null) return; if (Convert.ToBoolean(row.Cells["CHK"].Text) == true) { numPieces.Value = row.Cells["INSPECT_PIECES"].Text.ToString(); numQualified.Value = row.Cells["QUALIRIED_PCS"].Text.ToString(); ultraNumericEditor2.Value = row.Cells["REJECTED_PCS"].Text.ToString(); txtBC.Value = row.Cells["COL_SHIFT"].Text.ToString(); txtBz.Value = row.Cells["COL_GROUP"].Text.ToString(); txtUser.Text = row.Cells["COL_USER"].Text.ToString(); ProducerTime.Text = row.Cells["COL_TIME"].Text.ToString(); txtMemo.Text = row.Cells["MEMO"].Text.ToString(); } else { DoClean(); } } private void DoClean() { ultraNumericEditor2.Value = "0"; numPieces.Value = "0"; numQualified.Value = "0"; txtMemo.Text = ""; } private void numPieces_AfterEnterEditMode(object sender, EventArgs e) { this.BeginInvoke(new MethodInvoker(this.numPieces.SelectAll)); } private void numQualified_AfterEnterEditMode(object sender, EventArgs e) { this.BeginInvoke(new MethodInvoker(this.numQualified.SelectAll)); } private void ultraNumericEditor2_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { UltraGridRow row = ultraGridWoId.ActiveRow; if (row == null) return; string woid = row.Cells["WoId"].Text.ToString(); string judgeNo = row.Cells["JudgeStoveNo"].Text.ToString(); ComCoupBug ccb = new ComCoupBug(woid, judgeNo, ob); ccb.ShowDialog(); listF = ccb.List; ultraNumericEditor2.Value = ccb.SumPieces.ToString(); //LiXian = frm.StrNum; //_strat = frm.Strat; //StrMemo = frm.StrMemo; } private void numPieces_ValueChanged(object sender, EventArgs e) { if(numPieces.Value!=""&&ultraNumericEditor2.Value=="") { numQualified.Value = numPieces.Value; } else if (numPieces.Value != "" && ultraNumericEditor2.Value!="") { numQualified.Value = Convert.ToInt32(numPieces.Value) - Convert.ToInt32(ultraNumericEditor2.Value); } } private void ultraNumericEditor2_ValueChanged(object sender, EventArgs e) { if (numPieces.Value == "" && ultraNumericEditor2.Value != "") { numQualified.Value = ultraNumericEditor2.Value; } else if (numPieces.Value != "" && ultraNumericEditor2.Value != "") { numQualified.Value = Convert.ToInt32(numPieces.Value) - Convert.ToInt32(ultraNumericEditor2.Value); } } } }