From 266afcd9d3b53e97b9a81e61efd095bbdbc8de9e Mon Sep 17 00:00:00 2001
From: tjx <t2856754968@163.com>
Date: 星期五, 17 十月 2025 01:17:27 +0800
Subject: [PATCH] 同步为建辉的版本
---
service/QC/IpqcService.cs | 10 ++++++----
1 files changed, 6 insertions(+), 4 deletions(-)
diff --git a/service/QC/IpqcService.cs b/service/QC/IpqcService.cs
index df1c963..baac2bc 100644
--- a/service/QC/IpqcService.cs
+++ b/service/QC/IpqcService.cs
@@ -1,12 +1,14 @@
-锘縰sing MES.Service.Models;
-using Microsoft.IdentityModel.Tokens;
+锘縰sing Microsoft.IdentityModel.Tokens;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
+using NewPdaSqlServer.entity;
using NewPdaSqlServer.util;
using SqlSugar;
using System.Data;
using System.Data.SqlClient;
using System.Text;
+using static Azure.Core.HttpHeader;
+using static Microsoft.EntityFrameworkCore.DbLoggerCategory;
using DbHelperSQL = NewPdaSqlServer.DB.DbHelperSQL;
namespace NewPdaSqlServer.service.QC;
@@ -76,12 +78,12 @@
WHERE C.parent_guid = A.guid), 0) AS [YbslIn]
FROM [MES_QA_ITEMS_DETECT_DETAIL5] [a]
Left JOIN [MES_QA_ITEMS_DETECT_DETAIL12] [b] ON ([a].[guid] = [b].[parent_guid])
-WHERE ([a].[release_no] = N'{0}' AND IS_GWSCAN = 1)
+WHERE ([a].[release_no] = N'{0}')
GROUP BY [a].[guid], [a].[parent_guid], [a].[release_no], [a].[fac_level], [a].[fcheck_item], [a].[fcheck_tool],
[a].[fdown_allow], [a].[fcheck_level], [a].[fstand], [a].[fup_allow], [a].[sample_size_no], [a].[fspec_requ],
[a].[fre_qty], [a].[check_qyt], [a].[fcheck_resu], [a].[forder], [a].[ybsl], [a].stationName,
[a].IS_GWSCAN
-ORDER BY [a].[forder] ASC", releaseNo);
+ORDER BY [a].[forder] , [a].[fcheck_item] ASC", releaseNo);
var Ybsl_In = Db.Ado.SqlQuery<dynamic>(sql).ToList();
--
Gitblit v1.9.3