From 9b6d6f7f6b89c80edbef8da32feb0cf504a7c523 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期三, 27 十一月 2024 22:38:53 +0800 Subject: [PATCH] 采购退料 --- service/QC/LljService.cs | 31 +++++++++++-------------------- 1 files changed, 11 insertions(+), 20 deletions(-) diff --git a/service/QC/LljService.cs b/service/QC/LljService.cs index d46b42c..64962c0 100644 --- a/service/QC/LljService.cs +++ b/service/QC/LljService.cs @@ -1,12 +1,9 @@ -锘縰sing System.Data; -using Microsoft.IdentityModel.Tokens; +锘縰sing Microsoft.IdentityModel.Tokens; using NewPdaSqlServer.DB; using NewPdaSqlServer.Dto.service; using NewPdaSqlServer.entity; using NewPdaSqlServer.util; using SqlSugar; -using DbType = System.Data.DbType; - namespace NewPdaSqlServer.service.QC; @@ -17,7 +14,7 @@ var parsedGuid = Guid.Empty; if (!queryObj.id.IsNullOrEmpty()) { - bool isValid = Guid.TryParse(queryObj.id, out parsedGuid); + var isValid = Guid.TryParse(queryObj.id, out parsedGuid); if (!isValid) throw new ApplicationException("GUID杞崲閿欒"); } @@ -74,7 +71,7 @@ mesQaIqcItem.ForEach(item => { - string LEV = item.FcheckLevel switch + var LEV = item.FcheckLevel switch { null => "" // 榛樿鍊� , @@ -402,12 +399,9 @@ { var rkjDto = new LLJDto(); - bool isValid = Guid.TryParse(id, out var parsedGuid); + var isValid = Guid.TryParse(id, out var parsedGuid); - if (!isValid) - { - throw new Exception("GUID杞崲閿欒"); - } + if (!isValid) throw new Exception("GUID杞崲閿欒"); var qsItemOqcItem = Db.Queryable<MesQaItemsDetectDetail5>() @@ -502,10 +496,9 @@ //瀛愯〃淇敼澶囨敞瀛楁 public int saveRemarksPid(LLJDto dto) { - bool isValid = Guid.TryParse(dto.pid, out var parsedGuid); + var isValid = Guid.TryParse(dto.pid, out var parsedGuid); if (isValid) - { return UseTransaction(db => { return db.Updateable<MesQaItemsDetectDetail5>() @@ -514,7 +507,6 @@ .Where(it => it.Guid == parsedGuid) .ExecuteCommand(); }); - } throw new Exception("GUID杞崲閿欒"); } @@ -577,11 +569,9 @@ { mesQaItemsDetectDetail5.FenterQty ??= 0; if (mesQaItemsDetectDetail5.FenterQty == 0) - { throw new Exception("妫�楠岄」鐩�:" + mesQaItemsDetectDetail5.FcheckItem + " 宸插綍鍏ユ暟閲忎负0锛岃纭銆�"); - } } var com = UseTransaction(db => @@ -643,7 +633,7 @@ TotalOkRkQty = SqlFunc.AggregateSum(b.OkRkqty) }) .First(); - + var totalQuantity = first.TotalQuantity ?? 0; var totalOkRkQty = first.TotalOkRkQty ?? 0; @@ -658,12 +648,13 @@ executeCommand += db.Updateable<MesInvItemArnDetail>() .SetColumns(s => s.CheckStates == "涓嶅悎鏍煎緟瀹℃壒") .SetColumns(s => s.Ischeck == 1) - .SetColumns(s => s.CheckRes == mesQaItemsDetect01.FcheckResu) + .SetColumns( + s => s.CheckRes == mesQaItemsDetect01.FcheckResu) .SetColumns(s => s.CheckDate == DateTime.Now) .Where(s => s.ParentGuid == mesInvItemArn.Guid && s.ItemId == mesQaItemsDetect01.ItemId) .ExecuteCommand(); - + executeCommand += db.Updateable<MesQaItemsDetect01>() .SetColumns(s => s.IqcDate == DateTime.Now) .SetColumns(s => s.FcheckDate == DateTime.Now) @@ -672,7 +663,7 @@ .ExecuteCommand(); } - if (executeCommand >=3) + if (executeCommand >= 3) return executeCommand; throw new Exception("鏇存柊澶辫触"); -- Gitblit v1.9.3