From e85e1603b2d1c013be767a393a27ff4f2b97be81 Mon Sep 17 00:00:00 2001
From: hwh <332078369@qq.com>
Date: 星期一, 05 八月 2024 16:59:44 +0800
Subject: [PATCH] pda优化异步

---
 Wms/Wms/Controllers/PdaSoController.cs  |  184 +-----------
 Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs |  589 ++++++++++++++++++++----------------------
 Wms/WMS.IBLL/IPdaServer/IPdaSoServer.cs |   16 
 3 files changed, 306 insertions(+), 483 deletions(-)

diff --git a/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs b/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs
index d3b7475..3ab3a17 100644
--- a/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs
+++ b/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs
@@ -2029,56 +2029,56 @@
         }
 
         //鍙栨牱鍑哄簱鎷ｈ揣(鏃犳爣绛�)
-        public void SampleSoSetQtyPick(string soType, string soNo, string soDetailId, string palletNo, string PickQty, string asnNo, int userId)
+        public async Task SampleSoSetQtyPick(string soType, string soNo, string soDetailId, string palletNo, string PickQty, string asnNo, int userId)
         {
             Db.BeginTran();
             try
             {
                 if (string.IsNullOrWhiteSpace(soType))
                 {
-                    throw new Exception("鍙栨牱鏍囪瘑涓嶈兘涓虹┖");
+                    throw Oops.Bah("鍙栨牱鏍囪瘑涓嶈兘涓虹┖");
                 }
 
                 if (soType == "1")
                 {
                     if (string.IsNullOrWhiteSpace(asnNo))
                     {
-                        throw new Exception("鍏ュ簱鍗曟嵁涓嶈兘涓虹┖");
+                        throw Oops.Bah("鍏ュ簱鍗曟嵁涓嶈兘涓虹┖");
                     }
                     if (string.IsNullOrWhiteSpace(palletNo))
                     {
-                        throw new Exception("鎵樼洏鐮佷笉鑳戒负绌�");
+                        throw Oops.Bah("鎵樼洏鐮佷笉鑳戒负绌�");
                     }
                     //鍏堝垽鏂槸鍚︽槸搴撳鍙栨牱鎵樼洏
-                    var allot = Db.Queryable<BllExportAllot>().First(m =>
+                    var allot = await Db.Queryable<BllExportAllot>().FirstAsync(m =>
                         m.IsDel == "0" && m.PalletNo == palletNo && m.Status != "5" && m.Status != "6");
                     if (allot != null)
                     {
-                        throw new Exception("褰撳墠鎵樼洏涓嶅睘浜庡簱鍓嶅彇鏍�");
+                        throw Oops.Bah("褰撳墠鎵樼洏涓嶅睘浜庡簱鍓嶅彇鏍�");
                     }
 
 
                     //搴撳瓨鏄庣粏
-                    var stockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.ASNNo == asnNo && m.PalletNo == palletNo);
+                    var stockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.ASNNo == asnNo && m.PalletNo == palletNo);
                     if (stockDetail == null)
                     {
-                        throw new Exception("鏈煡璇㈠埌璇ユ墭鐩樼殑搴撳瓨鏄庣粏淇℃伅锛�");
+                        throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樼殑搴撳瓨鏄庣粏淇℃伅锛�");
                     }
 
-                    var sku = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == stockDetail.SkuNo);
+                    var sku = await Db.Queryable<SysMaterials>().FirstAsync(m => m.IsDel == "0" && m.SkuNo == stockDetail.SkuNo);
                     if (sku == null)
                     {
-                        throw new Exception("鏈煡璇㈠埌褰撳墠鎵樼洏涓婄殑鐗╂枡淇℃伅");
+                        throw Oops.Bah("鏈煡璇㈠埌褰撳墠鎵樼洏涓婄殑鐗╂枡淇℃伅");
                     }
                     //搴撳瓨鎬昏〃
-                    var stock = Db.Queryable<DataStock>().First(a => a.IsDel == "0" && a.SkuNo == stockDetail.SkuNo && a.LotNo == stockDetail.LotNo);
+                    var stock = await Db.Queryable<DataStock>().FirstAsync(a => a.IsDel == "0" && a.SkuNo == stockDetail.SkuNo && a.LotNo == stockDetail.LotNo);
                     if (stock == null)
                     {
-                        throw new Exception("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨淇℃伅锛�");
+                        throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨淇℃伅锛�");
                     }
 
                     //鍑哄簱鍗�
-                    var notice = Db.Queryable<BllExportNotice>().First(m => m.IsDel == "0" && m.AsnSampleNo == asnNo);
+                    var notice = await Db.Queryable<BllExportNotice>().FirstAsync(m => m.IsDel == "0" && m.AsnSampleNo == asnNo);
                     //鍒涘缓鍑哄簱鍗�
                     if (notice == null || notice.Status == "6")
                     {
@@ -2089,7 +2089,7 @@
                             //鑾峰彇鑷鍗曟嵁鍙�
                             billNo = new Common().GetMaxNo("SO");
                             var no = billNo;
-                            bl = Db.Queryable<BllExportNotice>().Any(m => m.SONo == no);
+                            bl = await Db.Queryable<BllExportNotice>().AnyAsync(m => m.SONo == no);
                         } while (bl);
 
                         var addNotice = new BllExportNotice()
@@ -2106,12 +2106,12 @@
                             CreateUser = userId,
                         };
 
-                        var n = Db.Insertable(addNotice).ExecuteReturnEntity();
+                        var n = await Db.Insertable(addNotice).ExecuteReturnEntityAsync();
                         notice = n;
                     }
 
                     //鍒涘缓鍑哄簱鍗曟槑缁�
-                    var noticeDetail = Db.Queryable<BllExportNoticeDetail>().First(m => m.IsDel == "0" && m.SONo == notice.SONo && m.SkuNo == stockDetail.SkuNo && m.LotNo.Contains(stockDetail.LotNo));
+                    var noticeDetail = await Db.Queryable<BllExportNoticeDetail>().FirstAsync(m => m.IsDel == "0" && m.SONo == notice.SONo && m.SkuNo == stockDetail.SkuNo && m.LotNo.Contains(stockDetail.LotNo));
                     if (noticeDetail == null)
                     {
                         var addNoticeDetail = new BllExportNoticeDetail()
@@ -2139,11 +2139,11 @@
                             CreateUser = userId,
 
                         };
-                        var m = Db.Insertable(addNoticeDetail).ExecuteReturnEntity();
+                        var m = await Db.Insertable(addNoticeDetail).ExecuteReturnEntityAsync();
                         noticeDetail = m;
                     }
                     //鍑哄簱鍒嗛厤淇℃伅
-                    var allot2 = Db.Queryable<BllExportAllot>().First(m => m.IsDel == "0" && m.Status == "5" && m.SONo == notice.SONo && m.PalletNo == palletNo);
+                    var allot2 = await Db.Queryable<BllExportAllot>().FirstAsync(m => m.IsDel == "0" && m.Status == "5" && m.SONo == notice.SONo && m.PalletNo == palletNo);
                     if (allot2 == null)
                     {
                         //娣诲姞鍒嗛厤琛ㄤ俊鎭�
@@ -2175,12 +2175,12 @@
                             UpdateTime = DateTime.Now
                         };
 
-                        var fp = Db.Insertable(addAllot).ExecuteReturnEntity();
+                        var fp = await Db.Insertable(addAllot).ExecuteReturnEntityAsync();
                         allot2 = fp;
                     }
 
                     //鑾峰彇褰撳墠鎵樼洏鎷ｈ揣鏄庣粏
-                    var complete = Db.Queryable<BllCompleteDetail>().First(a => a.IsDel == "0" && a.PalletNo == palletNo && a.SONo == notice.SONo && a.ExportAllotId == allot2.Id && a.StockId == stockDetail.Id);
+                    var complete = await Db.Queryable<BllCompleteDetail>().FirstAsync(a => a.IsDel == "0" && a.PalletNo == palletNo && a.SONo == notice.SONo && a.ExportAllotId == allot2.Id && a.StockId == stockDetail.Id);
 
                     //鍒よ鏄惁瀛樺湪鎷ｈ揣鏄庣粏
                     int isComplete = 0;
@@ -2219,7 +2219,7 @@
                         comList.Add(completeDetail);
 
                         //娣诲姞鎷ｈ揣鏄庣粏
-                        Db.Insertable(comList).ExecuteCommand();
+                        await Db.Insertable(comList).ExecuteCommandAsync();
                     }
                     else if (isComplete == 1)
                     {
@@ -2227,7 +2227,7 @@
                         complete.UpdateUser = userId;
                         complete.UpdateTime = Db.GetDate();
 
-                        Db.Updateable(complete).ExecuteCommand();
+                        await Db.Updateable(complete).ExecuteCommandAsync();
                     }
 
 
@@ -2235,7 +2235,7 @@
                     //淇敼鍑哄簱鍒嗛厤淇℃伅
                     allot2.Qty += int.Parse(PickQty);
                     allot2.CompleteQty += int.Parse(PickQty);
-                    Db.Updateable(allot2).ExecuteCommand();
+                    await Db.Updateable(allot2).ExecuteCommandAsync();
 
                     int isDel = 0;
 
@@ -2257,36 +2257,36 @@
                     }
                     if (stockDetail.Qty <= 0)
                     {
-                        Db.Deleteable(stockDetail).ExecuteCommand();
+                        await Db.Deleteable(stockDetail).ExecuteCommandAsync();
                     }
                     else
                     {
                         isDel = 1;
-                        Db.Updateable(stockDetail).ExecuteCommand();
+                        await Db.Updateable(stockDetail).ExecuteCommandAsync();
                     }
                     //鍒犻櫎鎴栦慨鏀瑰簱瀛�
                     stock.Qty -= int.Parse(PickQty);
                     if (stock.Qty <= 0)
                     {
-                        Db.Deleteable(stock).ExecuteCommand();
+                        await Db.Deleteable(stock).ExecuteCommandAsync();
                     }
                     else
                     {
-                        Db.Updateable(stock).ExecuteCommand();
+                        await Db.Updateable(stock).ExecuteCommandAsync();
                     }
 
                     //鏀瑰彉鎵樼洏鐘舵�佷负锛氭湭浣跨敤
-                    var pallet = Db.Queryable<SysPallets>().First(m => m.PalletNo == palletNo && m.IsDel == "0");
+                    var pallet = await Db.Queryable<SysPallets>().FirstAsync(m => m.PalletNo == palletNo && m.IsDel == "0");
                     if (pallet == null)
                     {
-                        throw new Exception("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
+                        throw Oops.Bah("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
                     }
 
                     //鍒ゆ柇鎵樼洏涓婄墿鏂欐槸鍚︽嫞璐у畬姣�
                     if (isDel == 0)
                     {
                         pallet.Status = "0";
-                        Db.Updateable(pallet).ExecuteCommand();
+                        await Db.Updateable(pallet).ExecuteCommandAsync();
                     }
 
                     //淇敼鍑哄簱鍗曟槑缁嗘嫞璐ф暟閲�
@@ -2295,7 +2295,7 @@
                     noticeDetail.FactQty += int.Parse(PickQty);
                     noticeDetail.CompleteQty += int.Parse(PickQty);
                     noticeDetail.Money = string.IsNullOrWhiteSpace(sku.Price.ToString()) ? null : sku.Price * noticeDetail.Qty;
-                    Db.Updateable(noticeDetail).ExecuteCommand();
+                    await Db.Updateable(noticeDetail).ExecuteCommandAsync();
 
                 }
                 else if (soType == "0")
@@ -2304,7 +2304,7 @@
 
                     if (string.IsNullOrWhiteSpace(soNo))
                     {
-                        throw new Exception("鍑哄簱鍗曟嵁涓嶈兘涓虹┖");
+                        throw Oops.Bah("鍑哄簱鍗曟嵁涓嶈兘涓虹┖");
                     }
                     //if (string.IsNullOrWhiteSpace(soDetailId))
                     //{
@@ -2312,56 +2312,56 @@
                     //}
                     if (string.IsNullOrWhiteSpace(palletNo))
                     {
-                        throw new Exception("鎵樼洏鐮佷笉鑳戒负绌�");
+                        throw Oops.Bah("鎵樼洏鐮佷笉鑳戒负绌�");
                     }
 
                     //鍑哄簱鍗�
                     var notice = Db.Queryable<BllExportNotice>().First(m => m.IsDel == "0" && m.SONo == soNo);
                     if (notice == null)
                     {
-                        throw new Exception("鏈煡璇㈠埌璇ュ嚭搴撳崟鐨勪俊鎭�");
+                        throw Oops.Bah("鏈煡璇㈠埌璇ュ嚭搴撳崟鐨勪俊鎭�");
                     }
                     if (notice.Status != "3")
                     {
-                        throw new Exception("鍑哄簱鍗曠殑鐘舵�佷笉鏄鍦ㄦ墽琛岋紝涓嶈兘鎷ｈ揣");
+                        throw Oops.Bah("鍑哄簱鍗曠殑鐘舵�佷笉鏄鍦ㄦ墽琛岋紝涓嶈兘鎷ｈ揣");
                     }
                     //鍑哄簱鍗曟槑缁�
                     var noticeDetail = Db.Queryable<BllExportNoticeDetail>()
                         .First(m => m.IsDel == "0" && m.Id == int.Parse(soDetailId));
                     if (noticeDetail == null)
                     {
-                        throw new Exception("鏈煡璇㈠埌璇ュ嚭搴撳崟鏄庣粏鐨勪俊鎭�");
+                        throw Oops.Bah("鏈煡璇㈠埌璇ュ嚭搴撳崟鏄庣粏鐨勪俊鎭�");
                     }
                     //鍑哄簱鍒嗛厤淇℃伅
-                    var allot = Db.Queryable<BllExportAllot>().First(m =>
+                    var allot = await Db.Queryable<BllExportAllot>().FirstAsync(m =>
                         m.IsDel == "0" && (m.Status == "2" || m.Status == "3") && m.SONo == soNo &&
                         m.SODetailNo == int.Parse(soDetailId) && m.PalletNo == palletNo);
                     if (allot == null)
                     {
-                        throw new Exception("鏈煡璇㈠埌璇ユ墭鐩樼殑鍒嗛厤淇℃伅");
+                        throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樼殑鍒嗛厤淇℃伅");
                     }
                     //鍓╀綑鎷ｈ揣鏁伴噺锛堝緟鎷ｅ噺鍘诲凡鎷ｏ級
                     var needQty = allot.Qty - allot.CompleteQty;
                     if (int.Parse(PickQty) > needQty)
                     {
-                        throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘澶т簬鎵樺唴鍓╀綑寰呮嫞鏁伴噺");
+                        throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘澶т簬鎵樺唴鍓╀綑寰呮嫞鏁伴噺");
                     }
 
                     //搴撳瓨鏄庣粏
-                    var stockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.Id == allot.StockId);
+                    var stockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.Id == allot.StockId);
                     if (stockDetail == null)
                     {
-                        throw new Exception("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨鏄庣粏淇℃伅锛�");
+                        throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨鏄庣粏淇℃伅锛�");
                     }
                     //搴撳瓨鎬昏〃
