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; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using Core.StlMes.Client.Mcp.Mch.Entity; namespace Core.StlMes.Client.Mcp.Mch.Report { public partial class FrmMchProcessQurey : FrmBase { private string plineCode = ""; private string manageNmae = ""; //科室名称 private string[] plineCodes = new string[] { }; public FrmMchProcessQurey() { InitializeComponent(); this.IsLoadUserView = true; } private void FrmMchProcessQurey_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);//当月最后一天 //StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); //EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); StartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00")); EndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59")); manageNmae = UserInfo.GetDepartment(); //plineCode = YdmBaseClass.GetPCode(manageNmae, this.ob);//获取 用户 对应的产线 plineCodes= comm.InitDropPlineCodePower("G", txt_PlinCode, this.ValidDataPurviewIds, this.ob); txt_PlinCode.SelectedIndex = 0; ultraGrid1.DisplayLayout.Bands[0].Groups["GROUP"].Hidden = true; } public override void ToolBar_Click(object sender, string ToolbarKey) { //base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query": DoQuery(); break; case "Export": GridHelper.ulGridToExcel(ultraGrid1, "加工线进程数据统计"); break; case "Close": this.Close(); break; } } /// /// 查询 /// /// private void DoQuery() { var wf = new WaitingForm2("正在查询,请稍候...."); try { Cursor = Cursors.WaitCursor; if (!CheckQuery()) return; ultraGrid1.DisplayLayout.Bands[0].Groups["GROUP"].Hidden = true; foreach (var ultraGridColumn in ultraGrid1.DisplayLayout.Bands[0].Columns) { if (ultraGridColumn.Key.StartsWith("GROUP")) { ultraGridColumn.Hidden = true; ultraGridColumn.Header.Caption = ultraGridColumn.Key.Replace("GROUP", ""); } } string staTime = ""; string endTime = ""; if (chkTim.Checked) { staTime = StartTime.Value.ToString(); endTime = EndTime.Value.ToString(); } ArrayList list = new ArrayList(); list.Add(staTime); list.Add(endTime); list.Add(chkJugeHeatNo.Checked?this.txtJugeNo.Text.Trim():""); list.Add(this.txtLotNo.Text.Trim()); list.Add(chkOrder.Checked?this.txtOrder.Text.Trim():""); list.Add(uceStatus.SelectedIndex == -1 ? "" : uceStatus.SelectedItem.DataValue.ToString2()); DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmJGXPerformance.doQueryPort", new object[] { list, plineCode == "" ? plineCodes : new string[] { plineCode } }, ob); GridHelper.CopyDataToDatatable(ref dt1, ref dataTable1, true); string OrderNo = chkOrder.Checked ? this.txtOrder.Text.Trim() : ""; if (!string.IsNullOrWhiteSpace(OrderNo)) { List listGroup= EntityHelper.GetData( "com.steering.mes.mcp.Mch.FrmGroupSetting.doQuery", new object[] { OrderNo }, ob); foreach (var entity in listGroup) { if (ultraGrid1.DisplayLayout.Bands[0].Columns.Exists("GROUP" + entity.GroupNo)) { ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP" + entity.GroupNo].Header.Caption = entity.GroupMin + "-" + entity.GroupMax; } } } } catch (Exception ex) { if (ex.Message.ToString2() != "") MessageBox.Show(ex.Message); } finally { wf.Close(); Cursor = Cursors.Default; } } private void chkTim_CheckedChanged(object sender, EventArgs e) { if (chkTim.Checked) { StartTime.Enabled = true; EndTime.Enabled = true; } else { StartTime.Enabled = false; EndTime.Enabled = false; } if (chkJugeHeatNo.Checked) { txtJugeNo.Enabled = true; } else { txtJugeNo.Enabled = false; } if (chkLotNo.Checked) { txtLotNo.Enabled = true; } else { txtLotNo.Enabled = false; } if (chkOrder.Checked) { txtOrder.Enabled = true; } else { txtOrder.Enabled = false; } } /// /// 数据验证 /// /// private bool CheckQuery() { if (DataTimeUtil.JudgeTime(DateTime.Parse(StartTime.Value.ToString()), DateTime.Parse(EndTime.Value.ToString())) == 0) { MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择!"); return false; } if (this.chkJugeHeatNo.Checked && string.IsNullOrEmpty(this.txtJugeNo.Text.Trim())) { MessageUtil.ShowWarning("请输入炉号!"); return false; } if (this.chkLotNo.Checked && string.IsNullOrEmpty(this.txtLotNo.Text.Trim())) { MessageUtil.ShowWarning("请输入批号!"); return false; } if (this.chkOrder.Checked && string.IsNullOrEmpty(this.txtOrder.Text.Trim())) { MessageUtil.ShowWarning("请输入合同号!"); return false; } return true; } 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) { if (int.Parse(e.Row.Cells["FLAG1"].Value.ToString3()) > 0) { e.Row.Appearance.BackColor = lbColor1.BackColor; } else if (int.Parse(e.Row.Cells["FLAG"].Value.ToString3()) > 0) { e.Row.Appearance.BackColor = lbColor2.BackColor; } if (int.Parse(e.Row.Cells["GROUP001"].Value.ToString3()) > 0) { ultraGrid1.DisplayLayout.Bands[0].Groups["GROUP"].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP001"].Hidden = false; } if (int.Parse(e.Row.Cells["GROUP002"].Value.ToString3()) > 0) { ultraGrid1.DisplayLayout.Bands[0].Groups["GROUP"].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP002"].Hidden = false; } if (int.Parse(e.Row.Cells["GROUP003"].Value.ToString3()) > 0) { ultraGrid1.DisplayLayout.Bands[0].Groups["GROUP"].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP003"].Hidden = false; } if (int.Parse(e.Row.Cells["GROUP004"].Value.ToString3()) > 0) { ultraGrid1.DisplayLayout.Bands[0].Groups["GROUP"].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP004"].Hidden = false; } if (int.Parse(e.Row.Cells["GROUP005"].Value.ToString3()) > 0) { ultraGrid1.DisplayLayout.Bands[0].Groups["GROUP"].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP005"].Hidden = false; } if (int.Parse(e.Row.Cells["GROUP006"].Value.ToString3()) > 0) { ultraGrid1.DisplayLayout.Bands[0].Groups["GROUP"].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP001"].Hidden = false; } if (int.Parse(e.Row.Cells["GROUP006"].Value.ToString3()) > 0) { ultraGrid1.DisplayLayout.Bands[0].Groups["GROUP"].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP006"].Hidden = false; } if (int.Parse(e.Row.Cells["GROUP007"].Value.ToString3()) > 0) { ultraGrid1.DisplayLayout.Bands[0].Groups["GROUP"].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP007"].Hidden = false; } if (int.Parse(e.Row.Cells["GROUP008"].Value.ToString3()) > 0) { ultraGrid1.DisplayLayout.Bands[0].Groups["GROUP"].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP008"].Hidden = false; } } } }