足力健后端,使用.netcore版本,合并1个项目使用

OrderMergeController.cs 22KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540
  1. /* =============================================
  2. -- Author: <Author,,zhangkun>
  3. -- Create date: <Create Date,,20200709>
  4. -- Description: <Description,,订单合并相关操作)>
  5. -- ============================================*/
  6. using System;
  7. using System.Collections.Generic;
  8. using System.Common;
  9. using System.Common.Helpers;
  10. using System.Data;
  11. using System.IRepositories;
  12. using System.Linq;
  13. using System.Linq.Expressions;
  14. using System.Model;
  15. using System.Repositories;
  16. using System.Security.Claims;
  17. using System.Threading.Tasks;
  18. using System.Utility.Http;
  19. using Microsoft.AspNetCore.Mvc;
  20. using Microsoft.AspNetCore.Mvc.RazorPages.Infrastructure;
  21. using Microsoft.Extensions.Configuration;
  22. using SqlSugar;
  23. using TVShoppingCallCenter_ZLJ.Models.Inputs;
  24. namespace TVShoppingCallCenter_ZLJ.Controllers.Order
  25. {
  26. [Route("api/[controller]")]
  27. public class OrderMergeController : BaseController
  28. {
  29. private readonly IBus_OrderDetailRepository bus_OrderDetailRepository;
  30. private readonly IBus_OrderRepository bus_OrderRepository;
  31. private readonly OrderFunctionController busOrcerFunctionController;
  32. private readonly IBus_ProductRepository bus_productRepository;
  33. private readonly ICus_VipInfoRepository cus_vip_infoRepository;
  34. private readonly IBus_OrderMergeRepository busOrderMergeRepository;
  35. private readonly ICus_ScoreSetRepository cus_score_setRepository;
  36. public OrderMergeController(ICus_ScoreSetRepository _cus_score_setRepository, IBus_OrderMergeRepository _busOrderMergeRepository, IBus_OrderRepository _bus_OrderRepository, IBus_OrderDetailRepository _bus_OrderDetailRepository, OrderFunctionController _orderController, IBus_ProductRepository _productRepository, ICus_VipInfoRepository _cus_vip_infoRepository)
  37. {
  38. bus_OrderDetailRepository = _bus_OrderDetailRepository;
  39. bus_OrderRepository = _bus_OrderRepository;
  40. busOrcerFunctionController = _orderController;
  41. bus_productRepository = _productRepository;
  42. cus_vip_infoRepository = _cus_vip_infoRepository;
  43. busOrderMergeRepository = _busOrderMergeRepository;
  44. cus_score_setRepository = _cus_score_setRepository;
  45. }
  46. #region 销售操作
  47. /// <summary>
  48. /// 创建合并订单申请
  49. /// </summary>
  50. /// <param name="input"></param>
  51. /// <returns></returns>
  52. [HttpPost("addordermerge")]
  53. public async Task<IActionResult> AddOrderMerge(OrderMergeInput input)
  54. {
  55. try
  56. {
  57. #region 验证参数 必填项
  58. if (string.IsNullOrEmpty(input.F_OrderList))
  59. return Error("请输入要合并的订单");
  60. string[] orderlist = input.F_OrderList.Split(',');
  61. if (orderlist.Length < 2)
  62. return Error("合并订单至少有两个");
  63. //活动满减 免运费 活动满赠 活动优惠
  64. if (string.IsNullOrEmpty(input.F_Type))
  65. return Error("请选择合并类型");
  66. if (input.F_Type == "活动满赠")
  67. {
  68. if (string.IsNullOrEmpty(input.F_Gift))
  69. return Error("请选择赠品");
  70. }
  71. else
  72. {
  73. if (string.IsNullOrEmpty(input.F_Gift))
  74. input.F_Gift = "";
  75. if (input.F_Money <= 0)
  76. return Error("请输入有效金额");
  77. }
  78. //F_Remark、F_CheckRemak
  79. #endregion
  80. #region 验证逻辑
  81. foreach (string orderid in orderlist)
  82. {
  83. //合并状态 -1无效 0暂存 1提交 2不予通过 3通过
  84. int exist = await busOrderMergeRepository.GetCount(q => q.F_OrderList.Contains(orderid) && new int[] { 0, 1, 3 }.Contains(q.F_State));
  85. if (exist > 0)
  86. {
  87. return Error("此单号已参与合并中:" + orderid);
  88. }
  89. //订单状态 -1无效 0暂存 1提交 2KF退回 3通过 4无货 5已分拣 6已发货
  90. exist = await bus_OrderRepository.GetCount(q => q.F_Id == orderid && new int[] { 1, 3, 4 }.Contains(q.F_State));
  91. if (exist == 0)
  92. {
  93. return Error("提交订单后发货前才可合并,此单号状态无效:" + orderid);
  94. }
  95. }
  96. #endregion
  97. T_Bus_OrderMerge modelOrderMerge = new T_Bus_OrderMerge();
  98. modelOrderMerge.F_AddUser = UserLogin.UserId.ObjToInt();
  99. modelOrderMerge.F_AddUserName = UserLogin.UserName;
  100. modelOrderMerge.F_State = input.F_State;
  101. modelOrderMerge.F_Money = input.F_Money;
  102. modelOrderMerge.F_Gift = input.F_Gift;
  103. modelOrderMerge.F_Type = input.F_Type;
  104. modelOrderMerge.F_OrderList = input.F_OrderList;
  105. if(!string.IsNullOrEmpty(input.F_Remark))
  106. modelOrderMerge.F_Remark = input.F_Remark;
  107. modelOrderMerge.F_Id = Guid.NewGuid().ToString().Replace("-", "");
  108. if (await busOrderMergeRepository.AddReturnCount(modelOrderMerge))
  109. {
  110. if (input.F_State == 0)
  111. return Success("订单合并已保存");
  112. else if (input.F_State == 1)
  113. { return Success("订单合并已提交审核"); }
  114. }
  115. return Error("订单合并失败,请重试!");
  116. }
  117. catch (Exception ex)
  118. { return Error(ex.Message); }
  119. }
  120. /// <summary>
  121. /// 修改合并订单
  122. /// </summary>
  123. /// <param name="input"></param>
  124. /// <returns></returns>
  125. [HttpPost("editordermerge")]
  126. public async Task<IActionResult> EditOrderMerge(OrderMergeInput input)
  127. {
  128. try
  129. {
  130. #region 验证参数 必填项
  131. if (string.IsNullOrEmpty(input.F_Id))
  132. return Error("缺失参数ID");
  133. if (string.IsNullOrEmpty(input.F_OrderList))
  134. return Error("请输入要合并的订单");
  135. string[] orderlist = input.F_OrderList.Split(',');
  136. if (orderlist.Length < 2)
  137. return Error("合并订单至少有两个");
  138. //活动满减 免运费 活动满赠 活动优惠
  139. if (string.IsNullOrEmpty(input.F_Type))
  140. return Error("请选择合并类型");
  141. if (input.F_Type == "活动满赠")
  142. {
  143. if (string.IsNullOrEmpty(input.F_Gift))
  144. return Error("请选择赠品");
  145. }
  146. else
  147. {
  148. if (input.F_Money <= 0)
  149. return Error("请数据金额");
  150. }
  151. //F_Remark、F_CheckRemak
  152. #endregion
  153. #region 验证逻辑
  154. foreach (string orderid in orderlist)
  155. {
  156. //订单状态 -1无效 0暂存 1提交 2KF退回 3通过 4无货 5已分拣 6已发货
  157. int exist = await bus_OrderRepository.GetCount(q => q.F_Id == orderid && new int[] { 1, 3, 4 }.Contains(q.F_State));
  158. if (exist == 0)
  159. {
  160. return Error("此单号状态无效:" + orderid);
  161. }
  162. }
  163. #endregion
  164. T_Bus_OrderMerge modelOrderMerge = await busOrderMergeRepository.GetSingle(q => q.F_Id == input.F_Id);
  165. if (modelOrderMerge.F_State == 3)
  166. { return Success("已审核不能修改"); }
  167. modelOrderMerge.F_AddUser = UserLogin.UserId.ObjToInt();
  168. modelOrderMerge.F_AddUserName = UserLogin.UserName;
  169. modelOrderMerge.F_State = input.F_State;
  170. modelOrderMerge.F_Money = input.F_Money;
  171. modelOrderMerge.F_Gift = input.F_Gift;
  172. modelOrderMerge.F_Type = input.F_Type;
  173. modelOrderMerge.F_OrderList = input.F_OrderList;
  174. modelOrderMerge.F_Remark = input.F_Remark == null ? "" : input.F_Remark;
  175. if (await busOrderMergeRepository.Update(modelOrderMerge))
  176. {
  177. if (input.F_State == 0)
  178. return Success("订单合并已保存");
  179. else if (input.F_State == 1)
  180. { return Success("订单合并已提交审核"); }
  181. }
  182. return Error("订单合并失败,请重试!");
  183. }
  184. catch (Exception ex)
  185. { return Error(ex.Message); }
  186. }
  187. /// <summary>
  188. /// 删除合并订单
  189. /// </summary>
  190. /// <param name="ids"></param>
  191. /// <returns></returns>
  192. [HttpPost("deleteordermerge")]
  193. public async Task<IActionResult> DeleteOrderMerge(string ids)
  194. {
  195. try
  196. {
  197. if (string.IsNullOrEmpty(ids))
  198. {
  199. return Error("参数缺失:" + ids);
  200. }
  201. string[] idlist = ids.Split(',');
  202. if (await busOrderMergeRepository.Delete(q => idlist.Contains(q.F_Id)&&new[] { 0,1,2}.Contains(q.F_State)))
  203. {
  204. return Success("删除成功");
  205. }
  206. return Error("删除失败,请重试!");
  207. }
  208. catch (Exception ex)
  209. { return Error(ex.Message); }
  210. }
  211. /// <summary>
  212. /// 根据分页获取列表
  213. /// </summary>
  214. /// <param name="input"></param>
  215. /// <returns></returns>
  216. [HttpPost("getordermergebypage")]
  217. public async Task<IActionResult> GetOrderMergeByPage(OrderMergeInput input)
  218. {
  219. #region 拼接条件
  220. Expression<Func<T_Bus_OrderMerge, bool>> eq = a => a.F_AddUser == UserLogin.UserId.ObjToInt();
  221. if (!string.IsNullOrEmpty(input.F_OrderList))
  222. {
  223. eq = eq.And(a => a.F_OrderList.Contains(input.F_OrderList));
  224. }
  225. if (!string.IsNullOrEmpty(input.F_Type))
  226. {
  227. eq = eq.And(a => a.F_Type == input.F_Type);
  228. }
  229. if (!string.IsNullOrEmpty(input.F_Id))
  230. {
  231. eq = eq.And(a => a.F_Id == input.F_Id);
  232. }
  233. if (input.F_State >-2)
  234. {
  235. eq = eq.And(a => a.F_State == input.F_State);
  236. }
  237. #endregion
  238. RefAsync<int> count = 0;
  239. PageData<T_Bus_OrderMerge> list = await busOrderMergeRepository.GetListByPage(eq, new MyPageModel() { PageIndex = input.pageindex, PageSize = input.pagesize, PageCount = count }, " F_AddTime DESC");
  240. return Success("成功", list);
  241. }
  242. #endregion
  243. #region 客服操作
  244. /// <summary>
  245. /// 根据分页获取列表
  246. /// </summary>
  247. /// <param name="input"></param>
  248. /// <returns></returns>
  249. [HttpPost("getordermergebycheckpage")]
  250. public async Task<IActionResult> GetOrderMergeByCheckPage(OrderMergeInput input)
  251. {
  252. #region 拼接条件
  253. Expression<Func<T_Bus_OrderMerge, bool>> eq = a => (a.F_Checkuser == UserLogin.UserId.ObjToInt() || a.F_Checkuser == 0);
  254. if (!string.IsNullOrEmpty(input.F_OrderList))
  255. {
  256. eq = eq.And(a => a.F_OrderList.Contains(input.F_OrderList));
  257. }
  258. if (!string.IsNullOrEmpty(input.F_Type))
  259. {
  260. eq = eq.And(a => a.F_Type == input.F_Type);
  261. }
  262. if (input.F_State >= 0)
  263. {
  264. eq = eq.And(a => a.F_State == input.F_State);
  265. }
  266. #endregion
  267. RefAsync<int> count = 0;
  268. PageData<T_Bus_OrderMerge> list = await busOrderMergeRepository.GetListByPage(eq, new MyPageModel() { PageIndex = input.pageindex, PageSize = input.pagesize, PageCount = count }, " F_AddTime DESC");
  269. return Success("成功", list);
  270. }
  271. /// <summary>
  272. /// 审核订单
  273. /// </summary>
  274. /// <param name="id"></param>
  275. /// <param name="state">3审核通过,2审核不通过</param>
  276. /// <returns></returns>
  277. [HttpPost("checkordermerge")]
  278. public async Task<IActionResult> CheckOrderMerge(OrderMergeInput input)
  279. {
  280. try
  281. {
  282. string id = input.F_Id;
  283. int state = input.F_State;
  284. if (string.IsNullOrEmpty(id))
  285. return Error("缺失参数ID");
  286. if (state != 2 && state != 3)
  287. {
  288. return Error("参数不正确");
  289. }
  290. T_Bus_OrderMerge modelOrderMerge = await busOrderMergeRepository.GetSingle(q => q.F_Id == id);
  291. if (modelOrderMerge.F_State != 1)
  292. { return Success("未查到待审核合并"); }
  293. #region 验证逻辑
  294. foreach (string orderid in modelOrderMerge.F_OrderList.Split(','))
  295. {
  296. //订单状态 -1无效 0暂存 1提交 2KF退回 3通过 4无货 5已分拣 6已发货
  297. int exist = await bus_OrderRepository.GetCount(q => q.F_Id == orderid && new int[] { 1, 3, 4 }.Contains(q.F_State));
  298. if (exist == 0)
  299. {
  300. return Error("此单号状态已失效:" + orderid);
  301. }
  302. }
  303. #endregion
  304. modelOrderMerge.F_Checkuser = UserLogin.UserId.ObjToInt();
  305. modelOrderMerge.F_CheckuserName = UserLogin.UserName;
  306. modelOrderMerge.F_State = state;
  307. modelOrderMerge.F_CheckTime = DateTime.Now;
  308. modelOrderMerge.F_CheckRemak = input.F_CheckRemak;
  309. if (state == 3)
  310. {
  311. bool bl = true;
  312. List<T_Bus_Order> modelorderlist = new List<T_Bus_Order>();
  313. decimal totle = 0.00M;
  314. foreach (string orderid in modelOrderMerge.F_OrderList.Split(','))
  315. {
  316. T_Cus_VipInfo modelvip = new T_Cus_VipInfo();
  317. T_Bus_Order modelOrder = await bus_OrderRepository.GetSingle(q => q.F_Id == orderid);
  318. if (modelOrder == null)
  319. {
  320. bl = false;
  321. break;
  322. }
  323. //待审核 审核
  324. if (modelOrder.F_State == 1)
  325. {
  326. modelOrder.F_CheckTime = DateTime.Now;
  327. modelOrder.F_CheckUser = UserLogin.UserId.ObjToInt();
  328. modelOrder.F_CheckUserName = UserLogin.UserName;
  329. modelOrder.F_CheckRemark = "订单合并";
  330. #region 判断积分
  331. bool blScore = false;
  332. if (modelOrder.F_UseScore > 0)
  333. {
  334. //退回积分 查询批次号核算积分是否已经解冻
  335. if (true)
  336. {
  337. //log 或者解冻积分
  338. blScore = true;
  339. }
  340. }
  341. else
  342. {
  343. blScore = true;
  344. }
  345. if (!blScore)
  346. {
  347. //积分处理失败 暂时不管不影响
  348. }
  349. #endregion
  350. modelOrder.F_State = 3;
  351. totle += modelOrder.F_ShouldPrice;
  352. modelorderlist.Add(modelOrder);
  353. }
  354. if (modelOrder.F_State == 3)
  355. {
  356. totle += modelOrder.F_ShouldPrice;
  357. modelorderlist.Add(modelOrder);
  358. }
  359. }
  360. if (!bl)
  361. {
  362. return Success("订单状态已经变化,无法合并");
  363. }
  364. else
  365. {
  366. T_Bus_OrderDetail modelDetail = null;
  367. List<T_Bus_StockLog> modeStocklogs = null;
  368. SetStockModel setStockModel = null;
  369. int n = 0;
  370. decimal totle2 = 0.00M;
  371. foreach (T_Bus_Order m in modelorderlist)
  372. {
  373. if (n == 0&& modelOrderMerge.F_Gift != "")
  374. {
  375. T_Bus_Product productModel =await bus_productRepository.GetSingle(q=>q.F_ProductId== modelOrderMerge.F_Gift);
  376. if (productModel == null)
  377. break;
  378. modelDetail = new T_Bus_OrderDetail();
  379. modelDetail.F_ProductName = productModel.F_ProductName;
  380. modelDetail.F_ProductId = productModel.F_ProductId;
  381. modelDetail.F_Id = Guid.NewGuid().ToString().Replace("-", "");
  382. modelDetail.F_OrderId = input.F_Id;
  383. modelDetail.F_Count = 1;
  384. modelDetail.F_Price = 0.00M;
  385. modelDetail.F_DealPrice = 0.00M;
  386. modelDetail.F_Sort = 0;
  387. modelDetail.F_Remark = "合并订单:"+ modelOrderMerge.F_Id;
  388. modelDetail.F_AddUser = UserLogin.UserId.ObjToInt();
  389. modelDetail.F_AddUserName = UserLogin.UserName;
  390. modelDetail.F_TotlePrice = 0.00M;
  391. modelDetail.F_Activity = 0;
  392. modelDetail.F_AddTime = DateTime.Now;
  393. #region 记录库存log
  394. modeStocklogs = new List<T_Bus_StockLog>();
  395. T_Bus_StockLog modelStock = new T_Bus_StockLog();
  396. modelStock.F_Id = Guid.NewGuid().ToString().Replace("-", "");
  397. modelStock.F_Action = 1;
  398. modelStock.F_AddTime = DateTime.Now;
  399. modelStock.F_FlowNum = m.F_FlowNum;
  400. modelStock.F_BatchNum = 0;
  401. modelStock.F_OrderId = m.F_Id;
  402. modelStock.F_State = 0;
  403. modelStock.F_UserId = m.F_AddUser;
  404. modelStock.F_UserName = m.F_AddUserName;
  405. modelStock.F_Stock = m.F_Stock;
  406. modelStock.F_Status = 0;
  407. modelStock.F_Num = -1;
  408. modelStock.F_ProductId = productModel.F_ProductId;
  409. modeStocklogs.Add(modelStock);
  410. #endregion
  411. #region 请求库存对象
  412. List<StockChangeModel> stockChangeModels = new List<StockChangeModel>();
  413. StockChangeModel stockChangeModel = new StockChangeModel();
  414. stockChangeModel.sku = productModel.F_ProductId;
  415. stockChangeModel.qty = -1;
  416. stockChangeModels.Add(stockChangeModel);
  417. setStockModel = new SetStockModel();
  418. setStockModel.store = m.F_Stock;
  419. setStockModel.dts = stockChangeModels;
  420. setStockModel.masterid = m.F_FlowNum;
  421. setStockModel.remark = "合并审核减库存";
  422. #endregion
  423. }
  424. if (modelOrderMerge.F_Money != 0)
  425. {
  426. if (n == modelorderlist.Count - 1)
  427. {
  428. m.F_MergeMoney = totle - totle2;
  429. }
  430. else
  431. {
  432. m.F_MergeMoney = Math.Round( modelOrderMerge.F_Money * m.F_ShouldPrice / totle,2);
  433. totle2 += m.F_MergeMoney;
  434. }
  435. // modelOrderMerge.F_Money *m.F_ShouldPrice/totle
  436. }
  437. n++;
  438. }
  439. if (modelDetail != null)
  440. {
  441. ResultMessage modelMessage = await busOrcerFunctionController.ChangeStock(setStockModel, modeStocklogs);
  442. if (modelMessage.Status)
  443. {
  444. //处理库存
  445. }
  446. }
  447. await bus_OrderRepository.UpdateList(modelorderlist);
  448. }
  449. }
  450. else if (state == 2)
  451. {
  452. }
  453. if (await busOrderMergeRepository.Update(modelOrderMerge))
  454. {
  455. return Success("成功");
  456. }
  457. return Error("审核失败,请重试!");
  458. }
  459. catch (Exception ex)
  460. { return Error(ex.Message); }
  461. }
  462. #endregion
  463. }
  464. }