-                    var stock = Db.Queryable<DataStock>().First(a => a.IsDel == "0" && a.SkuNo == stockDetail.SkuNo && a.LotNo == stockDetail.LotNo);
+                    var stock = await Db.Queryable<DataStock>().FirstAsync(a => a.IsDel == "0" && a.SkuNo == stockDetail.SkuNo && a.LotNo == stockDetail.LotNo);
                     if (stock == null)
                     {
-                        throw new Exception("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨淇℃伅锛�");
+                        throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨淇℃伅锛�");
                     }
                     #endregion
                     //鑾峰彇褰撳墠鎵樼洏鎷ｈ揣鏄庣粏
-                    var complete = Db.Queryable<BllCompleteDetail>().First(a => a.IsDel == "0" && a.PalletNo == palletNo && a.SONo == notice.SONo && a.SODetailNo == noticeDetail.Id && a.ExportAllotId == allot.Id && a.StockId == stockDetail.Id);
+                    var complete = await Db.Queryable<BllCompleteDetail>().FirstAsync(a => a.IsDel == "0" && a.PalletNo == palletNo && a.SONo == notice.SONo && a.SODetailNo == noticeDetail.Id && a.ExportAllotId == allot.Id && a.StockId == stockDetail.Id);
 
                     //鍒よ鏄惁瀛樺湪鎷ｈ揣鏄庣粏
                     int isComplete = 0;
@@ -2400,7 +2400,7 @@
                         comList.Add(completeDetail);
 
                         //娣诲姞鎷ｈ揣鏄庣粏
-                        Db.Insertable(comList).ExecuteCommand();
+                        await Db.Insertable(comList).ExecuteCommandAsync();
                     }
                     else if (isComplete == 1)
                     {
@@ -2408,7 +2408,7 @@
                         complete.UpdateUser = userId;
                         complete.UpdateTime = Db.GetDate();
 
-                        Db.Updateable(complete).ExecuteCommand();
+                        await Db.Updateable(complete).ExecuteCommandAsync();
                     }
 
 
@@ -2418,7 +2418,7 @@
                     allot.Status = allot.Qty == allot.CompleteQty ? "5" : "3";
 
                     allot.UpdateTime = DateTime.Now;
-                    Db.Updateable(allot).ExecuteCommand();
+                    await Db.Updateable(allot).ExecuteCommandAsync();
 
                     int isDel = 0;
 
@@ -2441,12 +2441,12 @@
                     }
                     if (stockDetail.Qty <= 0)
                     {
-                        Db.Deleteable(stockDetail).ExecuteCommand();
+                        await Db.Deleteable(stockDetail).ExecuteCommandAsync();
                     }
                     else
                     {
                         isDel = 1;
-                        Db.Updateable(stockDetail).ExecuteCommand();
+                        await Db.Updateable(stockDetail).ExecuteCommandAsync();
                     }
                     //鍒犻櫎鎴栦慨鏀瑰簱瀛�
                     stock.Qty -= int.Parse(PickQty);
@@ -2454,39 +2454,39 @@
                     stock.IsSampling = "1"; //鏄惁鍙栨牱
                     if (stock.Qty <= 0)
                     {
-                        Db.Deleteable(stock).ExecuteCommand();
+                        await Db.Deleteable(stock).ExecuteCommandAsync();
                     }
                     else
                     {
-                        Db.Updateable(stock).ExecuteCommand();
+                        await Db.Updateable(stock).ExecuteCommandAsync();
                     }
 
                     //鏀瑰彉鎵樼洏鐘舵�佷负锛氭湭浣跨敤
-                    var pallet = Db.Queryable<SysPallets>().First(m => m.PalletNo == palletNo && m.IsDel == "0");
+                    var pallet = await Db.Queryable<SysPallets>().FirstAsync(m => m.PalletNo == palletNo && m.IsDel == "0");
                     if (pallet == null)
                     {
-                        throw new Exception("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
+                        throw Oops.Bah("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
                     }
 
                     //鍒ゆ柇鎵樼洏涓婄墿鏂欐槸鍚︽嫞璐у畬姣�
                     if (isDel == 0)
                     {
                         pallet.Status = "0";
-                        Db.Updateable(pallet).ExecuteCommand();
+                        await Db.Updateable(pallet).ExecuteCommandAsync();
                     }
 
                     //淇敼鍑哄簱鍗曟槑缁嗘嫞璐ф暟閲�
                     noticeDetail.CompleteQty += int.Parse(PickQty);
-                    Db.Updateable(noticeDetail).ExecuteCommand();
+                    await Db.Updateable(noticeDetail).ExecuteCommandAsync();
 
-                    var num = Db.Queryable<BllExportNoticeDetail>()
-                        .Count(m => m.IsDel == "0" && m.SONo == soNo && m.CompleteQty < m.Qty);
+                    var num = await Db.Queryable<BllExportNoticeDetail>()
+                        .CountAsync(m => m.IsDel == "0" && m.SONo == soNo && m.CompleteQty < m.Qty);
                     if (num <= 0)
                     {
                         notice.Status = "4"; //鏇存敼涓烘墽琛屽畬鎴�
                     }
                     //淇敼鍑哄簱鍗曚俊鎭�
-                    Db.Updateable(notice).ExecuteCommand();
+                    await Db.Updateable(notice).ExecuteCommandAsync();
 
                 }
 
@@ -2497,7 +2497,6 @@
             catch (Exception e)
             {
                 Db.RollbackTran();
-                throw new Exception(e.Message);
             }
         }
 
@@ -2513,7 +2512,7 @@
         /// <param name="pickQty1"></param>
         /// <param name="palletNoNew"></param>
         /// <param name="userId"></param>
-        public void SoSetPinPick(string soNo, string soDetailId, string palletNo, string boxNo, string boxNo3, string pickQty1, string palletNoNew, int userId)
+        public async Task SoSetPinPick(string soNo, string soDetailId, string palletNo, string boxNo, string boxNo3, string pickQty1, string palletNoNew, int userId)
         {
             Db.BeginTran();
             try
@@ -2523,71 +2522,71 @@
 
                 if (string.IsNullOrWhiteSpace(soNo))
                 {
-                    throw new Exception("鍑哄簱鍗曟嵁涓嶈兘涓虹┖");
+                    throw Oops.Bah("鍑哄簱鍗曟嵁涓嶈兘涓虹┖");
                 }
                 if (string.IsNullOrWhiteSpace(soDetailId))
                 {
-                    throw new Exception("鍑哄簱鐗╂枡-鎵规涓嶈兘涓虹┖");
+                    throw Oops.Bah("鍑哄簱鐗╂枡-鎵规涓嶈兘涓虹┖");
                 }
                 if (string.IsNullOrWhiteSpace(palletNo))
                 {
-                    throw new Exception("鎵樼洏鐮佷笉鑳戒负绌�");
+                    throw Oops.Bah("鎵樼洏鐮佷笉鑳戒负绌�");
                 }
                 if (!string.IsNullOrEmpty(boxNo3) && !string.IsNullOrEmpty(pickQty1) && int.Parse(pickQty1) > 0)
                 {
-                    throw new Exception("杩芥函鏉＄爜鍜屾嫞璐ф暟閲忎笉鑳藉悓鏃惰緭鍏�");
+                    throw Oops.Bah("杩芥函鏉＄爜鍜屾嫞璐ф暟閲忎笉鑳藉悓鏃惰緭鍏�");
                 }
                 if (string.IsNullOrWhiteSpace(palletNoNew))
                 {
-                    throw new Exception("鏂版墭鐩樼爜涓嶈兘涓虹┖");
+                    throw Oops.Bah("鏂版墭鐩樼爜涓嶈兘涓虹┖");
                 }
                 if (palletNo == palletNoNew)//鍘熸墭鐩樹笌鏂版墭鐩樹竴鑷�
                 {
                     if (!string.IsNullOrEmpty(boxNo))
                     {
-                        throw new Exception("鍘熸墭鐩樹笌鏂版墭鐩樹竴鑷达紝璇烽�夋嫨鏁存墭鍑哄簱");
+                        throw Oops.Bah("鍘熸墭鐩樹笌鏂版墭鐩樹竴鑷达紝璇烽�夋嫨鏁存墭鍑哄簱");
                     }
                 }
 
                 //鍑哄簱鍗�
-                var notice = Db.Queryable<BllExportNotice>().First(m => m.IsDel == "0" && m.SONo == soNo);
+                var notice = await Db.Queryable<BllExportNotice>().FirstAsync(m => m.IsDel == "0" && m.SONo == soNo);
                 if (notice == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇ュ嚭搴撳崟鐨勪俊鎭�");
+                    throw Oops.Bah("鏈煡璇㈠埌璇ュ嚭搴撳崟鐨勪俊鎭�");
                 }
                 if (notice.Status != "3")
                 {
-                    throw new Exception("鍑哄簱鍗曠殑鐘舵�佷笉鏄鍦ㄦ墽琛岋紝涓嶈兘鎷ｈ揣");
+                    throw Oops.Bah("鍑哄簱鍗曠殑鐘舵�佷笉鏄鍦ㄦ墽琛岋紝涓嶈兘鎷ｈ揣");
                 }
                 //鍑哄簱鍗曟槑缁�
-                var noticeDetail = Db.Queryable<BllExportNoticeDetail>()
-                    .First(m => m.IsDel == "0" && m.Id == int.Parse(soDetailId));
+                var noticeDetail = await Db.Queryable<BllExportNoticeDetail>()
+                    .FirstAsync(m => m.IsDel == "0" && m.Id == int.Parse(soDetailId));
                 if (noticeDetail == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇ュ嚭搴撳崟鏄庣粏鐨勪俊鎭�");
+                    throw Oops.Bah("鏈煡璇㈠埌璇ュ嚭搴撳崟鏄庣粏鐨勪俊鎭�");
                 }
                 //鍑哄簱鍒嗛厤淇℃伅
-                var allot = Db.Queryable<BllExportAllot>().First(m =>
+                var allot = await Db.Queryable<BllExportAllot>().FirstAsync(m =>
                     m.IsDel == "0" && (m.Status == "2" || m.Status == "3") && m.SONo == soNo &&
                     m.SODetailNo == int.Parse(soDetailId) && m.PalletNo == palletNo);
                 if (allot == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇ユ墭鐩樼殑鍒嗛厤淇℃伅");
+                    throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樼殑鍒嗛厤淇℃伅");
                 }
                 //鍓╀綑鎷ｈ揣鏁伴噺锛堝緟鎷ｅ噺鍘诲凡鎷ｏ級
                 var needQty = allot.Qty - allot.CompleteQty;
 
                 //搴撳瓨鏄庣粏
-                var stockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.Id == allot.StockId);
+                var stockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.Id == allot.StockId);
                 if (stockDetail == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨鏄庣粏淇℃伅锛�");
+                    throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨鏄庣粏淇℃伅锛�");
                 }
                 //搴撳瓨鎬昏〃
-                var stock = Db.Queryable<DataStock>().First(a => a.IsDel == "0" && a.SkuNo == stockDetail.SkuNo && a.LotNo == stockDetail.LotNo);
+                var stock = await Db.Queryable<DataStock>().FirstAsync(a => a.IsDel == "0" && a.SkuNo == stockDetail.SkuNo && a.LotNo == stockDetail.LotNo);
                 if (stock == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨淇℃伅锛�");
+                    throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨淇℃伅锛�");
                 }
 
                 #endregion
@@ -2595,14 +2594,14 @@
                 #region 鎷兼墭淇℃伅
                 var sdId = 0;
                 bool isNew = false;
