ReportController.cs 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543
  1. using Microsoft.AspNetCore.Mvc;
  2. using Newtonsoft.Json;
  3. using System.Collections.Generic;
  4. using System.Data;
  5. using System.Web;
  6. using WMS.BZModels.Dto.SX.BaseMatinfoDtos;
  7. using WMS.BZModels.Dto.SX.BillInvDtos;
  8. using WMS.BZModels.Dto.SX.BilltimeoutrecordDtos;
  9. using WMS.BZModels.Dto.SX.ReportDtos;
  10. using WMS.BZModels.Dto.SX.SysConDtos;
  11. using WMS.BZServices.SX;
  12. using WMS.Info;
  13. using WMS.Util;
  14. namespace WMS.BZWeb.Areas.SXManager.Controllers
  15. {
  16. [Area("SXManager")]
  17. public class ReportController : MvcControllerBase
  18. {
  19. private readonly ReportService _report;
  20. private readonly SysConService _syscon;
  21. private readonly BillTimeOutRecordService _billTimeOutRecordService;
  22. public ReportController(ReportService report, SysConService syscon, BillTimeOutRecordService billTimeOutRecordService)
  23. {
  24. _report = report;
  25. _syscon = syscon;
  26. _billTimeOutRecordService = billTimeOutRecordService;
  27. }
  28. #region 页面
  29. public IActionResult Index()
  30. {
  31. return View();
  32. }
  33. public IActionResult cellreportIndex()
  34. {
  35. return View();
  36. }
  37. public IActionResult StockKeepReportIndex()
  38. {
  39. return View();
  40. }
  41. public IActionResult MatNameNetWeightReport()
  42. {
  43. return View();
  44. }
  45. public IActionResult TimeOutRecordIndex()
  46. {
  47. return View();
  48. }
  49. public IActionResult TimeOutRecordDetail()
  50. {
  51. return View();
  52. }
  53. #endregion
  54. public ActionResult GetPageList(string pagination, string queryJson)
  55. {
  56. Pagination paginationobj = InitPagination(pagination);
  57. var query = new ReportQueryDto();
  58. if (!string.IsNullOrEmpty(queryJson))
  59. {
  60. query = JsonConvert.DeserializeObject<ReportQueryDto>(queryJson);
  61. }
  62. var lists = _report.GetPageList(paginationobj, query ?? new ReportQueryDto());
  63. var jsonData = new
  64. {
  65. rows = lists.Result,
  66. total = lists.TotalPage,
  67. page = lists.PageIndex,
  68. records = lists.TotalNum
  69. };
  70. return Success(jsonData);
  71. }
  72. public ActionResult GetLocationUsageReportList()
  73. {
  74. var lists = _report.GetLocationUsageReportList();
  75. Pagination paginationobj = InitPagination(null);
  76. var tunnellists = _syscon.GetTunnelList(paginationobj, new TunnelQueryDto());
  77. if (tunnellists != null && tunnellists.Result.Any())
  78. {
  79. //更新巷道状态
  80. lists.ForEach(s =>
  81. {
  82. var conf = tunnellists.Result.Where(m => m.Tunnel == s.Tunnel && m.Floor == s.Floor).ToList();
  83. if (conf != null)
  84. {
  85. if (conf.Where(o => o.Name.Contains("入库")).Any())
  86. {
  87. s.InStates = conf.Where(o => o.Name.Contains("入库")).First().StatuName;
  88. }
  89. if (conf.Where(o => o.Name.Contains("出库")).Any())
  90. {
  91. s.OutStates = conf.Where(o => o.Name.Contains("出库")).First().StatuName;
  92. }
  93. }
  94. });
  95. }
  96. //var totallists= new List<dynamic>(){ new { UnitName="总货位",qty= lists.Sum(s=>s.AllLocationTotal)},
  97. // new { UnitName="有效货位",qty= lists.Sum(s=>s.CanUseLocation)},
  98. // new { UnitName="空余货位",qty= lists.Sum(s=>s.SpareLocation)},
  99. // new { UnitName="锁定货位",qty= lists.Sum(s=>s.LockLocation)},
  100. // new { UnitName="停用货位",qty= lists.Sum(s=>s.StopLocation)},
  101. // new { UnitName="有料货位",qty= lists.Sum(s=>s.MaterilLocation)}};
  102. lists = lists.OrderBy(s => s.Tunnel).ThenBy(o => o.Floor).ToList();
  103. lists.Add(new LocationUsageReportViewDto()
  104. {
  105. Tunnel = "",
  106. Floor = "",
  107. WarehouseName = "合计:",
  108. AllLocationTotal = lists.Sum(s => s.AllLocationTotal),
  109. CanUseLocation = lists.Sum(s => s.CanUseLocation),
  110. SpareLocation = lists.Sum(s => s.SpareLocation),
  111. LockLocation = lists.Sum(s => s.LockLocation),
  112. StopLocation = lists.Sum(s => s.StopLocation),
  113. MaterilLocation = lists.Sum(s => s.MaterilLocation),
  114. });
  115. return Success(lists);
  116. }
  117. public IActionResult GetStockKeepReportList(string pagination, string queryJson)
  118. {
  119. Pagination paginationobj = InitPagination(pagination);
  120. var query = new BillInvNowQueryDto();
  121. if (!string.IsNullOrEmpty(queryJson))
  122. {
  123. query = JsonConvert.DeserializeObject<BillInvNowQueryDto>(queryJson);
  124. }
  125. var lists = _report.GetStockKeepReportList(paginationobj, query ?? new BillInvNowQueryDto());
  126. var jsonData = new
  127. {
  128. rows = lists.Result,
  129. total = lists.TotalPage,
  130. page = lists.PageIndex,
  131. records = lists.TotalNum
  132. };
  133. return Success(jsonData);
  134. }
  135. /// <summary>
  136. /// 获取货位使用率
  137. /// </summary>
  138. /// <param name="pagination"></param>
  139. /// <param name="queryJson"></param>
  140. /// <returns></returns>
  141. public ActionResult GetCellList(string pagination, string queryJson)
  142. {
  143. Pagination paginationobj = InitPagination(pagination);
  144. var query = new ReportQueryDto();
  145. if (!string.IsNullOrEmpty(queryJson))
  146. {
  147. query = JsonConvert.DeserializeObject<ReportQueryDto>(queryJson);
  148. }
  149. var lists = _report.GetPageList(paginationobj, query ?? new ReportQueryDto());
  150. var jsonData = new
  151. {
  152. rows = lists.Result,
  153. total = lists.TotalPage,
  154. page = lists.PageIndex,
  155. records = lists.TotalNum
  156. };
  157. return Success(jsonData);
  158. }
  159. public ActionResult GetMatNameNetWeightCategory(string pagination, string queryJson)
  160. {
  161. Pagination paginationobj = InitPagination(pagination);
  162. var query = new BillInvNowQueryDto();
  163. if (!string.IsNullOrEmpty(queryJson))
  164. {
  165. query = JsonConvert.DeserializeObject<BillInvNowQueryDto>(queryJson);
  166. }
  167. var lists = _report.GetMatNameNetWeightCategory(paginationobj, query ?? new BillInvNowQueryDto());
  168. var jsonData = new
  169. {
  170. rows = lists.Result,
  171. total = lists.TotalPage,
  172. page = lists.PageIndex,
  173. records = lists.TotalNum
  174. };
  175. return Success(jsonData);
  176. }
  177. [HttpPost]
  178. public IActionResult ExportExcel(string fileName, string queryJson, string exportField)
  179. {
  180. var query = new ReportQueryDto();
  181. try
  182. {
  183. if (!string.IsNullOrEmpty(queryJson))
  184. {
  185. query = JsonConvert.DeserializeObject<ReportQueryDto>(queryJson);
  186. }
  187. }
  188. catch (Exception ex)
  189. {
  190. }
  191. //设置导出格式
  192. ExcelConfig excelconfig = new ExcelConfig();
  193. excelconfig.Title = HttpUtility.UrlDecode(fileName);
  194. excelconfig.TitleFont = "微软雅黑";
  195. excelconfig.TitlePoint = 15;
  196. excelconfig.FileName = HttpUtility.UrlDecode(fileName) + ".xls";
  197. excelconfig.IsAllSizeColumn = true;
  198. excelconfig.ColumnEntity = new List<ColumnModel>();
  199. List<jfGridModel> columnList = exportField.ToList<jfGridModel>();
  200. if (columnList.Count == 0)
  201. {
  202. throw new Exception("未找到表头");
  203. }
  204. //行数据
  205. var lists = _report.GetList(query ?? new ReportQueryDto());
  206. var dataJson = JsonConvert.SerializeObject(lists);
  207. DataTable rowData = dataJson.ToTable();
  208. //写入Excel表头
  209. Dictionary<string, string> exportFieldMap = new Dictionary<string, string>();
  210. if (!string.IsNullOrEmpty(exportField))
  211. {
  212. string[] exportFields = exportField.Split(',');
  213. foreach (var field in exportFields)
  214. {
  215. if (!exportFieldMap.ContainsKey(field))
  216. {
  217. exportFieldMap.Add(field, "1");
  218. }
  219. }
  220. }
  221. foreach (var columnModel in columnList)
  222. {
  223. excelconfig.ColumnEntity.Add(new ColumnModel()
  224. {
  225. // Column =string.IsNullOrEmpty(columnModel.sortname)? columnModel.name: columnModel.sortname,
  226. Column = columnModel.name,
  227. ExcelColumn = columnModel.label,
  228. Alignment = columnModel.align,
  229. Width = columnModel.name.Length
  230. });
  231. }
  232. return File(ExcelHelper.NewExportMemoryStream(rowData, excelconfig), "application/ms-excel", excelconfig.FileName);
  233. }
  234. [HttpPost]
  235. public IActionResult ExportLocationUsageReportExcel(string fileName, string queryJson, string exportField)
  236. {
  237. //设置导出格式
  238. ExcelConfig excelconfig = new ExcelConfig();
  239. excelconfig.Title = HttpUtility.UrlDecode(fileName);
  240. excelconfig.TitleFont = "微软雅黑";
  241. excelconfig.TitlePoint = 15;
  242. excelconfig.FileName = HttpUtility.UrlDecode(fileName) + ".xls";
  243. excelconfig.IsAllSizeColumn = true;
  244. excelconfig.ColumnEntity = new List<ColumnModel>();
  245. List<jfGridModel> columnList = exportField.ToList<jfGridModel>();
  246. if (columnList.Count == 0)
  247. {
  248. throw new Exception("未找到表头");
  249. }
  250. //行数据
  251. var lists = _report.GetLocationUsageReportList();
  252. var dataJson = JsonConvert.SerializeObject(lists);
  253. DataTable rowData = dataJson.ToTable();
  254. //写入Excel表头
  255. Dictionary<string, string> exportFieldMap = new Dictionary<string, string>();
  256. if (!string.IsNullOrEmpty(exportField))
  257. {
  258. string[] exportFields = exportField.Split(',');
  259. foreach (var field in exportFields)
  260. {
  261. if (!exportFieldMap.ContainsKey(field))
  262. {
  263. exportFieldMap.Add(field, "1");
  264. }
  265. }
  266. }
  267. foreach (var columnModel in columnList)
  268. {
  269. excelconfig.ColumnEntity.Add(new ColumnModel()
  270. {
  271. // Column =string.IsNullOrEmpty(columnModel.sortname)? columnModel.name: columnModel.sortname,
  272. Column = columnModel.name,
  273. ExcelColumn = columnModel.label,
  274. Alignment = columnModel.align,
  275. Width = columnModel.name.Length
  276. });
  277. }
  278. return File(ExcelHelper.NewExportMemoryStream(rowData, excelconfig), "application/ms-excel", excelconfig.FileName);
  279. }
  280. [HttpPost]
  281. public IActionResult ExportStockKeepReportExcel(string fileName, string queryJson, string exportField)
  282. {
  283. var query = new BillInvNowQueryDto();
  284. try
  285. {
  286. if (!string.IsNullOrEmpty(queryJson))
  287. {
  288. query = JsonConvert.DeserializeObject<BillInvNowQueryDto>(queryJson);
  289. }
  290. }
  291. catch (Exception ex)
  292. {
  293. }
  294. //设置导出格式
  295. ExcelConfig excelconfig = new ExcelConfig();
  296. excelconfig.Title = HttpUtility.UrlDecode(fileName);
  297. excelconfig.TitleFont = "微软雅黑";
  298. excelconfig.TitlePoint = 15;
  299. excelconfig.FileName = HttpUtility.UrlDecode(fileName) + ".xls";
  300. excelconfig.IsAllSizeColumn = true;
  301. excelconfig.ColumnEntity = new List<ColumnModel>();
  302. List<jfGridModel> columnList = exportField.ToList<jfGridModel>();
  303. if (columnList.Count == 0)
  304. {
  305. throw new Exception("未找到表头");
  306. }
  307. //行数据
  308. var lists = _report.GetStockKeepReports(query ?? new BillInvNowQueryDto());
  309. var dataJson = JsonConvert.SerializeObject(lists);
  310. DataTable rowData = dataJson.ToTable();
  311. //写入Excel表头
  312. Dictionary<string, string> exportFieldMap = new Dictionary<string, string>();
  313. if (!string.IsNullOrEmpty(exportField))
  314. {
  315. string[] exportFields = exportField.Split(',');
  316. foreach (var field in exportFields)
  317. {
  318. if (!exportFieldMap.ContainsKey(field))
  319. {
  320. exportFieldMap.Add(field, "1");
  321. }
  322. }
  323. }
  324. foreach (var columnModel in columnList)
  325. {
  326. excelconfig.ColumnEntity.Add(new ColumnModel()
  327. {
  328. // Column =string.IsNullOrEmpty(columnModel.sortname)? columnModel.name: columnModel.sortname,
  329. Column = columnModel.name,
  330. ExcelColumn = columnModel.label,
  331. Alignment = columnModel.align,
  332. Width = columnModel.name.Length
  333. });
  334. }
  335. return File(ExcelHelper.NewExportMemoryStream(rowData, excelconfig), "application/ms-excel", excelconfig.FileName);
  336. }
  337. [HttpPost]
  338. public IActionResult ExportCellListReportExcel(string fileName, string queryJson, string exportField)
  339. {
  340. var query = new ReportQueryDto();
  341. try
  342. {
  343. if (!string.IsNullOrEmpty(queryJson))
  344. {
  345. query = JsonConvert.DeserializeObject<ReportQueryDto>(queryJson);
  346. }
  347. }
  348. catch (Exception ex)
  349. {
  350. }
  351. //设置导出格式
  352. ExcelConfig excelconfig = new ExcelConfig();
  353. excelconfig.Title = HttpUtility.UrlDecode(fileName);
  354. excelconfig.TitleFont = "微软雅黑";
  355. excelconfig.TitlePoint = 15;
  356. excelconfig.FileName = HttpUtility.UrlDecode(fileName) + ".xls";
  357. excelconfig.IsAllSizeColumn = true;
  358. excelconfig.ColumnEntity = new List<ColumnModel>();
  359. List<jfGridModel> columnList = exportField.ToList<jfGridModel>();
  360. if (columnList.Count == 0)
  361. {
  362. throw new Exception("未找到表头");
  363. }
  364. //行数据
  365. var lists = _report.GetList(query ?? new ReportQueryDto());
  366. var dataJson = JsonConvert.SerializeObject(lists);
  367. DataTable rowData = dataJson.ToTable();
  368. //写入Excel表头
  369. Dictionary<string, string> exportFieldMap = new Dictionary<string, string>();
  370. if (!string.IsNullOrEmpty(exportField))
  371. {
  372. string[] exportFields = exportField.Split(',');
  373. foreach (var field in exportFields)
  374. {
  375. if (!exportFieldMap.ContainsKey(field))
  376. {
  377. exportFieldMap.Add(field, "1");
  378. }
  379. }
  380. }
  381. foreach (var columnModel in columnList)
  382. {
  383. excelconfig.ColumnEntity.Add(new ColumnModel()
  384. {
  385. // Column =string.IsNullOrEmpty(columnModel.sortname)? columnModel.name: columnModel.sortname,
  386. Column = columnModel.name,
  387. ExcelColumn = columnModel.label,
  388. Alignment = columnModel.align,
  389. Width = columnModel.name.Length
  390. });
  391. }
  392. return File(ExcelHelper.NewExportMemoryStream(rowData, excelconfig), "application/ms-excel", excelconfig.FileName);
  393. }
  394. [HttpPost]
  395. public IActionResult ExportMatNameNetWeightCategoryExcel(string fileName, string queryJson, string exportField)
  396. {
  397. var query = new BillInvNowQueryDto();
  398. try
  399. {
  400. if (!string.IsNullOrEmpty(queryJson))
  401. {
  402. query = JsonConvert.DeserializeObject<BillInvNowQueryDto>(queryJson);
  403. }
  404. }
  405. catch (Exception ex)
  406. {
  407. }
  408. //设置导出格式
  409. ExcelConfig excelconfig = new ExcelConfig();
  410. excelconfig.Title = HttpUtility.UrlDecode(fileName);
  411. excelconfig.TitleFont = "微软雅黑";
  412. excelconfig.TitlePoint = 15;
  413. excelconfig.FileName = HttpUtility.UrlDecode(fileName) + ".xls";
  414. excelconfig.IsAllSizeColumn = true;
  415. excelconfig.ColumnEntity = new List<ColumnModel>();
  416. List<jfGridModel> columnList = exportField.ToList<jfGridModel>();
  417. if (columnList.Count == 0)
  418. {
  419. throw new Exception("未找到表头");
  420. }
  421. //行数据
  422. var lists = _report.GetMatNameNetWeightCategorys(query ?? new BillInvNowQueryDto());
  423. var dataJson = JsonConvert.SerializeObject(lists);
  424. DataTable rowData = dataJson.ToTable();
  425. //写入Excel表头
  426. Dictionary<string, string> exportFieldMap = new Dictionary<string, string>();
  427. if (!string.IsNullOrEmpty(exportField))
  428. {
  429. string[] exportFields = exportField.Split(',');
  430. foreach (var field in exportFields)
  431. {
  432. if (!exportFieldMap.ContainsKey(field))
  433. {
  434. exportFieldMap.Add(field, "1");
  435. }
  436. }
  437. }
  438. foreach (var columnModel in columnList)
  439. {
  440. excelconfig.ColumnEntity.Add(new ColumnModel()
  441. {
  442. // Column =string.IsNullOrEmpty(columnModel.sortname)? columnModel.name: columnModel.sortname,
  443. Column = columnModel.name,
  444. ExcelColumn = columnModel.label,
  445. Alignment = columnModel.align,
  446. Width = columnModel.name.Length
  447. });
  448. }
  449. return File(ExcelHelper.NewExportMemoryStream(rowData, excelconfig), "application/ms-excel", excelconfig.FileName);
  450. }
  451. public ActionResult GetTimeOutRecordReportPageList(string pagination, string queryJson)
  452. {
  453. Pagination paginationobj = InitPagination(pagination);
  454. var query = new BillTimeOutRecordQueryDto();
  455. if (!string.IsNullOrEmpty(queryJson))
  456. {
  457. query = JsonConvert.DeserializeObject<BillTimeOutRecordQueryDto>(queryJson);
  458. }
  459. var lists = _billTimeOutRecordService.GetReportPageList(paginationobj, query ?? new BillTimeOutRecordQueryDto());
  460. var jsonData = new
  461. {
  462. rows = lists.Result,
  463. total = lists.TotalPage,
  464. page = lists.PageIndex,
  465. records = lists.TotalNum
  466. };
  467. return Success(jsonData);
  468. }
  469. public ActionResult GetTimeOutRecordPageList(string pagination, string queryJson)
  470. {
  471. Pagination paginationobj = InitPagination(pagination);
  472. var query = new BillTimeOutRecordQueryDto();
  473. if (!string.IsNullOrEmpty(queryJson))
  474. {
  475. query = JsonConvert.DeserializeObject<BillTimeOutRecordQueryDto>(queryJson);
  476. }
  477. var lists = _billTimeOutRecordService.GetPageList(paginationobj, query ?? new BillTimeOutRecordQueryDto());
  478. var jsonData = new
  479. {
  480. rows = lists.Result,
  481. total = lists.TotalPage,
  482. page = lists.PageIndex,
  483. records = lists.TotalNum
  484. };
  485. return Success(jsonData);
  486. }
  487. }
  488. }