using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Format; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.YdmStuffManage.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.YdmStuffManage { public partial class FrmOutStore : FrmBase { public FrmOutStore() { InitializeComponent(); } private void FrmOutStore_Load(object sender, EventArgs e) { EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid2.DisplayLayout.Bands[0]); } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": if (!CheckQuery()) return; doQueryData(); break; case"QueryHistory": doQueryHistory(); break; case "OutStore": doOutStore(); break; case"ScrapOutStore": scrapGpData(); break; case "CancelOutStore": cancelOutStore(); break; case"ExportData": exportData(); break; case "Close": close(); break; } } /// /// 导出 /// private void exportData() { if (ultraTabControl1.SelectedTab.Key == "0") { GridHelper.ulGridToExcel(ultraGrid1, "管坯库存数据"); } else if (ultraTabControl1.SelectedTab.Key == "1") { GridHelper.ulGridToExcel(ultraGrid2, "管坯出库数据"); } } /// /// 查询出库记录 /// private void doQueryHistory() { string stoveNo = ""; string judgeNo = ""; string startTime = ""; string endTime = ""; if (chkStoveNo.Checked && txtStoveNo.Text.Trim() != "") { stoveNo = this.txtStoveNo.Text.Trim(); } if (chkjudgeNo.Checked && txtjudgeNo.Text.Trim() != "") { judgeNo = this.txtjudgeNo.Text.Trim(); } if (ultraIsLoad.Checked) { startTime = StartTime.Value.ToString(); endTime = EndTime.Value.ToString(); } ArrayList parmList = new ArrayList(); parmList.Add(stoveNo); parmList.Add(judgeNo); parmList.Add(startTime); parmList.Add(endTime); List listSource = EntityHelper.GetData( "Core.LgMes.Server.Stuffmanage.FrmOutStore.doQueryHistory", new object[] { parmList,this.CustomInfo }, this.ob); YdmGpOutlistEntity3bindingSource.DataSource = listSource; } /// /// 查询 /// private void doQueryData() { string stoveNo = ""; string judgeNo = ""; if (chkStoveNo.Checked && txtStoveNo.Text.Trim() != "") { stoveNo = this.txtStoveNo.Text.Trim(); } if (chkjudgeNo.Checked && txtjudgeNo.Text.Trim() != "") { judgeNo = this.txtjudgeNo.Text.Trim(); } ArrayList parmList = new ArrayList(); parmList.Add(stoveNo); parmList.Add(judgeNo); List listSource = EntityHelper.GetData( "Core.LgMes.Server.Stuffmanage.FrmOutStore.doQueryMatData", new object[] { parmList,this.CustomInfo }, this.ob); MatGpMEntity3bindingSource.DataSource = listSource; } /// /// 销售出库 /// private void doOutStore() { this.ultraGrid1.UpdateData(); string outCode = "800805"; IQueryable checkMagRow = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = True"); if (checkMagRow.Count() == 0) { MessageUtil.ShowTips("请选择需要出库的库存信息!"); return; } if(this.cmbBelong.Value.ToString2() == "") { MessageUtil.ShowTips("管坯转销售时,需指定去向!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRow) { MatGpMEntity3 matGpEntity = (MatGpMEntity3)row.ListObject; if (!StringUtil.IsInt(matGpEntity.ActCount.ToString3())) { MessageUtil.ShowTips("出库支数应为整数!"); return; } matGpEntity.BelongCode = this.cmbBelong.Value.ToString2(); matGpEntity.BelongName = this.cmbBelong.Text.ToString2(); string matGpTity = JSONFormat.Format(matGpEntity); parmList.Add(matGpTity); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "Core.LgMes.Server.Stuffmanage.FrmOutStore"; ccp.MethodName = "doOutStore"; ccp.ServerParams = new object[] { parmList, this.UserInfo.GetUserName(), outCode }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("销售出库成功!")) { doQueryData(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 回废出库 /// private void scrapGpData() { this.ultraGrid1.UpdateData(); string outCode = "800804"; IQueryable checkMagRow = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = True"); if (checkMagRow.Count() == 0) { MessageUtil.ShowTips("请选择需要出库的库存信息!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRow) { MatGpMEntity3 matGpEntity = (MatGpMEntity3)row.ListObject; if (!StringUtil.IsInt(matGpEntity.ActCount.ToString3())) { MessageUtil.ShowTips("出库支数应为整数!"); return; } string matGpTity = JSONFormat.Format(matGpEntity); parmList.Add(matGpTity); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "Core.LgMes.Server.Stuffmanage.FrmOutStore"; ccp.MethodName = "scrapGpData"; ccp.ServerParams = new object[] { parmList, this.UserInfo.GetUserName(), outCode }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("回废出库成功!")) { doQueryData(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 撤销出库 /// private void cancelOutStore() { this.ultraGrid2.UpdateData(); IQueryable checkMagRow = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = True"); if (checkMagRow.Count() == 0) { MessageUtil.ShowTips("请选择需要撤销的出库信息!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRow) { YdmGpOutlistEntity3 ydmGpEntity = (YdmGpOutlistEntity3)row.ListObject; string ydmOutListTity = JSONFormat.Format(ydmGpEntity); parmList.Add(ydmOutListTity); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "Core.LgMes.Server.Stuffmanage.FrmOutStore"; ccp.MethodName = "cancelOutStore"; ccp.ServerParams = new object[] { parmList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("撤销成功!")) { doQueryHistory(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } private void close() { this.Close(); } /// /// 检查数据 /// /// private bool CheckQuery() { if (this.chkStoveNo.Checked && string.IsNullOrEmpty(this.txtStoveNo.Text.Trim())) { MessageBox.Show("请输入熔炼炉号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (this.chkjudgeNo.Checked && string.IsNullOrEmpty(this.txtjudgeNo.Text.Trim())) { MessageBox.Show("请输入判定炉号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } return true; } private void FrmOutStore_Shown(object sender, EventArgs e) { if (toolMenu == null) return; if (toolMenu.Toolbars[0].Tools.Exists("QueryHistory")) { toolMenu.Toolbars[0].Tools["QueryHistory"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelOutStore")) { toolMenu.Toolbars[0].Tools["CancelOutStore"].InstanceProps.Visible = DefaultableBoolean.False; } } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (ultraTabControl1.SelectedTab.Key == "0") { if (toolMenu == null) return; if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("OutStore")) { toolMenu.Toolbars[0].Tools["OutStore"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("ScrapOutStore")) { toolMenu.Toolbars[0].Tools["ScrapOutStore"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QueryHistory")) { toolMenu.Toolbars[0].Tools["QueryHistory"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelOutStore")) { toolMenu.Toolbars[0].Tools["CancelOutStore"].InstanceProps.Visible = DefaultableBoolean.False; } ultraIsLoad.Visible = false; StartTime.Visible = false; EndTime.Visible = false; ultraIsLoad.Checked = false; label1.Visible = false; } else if (ultraTabControl1.SelectedTab.Key == "1") { if (toolMenu == null) return; if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("OutStore")) { toolMenu.Toolbars[0].Tools["OutStore"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("ScrapOutStore")) { toolMenu.Toolbars[0].Tools["ScrapOutStore"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryHistory")) { toolMenu.Toolbars[0].Tools["QueryHistory"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("CancelOutStore")) { toolMenu.Toolbars[0].Tools["CancelOutStore"].InstanceProps.Visible = DefaultableBoolean.True; } ultraIsLoad.Visible = true; StartTime.Visible = true; EndTime.Visible = true; label1.Visible = true; } } private void chkStoveNo_CheckedChanged(object sender, EventArgs e) { this.txtStoveNo.Enabled = this.chkStoveNo.Checked; } private void chkjudgeNo_CheckedChanged(object sender, EventArgs e) { this.txtjudgeNo.Enabled = this.chkjudgeNo.Checked; } } }