-                var pinStockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.PalletNo == palletNoNew);
+                var pinStockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew);
                 if (pinStockDetail != null)
                 {
                     if (palletNo != palletNoNew)//闈炴暣鎵樻嫞璐�
                     {
                         if (pinStockDetail.SONo != notice.SONo)
                         {
-                            throw new Exception("鎷兼墭鎵樼洏涓婂彧鑳芥斁鍚屼竴涓嚭搴撳崟涓嬬殑鐗╂枡锛�");
+                            throw Oops.Bah("鎷兼墭鎵樼洏涓婂彧鑳芥斁鍚屼竴涓嚭搴撳崟涓嬬殑鐗╂枡锛�");
                         }
                         if (pinStockDetail.SkuName != stockDetail.SkuName || pinStockDetail.LotNo != stockDetail.LotNo)
                         {
@@ -2615,14 +2614,14 @@
                 {
                     isNew = true;
 
-                    var newPalletInfo = Db.Queryable<SysPallets>().First(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Status == "0");
+                    var newPalletInfo = await Db.Queryable<SysPallets>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Status == "0");
                     if (newPalletInfo == null)
                     {
-                        throw new Exception("鏂版墭鐩樹俊鎭笉瀛樺湪鎴栧凡琚娇鐢紒");
+                        throw Oops.Bah("鏂版墭鐩樹俊鎭笉瀛樺湪鎴栧凡琚娇鐢紒");
                     }
                     //淇敼鏂版墭鐩樼姸鎬�
                     newPalletInfo.Status = "1";
-                    Db.Updateable(newPalletInfo).ExecuteCommand();
+                    await Db.Updateable(newPalletInfo).ExecuteCommandAsync();
                 }
                 var sd = new DataStockDetail();
                 if (isNew)
@@ -2668,7 +2667,7 @@
                     sd.CreateTime = nowDate;
 
                     //鏂板鎷兼墭搴撳瓨鏄庣粏淇℃伅
-                    sdId = Db.Insertable(sd).ExecuteReturnIdentity();
+                    sdId = await Db.Insertable(sd).ExecuteReturnIdentityAsync();
                 }
                 #endregion
 
@@ -2677,28 +2676,28 @@
                 {
                     List<DataBoxInfo> boxInfos;
                     var boxInfo = Db.Queryable<DataBoxInfo>().Where(m => m.IsDel == "0" && m.PalletNo == palletNo);//鎵惧埌鎵樼洏涓婃墍鏈夌鐮�
-                    boxInfos = boxInfo.ToList();
+                    boxInfos = await boxInfo.ToListAsync();
                     if (boxInfo.Count() <= 0)
                     {
-                        throw new Exception("璇ユ墭鐩樹笂娌℃湁鍙嫞璐х殑绠卞瓙");
+                        throw Oops.Bah("璇ユ墭鐩樹笂娌℃湁鍙嫞璐х殑绠卞瓙");
                     }
-                    var boxQty = boxInfo.GroupBy(m => m.PalletNo).Select(m => SqlFunc.AggregateSum(m.Qty)).ToList();
+                    var boxQty = await boxInfo.GroupBy(m => m.PalletNo).Select(m => SqlFunc.AggregateSum(m.Qty)).ToListAsync();
                     if (boxQty[0] > needQty)
                     {
-                        throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鍓╀綑寰呮嫞鏁伴噺");
+                        throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鍓╀綑寰呮嫞鏁伴噺");
                     }
 
-                    var comDetailList = Db.Queryable<BllCompleteDetail>().Where(m => m.IsDel == "0" && m.ExportAllotId == allot.Id && m.PalletNo == palletNo).ToList();
+                    var comDetailList = await Db.Queryable<BllCompleteDetail>().Where(m => m.IsDel == "0" && m.ExportAllotId == allot.Id && m.PalletNo == palletNo).ToListAsync();
                     var comList = new List<BllCompleteDetail>();
                     foreach (var item in boxInfos)
                     {
                         if (comDetailList.Any(m => m.BoxNo3 == item.BoxNo3))
                         {
-                            throw new Exception($"褰撳墠{item.BoxNo}涓瓄item.BoxNo3}宸叉嫞璐у畬鎴愶紝璇峰嬁閲嶅鎷ｈ揣");
+                            throw Oops.Bah($"褰撳墠{item.BoxNo}涓瓄item.BoxNo3}宸叉嫞璐у畬鎴愶紝璇峰嬁閲嶅鎷ｈ揣");
                         }
                         if (item.SkuNo != allot.SkuNo || item.LotNo != allot.LotNo)
                         {
-                            throw new Exception("褰撳墠鎵樼洏涓婃湁鍏朵粬涓嶅悓鐗╂枡鎵规锛屾嫞璐уけ璐�");
+                            throw Oops.Bah("褰撳墠鎵樼洏涓婃湁鍏朵粬涓嶅悓鐗╂枡鎵规锛屾嫞璐уけ璐�");
                         }
                         //娣诲姞鎷ｈ揣鏄庣粏
                         var completeDetail = new BllCompleteDetail()
@@ -2732,41 +2731,41 @@
                         }
                         item.Status = "5";//绠辨敮鐘舵�侊紝0锛氭湭缁勬墭  1锛氬凡缁勬墭 2锛氬凡鍏ュ簱 3锛氬凡鍑哄簱 4:宸插垎閰� 5锛氬凡鎷ｈ揣
                         //淇敼搴撳瓨绠辩爜鏄庣粏
-                        Db.Updateable(item).ExecuteCommand();
+                        await Db.Updateable(item).ExecuteCommandAsync();
 
                         pickQty += item.Qty;
                     }
                     //娣诲姞鎷ｈ揣鏄庣粏
-                    Db.Insertable(comList).ExecuteCommand();
+                    await Db.Insertable(comList).ExecuteCommandAsync();
                     //淇敼鍑哄簱鍒嗛厤淇℃伅
                     allot.CompleteQty += pickQty;
                     allot.Status = allot.Qty == allot.CompleteQty ? "5" : "3";
                     allot.UpdateTime = DateTime.Now;
-                    Db.Updateable(allot).ExecuteCommand();
+                    await Db.Updateable(allot).ExecuteCommandAsync();
 
                     if (palletNo != palletNoNew)
                     {
                         //鍒犻櫎鍘熸墭鐩樺簱瀛樻槑缁�
-                        Db.Deleteable(stockDetail).ExecuteCommand();
+                        await Db.Deleteable(stockDetail).ExecuteCommandAsync();
 
                         //鏀瑰彉鍘熸墭鐩樼姸鎬佷负锛氭湭浣跨敤
-                        var pallet = Db.Queryable<SysPallets>().First(m => m.PalletNo == palletNo && m.IsDel == "0");
+                        var pallet = await Db.Queryable<SysPallets>().FirstAsync(m => m.PalletNo == palletNo && m.IsDel == "0");
                         if (pallet == null)
                         {
-                            throw new Exception("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
+                            throw Oops.Bah("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
                         }
                         pallet.Status = "0";
-                        Db.Updateable(pallet).ExecuteCommand();
+                        await Db.Updateable(pallet).ExecuteCommandAsync();
                     }
                     else
                     {
                         stockDetail.SONo = soNo;
-                        Db.Updateable(stockDetail).ExecuteCommand();
+                        await Db.Updateable(stockDetail).ExecuteCommandAsync();
                     }
 
                     //淇敼鍑哄簱鍗曟槑缁嗘嫞璐ф暟閲�
                     noticeDetail.CompleteQty += pickQty;
-                    Db.Updateable(noticeDetail).ExecuteCommand();
+                    await Db.Updateable(noticeDetail).ExecuteCommandAsync();
 
                     var num = Db.Queryable<BllExportNoticeDetail>()
                         .Count(m => m.IsDel == "0" && m.SONo == soNo && m.CompleteQty < m.Qty);
@@ -2775,48 +2774,48 @@
                         notice.Status = "4"; //鏇存敼涓烘墽琛屽畬鎴�
                     }
                     //淇敼鍑哄簱鍗曚俊鎭�
-                    Db.Updateable(notice).ExecuteCommand();
+                    await Db.Updateable(notice).ExecuteCommandAsync();
                 }
                 else
                 {
                     var biaoShi = "0";//0锛氭暣绠辨嫞璐с��1锛氭暎鏀嫞璐с��2锛氭暟閲忔嫞璐�
                     List<DataBoxInfo> boxInfos;
                     var boxInfo = Db.Queryable<DataBoxInfo>().Where(m => m.IsDel == "0" && m.BoxNo == boxNo);
-                    if (boxInfo.Count() == 0)
+                    if (await boxInfo.CountAsync() == 0)
                     {
-                        throw new Exception("鏈煡璇㈠埌璇ョ鐮佸強杩芥函鐮佺殑淇℃伅");
+                        throw Oops.Bah("鏈煡璇㈠埌璇ョ鐮佸強杩芥函鐮佺殑淇℃伅");
                     }
-                    boxInfos = boxInfo.ToList();
+                    boxInfos = await boxInfo.ToListAsync();
 
-                    var comDetailList = Db.Queryable<BllCompleteDetail>().Where(m => m.IsDel == "0" && m.ExportAllotId == allot.Id && m.PalletNo == palletNo).ToList();
+                    var comDetailList = await Db.Queryable<BllCompleteDetail>().Where(m => m.IsDel == "0" && m.ExportAllotId == allot.Id && m.PalletNo == palletNo).ToListAsync();
                     if (!string.IsNullOrWhiteSpace(boxNo3)) //鏁ｆ敮鎷ｈ揣
                     {
                         boxInfos = boxInfos.Where(m => m.BoxNo3 == boxNo3).ToList();
 
                         if (boxInfos.Count() == 0)
                         {
-                            throw new Exception("鏈煡璇㈠埌璇ョ鐮佸強杩芥函鐮佺殑淇℃伅");
+                            throw Oops.Bah("鏈煡璇㈠埌璇ョ鐮佸強杩芥函鐮佺殑淇℃伅");
                         }
                         if (boxInfos.Count() > 1)
                         {
-                            throw new Exception("璇ヨ拷婧敮鐮佺殑淇℃伅澶т簬1鏉★紝淇℃伅閿欒锛岃鏍稿疄锛�");
+                            throw Oops.Bah("璇ヨ拷婧敮鐮佺殑淇℃伅澶т簬1鏉★紝淇℃伅閿欒锛岃鏍稿疄锛�");
                         }
 
                         if (boxInfos.Any(m => m.PalletNo != palletNo))
                         {
-                            throw new Exception("璇ユ墭鐩樹笌绠辩爜娌℃湁缁戝畾鍏崇郴");
+                            throw Oops.Bah("璇ユ墭鐩樹笌绠辩爜娌℃湁缁戝畾鍏崇郴");
                         }
                         var boxQty = boxInfos.First().Qty;
                         if (boxQty > needQty)
                         {
-                            throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘澶т簬鍓╀綑寰呮嫞鏁伴噺");
+                            throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘澶т簬鍓╀綑寰呮嫞鏁伴噺");
                         }
 
                         foreach (var item in boxInfos)
                         {
                             if (biaoShi != "2" && comDetailList.Any(m => m.BoxNo3 == item.BoxNo3))
                             {
-                                throw new Exception($"褰撳墠{item.BoxNo}涓瓄item.BoxNo3}宸叉嫞璐у畬鎴愶紝璇峰嬁閲嶅鎷ｈ揣");
+                                throw Oops.Bah($"褰撳墠{item.BoxNo}涓瓄item.BoxNo3}宸叉嫞璐у畬鎴愶紝璇峰嬁閲嶅鎷ｈ揣");
                             }
                         }
 
@@ -2826,16 +2825,16 @@
                     {
                         if (boxInfo.Count() > 1)
                         {
-                            throw new Exception("璇ョ鐮佸唴瀛樺湪鏀爜涓嶈兘杩涜鏁伴噺鎷ｈ揣");
+                            throw Oops.Bah("璇ョ鐮佸唴瀛樺湪鏀爜涓嶈兘杩涜鏁伴噺鎷ｈ揣");
                         }
                         decimal boxQty = boxInfo.First().Qty;
                         if (Convert.ToInt32(pickQty1) > boxQty)
                         {
-                            throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鏁伴噺");
+                            throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鏁伴噺");
                         }
                         if (Convert.ToInt32(pickQty1) > needQty)
                         {
-                            throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘澶т簬鍓╀綑寰呮嫞鏁伴噺");
+                            throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘澶т簬鍓╀綑寰呮嫞鏁伴噺");
                         }
 
                         biaoShi = "2";
@@ -2844,23 +2843,23 @@
                     {
                         if (boxInfo.Count() == 0)
                         {
-                            throw new Exception("鏈煡璇㈠埌璇ョ鐮佺殑淇℃伅");
+                            throw Oops.Bah("鏈煡璇㈠埌璇ョ鐮佺殑淇℃伅");
                         }
                         if (boxInfo.Any(m => m.PalletNo != palletNo))
                         {
-                            throw new Exception("璇ユ墭鐩樹笌绠辩爜娌℃湁缁戝畾鍏崇郴");
+                            throw Oops.Bah("璇ユ墭鐩樹笌绠辩爜娌℃湁缁戝畾鍏崇郴");
                         }
-                        var boxQty = boxInfo.GroupBy(m => m.BoxNo).Select(m => SqlFunc.AggregateSum(m.Qty)).ToList();
+                        var boxQty = await boxInfo.GroupBy(m => m.BoxNo).Select(m => SqlFunc.AggregateSum(m.Qty)).ToListAsync();
                         if (boxQty[0] > needQty)
                         {
-                            throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鍓╀綑寰呮嫞鏁伴噺");
+                            throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鍓╀綑寰呮嫞鏁伴噺");
                         }
 
                         foreach (var item in boxInfos)
                         {
                             if (biaoShi != "2" && comDetailList.Any(m => m.BoxNo == item.BoxNo))
                             {
-                                throw new Exception($"褰撳墠{item.BoxNo}宸叉嫞璐у畬鎴愶紝璇峰嬁閲嶅鎷ｈ揣");
+                                throw Oops.Bah($"褰撳墠{item.BoxNo}宸叉嫞璐у畬鎴愶紝璇峰嬁閲嶅鎷ｈ揣");
                             }
                         }
                     }
@@ -2899,7 +2898,7 @@
                             item.BindNo = null;//鎵樼洏缁戝畾鍙�
                             item.PalletNo = palletNoNew;
                             item.Status = "5";//绠辨敮鐘舵�侊紝0锛氭湭缁勬墭  1锛氬凡缁勬墭 2锛氬凡鍏ュ簱 3锛氬凡鍑哄簱 4:宸插垎閰� 5锛氬凡鎷ｈ揣
-                            Db.Updateable(item).ExecuteCommand();
+                            await Db.Updateable(item).ExecuteCommandAsync();
 
                             pickQty += item.Qty;
                         }
@@ -2912,7 +2911,7 @@
                             item.BoxNo = item.BoxNo3;//灏嗘敮鐮佽祴缁欑鐮�
                             item.BitBoxMark = "1";//闆剁鏍囪
                             item.Status = "5";//绠辨敮鐘舵�侊紝0锛氭湭缁勬墭  1锛氬凡缁勬墭 2锛氬凡鍏ュ簱 3锛氬凡鍑哄簱 4:宸插垎閰� 5锛氬凡鎷ｈ揣
-                            Db.Updateable(item).ExecuteCommand();
+                            await Db.Updateable(item).ExecuteCommandAsync();
 
                             pickQty += item.Qty;
                         }
@@ -2925,13 +2924,13 @@
                                 item.BindNo = null;//鎵樼洏缁戝畾鍙�
                                 item.PalletNo = palletNoNew;
                                 item.Status = "5";//绠辨敮鐘舵�侊紝0锛氭湭缁勬墭  1锛氬凡缁勬墭 2锛氬凡鍏ュ簱 3锛氬凡鍑哄簱 4:宸插垎閰� 5锛氬凡鎷ｈ揣
-                                Db.Updateable(item).ExecuteCommand();
+                                await Db.Updateable(item).ExecuteCommandAsync();
                             }
                             else
                             {
                                 item.Qty -= decimal.Parse(pickQty1);
                                 item.BitBoxMark = "1";//闆剁鏍囪瘑
-                                Db.Updateable(item).ExecuteCommand();
+                                await Db.Updateable(item).ExecuteCommandAsync();
                             }
 
                             pickQty += int.Parse(pickQty1);
@@ -2944,11 +2943,11 @@
                         foreach (var item in boxSurplusList)
                         {
                             item.BitBoxMark = "1";
-                            Db.Updateable(item).ExecuteCommand();
+                            await Db.Updateable(item).ExecuteCommandAsync();
                         }
                     }
 
