using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using DevComponents.DotNetBar.Layout; using DevComponents.DotNetBar.SuperGrid; 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 GCList = new List() { //SuperGridUtil.Get_GridColumn("LOG_WCSSYSTEM", "WCS系统", 80), //SuperGridUtil.Get_GridColumn("Log_Level", "消息等级", 80), //SuperGridUtil.Get_GridColumn("Log_Func", "消息函数", 150), //SuperGridUtil.Get_GridColumn("Log_IPAdderss", "IP地址", 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", "结束时间", 80), SuperGridUtil.Get_Datetime_GridColumn("TIMES", "次数", 130) }; List LCIList = new List(); //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_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] FROM [dbo].[WCS_EXCEPTION] where 1=1 "; 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) { } } }