From 302054e253f1550ee64430882786ec9a3920ec92 Mon Sep 17 00:00:00 2001
From: sjz <1240968267@qq.com>
Date: 星期六, 19 七月 2025 08:33:44 +0800
Subject: [PATCH] 优化多组织代码
---
MES.Service/service/QC/XJService.cs | 15 +++++++--------
1 files changed, 7 insertions(+), 8 deletions(-)
diff --git a/MES.Service/service/QC/XJService.cs b/MES.Service/service/QC/XJService.cs
index 411d623..145d6cc 100644
--- a/MES.Service/service/QC/XJService.cs
+++ b/MES.Service/service/QC/XJService.cs
@@ -160,20 +160,19 @@
}
- public List<QsQaItemXj01> setJYItem(decimal itemId)
+ public List<QsQaItemXj01> setJYItem(string itemNo)
{
var db = SqlSugarHelper.GetInstance();
- var count = db.Queryable<MesQa>().Where(s => s.QsType == "2"
- && s.ItemId == itemId && s.Fsubmit == 1).Count();
+ var count = db.Queryable<MesQa>().Where(s =>
+ s.QsType == "2" && s.ItemNo == itemNo && s.Fsubmit == 1).Count();
if (count <= 0) return new List<QsQaItemXj01>();
return db
.Queryable<MesQualityStandard>()
- .Where(b => b.QsType == "2"
- && b.ItemId == itemId).Select(
- b => new QsQaItemXj01
+ .Where(b => b.QsType == "2" && b.ItemNo == itemNo).Select(b =>
+ new QsQaItemXj01
{
ProjName = b.ProjName,
ItemMod = b.ItemMod,
@@ -401,8 +400,8 @@
if (count == passCount) result = 1;
- var useTransactionWithOracle = SqlSugarHelper.UseTransactionWithOracle(
- db =>
+ var useTransactionWithOracle =
+ SqlSugarHelper.UseTransactionWithOracle(db =>
{
var commit = 0;
commit += db.Updateable<QsQaItemXj01>()
--
Gitblit v1.9.3