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; namespace Core.StlMes.Client.Mcp.VRP.Vrp { public partial class FrmPerformance : FrmBase { private string plineCode = ""; private string manageNmae = ""; //科室名称 private string stationCode = ""; public FrmPerformance() { InitializeComponent(); this.IsLoadUserView = true; } private void FrmPerformance_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);//获取 用户 对应的产线 comm.InitDropPlinePower("E", txt_PlinCode , this.ValidDataPurviewIds, this.ob); txt_PlinCode.SelectedIndex = 0; } 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 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 void DoQuery() { string judgeNo = ""; string batchNo = ""; string orderNo = ""; if (!CheckQuery()) return; string staTime = ""; string endTime = ""; if (chkTim.Checked) { staTime = StartTime.Value.ToString(); endTime = EndTime.Value.ToString(); } if (chkLotNo.Checked) { batchNo = this.txtLotNo.Text.Trim(); } if (chkJugeHeatNo.Checked) { judgeNo = this.txtJugeNo.Text.Trim(); } if (chkOrder.Checked) { orderNo = this.txtOrder.Text.Trim(); } ArrayList list = new ArrayList(); list.Add(staTime); list.Add(endTime); list.Add(judgeNo); list.Add(batchNo); list.Add(orderNo); DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Report.FrmDBKPerformance.doQuery", new object[] { list, plineCode,stationCode }, ob); GridHelper.CopyDataToDatatable(ref dt1, ref dataTable1, true); } /// /// 数据验证 /// /// 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(); if (plineCode.Equals("C018"))//720 { stationCode = "650101"; ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = true;//测量点 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = true;//冷拔冷轧表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = false;//旋扩 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = false;//均整 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = false;//定径 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = false;//旋扩表检 } else if (plineCode.Equals("C021"))//镦粗 { stationCode = "650401"; ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = true;//冷拔冷轧表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = false;//镦粗表检 } else if (plineCode.Equals("C014"))//冷拔机组 { stationCode = "650501"; ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = false;//冷拔冷轧 } else if (plineCode.Equals("C013"))//冷轧机组 { stationCode = "650601"; ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = false;//冷拔冷轧 } else if (plineCode.Equals("C070"))//热扩 { stationCode = "650701"; ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = true;//冷拔冷轧表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = false;//热扩 } else if (plineCode.Equals("C067"))//委外镦粗 { stationCode = "650401"; ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//镦粗表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = true;//冷拔冷轧表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = false;//镦粗 } else if (plineCode.Equals("C080"))//委外冷轧 { stationCode = "650601"; ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点 ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = false;//冷拔冷轧 } } } }