-                    Db.Insertable(comList).ExecuteCommand();
+                    await Db.Insertable(comList).ExecuteCommandAsync();
                     //淇敼鍑哄簱鍒嗛厤淇℃伅
                     allot.CompleteQty += pickQty;
                     allot.Status = allot.Qty == allot.CompleteQty ? "5" : "3";
@@ -2957,7 +2956,7 @@
                     {
                         //鍒ゆ柇璇ユ墭鐩樻槸鍚﹁繕瀛樺湪鐗╂枡 瀛樺湪鏀逛负寰呭洖搴� 寰呭洖搴撳畬鎴愬悗鏀逛负宸插畬鎴�
                     }
-                    Db.Updateable(allot).ExecuteCommand();
+                    await Db.Updateable(allot).ExecuteCommandAsync();
 
                     //鍒犻櫎鎴栦慨鏀瑰簱瀛樻槑缁�
                     stockDetail.BitPalletMark = "1";//淇敼涓洪浂鎵樻爣璇�
@@ -2978,36 +2977,36 @@
 
                     if (stockDetail.Qty <= 0)
                     {
-                        Db.Deleteable(stockDetail).ExecuteCommand();
+                        await Db.Deleteable(stockDetail).ExecuteCommandAsync();
                     }
                     else
                     {
-                        Db.Updateable(stockDetail).ExecuteCommand();
+                        await Db.Updateable(stockDetail).ExecuteCommandAsync();
                     }
-                    var num2 = Db.Queryable<DataStockDetail>().Count(m => m.IsDel == "0" && m.PalletNo == palletNo);
+                    var num2 = await Db.Queryable<DataStockDetail>().CountAsync(m => m.IsDel == "0" && m.PalletNo == palletNo);
                     if (num2 <= 0)
                     {
                         //鏀瑰彉鎵樼洏鐘舵��
-                        var pallet = Db.Queryable<SysPallets>().First(m => m.PalletNo == palletNo && m.IsDel == "0");
+                        var pallet = await Db.Queryable<SysPallets>().FirstAsync(m => m.PalletNo == palletNo && m.IsDel == "0");
                         if (pallet == null)
                         {
-                            throw new Exception("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
+                            throw Oops.Bah("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
                         }
                         pallet.Status = "0";
-                        Db.Updateable(pallet).ExecuteCommand();
+                        await Db.Updateable(pallet).ExecuteCommandAsync();
                     }
                     //淇敼鍑哄簱鍗曟槑缁嗘嫞璐ф暟閲�
                     noticeDetail.CompleteQty += pickQty;
-                    Db.Updateable(noticeDetail).ExecuteCommand();
+                    await Db.Updateable(noticeDetail).ExecuteCommandAsync();
 
-                    var num = Db.Queryable<BllExportNoticeDetail>()
-                        .Count(m => m.IsDel == "0" && m.SONo == soNo && m.CompleteQty < m.Qty);
+                    var num = await Db.Queryable<BllExportNoticeDetail>()
+                        .CountAsync(m => m.IsDel == "0" && m.SONo == soNo && m.CompleteQty < m.Qty);
                     if (num <= 0)
                     {
                         notice.Status = "4"; //鏇存敼涓烘墽琛屽畬鎴�
                     }
                     //淇敼鍑哄簱鍗曚俊鎭�
-                    Db.Updateable(notice).ExecuteCommand();
+                    await Db.Updateable(notice).ExecuteCommandAsync();
                 }
 
                 if (isNew)
@@ -3022,7 +3021,7 @@
                         //淇敼鎷兼墭鎵樼洏搴撳瓨鏄庣粏
                         pinStockDetail.Qty += pickQty;
                         pinStockDetail.LockQty += pickQty;
-                        Db.Updateable(pinStockDetail).ExecuteCommand();
+                        await Db.Updateable(pinStockDetail).ExecuteCommandAsync();
                     }
                 }
 
@@ -3033,7 +3032,6 @@
             catch (Exception e)
             {
                 Db.RollbackTran();
-                throw new Exception(e.Message);
             }
         }
         /// <summary>
@@ -3045,7 +3043,7 @@
         /// <param name="PickQty"></param>
         /// <param name="palletNoNew"></param>
         /// <param name="userId"></param>
-        public void SoSetQtyPinPick(string soNo, string soDetailId, string palletNo, string PickQty, string palletNoNew, int userId)
+        public async Task SoSetQtyPinPick(string soNo, string soDetailId, string palletNo, string PickQty, string palletNoNew, int userId)
         {
             Db.BeginTran();
             try
@@ -3055,7 +3053,7 @@
 
                 if (string.IsNullOrWhiteSpace(soNo))
                 {
-                    throw new Exception("鍑哄簱鍗曟嵁涓嶈兘涓虹┖");
+                    throw Oops.Bah("鍑哄簱鍗曟嵁涓嶈兘涓虹┖");
                 }
                 //if (string.IsNullOrWhiteSpace(soDetailId))
                 //{
@@ -3063,76 +3061,76 @@
                 //}
                 if (string.IsNullOrWhiteSpace(palletNo))
                 {
-                    throw new Exception("鎵樼洏鐮佷笉鑳戒负绌�");
+                    throw Oops.Bah("鎵樼洏鐮佷笉鑳戒负绌�");
                 }
                 if (string.IsNullOrWhiteSpace(palletNoNew))
                 {
-                    throw new Exception("鏂版墭鐩樼爜涓嶈兘涓虹┖");
+                    throw Oops.Bah("鏂版墭鐩樼爜涓嶈兘涓虹┖");
                 }
 
                 //鍑哄簱鍗�
-                var notice = Db.Queryable<BllExportNotice>().First(m => m.IsDel == "0" && m.SONo == soNo);
+                var notice = await Db.Queryable<BllExportNotice>().FirstAsync(m => m.IsDel == "0" && m.SONo == soNo);
                 if (notice == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇ュ嚭搴撳崟鐨勪俊鎭�");
+                    throw Oops.Bah("鏈煡璇㈠埌璇ュ嚭搴撳崟鐨勪俊鎭�");
                 }
                 if (notice.Status != "3")
                 {
-                    throw new Exception("鍑哄簱鍗曠殑鐘舵�佷笉鏄鍦ㄦ墽琛岋紝涓嶈兘鎷ｈ揣");
+                    throw Oops.Bah("鍑哄簱鍗曠殑鐘舵�佷笉鏄鍦ㄦ墽琛岋紝涓嶈兘鎷ｈ揣");
                 }
                 //鍑哄簱鍗曟槑缁�
-                var noticeDetail = Db.Queryable<BllExportNoticeDetail>()
-                    .First(m => m.IsDel == "0" && m.Id == int.Parse(soDetailId));
+                var noticeDetail = await Db.Queryable<BllExportNoticeDetail>()
+                    .FirstAsync(m => m.IsDel == "0" && m.Id == int.Parse(soDetailId));
                 if (noticeDetail == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇ュ嚭搴撳崟鏄庣粏鐨勪俊鎭�");
+                    throw Oops.Bah("鏈煡璇㈠埌璇ュ嚭搴撳崟鏄庣粏鐨勪俊鎭�");
                 }
                 //鍑哄簱鍒嗛厤淇℃伅
-                var allot = Db.Queryable<BllExportAllot>().First(m =>
+                var allot = await Db.Queryable<BllExportAllot>().FirstAsync(m =>
                     m.IsDel == "0" && (m.Status == "2" || m.Status == "3") && m.SONo == soNo &&
                     m.SODetailNo == int.Parse(soDetailId) && m.PalletNo == palletNo);
                 if (allot == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇ユ墭鐩樼殑鍒嗛厤淇℃伅");
+                    throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樼殑鍒嗛厤淇℃伅");
                 }
                 //鍓╀綑鎷ｈ揣鏁伴噺锛堝緟鎷ｅ噺鍘诲凡鎷ｏ級
                 var needQty = allot.Qty - allot.CompleteQty;
                 if (int.Parse(PickQty) > needQty)
                 {
-                    throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘澶т簬鎵樺唴鍓╀綑寰呮嫞鏁伴噺");
+                    throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘澶т簬鎵樺唴鍓╀綑寰呮嫞鏁伴噺");
                 }
 
                 //搴撳瓨鏄庣粏
-                var stockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.Id == allot.StockId);
+                var stockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.Id == allot.StockId);
                 if (stockDetail == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨鏄庣粏淇℃伅锛�");
+                    throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨鏄庣粏淇℃伅锛�");
                 }
                 //搴撳瓨鎬昏〃
-                var stock = Db.Queryable<DataStock>().First(a => a.IsDel == "0" && a.SkuNo == stockDetail.SkuNo && a.LotNo == stockDetail.LotNo);
+                var stock = await Db.Queryable<DataStock>().FirstAsync(a => a.IsDel == "0" && a.SkuNo == stockDetail.SkuNo && a.LotNo == stockDetail.LotNo);
                 if (stock == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨淇℃伅锛�");
+                    throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樺垎閰嶇殑搴撳瓨淇℃伅锛�");
                 }
                 if (palletNo == palletNoNew)//鍘熸墭鐩樹笌鏂版墭鐩樹竴鑷�
                 {
                     if (int.Parse(PickQty) != stockDetail.Qty)
                     {
-                        throw new Exception("鍘熸墭鐩樹笌鏂版墭鐩樹竴鑷达紝闇�瑕佹妸鎵樼洏涓婃墍鏈夋暟閲忔嫞璐�");
+                        throw Oops.Bah("鍘熸墭鐩樹笌鏂版墭鐩樹竴鑷达紝闇�瑕佹妸鎵樼洏涓婃墍鏈夋暟閲忔嫞璐�");
                     }
                 }
                 #endregion
 
                 #region 鎷兼墭淇℃伅
                 bool isNew = false;
-                var pinStockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.PalletNo == palletNoNew);
+                var pinStockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew);
                 if (pinStockDetail != null)
                 {
                     if (palletNo != palletNoNew)//闈炴暣鎵樻嫞璐�
                     {
                         if (pinStockDetail.SONo != notice.SONo)
                         {
-                            throw new Exception("鎷兼墭鎵樼洏涓婂彧鑳芥斁鍚屼竴涓嚭搴撳崟涓嬬殑鐗╂枡锛�");
+                            throw Oops.Bah("鎷兼墭鎵樼洏涓婂彧鑳芥斁鍚屼竴涓嚭搴撳崟涓嬬殑鐗╂枡锛�");
                         }
                         if (pinStockDetail.SkuName != stockDetail.SkuName || pinStockDetail.LotNo != stockDetail.LotNo)
                         {
@@ -3144,14 +3142,14 @@
                 {
                     isNew = true;
 
-                    var newPalletInfo = Db.Queryable<SysPallets>().First(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Status == "0");
+                    var newPalletInfo = await Db.Queryable<SysPallets>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Status == "0");
                     if (newPalletInfo == null)
                     {
-                        throw new Exception("鏂版墭鐩樹俊鎭笉瀛樺湪鎴栧凡琚娇鐢紒");
+                        throw Oops.Bah("鏂版墭鐩樹俊鎭笉瀛樺湪鎴栧凡琚娇鐢紒");
                     }
                     //淇敼鏂版墭鐩樼姸鎬�
                     newPalletInfo.Status = "1";
-                    Db.Updateable(newPalletInfo).ExecuteCommand();
+                    await Db.Updateable(newPalletInfo).ExecuteCommandAsync();
                 }
 
                 if (isNew)
@@ -3202,7 +3200,7 @@
                     sd.CreateTime = nowDate;
 
                     //鏂板鎷兼墭搴撳瓨鏄庣粏淇℃伅
-                    Db.Insertable(sd).ExecuteReturnIdentity();
+                    await Db.Insertable(sd).ExecuteReturnIdentityAsync();
                 }
                 else
                 {
@@ -3211,18 +3209,18 @@
                         //淇敼鎷兼墭鎵樼洏搴撳瓨鏄庣粏
                         pinStockDetail.Qty += int.Parse(PickQty);
                         pinStockDetail.LockQty += int.Parse(PickQty);
-                        Db.Updateable(pinStockDetail).ExecuteCommand();
+                        await Db.Updateable(pinStockDetail).ExecuteCommandAsync();
                     }
                     else
                     {
                         pinStockDetail.SONo = soNo;
-                        Db.Updateable(pinStockDetail).ExecuteCommand();
+                        await Db.Updateable(pinStockDetail).ExecuteCommandAsync();
                     }
                 }
                 #endregion
 
                 //鑾峰彇褰撳墠鎵樼洏鎷ｈ揣鏄庣粏
-                var complete = Db.Queryable<BllCompleteDetail>().First(a => a.IsDel == "0" && a.PalletNo == palletNo && a.SONo == notice.SONo && a.SODetailNo == noticeDetail.Id && a.ExportAllotId == allot.Id && a.StockId == stockDetail.Id);
+                var complete = await Db.Queryable<BllCompleteDetail>().FirstAsync(a => a.IsDel == "0" && a.PalletNo == palletNo && a.SONo == notice.SONo && a.SODetailNo == noticeDetail.Id && a.ExportAllotId == allot.Id && a.StockId == stockDetail.Id);
 
                 //鍒よ鏄惁瀛樺湪鎷ｈ揣鏄庣粏
                 int isComplete = 0;
@@ -3262,7 +3260,7 @@
                     comList.Add(completeDetail);
 
                     //娣诲姞鎷ｈ揣鏄庣粏
