From 3296c70dfc999ff1d09ac28d6205197c11825c5f Mon Sep 17 00:00:00 2001 From: zjh <2207896513@qq.com> Date: 星期四, 22 五月 2025 14:58:26 +0800 Subject: [PATCH] 1,来料检添加‘往期检验履历’,‘最大抽检数量’两个字段 2,一致性核对添加图片是否上传校验 --- StandardPda/MES.Service/service/LoginService.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/StandardPda/MES.Service/service/LoginService.cs b/StandardPda/MES.Service/service/LoginService.cs index f123d70..79ee359 100644 --- a/StandardPda/MES.Service/service/LoginService.cs +++ b/StandardPda/MES.Service/service/LoginService.cs @@ -16,7 +16,7 @@ SELECT LISTAGG(ROLEID, ',') WITHIN GROUP (ORDER BY ROLEID) AS ROLEIDS,userid FROM SYS_USER_ROLE GROUP BY userid - )B on b.USERID=a.FID where FCODE = '{0}'", + )B on b.USERID=a.FID where upper(FCODE)=upper('{0}')", name); var dataTable = SQLHelper.ExecuteQuery(sql); if (dataTable.Rows.Count <= 0) throw new Exception("鐢ㄦ埛涓嶅瓨鍦�"); -- Gitblit v1.9.3