From 7281004dc3854ed59e9164dcd27a59c8c2cf6667 Mon Sep 17 00:00:00 2001
From: qinchulong <qinchulong@hnkhzn.com>
Date: 星期六, 12 十月 2024 15:16:55 +0800
Subject: [PATCH] 初始化
---
项目代码/WMS/WIDESEA_WMSServer/WIDESEA_StorageOutOrderRepository/OutboundOrder/Dt_OutOrderAndStockRepository.cs | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 53 insertions(+), 0 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_StorageOutOrderRepository/OutboundOrder/Dt_OutOrderAndStockRepository.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_StorageOutOrderRepository/OutboundOrder/Dt_OutOrderAndStockRepository.cs"
new file mode 100644
index 0000000..6a97088
--- /dev/null
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_StorageOutOrderRepository/OutboundOrder/Dt_OutOrderAndStockRepository.cs"
@@ -0,0 +1,53 @@
+锘縩amespace WIDESEA_StorageOutOrderRepository;
+
+public class Dt_OutOrderAndStockRepository : RepositoryBase<Dt_OutOrderAndStock>, IDt_OutOrderAndStockRepository
+{
+ public Dt_OutOrderAndStockRepository(IUnitOfWorkManage unitOfWorkManage) : base(unitOfWorkManage)
+ {
+ }
+
+ /// <summary>
+ /// 鏍规嵁鐗瑰畾鏉′欢鑾峰彇鍑哄簱鐗╂枡淇℃伅
+ /// </summary>
+ /// <param name="locationID">璐т綅ID</param>
+ /// <param name="orderNum">鍑哄簱璁㈠崟</param>
+ /// <param name="palletCode">鎵樼洏鍙�</param>
+ /// <returns>鍑哄簱鐗╂枡淇℃伅</returns>
+ public async Task<Dt_OutOrderAndStock> GetOrderAndStock(string locationID = null, string orderNum = null, string palletCode = null)
+ {
+ return await Db.Queryable<Dt_OutOrderAndStock>()
+ .Includes(x => x.OrderList)
+ .Includes(x => x.StockList)
+ .Includes(x => x.LocationList)
+ .WhereIF(locationID != null, x => x.LocationCode == locationID)
+ .WhereIF(orderNum != null, x => x.OrderNumber == orderNum)
+ .WhereIF(palletCode != null, x => x.PalletCode == palletCode)
+ .FirstAsync();
+ }
+
+ /// <summary>
+ /// 瀵艰埅鍒犻櫎
+ /// </summary>
+ /// <param name="stock">鍑哄簱鐗╂枡淇℃伅</param>
+ /// <returns>鎴愬姛/澶辫触</returns>
+ public bool DeleteNavOrderStock(Dt_OutOrderAndStock stock)
+ {
+ return Db.DeleteNav<Dt_OutOrderAndStock>(x => x.Id == stock.Id)
+ .Include(x => x.OrderList).ThenInclude(x => x.OrderDetailList)
+ .Include(x => x.StockList).ThenInclude(x => x.Dt_BillGroupStockDetailList)
+ .ExecuteCommand();
+ }
+
+ /// <summary>
+ /// 瀵艰埅鏇存柊
+ /// </summary>
+ /// <param name="stock">鍑哄簱鐗╂枡淇℃伅</param>
+ /// <returns>鎴愬姛/澶辫触</returns>
+ public bool UpdateNavOrderStock(Dt_OutOrderAndStock stock)
+ {
+ return Db.UpdateNav(stock)
+ .Include(x => x.OrderList)
+ .Include(x => x.StockList)
+ .ExecuteCommand();
+ }
+}
\ No newline at end of file
--
Gitblit v1.9.3