MBtn_AgvTask_Dis.cs 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153
  1. using DevComponents.DotNetBar.Layout;
  2. using DevComponents.DotNetBar.SuperGrid;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.ComponentModel;
  6. using System.Data;
  7. using System.Drawing;
  8. using System.Linq;
  9. using System.Text;
  10. using System.Threading.Tasks;
  11. using System.Windows.Forms;
  12. using WCS.Data.Models;
  13. using WCS_Client;
  14. using WCS_Client.UC;
  15. using WCS_Client.Utility;
  16. namespace WCS_Client.Frm.MBtn_AgvTaskDis
  17. {
  18. public partial class MBtn_AgvTask_Dis : Form
  19. {
  20. int wcs_task_no = 0;
  21. public MBtn_AgvTask_Dis()
  22. {
  23. InitializeComponent();
  24. InitFrm();
  25. }
  26. private void InitFrm()
  27. {
  28. List<GridColumn> GCList = new List<GridColumn>()
  29. {
  30. SuperGridUtil.Get_GridColumn("ID", "任务ID", 80),
  31. SuperGridUtil.Get_GridColumn("AGVID", "AGV任务号", 180),
  32. SuperGridUtil.Get_GridColumn("WCSTASK", "WCS任务号", 80),
  33. SuperGridUtil.Get_GridColumn("WMSTASK", "WMS任务号", 80),
  34. SuperGridUtil.Get_GridColumn("AgvTaskTypeCh", "任务类型", 80),
  35. SuperGridUtil.Get_GridColumn("StatusCh", "任务状态", 80),
  36. SuperGridUtil.Get_GridColumn("AgvStatusCh", "AGV任务状态", 100),
  37. SuperGridUtil.Get_GridColumn("Workshop", "车间", 80),
  38. SuperGridUtil.Get_GridColumn("Station", "站台地址", 60),
  39. SuperGridUtil.Get_GridColumn("Position", "起始地址", 100),
  40. SuperGridUtil.Get_GridColumn("CreateTime", "创建时间", 180),
  41. SuperGridUtil.Get_GridColumn("UpdateTime", "修改时间", 180),
  42. SuperGridUtil.Get_GridColumn("AGVUpdateTime", "AGV修改时间", 180),
  43. };
  44. List<LayoutControlItem> LCIList = new List<LayoutControlItem>();
  45. LCIList.Add(LCItemUtil.Add_TextboxX("ID", "ID:", 20, SubmitMethods, null));
  46. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "a.ID like '%{0}%'" };
  47. LCIList.Add(LCItemUtil.Add_TextboxX("AGVID", "AGV任务号:", 20, SubmitMethods, null));
  48. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "a.AGVID like '%{0}%'" };
  49. LCIList.Add(LCItemUtil.Add_TextboxX("WCSTASK", "WCS任务号:", 20, SubmitMethods, null));
  50. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.ID like '%{0}%'" };
  51. LCIList.Add(LCItemUtil.Add_TextboxX("WESTASK", "WMS任务号:", 20, SubmitMethods, null));
  52. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.WMSTASK like '%{0}%'" };
  53. LCIList.Add(LCItemUtil.Add_TextboxX("Position", "起始地址:", 20, SubmitMethods, null));
  54. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "a.Position like '%{0}%'" };
  55. LCIList.Add(LCItemUtil.Add_TextboxX("Station", "站台地址:", 20, SubmitMethods, null));
  56. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "a.Station like '%{0}%'" };
  57. LCIList.Add(LCItemUtil.Add_TextboxX("Workshop", "车间:", 20, SubmitMethods, null));
  58. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "a.Workshop like '%{0}%'" };
  59. LCIList.Add(LCItemUtil.Add_ComboBoxEx("TaskType", "任务类型:", 20, null, SubmitMethods));
  60. TryCachHelper.TryExecute((db) =>
  61. {
  62. var dtsex = db.Queryable<WCS_MAPPINGENTRY>().Where(v => v.MEP_MAPPINGTYPE == "TaskType").ToList();
  63. DataTable dt = new DataTable();
  64. DataRow dr;
  65. dt.Columns.Add("MEP_MAPPINGNO");
  66. dt.Columns.Add("MEP_MAPPINGCHNAME");
  67. for (int i = 0; i < dtsex.Count; i++)
  68. {
  69. dr = dt.NewRow();
  70. dr["MEP_MAPPINGNO"] = dtsex[i].MEP_MAPPINGNO;
  71. dr["MEP_MAPPINGCHNAME"] = dtsex[i].MEP_MAPPINGCHNAME;
  72. dt.Rows.Add(dr);
  73. }
  74. LCItemUtil.Refresh_LCItem(LCIList[LCIList.Count - 1], dt, "MEP_MAPPINGNO", "MEP_MAPPINGCHNAME");
  75. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "a.TaskType like '%{0}%'" };
  76. });
  77. LCIList.Add(LCItemUtil.Add_ComboBoxEx("AGVStatus", "任务状态:", 20, null, SubmitMethods));
  78. TryCachHelper.TryExecute((db) =>
  79. {
  80. var dtsex = db.Queryable<WCS_MAPPINGENTRY>().Where(v => v.MEP_MAPPINGTYPE == "AGVStatus").ToList();
  81. DataTable dt = new DataTable();
  82. DataRow dr;
  83. dt.Columns.Add("MEP_MAPPINGNO");
  84. dt.Columns.Add("MEP_MAPPINGCHNAME");
  85. for (int i = 0; i < dtsex.Count; i++)
  86. {
  87. dr = dt.NewRow();
  88. dr["MEP_MAPPINGNO"] = dtsex[i].MEP_MAPPINGNO;
  89. dr["MEP_MAPPINGCHNAME"] = dtsex[i].MEP_MAPPINGCHNAME;
  90. dt.Rows.Add(dr);
  91. }
  92. LCItemUtil.Refresh_LCItem(LCIList[LCIList.Count - 1], dt, "MEP_MAPPINGNO", "MEP_MAPPINGCHNAME");
  93. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "a.STATUS like '%{0}%'" };
  94. });
  95. LCIList.Add(LCItemUtil.Add_ButtonX("btn_QDB", "查询", 80, 30, SubmitMethods));
  96. LCIList.Add(LCItemUtil.Add_ButtonX("btn_QClear", "重置", 80, 30, SubmitMethods));
  97. uC_QueryPage1.Init_QueryPage(60, true, true, "", GCList, LCIList, QueryPageDataMethods, RefreshRoleMethods, DoubleClikMethod, null, null);
  98. uC_QueryPage1.ClearLCItemValue();
  99. CommonShow.ShowProcessing("正在处理中,请稍候...", this, (obj) =>
  100. {
  101. uC_QueryPage1.RefreshData(1, 0);
  102. }, null);
  103. }
  104. private PageData QueryPageDataMethods(int PageIndex, int PageSize)
  105. {
  106. string _SQLText = @"SELECT a.*,t.ID WCSTASK,t.WMSTASK,b.MEP_MAPPINGCHNAME AgvTaskTypeCh,c.MEP_MAPPINGCHNAME StatusCh,d.MEP_MAPPINGCHNAME AgvStatusCh FROM dbo.WCS_AGVTask a
  107. left join dbo.WCS_TASK t on a.ID=t.AgvTask
  108. left join dbo.WCS_MAPPINGENTRY b on a.TaskType=b.MEP_MAPPINGNO and b.MEP_MAPPINGTYPE='TaskType'
  109. left join dbo.WCS_MAPPINGENTRY c on a.Status=c.MEP_MAPPINGNO and c.MEP_MAPPINGTYPE='AGVStatus'
  110. left join dbo.WCS_MAPPINGENTRY d on a.AGVStatus=d.MEP_MAPPINGNO and d.MEP_MAPPINGTYPE='AGVStatus' Where 1=1 and a.Status >= 100";
  111. string _Orderby = "a.CreateTime desc";
  112. PageData pd = BaseWorkflow.QueryPageData(_SQLText, _Orderby, uC_QueryPage1.GetQueryWhere(), PageIndex, PageSize);
  113. return pd;
  114. }
  115. private void SubmitMethods(string LCName)
  116. {
  117. if (LCName == "btn_QDB")
  118. {
  119. uC_QueryPage1.RefreshData();
  120. }
  121. else if (LCName == "btn_QClear")
  122. {
  123. uC_QueryPage1.ShowOpaqueLayer();
  124. uC_QueryPage1.ClearLCItemValue();
  125. uC_QueryPage1.RefreshData(1, 0);
  126. uC_QueryPage1.HideOpaqueLayer();
  127. }
  128. }
  129. private void DoubleClikMethod(DataRow dr)
  130. {
  131. }
  132. private void RefreshRoleMethods(bool ChkValue)
  133. {
  134. }
  135. }
  136. }