From 76cdb99e924eebdd5025584c103fa9bfdf0adecc Mon Sep 17 00:00:00 2001 From: zjh <2207896513@qq.com> Date: 星期一, 12 五月 2025 19:14:11 +0800 Subject: [PATCH] 获取所有检验单图片接口上传 --- StandardPda/MES.Service/service/QC/LljService.cs | 11 +++++++++++ 1 files changed, 11 insertions(+), 0 deletions(-) diff --git a/StandardPda/MES.Service/service/QC/LljService.cs b/StandardPda/MES.Service/service/QC/LljService.cs index 2659e0b..9689a68 100644 --- a/StandardPda/MES.Service/service/QC/LljService.cs +++ b/StandardPda/MES.Service/service/QC/LljService.cs @@ -762,6 +762,17 @@ } return Components; } + + public DataTable getBlmsItem() + { + OracleSQLHelper SQLHelper = new(); + //鏌ヤ笉鑹弿杩� + var sql1 = string.Format(@"select DEFECT_NAME + from MES_DEFECT_CODE A + left join MES_DEFECT_TYPE X ON X.TYPE_NO = A.DEFECT_SORT AND X.COMPANY = A.COMPANY AND X.FACTORY = A.FACTORY"); + + return SQLHelper.ExecuteQuery(sql1); + } public void saveYzxBDlist(string id,DataTable DB) { OracleSQLHelper SQLHelper = new(); -- Gitblit v1.9.3