SeOrderService.cs 28 KB

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