-                    Db.Insertable(comList).ExecuteCommand();
+                    await Db.Insertable(comList).ExecuteCommandAsync();
                 }
                 else if (isComplete == 1)
                 {
@@ -3270,14 +3268,14 @@
                     complete.UpdateUser = userId;
                     complete.UpdateTime = Db.GetDate();
 
-                    Db.Updateable(complete).ExecuteCommand();
+                    await Db.Updateable(complete).ExecuteCommandAsync();
                 }
 
                 //淇敼鍑哄簱鍒嗛厤淇℃伅
                 allot.CompleteQty += int.Parse(PickQty);
                 allot.Status = allot.Qty == allot.CompleteQty ? "5" : "3";
                 allot.UpdateTime = DateTime.Now;
-                Db.Updateable(allot).ExecuteCommand();
+                await Db.Updateable(allot).ExecuteCommandAsync();
 
                 int isDel = 0;
 
@@ -3301,12 +3299,12 @@
                     }
                     if (stockDetail.Qty <= 0)
                     {
-                        Db.Deleteable(stockDetail).ExecuteCommand();
+                        await Db.Deleteable(stockDetail).ExecuteCommandAsync();
                     }
                     else
                     {
                         isDel = 1;
-                        Db.Updateable(stockDetail).ExecuteCommand();
+                        await Db.Updateable(stockDetail).ExecuteCommandAsync();
                     }
                 }
                 else
@@ -3317,28 +3315,28 @@
                 if (isDel == 0)
                 {
                     //鏀瑰彉鎵樼洏鐘舵�佷负锛氭湭浣跨敤
-                    var pallet = Db.Queryable<SysPallets>().First(m => m.PalletNo == palletNo && m.IsDel == "0");
+                    var pallet = await Db.Queryable<SysPallets>().FirstAsync(m => m.PalletNo == palletNo && m.IsDel == "0");
                     if (pallet == null)
                     {
-                        throw new Exception("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
+                        throw Oops.Bah("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
                     }
 
                     pallet.Status = "0";
-                    Db.Updateable(pallet).ExecuteCommand();
+                    await Db.Updateable(pallet).ExecuteCommandAsync();
                 }
 
                 //淇敼鍑哄簱鍗曟槑缁嗘嫞璐ф暟閲�
                 noticeDetail.CompleteQty += int.Parse(PickQty);
-                Db.Updateable(noticeDetail).ExecuteCommand();
+                await Db.Updateable(noticeDetail).ExecuteCommandAsync();
 
-                var num = Db.Queryable<BllExportNoticeDetail>()
-                    .Count(m => m.IsDel == "0" && m.SONo == soNo && m.CompleteQty < m.Qty);
+                var num = await Db.Queryable<BllExportNoticeDetail>()
+                    .CountAsync(m => m.IsDel == "0" && m.SONo == soNo && m.CompleteQty < m.Qty);
                 if (num <= 0)
                 {
                     notice.Status = "4"; //鏇存敼涓烘墽琛屽畬鎴�
                 }
                 //淇敼鍑哄簱鍗曚俊鎭�
-                Db.Updateable(notice).ExecuteCommand();
+                await Db.Updateable(notice).ExecuteCommandAsync();
 
                 //娣诲姞鎿嶄綔鏃ュ織璁板綍
                 var k = new OperationSOServer().AddLogOperationSo("PDA妯″潡", "鎷ｈ揣鎷兼墭", soNo, "鎷ｈ揣", $"鍦≒DA涓婂鍑哄簱鍗曞彿涓猴細{soNo}鐨勬墭鐩樼爜涓猴細{palletNo}锛屾柊鎵樼洏鐮佷负锛歿palletNoNew}鐨勬嫞璐ф搷浣�", userId);
@@ -3347,7 +3345,6 @@
             catch (Exception e)
             {
                 Db.RollbackTran();
-                throw new Exception(e.Message);
             }
         }
         #endregion
@@ -3355,75 +3352,53 @@
         #region JC23鐗堝彇鏍�
 
         //鏍规嵁鎵樼洏鍙疯幏鍙栧彇鏍风被鍨�
-        public string GetSampleType2(string palletNo)
+        public async Task<string> GetSampleType2(string palletNo)
         {
-            try
+            var type = "";
+            var detail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNo);
+            if (detail == null)
             {
-                var type = "";
-                var detail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.PalletNo == palletNo);
-                if (detail == null)
-                {
-                    throw new Exception("褰撳墠鎵樼洏鏈湪搴撳瓨涓�");
-                }
-
-                var boxInfo = Db.Queryable<DataBoxInfo>().Count(m => m.IsDel == "0" && m.StockDetailId == detail.Id);
-
-                //鍒ゆ柇鎵樼洏涓婃槸鍚︽湁绠辩爜淇℃伅
-                if (boxInfo > 0)
-                {
-                    type = "0";//鏍囩鍙栨牱
-                }
-                else
-                {
-                    type = "1";//鏁伴噺鍙栨牱
-                }
-                return type;
+                throw Oops.Bah("褰撳墠鎵樼洏鏈湪搴撳瓨涓�");
             }
-            catch (Exception e)
+
+            var boxInfo = await Db.Queryable<DataBoxInfo>().CountAsync(m => m.IsDel == "0" && m.StockDetailId == detail.Id);
+
+            //鍒ゆ柇鎵樼洏涓婃槸鍚︽湁绠辩爜淇℃伅
+            if (boxInfo > 0)
             {
-                throw new Exception(e.Message);
+                type = "0";//鏍囩鍙栨牱
             }
+            else
+            {
+                type = "1";//鏁伴噺鍙栨牱
+            }
+            return type;
         }
 
         //鑾峰彇寰呭嚭搴撴垨寰呭彇鏍风殑璇烽獙鍗�
-        public List<string> GetInspectionNo()
+        public async Task<List<string>> GetInspectionNo()
         {
-            try
-            {
-                var data = Db.Queryable<BllQualityInspectionRequest>().Where(m => m.IsDel == "0" && (m.Status == "1" || m.Status == "2")).OrderByDescending(m => m.QcNo).Select(m => m.QcNo).ToList();
-                return data;
-            }
-            catch (Exception e)
-            {
-                throw new Exception(e.Message);
-            }
+            return await Db.Queryable<BllQualityInspectionRequest>().Where(m => m.IsDel == "0" && (m.Status == "1" || m.Status == "2")).OrderByDescending(m => m.QcNo).Select(m => m.QcNo).ToListAsync();
         }
 
         //鑾峰彇璇烽獙鍗曠浉鍏充俊鎭�
-        public InspectionRequestDto GetInspectionRequestInfo(string qcNo)
+        public async Task<InspectionRequestDto> GetInspectionRequestInfo(string qcNo)
         {
-            try
-            {
-                var data = new InspectionRequestDto();
-                var inspectionRequest = Db.Queryable<BllQualityInspectionRequest>().First(m => m.IsDel == "0" && m.QcNo == qcNo);
-                var samplingQty = Db.Queryable<BllSamplingDetails>().Where(m => m.IsDel == "0" && m.QcNo == qcNo).Sum(m => m.CompleteQty);
+            var data = new InspectionRequestDto();
+            var inspectionRequest = await Db.Queryable<BllQualityInspectionRequest>().FirstAsync(m => m.IsDel == "0" && m.QcNo == qcNo);
+            var samplingQty = await Db.Queryable<BllSamplingDetails>().Where(m => m.IsDel == "0" && m.QcNo == qcNo).SumAsync(m => m.CompleteQty);
 
-                data.QcNo = qcNo;
-                data.Sku = inspectionRequest.SkuNo;
-                data.LotNo = inspectionRequest.LotNo;
-                data.Qty = inspectionRequest.SamplingQty.ToString();
-                data.SamplingQty = samplingQty == null ? "0" : samplingQty.ToString();
+            data.QcNo = qcNo;
+            data.Sku = inspectionRequest.SkuNo;
+            data.LotNo = inspectionRequest.LotNo;
+            data.Qty = inspectionRequest.SamplingQty.ToString();
+            data.SamplingQty = samplingQty == null ? "0" : samplingQty.ToString();
 
-                return data;
-            }
-            catch (Exception e)
-            {
-                throw new Exception(e.Message);
-            }
+            return data;
         }
 
         //鍙栨牱鍑哄簱鎷ｈ揣(鏍囩)
