From f90ec957dbc918e87efb9cb506210d7939fc8301 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期二, 07 五月 2024 14:08:16 +0800 Subject: [PATCH] 生产计划平台优化 --- WebAPI/Controllers/WebAPIController.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 31c8db2..9f163d1 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -11473,7 +11473,7 @@ string sql = string.Format(@"select b.HDotCheckItemID HDotCheckItemID,c.HNumber HDotCheckCode,b.HDotCheckItem,b.HDotCheckPart,b.HClaim, b.HManagerID,e.HNumber HManagerCode,e.HName HManagerName,b.HRemark from Sb_EquipDotCheckRuleBillMain a left join Sb_EquipDotCheckRuleBillSub b on a.HInterID=b.HInterID - left join Gy_QCCheckItem c on c.HItemID=b.HDotCheckItemID + left join Gy_DotCheck c on c.HItemID=b.HDotCheckItemID left join Gy_Employee e on e.HItemID=b.HManagerID where a.HInterID=" + HDotCheckRuleInterID); ds = oCN.RunProcReturn(sql, "Sb_EquipDotCheckRuleBillMain"); -- Gitblit v1.9.1