From da3b2cfb3a34a7b1f83dcd9fc762b1d2459547dc Mon Sep 17 00:00:00 2001 From: zjh <2207896513@qq.com> Date: 星期四, 26 六月 2025 20:47:11 +0800 Subject: [PATCH] 添加退货申请单接口 --- StandardPda/MES.Service/service/QC/SJService.cs | 48 +++++++++++++++++++++++------------------------- 1 files changed, 23 insertions(+), 25 deletions(-) diff --git a/StandardPda/MES.Service/service/QC/SJService.cs b/StandardPda/MES.Service/service/QC/SJService.cs index db188ef..fcc93ec 100644 --- a/StandardPda/MES.Service/service/QC/SJService.cs +++ b/StandardPda/MES.Service/service/QC/SJService.cs @@ -103,8 +103,8 @@ return db .Queryable<MesQualityStandard>() - .Where(b => b.QsType == "1" && b.ItemNo == itemNo).Select( - b => new QsItemIpiItem + .Where(b => b.QsType == "1" && b.ItemNo == itemNo).Select(b => + new QsItemIpiItem { ProjName = b.ProjName, ItemMod = b.ItemMod, @@ -188,21 +188,20 @@ { var qsItemIpiReq = item.From; var qsItemIpiItems = item.Items; - SqlSugarHelper.UseTransactionWithOracle( - db => - { - qsItemIpiReq.StatusDate = DateTime.Now; - var pid = db.Insertable(qsItemIpiReq) - .ExecuteReturnIdentity(); - qsItemIpiReq.Id = pid; + SqlSugarHelper.UseTransactionWithOracle(db => + { + qsItemIpiReq.StatusDate = DateTime.Now; + var pid = db.Insertable(qsItemIpiReq) + .ExecuteReturnIdentity(); + qsItemIpiReq.Id = pid; - item.gid = pid; + item.gid = pid; - qsItemIpiItems.ForEach(s => s.Pid = pid); + qsItemIpiItems.ForEach(s => s.Pid = pid); - return db.Insertable(qsItemIpiItems) - .ExecuteCommand(); - }); + return db.Insertable(qsItemIpiItems) + .ExecuteCommand(); + }); item.Items = getQSItems(qsItemIpiReq.Id, null); //娌℃湁涓婁笅闄愮殑妫�楠岄」鐩嚜鍔ㄧ洏鐐逛负鍚堟牸 @@ -231,14 +230,13 @@ public QsItem SaveItem(QsItem item) { var qsItemIpiItems = item.Items; - SqlSugarHelper.UseTransactionWithOracle( - db => - { - qsItemIpiItems.ForEach(s => s.Pid = item.gid); + SqlSugarHelper.UseTransactionWithOracle(db => + { + qsItemIpiItems.ForEach(s => s.Pid = item.gid); - return db.Insertable(qsItemIpiItems) - .ExecuteCommand(); - }); + return db.Insertable(qsItemIpiItems) + .ExecuteCommand(); + }); item.Items = getQSItems(item.gid, null); //娌℃湁涓婁笅闄愮殑妫�楠岄」鐩嚜鍔ㄧ洏鐐逛负鍚堟牸 @@ -322,8 +320,8 @@ if (count == passCount) result = 1; - var useTransactionWithOracle = SqlSugarHelper.UseTransactionWithOracle( - db => + var useTransactionWithOracle = + SqlSugarHelper.UseTransactionWithOracle(db => { var commit = 0; commit += db.Updateable<QsItemIpiItem>() @@ -358,8 +356,8 @@ //鍚堟牸鐨勬楠岀粨鏋滅瓑浜庢�绘楠屾暟瑙嗕负鍚堟牸 if (icount == passCount) result = 1; - useTransactionWithOracle += SqlSugarHelper.UseTransactionWithOracle( - db => + useTransactionWithOracle += + SqlSugarHelper.UseTransactionWithOracle(db => { return db.Updateable<QsItemIpiReq>() .SetColumns(s => s.IsPass == result) -- Gitblit v1.9.3