-        public void SampleSetPick(string qcNo, string palletNo, string boxNo, string boxNo3, string pickQty, int userId)
+        public async Task SampleSetPick(string qcNo, string palletNo, string boxNo, string boxNo3, string pickQty, int userId)
         {
             try
             {
@@ -3431,20 +3406,20 @@
 
                 if (string.IsNullOrWhiteSpace(qcNo))
                 {
-                    throw new Exception("璇烽獙鍗曟嵁涓嶈兘涓虹┖");
+                    throw Oops.Bah("璇烽獙鍗曟嵁涓嶈兘涓虹┖");
                 }
                 if (string.IsNullOrWhiteSpace(palletNo))
                 {
-                    throw new Exception("鎵樼洏鍙蜂笉鑳戒负绌�");
+                    throw Oops.Bah("鎵樼洏鍙蜂笉鑳戒负绌�");
                 }
-                var type = GetSampleType2(palletNo);
+                var type = await GetSampleType2(palletNo);
                 if (type != "0")
                 {
-                    throw new Exception("褰撳墠鎵樼洏璇峰湪鏁伴噺椤电鍙栨牱");
+                    throw Oops.Bah("褰撳墠鎵樼洏璇峰湪鏁伴噺椤电鍙栨牱");
                 }
                 if (string.IsNullOrEmpty(boxNo))
                 {
-                    throw new Exception("澶栫鏉＄爜涓嶈兘涓虹┖");
+                    throw Oops.Bah("澶栫鏉＄爜涓嶈兘涓虹┖");
                 }
                 //if (!string.IsNullOrEmpty(boxNo3) && !string.IsNullOrEmpty(pickQty) && int.Parse(pickQty) > 0)
                 //{
@@ -3452,44 +3427,44 @@
                 //}
 
                 //璇烽獙鍗�
-                var inspecd = Db.Queryable<BllQualityInspectionRequest>().First(m => m.IsDel == "0" && m.QcNo == qcNo);
+                var inspecd = await Db.Queryable<BllQualityInspectionRequest>().FirstAsync(m => m.IsDel == "0" && m.QcNo == qcNo);
                 if (inspecd == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇烽獙鍗曚俊鎭�");
+                    throw Oops.Bah("鏈煡璇㈠埌璇烽獙鍗曚俊鎭�");
                 }
                 if (inspecd.Status == "0" || inspecd.Status == "3")
                 {
-                    throw new Exception("璇烽獙鍗曠姸鎬侀敊璇紝璇锋牳瀹�");
+                    throw Oops.Bah("璇烽獙鍗曠姸鎬侀敊璇紝璇锋牳瀹�");
                 }
                 //搴撳瓨鏄庣粏淇℃伅
-                var stockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.PalletNo == palletNo && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
+                var stockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNo && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
                 if (stockDetail == null)
                 {
-                    throw new Exception("鏈湪搴撳瓨涓煡璇㈠嚭褰撳墠鎵樼洏淇℃伅");
+                    throw Oops.Bah("鏈湪搴撳瓨涓煡璇㈠嚭褰撳墠鎵樼洏淇℃伅");
                 }
                 if (!string.IsNullOrWhiteSpace(stockDetail.LocatNo))
                 {
-                    throw new Exception("褰撳墠鎵樼洏涓嶆槸搴撳鎵樼洏锛岃鏍稿疄");
+                    throw Oops.Bah("褰撳墠鎵樼洏涓嶆槸搴撳鎵樼洏锛岃鏍稿疄");
                 }
                 //绠辨敮淇℃伅 
-                var boxInfoList = Db.Queryable<DataBoxInfo>().Where(m => m.IsDel == "0" && m.StockDetailId == stockDetail.Id && m.BoxNo == boxNo).ToList();
+                var boxInfoList = await Db.Queryable<DataBoxInfo>().Where(m => m.IsDel == "0" && m.StockDetailId == stockDetail.Id && m.BoxNo == boxNo).ToListAsync();
                 //搴撳瓨鎬昏〃
-                var stock = Db.Queryable<DataStock>().First(m => m.IsDel == "0" && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
+                var stock = await Db.Queryable<DataStock>().FirstAsync(m => m.IsDel == "0" && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
                 if (stock == null)
                 {
-                    throw new Exception("鏈煡璇㈠嚭搴撳瓨鎬讳俊鎭�");
+                    throw Oops.Bah("鏈煡璇㈠嚭搴撳瓨鎬讳俊鎭�");
                 }
                 //鍏ュ簱鍗�
-                var notice = Db.Queryable<BllArrivalNotice>().First(m => m.IsDel == "0" && m.ASNNo == inspecd.ASNNo);
+                var notice = await Db.Queryable<BllArrivalNotice>().FirstAsync(m => m.IsDel == "0" && m.ASNNo == inspecd.ASNNo);
                 if (notice == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌鍏ュ簱鍗曚俊鎭�");
+                    throw Oops.Bah("鏈煡璇㈠埌鍏ュ簱鍗曚俊鎭�");
                 }
 
                 #endregion
 
                 //鍙栨牱鏄庣粏璁板綍琛�
-                var sampld = Db.Queryable<BllSamplingDetails>().Where(m => m.IsDel == "0" && m.QcNo == qcNo).ToList();
+                var sampld = await Db.Queryable<BllSamplingDetails>().Where(m => m.IsDel == "0" && m.QcNo == qcNo).ToListAsync();
 
                 var isAddSampld = false;
                 var PickType = ""; //0鏁伴噺鎷ｈ揣  1 绠辨敮鎷ｈ揣
@@ -3506,16 +3481,16 @@
                     {
                         if (boxInfoList.Count(m => m.BoxNo3 == boxNo3) == 0)
                         {
-                            throw new Exception("鏈煡璇㈠埌鏀爜淇℃伅");
+                            throw Oops.Bah("鏈煡璇㈠埌鏀爜淇℃伅");
                         }
                         if (boxInfoList.Count(m => m.BoxNo3 == boxNo3) > 1)
                         {
-                            throw new Exception("鏀爜淇℃伅鏁版嵁淇℃伅閿欒锛岃鏍稿疄");
+                            throw Oops.Bah("鏀爜淇℃伅鏁版嵁淇℃伅閿欒锛岃鏍稿疄");
                         }
-                        EditboxInfo = Db.Queryable<DataBoxInfo>().First(m => m.IsDel == "0" && m.StockDetailId == stockDetail.Id && m.BoxNo == boxNo && m.BoxNo3 == boxNo3);
+                        EditboxInfo = await Db.Queryable<DataBoxInfo>().FirstAsync(m => m.IsDel == "0" && m.StockDetailId == stockDetail.Id && m.BoxNo == boxNo && m.BoxNo3 == boxNo3);
                         if (EditboxInfo.Qty < decimal.Parse(pickQty))
                         {
-                            throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鏁伴噺");
+                            throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鏁伴噺");
                         }
                         isAddSampld = sampld.Count(m => m.PalletNo == palletNo && m.BoxNo == EditboxInfo.BoxNo && m.BoxNo3 == EditboxInfo.BoxNo3) == 0;
                     }
@@ -3524,33 +3499,33 @@
 
                         if (boxInfoList.Count == 0)
                         {
-                            throw new Exception("鏈湪鎵樼洏涓婃煡璇㈠埌绠辩爜淇℃伅锛岃鏍稿疄");
+                            throw Oops.Bah("鏈湪鎵樼洏涓婃煡璇㈠埌绠辩爜淇℃伅锛岃鏍稿疄");
                         }
                         if (boxInfoList.Count > 1)
                         {
-                            throw new Exception("绠辩爜鏁版嵁淇℃伅閿欒锛岃鏍稿疄");
+                            throw Oops.Bah("绠辩爜鏁版嵁淇℃伅閿欒锛岃鏍稿疄");
                         }
                         if (boxInfoList.Count(m => !string.IsNullOrWhiteSpace(m.BoxNo3)) > 0)
                         {
-                            throw new Exception("褰撳墠绠辩爜涓惈鏈夋敮鐮侊紝璇疯緭鍏ユ敮鐮佷俊鎭彇鏍�");
+                            throw Oops.Bah("褰撳墠绠辩爜涓惈鏈夋敮鐮侊紝璇疯緭鍏ユ敮鐮佷俊鎭彇鏍�");
                         }
-                        EditboxInfo = Db.Queryable<DataBoxInfo>().First(m => m.IsDel == "0" && m.StockDetailId == stockDetail.Id && m.BoxNo == boxNo);
+                        EditboxInfo = await Db.Queryable<DataBoxInfo>().FirstAsync(m => m.IsDel == "0" && m.StockDetailId == stockDetail.Id && m.BoxNo == boxNo);
 
                         if (EditboxInfo.Qty < decimal.Parse(pickQty))
                         {
-                            throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鏁伴噺");
+                            throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鏁伴噺");
                         }
                         isAddSampld = sampld.Count(m => m.PalletNo == palletNo && m.BoxNo == EditboxInfo.BoxNo) == 0;
 
                     }
                     if (sampld.Sum(m => m.CompleteQty) + decimal.Parse(pickQty) > inspecd.SamplingQty)
                     {
-                        throw new Exception("鍙栨牱鎬绘嫞璐ф暟閲忓ぇ浜庤楠屽崟鍙栨牱鏁伴噺");
+                        throw Oops.Bah("鍙栨牱鎬绘嫞璐ф暟閲忓ぇ浜庤楠屽崟鍙栨牱鏁伴噺");
                     }
                     //鍒ゆ柇绠变腑鏄惁鍚湁鏀爜锛屾湁锛氫笉璁╂嫞鏁伴噺
                     if (stockDetail.Qty - stockDetail.LockQty - stockDetail.FrozenQty < decimal.Parse(pickQty))
                     {
-                        throw new Exception("鎵樼洏涓婂彲鐢ㄦ暟閲忓皬浜庡彇鏍锋暟閲忥紝璇锋牳瀹為攣瀹氥�佸喕缁撴暟閲�");
+                        throw Oops.Bah("鎵樼洏涓婂彲鐢ㄦ暟閲忓皬浜庡彇鏍锋暟閲忥紝璇锋牳瀹為攣瀹氥�佸喕缁撴暟閲�");
                     }
                 }
                 else //绠辨敮鎷ｈ揣
@@ -3563,16 +3538,16 @@
 
                         if (boxInfoList.Count(m => m.BoxNo3 == boxNo3) == 0)
                         {
-                            throw new Exception("鏈煡璇㈠埌鏀爜淇℃伅");
+                            throw Oops.Bah("鏈煡璇㈠埌鏀爜淇℃伅");
                         }
                         if (boxInfoList.Count(m => m.BoxNo3 == boxNo3) > 1)
                         {
-                            throw new Exception("鏀爜鏁版嵁淇℃伅閿欒锛岃鏍稿疄");
+                            throw Oops.Bah("鏀爜鏁版嵁淇℃伅閿欒锛岃鏍稿疄");
                         }
-                        EditboxInfoList = Db.Queryable<DataBoxInfo>().Where(m => m.IsDel == "0" && m.StockDetailId == stockDetail.Id && m.BoxNo == boxNo && m.BoxNo3 == boxNo3).ToList();
+                        EditboxInfoList = await Db.Queryable<DataBoxInfo>().Where(m => m.IsDel == "0" && m.StockDetailId == stockDetail.Id && m.BoxNo == boxNo && m.BoxNo3 == boxNo3).ToListAsync();
                         if (EditboxInfoList.Sum(m => m.Qty) + sampld.Sum(m => m.CompleteQty) > inspecd.SamplingQty)
                         {
-                            throw new Exception("鍙栨牱鎬绘嫞璐ф暟閲忓ぇ浜庤楠屽崟鍙栨牱鏁伴噺");
+                            throw Oops.Bah("鍙栨牱鎬绘嫞璐ф暟閲忓ぇ浜庤楠屽崟鍙栨牱鏁伴噺");
                         }
                         qty = EditboxInfoList.Sum(m => m.Qty);
                         //isAddSampld = sampld.Count(m => m.PalletNo == palletNo && m.BoxNo == EditboxInfo.BoxNo && m.BoxNo3 == EditboxInfo.BoxNo3) == 0;
@@ -3582,32 +3557,32 @@
 
                         if (boxInfoList.Count == 0)
                         {
-                            throw new Exception("鏈湪鎵樼洏涓婃煡璇㈠埌绠辩爜淇℃伅锛岃鏍稿疄");
+                            throw Oops.Bah("鏈湪鎵樼洏涓婃煡璇㈠埌绠辩爜淇℃伅锛岃鏍稿疄");
                         }
                         if (boxInfoList.Count > 1)
                         {
-                            throw new Exception("绠辩爜鏁版嵁淇℃伅閿欒锛岃鏍稿疄");
+                            throw Oops.Bah("绠辩爜鏁版嵁淇℃伅閿欒锛岃鏍稿疄");
                         }
                         if (boxInfoList.Count(m => !string.IsNullOrWhiteSpace(m.BoxNo3)) > 0)
                         {
-                            throw new Exception("褰撳墠绠辩爜涓惈鏈夋敮鐮侊紝璇疯緭鍏ユ敮鐮佷俊鎭彇鏍�");
+                            throw Oops.Bah("褰撳墠绠辩爜涓惈鏈夋敮鐮侊紝璇疯緭鍏ユ敮鐮佷俊鎭彇鏍�");
                         }
-                        EditboxInfoList = Db.Queryable<DataBoxInfo>().Where(m => m.IsDel == "0" && m.StockDetailId == stockDetail.Id && m.BoxNo == boxNo).ToList();
+                        EditboxInfoList = await Db.Queryable<DataBoxInfo>().Where(m => m.IsDel == "0" && m.StockDetailId == stockDetail.Id && m.BoxNo == boxNo).ToListAsync();
 
                         if (EditboxInfo.Qty < decimal.Parse(pickQty))
                         {
-                            throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鏁伴噺");
+                            throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鏁伴噺");
                         }
                         qty = EditboxInfoList.Sum(m => m.Qty);
                         //isAddSampld = sampld.Count(m => m.PalletNo == palletNo && m.BoxNo == EditboxInfo.BoxNo) == 0;
                     }
                     if (sampld.Sum(m => m.CompleteQty) + qty > inspecd.SamplingQty)
                     {
-                        throw new Exception("鍙栨牱鎬绘嫞璐ф暟閲忓ぇ浜庤楠屽崟鍙栨牱鏁伴噺");
+                        throw Oops.Bah("鍙栨牱鎬绘嫞璐ф暟閲忓ぇ浜庤楠屽崟鍙栨牱鏁伴噺");
                     }
                     if (stockDetail.Qty - stockDetail.LockQty - stockDetail.FrozenQty < qty)
                     {
-                        throw new Exception("鎵樼洏涓婂彲鐢ㄦ暟閲忓皬浜庡彇鏍锋暟閲忥紝璇锋牳瀹為攣瀹氥�佸喕缁撴暟閲�");
+                        throw Oops.Bah("鎵樼洏涓婂彲鐢ㄦ暟閲忓皬浜庡彇鏍锋暟閲忥紝璇锋牳瀹為攣瀹氥�佸喕缁撴暟閲�");
                     }
                 }
                 #endregion
@@ -3772,7 +3747,7 @@
                             CreateTime = DateTime.Now,
                             CreateUser = userId
                         };
-                        Db.Insertable(sampleDetail).ExecuteCommand();
+                        await Db.Insertable(sampleDetail).ExecuteCommandAsync();
                         //}
                         //else
                         //{
@@ -3791,7 +3766,7 @@
                         #region 淇敼搴撳瓨涓夎〃
 
                         //鎷嗗寘鏈夋晥鏈熸洿鏀�
-                        var unpackWarranty = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == inspecd.SkuNo).UnpackWarranty;
+                        var unpackWarranty = (await Db.Queryable<SysMaterials>().FirstAsync(m => m.IsDel == "0" && m.SkuNo == inspecd.SkuNo)).UnpackWarranty;
 
                         foreach (var item in boxInfoList)
                         {
@@ -3809,31 +3784,31 @@
                                 }
                             }
                         }
-                        Db.Updateable(boxInfoList).ExecuteCommand();
+                        await Db.Updateable(boxInfoList).ExecuteCommandAsync();
 
                         //搴撳瓨绠辩爜
 
-                        Db.Deleteable(boxInfo).ExecuteCommand();
+                        await Db.Deleteable(boxInfo).ExecuteCommandAsync();
 
                         //搴撳瓨鏄庣粏
                         stockDetail.Qty -= boxInfo.Qty;
                         if (stockDetail.Qty == 0)
                         {
-                            Db.Deleteable(stockDetail).ExecuteCommand();
+                            await Db.Deleteable(stockDetail).ExecuteCommandAsync();
                         }
                         else
                         {
-                            Db.Updateable(stockDetail).ExecuteCommand();
+                            await Db.Updateable(stockDetail).ExecuteCommandAsync();
                         }
                         //搴撳瓨鎬昏〃
                         stock.Qty -= boxInfo.Qty;
                         if (stock.Qty == 0)
                         {
-                            Db.Deleteable(stock).ExecuteCommand();
+                            await Db.Deleteable(stock).ExecuteCommandAsync();
                         }
                         else
                         {
-                            Db.Updateable(stock).ExecuteCommand();
+                            await Db.Updateable(stock).ExecuteCommandAsync();
                         }
 
                         #endregion
@@ -3843,12 +3818,12 @@
                         //涓嶆槸涓婁紶瀹屾瘯鐨勪慨鏀瑰彇鏍风姸鎬�
                         if (notice.Status != "4")
                         {
-                            var noticeDetail = Db.Queryable<BllArrivalNoticeDetail>().First(m => m.IsDel == "0" && m.ASNNo == inspecd.ASNNo && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
+                            var noticeDetail = await Db.Queryable<BllArrivalNoticeDetail>().FirstAsync(m => m.IsDel == "0" && m.ASNNo == inspecd.ASNNo && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
                             if (noticeDetail.IsSampling == "0")
                             {
                                 noticeDetail.IsSampling = "1";
 
-                                Db.Updateable(noticeDetail).ExecuteCommand();
+                                await Db.Updateable(noticeDetail).ExecuteCommandAsync();
                             }
 
                         }
@@ -3866,7 +3841,7 @@
                         inspecd.Status = "3";
                     }
 
-                    Db.Updateable(inspecd).ExecuteCommand();
+                    await Db.Updateable(inspecd).ExecuteCommandAsync();
                     #endregion
                 }
 
@@ -3880,13 +3855,12 @@
             catch (Exception e)
             {
                 Db.RollbackTran();
-                throw new Exception(e.Message);
             }
         }
 
 
         //鍙栨牱鍑哄簱鎷ｈ揣(鏁伴噺)
