SeOrderService.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553
  1. using Yitter.IdGenerator;
  2. namespace Admin.NET.Plugin.AiDOP.Order;
  3. /// <summary>
  4. /// 销售订单评审服务 🗂️
  5. /// 路由前缀:/api/Order/seorder/...
  6. /// </summary>
  7. [ApiDescriptionSettings(Order = 300, Description = "销售订单评审")]
  8. [Route("api/Order")]
  9. [AllowAnonymous]
  10. [NonUnify]
  11. public class SeOrderService : IDynamicApiController, ITransient
  12. {
  13. private readonly ISqlSugarClient _db;
  14. private readonly SqlSugarRepository<SeOrder> _seOrderRep;
  15. private readonly SqlSugarRepository<SeOrderEntry> _seOrderEntryRep;
  16. private readonly SqlSugarRepository<SeOrderChange> _seOrderChangeRep;
  17. private readonly UserManager _userManager;
  18. private readonly SeOrderOperationLogService _orderOpLog;
  19. private readonly OrderReviewOrchestrationService _reviewOrchestration;
  20. public SeOrderService(
  21. ISqlSugarClient db,
  22. SqlSugarRepository<SeOrder> seOrderRep,
  23. SqlSugarRepository<SeOrderEntry> seOrderEntryRep,
  24. SqlSugarRepository<SeOrderChange> seOrderChangeRep,
  25. UserManager userManager,
  26. SeOrderOperationLogService orderOpLog,
  27. OrderReviewOrchestrationService reviewOrchestration)
  28. {
  29. _db = db;
  30. _seOrderRep = seOrderRep;
  31. _seOrderEntryRep = seOrderEntryRep;
  32. _seOrderChangeRep = seOrderChangeRep;
  33. _userManager = userManager;
  34. _orderOpLog = orderOpLog;
  35. _reviewOrchestration = reviewOrchestration;
  36. }
  37. // ══════════════════════════════════════════════════════════════
  38. // 订单列表 GET /api/Order/seorder/list
  39. // ══════════════════════════════════════════════════════════════
  40. /// <summary>获取订单评审分页列表 🗂️</summary>
  41. [DisplayName("获取订单评审列表")]
  42. [HttpGet("seorder/list")]
  43. public async Task<object> GetSeOrderList([FromQuery] SeOrderListInput input)
  44. {
  45. var tenantId = AidopTenantHelper.Resolve(App.HttpContext);
  46. var pars = new List<SugarParameter> { new("@TenantId", tenantId) };
  47. var innerConditions = new List<string> { "o.IsDeleted = 0", "o.tenant_id = @TenantId" };
  48. if (!string.IsNullOrWhiteSpace(input.BillNo))
  49. {
  50. innerConditions.Add("o.bill_no LIKE @BillNo");
  51. pars.Add(new SugarParameter("@BillNo", $"%{input.BillNo.Trim()}%"));
  52. }
  53. if (!string.IsNullOrWhiteSpace(input.CustomNo))
  54. {
  55. innerConditions.Add("o.custom_no LIKE @CustomNo");
  56. pars.Add(new SugarParameter("@CustomNo", $"%{input.CustomNo.Trim()}%"));
  57. }
  58. if (input.OrderType.HasValue)
  59. {
  60. innerConditions.Add("o.order_type = @OrderType");
  61. pars.Add(new SugarParameter("@OrderType", input.OrderType.Value));
  62. }
  63. var baseSql = BuildListBaseSql(string.Join(" AND ", innerConditions));
  64. // state 是 CASE 计算列,需包一层再过滤
  65. var outerWhere = "";
  66. if (!string.IsNullOrWhiteSpace(input.State))
  67. {
  68. outerWhere = "WHERE t.State = @State";
  69. pars.Add(new SugarParameter("@State", input.State.Trim()));
  70. }
  71. var offset = (input.Page - 1) * input.PageSize;
  72. var total = await _db.Ado.GetIntAsync(
  73. $"SELECT COUNT(*) FROM ({baseSql}) AS t {outerWhere}", pars);
  74. var list = await _db.Ado.SqlQueryAsync<SeOrderListRow>(
  75. $"SELECT * FROM ({baseSql}) AS t {outerWhere} ORDER BY t.Id DESC LIMIT {input.PageSize} OFFSET {offset}", pars);
  76. return new { total, page = input.Page, pageSize = input.PageSize, list };
  77. }
  78. private static string BuildListBaseSql(string innerWhere) => $"""
  79. SELECT
  80. o.Id AS Id,
  81. o.bill_no AS BillNo,
  82. o.order_type AS OrderType,
  83. o.custom_no AS CustomNo,
  84. o.custom_name AS SortName,
  85. o.rdate AS RDate,
  86. o.flowstate AS FlowState,
  87. COALESCE(NULLIF(e.min_progress, ''), '1') AS Progress,
  88. CASE
  89. WHEN COALESCE(NULLIF(e.min_progress, ''), '1') = '1' THEN '新建'
  90. WHEN COALESCE(NULLIF(e.min_progress, ''), '1') = '2' THEN '评审'
  91. WHEN COALESCE(NULLIF(e.min_progress, ''), '1') = '0' THEN '再评审'
  92. WHEN COALESCE(NULLIF(e.min_progress, ''), '1') = '3' THEN '确认'
  93. ELSE '确认'
  94. END AS State,
  95. chg.change_content AS ChangeContent,
  96. cN.changeNum AS ChangeNum
  97. FROM crm_seorder o
  98. LEFT JOIN (
  99. SELECT seorder_id, MIN(COALESCE(NULLIF(progress, ''), '1')) AS min_progress
  100. FROM crm_seorderentry
  101. WHERE IsDeleted = 0
  102. GROUP BY seorder_id
  103. ) e ON e.seorder_id = o.Id
  104. LEFT JOIN (
  105. SELECT order_no, change_content
  106. FROM (
  107. SELECT JSON_UNQUOTE(JSON_EXTRACT(raw_data,'$.bill_no')) AS order_no,
  108. JSON_UNQUOTE(JSON_EXTRACT(raw_data,'$.change_content')) AS change_content,
  109. sync_time,
  110. ROW_NUMBER() OVER (PARTITION BY JSON_UNQUOTE(JSON_EXTRACT(raw_data,'$.bill_no')) ORDER BY sync_time DESC, id DESC) AS RowNum
  111. FROM mdp_stg_so
  112. WHERE source_table='crm_seorder_change'
  113. AND JSON_UNQUOTE(JSON_EXTRACT(raw_data,'$.bill_no')) IS NOT NULL
  114. ) ranked
  115. WHERE RowNum = 1
  116. ) chg ON chg.order_no = o.bill_no
  117. LEFT JOIN (
  118. SELECT JSON_UNQUOTE(JSON_EXTRACT(raw_data,'$.bill_no')) AS order_no, COUNT(*) AS changeNum
  119. FROM mdp_stg_so
  120. WHERE source_table='crm_seorder_change'
  121. AND JSON_UNQUOTE(JSON_EXTRACT(raw_data,'$.bill_no')) IS NOT NULL
  122. GROUP BY JSON_UNQUOTE(JSON_EXTRACT(raw_data,'$.bill_no'))
  123. ) cN ON cN.order_no = o.bill_no
  124. WHERE {innerWhere}
  125. """;
  126. // ══════════════════════════════════════════════════════════════
  127. // 客户列表 GET /api/Order/seorder/customers
  128. // 注:字面量路由优先于 {id} 参数路由,无需额外排序
  129. // ══════════════════════════════════════════════════════════════
  130. /// <summary>获取客户选择列表 🗂️</summary>
  131. [DisplayName("获取客户列表")]
  132. [HttpGet("seorder/customers")]
  133. public async Task<object> GetCustomers([FromQuery] KeywordPageInput input)
  134. {
  135. var pars = new List<SugarParameter>();
  136. var where = "1=1";
  137. if (!string.IsNullOrWhiteSpace(input.Keyword))
  138. {
  139. where = "(Cust LIKE @Keyword OR SortName LIKE @Keyword)";
  140. pars.Add(new SugarParameter("@Keyword", $"%{input.Keyword.Trim()}%"));
  141. }
  142. var offset = (input.Page - 1) * input.PageSize;
  143. var total = await _db.Ado.GetIntAsync(
  144. $"SELECT COUNT(*) FROM CustMaster WHERE {where}", pars);
  145. var list = await _db.Ado.SqlQueryAsync<SimpleKvRow>(
  146. $"SELECT Cust AS Value, SortName AS Label, NULL AS Extra, NULL AS Id FROM CustMaster WHERE {where} ORDER BY Cust LIMIT {input.PageSize} OFFSET {offset}",
  147. pars);
  148. return new { total, page = input.Page, pageSize = input.PageSize, list };
  149. }
  150. // ══════════════════════════════════════════════════════════════
  151. // 物料列表 GET /api/Order/seorder/items
  152. // TODO: 将 bd_material 替换为实际物料主数据表名
  153. // ══════════════════════════════════════════════════════════════
  154. /// <summary>获取物料选择列表 🗂️</summary>
  155. [DisplayName("获取物料列表")]
  156. [HttpGet("seorder/items")]
  157. public async Task<object> GetItems([FromQuery] KeywordPageInput input)
  158. {
  159. var pars = new List<SugarParameter>();
  160. var where = "IsDeleted = 0";
  161. if (!string.IsNullOrWhiteSpace(input.Keyword))
  162. {
  163. where += " AND (item_number LIKE @Keyword OR item_name LIKE @Keyword)";
  164. pars.Add(new SugarParameter("@Keyword", $"%{input.Keyword.Trim()}%"));
  165. }
  166. var offset = (input.Page - 1) * input.PageSize;
  167. var total = await _db.Ado.GetIntAsync(
  168. $"SELECT COUNT(*) FROM bd_material WHERE {where}", pars);
  169. var list = await _db.Ado.SqlQueryAsync<SimpleKvRow>(
  170. $"SELECT item_number AS Value, item_name AS Label, CONCAT(IFNULL(specification,''),'|',IFNULL(unit,'')) AS Extra, NULL AS Id FROM bd_material WHERE {where} ORDER BY item_number LIMIT {input.PageSize} OFFSET {offset}",
  171. pars);
  172. return new { total, page = input.Page, pageSize = input.PageSize, list };
  173. }
  174. // ══════════════════════════════════════════════════════════════
  175. // 订单详情 GET /api/Order/seorder/{id}
  176. // ══════════════════════════════════════════════════════════════
  177. /// <summary>获取订单详情(含明细)🗂️</summary>
  178. [DisplayName("获取订单详情")]
  179. [HttpGet("seorder/{id}")]
  180. public async Task<object> GetSeOrderDetail(long id)
  181. {
  182. const string orderSql = """
  183. SELECT Id, bill_no AS BillNo, order_type AS OrderType,
  184. custom_id AS CustomId, custom_no AS CustomNo, custom_name AS CustomName,
  185. date AS Date, custom_level AS CustomLevel, urgent AS Urgent,
  186. bill_from AS BillFrom, country AS Country, rdate AS RDate, flowstate AS FlowState
  187. FROM crm_seorder
  188. WHERE Id = @Id AND IsDeleted = 0
  189. LIMIT 1
  190. """;
  191. var order = (await _db.Ado.SqlQueryAsync<SeOrderDetailRow>(orderSql, new { Id = id }))
  192. .FirstOrDefault()
  193. ?? throw Oops.Oh("订单不存在");
  194. const string entrySql = """
  195. SELECT Id, entry_seq AS EntrySeq, company_id AS CompanyId, item_number AS ItemNumber, item_name AS ItemName,
  196. specification AS Specification, qty AS Qty, plan_date AS PlanDate,
  197. sys_capacity_date AS SysCapacityDate, date AS Date, remark AS Remark,
  198. unit AS Unit, deliver_count AS DeliverCount, progress AS Progress
  199. FROM crm_seorderentry
  200. WHERE seorder_id = @Id AND IsDeleted = 0
  201. ORDER BY entry_seq
  202. """;
  203. var entries = await _db.Ado.SqlQueryAsync<SeOrderEntryRow>(entrySql, new { Id = id });
  204. return new
  205. {
  206. order.Id, order.BillNo, order.OrderType,
  207. order.CustomId, order.CustomNo, order.CustomName,
  208. order.Date, order.CustomLevel, order.Urgent,
  209. order.BillFrom, order.Country, order.RDate, order.FlowState,
  210. entries
  211. };
  212. }
  213. // ══════════════════════════════════════════════════════════════
  214. // 新增 / 编辑 POST /api/Order/seorder/save
  215. // ══════════════════════════════════════════════════════════════
  216. /// <summary>保存销售订单(新增或编辑)🗂️</summary>
  217. [DisplayName("保存销售订单")]
  218. [ApiDescriptionSettings(Name = "SaveSeOrder"), HttpPost("seorder/save")]
  219. public async Task<object> SaveSeOrder([FromBody] SeOrderSaveInput input)
  220. {
  221. // 子表订单明细至少一条
  222. if (input.Entries == null || input.Entries.Count == 0)
  223. throw Oops.Oh("订单明细至少需要一条数据");
  224. if (input.Id is null or 0)
  225. {
  226. // ── 新增:参照 SysJobService.AddJobDetail ──
  227. var tenantId = _userManager.TenantId;
  228. // 如果未填写订单编号,自动生成:SO + yyyyMMdd + 4位流水号
  229. if (string.IsNullOrWhiteSpace(input.BillNo))
  230. {
  231. input.BillNo = await GenerateBillNoAsync(tenantId);
  232. }
  233. var isExist = await _seOrderRep.IsAnyAsync(u => u.BillNo == input.BillNo && u.IsDeleted == 0 && u.TenantId == tenantId);
  234. if (isExist) throw Oops.Oh("订单编号已存在");
  235. var entity = input.Adapt<SeOrder>();
  236. entity.Id = YitIdHelper.NextId();
  237. entity.IsDeleted = 0;
  238. entity.Closed = 0;
  239. entity.CreateTime = DateTime.Now;
  240. entity.TenantId = tenantId;
  241. await _seOrderRep.InsertAsync(entity);
  242. await SaveEntriesAsync(entity.Id, input.BillNo, input.Entries);
  243. var orderAfter = await _seOrderRep.GetFirstAsync(u => u.Id == entity.Id && u.IsDeleted == 0 && u.TenantId == tenantId);
  244. var entriesAfter = await _seOrderEntryRep.GetListAsync(u => u.SeOrderId == entity.Id && u.IsDeleted == 0 && u.TenantId == tenantId);
  245. var afterJson = SeOrderAuditHelper.BuildCombinedSnapshotJson(orderAfter!, entriesAfter);
  246. await _orderOpLog.WriteAsync(new SeOrderOperationLogDto
  247. {
  248. UserId = _userManager.UserId,
  249. Action = "新增订单",
  250. TableName = "crm_seorder",
  251. KeyValue = entity.Id.ToString(),
  252. Content = $"新增订单,订单编号:{entity.BillNo},订单主键:{entity.Id}。",
  253. BeforeJson = null,
  254. AfterJson = afterJson
  255. });
  256. return new { id = entity.Id, message = "新增成功" };
  257. }
  258. else
  259. {
  260. // ── 编辑:参照 SysJobService.UpdateJobDetail ──
  261. var tenantId = _userManager.TenantId;
  262. var entity = await _seOrderRep.GetFirstAsync(u => u.Id == input.Id.Value && u.IsDeleted == 0)
  263. ?? throw Oops.Oh("订单不存在");
  264. var beforeEntries = await _seOrderEntryRep.GetListAsync(u => u.SeOrderId == input.Id.Value && u.IsDeleted == 0);
  265. var orderBefore = entity.Adapt<SeOrder>();
  266. var entriesBefore = beforeEntries.Select(e => e.Adapt<SeOrderEntry>()).ToList();
  267. input.Adapt(entity);
  268. entity.UpdateTime = DateTime.Now;
  269. await _seOrderRep.UpdateAsync(entity);
  270. await SaveEntriesAsync(input.Id.Value, input.BillNo, input.Entries);
  271. var afterOrder = await _seOrderRep.GetFirstAsync(u => u.Id == input.Id.Value && u.IsDeleted == 0 && u.TenantId == tenantId);
  272. var afterEntries = await _seOrderEntryRep.GetListAsync(u => u.SeOrderId == input.Id.Value && u.IsDeleted == 0 && u.TenantId == tenantId);
  273. var (content, beforeJson, afterJson) = SeOrderAuditHelper.BuildUpdateDiff(
  274. orderBefore!, entriesBefore, afterOrder!, afterEntries);
  275. await _orderOpLog.WriteAsync(new SeOrderOperationLogDto
  276. {
  277. UserId = _userManager.UserId,
  278. Action = "修改订单",
  279. TableName = "crm_seorder",
  280. KeyValue = input.Id.Value.ToString(),
  281. Content = content,
  282. BeforeJson = beforeJson,
  283. AfterJson = afterJson
  284. });
  285. return new { id = input.Id, message = "编辑成功" };
  286. }
  287. }
  288. /// <summary>
  289. /// 明细三路合并:
  290. /// ① DB有且入参有(按 Id 匹配)→ 更新
  291. /// ② DB无但入参有 → 新增(补填 bill_no / progress=0 / create_by)
  292. /// ③ DB有但入参无 → 删除
  293. /// </summary>
  294. private async Task SaveEntriesAsync(long orderId, string billNo, List<SeOrderEntryInput> entries)
  295. {
  296. var tenantId = _userManager.TenantId;
  297. // 取 DB 现有明细,以 Id 为 key 建索引
  298. var dbEntries = await _seOrderEntryRep.GetListAsync(u => u.SeOrderId == orderId && u.IsDeleted == 0 && u.TenantId == tenantId);
  299. var dbById = dbEntries.ToDictionary(u => u.Id);
  300. // 入参中携带 Id 的集合(用于判断 DB 行是否需要删除)
  301. var inputIds = new HashSet<long>(entries.Where(e => e.Id > 0).Select(e => e.Id!.Value));
  302. for (var i = 0; i < entries.Count; i++)
  303. {
  304. var e = entries[i];
  305. var seq = e.EntrySeq ?? (i + 1);
  306. if (e.Id > 0 && dbById.TryGetValue(e.Id.Value, out var existing))
  307. {
  308. // ① DB有、参数有 → 更新(参照 SysJobService.UpdateJobDetail)
  309. var originalCompanyId = existing.CompanyId;
  310. e.Adapt(existing);
  311. existing.CompanyId = e.CompanyId ?? originalCompanyId;
  312. existing.EntrySeq = seq;
  313. existing.UpdateTime = DateTime.Now;
  314. await _seOrderEntryRep.UpdateAsync(existing);
  315. }
  316. else
  317. {
  318. // ② DB无、参数有 → 新增(参照 SysJobService.AddJobDetail)
  319. var entry = e.Adapt<SeOrderEntry>();
  320. entry.Id = YitIdHelper.NextId();
  321. entry.SeOrderId = orderId;
  322. entry.BillNo = billNo;
  323. entry.EntrySeq = seq;
  324. entry.CompanyId ??= 1000;
  325. entry.Progress ??= "0";
  326. entry.CreateBy = _userManager.UserId;
  327. entry.IsDeleted = 0;
  328. entry.CreateTime = DateTime.Now;
  329. entry.TenantId = tenantId;
  330. await _seOrderEntryRep.InsertAsync(entry);
  331. }
  332. }
  333. // ③ DB有、参数无 → 删除(参照 SysJobService.DeleteJobDetail)
  334. foreach (var toDelete in dbEntries.Where(u => !inputIds.Contains(u.Id)))
  335. {
  336. await _seOrderEntryRep.DeleteAsync(u => u.Id == toDelete.Id);
  337. }
  338. }
  339. /// <summary>
  340. /// 生成订单编号:SO + yyyyMMdd + 4位流水号,例如 SO202605210001
  341. /// </summary>
  342. private async Task<string> GenerateBillNoAsync(long tenantId)
  343. {
  344. var today = DateTime.Now.ToString("yyyyMMdd");
  345. var prefix = $"SO{today}";
  346. // 查询当天已有的最大订单编号
  347. var maxBillNo = await _db.Queryable<SeOrder>()
  348. .Where(u => u.BillNo!.StartsWith(prefix) && u.IsDeleted == 0 && u.TenantId == tenantId)
  349. .OrderBy(u => u.BillNo, OrderByType.Desc)
  350. .Select(u => u.BillNo)
  351. .FirstAsync();
  352. if (string.IsNullOrEmpty(maxBillNo))
  353. {
  354. return $"{prefix}0001";
  355. }
  356. // 取后4位转为数字并加1,不足4位补零
  357. var last4 = maxBillNo.Length >= 4 ? maxBillNo[^4..] : maxBillNo;
  358. if (int.TryParse(last4, out var serial))
  359. {
  360. return $"{prefix}{(serial + 1).ToString().PadLeft(4, '0')}";
  361. }
  362. return $"{prefix}0001";
  363. }
  364. // ══════════════════════════════════════════════════════════════
  365. // 订单评审 POST /api/Order/seorder/review
  366. // ══════════════════════════════════════════════════════════════
  367. /// <summary>订单评审(资源检查 + 工单生成)🗂️</summary>
  368. [DisplayName("订单评审")]
  369. [ApiDescriptionSettings(Name = "ReviewSeOrders"), HttpPost("seorder/review")]
  370. public async Task<SeOrderReviewExecuteResult> ReviewSeOrders([FromBody] SeOrderReviewExecuteInput input) =>
  371. await _reviewOrchestration.ReviewAsync(input.Ids);
  372. // ══════════════════════════════════════════════════════════════
  373. // 交期确认 POST /api/Order/seorder/confirm-delivery
  374. // ══════════════════════════════════════════════════════════════
  375. /// <summary>交期确认 🗂️</summary>
  376. [DisplayName("交期确认")]
  377. [ApiDescriptionSettings(Name = "ConfirmSeOrderDelivery"), HttpPost("seorder/confirm-delivery")]
  378. public async Task<SeOrderReviewExecuteResult> ConfirmSeOrderDelivery([FromBody] SeOrderReviewExecuteInput input) =>
  379. await _reviewOrchestration.ConfirmDeliveryAsync(input.Ids);
  380. // ══════════════════════════════════════════════════════════════
  381. // 变更重排 POST /api/Order/seorder/{id}/refresh-plan
  382. // ══════════════════════════════════════════════════════════════
  383. /// <summary>订单变更后 3 级计划重排 🗂️</summary>
  384. [DisplayName("订单变更重排")]
  385. [ApiDescriptionSettings(Name = "RefreshSeOrderPlan"), HttpPost("seorder/{id}/refresh-plan")]
  386. public async Task<SeOrderReviewExecuteResult> RefreshSeOrderPlan(long id, [FromBody] SeOrderRefreshPlanInput? input) =>
  387. await _reviewOrchestration.RefreshPlanAsync(id, input?.Reason);
  388. // ══════════════════════════════════════════════════════════════
  389. // 资源解锁 POST /api/Order/seorder/{id}/unlock
  390. // ══════════════════════════════════════════════════════════════
  391. /// <summary>资源解锁 🔓</summary>
  392. [DisplayName("资源解锁")]
  393. [ApiDescriptionSettings(Name = "UnlockSeOrder"), HttpPost("seorder/{id}/unlock")]
  394. public async Task<object> UnlockSeOrder(long id)
  395. {
  396. return new { message = "解锁成功" };
  397. }
  398. // ══════════════════════════════════════════════════════════════
  399. // 变更申请 POST /api/Order/seorder/{id}/change
  400. // ══════════════════════════════════════════════════════════════
  401. /// <summary>提交订单变更申请 🔖</summary>
  402. [DisplayName("提交订单变更申请")]
  403. [ApiDescriptionSettings(Name = "CreateSeOrderChange"), HttpPost("seorder/{id}/change")]
  404. public async Task<object> CreateChange(long id, [FromBody] SeOrderChangeSaveInput input)
  405. {
  406. var tenantId = _userManager.TenantId;
  407. // 参照 SysJobService.AddJobDetail:Adapt → 设主键与审计字段 → InsertAsync
  408. var entity = input.Adapt<SeOrderChange>();
  409. entity.Id = YitIdHelper.NextId();
  410. entity.SeOrderId = id;
  411. entity.IsDeleted = 0;
  412. entity.CreateTime = DateTime.Now;
  413. entity.TenantId = tenantId;
  414. await _seOrderChangeRep.InsertAsync(entity);
  415. return new { id = entity.Id, message = "变更申请已保存" };
  416. }
  417. // ──────────────── 内部查询结果映射类 ────────────────
  418. private sealed class SeOrderListRow
  419. {
  420. public long Id { get; set; }
  421. public string? BillNo { get; set; }
  422. public int? OrderType { get; set; }
  423. public string? CustomNo { get; set; }
  424. public string? SortName { get; set; }
  425. public DateTime? RDate { get; set; }
  426. public string? Progress { get; set; }
  427. public string? State { get; set; }
  428. public string? ChangeContent { get; set; }
  429. public int? ChangeNum { get; set; }
  430. public string? FlowState { get; set; }
  431. }
  432. private sealed class SeOrderDetailRow
  433. {
  434. public long Id { get; set; }
  435. public string? BillNo { get; set; }
  436. public int? OrderType { get; set; }
  437. public long? CustomId { get; set; }
  438. public string? CustomNo { get; set; }
  439. public string? CustomName { get; set; }
  440. public DateTime? Date { get; set; }
  441. public int? CustomLevel { get; set; }
  442. public int? Urgent { get; set; }
  443. public string? BillFrom { get; set; }
  444. public string? Country { get; set; }
  445. public DateTime? RDate { get; set; }
  446. public string? FlowState { get; set; }
  447. }
  448. private sealed class SeOrderEntryRow
  449. {
  450. public long Id { get; set; }
  451. public int? EntrySeq { get; set; }
  452. public long? CompanyId { get; set; }
  453. public string? ItemNumber { get; set; }
  454. public string? ItemName { get; set; }
  455. public string? Specification { get; set; }
  456. public decimal? Qty { get; set; }
  457. public DateTime? PlanDate { get; set; }
  458. public DateTime? SysCapacityDate { get; set; }
  459. public DateTime? Date { get; set; }
  460. public string? Remark { get; set; }
  461. public string? Unit { get; set; }
  462. public decimal? DeliverCount { get; set; }
  463. public string? Progress { get; set; }
  464. }
  465. private sealed class SimpleKvRow
  466. {
  467. public string? Value { get; set; }
  468. public string? Label { get; set; }
  469. public string? Extra { get; set; }
  470. public long? Id { get; set; }
  471. }
  472. // ══════════════════════════════════════════════════════════════
  473. // 提交订单评审审批
  474. // ══════════════════════════════════════════════════════════════
  475. /// <summary>提交订单评审审批流程</summary>
  476. [DisplayName("提交订单评审审批")]
  477. [HttpPost("seorder/submitReview")]
  478. public async Task<object> SubmitOrderReview([FromBody] SubmitReviewInput input)
  479. {
  480. var order = await _seOrderRep.GetByIdAsync(input.OrderId)
  481. ?? throw Oops.Oh("订单不存在");
  482. var engine = App.GetRequiredService<Admin.NET.Plugin.ApprovalFlow.Service.FlowEngineService>();
  483. var instanceId = await engine.StartFlow(new Admin.NET.Plugin.ApprovalFlow.Service.StartFlowInput
  484. {
  485. BizType = "ORDER_REVIEW",
  486. BizId = order.Id,
  487. BizNo = order.BillNo,
  488. Title = $"订单评审-{order.BillNo}",
  489. Comment = input.Comment,
  490. });
  491. return new { instanceId };
  492. }
  493. public class SubmitReviewInput
  494. {
  495. public long OrderId { get; set; }
  496. public string? Comment { get; set; }
  497. }
  498. }