using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Format; using Core.Mes.Client.Comm.Tool; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; 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; namespace Core.StlMes.Client.Mcp.Mch.Mat { public partial class ApplyAudit : FrmBase { private string[] plineCodes = { }; public ApplyAudit() { InitializeComponent(); IsLoadUserView = true; } protected override void OnLoad(EventArgs e) { base.OnLoad(e); StartTime1.Value = DateTime.Parse(DateTime.Now.AddDays(1 - DateTime.Now.Day).AddDays(-1).ToString("yyyy-MM-dd 21:00")); EndTime1.Value = DateTime.Parse( DateTime.Now.AddDays(1 - DateTime.Now.Day).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd 20:59")); plineCodes = comm.GetPlineCode2(ValidDataPurviewIds, ob); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); comm.RefreshAndAutoSize(ultraGrid1); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": Query(); break; case "AuditYK": AuditYK(); break; case "Cancel": CancelAudit(); break; case "Del": Del(); break; case "CancelDel": CancelDel(); break; case "Close": Close(); break; case "Export": Export(); break; } } public void AuditYK() { if (this.ultraOptionSet1.CheckedItem.DataValue.ToString().Equals("0")) { AuditOfflineYK(); } else if (this.ultraOptionSet1.CheckedItem.DataValue.ToString().Equals("1")) { AuditYucaiYK(); } } private void Chk1_CheckedChanged(object sender, EventArgs e) { this.ultraTextEditor1.Enabled = this.Chk1.Checked; } private void Chk2_CheckedChanged(object sender, EventArgs e) { this.judgeNoTextEditor2.Enabled = this.Chk2.Checked; } /// /// 查询申请信息 /// public void Query() { var wf = new WaitingForm2("正在查询,请稍后...."); try { Cursor = Cursors.WaitCursor; Dictionary dic = new Dictionary(); if (chkTim1.Checked) if (DateTime.Parse(StartTime1.Value.ToString()) > DateTime.Parse(EndTime1.Value.ToString())) { MessageUtil.ShowTips("选择时间区间错误,请重新选择!"); return; } else { dic.Add("start", StartTime1.Value.ToString("yyyy-MM-dd HH:mm:ss")); dic.Add("end", EndTime1.Value.ToString("yyyy-MM-dd HH:mm:ss")); } if(Chk1.Checked){ dic.Add("applyno",this.ultraTextEditor1.Text.ToString()); } if (Chk2.Checked) { dic.Add("judgeno",this.judgeNoTextEditor2.Text.ToString()); } if(validChk.Checked){ dic.Add("validChk","包含无效"); } else { dic.Add("validChk", "不包含无效"); } dic.Add("applytype", this.ultraOptionSet1.CheckedItem.DataValue.ToString()); dic.Add("plineCodes", plineCodes); List listSource = EntityHelper.GetData( "com.steering.mes.mcp.common.OverstockPipe.doQueryApply", new object[] { dic }, ob); ydmOverstockpipeApplyEntityBindingSource.DataSource = listSource; comm.RefreshAndAutoSize(ultraGrid1); foreach(UltraGridRow ugr in this.ultraGrid1.Rows){ if (ugr.Cells["validflag"].Text.ToString().Equals("无效")) { ugr.Appearance.ForeColor = Color.Red; } else { ugr.Appearance.ForeColor = Color.Black; } } } catch (Exception ex) { if (ex.Message.ToString2() != "") MessageBox.Show(ex.Message); } finally { wf.Close(); Cursor = Cursors.Default; } } /// /// 离线转压库审核 /// private void AuditOfflineYK() { ultraGrid1.UpdateData(); var list = ydmOverstockpipeApplyEntityBindingSource.DataSource as List; list = list.Where(p =>p.Chk).ToList(); if (!list.Any()) { MessageBox.Show("请选择要转压库审核的数据!"); return; } var list1 = list.Select(p => p.ApplyFlag).ToList(); foreach (var item in list1) { if (!item.Equals("已申请")) { MessageUtil.ShowTips("包含已经完成审核的数据,请重试!"); return; } } if (MessageUtil.ShowYesNoAndQuestion("确认通过审核?") == DialogResult.No) return; var ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.common.OverstockPipe"; ccp.MethodName = "AuditOfflineYK"; ccp.ServerParams = new object[]{ list.Select(JSONFormat.Format).ToList(),this.UserInfo.GetUserName() }; ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("审核通过!")) { Query(); } } } /// /// 余材压库审核 /// public void AuditYucaiYK() { ultraGrid1.UpdateData(); var list = ydmOverstockpipeApplyEntityBindingSource.DataSource as List; list = list.Where(p => p.Chk).ToList(); if (!list.Any()) { MessageBox.Show("请选择要转压库审核的数据!"); return; } var list1 = list.Select(p => p.ApplyFlag).ToList(); foreach (var item in list1) { if (!item.Equals("已申请")) { MessageUtil.ShowTips("包含已经完成审核的数据,请重试!"); return; } } if (MessageUtil.ShowYesNoAndQuestion("确认通过审核?") == DialogResult.No) return; var ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.common.OverstockPipe"; ccp.MethodName = "AuditYucaiYK"; ccp.ServerParams = new object[] { list.Select(JSONFormat.Format).ToList(), this.UserInfo.GetUserName() }; ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("审核通过!")) { Query(); } } } /// /// 压库审核撤销 /// public void CancelAudit() { ultraGrid1.UpdateData(); var list = ydmOverstockpipeApplyEntityBindingSource.DataSource as List; list = list.Where(p => p.Chk).ToList(); if (!list.Any()) { MessageBox.Show("请选择要撤销的数据!"); return; } var list1 = list.Select(p => p.ApplyFlag).ToList(); foreach (var item in list1) { if (item.Equals("已申请")) { MessageUtil.ShowTips("尚未审核通过的数据无法撤销,请重试!"); return; } } foreach (var item in list.Select(JSONFormat.Format).ToList()) { List listSource = EntityHelper.GetData( "com.steering.mes.mcp.common.OverstockPipe.doQueryYDMResult", new object[] { item }, this.ob); if (listSource.Any()) { MessageUtil.ShowTips("包含已经进行送判的数据,无法撤销审核,清重试!"); return; } } if (MessageUtil.ShowYesNoAndQuestion("确认撤销?") == DialogResult.No) return; var ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.common.OverstockPipe"; ccp.MethodName = "CancelAudit"; ccp.ServerParams = new object[] { list.Select(JSONFormat.Format).ToList() }; ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("撤销成功!")) { Query(); } } } /// /// 压库申请废除 /// public void Del() { ultraGrid1.UpdateData(); var list = ydmOverstockpipeApplyEntityBindingSource.DataSource as List; list = list.Where(p => p.Chk).ToList(); if (!list.Any()) { MessageUtil.ShowTips("请选择要废除的数据!"); return; } var list1 = list.Select(p => p.Validflag).ToList(); foreach (var item in list1) { if (item.Equals("无效")) { MessageUtil.ShowTips("已经废除的数据无法再次废除,请重试!"); return; } } if (MessageUtil.ShowYesNoAndQuestion("确认废除?") == DialogResult.No) return; var ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.common.OverstockPipe"; ccp.MethodName = "Del"; ccp.ServerParams = new object[] { list.Select(JSONFormat.Format).ToList() }; ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("废除成功!")) { Query(); } } } /// /// 压库申请废除撤销 /// public void CancelDel() { ultraGrid1.UpdateData(); var list = ydmOverstockpipeApplyEntityBindingSource.DataSource as List; list = list.Where(p => p.Chk).ToList(); if (!list.Any()) { MessageUtil.ShowTips("请选择要撤销的数据!"); return; } var list1 = list.Select(p => p.Validflag).ToList(); foreach (var item in list1) { if (item.Equals("有效")) { MessageUtil.ShowTips("有效数据无法撤销废除,请重试!"); return; } } if (MessageUtil.ShowYesNoAndQuestion("确认撤销?") == DialogResult.No) return; var ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.common.OverstockPipe"; ccp.MethodName = "CancelDel"; ccp.ServerParams = new object[] { list.Select(JSONFormat.Format).ToList() }; ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("撤销成功!")) { Query(); } } } public void Export() { string title = ""; title += "申请审核记录"; GridHelper.ulGridToExcel(ultraGrid1, title); } } }