FrmLog.cs 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10. using DevComponents.DotNetBar.Layout;
  11. using DevComponents.DotNetBar.SuperGrid;
  12. using WCS_Client.UC;
  13. using WCS_Client.Utility;
  14. namespace WCS_Client.Frm
  15. {
  16. public partial class FrmLog : Form
  17. {
  18. public FrmLog()
  19. {
  20. InitializeComponent();
  21. InitFrm();
  22. }
  23. private void InitFrm()
  24. {
  25. List<GridColumn> GCList = new List<GridColumn>()
  26. {
  27. //SuperGridUtil.Get_GridColumn("LOG_WCSSYSTEM", "WCS系统", 80),
  28. //SuperGridUtil.Get_GridColumn("Log_Level", "消息等级", 80),
  29. //SuperGridUtil.Get_GridColumn("Log_Func", "消息函数", 150),
  30. //SuperGridUtil.Get_GridColumn("Log_IPAdderss", "IP地址", 80),
  31. SuperGridUtil.Get_GridColumn("MSG", "消息", 500),
  32. //SuperGridUtil.Get_GridColumn("Log_InfoDtl", "消息详情", 500),
  33. //SuperGridUtil.Get_GridColumn("Log_AddUserName", "创建用户", 80),
  34. SuperGridUtil.Get_Datetime_GridColumn("STARTTIME", "创建时间", 130),
  35. SuperGridUtil.Get_GridColumn("UPDATETIME", "结束时间", 130),
  36. SuperGridUtil.Get_Datetime_GridColumn("TIMES", "次数", 130),
  37. //SuperGridUtil.Get_Datetime_GridColumn("Continued", "持续时间", 130)
  38. };
  39. List<LayoutControlItem> LCIList = new List<LayoutControlItem>();
  40. //LCIList.Add(LCItemUtil.Add_TextboxX("Log_Level", "消息等级:", 20, SubmitMethods, null));
  41. //LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "Log_Level like '%{0}%'" };
  42. //LCIList.Add(LCItemUtil.Add_TextboxX("Log_Func", "消息函数:", 20, SubmitMethods, null));
  43. //LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "Log_Func like '%{0}%'" };
  44. LCIList.Add(LCItemUtil.Add_TextboxX("MSG", "消息:", 20, SubmitMethods, null));
  45. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "MSG like '%{0}%'" };
  46. LCIList.Add(LCItemUtil.Add_ButtonX("btn_QDB", "查询", 80, 30, SubmitMethods));
  47. LCIList.Add(LCItemUtil.Add_ButtonX("btn_QClear", "重置", 80, 30, SubmitMethods));
  48. uC_QueryPage1.Init_QueryPage(57, true, true, "", GCList, LCIList, QueryPageDataMethods, RefreshRoleMethods, DoubleClikMethod, null, null);
  49. uC_QueryPage1.ClearLCItemValue();
  50. CommonShow.ShowProcessing("正在处理中,请稍候...", this, (obj) =>
  51. {
  52. uC_QueryPage1.RefreshData(1, 0);
  53. }, null);
  54. }
  55. private PageData QueryPageDataMethods(int PageIndex, int PageSize)
  56. {
  57. string _SQLText = @"SELECT [MSG],[STARTTIME],[UPDATETIME],[TIMES] FROM [dbo].[WCS_EXCEPTION] where MSG not like '%接口调用中%'";
  58. string _Orderby = "UPDATETIME desc ";
  59. PageData pd = BaseWorkflow.QueryPageData(_SQLText, _Orderby, uC_QueryPage1.GetQueryWhere(), PageIndex, PageSize);
  60. return pd;
  61. }
  62. private void SubmitMethods(string LCName)
  63. {
  64. if (LCName == "btn_QDB")
  65. {
  66. uC_QueryPage1.RefreshData();
  67. }
  68. else if (LCName == "btn_QClear")
  69. {
  70. uC_QueryPage1.ShowOpaqueLayer();
  71. uC_QueryPage1.ClearLCItemValue();
  72. uC_QueryPage1.RefreshData(1, 0);
  73. uC_QueryPage1.HideOpaqueLayer();
  74. }
  75. }
  76. private void DoubleClikMethod(DataRow dr)
  77. {
  78. }
  79. private void RefreshRoleMethods(bool ChkValue)
  80. {
  81. }
  82. }
  83. }