From 4ef0acfc95e9e654ae142f8d5b21d68c55ddfc8d Mon Sep 17 00:00:00 2001 From: 南骏 池 <chiffly@163.com> Date: 星期二, 27 五月 2025 10:37:04 +0800 Subject: [PATCH] 1.巡检新增扫描工单获取检验信息 --- service/Warehouse/MesXkyShdManager.cs | 6 ++++++ 1 files changed, 6 insertions(+), 0 deletions(-) diff --git a/service/Warehouse/MesXkyShdManager.cs b/service/Warehouse/MesXkyShdManager.cs index f86518d..3ab65b1 100644 --- a/service/Warehouse/MesXkyShdManager.cs +++ b/service/Warehouse/MesXkyShdManager.cs @@ -23,7 +23,13 @@ if (shdh.Count < 1) throw new Exception($"閫佽揣鍗曞彿銆恵unity.shdh}銆戜笉瀛樺湪鎴栨湭鍚屾!"); + // var sql3 = @"SELECT ISNULL((SELECT SUM(delivery_qty) FROM DELIVERY_NOTICE_DETAIL WHERE delivery_no = @shdh), 0) - + //ISNULL((SELECT SUM(include_qty) FROM TBL_BARCODE_INFORMATION WHERE delivery_no = @shdh), 0) AS Diffnum "; + // var diffNum = Db.Ado.SqlQuery<dynamic>(sql3, sqlParams).First(); + + // if (diffNum.Diffnum != 0) + // throw new Exception($"閫佽揣鍗曞彿銆恵unity.shdh}銆戞潯鐮佹湭鍏ㄩ儴鎵撳嵃鎴栨湭鍚屾锛屾棤娉曟敹璐э紒"); var sql2 = @"select D.item_no, D.item_name, -- Gitblit v1.9.3