MES_Client/TGMES/Core.StlMes.Client.LgIntegrationQuery/frmSystemLog.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 Infragistics.Win.UltraWinMaskedEdit;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using Core.StlMes.Client.LgCommon;
using Core.Mes.Client.Comm.Control;


namespace Core.StlMes.Client.LgIntegrationQuery
{
    public partial class frmSystemLog : frmStyleBase
    {
        public frmSystemLog()
        {
            InitializeComponent();
        }

        private void frmSystemLog_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();
        }
        private void RadioSystemLog_CheckedChanged(object sender, EventArgs e)
        {
            if (this.RadioSystemLog.Checked == true)
            {
                this.RadioInterfaceLog.Checked = false;
            }

            QueryData();
        }
        private void RadioInterfaceLog_CheckedChanged(object sender, EventArgs e)
        {
            if (this.RadioInterfaceLog.Checked == true)
            {
                this.RadioSystemLog.Checked = false;
            }

            QueryData();
        }
        /// <summary>
        /// 获取辅助材料进料信息
        /// </summary>
        private void QueryData()
        {
            string strErrType = "";
            string strStartTime = "";
            string strEndTime = "";
            string strErr = "";

            if (RadioSystemLog.Checked == true)
            {
                strErrType = RadioSystemLog.Tag.ToString() ;
            }
            if (RadioInterfaceLog.Checked == true)
            {
                strErrType = RadioInterfaceLog.Tag.ToString();
            }

            if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value))
            {
                MessageBox.Show("时间条件的开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            else
            {

                strStartTime = this.uldtBeginTime.DateTime.ToString("yyyyMMddHHmmss");
                strEndTime = this.uldtEndTime.DateTime.ToString("yyyyMMddHHmmss");
            }

            

            //获取系统日志信息
            string NowTime = DateTime.Now.ToString("yyyy-MM-dd");
            ArrayList arry = new ArrayList();
            arry.Add("frmSysteLog.select");
            arry.Add(strErrType);
            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[0].Rows.Count > 0)
            {
                foreach (DataRow Dr in ds.Tables[0].Rows)
                {
                    DataRow dr1 = dataSet1.Tables[0].NewRow();
                    dr1["ERRSEQ"] = Dr["ERRSEQ"].ToString();
                    dr1["ERRTYPE"] = Dr["ERRTYPE"].ToString();
                    dr1["ERRCODE"] = Dr["ERRCODE"].ToString();
                    dr1["ERRDATE"] = Dr["ERRDATE"].ToString();
                    dr1["ERRNOTE"] = Dr["ERRNOTE"].ToString();
                    dr1["ERRMODULE"] = Dr["ERRMODULE"].ToString();
                    dataSet1.Tables[0].Rows.Add(dr1);
                }
            }
            PublicMethod.RefreshAndAutoSize(ultraGrid1);
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {            
            switch (ToolbarKey)
            {
                case "Query":
                    QueryData();
                    break;
                case "Export":
                    if (ultraGrid1.Rows.Count > 0)
                    ExportExcel();
                    break;
                case "Exit":
                    this.Close();
                    break;
                default:
                    break;
            }
        }
      
        /// <summary>
        /// 导出Excel
        /// </summary>
        private void ExportExcel()
        {
            try
            {
                //Core.Mes.Client.Common.Globals.ulGridToExcel(ultraGrid1, Text);
                GridHelper.ulGridToExcel(ultraGrid1, Text);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}