blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2022-08-08 8560519c52cede92c33b89184f39844934c71de4 
 WebAPI/Controllers/WebAPIController.cs


@@ -3142,7 +3142,7 @@


            {


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                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 


                                    b.HManagerID,e.HNumber HManagerCode,e.HName HManagerName,b.HRemark,a.HInterID,a.HBillNo 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_Employee e on e.HItemID=b.HManagerID