ConstItemController.cs 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132
  1. using Cksoft.Data;
  2. using Cksoft.Data.Repository;
  3. using DllEapDal;
  4. using DllEapEntity.Dtos;
  5. using Microsoft.AspNetCore.Authorization;
  6. using Microsoft.AspNetCore.Mvc;
  7. using System;
  8. using System.Collections.Generic;
  9. using System.Linq;
  10. using System.Text;
  11. namespace DllEapBll.Controllers
  12. {
  13. /// <summary>
  14. /// 字典
  15. /// </summary>
  16. [Route("eap/api/[controller]/[action]")]
  17. [Authorize]
  18. [ApiController]
  19. public class ConstItemController : ControllerBase
  20. {
  21. private readonly string eapslave = "eapslave";
  22. /// <summary>
  23. /// 获取对应字典的数据源
  24. /// </summary>
  25. /// <param name="dicId"></param>
  26. /// <returns></returns>
  27. [HttpGet]
  28. public IEnumerable<SelectDto<object>> GetConstItemsByDicId(int dicId)
  29. {
  30. using (IDatabase db = DbFactory.Base(eapslave))
  31. {
  32. var dal = new ConstItemDal(db);
  33. return dal.Get(dicId);
  34. }
  35. }
  36. /// <summary>
  37. /// 获取制程
  38. /// </summary>
  39. /// <param name="includeAll"></param>
  40. /// <returns></returns>
  41. [HttpGet]
  42. public IEnumerable<SelectDto<string>> GetProcess(int? includeAll = 1)
  43. {
  44. using (IDatabase db = DbFactory.Base(eapslave))
  45. {
  46. var dal = new ConstItemDal(db);
  47. var selects = dal.GetProcess().ToList();
  48. if (includeAll != null && includeAll == 1)
  49. {
  50. var defaultSec = new SelectDto<string>();
  51. defaultSec.Label = "全部";
  52. defaultSec.Value = null;
  53. selects.Insert(0, defaultSec);
  54. }
  55. return selects;
  56. }
  57. }
  58. /// <summary>
  59. /// 获取按机型分组的机台
  60. /// </summary>
  61. /// <param name="factoryId"></param>
  62. /// <returns></returns>
  63. [HttpGet]
  64. public IEnumerable<CascaderDto> GetGroupedMachines(int? factoryId)
  65. {
  66. using (IDatabase db = DbFactory.Base(eapslave))
  67. {
  68. var dal = new MachineDal(db);
  69. return dal.GetGroupedMachines(factoryId);
  70. }
  71. }
  72. /// <summary>
  73. /// 获取带厂家的机型
  74. /// </summary>
  75. /// <returns></returns>
  76. [HttpGet]
  77. public IEnumerable<object> GetMacModelsWithSupplier()
  78. {
  79. using (IDatabase db = DbFactory.Base(eapslave))
  80. {
  81. string errorinfo = string.Empty;
  82. var dal = new MacModelDal(db);
  83. var macmodels = dal.Get(1, 1000, "asc", "a.FCode", "", errorinfo).Select(c => new { Label = c.FCode, Value = c.ID, Parent = c.SupplierID });
  84. return macmodels;
  85. }
  86. }
  87. /// <summary>
  88. /// 获取机台
  89. /// </summary>
  90. /// <param name="filter"></param>
  91. /// <returns></returns>
  92. [HttpGet]
  93. public IEnumerable<SelectDto<int>> GetEapMachines(string filter)
  94. {
  95. using (IDatabase db = DbFactory.Base(eapslave))
  96. {
  97. var macDal = new MachineDal(db);
  98. return macDal.Get(filter).OrderBy(c => c.FCode).Select(c => new SelectDto<int>
  99. {
  100. Label = c.FCode,
  101. Value = c.ID
  102. });
  103. }
  104. }
  105. /// <summary>
  106. /// 获取标准状态
  107. /// </summary>
  108. /// <param name="filter"></param>
  109. /// <returns></returns>
  110. [HttpGet]
  111. public IEnumerable<SelectDto<int?>> GetStatndardStatuses(string filter)
  112. {
  113. using (IDatabase db = DbFactory.Base(eapslave))
  114. {
  115. var dal = new StandardStatusDal(db);
  116. var defaultSec = new SelectDto<int?>();
  117. defaultSec.Label = "全部";
  118. defaultSec.Value = null;
  119. var selects = dal.GetAll(filter).ToList();
  120. selects.Insert(0, defaultSec);
  121. return selects;
  122. }
  123. }
  124. }
  125. }