YG-OPP-WCS-Client/WCS_Client/Frm/MBtn_Log/FrmLog.cs

using DevComponents.DotNetBar.Layout;
using DevComponents.DotNetBar.SuperGrid;
using System.Collections.Generic;
using System.Data;
using System.Windows.Forms;
using WCS_Client.UC;
using WCS_Client.Utility;

namespace WCS_Client.Frm
{
    public partial class FrmLog : Form
    {
        public FrmLog()
        {
            InitializeComponent();
            InitFrm();
        }

        private void InitFrm()
        {
            List<GridColumn> GCList = new List<GridColumn>()
            {
                //SuperGridUtil.Get_GridColumn("LOG_WCSSYSTEM", "WCS系统", 80),
                //SuperGridUtil.Get_GridColumn("Log_Level", "消息等级", 80),
                //SuperGridUtil.Get_GridColumn("Log_Func", "消息函数", 150),
                SuperGridUtil.Get_GridColumn("DEVICE", "所属设备", 80),
                SuperGridUtil.Get_GridColumn("MSG", "消息", 500),
                //SuperGridUtil.Get_GridColumn("Log_InfoDtl", "消息详情", 500),
                //SuperGridUtil.Get_GridColumn("Log_AddUserName", "创建用户", 80),
                SuperGridUtil.Get_Datetime_GridColumn("STARTTIME", "创建时间", 130),
                SuperGridUtil.Get_GridColumn("UPDATETIME", "结束时间", 130),
                SuperGridUtil.Get_Datetime_GridColumn("TIMES", "次数", 130),
                //SuperGridUtil.Get_Datetime_GridColumn("Continued", "持续时间", 130)
            };
            List<LayoutControlItem> LCIList = new List<LayoutControlItem>();
            //LCIList.Add(LCItemUtil.Add_TextboxX("Log_Level", "消息等级:", 20, SubmitMethods, null));
            //LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "Log_Level like '%{0}%'" };

            //LCIList.Add(LCItemUtil.Add_TextboxX("Log_Func", "消息函数:", 20, SubmitMethods, null));
            //LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "Log_Func like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("MSG", "消息:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "MSG like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("DEVICE", "设备:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "DEVICE like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_ButtonX("btn_QDB", "查询", 80, 30, SubmitMethods));
            LCIList.Add(LCItemUtil.Add_ButtonX("btn_QClear", "重置", 80, 30, SubmitMethods));

            uC_QueryPage1.Init_QueryPage(57, true, true, "", GCList, LCIList, QueryPageDataMethods, RefreshRoleMethods, DoubleClikMethod, null, null);
            uC_QueryPage1.ClearLCItemValue();
            CommonShow.ShowProcessing("正在处理中，请稍候...", this, (obj) =>
            {
                uC_QueryPage1.RefreshData(1, 0);
            }, null);
        }

        private PageData QueryPageDataMethods(int PageIndex, int PageSize)
        {
            string _SQLText = @"SELECT [MSG],[STARTTIME],[UPDATETIME],[TIMES],[DEVICE] FROM [dbo].[WCS_EXCEPTION] where MSG not like '%接口调用中%' and MSG not like '%并发管控%'";
            string _Orderby = "UPDATETIME desc ";

            PageData pd = BaseWorkflow.QueryPageData(_SQLText, _Orderby, uC_QueryPage1.GetQueryWhere(), PageIndex, PageSize);
            return pd;
        }

        private void SubmitMethods(string LCName)
        {
            if (LCName == "btn_QDB")
            {
                uC_QueryPage1.RefreshData();
            }
            else if (LCName == "btn_QClear")
            {
                uC_QueryPage1.ShowOpaqueLayer();
                uC_QueryPage1.ClearLCItemValue();
                uC_QueryPage1.RefreshData(1, 0);
                uC_QueryPage1.HideOpaqueLayer();
            }
        }

        private void DoubleClikMethod(DataRow dr)
        {
        }

        private void RefreshRoleMethods(bool ChkValue)
        {
        }
    }
}