From ea79dd023ae2785d301e88b8133c0d5f553674cb Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期日, 31 八月 2025 21:59:02 +0800
Subject: [PATCH] 1.库位查询组织权限区分 2.PDA多组织切换
---
service/QC/IpqcService.cs | 22 ++++++++++++++++------
1 files changed, 16 insertions(+), 6 deletions(-)
diff --git a/service/QC/IpqcService.cs b/service/QC/IpqcService.cs
index d9bcc43..d477004 100644
--- a/service/QC/IpqcService.cs
+++ b/service/QC/IpqcService.cs
@@ -93,6 +93,10 @@
public (List<VIpqcXj> item, int TotalCount) getPageXj(XJPageResult queryObj)
{
+
+
+
+ var totalCount = 0;
var parsedGuid = Guid.Empty;
if (!queryObj.id.IsNullOrEmpty())
{
@@ -100,10 +104,6 @@
if (!isValid)
throw new ApplicationException("GUID杞崲閿欒");
}
-
-
- var totalCount = 0;
-
//var pageList = Db.Queryable<VIpqcXj>()
// .WhereIF(!string.IsNullOrWhiteSpace(queryObj.keyword), a =>
// a.ItemNo.Contains(queryObj.keyword) ||
@@ -168,9 +168,19 @@
AND TRY_CONVERT(date, SUBSTRING([check_time_slot], 1, 10)) = CAST(GETDATE() AS date)
AND CAST(GETDATE() AS time) >= '17:00:00'
)
- )");
+ )
+ {0}",
+ parsedGuid != Guid.Empty ? "AND guid = @parsedGuid" : ""); // 鏂板GUID杩囨护鏉′欢
- var pageList = Db.Ado.SqlQuery<VIpqcXj>(sql).ToList();
+
+
+
+
+ var sqlParams = new List<SugarParameter> {
+ new("@parsedGuid", parsedGuid) // 鏂板鍙傛暟
+ };
+
+ var pageList = Db.Ado.SqlQuery<VIpqcXj>(sql,sqlParams).ToList();
return (pageList, totalCount);
}
--
Gitblit v1.9.3