-        public void SampleSetQtyPick(string qcNo, string palletNo, string pickQty, int userId)
+        public async Task SampleSetQtyPick(string qcNo, string palletNo, string pickQty, int userId)
         {
             try
             {
@@ -3894,63 +3868,63 @@
 
                 if (string.IsNullOrWhiteSpace(qcNo))
                 {
-                    throw new Exception("璇烽獙鍗曟嵁涓嶈兘涓虹┖");
+                    throw Oops.Bah("璇烽獙鍗曟嵁涓嶈兘涓虹┖");
                 }
                 if (string.IsNullOrWhiteSpace(palletNo))
                 {
-                    throw new Exception("鎵樼洏鍙蜂笉鑳戒负绌�");
+                    throw Oops.Bah("鎵樼洏鍙蜂笉鑳戒负绌�");
                 }
-                var type = GetSampleType2(palletNo);
+                var type = await GetSampleType2(palletNo);
                 if (type != "1")
                 {
-                    throw new Exception("褰撳墠鎵樼洏璇峰湪鏍囩椤电鍙栨牱");
+                    throw Oops.Bah("褰撳墠鎵樼洏璇峰湪鏍囩椤电鍙栨牱");
                 }
                 if (string.IsNullOrWhiteSpace(pickQty))
                 {
-                    throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘涓虹┖");
+                    throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘涓虹┖");
                 }
                 if (decimal.Parse(pickQty) <= 0)
                 {
-                    throw new Exception("鎷ｈ揣鏁伴噺涓嶈兘灏忎簬绛変簬0");
+                    throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘灏忎簬绛変簬0");
                 }
 
                 //璇烽獙鍗�
-                var inspecd = Db.Queryable<BllQualityInspectionRequest>().First(m => m.IsDel == "0" && m.QcNo == qcNo);
+                var inspecd = await Db.Queryable<BllQualityInspectionRequest>().FirstAsync(m => m.IsDel == "0" && m.QcNo == qcNo);
                 if (inspecd == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌璇烽獙鍗曚俊鎭�");
+                    throw Oops.Bah("鏈煡璇㈠埌璇烽獙鍗曚俊鎭�");
                 }
                 if (inspecd.Status == "0" || inspecd.Status == "3")
                 {
-                    throw new Exception("璇烽獙鍗曠姸鎬侀敊璇紝璇锋牳瀹�");
+                    throw Oops.Bah("璇烽獙鍗曠姸鎬侀敊璇紝璇锋牳瀹�");
                 }
                 //搴撳瓨鏄庣粏淇℃伅
-                var stockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.PalletNo == palletNo && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
+                var stockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNo && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
                 if (stockDetail == null)
                 {
-                    throw new Exception("鏈湪搴撳瓨涓煡璇㈠嚭褰撳墠鎵樼洏淇℃伅");
+                    throw Oops.Bah("鏈湪搴撳瓨涓煡璇㈠嚭褰撳墠鎵樼洏淇℃伅");
                 }
                 if (!string.IsNullOrWhiteSpace(stockDetail.LocatNo))
                 {
-                    throw new Exception("褰撳墠鎵樼洏涓嶆槸搴撳鎵樼洏锛岃鏍稿疄");
+                    throw Oops.Bah("褰撳墠鎵樼洏涓嶆槸搴撳鎵樼洏锛岃鏍稿疄");
                 }
                 //搴撳瓨鎬昏〃
-                var stock = Db.Queryable<DataStock>().First(m => m.IsDel == "0" && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
+                var stock = await Db.Queryable<DataStock>().FirstAsync(m => m.IsDel == "0" && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
                 if (stock == null)
                 {
-                    throw new Exception("鏈煡璇㈠嚭搴撳瓨鎬讳俊鎭�");
+                    throw Oops.Bah("鏈煡璇㈠嚭搴撳瓨鎬讳俊鎭�");
                 }
                 //鍏ュ簱鍗�
-                var notice = Db.Queryable<BllArrivalNotice>().First(m => m.IsDel == "0" && m.ASNNo == inspecd.ASNNo);
+                var notice = await Db.Queryable<BllArrivalNotice>().FirstAsync(m => m.IsDel == "0" && m.ASNNo == inspecd.ASNNo);
                 if (notice == null)
                 {
-                    throw new Exception("鏈煡璇㈠埌鍏ュ簱鍗曚俊鎭�");
+                    throw Oops.Bah("鏈煡璇㈠埌鍏ュ簱鍗曚俊鎭�");
                 }
 
                 #endregion
 
                 //鍙栨牱鏄庣粏璁板綍琛�
-                var sampld = Db.Queryable<BllSamplingDetails>().Where(m => m.IsDel == "0" && m.QcNo == qcNo).ToList();
+                var sampld = await Db.Queryable<BllSamplingDetails>().Where(m => m.IsDel == "0" && m.QcNo == qcNo).ToListAsync();
                 var qty = decimal.Parse(pickQty);
                 //var isAddSampld = sampld.Count(m => m.PalletNo == palletNo) == 0; 
 
@@ -3959,12 +3933,12 @@
 
                 if (sampld.Sum(m => m.CompleteQty) + qty > inspecd.SamplingQty)
                 {
-                    throw new Exception("鍙栨牱鎬绘嫞璐ф暟閲忓ぇ浜庤楠屽崟鍙栨牱鏁伴噺");
+                    throw Oops.Bah("鍙栨牱鎬绘嫞璐ф暟閲忓ぇ浜庤楠屽崟鍙栨牱鏁伴噺");
                 }
                 //鍒ゆ柇绠变腑鏄惁鍚湁鏀爜锛屾湁锛氫笉璁╂嫞鏁伴噺
                 if (stockDetail.Qty - stockDetail.LockQty - stockDetail.FrozenQty < qty)
                 {
-                    throw new Exception("鎵樼洏涓婂彲鐢ㄦ暟閲忓皬浜庡彇鏍锋暟閲忥紝璇锋牳瀹為攣瀹氥�佸喕缁撴暟閲�");
+                    throw Oops.Bah("鎵樼洏涓婂彲鐢ㄦ暟閲忓皬浜庡彇鏍锋暟閲忥紝璇锋牳瀹為攣瀹氥�佸喕缁撴暟閲�");
                 }
 
 
@@ -3990,7 +3964,7 @@
                     CreateTime = DateTime.Now,
                     CreateUser = userId
                 };
-                Db.Insertable(sampleDetail).ExecuteCommand();
+                await Db.Insertable(sampleDetail).ExecuteCommandAsync();
                 //}
                 //else
                 //{
@@ -4009,24 +3983,24 @@
                 stockDetail.Qty -= qty;
                 if (stockDetail.Qty == 0)
                 {
-                    Db.Deleteable(stockDetail).ExecuteCommand();
+                    await Db.Deleteable(stockDetail).ExecuteCommandAsync();
                 }
                 else
                 {
                     stockDetail.BitPalletMark = "1";
                     stockDetail.InspectMark = "1";
 
-                    Db.Updateable(stockDetail).ExecuteCommand();
+                    await Db.Updateable(stockDetail).ExecuteCommandAsync();
                 }
                 //搴撳瓨鎬昏〃
                 stock.Qty -= qty;
                 if (stock.Qty == 0)
                 {
-                    Db.Deleteable(stock).ExecuteCommand();
+                    await Db.Deleteable(stock).ExecuteCommandAsync();
                 }
                 else
                 {
-                    Db.Updateable(stock).ExecuteCommand();
+                    await Db.Updateable(stock).ExecuteCommandAsync();
                 }
 
                 #endregion
@@ -4036,12 +4010,12 @@
                 //涓嶆槸涓婁紶瀹屾瘯鐨勪慨鏀瑰彇鏍风姸鎬�
                 if (notice.Status != "4")
                 {
-                    var noticeDetail = Db.Queryable<BllArrivalNoticeDetail>().First(m => m.IsDel == "0" && m.ASNNo == inspecd.ASNNo && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
+                    var noticeDetail = await Db.Queryable<BllArrivalNoticeDetail>().FirstAsync(m => m.IsDel == "0" && m.ASNNo == inspecd.ASNNo && m.SkuNo == inspecd.SkuNo && m.LotNo == inspecd.LotNo);
                     if (noticeDetail.IsSampling == "0")
                     {
                         noticeDetail.IsSampling = "1";
 
-                        Db.Updateable(noticeDetail).ExecuteCommand();
+                        await Db.Updateable(noticeDetail).ExecuteCommandAsync();
                     }
 
                 }
@@ -4056,7 +4030,7 @@
                 {
                     inspecd.Status = "3";
                 }
-                Db.Updateable(inspecd).ExecuteCommand();
+                await Db.Updateable(inspecd).ExecuteCommandAsync();
                 #endregion
 
 
@@ -4068,7 +4042,6 @@
             catch (Exception e)
             {
                 Db.RollbackTran();
-                throw new Exception(e.Message);
             }
         }
 
diff --git a/Wms/WMS.IBLL/IPdaServer/IPdaSoServer.cs b/Wms/WMS.IBLL/IPdaServer/IPdaSoServer.cs
index 1d3825c..7d2dfe1 100644
--- a/Wms/WMS.IBLL/IPdaServer/IPdaSoServer.cs
+++ b/Wms/WMS.IBLL/IPdaServer/IPdaSoServer.cs
@@ -157,7 +157,7 @@
         /// <param name="boxNo3">鏀�/琚嬬爜</param>
         /// <param name="palletNo">鏂版墭鐩樺彿</param> 
         /// <param name="userId">鎿嶄綔浜�</param>
-        void SoSetPinPick(string soNo, string soDetailId, string palletNo, string boxNo, string boxNo3, string PickQty, string palletNoNew, int userId);
+        Task SoSetPinPick(string soNo, string soDetailId, string palletNo, string boxNo, string boxNo3, string PickQty, string palletNoNew, int userId);
         /// <summary>
         /// 鎷兼墭鍑哄簱pda鎷ｈ揣-鏁伴噺
         /// </summary>
@@ -167,7 +167,7 @@
         /// <param name="PickQty"></param>
         /// <param name="palletNoNew"></param>
         /// <param name="userId"></param>
-        void SoSetQtyPinPick(string soNo, string soDetailId, string palletNo, string PickQty, string palletNoNew, int userId);
+        Task SoSetQtyPinPick(string soNo, string soDetailId, string palletNo, string PickQty, string palletNoNew, int userId);
         /// <summary>
         ///  鍙栨牱鍑哄簱鎷ｈ揣(鏃犳爣绛�)
         /// </summary>
@@ -178,7 +178,7 @@
         /// <param name="PickQty">鎷ｈ揣鏁伴噺</param>
         /// <param name="asnNo">鍏ュ簱鍗�</param>
         /// <param name="userId">鎿嶄綔浜篒D</param>
-        void SampleSoSetQtyPick(string soType, string soNo, string soDetailId, string palletNo, string PickQty,
+        Task SampleSoSetQtyPick(string soType, string soNo, string soDetailId, string palletNo, string PickQty,
             string asnNo, int userId);
 
 
@@ -189,18 +189,18 @@
         /// </summary>
         /// <param name="palletNo">鎵樼洏鍙�</param>
         /// <returns>0:鏍囩鍙栨牱  1锛氭暟閲忓彇鏍�</returns>
-        string GetSampleType2(string palletNo);
+        Task<string> GetSampleType2(string palletNo);
         /// <summary>
         /// 鑾峰彇寰呭嚭搴撴垨寰呭彇鏍风殑璇烽獙鍗�
         /// </summary>
         /// <returns></returns>
-        List<string> GetInspectionNo();
+        Task<List<string>> GetInspectionNo();
         /// <summary>
         /// 鑾峰彇璇烽獙鍗曠浉鍏充俊鎭�
         /// </summary>
         /// <param name="qcNo">璇烽獙鍗�</param>
         /// <returns></returns>
-        InspectionRequestDto GetInspectionRequestInfo(string qcNo);
+        Task<InspectionRequestDto> GetInspectionRequestInfo(string qcNo);
 
         /// <summary>
         /// 鍙栨牱鍑哄簱鎷ｈ揣(鏍囩)
@@ -211,7 +211,7 @@
         /// <param name="boxNo3">鏀爜</param>
         /// <param name="pickQty">鎷ｈ揣鏁伴噺</param>
         /// <param name="userId"></param>
-        void SampleSetPick(string qcNo, string palletNo, string boxNo, string boxNo3, string pickQty, int userId);
+        Task SampleSetPick(string qcNo, string palletNo, string boxNo, string boxNo3, string pickQty, int userId);
 
         /// <summary>
         /// 鍙栨牱鍑哄簱鎷ｈ揣(鏁伴噺)
@@ -220,7 +220,7 @@
         /// <param name="palletNo">鎵樼洏鍙�</param>
         /// <param name="pickQty">鎷ｈ揣鏁伴噺</param>
         /// <param name="userId"></param>
-        void SampleSetQtyPick(string qcNo, string palletNo, string pickQty, int userId);
+        Task SampleSetQtyPick(string qcNo, string palletNo, string pickQty, int userId);
 
         #endregion
 
diff --git a/Wms/Wms/Controllers/PdaSoController.cs b/Wms/Wms/Controllers/PdaSoController.cs
index 9adb88f..006663b 100644
--- a/Wms/Wms/Controllers/PdaSoController.cs
+++ b/Wms/Wms/Controllers/PdaSoController.cs
@@ -20,6 +20,7 @@
     [Route("api/[controller]/[action]")]
     [ApiController]
     [Authorize]
+    [ServiceFilter(typeof(ApiResponseActionFilter))]
     public class PdaSoController : ControllerBase
     {
         #region 渚濊禆娉ㄥ叆
@@ -42,7 +43,6 @@
         /// <param name="model">PalletNo锛氭墭鐩樻潯鐮�</param>
         /// <returns></returns>
         [HttpPost]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task IsEnableOkPalletNo(PdaSoVm model)
         {
             await _pdaSoSvc.IsEnableOkPalletNo(model.PalletNo);
@@ -54,7 +54,6 @@
         /// <param name="model">PalletNo:鎵樼洏鍙�</param> 
         /// <returns></returns>
         [HttpPost]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task<List<string>> GetRunSoNoticeList(PdaSoVm model)
         {
             return await _pdaSoSvc.GetRunSoNoticeList(model.PalletNo, model.Type);
@@ -66,7 +65,6 @@
         /// <param name="model">PalletNo:鎵樼洏鐮併�丼oNo:鍗曟嵁鍙�</param> 
         /// <returns></returns>
         [HttpPost]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task GetSoSkuLotNoListByPallet(PdaSoVm model)
         {
             var models = await _pdaSoSvc.GetSoSkuLotNoListByPallet(model.PalletNo, model.SoNo);
@@ -78,7 +76,6 @@
         /// <param name="model">SoDetailId:鍑哄簱鍗曟槑缁咺D銆丳alletNo:鎵樼洏鐮�</param> 
         /// <returns></returns>
         [HttpPost]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task<OutPdaInfo> GetOutlets(PdaSoVm model)
         {
             return await _pdaSoSvc.GetOutlets(model.SoDetailId, model.PalletNo);
@@ -90,7 +87,6 @@
         /// <param name="model">SoDetailId:鍑哄簱鍗曟槑缁咺D</param> 
         /// <returns></returns>
         [HttpPost]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task<OutPdaInfo> GetPlanAndFinishQty(PdaSoVm model)
         {
             return await _pdaSoSvc.GetPlanAndFinishQty(model.SoDetailId);
@@ -102,7 +98,6 @@
         /// <param name="model">BoxNo:绠辩爜鍙�</param> 
         /// <returns></returns>
         [HttpPost]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task<dynamic> GetDataComBoxInfo(PdaSoVm model)
         {
             return await _pdaSoSvc.GetDataComBoxInfo(model.SoDetailId, model.PalletNo, model.BoxNo, model.BoxNo3);
@@ -114,7 +109,6 @@
         /// <param name="model">BoxNo:绠辩爜鍙�</param> 
         /// <returns></returns>
         [HttpPost]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task<dynamic> GetAllotPlnInfo(PdaSoVm model)
         {
             return await _pdaSoSvc.GetAllotPlnInfo(model.SoDetailId, model.PalletNo);
@@ -126,7 +120,6 @@
         /// <param name="model">SoDetailId:鍑哄簱鍗曟槑缁咺D銆丳alletNo:鎵樼洏鐮�</param> 
         /// <returns></returns>
         [HttpPost]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task SoSetPick(PdaSoVm model)
         {
             await _pdaSoSvc.SoSetPick(model.SoNo, model.SoDetailId, model.PalletNo, model.BoxNo, model.BoxNo3, model.PickQty, _userManager.UserId);
@@ -138,7 +131,6 @@
         /// <param name="model">SoDetailId:鍑哄簱鍗曟槑缁咺D銆丳alletNo:鎵樼洏鐮�</param> 
         /// <returns></returns>
         [HttpPost]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task SoSetQtyPick(PdaSoVm model)
         {
             await _pdaSoSvc.SoSetQtyPick(model.SoNo, model.SoDetailId, model.PalletNo, model.PickQty, _userManager.UserId);
@@ -151,7 +143,6 @@
         /// <param name="model">绌烘墭鐩樺嚭搴�</param>
         /// <returns></returns>
         [HttpPost]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task<string> IssuePlnOutHouse(OutModePalletVm model)
         {
             return await _pdaSoSvc.IssuePlnOutHouse(model, _userManager.UserId, _config.WcsHost + _config.IssueComApiUrl);
@@ -166,7 +157,6 @@
         /// <param name="palletNo">鎵樼洏鍙�</param>
         /// <returns></returns>
         [HttpGet]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task<dynamic> GetPingKuInfoByPallet(string soNo, string palletNo)
         {
             return await _pdaSoSvc.GetPingKuInfoByPallet(soNo, palletNo);
@@ -179,7 +169,6 @@
         /// <param name="palletNo">鎵樼洏鍙�</param>
         /// <returns></returns>
         [HttpGet]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task PlaneExportSuccess(string soNo, string palletNo)
         {
             await _pdaSoSvc.PlaneExportSuccess(soNo, palletNo, _userManager.UserId);
@@ -192,7 +181,6 @@
         /// <param name="palletNo">鎵樼洏鍙�</param>
         /// <returns></returns>
         [HttpGet]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task<string> GetSampleType(string palletNo)
         {
             return await _pdaSoSvc.GetSampleType(palletNo);
@@ -204,7 +192,6 @@
         /// <param name="palletNo">鎵樼洏鍙�</param>
         /// <returns></returns>
         [HttpGet]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task<List<string>> GetAsnNoByPallet(string palletNo)
         {
             return await _pdaSoSvc.GetAsnNoByPallet(palletNo);
@@ -215,7 +202,6 @@
         /// <param name="model"></param>
         /// <returns></returns>
         [HttpPost]
-        [ServiceFilter(typeof(ApiResponseActionFilter))]
         public async Task SampleSoSetPick(PdaSoVm model)
         {
             await _pdaSoSvc.SampleSoSetPick(model.Type, model.SoNo, model.SoDetailId, model.PalletNo, model.BoxNo, model.BoxNo3, model.PickQty, model.AsnNo, _userManager.UserId);
@@ -226,30 +212,9 @@
         /// <param name="model">SoDetailId:鍑哄簱鍗曟槑缁咺D銆丳alletNo:鎵樼洏鐮�</param> 
         /// <returns></returns>
         [HttpPost]
-        public IActionResult SampleSoSetQtyPick(PdaSoVm model)
+        public async Task SampleSoSetQtyPick(PdaSoVm model)
         {
-            try
-            {
-                //鑾峰彇褰撳墠鐧诲綍鐨勭敤鎴稩D
-                var claimsIdentity = this.User.Identity as ClaimsIdentity;
-                if (claimsIdentity == null)
-                {
-                    return Ok(new { code = 1, msg = "鏈幏鍙栧埌褰撳墠鎿嶄綔浜轰俊鎭�" });
-                }
-                var userId = claimsIdentity.FindFirst(ClaimTypes.Name)?.Value;
-                if (string.IsNullOrWhiteSpace(userId))
-                {
-                    return Ok(new { code = 1, msg = "鏈幏鍙栧埌褰撳墠鎿嶄綔浜轰俊鎭�" });
-                }
-
-                _pdaSoSvc.SampleSoSetQtyPick(model.Type, model.SoNo, model.SoDetailId, model.PalletNo, model.PickQty, model.AsnNo, int.Parse(userId));
-
-                return Ok(new { data = "", code = 0, msg = "(鏃犳爣绛�)鍙栨牱鍑哄簱鎷ｈ揣" });
-            }
-            catch (Exception e)
-            {
-                return Ok(new { data = "", code = 1, msg = "(鏃犳爣绛�)鍙栨牱鍑哄簱鎷ｈ揣閿欒锛�" + e.Message });
-            }
+            await _pdaSoSvc.SampleSoSetQtyPick(model.Type, model.SoNo, model.SoDetailId, model.PalletNo, model.PickQty, model.AsnNo, _userManager.UserId);
         }
         #region 鎷ｈ揣鎷兼墭
         /// <summary>
@@ -258,29 +223,9 @@
         /// <param name="model"></param>
         /// <returns></returns>
         [HttpPost]
-        public IActionResult SoSetPinPick(PdaSoVm model)
+        public async Task SoSetPinPick(PdaSoVm model)
         {
-            try
-            {
-                //鑾峰彇褰撳墠鐧诲綍鐨勭敤鎴稩D
-                var claimsIdentity = this.User.Identity as ClaimsIdentity;
-                if (claimsIdentity == null)
-                {
-                    return Ok(new { code = 1, msg = "鏈幏鍙栧埌褰撳墠鎿嶄綔浜轰俊鎭�" });
-                }
-                var userId = claimsIdentity.FindFirst(ClaimTypes.Name)?.Value;
-                if (string.IsNullOrWhiteSpace(userId))
-                {
-                    return Ok(new { code = 1, msg = "鏈幏鍙栧埌褰撳墠鎿嶄綔浜轰俊鎭�" });
-                }
-
-                _pdaSoSvc.SoSetPinPick(model.SoNo, model.SoDetailId, model.PalletNo, model.BoxNo, model.BoxNo3, model.PickQty, model.PalletNoNew, int.Parse(userId));
-                return Ok(new { code = 0, msg = "鎷ｈ揣瀹屾垚", data = "" });
-            }
-            catch (Exception e)
-            {
-                return Ok(new { code = 1, msg = e.Message });
-            }
+            await _pdaSoSvc.SoSetPinPick(model.SoNo, model.SoDetailId, model.PalletNo, model.BoxNo, model.BoxNo3, model.PickQty, model.PalletNoNew, _userManager.UserId);
         }
         /// <summary>
         /// 鎷兼墭鍑哄簱pda鎷ｈ揣-鏁伴噺
@@ -288,30 +233,9 @@
         /// <param name="model"></param>
         /// <returns></returns>
         [HttpPost]
-        public IActionResult SoSetQtyPinPick(PdaSoVm model)
+        public async Task SoSetQtyPinPick(PdaSoVm model)
         {
-            try
-            {
-                //鑾峰彇褰撳墠鐧诲綍鐨勭敤鎴稩D
-                var claimsIdentity = this.User.Identity as ClaimsIdentity;
-                if (claimsIdentity == null)
-                {
-                    return Ok(new { code = 1, msg = "鏈幏鍙栧埌褰撳墠鎿嶄綔浜轰俊鎭�" });
-                }
-                var userId = claimsIdentity.FindFirst(ClaimTypes.Name)?.Value;
-                if (string.IsNullOrWhiteSpace(userId))
-                {
-                    return Ok(new { code = 1, msg = "鏈幏鍙栧埌褰撳墠鎿嶄綔浜轰俊鎭�" });
-                }
-
-                _pdaSoSvc.SoSetQtyPinPick(model.SoNo, model.SoDetailId, model.PalletNo, model.PickQty, model.PalletNoNew, int.Parse(userId));
-
-                return Ok(new { code = 0, msg = "鎷ｈ揣瀹屾垚", data = "" });
-            }
-            catch (Exception e)
-            {
-                return Ok(new { code = 1, msg = e.Message });
-            }
+            await _pdaSoSvc.SoSetQtyPinPick(model.SoNo, model.SoDetailId, model.PalletNo, model.PickQty, model.PalletNoNew, _userManager.UserId);
         }
         #endregion
 
@@ -324,19 +248,9 @@
         /// <param name="palletNo">鎵樼洏鍙�</param>
         /// <returns></returns>
         [HttpGet]
-        public IActionResult GetSampleType2(string palletNo)
+        public async Task<string> GetSampleType2(string palletNo)
         {
-            try
-            {
-                var type = _pdaSoSvc.GetSampleType2(palletNo);
-
-                return Ok(new { data = type, code = 0, msg = "鏍规嵁鎵樼洏鍙疯幏鍙栧彇鏍风被鍨�" });
-            }
-            catch (Exception e)
-            {
-                return Ok(new { data = "", code = 1, msg = "鏍规嵁鎵樼洏鍙疯幏鍙栧彇鏍风被鍨嬶細" + e.Message });
-            }
-
+            return await _pdaSoSvc.GetSampleType2(palletNo);
         }
 
         /// <summary>
@@ -344,19 +258,9 @@
         /// </summary>
         /// <returns></returns>
         [HttpGet]
-        public IActionResult GetInspectionNo()
+        public async Task<List<string>> GetInspectionNo()
         {
-            try
-            {
-                var qcNoStr = _pdaSoSvc.GetInspectionNo();
-
-                return Ok(new { data = qcNoStr, code = 0, msg = "鑾峰彇寰呭嚭搴撴垨寰呭彇鏍风殑璇烽獙鍗�" });
-            }
-            catch (Exception e)
-            {
-                return Ok(new { data = "", code = 1, msg = "鑾峰彇寰呭嚭搴撴垨寰呭彇鏍风殑璇烽獙鍗曪細" + e.Message });
-            }
-
+            return await _pdaSoSvc.GetInspectionNo();
         }
 
         /// <summary>
@@ -365,19 +269,9 @@
         /// <param name="qcNo">璇烽獙鍗�</param>
         /// <returns></returns>
         [HttpGet]
-        public IActionResult GetInspectionRequestInfo(string qcNo)
+        public async Task<InspectionRequestDto> GetInspectionRequestInfo(string qcNo)
         {
-            try
-            {
-                var info = _pdaSoSvc.GetInspectionRequestInfo(qcNo);
-
-                return Ok(new { data = info, code = 0, msg = "鑾峰彇璇烽獙鍗曠浉鍏充俊鎭�" });
-            }
-            catch (Exception e)
-            {
-                return Ok(new { data = "", code = 1, msg = "鑾峰彇璇烽獙鍗曠浉鍏充俊鎭細" + e.Message });
-            }
-
+            return await _pdaSoSvc.GetInspectionRequestInfo(qcNo);
         }
 
         /// <summary>
@@ -386,31 +280,9 @@
         /// <param name="model"></param>
         /// <returns></returns>
         [HttpPost]
-        public IActionResult SampleSetPick(SampleSoVm model)
+        public async Task SampleSetPick(SampleSoVm model)
         {
-            try
-            {
-                var claimsIdentity = this.User.Identity as ClaimsIdentity;
-                if (claimsIdentity == null)
-                {
-                    throw new Exception("鏈幏鍙栧埌鐢ㄦ埛淇℃伅");
-                }
-                string UserId = claimsIdentity.FindFirst(ClaimTypes.Name)?.Value;
-                if (string.IsNullOrWhiteSpace(UserId))
-                {
-                    throw new Exception("鏈幏鍙栧埌鐢ㄦ埛淇℃伅");
-                }
-                int uid = Convert.ToInt32(UserId);
-
-                _pdaSoSvc.SampleSetPick(model.QcNo, model.PalletNo, model.BoxNo, model.BoxNo3, model.PickQty, uid);
-
-                return Ok(new { data = "", code = 0, msg = "(鏍囩)鍙栨牱鍑哄簱鎷ｈ揣" });
-            }
-            catch (Exception e)
-            {
-                return Ok(new { data = "", code = 1, msg = "(鏍囩)鍙栨牱鍑哄簱鎷ｈ揣閿欒锛�" + e.Message });
-            }
-
+            await _pdaSoSvc.SampleSetPick(model.QcNo, model.PalletNo, model.BoxNo, model.BoxNo3, model.PickQty, _userManager.UserId);
         }
 
         /// <summary>
@@ -419,31 +291,9 @@
         /// <param name="model"></param>
         /// <returns></returns>
         [HttpPost]
-        public IActionResult SampleSetQtyPick(SampleSoVm model)
+        public async Task SampleSetQtyPick(SampleSoVm model)
         {
-            try
-            {
-                var claimsIdentity = this.User.Identity as ClaimsIdentity;
-                if (claimsIdentity == null)
-                {
-                    throw new Exception("鏈幏鍙栧埌鐢ㄦ埛淇℃伅");
-                }
-                string UserId = claimsIdentity.FindFirst(ClaimTypes.Name)?.Value;
-                if (string.IsNullOrWhiteSpace(UserId))
-                {
-                    throw new Exception("鏈幏鍙栧埌鐢ㄦ埛淇℃伅");
-                }
-                int uid = Convert.ToInt32(UserId);
-
-                _pdaSoSvc.SampleSetQtyPick(model.QcNo, model.PalletNo, model.PickQty, uid);
-
-                return Ok(new { data = "", code = 0, msg = "(鏁伴噺)鍙栨牱鍑哄簱鎷ｈ揣" });
-            }
-            catch (Exception e)
-            {
-                return Ok(new { data = "", code = 1, msg = "(鏁伴噺)鍙栨牱鍑哄簱鎷ｈ揣閿欒锛�" + e.Message });
-            }
-
+            await _pdaSoSvc.SampleSetQtyPick(model.QcNo, model.PalletNo, model.PickQty, _userManager.UserId);
         }
 
         #endregion

--
Gitblit v1.8.0