MES_Client/TGMES/Core.StlMes.Client.LgIntegrationQuery/frmSendMessage.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 frmSendMessage : frmStyleBase
    {
        public frmSendMessage()
        {
            InitializeComponent();
        }

        public string strShift = "";
        private string station = "A";

        private void frmSendMessage_Load(object sender, EventArgs e)
        {
            //初始化时间和查询条件
            this.uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00";
            this.uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59";
            //获取原有信息
            QueryData();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    QueryData();
                    break;
                case "Export":
                    try
                    {
                        //Core.Mes.Client.Common.Globals.ulGridToExcel(ultraGrid, Text);
                        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 strHeatNo = "";
            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.txtHeatNo.Text.ToString() == "" || this.txtHeatNo.Text.ToString().Length == 0)
                {
                    txtHeatNo.Focus();
                    MessageBox.Show("炉号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                strHeatNo = txtHeatNo.Text.Trim();
            }
            else
            {
                strHeatNo = "0";
            }


            //获取过程异常信息
            //string NowTime = DateTime.Now.ToString("yyyy-MM-dd");
            //ArrayList arry = new ArrayList();
            //arry.Add("SenMessage.Query");
            //arry.Add(strHeatNo);
            //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);
            try
            {
                ArrayList arry = new ArrayList();
                arry.Add(strHeatNo);
                arry.Add(strHeatNo);
                arry.Add(station);
                arry.Add(station);
                arry.Add(strStartTime);
                arry.Add(strEndTime);
                CommonClientToServer ccTos = new CommonClientToServer();
                ccTos.ob = this.ob;
                DataSet ds = ccTos.ExecuteQueryFunctionsSqlID("Core.Mes.Server.Common.ComDataAccess",
                                                             "QueryWithParameter", "STL_QUERY0001", 5, 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["OBJECTID"] = Dr["OBJECTID"].ToString().Substring(5, 8);
                        dr1["STATIONCODE"] = getStation(Dr["OBJECTID"].ToString().Substring(0, 1));
                        dr1["SENDCMPT"] = Dr["SENDCMPT"].ToString() == "SERVER" ? "系统自动发送" : Dr["SENDCMPT"].ToString();
                        dr1["OBJECTSRC"] = Dr["OBJECTSRC"].ToString();
                        dr1["OBJECTDES"] = Dr["OBJECTDES"].ToString();
                        dr1["MSGCONTENT"] = Dr["MSGCONTENT"].ToString();
                        dr1["LASTFRESHTIME"] = Dr["LASTFRESHTIME"].ToString();
                        dataSet1.Tables[0].Rows.Add(dr1);
                    }
                }
                PublicMethod.RefreshAndAutoSize(ultraGrid);
            }
            catch { }
        }

        private string getStation(string key)
        {
            string value = "未知";
            if (key == "C")
            {
                value = "转炉";
            }
            else if (key == "D")
            {
                value = "吹氩站";
            }
            else if (key == "D")
            {
                value = "精炼炉";
            }
            else if (key == "G")
            {
                value = "连铸";
            }
            return value;
        }

        /// <summary>
        /// 导出Excel
        /// </summary>
        private void ExportExcel()
        {
            try
            {
                string StrfileName = System.Windows.Forms.Application.StartupPath + "\\Report\\过程异常信息.xls";
                this.ultraGridExcelExporter1.Export(this.ultraGrid, StrfileName);
                ProcessStartInfo p = new ProcessStartInfo(StrfileName);
                p.WindowStyle = System.Diagnostics.ProcessWindowStyle.Maximized;
                p.WorkingDirectory = Path.GetDirectoryName(StrfileName);
                Process.Start(p);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void chkShift_CheckedChanged(object sender, EventArgs e)
        {
            txtHeatNo.Enabled = chkShift.Checked;
        }

        private void rb_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                RadioButton rb = (RadioButton)sender;
                if (rb.Checked)
                {
                    station = rb.Tag.ToString();
                    QueryData();
                }
            }
            catch { }
        }

    }
}