From 2a52411bca70c10b4a8fe08ce44c2b47ef8ecbf7 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期四, 09 五月 2024 09:51:17 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs index 37a814a..4144b8a 100644 --- a/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs +++ b/WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs @@ -175,8 +175,8 @@ { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); - string sql1 = @"select 鐐规椤圭洰ID HDotCheckItemID,鐐规椤圭洰 HDotCheckItem,鐐规閮ㄤ綅 HDotCheckPart,鍏蜂綋瑕佹眰 HClaim,璐熻矗浜篒D HManagerID,璐熻矗浜轰唬鐮� HManagerNumber,璐熻矗浜� HManagerName,瀛愬娉� HRemark,b.HNumber 鐐规椤圭洰浠g爜 from h_v_Sb_EquipDotCheckRuleList a - left join Gy_QCCheckItem b on a.鐐规椤圭洰ID =b.HItemID where 1 = 1 "; + string sql1 = @"select * from h_v_Sb_EquipDotCheckRuleList a + left join Gy_DotCheck b on a.鐐规椤圭洰ID =b.HItemID where 1 = 1 "; string sql = sql1 + sqlWhere; ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckRuleList"); objJsonResult.code = "0"; -- Gitblit v1.9.1