using com.steering.mes.mcp.entity; using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Mcp.CollarMaterial; using Core.StlMes.Client.Mcp.Common; using Core.StlMes.Client.Mcp.Control; using Core.StlMes.Client.Mcp.Entity; using CoreFS.CA06; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; 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; namespace Core.StlMes.Client.Mcp.Coupling { public partial class FrmInLibrary : FrmBase { private string departm = "";//获取部门ID private string[] plineCode = null;//获取产线代码 private string cutGx = "";//交库工序 public FrmInLibrary() { InitializeComponent(); this.IsLoadUserView = true; } private void FrmInLibrary_Load(object sender, EventArgs e) { departm = UserInfo.GetDeptid(); plineCode = McpBaseHelper.GetPCodePline(departm, this.ob); //获取交库工序 DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700313" }, this.ob); if (dt2.Rows.Count > 0) { cutGx = dt2.Rows[0]["BASECODE"].ToString(); } PipeManageClass.BindComBaseInfo(cmbStroage, this.ob); EntityHelper.ShowGridCaption(ultraGrid2.DisplayLayout.Bands[0]); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "DoQuery": QuerySinglePlan();//查询计划 break; //case "MatQuery": // DoMatQuery();//材料查询 // break; case "DoSave": DoSave(); break; case "DoUpdate": DoUpdate();//库位修改 break; case "DoDelete": DoDelete(); break; case "DoBeside"://结炉 DoBeside(); break; case "UndoBeside"://撤销结炉 UndoBeside(); break; case "DoApply"://申请判定 DoApply(); break; case "UndoApply"://撤销申请 UndoApply(); break; case "DoClose": this.Close(); break; } } /// /// 申请判定 /// private void DoApply() { string piece = ""; ultraGrid3.UpdateData(); UltraGridRow row = ultraGrid1.ActiveRow; if (row == null) return; UltraGridRow urg = ultraGrid3.ActiveRow; if (urg == null) { MessageUtil.ShowTips("无交库信息!"); return; } int addCount = 0; ArrayList list = new ArrayList(); string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); foreach (UltraGridRow uRow in ultraGrid3.Rows) { if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true) { addCount += 1; ArrayList list1 = new ArrayList(); list1.Add(uRow.Cells["DEAL_ORDE"].Value.ToString()); list1.Add(uRow.Cells["WO_ID"].Value.ToString()); list1.Add(uRow.Cells["ZY_PLAN_ID"].Value.ToString()); list1.Add(uRow.Cells["JUDGE_STOVE_NO"].Value.ToString()); list1.Add(uRow.Cells["BATCH_NO"].Value.ToString()); list1.Add(this.UserInfo.GetUserName()); list1.Add(uRow.Cells["PIECES"].Value.ToString()); list1.Add(time); list1.Add(uRow.Cells["PLINE_CODE"].Text.ToString()); list.Add(list1); if (uRow.Cells["PIECES"].Value.ToString()=="") { uRow.Cells["PIECES"].Value = "0"; } piece = uRow.Cells["PIECES"].Value.ToString(); } } if (addCount == 0) { MessageUtil.ShowTips("请选择要申请判定的交库信息!"); return; } else { if (piece != row.Cells["SJ_NUM"].Text.ToString()) { 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.FrmInLibrary"; ccp.MethodName = "doApplyResult"; ccp.ServerParams = new object[] { list }; 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 UndoApply() { ultraGrid3.UpdateData(); UltraGridRow urg = ultraGrid3.ActiveRow; if (urg == null) { MessageUtil.ShowTips("无交库信息!"); return; } int addCount = 0; ArrayList list = new ArrayList(); foreach (UltraGridRow uRow in ultraGrid3.Rows) { if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true) { addCount += 1; ArrayList list1 = new ArrayList(); list1.Add(uRow.Cells["DEAL_ORDE"].Value.ToString()); list1.Add(uRow.Cells["WO_ID"].Value.ToString()); list1.Add(uRow.Cells["ZY_PLAN_ID"].Value.ToString()); list1.Add(uRow.Cells["JUDGE_STOVE_NO"].Value.ToString()); list1.Add(uRow.Cells["BATCH_NO"].Value.ToString()); list1.Add(this.UserInfo.GetUserName()); list1.Add(uRow.Cells["PIECES"].Value.ToString()); list1.Add(uRow.Cells["PLINE_CODE"].Text.ToString()); list.Add(list1); } } if (addCount == 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.FrmInLibrary"; ccp.MethodName = "undoApplyResult"; ccp.ServerParams = new object[] { list }; 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 DoUpdate() { ultraGrid3.UpdateData(); UltraGridRow urg = ultraGrid3.ActiveRow; if (urg == null) { MessageUtil.ShowTips("无库存信息!"); return; } int addCount = 0; ArrayList list = new ArrayList(); string date = DateTime.Now.ToString(); foreach (UltraGridRow uRow in ultraGrid3.Rows) { if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true) { addCount += 1; if (uRow.Cells["KEP_NO"].Text.Trim() == "") { MessageUtil.ShowTips("框号不能为空!"); return; } if (uRow.Cells["STORAGE_NO"].Text.Trim() == "") { MessageUtil.ShowTips("库位不能空!"); return; } ArrayList list1 = new ArrayList(); list1.Add(uRow.Cells["MAT_NO"].Value.ToString()); list1.Add(uRow.Cells["ZY_PLAN_ID"].Value.ToString()); list1.Add(uRow.Cells["RESULT_NO"].Value.ToString()); list1.Add(uRow.Cells["KEP_NO"].Value.ToString()); list1.Add(uRow.Cells["STORAGE_NO"].Value.ToString()); list1.Add(this.UserInfo.GetUserName()); list1.Add(date); list.Add(list1); } } if (addCount == 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.FrmInLibrary"; ccp.MethodName = "updateLibraryResult"; ccp.ServerParams = new object[] { list}; 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 DoMatQuery() { string woId = ""; string judgeStoveNo = ""; string plnNo = ""; #region 条件 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); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmInLibrary.doQueryMatNo", new object[] { list, plineCode[0].ToString() }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dateMat, true); } private void QuerySinglePlan() { string woId = ""; string judgeStoveNo = ""; string plnNo = ""; #region 条件 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); DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmInLibrary.doQueryZygNo", new object[] { list,plineCode[0].ToString() }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dataTable3, true); //DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmInLibrary.doQueryMatNo", new object[] { list, plineCode[0].ToString() }, this.ob); //GridHelper.CopyDataToDatatable(ref dt1, ref dataTable2, true); } /// /// 编辑区Gird /// /// /// private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { UltraGridRow row = ultraGrid1.ActiveRow; if (row == null) return; ultraGrid1.UpdateData(); if (e.Cell.Column.Key.Equals("FAIL_CUT_NUM")) { if(e.Cell.Row.Cells["FAIL_CUT_NUM"].Text.ToString().Trim()=="") { e.Cell.Row.Cells["FAIL_CUT_NUM"].Value = "0"; } if (double.Parse(e.Cell.Row.Cells["FAIL_CUT_NUM"].Value.ToString()) > double.Parse(e.Cell.Row.Cells["PLAN_JG_NUM"].Value.ToString())) { MessageUtil.ShowTips("废品个数不能大于计划个数!"); e.Cell.Row.Cells["FAIL_CUT_NUM"].Value = e.Cell.Row.Cells["PLAN_JG_NUM"].Value.ToString(); return; } e.Cell.Row.Cells["LL_NUM"].Value = double.Parse(e.Cell.Row.Cells["PLAN_JG_NUM"].Value.ToString()) - double.Parse(e.Cell.Row.Cells["FAIL_CUT_NUM"].Value.ToString()); e.Cell.Row.Cells["CLC_NUM"].Value = double.Parse(e.Cell.Row.Cells["PLAN_JG_NUM"].Value.ToString()) - double.Parse(e.Cell.Row.Cells["FAIL_CUT_NUM"].Value.ToString()) - double.Parse(e.Cell.Row.Cells["SJ_NUM"].Value.ToString()); } if (e.Cell.Column.Key.Equals("SPRAY_COUNT")) { if (e.Cell.Row.Cells["SPRAY_COUNT"].Text.ToString().Trim() == "") { e.Cell.Row.Cells["SPRAY_COUNT"].Value = "0"; } if (double.Parse(e.Cell.Row.Cells["SPRAY_COUNT"].Value.ToString()) > double.Parse(e.Cell.Row.Cells["SJ_NUM"].Value.ToString())) { MessageUtil.ShowTips("实际入库个数不能大于实际产出个数!"); e.Cell.Row.Cells["SPRAY_COUNT"].Value = e.Cell.Row.Cells["SJ_NUM"].Value.ToString(); return; } e.Cell.Row.Cells["SJ_NUM1"].Value = double.Parse(e.Cell.Row.Cells["SJ_NUM"].Value.ToString()) - double.Parse(e.Cell.Row.Cells["SPRAY_COUNT"].Value.ToString()); } } private void DoSave() { ultraGrid1.UpdateData(); UltraGridRow urg = ultraGrid1.ActiveRow; if (urg == null)return; int addCount = 0; ArrayList list = new ArrayList(); foreach (UltraGridRow uRow in ultraGrid1.Rows) { if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true) { addCount += 1; //产量差 if (uRow.Cells["CLC_NUM"].Value.ToString() != "0") { MessageUtil.ShowTips("您选择的工单产量不平!"); return; } int fallNum = int.Parse(urg.Cells["FAIL_CUT_NUM"].Value.ToString()) - int.Parse(urg.Cells["FAIL_CUT_NUM1"].Value.ToString()); ArrayList pram = new ArrayList(); pram.Add(urg.Cells["ZY_PLAN_ID"].Text.ToString()); pram.Add(urg.Cells["PLINE_CODE"].Text.ToString()); pram.Add(urg.Cells["WO_ID"].Text.ToString()); pram.Add(urg.Cells["SJ_NUM"].Text.ToString()); pram.Add(urg.Cells["FAIL_CUT_NUM"].Text.ToString()); pram.Add(this.UserInfo.GetUserName()); pram.Add(this.UserInfo.GetUserOrder()); pram.Add(this.UserInfo.GetUserGroup()); pram.Add(urg.Cells["SPRAY_COUNT"].Text.ToString()); list.Add(pram); } } if (addCount == 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.FrmInLibrary"; ccp.MethodName = "addLibraryResult"; ccp.ServerParams = new object[] { list, cutGx, urg.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(); DataTable dt = new DataTable(); GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true); } } /// /// ultraGrid2 触发事件 /// /// /// //private void ultraGrid2_AfterRowActivate(object sender, EventArgs e) //{ // UltraGridRow row = ultraGrid1.ActiveRow; // if (row == null) // { // //List listSource = new List(); // //CouplingComInfoEntity.DataSource = listSource; // //GridHelper.RefreshAndAutoSize(ultraGrid3); // } // else // { // //List listSource = EntityHelper.GetData // // ("com.steering.mes.mcp.coup.FrmInLibrary.doQueryInfoResult", new object[] { row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() }, this.ob); // //CouplingComInfoEntity.DataSource = listSource; // //GridHelper.RefreshAndAutoSize(ultraGrid3); // } //} /// /// 删除交库实绩 /// private void DoDelete() { ultraGrid3.UpdateData(); UltraGridRow urg = ultraGrid3.ActiveRow; if (urg == null) { MessageUtil.ShowTips("无交库信息!"); return; } int addCount = 0; ArrayList list = new ArrayList(); foreach (UltraGridRow uRow in ultraGrid3.Rows) { if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true) { addCount += 1; ArrayList list1 = new ArrayList(); list1.Add(uRow.Cells["DEAL_ORDE"].Value.ToString()); list1.Add(uRow.Cells["WO_ID"].Value.ToString()); list1.Add(uRow.Cells["ZY_PLAN_ID"].Value.ToString()); list1.Add(uRow.Cells["JUDGE_STOVE_NO"].Value.ToString()); list1.Add(uRow.Cells["BATCH_NO"].Value.ToString()); list1.Add(this.UserInfo.GetUserName()); list1.Add(this.UserInfo.GetUserOrder()); list1.Add(this.UserInfo.GetUserGroup()); list1.Add(cutGx); list1.Add(uRow.Cells["PIECES"].Value.ToString()); list1.Add(uRow.Cells["RESULT_NO"].Value.ToString()); list.Add(list1); } } if (addCount == 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.FrmInLibrary"; ccp.MethodName = "deleteLibraryResult"; ccp.ServerParams = new object[] { list }; 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.ultraGrid1.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("请选择需要结炉的工单号!"); return; } int proNum = 0; string planNum = uRow.Cells["PLAN_JG_NUM"].Value.ToString(); string inNum = uRow.Cells["SPRAY_COUNT"].Value.ToString(); if (planNum == null || planNum.Equals("")) { planNum = "0"; } if(inNum==null||inNum.Equals("")) { inNum = "0"; } proNum = Convert.ToInt32(planNum); string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); ArrayList list = new ArrayList(); list.Add(zYgNo); list.Add(woId); list.Add(cutGx); list.Add(proNum.ToString()); if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.FrmInLibrary"; 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 UndoBeside() { UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("请选择需要撤销结炉的工单号!"); return; } string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString(); string woId = uRow.Cells["WO_ID"].Value.ToString(); ArrayList list = new ArrayList(); list.Add(zYgNo); list.Add(woId); list.Add(cutGx); if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.coup.FrmInLibrary"; 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 chkStarts_CheckedChanged(object sender, EventArgs e) { 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 FrmInLibrary_Shown(object sender, EventArgs e) { if (toolMenu.Toolbars[0].Tools.Exists("DoQuery")) { toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("MatQuery")) { toolMenu.Toolbars[0].Tools["MatQuery"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoSave")) { toolMenu.Toolbars[0].Tools["DoSave"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("DoUpdate")) { toolMenu.Toolbars[0].Tools["DoUpdate"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoDelete")) { toolMenu.Toolbars[0].Tools["DoDelete"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("DoBeside")) { toolMenu.Toolbars[0].Tools["DoBeside"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("UndoBeside")) { toolMenu.Toolbars[0].Tools["UndoBeside"].InstanceProps.Visible = DefaultableBoolean.True; } } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (toolMenu == null) return; if (e.Tab.TabControl.SelectedTab.Key.Equals("0")) { if (toolMenu.Toolbars[0].Tools.Exists("DoQuery")) { toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("MatQuery")) { toolMenu.Toolbars[0].Tools["MatQuery"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoSave")) { toolMenu.Toolbars[0].Tools["DoSave"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("DoUpdate")) { toolMenu.Toolbars[0].Tools["DoUpdate"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoDelete")) { toolMenu.Toolbars[0].Tools["DoDelete"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("DoBeside")) { toolMenu.Toolbars[0].Tools["DoBeside"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("UndoBeside")) { toolMenu.Toolbars[0].Tools["UndoBeside"].InstanceProps.Visible = DefaultableBoolean.True; } } else { if (toolMenu.Toolbars[0].Tools.Exists("DoQuery")) { toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("MatQuery")) { toolMenu.Toolbars[0].Tools["MatQuery"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("DoSave")) { toolMenu.Toolbars[0].Tools["DoSave"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoUpdate")) { toolMenu.Toolbars[0].Tools["DoUpdate"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("DoDelete")) { toolMenu.Toolbars[0].Tools["DoDelete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoBeside")) { toolMenu.Toolbars[0].Tools["DoBeside"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("UndoBeside")) { toolMenu.Toolbars[0].Tools["UndoBeside"].InstanceProps.Visible = DefaultableBoolean.False; } } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { string woid = ""; string orderAll = ""; UltraGridRow urg = ultraGrid1.ActiveRow; if (urg != null) { woid = urg.Cells["WO_ID"].Text.ToString(); orderAll = urg.Cells["JG_ORDERNO_ALL"].Text.ToString(); // urg.Cells["SJ_NUM1"].Value = urg.Cells["SJ_NUM"].Text.ToString(); } if (urg.Cells["SPRAY_COUNT"].Text.ToString().Trim() == "") { urg.Cells["SPRAY_COUNT"].Value = "0"; } DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmInLibrary.doQueryMatNo", new object[] { woid, urg.Cells["PLINE_CODE"].Text.ToString() }, this.ob); GridHelper.CopyDataToDatatable(ref dt1, ref dataTable2, true); if(dt1.Rows.Count>0) { urg.Cells["SPRAY_COUNT"].Value = dt1.Rows[0]["PIECES"].ToString(); //urg.Cells["SJ_NUM1"].Value = double.Parse(urg.Cells["SJ_NUM"].Value.ToString()) - double.Parse(urg.Cells["SPRAY_COUNT"].Value.ToString()); } string jgOrder = ""; List listSource = EntityHelper.GetData( "com.steering.mes.mcp.coup.FrmInLibrary.QueryPlnOrderJg", new object[] { orderAll }, this.ob); PlnOrderJgbindingSource.DataSource = listSource; } } }