From 9fe266f1956ac01a7ab446d3c84a046ac4ea90af Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周五, 13 12月 2024 09:33:31 +0800
Subject: [PATCH] 1
---
LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsCommonnQuery/WmsCommonnQueryService.cs | 842 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 838 insertions(+), 4 deletions(-)
diff --git a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsCommonnQuery/WmsCommonnQueryService.cs b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsCommonnQuery/WmsCommonnQueryService.cs
index 0739fe9..c77a4e3 100644
--- a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsCommonnQuery/WmsCommonnQueryService.cs
+++ b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsCommonnQuery/WmsCommonnQueryService.cs
@@ -7,6 +7,9 @@
using DocumentFormat.OpenXml.Office.CustomUI;
using Microsoft.CodeAnalysis.Operations;
using Admin.NET.Application.Service.WmsTask.WmsRbLineTask.Dto;
+using Admin.NET.Application.Service.WmsCommonnQuery.Dto;
+using System.Collections.Generic;
+using Admin.NET.Application.CommonHelper;
namespace Admin.NET.Application;
/// <summary>
@@ -16,26 +19,38 @@
[AllowAnonymous]
public class WmsCommonnQueryService : IDynamicApiController, ITransient
{
- private readonly SqlSugarRepository<WmsRbLineTask> _rep;
+ private readonly SqlSugarRepository<WmsRbLineTask> _wmsRbLineTaskRep;
private readonly SqlSugarRepository<WmsStockQuan> _wmsStockQuanRep;
private readonly SqlSugarRepository<Mes_Package_Gather> _mesPackageGatherRep;
private readonly SqlSugarRepository<SysConfig> _sysConfigRep;
private readonly SqlSugarRepository<Mes_BatchOrderUPI_New> _mesBatchOrderUpiRep;
private readonly SqlSugarRepository<Mes_Order_Gather> _mesOrderGatherRep;
+ private readonly SqlSugarRepository<Mes_Package_UnLine_Record> _mesPackage_UnLine_RecordRep;
+ private readonly SqlSugarRepository<Mes_Package_LineQueue> _mesPackage_LineQueueRep;
+ private readonly SqlSugarRepository<WmsRecordUpiReplenish> _wmsRecordUpiReplenishRep;
+ private readonly SqlSugarRepository<WmsRecordUpiProcess> _wmsRecordUpiProcessRep;
- public WmsCommonnQueryService(SqlSugarRepository<WmsRbLineTask> rep, SqlSugarRepository<WmsStockQuan> wmsStockQuanRep
+ public WmsCommonnQueryService(SqlSugarRepository<WmsRbLineTask> wmsRbLineTaskRep, SqlSugarRepository<WmsStockQuan> wmsStockQuanRep
, SqlSugarRepository<Mes_Package_Gather> mesPackageGatherRep
, SqlSugarRepository<SysConfig> sysConfigRep
, SqlSugarRepository<Mes_BatchOrderUPI_New> mesBatchOrderUpiRep
, SqlSugarRepository<Mes_Order_Gather> mesOrderGatherRep
+ , SqlSugarRepository<Mes_Package_UnLine_Record> mesPackage_UnLine_RecordRep
+ , SqlSugarRepository<Mes_Package_LineQueue> mesPackage_LineQueueRep
+ , SqlSugarRepository<WmsRecordUpiReplenish> wmsRecordUpiReplenishRep
+ , SqlSugarRepository<WmsRecordUpiProcess> wmsRecordUpiProcessRep
)
{
+ _wmsRecordUpiReplenishRep = wmsRecordUpiReplenishRep;
_sysConfigRep = sysConfigRep;
_mesPackageGatherRep = mesPackageGatherRep;
- _rep = rep;
+ _wmsRbLineTaskRep = wmsRbLineTaskRep;
_wmsStockQuanRep = wmsStockQuanRep;
_mesBatchOrderUpiRep = mesBatchOrderUpiRep;
_mesOrderGatherRep = mesOrderGatherRep;
+ _mesPackage_UnLine_RecordRep = mesPackage_UnLine_RecordRep;
+ _mesPackage_LineQueueRep = mesPackage_LineQueueRep;
+ _wmsRecordUpiProcessRep = wmsRecordUpiProcessRep;
}
/// <summary>
@@ -60,6 +75,39 @@
}
+
+ /// <summary>
+ /// 鏌ヨ 璁″垝鐢熶骇璁㈠崟璁板綍 锛堝ぇ灞忎娇鐢級
+ /// </summary>
+ /// <returns></returns>
+ [HttpGet]
+ [ApiDescriptionSettings(Name = "QueryPlanOrderList")]
+ [Description("WmsCommonnQuery/QueryPlanOrderList")]
+ public async Task<List<Mes_Order_Gather>> QueryPlanOrderList()
+ {
+ var list = await _mesPackage_LineQueueRep.AsQueryable()
+ .OrderBy(g => g.Id)
+ .ToListAsync(); // 纭繚鑾峰彇缁撴灉涓� List
+ List<Mes_Order_Gather> resultList = new List<Mes_Order_Gather>();
+ foreach (var item in list)
+ {
+ if (resultList.Select(x => x.Info5).ToList().Contains(item.Info5))
+ {
+
+ }
+ else
+ {
+ var mesOrderGather = await _mesOrderGatherRep.GetFirstAsync(x => x.Info5 == item.Info5);
+ if (mesOrderGather != null)
+ {
+ resultList.Add(mesOrderGather);
+ }
+ }
+ }
+
+ return resultList; // 缁撴灉
+ }
+
/// <summary>
/// 鏌ヨ 鍘嗗彶鐢熶骇璁㈠崟璁板綍 锛堝ぇ灞忎娇鐢級
/// </summary>
@@ -73,7 +121,7 @@
var sysConfig_wms_unline_time = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.wms_unline_time);
if (sysConfig_wms_unline_time == null || sysConfig_wms_unline_time.Value == "鏃�")
{
- throw Oops.Oh($"娌℃湁閰嶇疆 鍖呰涓嬬嚎鐧婚檰鏃堕棿 鍊�");
+ return null;
}
var unLineTime = Convert.ToDateTime(sysConfig_wms_unline_time.Value);
@@ -85,5 +133,791 @@
return list; // 缁撴灉
}
+
+
+ /// <summary>
+ /// 鏌ヨ 褰撳墠鐢熶骇璁㈠崟璁板綍 锛堝ぇ灞忎娇鐢級
+ /// </summary>
+ /// <returns></returns>
+ [HttpGet]
+ [ApiDescriptionSettings(Name = "QueryCurrentOrder")]
+ [Description("WmsCommonnQuery/QueryCurrentOrder")]
+ public async Task<Mes_Order_Gather> QueryCurrentOrder()
+ {
+ //鑾峰彇涓婄彮鏃堕棿銆�
+ var sysConfig_wms_wms_unline_oper = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.WmsBZ30_QiTao);
+ if (sysConfig_wms_wms_unline_oper == null || sysConfig_wms_wms_unline_oper.Value == "鏃�")
+ {
+ return null;
+ }
+ var arr = sysConfig_wms_wms_unline_oper.Value.Split('|');
+ var packagecode = arr[0];
+ var packObj = await _mesPackageGatherRep.AsQueryable().FirstAsync(x => x.PackageCode == packagecode);
+ if (packObj == null)
+ {
+ throw Oops.Oh($"娌℃湁鎵惧埌鍖厈packagecode}鐨勬眹鎬绘暟鎹�");
+ }
+
+ var list = await _mesOrderGatherRep.AsQueryable()
+ .Where(x => x.Info5 == packObj.Info5)
+ .FirstAsync(); // 纭繚鑾峰彇缁撴灉涓� List
+
+ return list; // 缁撴灉
+ }
+
+
+
+
+ /// <summary>
+ /// 澶у睆 - 鐧诲綍浜� 鐧诲綍鏃堕棿 LS070700117B0005GS
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpGet]
+ [ApiDescriptionSettings(Name = "ScreenLogin")]
+ [Description("WmsCommonnQuery/ScreenLogin")]
+ [AllowAnonymous]
+ public async Task<ScreenLoginUserOutput> ScreenLogin([FromQuery] Mes_Package_LineQueueInput input)
+ {
+ // 鍩烘湰鏌ヨ
+ var list = await _sysConfigRep.AsQueryable()
+ .Where(x => x.Code == "wms_bz30_qitao" || x.Code == "wms_unline_oper" || x.Code == "wms_unline_time")
+ .ToListAsync();
+ // 妫�鏌ist鏄惁涓虹┖
+ if (list == null || !list.Any())
+ {
+ // 杩斿洖榛樿鍊兼垨鑰呮姏鍑哄紓甯�
+ return new ScreenLoginUserOutput
+ {
+ LoginUser = null,
+ TimeLogin = null,
+ };
+ }
+
+ //鑾峰彇涓婄彮鏃堕棿銆�
+ DateTime unLineTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 00:00:00"));
+ var sysConfig_wms_unline_time = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.wms_unline_time);
+ if (sysConfig_wms_unline_time == null || sysConfig_wms_unline_time.Value == "鏃�")
+ {
+
+ }
+ else
+ {
+ unLineTime = Convert.ToDateTime(sysConfig_wms_unline_time.Value);
+ }
+
+
+ var recordList = await _mesPackage_UnLine_RecordRep.AsQueryable()
+ .Where(x => x.CreateTime >= unLineTime)
+ .ToListAsync(); // 纭繚鑾峰彇缁撴灉涓� List
+ //姹囨�绘暟鎹�
+
+
+ TimeSpan ts = DateTime.Now - unLineTime;
+
+ // 杩斿洖缁撴灉
+ return new ScreenLoginUserOutput
+ {
+ LoginUser = list.FirstOrDefault(x => x.Code == "wms_unline_oper")?.Value,
+ TimeLogin = list.FirstOrDefault(x => x.Code == "wms_unline_time")?.Value,
+ AllOrderNum = recordList.GroupBy(x => x.Info5).Count(),
+ AllPackageArea = recordList.Sum(x => Convert.ToDecimal((x.Info13))),
+ PackageNum = recordList.GroupBy(x => x.PackageCode).Count(),
+ WorkTime = ts.TotalHours
+ };
+ }
+
+
+
+ /// <summary>
+ /// 涓嶅垎椤垫煡璇㈢紦瀛樺矝榻愬寘绠＄悊
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpGet]
+ [ApiDescriptionSettings(Name = "packList")]
+ [Description("WmsCommonnQuery/packList")]
+ public async Task<List<WmsPackListOutput>> PackList([FromQuery] PackListInput input)
+ {
+ // 鑾峰彇绗﹀悎鏉′欢鐨勮褰曪紝骞舵彁鍙栨墍闇�淇℃伅
+ var list = await _wmsStockQuanRep.AsQueryable()
+ .WhereIF(!string.IsNullOrWhiteSpace(input.PackageCode), u => u.PackageCode.Contains(input.PackageCode.Trim()))
+ .Select(x => new { x.PackageCode })
+ .ToListAsync();
+
+ // 鍒涘缓涓�涓垪琛ㄤ互瀛樺偍 WmsPackListOutput
+ var resultList = new List<WmsPackListOutput>();
+
+ // 鍒嗙粍骞惰绠楁瘡缁勪俊鎭�
+ var groupedResult = list.GroupBy(x => x.PackageCode);
+
+ foreach (var g in groupedResult)
+ {
+ // 鍦ㄨ繖閲岃绠楁瘡缁勭殑鎬绘暟
+ var count = g.Count();
+ var mesTotalCount = await _mesBatchOrderUpiRep.AsQueryable().CountAsync(m => m.PackageCode == g.Key);
+
+ resultList.Add(new WmsPackListOutput
+ {
+ PackageCode = g.Key,
+ Count = count,
+ MesTotalCount = mesTotalCount,
+ IsPack = count >= mesTotalCount, // 妫�鏌ユ槸鍚︽墦鍖�
+ LackCount = mesTotalCount - count
+ });
+ }
+
+ // 杩囨护銆佹帓搴忓苟杩斿洖鏈�缁堢粨鏋�
+ var finalResult = resultList
+ .WhereIF(input.IsPack.HasValue, u => u.IsPack == input.IsPack)
+ .OrderBy(g => g.PackageCode)
+ .ToList();
+
+ return finalResult;
+ }
+
+
+
+ /// <summary>
+ /// 涓嶅垎椤垫煡璇㈤綈濂楃鐞�
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpGet]
+ [ApiDescriptionSettings(Name = "KittingList")]
+ [Description("WmsCommonnQuery/KittingList")]
+ public async Task<List<WmsKittingListOutput>> KittingList([FromQuery] KittingListInput input)
+ {
+ var list = await _wmsStockQuanRep.AsQueryable()
+ .WhereIF(!string.IsNullOrWhiteSpace(input.DetailName), u => u.PlaceCode.Contains(input.DetailName.Trim()))
+ .Select(x => new WmsKittingListOutput
+ {
+ OrderId = x.OrderId
+ })
+ .ToListAsync(); // 纭繚鑾峰彇缁撴灉涓� List
+
+ // 鍒嗙粍骞惰繑鍥炲垎缁勪俊鎭�
+ var groupedResult = list
+ .GroupBy(x => x.OrderId) // 鎸� PackageCode 鍒嗙粍
+ .Select(g => new WmsKittingListOutput
+ {
+ OrderId = g.Key, // 鑾峰彇鍒嗙粍鐨勯敭
+ Count = g.Count(), // 缁熻姣忕粍鐨勬暟閲�
+ IsKitting = 1 == 1 ? true : false // 濡傛灉 Count 涓� 5 鍒� IsKitting 涓� 1锛屽惁鍒欎负 0
+ })
+ .WhereIF(input.IsKitting.HasValue, u => u.IsKitting == input.IsKitting)
+ .OrderBy(g => g.OrderId) // 鏍规嵁 PackageCode 鎺掑簭
+ .ToList(); // 杞崲涓� List
+ return groupedResult; // 杩斿洖鍒嗙粍缁撴灉
+ }
+
+
+
+
+
+
+ /// <summary>
+ /// 浜哄伐琛ユ澘鍔ㄤ綔
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ /// [HttpGet]
+ [ApiDescriptionSettings(Name = "ShortageList")]
+ [Description("WmsCommonnQuery/ShortageList")]
+ public async Task<WmsShortageListOutput> ShortageList(KittingListInput input)
+ {
+ var listRes = await GetShortageListCore(input);
+ var resJson = new WmsShortageListOutput();
+ if (!string.IsNullOrWhiteSpace(input.UPI))
+ {
+ resJson = listRes.FirstOrDefault(u => u.UPI == input.UPI);
+ //var filteredResult = listRes.FirstOrDefault(u => u.UPI == input.UPI);
+ }
+ var _cretaorName = App.User.FindFirst(ClaimConst.RealName)?.Value;
+ if (resJson != null)
+ {
+ //鎵ц浜哄伐琛ユ澘鍔ㄤ綔
+ var client = await WCFServiceHelper.GetWCFService_SAPCC_Client(_sysConfigRep);
+ var res = await client.WriteStation_AllowInAsync();
+ if (res.result == false)
+ {
+ throw Oops.Oh("琛ユ澘宸ヤ綅鍏佽杩涙澘璇锋眰澶辫触:" + res.resMsg);
+ }
+ //*/
+
+ //璁板綍琛ユ澘璁板綍鍜屾澘浠跺饱鍘�
+ var singleUpi = await _mesBatchOrderUpiRep.AsQueryable().Where(x => x.UPI == input.UPI).FirstAsync();
+ if (singleUpi == null)
+ {
+ throw Oops.Oh($"娌℃湁鎵惧埌閮ㄤ欢鏉＄爜{input.UPI}鐨勬暟鎹�");
+ }
+ WmsRecordUpiProcess wmsRecordUpi = new WmsRecordUpiProcess();
+ wmsRecordUpi = singleUpi.Adapt<WmsRecordUpiProcess>();
+ wmsRecordUpi.Id = Yitter.IdGenerator.YitIdHelper.NextId();
+ wmsRecordUpi.CreateTime = DateTime.Now;
+ wmsRecordUpi.CreateUserName = _cretaorName;
+ wmsRecordUpi.Location = "";
+ wmsRecordUpi.OperRemark = "浜哄伐琛ユ澘";
+ await _wmsRecordUpiProcessRep.InsertAsync(wmsRecordUpi);
+
+ WmsRecordUpiReplenish wmsRecordUpiNg = new WmsRecordUpiReplenish();
+ wmsRecordUpiNg = singleUpi.Adapt<WmsRecordUpiReplenish>();
+ wmsRecordUpiNg.Id = Yitter.IdGenerator.YitIdHelper.NextId();
+ wmsRecordUpiNg.CreateTime = DateTime.Now;
+ wmsRecordUpiNg.CreateUserName = _cretaorName;
+ wmsRecordUpiNg.OperRemark = "浜哄伐琛ユ澘";
+ await _wmsRecordUpiReplenishRep.InsertAsync(wmsRecordUpiNg);
+ }
+ else
+ {
+ throw Oops.Oh($"鏉夸欢'{input.UPI}'涓嶅湪缂哄寘娓呭崟涓�");
+ }
+
+ return resJson;
+ }
+
+ /// <summary>
+ /// 鍒嗛〉鏌ヨ鎵规缂烘枡娓呭崟 涓嶉綈鍖�
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpPost]
+ [ApiDescriptionSettings(Name = "ShortagePage")]
+ [Description("WmsCommonnQuery/ShortagePage")]
+ public async Task<SqlSugarPagedList<WmsShortageListOutput>> ShortagePage(KittingListInput input)
+ {
+ var listRes = await GetShortageListCore(input);
+ if (listRes?.Count > 0)
+ {
+ listRes = listRes.WhereIF(!string.IsNullOrWhiteSpace(input.Info5), u => u.Info5 == input.Info5).ToList();
+ listRes = listRes.WhereIF(!string.IsNullOrWhiteSpace(input.DetailName), u => u.DetailName == input.DetailName).ToList();
+ }
+ // 杩涜鍒嗛〉澶勭悊
+ var totalCount = listRes.Count; // 鑾峰彇鎬绘暟
+ var pagedList = listRes
+ //.OrderBy(x => x.Id) // 鏍规嵁闇�瑕佽繘琛屾帓搴�
+ .Skip((input.Page - 1) * input.PageSize)
+ .Take(input.PageSize)
+ .ToList();
+
+ // 鏋勯�犲苟杩斿洖鍒嗛〉缁撴灉
+ return new SqlSugarPagedList<WmsShortageListOutput>
+ {
+ Page = input.Page,
+ PageSize = input.PageSize,
+ Total = totalCount,
+ TotalPages = (int)Math.Ceiling((double)totalCount / input.PageSize),
+ Items = pagedList,
+ HasPrevPage = input.Page > 1,
+ HasNextPage = input.Page < ((int)Math.Ceiling((double)totalCount / input.PageSize))
+ };
+ }
+
+
+ /// <summary>
+ /// 鍒嗛〉鏌ヨ缂烘枡娓呭崟 涓嶉綈鍖� -鎸夌収鐢熶骇鍗曞彿鍒嗙粍
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpPost]
+ [ApiDescriptionSettings(Name = "ShortagePageGroupByInfo5")]
+ [Description("WmsCommonnQuery/ShortagePageGroupByInfo5")]
+ public async Task<SqlSugarPagedList<WmsShortageListOutput>> ShortagePageGroupByInfo5(KittingListInput input)
+ {
+ var listRes = await GetShortageListCore(input);
+
+ // 鎸夌収瀛楁 Info5 鍒嗙粍
+ var groupedList = listRes
+ .GroupBy(x => x.Info5) // 鏍规嵁 Info5 瀛楁杩涜鍒嗙粍
+ .Select(g => new WmsShortageListOutput // 鍋囪鎮ㄥ皢鍒嗙粍鍚庣殑缁撴灉杞崲涓� WmsShortageListOutput
+ {
+ Info5 = g.Key,
+ ShortageCount = g.Count(),
+ })
+ .ToList();
+
+ // 杩涜鍒嗛〉澶勭悊
+ var totalCount = groupedList.Count; // 鑾峰彇鎬绘暟
+ var pagedList = groupedList
+ //.OrderBy(x => x.Id) // 鏍规嵁闇�瑕佽繘琛屾帓搴�
+ .Skip((input.Page - 1) * input.PageSize)
+ .Take(input.PageSize)
+ .ToList();
+
+ // 鏋勯�犲苟杩斿洖鍒嗛〉缁撴灉
+ return new SqlSugarPagedList<WmsShortageListOutput>
+ {
+ Page = input.Page,
+ PageSize = input.PageSize,
+ Total = totalCount,
+ TotalPages = (int)Math.Ceiling((double)totalCount / input.PageSize),
+ Items = pagedList,
+ HasPrevPage = input.Page > 1,
+ HasNextPage = input.Page < ((int)Math.Ceiling((double)totalCount / input.PageSize))
+ };
+ }
+
+
+
+ /// <summary>
+ /// 缂哄寘鏁版嵁
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ private async Task<List<WmsShortageListOutput>> GetShortageListCore(KittingListInput input)
+ {
+ var listRes = new List<WmsShortageListOutput>();
+ // 缂撳瓨宀涙暟鎹�
+ var queryHcdList = _wmsStockQuanRep.AsQueryable().WhereIF(!string.IsNullOrWhiteSpace(input.PackageCode), u => u.PackageCode == input.PackageCode);
+
+ var listDao = await queryHcdList.ToListAsync();
+ var packageCodes = listDao.Select(x => x.PackageCode).ToList();
+ // 鑾峰彇 mes 鎵�鏈夌浉鍏宠褰�
+ var allRecords = await _mesBatchOrderUpiRep.AsQueryable()
+ .Where(m => packageCodes.Contains(m.PackageCode))
+ .ToListAsync();
+ // 閬嶅巻璁板綍锛屽姣� listDao
+ var listDaoUbi = listDao.Select(u => u.Upi).ToHashSet(); // 灏� UPI 杞崲涓� HashSet锛屾彁楂樻煡鎵炬晥鐜�
+ foreach (var item in allRecords)
+ {
+ if (!listDaoUbi.Contains(item.UPI)) // 浣跨敤 HashSet 杩涜鏌ユ壘
+ {
+ listRes.Add(new WmsShortageListOutput
+ {
+ UPI = item.UPI,
+ PackageCode = item.PackageCode,
+ DetailName = item.DetailName,
+ OrderId = item.OrderId,
+ PlanNo = item.PlanNo,
+ Info5 = item.Info5,
+ Info4 = item.Info4,
+ Info10 = item.Info10,
+ Info11 = item.Info11,
+ Info12 = item.Info12,
+ Info13 = item.Info13,
+ //Info14 = item.Info14,
+ Info15 = item.Info15,
+ Info16 = item.Info16,
+ Info18 = item.Info18,
+ Length = item.Length,
+ Width = item.Width,
+ Thk = item.Thk
+ });
+ }
+ }
+
+ return listRes;
+ }
+
+ /// <summary>
+ /// 鍒嗛〉鏌ヨ鎵规缂烘枡娓呭崟 涓嶉綈鍖� -鏆傛椂涓嶇敤
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpPost]
+ [ApiDescriptionSettings(Name = "ShortagePage2")]
+ [Description("WmsCommonnQuery/ShortagePage2")]
+ public async Task<SqlSugarPagedList<WmsShortageListOutput>> ShortagePage2(KittingListInput input)
+ {
+ // 鑾峰彇鍩虹鏁版嵁
+ var list = await _wmsStockQuanRep.AsQueryable()
+ .WhereIF(!string.IsNullOrWhiteSpace(input.DetailName), u => u.PlaceCode.Contains(input.DetailName.Trim()))
+ .Select(x => new WmsShortageListOutput
+ {
+ OrderId = x.OrderId,
+ PlanNo = x.PlanNo,
+ PackageCode = x.PackageCode
+ })
+ .ToListAsync(); // 纭繚鑾峰彇缁撴灉涓� List
+
+ // 鍒嗙粍骞惰繑鍥炲垎缁勪俊鎭�
+ var groupedResult = list
+ .GroupBy(x => x.OrderId) // 鎸� OrderId 鍒嗙粍
+ .Select(g => new WmsShortageListOutput
+ {
+ OrderId = g.Key, // 鑾峰彇鍒嗙粍鐨勯敭
+ PlanNo = g.FirstOrDefault().PlanNo, // 鑾峰彇缁勫唴鐨勭涓�涓� PlanNo
+ PackageCode = g.FirstOrDefault().PackageCode, // 鑾峰彇缁勫唴鐨勭涓�涓� PackageCode
+ HasCount = g.Count(), // 缁熻姣忕粍鐨勬暟閲�
+ TotalCount = 0, // 鍒濆鍖� TotalCount
+ ShortageCount = 0 // 鍒濆鍖� ShortageCount
+ })
+ .OrderBy(g => g.OrderId) // 鏍规嵁 OrderId 鎺掑簭
+ .ToList(); // 杞崲涓� List
+
+ // 寰幆 groupedResult 缁欐瘡涓�鏉″姞涓婃�绘暟閲� TotalCount
+ foreach (var item in groupedResult)
+ {
+ item.TotalCount = await _mesBatchOrderUpiRep.AsQueryable().CountAsync(m => m.PackageCode == item.PackageCode); // 鏍规嵁 PackageCode 缁熻鎬绘潯鏁�
+ item.ShortageCount = item.TotalCount - item.HasCount > 0 ? item.TotalCount - item.HasCount : 0;
+ }
+
+ // 鍒嗛〉澶勭悊
+ var pagedResult = groupedResult.AsQueryable() // 灏嗗垎缁勭粨鏋滆浆鎹负鍙煡璇㈢殑闆嗗悎
+ .OrderBy(g => g.OrderId) // 杩涜鎺掑簭
+ .Skip((input.Page - 1) * input.PageSize) // 璺宠繃鍓嶉潰鐨勯〉鏁�
+ .Take(input.PageSize) // 鍙栧嚭褰撳墠椤电殑鏁版嵁
+ .ToList(); // 杞崲涓� List
+
+ var totalCount = groupedResult.Count; // 鑾峰彇鎬绘暟
+ var totalPages = (int)Math.Ceiling((double)totalCount / input.PageSize); // 璁＄畻鎬婚〉鏁�
+
+ // 鏋勯�犲苟杩斿洖鍒嗛〉缁撴灉
+ return new SqlSugarPagedList<WmsShortageListOutput>
+ {
+ Page = input.Page,
+ PageSize = input.PageSize,
+ Total = totalCount,
+ TotalPages = totalPages,
+ Items = pagedResult,
+ HasPrevPage = input.Page > 1,
+ HasNextPage = input.Page < totalPages
+ };
+ }
+
+
+ /// <summary>
+ /// 涓嶅垎椤垫煡璇㈡壒娆＄己鏂欐竻鍗� 涓嶉綈鍖�-鏆傛椂涓嶇敤
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpGet]
+ [ApiDescriptionSettings(Name = "ShortageList2")]
+ [Description("WmsCommonnQuery/ShortageList2")]
+ public async Task<List<WmsShortageListOutput>> ShortageList2([FromQuery] KittingListInput input)
+ {
+ var list = await _wmsStockQuanRep.AsQueryable()
+ .WhereIF(!string.IsNullOrWhiteSpace(input.DetailName), u => u.PlaceCode.Contains(input.DetailName.Trim()))
+ .Select(x => new WmsShortageListOutput
+ {
+ OrderId = x.OrderId,
+ PlanNo = x.PlanNo,
+ PackageCode = x.PackageCode
+ })
+ .ToListAsync(); // 纭繚鑾峰彇缁撴灉涓� List
+
+ // 鍒嗙粍骞惰繑鍥炲垎缁勪俊鎭�
+ var groupedResult = list
+ .GroupBy(x => x.OrderId) // 鎸� OrderId 鍒嗙粍
+ .Select(g => new WmsShortageListOutput
+ {
+ OrderId = g.Key, // 鑾峰彇鍒嗙粍鐨勯敭
+ PlanNo = g.FirstOrDefault().PlanNo, // 鑾峰彇缁勫唴鐨勭涓�涓� PlanNo
+ PackageCode = g.FirstOrDefault().PackageCode, // 鑾峰彇缁勫唴鐨勭涓�涓� PackageCode
+ HasCount = g.Count(), // 缁熻姣忕粍鐨勬暟閲�
+ TotalCount = 0, // 鍒濆鍖� TotalCount
+ ShortageCount = 0 // 鍒濆鍖� ShortageCount
+ })
+ .OrderBy(g => g.OrderId) // 鏍规嵁 OrderId 鎺掑簭
+ .ToList(); // 杞崲涓� List
+
+ // 寰幆 groupedResult 缁欐瘡涓�鏉″姞涓婃�绘暟閲� CountTotal
+ foreach (var item in groupedResult)
+ {
+ item.TotalCount = await _mesBatchOrderUpiRep.AsQueryable().CountAsync(m => m.PackageCode == item.PackageCode); // 鏍规嵁 PackageCode 缁熻鎬绘潯鏁�
+ item.ShortageCount = item.TotalCount - item.HasCount > 0 ? item.TotalCount - item.HasCount : 0;
+ }
+
+ return groupedResult; // 杩斿洖鍒嗙粍缁撴灉
+ }
+
+
+ /// <summary>
+ /// 鏌ヨ鍖呮暟鎹�
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpPost]
+ [ApiDescriptionSettings(Name = "QueryPackage")]
+ [Description("WmsCommonnQuery/QueryPackage")]
+ public async Task<Mes_Package_Gather> QueryPackage(QueryPackageInput input)
+ {
+ if (input == null || input.PackageCode == null)
+ {
+ throw Oops.Oh("鍙傛暟涓嶈兘涓虹┖");
+ }
+
+ var package = await _mesPackageGatherRep.AsQueryable().Where(x => x.PackageCode == input.PackageCode).FirstAsync();
+ if (package == null)
+ {
+ throw Oops.Oh($"娌℃湁鎵惧埌鍖呭彿{input.PackageCode}鐨勬眹鎬绘暟鎹�");
+ }
+ return package;
+ }
+
+
+ /// <summary>
+ /// 鏍规嵁鍖呭彿锛屾煡璇㈡煇涓寘涓嬬殑鏉夸欢鏁版嵁
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpPost]
+ [ApiDescriptionSettings(Name = "QueryUpiListByPackage")]
+ [Description("WmsCommonnQuery/QueryUpiListByPackage")]
+ public async Task<List<Mes_BatchOrderUPI_New>> QueryUpiListByPackage(QueryPackageInput input)
+ {
+ if (input == null || input.PackageCode == null)
+ {
+ throw Oops.Oh("鍙傛暟涓嶈兘涓虹┖");
+ }
+
+ var package = await _mesPackageGatherRep.AsQueryable().Where(x => x.PackageCode == input.PackageCode).FirstAsync();
+ if (package == null)
+ {
+ throw Oops.Oh($"娌℃湁鎵惧埌鍖呭彿{input.PackageCode}鐨勬眹鎬绘暟鎹�");
+ }
+
+ var upiList = await _mesBatchOrderUpiRep.AsQueryable().Where(x => x.PackageCode == input.PackageCode).ToListAsync();
+
+ return upiList;
+ }
+
+ /// <summary>
+ /// 鏍规嵁鏌愪釜Upi锛屾煡璇㈡煇涓寘涓嬬殑鏉夸欢鏁版嵁
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpPost]
+ [ApiDescriptionSettings(Name = "QueryUpiListByUpi")]
+ [Description("WmsCommonnQuery/QueryUpiListByUpi")]
+ public async Task<List<Mes_BatchOrderUPI_New>> QueryUpiListByUpi(QueryUpiListByUpiInput input)
+ {
+ if (input == null || input.Upi == null)
+ {
+ throw Oops.Oh("鍙傛暟涓嶈兘涓虹┖");
+ }
+
+ var singleUpi = await _mesBatchOrderUpiRep.AsQueryable().Where(x => x.UPI == input.Upi || x.PackageCode == input.Upi).FirstAsync();
+ if (singleUpi == null)
+ {
+ throw Oops.Oh($"娌℃湁鎵惧埌閮ㄤ欢鏉＄爜{input.Upi}鐨勬暟鎹�");
+ }
+
+ var package = await _mesPackageGatherRep.AsQueryable().Where(x => x.PackageCode == singleUpi.PackageCode).FirstAsync();
+ if (package == null)
+ {
+ throw Oops.Oh($"娌℃湁鎵惧埌鍖呭彿{singleUpi.PackageCode}鐨勬眹鎬绘暟鎹�");
+ }
+
+ var upiList = await _mesBatchOrderUpiRep.AsQueryable().Where(x => x.PackageCode == singleUpi.PackageCode).ToListAsync();
+ upiList = upiList.OrderBy(x => x.Shelf).ToList();
+
+ return upiList;
+ }
+
+
+ /// <summary>
+ /// 鏍规嵁鏌愪釜Upi锛屾煡璇㈡澘浠舵暟鎹�
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpPost]
+ [ApiDescriptionSettings(Name = "QuerySingleUpiByUpi")]
+ [Description("WmsCommonnQuery/QuerySingleUpiByUpi")]
+ public async Task<List<Mes_BatchOrderUPI_New>> QuerySingleUpiByUpi(QueryUpiListByUpiInput input)
+ {
+ if (input == null || input.Upi == null)
+ {
+ throw Oops.Oh("鍙傛暟涓嶈兘涓虹┖");
+ }
+
+ var singleUpi = await _mesBatchOrderUpiRep.AsQueryable().Where(x => x.UPI == input.Upi).FirstAsync();
+ if (singleUpi == null)
+ {
+ throw Oops.Oh($"娌℃湁鎵惧埌閮ㄤ欢鏉＄爜{input.Upi}鐨勬暟鎹�");
+ }
+
+ List<Mes_BatchOrderUPI_New> upiList = new List<Mes_BatchOrderUPI_New>();
+ upiList.Add(singleUpi);
+ return upiList;
+ }
+
+
+
+ /// <summary>
+ /// 棣栭〉 鏈懆涓嬬嚎鐗╂枡淇℃伅
+ /// </summary>
+ /// <returns></returns>
+ [HttpGet]
+ [ApiDescriptionSettings(Name = "HomeOffOrderList")]
+ [Description("WmsCommonnQuery/HomeOffOrderList")]
+ public async Task<List<Home_Order_Info>> HomeOffOrderList()
+ {
+ List<Home_Order_Info> resultList = new List<Home_Order_Info>();
+ // 鑾峰彇褰撳墠鏃堕棿
+ DateTime currentDate = DateTime.Now;
+ // 璁＄畻涓�鍛ㄤ箣鍓嶇殑鏃堕棿
+ DateTime oneWeekAgo = currentDate.AddDays(-7);
+ // 鏌ヨ鏈�杩戜竴鍛ㄧ殑涓嬬嚎璁㈠崟鏁�
+ var orderCount = await _mesOrderGatherRep.AsQueryable().Where(x => x.UnlineTime >= oneWeekAgo && x.UnlineTime <= currentDate).CountAsync();
+ resultList.Add(new Home_Order_Info
+ {
+ Name = "鏈懆涓嬬嚎璁㈠崟鏁�",
+ Value = orderCount // 灏嗘煡璇㈠埌鐨勬暟閲忚祴鍊�
+ });
+ resultList.Add(new Home_Order_Info
+ {
+ Name = "涓嬬嚎鍖呮暟",
+ Value = 8
+ // Value = await _mesPackage_UnLine_RecordRep 鏌ヨ鏈�杩戜竴鍛ㄧ殑涓嬬嚎璁㈠崟鏁�
+ });
+ resultList.Add(new Home_Order_Info
+ {
+ Name = "涓嬬嚎鏉挎暟",
+ Value = 3 // 杩欓噷绀轰緥鍊间负3锛屽彲浠ユ牴鎹疄闄呴�昏緫璋冩暣
+ });
+ return resultList; // 缁撴灉
+ }
+
+
+
+ /// <summary>
+ /// 涓婁笅鏋舵帹绉诲浘
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpGet]
+ [ApiDescriptionSettings(Name = "HomeTytPage")]
+ [Description("WmsCommonnQuery/HomeTytPage")]
+ public async Task<List<WmsStockPassMapOutput>> HomeTytPage([FromQuery] WmsStockPassMapInput input)
+ {
+ List<WmsStockPassMapOutput> outputlist = new List<WmsStockPassMapOutput>();
+ DateTime currentDate = DateTime.Today;
+
+ //閫夋嫨涓�12鏃ョ殑鎯呭喌
+ if (input.DayOrWeekOrMonth == 1)
+ {
+ //鎬荤殑鏁版嵁
+ DateTime all_startDate = currentDate.AddDays(-11);
+ DateTime all_endDate = currentDate.Date.AddDays(1).AddTicks(-1);
+ var all_recordsOfDay = await _mesOrderGatherRep.AsQueryable()
+ .Where(r => r.CreateTime >= all_startDate && r.CreateTime <= all_endDate
+ //&& (r.OrderStatus == OrderStatusEnum.宸插畬鎴�)
+ //&& (r.OrderType == OrderTypeEnum.涓婃灦鍗� || r.OrderType == OrderTypeEnum.涓嬫灦鍗�)
+ ).ToListAsync();
+
+
+ for (int i = 0; i < 12; i++)
+ {
+ DateTime startDate = currentDate.AddDays(-i);
+ DateTime endDate = startDate.Date.AddDays(1).AddTicks(-1);
+
+ // 鏌ヨ鍦ㄨ繖涓�澶╁唴鐨勮褰�
+ var recordsOfDay = all_recordsOfDay.Where(r => r.CreateTime >= startDate && r.CreateTime <= endDate
+ ).ToList();
+
+
+ var summary = new WmsStockPassMapOutput
+ {
+ Time = 12 - i,
+ InWare = recordsOfDay
+ // .Where(x => x.OrderType == OrderTypeEnum.涓婃灦鍗�)
+ .ToList().Count(),
+ OutWare = recordsOfDay
+ // .Where(x => x.OrderType == OrderTypeEnum.涓嬫灦鍗�)
+ .ToList().Count(),
+ StockNum = 0,
+ AveStockNum = 0,
+ Date = startDate.Date.ToString("yyyy-MM-dd")
+ };
+
+ outputlist.Add(summary);
+ }
+ }
+ //閫夋嫨12鍛�
+ else if (input.DayOrWeekOrMonth == 2)
+ {
+ //鎬荤殑鏁版嵁
+ DateTime all_startDate = GetStartOfWeek(currentDate).AddDays(-7 * 11);
+ DateTime all_endDate = GetEndOfWeek(currentDate);
+ var all_recordsOfDay = await _mesOrderGatherRep.AsQueryable().Where(r => r.CreateTime >= all_startDate && r.CreateTime <= all_endDate
+ //&& (r.OrderStatus == OrderStatusEnum.宸插畬鎴�)
+ //&& (r.OrderType == OrderTypeEnum.涓婃灦鍗� || r.OrderType == OrderTypeEnum.涓嬫灦鍗�)
+ ).ToListAsync();
+
+ for (int i = 0; i < 12; i++)
+ {
+ // 璁＄畻褰撳墠鍛ㄧ殑璧峰鏃ユ湡
+ DateTime startDate = GetStartOfWeek(currentDate).AddDays(-7 * i);
+ DateTime endDate = GetEndOfWeek(startDate);
+
+ // 鏌ヨ鍦ㄨ繖涓�鍛ㄥ唴鐨勫嚭鍏ュ簱璁板綍
+ var recordsOfWeek = all_recordsOfDay.Where(r => r.CreateTime >= startDate && r.CreateTime <= endDate).ToList();
+
+ // 姹囨�诲嚭鍏ュ簱璁板綍
+ var summary = new WmsStockPassMapOutput
+ {
+ Time = 12 - i,
+ InWare = recordsOfWeek
+ // .Where(x => x.OrderType == OrderTypeEnum.涓婃灦鍗�) .Sum(x => x.Quantity),
+ .ToList().Count(),
+ OutWare = recordsOfWeek
+ // .Where(x => x.OrderType == OrderTypeEnum.涓嬫灦鍗�)
+ .ToList().Count(),
+ StockNum = 0,
+ AveStockNum = 0,
+ Date = startDate.Date.ToString("MMdd") + "锝�" + endDate.Date.ToString("MMdd")
+ };
+
+ outputlist.Add(summary);
+ }
+ }
+ //閫夋嫨12涓湀
+ else if (input.DayOrWeekOrMonth == 3)
+ {
+ //鎬荤殑鏁版嵁
+ DateTime all_startDate = currentDate.AddMonths(-11).AddDays(1 - currentDate.Day);
+ DateTime all_endDate = currentDate.AddMonths(1).AddDays(-1);
+ var all_recordsOfDay = await _mesOrderGatherRep.AsQueryable().Where(r => r.CreateTime >= all_startDate && r.CreateTime <= all_endDate
+ //&& (r.OrderStatus == OrderStatusEnum.宸插畬鎴�)
+ //&& (r.OrderType == OrderTypeEnum.涓婃灦鍗� || r.OrderType == OrderTypeEnum.涓嬫灦鍗�)
+ ).ToListAsync();
+
+ for (int i = 0; i < 12; i++)
+ {
+ DateTime startDate = currentDate.AddMonths(-i).AddDays(1 - currentDate.Day);
+ DateTime endDate = startDate.AddMonths(1).AddDays(-1);
+
+ // 鏌ヨ鍦ㄨ繖涓湀鍐呯殑鍑哄叆搴撹褰�
+ var recordsOfMonth = all_recordsOfDay.Where(r => r.CreateTime >= startDate && r.CreateTime <= endDate).ToList();
+
+ // 姹囨�诲嚭鍏ュ簱璁板綍
+ var summary = new WmsStockPassMapOutput
+ {
+ Time = 12 - i,
+ InWare = recordsOfMonth
+ //.Where(x => x.OrderType == OrderTypeEnum.涓婃灦鍗�)
+ .ToList().Count(),
+ OutWare = recordsOfMonth
+ // .Where(x => x.OrderType == OrderTypeEnum.涓嬫灦鍗�)
+ .ToList().Count(),
+ StockNum = 0,
+ AveStockNum = 0,
+ Date = startDate.ToString("yyyy-MM")
+ };
+
+ outputlist.Add(summary);
+ }
+ }
+
+ //鎺掑簭
+ outputlist = outputlist.OrderBy(x => x.Time).ToList();
+
+ return outputlist;
+ }
+ // 鑾峰彇褰撳墠鏃ユ湡鎵�鍦ㄥ懆鐨勮捣濮嬫棩鏈燂紙鍛ㄤ竴锛�
+ private DateTime GetStartOfWeek(DateTime currentDate)
+ {
+ int diff = currentDate.DayOfWeek - DayOfWeek.Monday;
+ if (diff < 0) diff += 7; // 澶勭悊鍛ㄦ棩鐨勬儏鍐�
+ return currentDate.AddDays(-1 * diff).Date;
+ }
+
+ // 鑾峰彇褰撳墠鏃ユ湡鎵�鍦ㄥ懆鐨勭粨鏉熸棩鏈燂紙鍛ㄦ棩锛�
+ private DateTime GetEndOfWeek(DateTime startDate)
+ {
+ return startDate.AddDays(6); // 鍥犱负璧峰鏃ユ湡宸茬粡鏄懆涓�锛屾墍浠ョ洿鎺ュ姞6澶╁嵆鍙緱鍒板懆鏃�
+ }
+
}
--
Gitblit v1.9.3