From 251dfa31818b7ae1803117b72376b82841f0c542 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期二, 24 九月 2024 14:49:33 +0800 Subject: [PATCH] 入库检增加用户数据权限 --- MES.Service/service/QC/LljService.cs | 16 ++++++---------- 1 files changed, 6 insertions(+), 10 deletions(-) diff --git a/MES.Service/service/QC/LljService.cs b/MES.Service/service/QC/LljService.cs index f43ca58..3e4fa9a 100644 --- a/MES.Service/service/QC/LljService.cs +++ b/MES.Service/service/QC/LljService.cs @@ -112,10 +112,8 @@ } if (string.IsNullOrEmpty(LEV)) - { - throw new Exception(item.SampleSizeNo+"鐨勬楠屾按骞充笉姝g‘"); - } - + throw new Exception(item.SampleSizeNo + "鐨勬楠屾按骞充笉姝g‘"); + var sql = "SELECT " + LEV + " FROM MES_QM_AQL1 A LEFT JOIN MES_QM_AQL2 B ON B.AQL1_ID=A.ID WHERE A.SAMPLE_SIZE_NO='" + @@ -126,16 +124,14 @@ var maxBillNo = db.Ado.SqlQuerySingle<string>(sql); if (string.IsNullOrEmpty(maxBillNo)) - { - throw new Exception(item.SampleSizeNo+"涓嬬殑"+quantity+"杩欎釜鑼冨洿涓嬫病鏈夊尮閰嶅埌妫�楠岄」鐩�"); - } + throw new Exception(item.SampleSizeNo + "涓嬬殑" + quantity + + "杩欎釜鑼冨洿涓嬫病鏈夊尮閰嶅埌妫�楠岄」鐩�"); var result = ExtractSubstring(item.FacLevel, '(', ')'); if (string.IsNullOrEmpty(result)) - { - throw new Exception(item.SampleSizeNo+"涓嬬殑"+quantity+"鎷掓敹姘村钩涓嶆纭�"); - } + throw new Exception(item.SampleSizeNo + "涓嬬殑" + quantity + + "鎷掓敹姘村钩涓嶆纭�"); sql = "SELECT FSAMPLE_SIZE_WORD, " + result + " Result FROM MES_QM_AQL1 A LEFT JOIN MES_QM_AQL3 C ON C.AQL1_ID=A.ID WHERE A.SAMPLE_SIZE_NO= '" + -- Gitblit v1.9.3