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 Core.Mes.Client.Comm.Server; using CoreFS.CA06; using System.Collections; using Core.Mes.Client.Comm.Control; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Tool; using Infragistics.Win; using Infragistics.Win.UltraWinEditors; using Core.StlMes.Client.Mcp.Entity; using Core.StlMes.Client.Mcp.Control; namespace Core.StlMes.Client.Mcp.Coupling { public partial class FrmCouplingConfirm : FrmBase { public FrmCouplingConfirm() { InitializeComponent(); this.IsLoadUserView = true; } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "DoQuery": DoQuery(); break; case "Confirm": Confirm(); break; case "CancelConfirm": cancelConfirm(); break; case "DoDelete": DoDelete(); break; case "Export": GridHelper.ulGridToExcel(ultraGrid1, "接箍入库确认"); break; case "DoClose": this.Close(); break; } } /// /// 查询 /// private void DoQuery() { string[] starts = { }; string woId = "";//工单号 string judgeStoveNo = "";//炉号 string txtShift = "";//班次 string txtConfirm = "";//是否确认 string startTim = ""; string endTim = ""; #region 条件 if (chkTim2.Checked) { if (DateTime.Parse(this.StartTime.Value.ToString()) > DateTime.Parse(EndTime.Value.ToString())) { MessageUtil.ShowTips("选择的前面时间不能大于后面的时间!"); return; } else { startTim = this.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } } 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(); } } if (chkJuNo.Checked) { if (chkJuNo.Checked && string.IsNullOrEmpty(txtJudgeStoveNO.Text.Trim())) { MessageUtil.ShowTips("请输入炉号!"); return; } else { judgeStoveNo = txtJudgeStoveNO.Text.ToString().Trim(); } } if (chkshift.Checked) { if (chkshift.Checked && string.IsNullOrEmpty(shift.Text.Trim())) { MessageUtil.ShowTips("请输入班次!"); return; } else { if (string.IsNullOrEmpty(shift.Text.Trim())) { txtShift = ""; } else { txtShift = shift.Value.ToString().Trim(); } } } if (chkconfirm.Checked && string.IsNullOrEmpty(confirm.Text.Trim())) { MessageUtil.ShowTips("请选择是否确认!"); return; } else { if(confirm.Text.ToString().Trim().Equals("确认")) { txtConfirm = "1"; } else if (confirm.Text.ToString().Trim().Equals("未确认")) { txtConfirm = "0"; } else { txtConfirm = ""; } } #endregion List listSource1 = EntityHelper.GetData ("com.steering.mes.mcp.coup.PhosphateResultService.getphosInResult", new object[] { startTim, endTim,starts, woId, judgeStoveNo, txtShift, txtConfirm }, this.ob); couplingbindingSource.DataSource = listSource1; GridHelper.RefreshAndAutoSize(ultraGrid1); foreach (UltraGridRow urg in ultraGrid1.Rows) { if (urg.Cells["Matconfirm"].Value.Equals("确认")) { urg.Appearance.BackColor = Color.LightGreen; } } } /// /// 确认 /// private void Confirm() { ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("无数据!"); return; } ArrayList list1 = new ArrayList(); int UpdaCount = 0; foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { if (ugr.Cells["Matconfirm"].Value.ToString().Equals("1")) { MessageUtil.ShowTips("选中有已确认实绩,不允许再次确认!"); return; } string firm = ""; string shift = ""; if (ugr.Cells["Matconfirm"].Value.ToString().Equals("确认")) { firm = "1"; } else { firm = "0"; } if (ugr.Cells["ColShift"].Value.ToString().Equals("早班")) { shift = "1"; } else if (ugr.Cells["ColShift"].Value.ToString().Equals("中班")) { shift = "2"; } else if (ugr.Cells["ColShift"].Value.ToString().Equals("晚班")) { shift = "3"; } else { shift = "4"; } UpdaCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["WoId"].Text.ToString()); list.Add(shift); list.Add(ugr.Cells["JudgeStoveNo"].Value.ToString()); list.Add(ugr.Cells["BatchNo"].Value.ToString()); list.Add(firm); list.Add(UserInfo.GetUserName()); list.Add(DateTime.Now.ToString()); list.Add(ugr.Cells["CreateTime"].Value.ToString()); //list.Add(ugr.Cells[""]) 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.PhosphateResultService"; ccp.MethodName = "getMatConfirm"; 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("确认成功!")) { DoQuery(); } } } /// /// 取消确认 /// private void cancelConfirm() { ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("无数据!"); return; } ArrayList list1 = new ArrayList(); int UpdaCount = 0; foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { if (ugr.Cells["Matconfirm"].Value.ToString().Equals("0")) { MessageUtil.ShowTips("选中有没确认实绩,不允许取消确认!"); return; } UpdaCount += 1; string firm = ""; string shift = ""; if (ugr.Cells["Matconfirm"].Value.ToString().Equals("确认")) { firm = "1"; } else { firm = "0"; } if (ugr.Cells["ColShift"].Value.ToString().Equals("早班")) { shift = "1"; } else if (ugr.Cells["ColShift"].Value.ToString().Equals("中班")) { shift = "2"; } else { shift = "3"; } ArrayList list = new ArrayList(); list.Add(ugr.Cells["WoId"].Text.ToString()); list.Add(shift); list.Add(ugr.Cells["JudgeStoveNo"].Value.ToString()); list.Add(ugr.Cells["BatchNo"].Value.ToString()); list.Add(firm); list.Add(UserInfo.GetUserName()); list.Add(DateTime.Today.ToString()); list.Add(ugr.Cells["CreateTime"].Value.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.PhosphateResultService"; ccp.MethodName = "getCancelMatConfirm"; 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("取消确认成功!")) { DoQuery(); } } } /// /// 修改 /// private void DoUpdate() { ultraGrid1.UpdateData(); int updateCount = 0; ArrayList list1 = new ArrayList(); string dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string flag = ""; foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { flag = "1"; if (ugr.Cells["MACHINE_NO"].Text.Trim().Equals("")) { MessageUtil.ShowTips("请输入机床编号!"); return; } updateCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["MACHINE_NO"].Text.ToString()); list.Add(this.UserInfo.GetUserName()); list.Add(dtime); list.Add(ugr.Cells["MACHINE_NO"].Value.ToString()); list.Add(ugr.Cells["MACHINE_NO"].Value.ToString()); list1.Add(list); } } ArrayList list2 = new ArrayList(); foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { flag = "2"; updateCount += 1; UltraGridRow row = ultraGrid1.ActiveRow; if (row == null) { MessageUtil.ShowTips("机床信息不能为空"); return; } ArrayList list = new ArrayList(); if (ugr.Cells["PRO_BZ"].Text.ToString().Equals("")) { MessageUtil.ShowTips("班组不能为空"); return; } list.Add(row.Cells["MACHINE_NO"].Value.ToString()); //list.Add(row.Cells["PLINE_NO"].Value.ToString()); list.Add("700305"); list.Add(ugr.Cells["MACHINE_USER1"].Text.Trim().ToString()); list.Add(ugr.Cells["MACHINE_USER2"].Text.Trim().ToString()); list.Add(ugr.Cells["PRO_BZ"].Value.ToString()); list.Add(this.UserInfo.GetUserName()); list.Add(dtime); list.Add(ugr.Cells["ID"].Value.ToString()); list2.Add(list); } } if (updateCount == 0) { MessageUtil.ShowTips("请选择修改数据!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否修改?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.FrmMachine"; ccp.MethodName = "getUpdatePhosphateItem"; ccp.ServerParams = new object[] { list1, list2, flag }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { DoQuery(); } } /// /// 删除 /// private void DoDelete() { ultraGrid1.UpdateData(); int updateCount = 0; ArrayList list1 = new ArrayList(); ArrayList list2 = new ArrayList(); string flag = ""; foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { flag = "1"; updateCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["MACHINE_NO"].Value.ToString()); //list.Add(ugr.Cells["PLINE_NO"].Value.ToString()); list.Add("700305"); list1.Add(list); } } foreach (UltraGridRow ugr in ultraGrid1.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true) { flag = "2"; updateCount += 1; ArrayList list = new ArrayList(); list.Add(ugr.Cells["ID"].Value.ToString()); list2.Add(list); } } if (updateCount == 0) { MessageUtil.ShowTips("请选择要删除的数据!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否删除?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.FrmMachine"; ccp.MethodName = "getDeletePhosphateItem"; ccp.ServerParams = new object[] { list1,list2, flag }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("删除成功!")) { DoQuery(); } } private void FrmCouplingConfirm_Load(object sender, EventArgs e) { EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); PipeManageClass.setUltraGridColumnInput(ultraGrid1, new string[] { "LhNum" });//支数 this.IsLoadUserView = true; } 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 (chkshift.Checked) { shift.Enabled = true; } else { shift.Enabled = false; } if (chkwoId.Checked) { txtWoId.Enabled = true; } else { txtWoId.Enabled = false; } } } }