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();
}
}
}