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.Control; using CoreFS.CA06; 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; using Infragistics.Win.UltraWinEditors; using Core.StlMes.Client.Mcp.Mch.Entity; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Format; using System.Collections; namespace Core.StlMes.Client.Mcp.Mch.Report { public partial class FrmMchWasterAuditReport : FrmBase { //private string SlGx = "";//工序代码 //private string SlGxname = "";//工序名称 private string departm = ""; private string plineCode = ""; private string Process = "";//参数 private string[] plineCodes = new string[] { }; public FrmMchWasterAuditReport() { InitializeComponent(); this.IsLoadUserView = true; } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "DoQuery": QuerySinglePlan(); break; case "Audit": Audit(); break; case "CancelAudit": CancelAudit(); break; case "DoClose": this.Close(); break; } } /// /// 审核 /// private void Audit() { CrackDetectGrid.UpdateData(); IQueryable checkMagRows = this.CrackDetectGrid.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要申请判定的主信息!"); return; } ArrayList parm = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { MatBcMEntity matBcEntity = (MatBcMEntity)uRow.ListObject; string matBcTity = JSONFormat.Format(matBcEntity); parm.Add(matBcTity); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.Mch.FrmJgxReport"; ccp.MethodName = "Audit"; ccp.ServerParams = new object[] { parm, UserInfo.GetUserName() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips("审核成功!"); QuerySinglePlan(); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } /// /// 取消审核 /// private void CancelAudit() { ultraGrid2.UpdateData(); ultraGrid1.UpdateData(); UltraGridRow row = this.ultraGrid2.ActiveRow; IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要申请判定的主信息!"); return; } ArrayList parm = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { MatBcMEntity matBcEntity = (MatBcMEntity)uRow.ListObject; string matBcTity = JSONFormat.Format(matBcEntity); parm.Add(matBcTity); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.Mch.FrmJgxReport"; ccp.MethodName = "CancelAudit"; ccp.ServerParams = new object[] { parm, row.Cells["FAIL_APPROVAL_CODE"].Text.Trim() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips("取消审核成功!"); QuerySinglePlan(); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } /// /// 台账查询 /// private void QuerySinglePlan() { MatBcMEntitybindingSource2.Clear(); var startTim = ""; var endTim = ""; var shift = ""; //班次 var group = ""; //班组 var OrderNo = ""; var JudgeStoveNo = ""; #region if (chkTim.Checked) { if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString())) { MessageUtil.ShowTips("选择时间区间错误,请重新选择!"); return; } startTim = RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if (chkOrderNo.Checked) OrderNo = txtOrderNo.Text; if (chkJudgeStove.Checked) JudgeStoveNo = txtJudgeStove.Text; #endregion if (ultraTabControl1.SelectedTab.Index == 0) { MatBcMEntitybindingSource1.DataSource = EntityHelper.GetData( "com.steering.mes.mcp.Mch.FrmJgxReport.doQueryWasterAudit", new object[] { plineCode == "" ? plineCodes : new string[] { plineCode }, startTim, endTim, OrderNo, JudgeStoveNo }, ob); GridHelper.RefreshAndAutoSizeExceptColumns(CrackDetectGrid); } else if (ultraTabControl1.SelectedTab.Index == 1) { DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmJgxReport.doQueryWasterAuditRecords", new Object[] { plineCode == "" ? plineCodes : new string[] { plineCode }, startTim, endTim, OrderNo, JudgeStoveNo }, this.ob); GridHelper.CopyDataToDatatable(dt, this.dataTable1, true); GridHelper.RefreshAndAutoSize(this.ultraGrid2); } } private void FrmMchWasterAuditReport_Load(object sender, EventArgs e) { Process = this.CustomInfo.ToString();//参数 plineCodes = comm.InitDropPlineCodePower(Process, txt_PlinCode, this.ValidDataPurviewIds, this.ob); if (plineCodes.Length > 1 && (plineCodes[1] == "C038" || plineCodes[1] == "C039" || plineCodes[1] == "C049" || plineCodes[1] == "C050" || plineCodes[1] == "C051" || plineCodes[1] == "C057")) { RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 20:00")); RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 19:59")); } else { RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00")); RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59")); } departm = UserInfo.GetDepartment(); //plineCode = YdmBaseClass.GetPCode(departm, this.ob);//获取 用户 对应的产线 txt_PlinCode.SelectedIndex = 0; //YdmBaseClass.SetComboItemHeight(cmbOrder); //YdmBaseClass.SetComboItemHeight(cmbGroup); EntityHelper.ShowGridCaption(CrackDetectGrid.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); QuerySinglePlan(); } private void chkStarts_CheckedChanged(object sender, EventArgs e) { if (chkTim.Checked) { RegStartTime.Enabled = true; RegEndTime.Enabled = true; } else { RegStartTime.Enabled = false; RegEndTime.Enabled = false; } //cmbOrder.Enabled = chkOrder.Checked; //cmbGroup.Enabled = chkGroup.Checked; txtOrderNo.Enabled = chkOrderNo.Checked; txtJudgeStove.Enabled = chkJudgeStove.Checked; } private void txt_PlinCode_TextChanged(object sender, EventArgs e) { plineCode = txt_PlinCode.SelectedItem.DataValue.ToString(); } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (toolMenu == null) return; if (ultraTabControl1.SelectedTab.Index == 0) { if (toolMenu.Toolbars[0].Tools.Exists("Audit")) { toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit")) { this.toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False; } chkTim.Text = "入库时间"; chkOrderNo.Visible = true; txtOrderNo.Visible = true; chkJudgeStove.Visible = true; txtJudgeStove.Visible = true; } else if (ultraTabControl1.SelectedTab.Index == 1) { if (toolMenu.Toolbars[0].Tools.Exists("Audit")) { toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit")) { this.toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True; } chkTim.Text = "审核时间"; chkOrderNo.Visible = false; txtOrderNo.Visible = false; chkJudgeStove.Visible = false; txtJudgeStove.Visible = false; } } private void ultraGrid2_AfterRowActivate(object sender, EventArgs e) { UltraGridRow uRow = this.ultraGrid2.ActiveRow; MatBcMEntitybindingSource2.DataSource = EntityHelper.GetData( "com.steering.mes.mcp.Mch.FrmJgxReport.doQueryWasterAuditRecordsByID", new object[] { uRow.Cells["FAIL_APPROVAL_CODE"].Value.ToString() }, ob); GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid1); } private void FrmMchWasterAuditReport_Shown(object sender, EventArgs e) { this.toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False; } } }