using System; using System.Collections; using System.Collections.Generic; using System.Drawing; using System.Linq; using System.Management; using System.Windows.Forms; using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Mcp.Mch.Entity; using CoreFS.CA06; namespace Core.StlMes.Client.Mcp.Mch.Report { public partial class FrmOffLineReport : FrmBase { private string plineCode = ""; private string[] plineCodes = {}; public FrmOffLineReport() { InitializeComponent(); IsLoadUserView = true; } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "DoQuery": QuerySinglePlan(); break; case "DoClose": Close(); break; case "Export": GridHelper.ulGridToExcel(ultraGrid1, "热处理离线台账"); break; } } /// /// 台账查询 /// private void QuerySinglePlan() { var startTime = ""; var endTime = ""; var judgeNo = ""; var batchNo = ""; var gx = ""; if (chkTim.Checked) if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString())) { MessageUtil.ShowTips("选择时间区间错误,请重新选择!"); return; } else { startTime = RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTime = RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } else if (!chkJugeHeatNo.Checked) if (MessageUtil.ShowYesNoAndQuestion("未加时间条件,查询时间可能比较长,请确定是否继续查询?") == DialogResult.No) return; if (chkJugeHeatNo.Checked) judgeNo = txtJugeNo.Text.Trim(); if (chkBatch.Checked) batchNo = txtBatch.Text.Trim(); var list = new ArrayList(); list.Add(startTime); list.Add(endTime); list.Add(judgeNo); list.Add(batchNo); list.Add(gx); list.Add(uceType.SelectedItem.DataValue.ToString()); List listSource = EntityHelper.GetData( "com.steering.mes.mcp.Mch.FrmJgxReport.doQueryOffLine", new object[] { list, new string[]{ultraCheckEditor1.Checked?"1":"0", ultraCheckEditor2.Checked?"1":"0",ultraCheckEditor3.Checked?"1":"0",ultraCheckEditor4.Checked?"1":"0"} ,plineCode == "" ? plineCodes : new string[] { plineCode } }, ob); List listGroup = EntityHelper.GetData( "com.steering.mes.mcp.Mch.FrmMchDownLineManage.doQueryOffGroupDetail", new object[] {listSource.Select(p => p.GroupId).Distinct().ToArray()}, ob); listSource.ForEach( p => p.MchGroupResultEntitys = listGroup.Where(q => q.GroupId == p.GroupId).OrderBy(q => q.GroupXh).ToList()); HttOfflineResultEntitybindingSource.DataSource = listSource; comm.RefreshAndAutoSize(ultraGrid1,new string[]{"StdName"}); } private void FrmWatergageReport_Load(object sender, EventArgs e) { plineCodes = comm.InitDropPlineCodePower("G", txt_PlinCode, ValidDataPurviewIds, 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")); } txt_PlinCode.SelectedIndex = 0; EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[1]); uceType.SelectedIndex = 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; } if (chkJugeHeatNo.Checked) txtJugeNo.Enabled = true; else txtJugeNo.Enabled = false; if (chkBatch.Checked) txtBatch.Enabled = true; else txtBatch.Enabled = false; } private void txt_PlinCode_TextChanged(object sender, EventArgs e) { plineCode = txt_PlinCode.SelectedItem.DataValue.ToString(); } private void ultraGrid1_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e) { MchOfflineResultAndGroupEntity list = e.Row.ListObject as MchOfflineResultAndGroupEntity; if(list==null) return; if (list.GroupLog == "1") { e.Row.Cells["GroupLog"].Appearance.BackColor = Color.LightGreen; } if ((list.OfflineNum ?? 0) - (list.GroupNum ?? 0) - (list.ReNum ?? 0) - (list.SubcontractNum ?? 0) + (list.SubcontractcompleteNum ?? 0) <= 0) { if ((list.SubcontractNum ?? 0) > 0 && (list.SubcontractcompleteNum ?? 0) == 0 && (list.HbFpNum ?? 0) == 0) { e.Row.Cells["JudgeStoveNo"].Appearance.BackColor = Color.Khaki; } else if((list.GroupNum??0)>0) { e.Row.Cells["JudgeStoveNo"].Appearance.BackColor = Color.DarkGray; } else { e.Row.Cells["JudgeStoveNo"].Appearance.BackColor = Color.LightGray; } } } } }