From dabfdd9dbf0364b1134daaad86af7e13f6437295 Mon Sep 17 00:00:00 2001
From: xwt <2740516069@qq.com>
Date: 星期四, 30 十月 2025 12:40:30 +0800
Subject: [PATCH] XJ,SJ,RKJ检验项目序号，LLJ单个检验项目FTP附件信息
---
StandardInterface/MES.Service/service/QC/BaseService.cs | 77 ++++++++++++++++++++++++++++++++++++++
1 files changed, 77 insertions(+), 0 deletions(-)
diff --git a/StandardInterface/MES.Service/service/QC/BaseService.cs b/StandardInterface/MES.Service/service/QC/BaseService.cs
index a827168..87bc106 100644
--- a/StandardInterface/MES.Service/service/QC/BaseService.cs
+++ b/StandardInterface/MES.Service/service/QC/BaseService.cs
@@ -49,4 +49,81 @@
});
return mesQsImages;
}
+
+ /// <summary>
+ /// 鑾峰彇QC杞﹂棿鍒楄〃锛堟牴鎹鍥� V_MES_QC_CJ锛�
+ /// </summary>
+ /// <returns>杞﹂棿鍒楄〃</returns>
+ public List<dynamic> GetQCDepartments()
+ {
+ var db = SqlSugarHelper.GetInstance();
+ var sql = @"
+ SELECT
+ T.DEPARTMENTNAME as departmentname,
+ T.DEPARTMENTID as departmentid
+ FROM SYS_DEPARTMENT T
+ WHERE T.DEPARTMENTID IN (
+ 2951904,2951874,2973564,3131720,3252567,3306857,3335722,2306534,2670262,
+ 2365021,2365022,2749927,2306535,2558979,2558980,2558981,2558982,1606194,
+ 1608020,1608021,1606193,1608022,1638037,1682634,1802281,1802278,1802279,
+ 1802280,1999190,1999191,2272979,2513368,2513369,2513370,2513371,2558971,
+ 2558972,2558973,2558974,2558975,2558976,2558977,2749970,2749946,2749947,
+ 2749948,2670253,2670258,2670260,2513372,2513373,2513374,2513375,2513376,
+ 2670261,139517,139518,139519,209814,211639,221640,378794,440720,441918,
+ 441919,502188,507542,507545,507546,139524
+ )
+ ORDER BY T.DEPARTMENTNAME";
+
+ return db.Ado.SqlQuery<dynamic>(sql);
+ }
+
+ /// <summary>
+ /// 鑾峰彇QC绾夸綋鍒楄〃锛堟牴鎹溅闂碔D绛涢�夛紝鍩轰簬瑙嗗浘 V_MES_QC_XT锛�
+ /// </summary>
+ /// <param name="departmentId">杞﹂棿ID锛屽鏋滀负绌哄垯杩斿洖鎵�鏈塓C绾夸綋</param>
+ /// <returns>绾夸綋鍒楄〃</returns>
+ public List<MesLine> GetQCLines(string? departmentId)
+ {
+ var db = SqlSugarHelper.GetInstance();
+
+ if (string.IsNullOrEmpty(departmentId))
+ {
+ // 濡傛灉娌℃湁鎸囧畾杞﹂棿锛岃繑鍥炴墍鏈塓C绾夸綋
+ var sql = @"
+ SELECT E.LINE_NO as LineNo, E.LINE_NAME as LineName, E.DEPOT_ID as DepotId
+ FROM MES_LINE E
+ LEFT JOIN (
+ SELECT T.DEPARTMENTID
+ FROM SYS_DEPARTMENT T
+ WHERE T.DEPARTMENTID IN (
+ 2951904,2951874,2973564,3131720,3252567,3306857,3335722,2306534,2670262,
+ 2365021,2365022,2749927,2306535,2558979,2558980,2558981,2558982,1606194,
+ 1608020,1608021,1606193,1608022,1638037,1682634,1802281,1802278,1802279,
+ 1802280,1999190,1999191,2272979,2513368,2513369,2513370,2513371,2558971,
+ 2558972,2558973,2558974,2558975,2558976,2558977,2749970,2749946,2749947,
+ 2749948,2670253,2670258,2670260,2513372,2513373,2513374,2513375,2513376,
+ 2670261,139517,139518,139519,209814,211639,221640,378794,440720,441918,
+ 441919,502188,507542,507545,507546,139524
+ )
+ ) C ON C.DEPARTMENTID = E.DEPOT_ID
+ WHERE C.DEPARTMENTID IS NOT NULL
+ ORDER BY E.LINE_NO DESC";
+
+ return db.Ado.SqlQuery<MesLine>(sql);
+ }
+ else
+ {
+ // 濡傛灉鎸囧畾浜嗚溅闂达紝鍙繑鍥炶杞﹂棿涓嬬殑绾夸綋
+ return db.Queryable<MesLine>()
+ .Where(e => e.DepotId.ToString() == departmentId)
+ .OrderBy(e => e.LineNo, SqlSugar.OrderByType.Desc)
+ .Select(e => new MesLine
+ {
+ LineNo = e.LineNo,
+ LineName = e.LineName,
+ DepotId = e.DepotId
+ })
+ .ToList();
+ }
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3