MES_Client/TGMES/Core.StlMes.Client.LgIntegrationQuery/frmAbnormalInfo.cs

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

        // 初始化岗位
        /// <summary>
        /// 初始化岗位
        /// </summary>
        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;
            }
        }

        // 获取异常信息
        /// <summary>
        /// 获取信息
        /// </summary>
        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控件(岗位)  废弃使用
        /// <summary>
        /// 初始化UltraDropDown控件(岗位)
        /// </summary>
        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();
        }
    }
}