From f2900f2e7a9fef2e536c34e8d8406ac60c0f06ba Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期四, 17 七月 2025 23:36:32 +0800 Subject: [PATCH] 添加首检的查询条件,添加首检,巡检返回总行数 --- StandardInterface/MES.Service/service/SRM/MesDeliveryNoteBarcodeManager.cs | 54 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 54 insertions(+), 0 deletions(-) diff --git a/StandardInterface/MES.Service/service/SRM/MesDeliveryNoteBarcodeManager.cs b/StandardInterface/MES.Service/service/SRM/MesDeliveryNoteBarcodeManager.cs index 782124d..38ae75e 100644 --- a/StandardInterface/MES.Service/service/SRM/MesDeliveryNoteBarcodeManager.cs +++ b/StandardInterface/MES.Service/service/SRM/MesDeliveryNoteBarcodeManager.cs @@ -36,6 +36,46 @@ return result.All(b => b); } + public dynamic DeleteByNo(ErpDelivery delivery) + { + return UseTransaction(db => + { + return DeleteDataByShd(db, delivery) ? 1 : 0; + }) > 0; + } + + public dynamic DeleteListByNo(List<ErpDelivery> delivery) + { + var result = delivery.Select(DeleteByNo).ToList(); + return result.All(b => b); + } + + public dynamic DeleteByItem(DeliveryItem dt) + { + return UseTransaction(db => + { + return DeleteDataByItem(db, dt) ? 1 : 0; + }) > 0; + } + + public dynamic DeleteListByItem(List<DeliveryItem> dts) + { + var result = dts.Select(DeleteByItem).ToList(); + return result.All(b => b); + } + + // 鍒犻櫎鏁版嵁鐨勬柟娉� + private bool DeleteDataByItem(SqlSugarScope db, DeliveryItem dt) + { + var del = db.Deleteable<MesDeliveryNoteBarcode>().Where(s => s.DeliveryNo == dt.DeliveryNo && s.ProductCode==dt.ItemNo).ExecuteCommand() > 0; + + if (del) + { + return true; + } + throw new NotImplementedException("鍒犻櫎澶辫触"); + } + // 鍒犻櫎鏁版嵁鐨勬柟娉� private bool DeleteData(SqlSugarScope db, ErpBarcode barcode) { @@ -47,6 +87,20 @@ throw new NotImplementedException("鍒犻櫎澶辫触"); } + // 鍒犻櫎鏁版嵁鐨勬柟娉� + private bool DeleteDataByShd(SqlSugarScope db, ErpDelivery delivery) + { + var del = db.Deleteable<MesDeliveryNoteBarcode>(). + Where(s => s.DeliveryNo == delivery.DeliveryNo) + .ExecuteCommand() > 0; + + if (del) + { + return true; + } + throw new NotImplementedException("鍒犻櫎澶辫触"); + } + // 鎻掑叆鎴栨洿鏂版暟鎹殑鏂规硶 private bool SaveOrUpdateData(SqlSugarScope db, MesDeliveryNoteBarcode mesDeliveryBarcode) { -- Gitblit v1.9.3