using System; using System.Collections.Generic; using System.Collections; using System.ComponentModel; using System.IO; using System.Diagnostics; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using Core.StlMes.Client.LgCommon; using Core.Mes.Client.Comm.Control; namespace Core.StlMes.Client.LgIntegrationQuery { public partial class frmAbnormalInfo : frmStyleBase { public frmAbnormalInfo() { InitializeComponent(); } public string strShift = ""; public string workShopNo = ""; private void frmAbnormalInfo_Load(object sender, EventArgs e) { this.workShopNo = this.CustomInfo; //初始化时间和查询条件 this.uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00"; this.uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59"; ; this.ulcmePose.Enabled = false; this.ulcmeShiftQuery.Enabled = false; ulcmeShiftQuery.SelectedIndex = 0; ulcmePose.SelectedIndex = 0; initPos(); //获取原有信息 QueryData(); } // 初始化岗位 /// /// 初始化岗位 /// public void initPos() { ulcmePose.Items.Clear(); ulcmePose.Items.Add("HMP01", "1#脱硫"); ulcmePose.Items.Add("BOF01", "1#转炉"); ulcmePose.Items.Add("BOF02", "2#转炉"); ulcmePose.Items.Add("BOF03", "3#转炉"); ulcmePose.Items.Add("BOF04", "4#转炉"); ulcmePose.Items.Add("BOF05", "5#转炉"); ulcmePose.Items.Add("CAS01", "1#吹氩"); ulcmePose.Items.Add("CAS02", "2#吹氩"); ulcmePose.Items.Add("CAS03", "3#吹氩"); ulcmePose.Items.Add("CAS04", "4#吹氩"); ulcmePose.Items.Add("CAS05", "5#吹氩"); ulcmePose.Items.Add("LFS01", "1#精炼"); ulcmePose.Items.Add("LFS02", "2#精炼"); ulcmePose.Items.Add("LFS03", "3#精炼"); ulcmePose.Items.Add("CCM01", "1#连铸机"); ulcmePose.Items.Add("CMM02", "2#连铸机"); ulcmePose.Items.Add("LFS02", "2#精炼炉"); ulcmePose.Items.Add("CCM03", "3#连铸机"); ulcmePose.Items.Add("CMM04", "4#连铸机"); ulcmePose.Items.Add("CMM05", "5#连铸机"); //if (workShopNo == "1") //{ // ulcmePose.Items.Add("HMP01", "1#脱硫站"); // ulcmePose.Items.Add("BOF01", "1#转炉"); // ulcmePose.Items.Add("BOF02", "2#转炉"); // ulcmePose.Items.Add("CAS01", "1#吹氩站"); // ulcmePose.Items.Add("CAS02", "2#吹氩站"); // ulcmePose.Items.Add("LFS01", "1#精炼炉"); // ulcmePose.Items.Add("CCM01", "1#连铸机"); // ulcmePose.Items.Add("CMM02", "2#连铸机"); //} //else //{ // ulcmePose.Items.Add("BOF03", "3#转炉"); // ulcmePose.Items.Add("BOF04", "4#转炉"); // ulcmePose.Items.Add("BOF05", "5#转炉"); // ulcmePose.Items.Add("CAS03", "3#吹氩站"); // ulcmePose.Items.Add("CAS04", "4#吹氩站"); // ulcmePose.Items.Add("CAS05", "5#吹氩站"); // ulcmePose.Items.Add("LFS02", "2#精炼炉"); // ulcmePose.Items.Add("LFS03", "3#精炼炉"); // ulcmePose.Items.Add("CCM03", "3#连铸机"); // ulcmePose.Items.Add("CMM04", "4#连铸机"); // ulcmePose.Items.Add("CMM05", "5#连铸机"); //} } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": QueryData(); break; case "Export": try { GridHelper.ulGridToExcel(ultraGrid, Text); } catch (Exception ex) { MessageBox.Show(ex.Message); } break; case "Exit": this.Close(); break; default: break; } } // 获取异常信息 /// /// 获取信息 /// private void QueryData() { string strStartTime = ""; string strEndTime = ""; string strStacode = ""; string strPost = ""; string strErr = ""; if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value)) { MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } else { strStartTime = this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss"); strEndTime = this.uldtEndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss"); } if (chkShift.Checked) { if (this.ulcmeShiftQuery.SelectedIndex<0) { ulcmeShiftQuery.Focus(); MessageBox.Show("班次不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } strStacode = strShift; } if (chkPost.Checked) { if (this.ulcmePose.SelectedIndex < 0) { ulcmePose.Focus(); MessageBox.Show("岗位不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } strPost = ulcmePose.Text.ToString(); } //获取过程异常信息 string NowTime = DateTime.Now.ToString("yyyy-MM-dd"); ArrayList arry = new ArrayList(); arry.Add("frmAbnormalInfo.select"); arry.Add(strStacode); arry.Add(strPost); arry.Add(strStartTime == "" ? NowTime : strStartTime); arry.Add(strEndTime == "" ? NowTime : strEndTime); CommonClientToServer cctos = new CommonClientToServer(); cctos.ob = this.ob; DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr); dataSet1.Clear(); if (strErr == "" && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow Dr in ds.Tables[0].Rows) { DataRow dr1 = dataSet1.Tables[0].NewRow(); dr1["HEATPROCESSNO"] = Dr["HEATPROCESSNO"].ToString(); dr1["HeatNo"] = Dr["HeatNo"].ToString(); dr1["G"] = Dr["G"].ToString(); dr1["B"] = Dr["B"].ToString(); dr1["OPTDATE"] = Dr["OPTDATE"].ToString(); dr1["MEMO"] = Dr["MEMO"].ToString(); dataSet1.Tables[0].Rows.Add(dr1); } } PublicMethod.RefreshAndAutoSize(ultraGrid); } // 初始化UltraDropDown控件(岗位) 废弃使用 /// /// 初始化UltraDropDown控件(岗位) /// private void InitUltraDropDown() { string strErr = ""; ArrayList arry = new ArrayList(); arry.Add("FrmYCJJB_Process.select"); CommonClientToServer cctos = new CommonClientToServer(); cctos.ob = this.ob; DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr); if (strErr == "" && ds != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ulcmePose.Items.Add(i); ulcmePose.Items[i].DisplayText = ds.Tables[0].Rows[i]["DESCRIPTION"].ToString(); ulcmePose.Items[i].DataValue = ds.Tables[0].Rows[i]["NAME_"].ToString(); } } } private void ulcmePose_ValueChanged(object sender, EventArgs e) { QueryData(); } private void chkShift_CheckedChanged(object sender, EventArgs e) { ulcmeShiftQuery.Enabled = chkShift.Checked; if (chkShift.Checked == true) { string ShiftCode = ""; ShiftCode = ""; if (!string.IsNullOrEmpty(ShiftCode)) { ulcmeShiftQuery.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1; } } else { ulcmeShiftQuery.Text = ""; } } private void chkPost_CheckedChanged(object sender, EventArgs e) { ulcmePose.Enabled = chkPost.Checked; } private void ulcmeShiftQuery_ValueChanged(object sender, EventArgs e) { switch (this.ulcmeShiftQuery.SelectedIndex) { case 0: strShift = "甲班"; //调度岗位 break; case 1: strShift = "乙班"; break; case 2: strShift = "丙班"; break; case 3: strShift = "丁班"; break; default: break; } QueryData(); } } }