using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.PlnSaleOrd.BaseMethod; using Core.StlMes.Client.PlnSaleOrd.JGGXPln.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.PlnSaleOrd.JGGXPln { public partial class FrmJgOrderLk : FrmBase { private string flag = "0"; private string jgOrder = ""; private string codeJgG = ""; private bool flaggd = false; private string jgorderNoSeq = ""; private string judgeStoveNo = ""; public bool Flaggd { get { return flaggd; } set { flaggd = value; } } public FrmJgOrderLk() { InitializeComponent(); this.IsLoadUserView = true; } public FrmJgOrderLk(OpeBase _ob, string _codeJg, string _orderNo) { this.ob = _ob; flag = "1"; codeJgG = _codeJg; jgorderNoSeq = _orderNo; InitializeComponent(); this.IsLoadUserView = true; } private void FrmJgOrderLk_Load(object sender, EventArgs e) { EntityHelper.ShowGridCaption(ultraGridOrderJg.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid2.DisplayLayout.Bands[0]); BaseHelper.setOtherColumnReadOnly(ultraGridOrderJg, new string[] { "CHC" }); BaseHelper.setUltraGridColumnMaxInput(ultraGridOrderJg, new string[] { "Singleweight", "JgwtBlreq" }); BaseHelper.setUltraGridColumnBits(ultraGridOrderJg, new string[] { "CountFinish", "KcCount" }); //BaseHelper.GridColumnSum(ultraGridOrderJg, new string[] {}); BaseHelper.GridColumnCount(ultraGridOrderJg, new string[] { "CountFinish" }); BaseHelper.InitCellPosition(ultraGridOrderJg, new string[] { "Outdiameter", "Wallthick","Aimlength", "Singleweight","Diameter", "CheckJVal","CountFinish","KcCount"}); BaseHelper.setColumnBackColor(ultraGridOrderJg, new string[] { "KcCount" }); ultraGridOrderJg.DisplayLayout.Bands[0].Columns["KcCount"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Button; BaseHelper.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHC", "KoreNum" }); BaseHelper.setUltraGridColumnMaxInput(ultraGrid1, new string[] { "KoreWt", "Weight" }); BaseHelper.setUltraGridColumnBits(ultraGrid1, new string[] { "KoreNum", "Pieces"}); BaseHelper.InitCellPosition(ultraGrid1, new string[] { "KoreNum", "KoreWt", "Pieces", "Weight" }); BaseHelper.setColumnBackColor(ultraGrid1, new string[] { "KoreNum" }); BaseHelper.setOtherColumnReadOnly(ultraGrid2, new string[] { "CHC" }); BaseHelper.setUltraGridColumnMaxInput(ultraGrid2, new string[] { "PlanWt" }); BaseHelper.setUltraGridColumnBits(ultraGrid1, new string[] { "PlanNum" }); BaseHelper.InitCellPosition(ultraGrid2, new string[] { "PlanNum", "PlanWt" }); ultraGridOrderJg.DisplayLayout.Bands[0].Columns["CodeJg"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton; if (flag.Equals("1")) { chcCodeJg.Checked = true; txtCodeJg.Enabled = true; txtCodeJg.Value = codeJgG; chcJgOrderNo.Checked = true; txtJgOrderNo.Enabled = true; txtJgOrderNo.Value = jgorderNoSeq; Query(); } judgeStoveNo = ultraTextEditor1.Text.ToString().Trim(); judgeNo.Visible = false; txtJudge.Visible = false; } public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query"://查询 Query(); break; case "QueryKc"://接箍可利库存查询 QueryKc(); break; case "Add"://利库 doAdd(); break; case "Delete"://撤销 doDelete(); break; //case "Export": //导出 // Export(); // break; case "Update"://修改 doUpdate(); break; case "UpdateDelte"://撤销修改 doUpdateDelte(); break; case "Close": //关闭 this.Close(); break; default: break; } } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "Query"://查询 Query(); break; case "Add"://利库 doAdd(); break; case "Delete"://撤销 doDelete(); break; case "Update"://修改 doUpdate(); break; case "Close": //关闭 this.Close(); break; default: break; } } private void chcJgOrderNo_CheckedChanged(object sender, EventArgs e) { if (chcJgOrderNo.Checked) { txtJgOrderNo.Enabled = true; } else { txtJgOrderNo.Enabled = false; } if (chcOrderNo.Checked) { txtOrderNo.Enabled = true; } else { txtOrderNo.Enabled = false; } if (chcCodeJg.Checked) { txtCodeJg.Enabled = true; } else { txtCodeJg.Enabled = false; } if (chkJgStart.Checked) { chcJgStart.Enabled = true; } else { chcJgStart.Enabled = false; } if (chkPcStart.Checked) { chcPcStart.Enabled = true; } else { chcPcStart.Enabled = false; } if (judgeNo.Checked) { txtJudge.Enabled = true; } else { txtJudge.Enabled = false; } } private void Query() { string jgOrderNo = ""; if (chcJgOrderNo.Checked) { jgOrderNo = txtJgOrderNo.Text.Trim(); } string orderNo = ""; if (chcOrderNo.Checked) { orderNo = txtOrderNo.Text.Trim(); } string codeJg = ""; if (chcCodeJg.Checked) { codeJg = txtCodeJg.Text.Trim(); } string judge = ""; if (judgeNo.Checked) { judge = txtJudge.Text.Trim(); } string[] jgStart = { }; if (chkJgStart.Checked && !chcJgStart.Text.Equals("")) { jgStart = chcJgStart.Text.Split(',').Select(p=>p.Trim()).ToArray(); } string[] pcStart = { }; if (chkPcStart.Checked && !chcPcStart.Text.Equals("")) { pcStart = chcPcStart.Text.Split(',').Select(p => p.Trim()).ToArray(); } if (ultraTabControl1.SelectedTab.Key.Equals("0")) { List listSource = EntityHelper.GetData ("com.steering.pss.plnsaleord.jggxpln.FrmJgOrderLk.queryJgOrder", new object[] { jgOrderNo, orderNo, codeJg, jgStart, pcStart }, this.ob); bindingSourcePlnOrderJgEntity.DataSource = listSource; foreach (UltraGridRow item in ultraGridOrderJg.Rows) { if (!jgOrder.Equals("")) { if (item.Cells["JgOrderno"].Text.Trim().Equals(jgOrder)) { item.Activate(); break; } } } } else { List listSource = EntityHelper.GetData ("com.steering.pss.plnsaleord.jggxpln.FrmJgOrderLk.QueryMatJgOrder", new object[] { codeJg, jgOrderNo, orderNo, judge }, this.ob); bindingSource2.DataSource = listSource; } } private void QueryKc() { List listSource = EntityHelper.GetData ("com.steering.pss.plnsaleord.jggxpln.FrmJgOrderLk.QueryMatM", new object[] { "", "" }, this.ob); bindingSource1.DataSource = listSource; } /// /// ultraGridOrderJg 触发事件 /// /// /// private void ultraGridOrderJg_AfterRowActivate(object sender, EventArgs e) { UltraGridRow row = ultraGridOrderJg.ActiveRow; if (row == null) return; //QueryMatML(row.Cells["CodeJg"].Value.ToString(), row.Cells["JgOrderno"].Value.ToString()); } /// /// 查询已利库库存 /// /// /// // private void QueryMatML(string codeJg, string jgOrderNo) // { // List listSource = EntityHelper.GetData //("com.steering.pss.plnsaleord.jggxpln.FrmJgOrderLk.QueryMatJgOrder", new object[] { codeJg, jgOrderNo }, this.ob); // bindingSource2.DataSource = listSource; // //GridHelper.RefreshAndAutoSize(ultraGrid2); // } /// /// 查询可利库库存 /// /// /// private void QueryMatMK(string codeJg) { List listSource = EntityHelper.GetData ("com.steering.pss.plnsaleord.jggxpln.FrmJgOrderLk.QueryMatM", new object[] { codeJg, judgeStoveNo }, this.ob); bindingSource1.DataSource = listSource; //GridHelper.RefreshAndAutoSize(ultraGrid1); } private string codeJg = ""; /// /// ultraGridOrderJg 点击事件 /// /// /// private void ultraGridOrderJg_ClickCellButton(object sender, CellEventArgs e) { UltraGridRow row = ultraGridOrderJg.ActiveRow; if (row == null) return; if (e.Cell.Column.Key.Equals("KcCount")) { judgeStoveNo = ultraTextEditor1.Text.ToString().Trim(); //string exeStatus = row.GetValue("ExeStatus"); codeJg = row.GetValue("CodeJg"); QueryMatMK(codeJg); ultraExpandableGroupBox1.Expanded = true; } if (e.Cell.Column.Key.Equals("CodeJg")) { foreach (UltraGridRow row1 in ultraGrid1.Rows) { if (Convert.ToBoolean(row1.Cells["CHC"].Value) == true) { row1.Cells["CodeJg"].Value = row.Cells["CodeJg"].Value.ToString(); } } } } /// /// 利库 /// private void doAdd() { UltraGridRow rowOrder = ultraGridOrderJg.ActiveRow; if (rowOrder == null) return; UltraGridRow row = ultraGrid1.ActiveRow; if (row == null) return; int count = 0; ArrayList list = new ArrayList(); foreach (UltraGridRow urg in ultraGrid1.Rows) { if (Convert.ToBoolean(urg.Cells["CHC"].Text) == true) { count++; if (urg.Cells["KoreNum"].Value.ToString().Equals("0")) { MessageUtil.ShowTips("可利库个数不能为0!"); return; } ArrayList list1 = new ArrayList(); list1.Add(urg.Cells["CodeJg"].Value.ToString()); list1.Add(urg.Cells["MatNo"].Value.ToString()); list1.Add(urg.Cells["MatNoXh"].Value.ToString()); list1.Add(urg.Cells["KoreNum"].Value.ToString()); list1.Add(urg.Cells["KoreWt"].Value.ToString()); list1.Add(urg.Cells["WoId"].Value.ToString()); list.Add(list1); } } if (count == 0) { MessageUtil.ShowTips("请勾库存可利信息!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否利库?") == DialogResult.No) return; PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmJgOrderLk"; ccp.MethodName = "doAdd"; ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName(), rowOrder.Cells["JgOrderno"].Text.ToString() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("利库成功!")) { jgOrder = rowOrder.Cells["JgOrderno"].Text.ToString(); string codeJg = rowOrder.Cells["CodeJg"].Text.ToString(); Query(); QueryMatMK(codeJg); Flaggd = true; } } /// /// 撤销利库 /// private void doDelete() { UltraGridRow row = ultraGrid2.ActiveRow; if (row == null) return; int count = 0; ArrayList list = new ArrayList(); foreach (UltraGridRow urg in ultraGrid2.Rows) { if (Convert.ToBoolean(urg.Cells["CHC"].Text) == true) { count++; //if (urg.Cells["KoreNum"].Value.ToString().Equals("0")) //{ // MessageUtil.ShowTips("可利库个数不能为0!"); // return; //} ArrayList list1 = new ArrayList(); list1.Add(urg.Cells["CodeJg"].Value.ToString()); list1.Add(urg.Cells["MatNo"].Value.ToString()); list1.Add(urg.Cells["MatNoXh"].Value.ToString()); list1.Add(urg.Cells["WoId"].Value.ToString()); list1.Add(urg.Cells["Guid"].Value.ToString()); list1.Add(urg.Cells["JgOrderno"].Text.ToString()); list.Add(list1); } } if (count == 0) { MessageUtil.ShowTips("请勾库存已利信息!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否撤销利库?") == DialogResult.No) return; PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmJgOrderLk"; ccp.MethodName = "doDelete"; ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("撤销成功!")) { //jgOrder = rowOrder.Cells["JgOrderno"].Text.ToString(); //string codeJg = rowOrder.Cells["CodeJg"].Text.ToString(); Query(); //QueryMatMK(codeJg); Flaggd = true; } } /// /// 修改库存接箍码 /// private void doUpdate() { UltraGridRow row1 = ultraGridOrderJg.ActiveRow; if (row1 == null) return; string codeJg = row1.GetValue("CodeJg"); UltraGridRow row = ultraGrid1.ActiveRow; if (row == null) return; int count = 0; ArrayList list = new ArrayList(); foreach (UltraGridRow urg in ultraGrid1.Rows) { if (Convert.ToBoolean(urg.Cells["CHC"].Text) == true) { count++; ArrayList list1 = new ArrayList(); list1.Add(urg.Cells["CodeJg"].Text.ToString()); list1.Add(urg.Cells["JudgeStoveNo"].Value.ToString()); list1.Add(urg.Cells["BatchNo"].Value.ToString()); list1.Add(urg.Cells["MatNo"].Value.ToString()); list.Add(list1); } } if (count == 0) { MessageUtil.ShowTips("请勾需要修改库存信息!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否修改接箍码?") == DialogResult.No) return; PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmJgOrderLk"; ccp.MethodName = "doUpdate"; ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { Query(); QueryMatMK(codeJg); Flaggd = true; } } private void doUpdateDelte() { string codeJg = ""; UltraGridRow row1 = ultraGridOrderJg.ActiveRow; if (row1 != null) { codeJg = row1.GetValue("CodeJg"); } UltraGridRow row = ultraGrid1.ActiveRow; if (row == null) return; int count = 0; ArrayList list = new ArrayList(); foreach (UltraGridRow urg in ultraGrid1.Rows) { if (Convert.ToBoolean(urg.Cells["CHC"].Text) == true) { count++; ArrayList list1 = new ArrayList(); list1.Add(urg.Cells["MatNo"].Value.ToString()); list.Add(list1); } } if (count == 0) { MessageUtil.ShowTips("请勾需要修改库存信息!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否修改接箍码?") == DialogResult.No) return; PlanComm.WaitFromOpen(this.Cursor); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmJgOrderLk"; ccp.MethodName = "doUpdateDelte"; ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); PlanComm.WaitFromColse(this.Cursor); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { //Query(); QueryMatMK(codeJg); Flaggd = true; } } private int splitterDistance = 0; private void ultraExpandableGroupBox1_ExpandedStateChanged(object sender, EventArgs e) { if (ultraExpandableGroupBox1.Expanded == false) { this.splitContainer1.SplitterDistance = splitContainer1.Size.Height - 26; } else { this.splitContainer1.SplitterDistance = splitterDistance == 0 ? splitContainer1.Size.Height / 2 : splitterDistance; } } /// /// 可利库信息改变事件 /// /// /// private void ultraGrid1_CellChange(object sender, CellEventArgs e) { UltraGridRow row = ultraGrid1.ActiveRow; ultraGrid1.UpdateData(); if (e.Cell.Column.Key.Equals("KoreNum")) { if (e.Cell.Row.Cells["KoreNum"].Value==null||e.Cell.Row.Cells["KoreNum"].Value.Equals("")) { row.Cells["KoreNum"].Value = row.Cells["Pieces"].Value.ToString(); row.Cells["KoreWt"].Value = row.Cells["Weight"].Value.ToString(); } else { string actLen = e.Cell.Row.Cells["KoreNum"].Value.ToString(); if (!StringUtil.IsInt(actLen) || actLen == "0") { e.Cell.Row.Cells["KoreWt"].Value = 0; } else { e.Cell.Row.Cells["KoreWt"].Value = (int.Parse(actLen) * double.Parse(e.Cell.Row.Cells["Singleweight"].Value.ToString())/1000).ToString("f3"); } } } } /// /// 托选 /// /// /// private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGrid1.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHC"].Value = true; } } } private void ultraGrid2_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGrid2.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHC"].Value = true; } } } private void 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("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QueryKc")) { toolMenu.Toolbars[0].Tools["QueryKc"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("UpdateDelte")) { toolMenu.Toolbars[0].Tools["UpdateDelte"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True; } chkJgStart.Visible = true; chcJgStart.Visible = true; chkPcStart.Visible = true; chcPcStart.Visible = true; judgeNo.Visible = false; txtJudge.Visible = false; } else { if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryKc")) { toolMenu.Toolbars[0].Tools["QueryKc"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("UpdateDelte")) { toolMenu.Toolbars[0].Tools["UpdateDelte"].InstanceProps.Visible = DefaultableBoolean.False; } chkJgStart.Visible = false; chcJgStart.Visible = false; chkPcStart.Visible = false; chcPcStart.Visible = false; judgeNo.Visible = true; txtJudge.Visible = true; } } private void ultraButton1_Click(object sender, EventArgs e) { judgeStoveNo = ultraTextEditor1.Text.ToString().Trim(); QueryMatMK(codeJg); } } }