using System; using System.Collections; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Control; using Core.StlMes.Client.Mcp; using com.steering.mes.mcp.entity; using Infragistics.Win.UltraWinGrid; using Core.StlMes.Client.Mcp.Control; using Core.StlMes.Client.Mcp.Common; using Core.StlMes.Client.Mcp.Entity; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Mcp.CollarMaterial; using Infragistics.Win; using Core.StlMes.Client.Mcp.Coupling; namespace Core.StlMes.Client.Coup { public partial class FrmPerformanceResult : FrmBase { private string departm = "";//获取部门ID private string[] plineCode = null;//获取产线代码 private string cutGx = "";//切管工序 private string embGx = "";//压印工序 //private string rouGx = "";//粗加工工序 private string csGx = "";//车丝工序 private string PsGx = "";//喷砂工序 private string LiXian = ""; public FrmPerformanceResult() { InitializeComponent(); this.IsLoadUserView = true; } protected override void OnLoad(EventArgs e) { base.OnLoad(e); //禁控件过滤 this.coupWoIdPlanControl1.Grid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False; //设置计划区控件只读 //this.coupWoIdPlanControl1.SetAllColumnsActiveOnly(); coupWoIdPlanControl1.Ob = this.ob; } private void FrmPerformanceResult_Load(object sender, EventArgs e) { departm = UserInfo.GetDeptid(); plineCode = McpBaseHelper.GetPCodePline(departm, this.ob); // McpBaseHelper.InitPlineUnit(cmbCname, plineCode, this.ob); //McpBaseHelper.InitPlineUnit(cmbCname, plineCode, this.ob,"H"); #region 切管 //获取废品原因 DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7002" }, this.ob); cmbReason.DataSource = dt1; cmbReason.ValueMember = "BASENAME"; YdmBaseClass.SetComboItemHeight(cmbReason); txtBz.Value = UserInfo.GetUserGroup(); txtBC.Value = UserInfo.GetUserOrder(); txtUser.Text = UserInfo.GetUserName(); //获取切管工序 DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700302" }, this.ob); if (dt2.Rows.Count > 0) { cutGx = dt2.Rows[0]["BASECODE"].ToString(); } //获取压印工序 DataTable dt3 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700304" }, this.ob); if (dt3.Rows.Count > 0) { embGx = dt3.Rows[0]["BASECODE"].ToString(); } //获取粗加工工序 //DataTable dt4 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700303" }, this.ob); //if (dt4.Rows.Count > 0) //{ // rouGx = dt4.Rows[0]["BASECODE"].ToString(); //} #endregion #region 车丝 //获取废品原因 DataTable dtcs = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7004" }, this.ob); txtCsFp.DataSource = dtcs; txtCsFp.ValueMember = "BASENAME"; YdmBaseClass.SetComboItemHeight(txtCsFp); txtCsBz.Value = UserInfo.GetUserGroup(); txtCsBc.Value = UserInfo.GetUserOrder(); txtUserCs.Text = UserInfo.GetUserName(); //获取车丝工序 DataTable dtcsgx = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700305" }, this.ob); if (dtcsgx.Rows.Count > 0) { csGx = dtcsgx.Rows[0]["BASECODE"].ToString(); } #endregion #region 喷砂 //获取工序 DataTable dtps = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700308" }, this.ob); if (dtps.Rows.Count > 0) { PsGx = dt2.Rows[0]["BASECODE"].ToString(); } txtPsbc.Value = this.UserInfo.GetUserOrder(); txtPsbz.Value = this.UserInfo.GetUserGroup(); txtUserPs.Text = this.UserInfo.GetUserName(); //获取废品原因 DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7007" }, this.ob); cmbFpPs.DataSource = dt; cmbFpPs.ValueMember = "BASENAME"; YdmBaseClass.SetComboItemHeight(cmbFpPs); //获取喷料 DataTable dt1ps = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7005" }, this.ob); cmbPsSpray.DataSource = dt1ps; cmbPsSpray.ValueMember = "BASENAME"; YdmBaseClass.SetComboItemHeight(cmbPsSpray); //获取喷砂设备 DataTable dt3ps = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "7006" }, this.ob); cmbPsEquipment.DataSource = dt3ps; cmbPsEquipment.ValueMember = "BASENAME"; YdmBaseClass.SetComboItemHeight(cmbPsEquipment); #endregion } 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 "DoClose": this.Close(); break; } } private void Offline() { if (ultraTabControl3.SelectedTab.Key.Equals("0")) { OfflineQg(); } else if (ultraTabControl3.SelectedTab.Key.Equals("1")) { OfflineCs(); } else { OfflinePs(); } } //撤销离线 private void unOffline() { if (ultraTabControl3.SelectedTab.Key.Equals("0")) { unOfflineQg(); } else if (ultraTabControl3.SelectedTab.Key.Equals("1")) { unOfflineCs(); } else { unOfflinePs(); } } private void unOfflineQg() { ultraCut.UpdateData(); UltraGridRow uRow = this.ultraCut.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("锯切实绩无数据!"); return; } UltraGridRow row = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("无工单信息,不允许此操作!"); } if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成") { MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成")) { 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 ultraCut.Rows) { if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true) { UpdaCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["RESULT_NO"].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["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() }; 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 unOfflinePs() { ultraPs.UpdateData(); UltraGridRow uRow = this.ultraPs.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("喷砂实绩无数据!"); return; } UltraGridRow row = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("无工单信息,不允许此操作!"); } if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成") { MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成")) { 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 ultraPs.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { UpdaCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["RESULT_NO"].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.FrmSandBlast"; ccp.MethodName = "unlixianThreadingResult"; ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() }; 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 unOfflineCs() { ultraCs.UpdateData(); UltraGridRow uRow = this.ultraCs.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("车丝实绩无数据!"); return; } UltraGridRow row = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("无工单信息,不允许此操作!"); } if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成") { MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成")) { 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 ultraCs.Rows) { if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true) { UpdaCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["RESULT_NO"].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.CoupThreadingService"; ccp.MethodName = "unlixianThreadingResult"; ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() }; 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 OfflineQg() { string _strat = ""; OffLine frm = new OffLine(); frm.ShowDialog(); LiXian = frm.StrNum; _strat = frm.Strat; if (_strat.Equals("2")) return; if (LiXian.Equals("") || LiXian.Equals("0")) { MessageUtil.ShowTips("离线支数不能为空!"); return; } UltraGridRow row = ultraGrid2.ActiveRow; if (row == null) return; if (row.Cells["ZY_BILL_STATUS"].Value.ToString()=="生产完成") { MessageUtil.ShowTips("此工单状态已生产完成,不允许此操作!"); return; } string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = row.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成")) { 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["WO_ID"].Text.ToString()); list.Add(row.Cells["JUDGE_STOVE_NO"].Text.ToString()); list.Add(row.Cells["BATCH_NO"].Text.ToString()); list.Add(row.Cells["PLINE_CODE"].Text.ToString()); list.Add(row.Cells["ZY_PLAN_ID"].Text.ToString()); list.Add(row.Cells["PLINE_NAME"].Text.ToString()); list.Add(this.UserInfo.GetUserName()); list.Add(this.UserInfo.GetUserOrder()); list.Add(this.UserInfo.GetUserGroup()); list.Add(time); 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, cutGx }; 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 OfflineCs() { string _strat = ""; OffLine frm = new OffLine(); frm.ShowDialog(); LiXian = frm.StrNum; _strat = frm.Strat; if (_strat.Equals("2")) return; if (LiXian.Equals("") || LiXian.Equals("0")) { MessageUtil.ShowTips("离线支数不能为空!"); return; } UltraGridRow row = ultraGrid2.ActiveRow; if (row == null) return; if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成") { MessageUtil.ShowTips("此工单状态已生产完成,不允许此操作!"); return; } string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = row.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成")) { 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["WO_ID"].Text.ToString()); list.Add(row.Cells["JUDGE_STOVE_NO"].Text.ToString()); list.Add(row.Cells["BATCH_NO"].Text.ToString()); list.Add(row.Cells["PLINE_CODE"].Text.ToString()); list.Add(row.Cells["ZY_PLAN_ID"].Text.ToString()); list.Add(row.Cells["PLINE_NAME"].Text.ToString()); list.Add(this.UserInfo.GetUserName()); list.Add(this.UserInfo.GetUserOrder()); list.Add(this.UserInfo.GetUserGroup()); list.Add(time); 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.CoupThreadingService"; //ccp.MethodName = "lixianThreadingResult"; ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService"; ccp.MethodName = "lixianThreadingResult"; ccp.ServerParams = new object[] { list, csGx }; 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 OfflinePs() { string _strat = ""; OffLine frm = new OffLine(); frm.ShowDialog(); LiXian = frm.StrNum; _strat = frm.Strat; if (_strat.Equals("2")) return; if (LiXian.Equals("") || LiXian.Equals("0")) { MessageUtil.ShowTips("离线支数不能为空!"); return; } UltraGridRow row = ultraGrid2.ActiveRow; if (row == null) return; string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = row.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成")) { 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["WO_ID"].Text.ToString()); list.Add(row.Cells["JUDGE_STOVE_NO"].Text.ToString()); list.Add(row.Cells["BATCH_NO"].Text.ToString()); list.Add(row.Cells["PLINE_CODE"].Text.ToString()); list.Add(row.Cells["ZY_PLAN_ID"].Text.ToString()); list.Add(row.Cells["PLINE_NAME"].Text.ToString()); list.Add(this.UserInfo.GetUserName()); list.Add(this.UserInfo.GetUserOrder()); list.Add(this.UserInfo.GetUserGroup()); list.Add(time); 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.CoupThreadingService"; //ccp.MethodName = "lixianThreadingResult"; ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast"; ccp.MethodName = "lixianThreadingResult"; ccp.ServerParams = new object[] { list, PsGx }; 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 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 && string.IsNullOrEmpty(txtWoId.Text.Trim())) { MessageUtil.ShowTips("请输入工单号!"); return; } else { woId = txtWoId.Text.ToString().Trim(); } if (chkPlnNo.Checked && string.IsNullOrEmpty(txtPlnNo.Text.Trim())) { MessageUtil.ShowTips("请输入炉次计划号!"); return; } else { plnNo = txtPlnNo.Text.ToString().Trim(); } if (chkJuNo.Checked && string.IsNullOrEmpty(txtJudgeStoveNO.Text.Trim())) { MessageUtil.ShowTips("请输入炉号!"); return; } else { judgeStoveNo = txtJudgeStoveNO.Text.ToString().Trim(); } #endregion ArrayList list = new ArrayList(); list.Add(woId); list.Add(plnNo); list.Add(judgeStoveNo); list.Add(starts); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoId", new object[] { list, plineCode[0].ToString() }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dtProcessPlan, true); // GridHelper.RefreshAndAutoSize(ultraGridWoId); //string pliNo = ""; //if (cmbCname.SelectedIndex != -1) { pliNo = cmbCname.Value.ToString(); } else { pliNo = ""; } //string judgeStoveNo = this.txtJudgeStoveNO.Text.ToString(); //string batchNo = this.txtBatchNO.Text; //string zYgNo = this.txtLotNo.Text.Trim(); //ArrayList list = new ArrayList(); //list.Add(zYgNo); //list.Add(judgeStoveNo); //list.Add(batchNo); //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.doQueryZygNo", new object[] { list, pliNo }, this.ob); //GridHelper.CopyDataToDatatable(ref dt, ref dtPlan, true); Information(); } private void Information() { string woId = ""; string starts = ""; string judgeStoveNo = ""; string plnNo = ""; ArrayList list = new ArrayList(); list.Add(woId); list.Add(plnNo); list.Add(judgeStoveNo); list.Add(starts); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.ulgetQueryWoId", new object[] { list, plineCode[0].ToString() }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true); GridHelper.RefreshAndAutoSize(ultraGrid3); } private void ultraGrid2_AfterRowActivate(object sender, EventArgs e) { this.ultraGrid2AfterRowActivate(); } /// /// 作业计划详情 /// private void ultraGrid2AfterRowActivate() { UltraGridRow row = ultraGrid2.ActiveRow; ////获取上料实绩 string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = row.Cells["WO_ID"].Value.ToString(); //string plNo = row.Cells["PLINE_CODE"].Value.ToString(); //DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCoupLingById", new object[] { zYgNo, plNo }, this.ob); //GridHelper.CopyDataToDatatable(ref dt1, ref dtLoadRecord, true); //GridHelper.RefreshAndAutoSize(ultraGrid1); //获取计划 getJGCutPlan(zYgNo, woId); #region 切管 //获取机床编号 ArrayList list = new ArrayList(); list.Add(cutGx); list.Add(row.Cells["PLINE_CODE"].Text.ToString()); list.Add(row.Cells["CUT_MACH_GRP_NM"].Text.ToString()); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getMachine", new object[] { list }, this.ob); cmbJcCode.DataSource = dt; cmbJcCode.ValueMember = "MACHINE_NAME"; YdmBaseClass.SetComboItemHeight(cmbJcCode); cmbEmbossed.Text = row.Cells["IF_IMPRESS"].Text.ToString();//压印 #endregion #region 车丝 //获取机床编号 ArrayList list1 = new ArrayList(); list1.Add(csGx); list1.Add(row.Cells["PLINE_CODE"].Text.ToString()); list1.Add(row.Cells["LATHE_GRP_NM"].Text.ToString()); DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupThreadingService.getMachine", new object[] { list1 }, this.ob); txtJcCs.DataSource = dt2; txtJcCs.ValueMember = "MACHINE_NAME"; YdmBaseClass.SetComboItemHeight(txtJcCs); #endregion if (ultraTabControl3.SelectedTab.Key.Equals("0")) { //获取切管实绩 this.getCoupCutResult(zYgNo, woId); } else if (ultraTabControl3.SelectedTab.Key.Equals("1")) { //获取车丝实绩 this.getCoupThreadingResult(zYgNo, woId); } else { //获取喷砂实绩 this.getCoupSandBlast(zYgNo, woId); } } /// /// 机床编号改变事件 /// /// /// ///查询操作工,根据机床编号 private void cmbJcCode_TextChanged(object sender, EventArgs e) { UltraGridRow row = this.ultraGrid2.ActiveRow; if (row == null) return; DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getMachUser", new object[] { cmbJcCode.Text.ToString(), cutGx, row.Cells["PLINE_CODE"].Text.Trim(), row.Cells["CUT_MACH_GRP_NM"].Text.ToString() }, this.ob); cmbOperator.DataSource = dt; cmbOperator.ValueMember = "MACHINE_USER1"; YdmBaseClass.SetComboItemHeight(cmbOperator); } private void txtJcCs_TextChanged(object sender, EventArgs e) { UltraGridRow row = this.ultraGrid2.ActiveRow; if (row == null) return; DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupThreadingService.getMachUser", new object[] { txtJcCs.Text.ToString(), csGx, row.Cells["PLINE_CODE"].Text.Trim(), row.Cells["LATHE_GRP_NM"].Text.ToString() }, this.ob); txtOpeCs.DataSource = dt; txtOpeCs.ValueMember = "MACHINE_USER1"; YdmBaseClass.SetComboItemHeight(txtOpeCs); Operator(); } private void Operator() { UltraGridRow row = this.ultraGrid2.ActiveRow; if (row == null) return; DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupThreadingService.getMachUser1", new object[] { txtJcCs.Text.ToString(), csGx, row.Cells["PLINE_CODE"].Text.Trim(), row.Cells["LATHE_GRP_NM"].Text.ToString() }, this.ob); txtOpeCs1.DataSource = dt; txtOpeCs1.ValueMember = "MACHINE_USER2"; YdmBaseClass.SetComboItemHeight(txtOpeCs1); } private void ultraTabControl3_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { UltraGridRow row = ultraGrid2.ActiveRow; if (row == null) return; string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = row.Cells["WO_ID"].Value.ToString(); if (ultraTabControl3.SelectedTab.Key.Equals("0")) { //获取切管实绩 this.getCoupCutResult(zYgNo, woId); } else if (ultraTabControl3.SelectedTab.Key.Equals("1")) { //获取车丝实绩 this.getCoupThreadingResult(zYgNo, woId); } else { //获取喷砂实绩 this.getCoupSandBlast(zYgNo, woId); } } /// /// 接箍计划详细 /// /// private void getJGCutPlan(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 DoBeside() { if (ultraTabControl3.SelectedTab.Key.Equals("0")) { DoBesideQg(); } else if (ultraTabControl3.SelectedTab.Key.Equals("1")) { DoBesideCs(); } else { DoComplete(); } } /// /// 撤销结炉 /// private void UndoBeside() { if (ultraTabControl3.SelectedTab.Key.Equals("0")) { UndoBesideQg(); } else if (ultraTabControl3.SelectedTab.Key.Equals("1")) { UndoBesideCs(); } else { UnDoComplete(); } } /// /// 保存 /// private void DoSave() { if (ultraTabControl3.SelectedTab.Key.Equals("0")) { DoSaveQg(); } else if (ultraTabControl3.SelectedTab.Key.Equals("1")) { DoSaveCs(); } else { DoSavePs(); } } /// /// 修改 /// private void DoUpdate() { if (ultraTabControl3.SelectedTab.Key.Equals("0")) { DoUpdateQg(); } else if (ultraTabControl3.SelectedTab.Key.Equals("1")) { DoUpdateCs(); } else { DoUpdatePs(); } } /// /// 删除 /// private void DoDelete() { if (ultraTabControl3.SelectedTab.Key.Equals("0")) { DoDeleteQg(); } else if (ultraTabControl3.SelectedTab.Key.Equals("1")) { DoDeleteCs(); } else { DoDeletePs(); } } #region 切管 /// /// 切管结炉 /// private void DoBesideQg() { UltraGridRow uRow = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("请选择需要结炉的作业工单号!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!"); return; } if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单已结炉,不允许此操作!"); return; } ArrayList list = new ArrayList(); list.Add(zYgNo); list.Add(cutGx); list.Add(embGx); list.Add(woId); //list.Add(rouGx); if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService"; ccp.MethodName = "doBeside"; ccp.ServerParams = new object[] { list}; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("结炉成功!")) { QuerySinglePlan(); } } } /// /// 撤销结炉 /// private void UndoBesideQg() { UltraGridRow uRow = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("请选择需要撤销结炉的作业工单号!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (!dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单工序点未结炉,不允许此操作!"); return; } if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单状态生产完成,不允许此操作!"); return; } ArrayList list = new ArrayList(); list.Add(zYgNo); list.Add(cutGx); list.Add(embGx); list.Add(woId); //list.Add(rouGx); if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService"; ccp.MethodName = "undoBeside"; ccp.ServerParams = new object[] { list }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("撤销结炉成功!")) { QuerySinglePlan(); } } } /// /// 查询接箍切断实绩 /// /// private void getCoupCutResult(string planNO,string woId) { DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmPerformanceResult.getCutResultByPlanNo", new object[] { planNO, woId }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true); } /// /// 作业实绩保存 /// private void DoSaveQg() { UltraGridRow uRow = this.ultraGrid2.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["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["IF_ALL_OUT_WORK"].ToString().Equals("是")) { MessageUtil.ShowTips("此工序已经离线,不允许此操作!"); return; } if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!"); return; } if (double.Parse(numQualified.Value.ToString()) < double.Parse(numRejected.Value.ToString())) { MessageUtil.ShowTips("废品个数不能大于切管个数!"); return; } CutResult cut = new CutResult(); cut.MachineNo = cmbJcCode.Text.Trim(); cut.CutPieces = numPieces.Value.ToString(); cut.QualifiedNumber = numQualified.Value.ToString(); cut.RejectedPieces = numRejected.Value.ToString(); cut.RejectedReason = cmbReason.Text.Trim(); cut.LvalidLength = numLength.Value.ToString(); cut.ColOperator = cmbOperator.Text.Trim(); cut.ColShft = txtBC.Value.ToString(); cut.ColGroup = txtBz.Value.ToString(); cut.ColUser = txtUser.Text.ToString(); cut.IsEmbossed = cmbEmbossed.Value.ToString(); cut.EmbCount = numEmbossed.Value.ToString(); cut.EmbContent = txtEmbossed.Text.Trim(); cut.PlanNo = uRow.Cells["ZY_PLAN_ID"].Text.ToString(); cut.PlineCode = uRow.Cells["PLINE_CODE"].Text.ToString(); cut.WoId = uRow.Cells["WO_ID"].Text.ToString(); double PlnCount=0;//计划切割个数 double CutCount=0;//实际切割个数 DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { uRow.Cells["ZY_PLAN_ID"].Text.ToString() }, ob); if (dt1.Rows.Count>0) { PlnCount = Double.Parse(dt1.Rows[0]["CUT_PLN_NUMB"].ToString()); CutCount = Double.Parse(dt1.Rows[0]["CUT_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.CoupCutService"; ccp.MethodName = "addCutResult"; ccp.ServerParams = new object[] { cut, cutGx, embGx }; 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) { if (ccp.ReturnInfo.Equals("保存成功!")) { QuerySinglePlan(); MessageUtil.ShowTips(ccp.ReturnInfo); DoClean(); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 修改 /// private void DoUpdateQg() { ultraCut.UpdateData(); UltraGridRow uRow = this.ultraCut.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("切管实绩无数据!"); return; } if (uRow.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是")) { MessageUtil.ShowTips("此工序已经离线,不允许此操作!"); return; } UltraGridRow row = this.ultraGrid2.ActiveRow; if (row == null) { MessageUtil.ShowTips("无工单信息,不允许此操作!"); } if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成") { MessageUtil.ShowTips("此工单已生产完成,不允许此操作!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!"); return; } if (double.Parse(numQualified.Value.ToString()) < double.Parse(numRejected.Value.ToString())) { MessageUtil.ShowTips("废品个数不能大于切管个数!"); return; } ArrayList list = new ArrayList(); list.Add(uRow.Cells["RESULT_NO"].Text.ToString()); list.Add(uRow.Cells["ZY_PLAN_ID"].Text.ToString()); list.Add(numQualified.Value.ToString());//加工个数 list.Add(numPieces.Value.ToString());//加工支数 list.Add(numRejected.Value.ToString()); list.Add(cmbReason.Text.ToString()); list.Add(txtBC.Value.ToString()); list.Add(txtBz.Value.ToString()); list.Add(cmbJcCode.Text.Trim()); list.Add(numLength.Value.ToString()); list.Add(cmbOperator.Text.Trim()); list.Add(txtEmbossed.Text.Trim()); list.Add(numEmbossed.Value.ToString()); list.Add(uRow.Cells["WO_ID"].Text.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]["CUT_PLN_NUMB"].ToString()); CutCount = Double.Parse(dt1.Rows[0]["CUT_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.FrmPerformanceResult"; ccp.MethodName = "updateCutResult"; ccp.ServerParams = new object[] { list, cutGx, embGx, row.Cells["ZY_PLAN_ID"].Text.ToString() }; 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 DoDeleteQg() { ultraCut.UpdateData(); UltraGridRow uRow = this.ultraCut.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("切管实绩无数据!"); return; } UltraGridRow row = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("无工单信息,不允许此操作!"); } if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成") { MessageUtil.ShowTips("此工单已生产完成,不允许此操作!"); return; } string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = row.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["CUT_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!"); return; } ArrayList list1 = new ArrayList(); int UpdaCount = 0; foreach (UltraGridRow ugr in ultraCut.Rows) { if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true) { if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是")) { MessageUtil.ShowTips("此工序已经离线,不允许此操作!"); return; } UpdaCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["RESULT_NO"].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 = "deleteCutResult"; ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() }; 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 ultraGrid4_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { try { ultraPs.UpdateData(); foreach (UltraGridRow row in ultraCut.Rows) { row.Cells["CHECK"].Value = row.Selected; } } catch { } } /// /// 是否压印 /// /// /// private void cmbEmbossed_TextChanged(object sender, EventArgs e) { if (cmbEmbossed.Text.Equals("是")) { numEmbossed.Enabled = true; txtEmbossed.Enabled = true; } else { numEmbossed.Enabled = false; txtEmbossed.Enabled = false; } } /// /// 废品 /// /// /// private void numRejected_ValueChanged(object sender, EventArgs e) { if (numRejected.Value.ToString().Equals("0")) { cmbReason.Enabled = false; } else { cmbReason.Enabled = true; } } private void DoClean() { cmbJcCode.Text = ""; cmbOperator.Text = ""; numPieces.Value = 0; numQualified.Value = 0; numRejected.Value = 0; cmbReason.Text = ""; txtBC.Value = this.UserInfo.GetUserOrder(); txtBz.Value = this.UserInfo.GetUserGroup(); numLength.Value = 0; numEmbossed.Value = 0; txtEmbossed.Text = ""; } private void numQualified_ValueChanged(object sender, EventArgs e) { if (cmbEmbossed.Text.ToString().Equals("是")) { numEmbossed.Value = numQualified.Value.ToString(); } } #endregion #region 车丝 /// /// 车丝实绩保存 /// private void DoSaveCs() { UltraGridRow urg = this.ultraGrid2.ActiveRow; if (urg == null) { MessageUtil.ShowTips("无工单信息,不允许此操作!"); return; } if (urg.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成") { MessageUtil.ShowTips("此工单已生产完成,不允许此操作!"); return; } string zYgNo = urg.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = urg.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!"); return; } if (Convert.ToInt32(numCsCount.Value.ToString()) != Convert.ToInt32(numCsHg.Value.ToString()) + Convert.ToInt32(numCsFp.Value.ToString())) { MessageBox.Show("车丝个数=合格个数+废品个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } ThreadingResult result = new ThreadingResult(); result.PlanNo = urg.Cells["ZY_PLAN_ID"].Value.ToString(); result.PlineCode = urg.Cells["PLINE_CODE"].Value.ToString(); result.ColGroup = txtCsBz.Value.ToString(); result.ColShft = txtCsBc.Value.ToString(); result.ColUser = txtUserCs.Text.ToString(); result.MachineNo = txtJcCs.Text.ToString(); result.ProducedPcs = numCsCount.Value.ToString(); result.Producer = cmbCsProducer.Text.ToString(); result.WoId = urg.Cells["WO_ID"].Value.ToString(); if (cmbCsProducer.Text.ToString().Trim().Equals("")) { result.ProducerTime = ""; } else { result.ProducerTime = ProducerTimeCs.Value.ToString(); } result.ColOperator1 = txtOpeCs.Text.ToString(); result.ColOperator2 = txtOpeCs1.Text.ToString(); result.QualiriedPcs = numCsHg.Value.ToString(); result.RejectedPieces = numCsFp.Value.ToString(); result.RejectedReason = txtCsFp.Text.ToString(); double PlnCount = 0;//计划个数 double CutCount = 0;//实际个数 DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { urg.Cells["ZY_PLAN_ID"].Text.ToString() }, ob); if (dt1.Rows.Count > 0) { PlnCount = Double.Parse(dt1.Rows[0]["LATHE_PLN_NUM"].ToString()); CutCount = Double.Parse(dt1.Rows[0]["LATHE_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.CoupThreadingService"; ccp.MethodName = "addThreadingResult"; ccp.ServerParams = new object[] { result, csGx }; 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 DoUpdateCs() { ultraCs.UpdateData(); UltraGridRow uRow = this.ultraCs.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("车丝实绩无数据!"); return; } if (uRow.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是")) { MessageUtil.ShowTips("此工序已经离线,不允许此操作!"); return; } UltraGridRow row = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("无工单信息,不允许此操作!"); } if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成") { MessageUtil.ShowTips("此工单已生产完成,不允许此操作!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!"); return; } ArrayList list = new ArrayList(); if (Convert.ToInt32(numCsCount.Value.ToString()) != Convert.ToInt32(numCsHg.Value.ToString()) + Convert.ToInt32(numCsFp.Value.ToString())) { MessageBox.Show("车丝个数=合格个数+废品个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } list.Add(uRow.Cells["RESULT_NO"].Text.ToString()); list.Add(uRow.Cells["ZY_PLAN_ID"].Text.ToString()); list.Add(numCsCount.Value.ToString()); list.Add(numCsHg.Value.ToString()); list.Add(numCsFp.Text.Trim().ToString()); list.Add(txtCsFp.Text.ToString()); list.Add(txtCsBc.Value.ToString()); list.Add(txtCsBz.Value.ToString()); list.Add(txtJcCs.Text.ToString()); list.Add(txtOpeCs.Text.ToString()); list.Add(txtOpeCs1.Text.ToString()); list.Add(cmbCsProducer.Text.ToString()); if (cmbCsProducer.Text.ToString().Equals("")) { list.Add(""); } else { list.Add(ProducerTimeCs.Value.ToString()); } list.Add(uRow.Cells["WO_ID"].Text.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]["LATHE_PLN_NUM"].ToString()); CutCount = Double.Parse(dt1.Rows[0]["LATHE_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.FrmPerformanceResult"; ccp.MethodName = "updateThreadingResult"; ccp.ServerParams = new object[] { list, csGx, row.Cells["ZY_PLAN_ID"].Text.ToString() }; 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 DoDeleteCs() { ultraGrid2.UpdateData(); UltraGridRow uRow = this.ultraCs.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("车丝实绩无数据!"); return; } UltraGridRow row = this.ultraGrid2.ActiveRow; if (row == null) { MessageUtil.ShowTips("无工单信息,不允许此操作!"); } if (row.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成") { MessageUtil.ShowTips("此工单已生产完成,不允许此操作!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!"); return; } ArrayList list1 = new ArrayList(); int UpdaCount = 0; foreach (UltraGridRow ugr in ultraCs.Rows) { if (Convert.ToBoolean(ugr.Cells["CHECK"].Text) == true) { if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是")) { MessageUtil.ShowTips("此工序已经离线,不允许此操作!"); return; } UpdaCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["RESULT_NO"].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.CoupThreadingService"; ccp.MethodName = "deleteThreadingResult"; ccp.ServerParams = new object[] { list1, row.Cells["ZY_PLAN_ID"].Text.ToString(), csGx, row.Cells["WO_ID"].Text.ToString() }; 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 DoBesideCs() { UltraGridRow uRow = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("请选择需要结炉的工单信息!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单车丝工序点已结炉,不允许此操作!"); return; } if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单已结炉,不允许此操作!"); return; } ArrayList list = new ArrayList(); list.Add(zYgNo); list.Add(csGx); list.Add(woId); if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService"; ccp.MethodName = "doBeside"; ccp.ServerParams = new object[] { list }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("结炉成功!")) { QuerySinglePlan(); } } } /// /// 撤销结炉 /// private void UndoBesideCs() { UltraGridRow uRow = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("请选择需要撤销结炉的工单信息!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (!dt.Rows[0]["LATHE_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单车丝工序点未结炉,不允许此操作!"); return; } if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单已结炉,不允许此操作!"); return; } ArrayList list = new ArrayList(); list.Add(zYgNo); list.Add(csGx); list.Add(woId); if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.CoupThreadingService"; ccp.MethodName = "undoBeside"; ccp.ServerParams = new object[] { list }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("撤销结炉成功!")) { QuerySinglePlan(); } } } /// /// 车丝实绩查询 /// /// private void getCoupThreadingResult(string planNo, string woId) { DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmPerformanceResult.getThreadingResult", new object[] { planNo, woId }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dtSelfChecked, true); } private void ultraCs_AfterRowActivate(object sender, EventArgs e) { UltraGridRow ugr = ultraCs.ActiveRow; if (ugr == null) return; if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("否")) { numCsCount.Value = ugr.Cells["PRODUCED_PCS"].Value.ToString(); numCsHg.Value = ugr.Cells["QUALIRIED_PCS"].Value.ToString(); numCsFp.Value = ugr.Cells["REJECTED_PCS"].Value.ToString(); txtCsFp.Text = ugr.Cells["REJECTED_REASON"].Value.ToString(); txtCsBc.Text = ugr.Cells["COL_SHIFT"].Value.ToString(); txtCsBz.Text = ugr.Cells["COL_GROUP"].Value.ToString(); txtJcCs.Text = ugr.Cells["MACHINE_NO"].Value.ToString(); txtOpeCs.Text = ugr.Cells["COL_OPERATOR1"].Value.ToString(); txtOpeCs1.Text = ugr.Cells["COL_OPERATOR2"].Value.ToString(); cmbCsProducer.Text = ugr.Cells["PRODUCER"].Value.ToString(); } if (!ugr.Cells["PRODUCER"].Value.ToString().Equals("")) { ProducerTimeCs.Value = DateTime.Parse(ugr.Cells["PRODUCER_TIME"].Value.ToString()); } } private void numCsFp_ValueChanged(object sender, EventArgs e) { if (numCsFp.Value.ToString().Equals("0")) { txtCsFp.Enabled = false; } else { txtCsFp.Enabled = true; } } #endregion #region 喷标 /// /// 查询喷砂实绩 /// /// private void getCoupSandBlast(string planNo, string woId) { DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmPerformanceResult.getCoupSandBlast", new object[] { planNo, woId }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dataTable4, true); } /// /// 保存 /// private void DoSavePs() { UltraGridRow row = this.ultraGrid2.ActiveRow; if (row == null) { MessageUtil.ShowTips("无工单信息,不允许此操作!"); return; } string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = row.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!"); return; } if (row.Cells["ZY_BILL_STATUS"].Value.ToString().Equals("生产完成")) { MessageUtil.ShowTips("此炉次计划号整体已生产完成,不允许此操作!"); return; } if (row.Cells["IF_OUT_BLAST"].Text.ToString().Equals("无喷砂")) { MessageUtil.ShowTips("不需要进行此工序!"); return; } if (Convert.ToInt32(numCountPs.Value.ToString()) != Convert.ToInt32(numHgPs.Value.ToString()) + Convert.ToInt32(numFpPs.Value.ToString())) { MessageBox.Show("喷标个数=合格个数+废品总个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } CouplingSandblastResultEntity sand = new CouplingSandblastResultEntity(); sand.SprayCount = numCountPs.Value.ToString(); sand.QualiriedPcs = numHgPs.Value.ToString(); sand.RejectedPcs = numFpPs.Value.ToString(); sand.RejectedReason = cmbFpPs.Text.Trim(); sand.SprayMaterial = cmbPsSpray.Text.ToString(); sand.ColOperator = txtOpePs.Text.Trim(); sand.ColShift = txtPsbc.Value.ToString(); sand.ColGroup = txtPsbz.Value.ToString(); sand.ColUser = txtUserPs.Text.ToString(); sand.SprayThick = numCZDPs.Value.ToString(); sand.SprayEquipment = cmbPsEquipment.Text.ToString(); sand.SprayPressure = numPsPressure.Value.ToString(); sand.Memo = txtPsMemo.Text.ToString(); //sand.IfAllOutWork = row.Cells["IF_ALL_OUT_WORK"].Text.ToString(); sand.ZyPlanId = row.Cells["ZY_PLAN_ID"].Text.ToString(); sand.PlineCode = row.Cells["PLINE_CODE"].Text.ToString(); sand.WoId = row.Cells["WO_ID"].Text.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]["BLAST_PLN_NUM"].ToString()); CutCount = Double.Parse(dt1.Rows[0]["BLAST_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.FrmSandBlast"; ccp.MethodName = "addSandResult"; ccp.ServerParams = new object[] { sand, PsGx }; 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 DoUpdatePs() { UltraGridRow row = this.ultraGrid2.ActiveRow; if (row == null) { MessageUtil.ShowTips("无工单信息,不允许此操作!"); return; } UltraGridRow urg = this.ultraPs.ActiveRow; if (urg == null) { MessageUtil.ShowTips("无接箍喷砂实绩,不允许此操作!"); return; } if (urg.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是")) { MessageUtil.ShowTips("此工序已经离线,不允许此操作!"); return; } string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = row.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!"); return; } string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (Convert.ToInt32(numPieces.Value.ToString()) != Convert.ToInt32(numQualified.Value.ToString()) + Convert.ToInt32(numRejected.Value.ToString())) { MessageBox.Show("喷标个数=合格个数+废品总个数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } string resNo = ""; if (Convert.ToBoolean(urg.Cells["CHK"].Text) == true) { resNo = urg.Cells["RESULT_NO"].Text.ToString(); } else { } CouplingSandblastResultEntity sand = new CouplingSandblastResultEntity(); sand.SprayCount = numCountPs.Value.ToString(); sand.QualiriedPcs = numHgPs.Value.ToString(); sand.RejectedPcs = numFpPs.Value.ToString(); sand.RejectedReason = cmbFpPs.Text.Trim(); sand.SprayMaterial = cmbPsSpray.Text.ToString(); sand.ColOperator = txtOpePs.Text.Trim(); sand.ColShift = txtPsbc.Value.ToString(); sand.ColGroup = txtPsbz.Value.ToString(); sand.SprayThick = numCZDPs.Value.ToString(); sand.SprayEquipment = cmbPsEquipment.Text.ToString(); sand.SprayPressure = numPsPressure.Value.ToString(); sand.Memo = txtPsMemo.Text.ToString(); sand.UpdateName = this.UserInfo.GetUserName(); sand.UpdateTime = time; //sand.IfAllOutWork = row.Cells["IF_ALL_OUT_WORK"].Text.ToString(); sand.ZyPlanId = urg.Cells["ZY_PLAN_ID"].Text.ToString(); sand.PlineCode = urg.Cells["PLINE_CODE"].Text.ToString(); sand.ResultNo = urg.Cells["RESULT_NO"].Text.ToString(); sand.WoId = urg.Cells["WO_ID"].Text.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]["BLAST_PLN_NUM"].ToString()); CutCount = Double.Parse(dt1.Rows[0]["BLAST_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.FrmSandBlast"; ccp.MethodName = "updateSandResult"; ccp.ServerParams = new object[] { sand, PsGx }; 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 DoDeletePs() { UltraGridRow uRow = this.ultraPs.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("喷砂实绩无数据!"); return; } UltraGridRow row = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("无工单信息,不允许此操作!"); } string zYgNo = row.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = row.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!"); return; } ArrayList list1 = new ArrayList(); int UpdaCount = 0; foreach (UltraGridRow ugr in ultraPs.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是")) { MessageUtil.ShowTips("此工序已经离线,不允许此操作!"); return; } UpdaCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["RESULT_NO"].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.FrmSandBlast"; ccp.MethodName = "deleteSandResult"; ccp.ServerParams = new object[] { list1, PsGx, row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() }; 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 DoComplete() { UltraGridRow uRow = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("请选择需要结炉的作业工单号!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单喷砂工序点已结炉,不允许此操作!"); return; } if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单已结炉,不允许此操作!"); return; } ArrayList list = new ArrayList(); list.Add(zYgNo); list.Add(PsGx); list.Add(woId); if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast"; ccp.MethodName = "doBeside"; ccp.ServerParams = new object[] { list }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("结炉成功!")) { QuerySinglePlan(); } } } /// /// 撤销结炉 /// private void UnDoComplete() { UltraGridRow uRow = this.ultraGrid2.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("请选择需要结炉的作业工单号!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob); if (!dt.Rows[0]["BLAST_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单喷砂工序点未结炉,不允许此操作!"); return; } if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成")) { MessageUtil.ShowTips("此工单已结炉,不允许此操作!"); return; } ArrayList list = new ArrayList(); list.Add(zYgNo); list.Add(PsGx); list.Add(woId); if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.FrmSandBlast"; ccp.MethodName = "undoBeside"; ccp.ServerParams = new object[] { list }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("撤销结炉成功!")) { QuerySinglePlan(); } } } private void numFpPs_ValueChanged(object sender, EventArgs e) { } private void ultraPs_AfterRowActivate(object sender, EventArgs e) { UltraGridRow ugr = this.ultraPs.ActiveRow; if (ugr == null) return; if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("否")) { numCountPs.Value = ugr.Cells["SPRAY_COUNT"].Text.ToString(); numHgPs.Value = ugr.Cells["QUALIRIED_PCS"].Text.ToString(); numFpPs.Value = ugr.Cells["REJECTED_PCS"].Text.ToString(); cmbFpPs.Text = ugr.Cells["REJECTED_REASON"].Text.ToString(); cmbPsSpray.Text = ugr.Cells["SPRAY_MATERIAL"].Text.ToString(); txtOpePs.Text = ugr.Cells["COL_OPERATOR"].Text.ToString(); txtPsbc.Text = ugr.Cells["COL_SHIFT"].Value.ToString(); txtPsbz.Text = ugr.Cells["COL_GROUP"].Value.ToString(); txtUserPs.Text = ugr.Cells["COL_USER"].Text.ToString(); numCZDPs.Value = ugr.Cells["SPRAY_THICK"].Text.ToString(); cmbPsEquipment.Text = ugr.Cells["SPRAY_EQUIPMENT"].Text.ToString(); numPsPressure.Value = ugr.Cells["SPRAY_PRESSURE"].Text.ToString(); txtPsMemo.Text = ugr.Cells["MEMO"].Text.ToString(); } else { DoClean(); } } #endregion /// /// 按回车键触发查询按钮 /// /// /// private void ContPublic_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { QuerySinglePlan(); } } 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 ultraCut_AfterRowActivate(object sender, EventArgs e) { UltraGridRow uRow = this.ultraCut.ActiveRow; if (uRow == null) return; if (uRow.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("否")) { cmbJcCode.Text = uRow.Cells["MACHINE_NO"].Value.ToString(); numPieces.Value = uRow.Cells["CUT_PIECES"].Value.ToString(); numQualified.Value = uRow.Cells["QUALIFIED_NUMBER"].Value.ToString(); numRejected.Value = uRow.Cells["REJECTED_PCS"].Value.ToString(); cmbReason.Text = uRow.Cells["REJECTED_REASON"].Value.ToString(); numLength.Value = uRow.Cells["LVALID_LENGTH"].Value.ToString(); cmbOperator.Text = uRow.Cells["COL_OPERATOR"].Value.ToString(); txtBC.Text = uRow.Cells["COL_SHIFT"].Value.ToString(); txtBz.Text = uRow.Cells["COL_GROUP"].Value.ToString(); txtUser.Text = uRow.Cells["COL_USER"].Value.ToString(); cmbEmbossed.Value = uRow.Cells["IS_EMBOSSED"].Value.ToString(); numEmbossed.Value = uRow.Cells["EMB_COUNT"].Value.ToString(); txtEmbossed.Text = uRow.Cells["EMB_CONTENT"].Value.ToString(); } } } }