using Core.Mes.Client.Comm.Format; using Core.Mes.Client.Comm.Server; 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 FrmForgingStockInstore : FrmBase { public FrmForgingStockInstore() { InitializeComponent(); } private string[] arr = null; private void FrmForgingStockInstore_Load(object sender, EventArgs e) { DateTime now = DateTime.Now; DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天 DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天 this.StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); this.EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[1]); EntityHelper.ShowGridCaption(ultraGrid3.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid4.DisplayLayout.Bands[0]); arr = BaseMethod.InitLgPermissions(this.ValidDataPurviewIds,"C",this.ob); } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": doQueryPlan(); break; case"doQueryInList": doQueryInList(); break; case "EnsureInPut": EnsureInPutData(); break; case "CancelInPut": CancelInPutData(); break; case "DoBeside": doBeside(); break; case"cancelDoBeside": cancelDoBeside(); break; case "Close": this.Close(); break; } } /// /// 查询炉计划 /// private void doQueryPlan() { string[] L1 = new string[] { "HeatPlanNo", "StoveNo" }; string[] L2 = new string[] { "HeatPlanNo", "StoveNo" }; string stoveNo = ""; string startTim = ""; string endTim = ""; if (!CheckQuery()) return; if (this.chkTim.Checked) { startTim = this.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if (this.chkStoveNo.Checked) { stoveNo = this.txtStoveNo.Text.Trim(); } ArrayList parm = new ArrayList(); parm.Add(stoveNo); List listSource = EntityHelper.GetData( "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryPlnZyM", new object[] { parm, startTim, endTim, arr, ultraOptionSet2.CheckedItem.DataValue.ToString() }, this.ob); FrgLoadingResultEntitybindingSource.Clear(); List listSource2 = EntityHelper.GetData( "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryPlnZyC", new object[] { parm }, this.ob); EntityHelper.AddEntityRelation(listSource, listSource2, L1, L2); PlnZyDzMEntitybindingSource.DataSource = listSource; } /// /// 查询交库实绩 /// private void doQueryInList() { string stoveNo = ""; string startTim = ""; string endTim = ""; if (!CheckQuery()) return; if (this.chkTim.Checked) { startTim = this.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if (this.chkStoveNo.Checked) { stoveNo = this.txtStoveNo.Text.Trim(); } ArrayList parm = new ArrayList(); parm.Add(stoveNo); List listSource = EntityHelper.GetData( "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryInList", new object[] { parm, startTim, endTim,arr }, this.ob); YdmGpInlistEntitybindingSource.DataSource = listSource; } /// /// 数据验证 /// /// private bool CheckQuery() { if (this.chkStoveNo.Checked && string.IsNullOrEmpty(this.txtStoveNo.Text.Trim())) { MessageUtil.ShowWarning("请输入判定炉号!"); return false; } return true; } /// /// 交库 /// private void EnsureInPutData() { this.ultraGrid3.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; string storeNo = ""; string strInBound = "800701"; string departId = ClsLoad.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob); string departMent = ClsLoad.GetDepartBySectionId(this.UserInfo.GetDeptid(), this.ob); string[] storeType = new string[4]; IQueryable checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请勾选可交库信息!"); return; } if (uRow.Cells["PlineCode"].Text.Equals("C005")) { storeNo = "XED1"; } else { MessageUtil.ShowTips("未获取到所在科室,无法交库!"); return; } storeType = getStoreType(storeNo); ArrayList parmList = new ArrayList(); foreach(UltraGridRow row in checkMagRows) { FrgLoadingResultEntity frgLoadingEntity = (FrgLoadingResultEntity)row.ListObject; string frgLoadingTity = JSONFormat.Format(frgLoadingEntity); parmList.Add(frgLoadingTity); } if (MessageUtil.ShowYesNoAndQuestion("是否入库?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore"; ccp.MethodName = "ensureInPutData"; ccp.ServerParams = new object[] { parmList, storeNo, strInBound, storeType, this.UserInfo.GetUserName(), this.UserInfo.GetDeptid(), this.UserInfo.GetDepartment(), departId, departMent }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("入库成功!")) { doQueryPlan(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 查询仓库类型 /// /// /// private string[] getStoreType(string storeNo) { string[] storeType = new string[4]; DataTable dt = ServerHelper.GetData("Core.LgMes.Server.Stuffmanage.FrmStuffInputStore.getStoreType", new object[] { storeNo }, ob); if (dt.Rows.Count > 0) { storeType[0] = dt.Rows[0]["STORAGE_ATTR"].ToString(); storeType[1] = dt.Rows[0]["STORAGE_ATTR_NAME"].ToString(); storeType[2] = dt.Rows[0]["STORAGE_TYPE_NO"].ToString(); storeType[3] = dt.Rows[0]["STORAGE_TYPE_NAME"].ToString(); } return storeType; } /// /// 撤销交库 /// private void CancelInPutData() { this.ultraGrid4.UpdateData(); IQueryable checkMagRows = this.ultraGrid4.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请勾选需要撤销的入库实绩!"); return; } ArrayList parm = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { YdmGpInlistEntity ydmGpInListEntity = (YdmGpInlistEntity)uRow.ListObject; string inListTity = JSONFormat.Format(ydmGpInListEntity); parm.Add(inListTity); } if (MessageUtil.ShowYesNoAndQuestion("是否撤销入库?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore"; ccp.MethodName = "cancelInPutData"; ccp.ServerParams = new object[] { parm }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("撤销入库成功!")) { doQueryInList(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 结炉 /// private void doBeside() { this.ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null || uRow.HasParent()) { return; } if (!uRow.Cells["NodeEstatus"].Text.Equals("上料完成")) { MessageUtil.ShowTips("上料未结炉,不允许结炉!"); return; } DataTable ds = ServerHelper.GetData("Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryLoading", new object[] { uRow.Cells["HeatPlanNo"].Text }, ob); if (int.Parse(ds.Rows[0][0].ToString()) > 0) { MessageUtil.ShowTips("还有未入库的管坯,不允许结炉!"); return; } PlnZyDzMEntity plnZyC = (PlnZyDzMEntity)uRow.ListObject; string plnZyTity = JSONFormat.Format(plnZyC); ServerHelper.SetData("Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doBeside", new object[] { plnZyTity }, ob); doQueryPlan(); MessageUtil.ShowTips("结炉成功!"); } /// /// 撤销结炉 /// private void cancelDoBeside() { this.ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null || uRow.HasParent()) { return; } if (!uRow.Cells["NodeEstatus"].Text.Equals("下线完成")) { MessageUtil.ShowTips("下线未结炉,不允许结炉回退!"); return; } ArrayList parmList = new ArrayList(); parmList.Add(uRow.Cells["StoveNo"].Text); parmList.Add(uRow.Cells["JudgeStoveNo"].Text); parmList.Add(uRow.Cells["ProPlanId"].Text); parmList.Add(uRow.Cells["GxPlanNo"].Text); DataTable ds = ServerHelper.GetData("Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryJudgeApply", new object[] { parmList }, ob); if (int.Parse(ds.Rows[0][0].ToString()) > 0) { MessageUtil.ShowTips("该熔炼炉已有申请判定,不允许结炉回退!"); return; } PlnZyDzMEntity plnZyC = (PlnZyDzMEntity)uRow.ListObject; string plnZyTity = JSONFormat.Format(plnZyC); ServerHelper.SetData("Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.cancelDoBeside", new object[] { plnZyTity }, ob); doQueryPlan(); MessageUtil.ShowTips("结炉回退成功!"); } private void chkTim_CheckedChanged(object sender, EventArgs e) { this.StartTime.Enabled = this.EndTime.Enabled = this.chkTim.Checked; } private void chkStoveNo_CheckedChanged(object sender, EventArgs e) { this.txtStoveNo.Enabled = this.chkStoveNo.Checked; } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (toolMenu == null) return; if(ultraTabControl1.SelectedTab.Key == "0") { if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("doQueryInList")) { toolMenu.Toolbars[0].Tools["doQueryInList"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("EnsureInPut")) { toolMenu.Toolbars[0].Tools["EnsureInPut"].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("CancelInPut")) { toolMenu.Toolbars[0].Tools["CancelInPut"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("cancelDoBeside")) { toolMenu.Toolbars[0].Tools["cancelDoBeside"].InstanceProps.Visible = DefaultableBoolean.True; } this.chkTim.Text = "计划日期"; ultraOptionSet2.Visible = true; } else if (ultraTabControl1.SelectedTab.Key == "1") { if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doQueryInList")) { toolMenu.Toolbars[0].Tools["doQueryInList"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("EnsureInPut")) { toolMenu.Toolbars[0].Tools["EnsureInPut"].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("CancelInPut")) { toolMenu.Toolbars[0].Tools["CancelInPut"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("cancelDoBeside")) { toolMenu.Toolbars[0].Tools["cancelDoBeside"].InstanceProps.Visible = DefaultableBoolean.False; } this.chkTim.Text = "入库日期"; ultraOptionSet2.Visible = false; } } private void FrmForgingStockInstore_Shown(object sender, EventArgs e) { if (toolMenu == null) return; if (toolMenu.Toolbars[0].Tools.Exists("doQueryInList")) { toolMenu.Toolbars[0].Tools["doQueryInList"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelInPut")) { toolMenu.Toolbars[0].Tools["CancelInPut"].InstanceProps.Visible = DefaultableBoolean.False; } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { UltraGridRow row = this.ultraGrid1.ActiveRow; if (row == null) { return; } if (row.HasChild()) { return; } List listSource = EntityHelper.GetData( "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryLoadResult", new object[] { row.Cells["HeatPlanNo"].Text, row.Cells["StoveNo"].Text, row.Cells["JudgeStoveNo"].Text }, this.ob); FrgLoadingResultEntitybindingSource.DataSource = listSource; foreach(UltraGridRow uRow in this.ultraGrid3.Rows) { uRow.Cells["CHK"].Value = "True"; } } } }