FrmWCS_Task.cs 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271
  1. using DevComponents.DotNetBar.Layout;
  2. using DevComponents.DotNetBar.SuperGrid;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Data;
  6. using System.Windows.Forms;
  7. using WCS.Data.Models;
  8. using WCS_Client.UC;
  9. using WCS_Client.Utility;
  10. namespace WCS_Client.Frm
  11. {
  12. public partial class FrmWCS_Task : Form
  13. {
  14. private int wcs_task_no = 0;
  15. public FrmWCS_Task()
  16. {
  17. InitializeComponent();
  18. InitFrm();
  19. }
  20. private void InitFrm()
  21. {
  22. List<GridColumn> GCList = new List<GridColumn>()
  23. {
  24. SuperGridUtil.Get_GridColumn("ID", "任务ID号", 80),
  25. SuperGridUtil.Get_GridColumn("WMSTASK", "WMS任务号", 80),
  26. SuperGridUtil.Get_GridColumn("task_comtypech", "任务类型", 80),
  27. SuperGridUtil.Get_GridColumn("task_wkstatusch", "任务状态", 100),
  28. SuperGridUtil.Get_GridColumn("BARCODE", "条码", 160),
  29. SuperGridUtil.Get_GridColumn("ADDRFROM", "起始地址", 100),
  30. SuperGridUtil.Get_GridColumn("ADDRCURRENT", "当前地址", 80),
  31. SuperGridUtil.Get_GridColumn("ADDRNEXT", "下个地址", 80),
  32. SuperGridUtil.Get_GridColumn("ADDRTO", "目的地址", 100),
  33. SuperGridUtil.Get_GridColumn("ADDRline", "目标产线", 100),
  34. SuperGridUtil.Get_GridColumn("DEVICE", "堆垛机编号", 80),
  35. SuperGridUtil.Get_GridColumn("TUNNEL", "巷道", 70),
  36. SuperGridUtil.Get_GridColumn("Priority", "优先级", 60),
  37. SuperGridUtil.Get_GridColumn("PALLETTYPE", "托盘类型", 80),
  38. //SuperGridUtil.Get_GridColumn("TASK_RGVNO", "RGV编号", 70),
  39. SuperGridUtil.Get_GridColumn("GROUPTASK", "分组编号", 80),
  40. SuperGridUtil.Get_GridColumn("AgvTask", "AGV任务号", 100),
  41. SuperGridUtil.Get_GridColumn("TASK_ADDUSERNO", "创建用户", 100),
  42. SuperGridUtil.Get_Datetime_GridColumn("CREATETIME", "创建时间", 130),
  43. SuperGridUtil.Get_Datetime_GridColumn("STARTTIME", "开始时间", 130),
  44. SuperGridUtil.Get_Datetime_GridColumn("ENDTIME", "结束时间", 130),
  45. SuperGridUtil.Get_GridColumn("UPDATEUSER", "修改用户", 100),
  46. SuperGridUtil.Get_Datetime_GridColumn("UPDATETIME", "修改时间", 130),
  47. SuperGridUtil.Get_GridColumn("PRODLINE", "产线", 100),
  48. SuperGridUtil.Get_GridColumn("SRMSTATION", "站台号", 100),
  49. // SuperGridUtil.Get_GridColumn("SonTrayColorNo", "子托盘颜色", 100),
  50. // SuperGridUtil.Get_GridColumn("TASK_WEIGHT", "箱子重量", 100),
  51. //SuperGridUtil.Get_GridColumn("TASK_STACKINGTYPE", "垛型", 100)
  52. //SuperGridUtil.Get_CheckBoxX_GridColumn("Task_IsInventory", "是否盘点任务", 80),
  53. //SuperGridUtil.Get_CheckBoxX_GridColumn("Task_IsEmptyBox", "是否空箱", 80),
  54. };
  55. List<LayoutControlItem> LCIList = new List<LayoutControlItem>();
  56. LCIList.Add(LCItemUtil.Add_TextboxX("ID", "WCS任务号:", 20, SubmitMethods, null));
  57. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "ID like '%{0}%'" };
  58. LCIList.Add(LCItemUtil.Add_TextboxX("WMSTASK", "WMS任务号:", 20, SubmitMethods, null));
  59. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "WMSTASK like '%{0}%'" };
  60. LCIList.Add(LCItemUtil.Add_TextboxX("BARCODE", "条码:", 20, SubmitMethods, null));
  61. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "BARCODE like '%{0}%'" };
  62. LCIList.Add(LCItemUtil.Add_TextboxX("ADDRFROM", "起始地址:", 20, SubmitMethods, null));
  63. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "ADDRFROM like '%{0}%'" };
  64. LCIList.Add(LCItemUtil.Add_TextboxX("ADDRCURRENT", "当前地址:", 20, SubmitMethods, null));
  65. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "ADDRCURRENT like '%{0}%'" };
  66. LCIList.Add(LCItemUtil.Add_TextboxX("ADDRNEXT", "下个地址:", 20, SubmitMethods, null));
  67. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "ADDRNEXT like '%{0}%'" };
  68. LCIList.Add(LCItemUtil.Add_TextboxX("ADDRTO", "目的地址:", 20, SubmitMethods, null));
  69. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "ADDRTO like '%{0}%'" };
  70. LCIList.Add(LCItemUtil.Add_TextboxX("DEVICE", "堆垛机编号:", 20, SubmitMethods, null));
  71. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "DEVICE like '%{0}%'" };
  72. LCIList.Add(LCItemUtil.Add_ComboBoxEx("TYPE", "任务类型:", 20, null, SubmitMethods));
  73. TryCachHelper.TryExecute((db) =>
  74. {
  75. var dtsex = db.Queryable<WCS_MAPPINGENTRY>().Where(v => v.MEP_MAPPINGTYPE == "TYPE").ToList();
  76. DataTable dt = new DataTable();
  77. DataRow dr;
  78. dt.Columns.Add("MEP_MAPPINGNO");
  79. dt.Columns.Add("MEP_MAPPINGCHNAME");
  80. for (int i = 0; i < dtsex.Count; i++)
  81. {
  82. dr = dt.NewRow();
  83. dr["MEP_MAPPINGNO"] = dtsex[i].MEP_MAPPINGNO;
  84. dr["MEP_MAPPINGCHNAME"] = dtsex[i].MEP_MAPPINGCHNAME;
  85. dt.Rows.Add(dr);
  86. }
  87. LCItemUtil.Refresh_LCItem(LCIList[LCIList.Count - 1], dt, "MEP_MAPPINGNO", "MEP_MAPPINGCHNAME");
  88. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "TYPE like '%{0}%'" };
  89. });
  90. LCIList.Add(LCItemUtil.Add_ComboBoxEx("STATUS", "任务状态:", 20, null, SubmitMethods));
  91. TryCachHelper.TryExecute((db) =>
  92. {
  93. var dtsex = db.Queryable<WCS_MAPPINGENTRY>().Where(v => v.MEP_MAPPINGTYPE == "STATUS").ToList();
  94. DataTable dt = new DataTable();
  95. DataRow dr;
  96. dt.Columns.Add("MEP_MAPPINGNO");
  97. dt.Columns.Add("MEP_MAPPINGCHNAME");
  98. for (int i = 0; i < dtsex.Count; i++)
  99. {
  100. dr = dt.NewRow();
  101. dr["MEP_MAPPINGNO"] = dtsex[i].MEP_MAPPINGNO;
  102. dr["MEP_MAPPINGCHNAME"] = dtsex[i].MEP_MAPPINGCHNAME;
  103. dt.Rows.Add(dr);
  104. }
  105. LCItemUtil.Refresh_LCItem(LCIList[LCIList.Count - 1], dt, "MEP_MAPPINGNO", "MEP_MAPPINGCHNAME");
  106. LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "STATUS like '%{0}%'" };
  107. });
  108. LCIList.Add(LCItemUtil.Add_ButtonX("btn_QDB", "查询", 100, 30, SubmitMethods));
  109. LCIList.Add(LCItemUtil.Add_ButtonX("btn_QClear", "重置", 100, 30, SubmitMethods));
  110. if (CurrentHelper.User.Use_RoleId == 1)
  111. {
  112. LCIList.Add(LCItemUtil.Add_ButtonX("btn_FinishTask", "手动完成任务", 100, 30, SubmitMethods));
  113. LCIList.Add(LCItemUtil.Add_ButtonX("btn_ClearTask", "取消任务", 100, 30, SubmitMethods));
  114. LCIList.Add(LCItemUtil.Add_ButtonX("btn_UpdatePriority", "修改优先级", 100, 30, SubmitMethods));
  115. LCIList.Add(LCItemUtil.Add_ButtonX("btn_RestartTask", "重新下发出库任务", 200, 30, SubmitMethods));
  116. }
  117. uC_QueryPage1.Init_QueryPage(86, true, true, "", GCList, LCIList, QueryPageDataMethods, RefreshRoleMethods, null, null, ClikMethod);
  118. uC_QueryPage1.ClearLCItemValue();
  119. CommonShow.ShowProcessing("正在处理中,请稍候...", this, (obj) =>
  120. {
  121. uC_QueryPage1.RefreshData(1, 0);
  122. }, null);
  123. }
  124. //获取数据集
  125. private PageData QueryPageDataMethods(int PageIndex, int PageSize)
  126. {
  127. string _SQLText = @"select t.*,m.MEP_MAPPINGCHNAME task_comtypech,me.MEP_MAPPINGCHNAME task_wkstatusch from dbo.WCS_TASK t
  128. left join WCS_MAPPINGENTRY m on t.TYPE = m.MEP_MAPPINGNO and m.MEP_MAPPINGTYPE = 'TYPE'
  129. left join WCS_MAPPINGENTRY me on t.STATUS = me.MEP_MAPPINGNO and me.MEP_MAPPINGTYPE = 'STATUS' where 1=1 and STATUS < 99 ";
  130. string _Orderby = "CREATETIME desc ";
  131. PageData pd = BaseWorkflow.QueryPageData(_SQLText, _Orderby, uC_QueryPage1.GetQueryWhere(), PageIndex, PageSize);
  132. return pd;
  133. }
  134. /// <summary>
  135. /// 按钮触发事件
  136. /// </summary>
  137. /// <param name="LCName"></param>
  138. private void SubmitMethods(string LCName)
  139. {
  140. if (LCName == "btn_QDB")
  141. {
  142. uC_QueryPage1.RefreshData();
  143. }
  144. else if (LCName == "btn_RestartTask")
  145. {
  146. DataTable dt = this.uC_QueryPage1.SCGrid_GetChkRows();
  147. if (dt == null || dt.Rows.Count == 0)
  148. {
  149. MessageUtil.ShowTips("请选择任务。");
  150. return;
  151. }
  152. int task_no = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
  153. var result = MessageUtil.ShowYesNoAndWarning(string.Format("任务[{0}]确定要重下出库任务吗(请谨慎操作)?", task_no));
  154. if (result == DialogResult.Yes)
  155. {
  156. string msg = BaseWorkflow.RestartTask(task_no);
  157. MessageUtil.ShowTips(msg);
  158. uC_QueryPage1.RefreshData(1, 0);
  159. }
  160. }
  161. else if (LCName == "btn_FinishTask")
  162. {
  163. DataTable dt = this.uC_QueryPage1.SCGrid_GetChkRows();
  164. if (dt == null || dt.Rows.Count == 0)
  165. {
  166. MessageUtil.ShowTips("请选择任务。");
  167. return;
  168. }
  169. int task_no = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
  170. var result = MessageUtil.ShowYesNoAndWarning(string.Format("任务[{0}]确定要[手动完成任务]吗(请谨慎操作)?", task_no));
  171. if (result == DialogResult.Yes)
  172. {
  173. string msg = BaseWorkflow.FinishTask(task_no);
  174. MessageUtil.ShowTips(msg);
  175. uC_QueryPage1.RefreshData(1, 0);
  176. }
  177. }
  178. else if (LCName == "btn_ClearTask")
  179. {
  180. DataTable dt = this.uC_QueryPage1.SCGrid_GetChkRows();
  181. if (dt == null || dt.Rows.Count == 0)
  182. {
  183. MessageUtil.ShowTips("请选择任务。");
  184. return;
  185. }
  186. int task_no = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
  187. var result = MessageUtil.ShowYesNoAndWarning(string.Format("任务[{0}]确定要[取消任务]吗(请谨慎操作)?", task_no));
  188. if (result == DialogResult.Yes)
  189. {
  190. string msg = BaseWorkflow.ClearTask(task_no);
  191. MessageUtil.ShowTips(msg);
  192. uC_QueryPage1.RefreshData(1, 0);
  193. }
  194. }
  195. else if (LCName == "btn_QClear")
  196. {
  197. uC_QueryPage1.ShowOpaqueLayer();
  198. uC_QueryPage1.ClearLCItemValue();
  199. uC_QueryPage1.RefreshData(1, 0);
  200. uC_QueryPage1.HideOpaqueLayer();
  201. }
  202. else if (LCName == "btn_CreateProInTask")
  203. {
  204. //FrmCreateTask frm = new FrmCreateTask();
  205. //frm.ShowDialog();
  206. uC_QueryPage1.RefreshData(1, 0);
  207. }
  208. else if (LCName == "btn_UpdateEndAddress")
  209. {
  210. DataTable dt = this.uC_QueryPage1.SCGrid_GetChkRows();
  211. if (dt == null || dt.Rows.Count == 0)
  212. {
  213. MessageUtil.ShowTips("请选择任务。");
  214. return;
  215. }
  216. DataRow dr = dt.Rows[0];
  217. string comtypech = dt.Rows[0]["task_comtypech"].ToString();
  218. if (comtypech.Contains("入库"))
  219. {
  220. var frmUpdateEndAddress = new FrmUpdateEndAddress(dr);
  221. frmUpdateEndAddress.ShowDialog();
  222. }
  223. else
  224. {
  225. MessageUtil.ShowTips("只有入库任务能变更目标地址。");
  226. }
  227. }
  228. else if (LCName == "btn_UpdatePriority")
  229. {
  230. DataTable dt = this.uC_QueryPage1.SCGrid_GetChkRows();
  231. if (dt == null || dt.Rows.Count == 0)
  232. {
  233. MessageUtil.ShowTips("请选择任务。");
  234. return;
  235. }
  236. DataRow dr = dt.Rows[0];
  237. var frmUpdatePriority = new FrmUpdatePriority(dr);
  238. frmUpdatePriority.ShowDialog();
  239. uC_QueryPage1.RefreshData(1, 0);
  240. }
  241. }
  242. private void RefreshRoleMethods(bool ChkValue)
  243. {
  244. //if (AppConst.CheckExtentByName("查询任务"))
  245. //
  246. }
  247. private void ClikMethod(DataRow dr)
  248. {
  249. }
  250. }
  251. }