From 148e3eea1fea2d45ab135c6e66e69d163a4dd811 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期五, 28 二月 2025 16:19:53 +0800
Subject: [PATCH] 代码提交
---
StandardPda/MES.Service/service/QC/BaseService.cs | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 53 insertions(+), 0 deletions(-)
diff --git a/StandardPda/MES.Service/service/QC/BaseService.cs b/StandardPda/MES.Service/service/QC/BaseService.cs
new file mode 100644
index 0000000..d99828f
--- /dev/null
+++ b/StandardPda/MES.Service/service/QC/BaseService.cs
@@ -0,0 +1,53 @@
+锘縰sing MES.Service.DB;
+using MES.Service.Modes;
+
+namespace MES.Service.service.QC;
+
+public class BaseService
+{
+ // public string?[] getUserLineNo(string userNo)
+ // {
+ // //MesLineUser
+ // var db = SqlSugarHelper.GetInstance();
+ // var mesLineUsers = db.Queryable<MesLineUser>()
+ // .Where(a => a.Fcode == userNo)
+ // .ToList();
+ // // 浣跨敤 Distinct 鏂规硶瀵� LineNo 杩涜鍘婚噸
+ // return mesLineUsers.Select(s => s.LineNo).Distinct().ToArray();
+ // }
+
+ public int saveImage(List<MesQsImage> entity)
+ {
+ var mesQsImages = entity.Where(item => item.Id == null).ToList();
+
+ mesQsImages.ForEach(s =>
+ {
+ if (!string.IsNullOrEmpty(s.base64Date))
+ //灏哹ase64杞崲涓篵yte鏁扮粍
+ s.ImageData = Convert.FromBase64String(s.base64Date);
+ });
+
+ return SqlSugarHelper.UseTransactionWithOracle(db =>
+ db.Insertable(mesQsImages).ExecuteCommand());
+ }
+
+ public int removeImage(decimal? id)
+ {
+ return SqlSugarHelper.UseTransactionWithOracle(db => db
+ .Deleteable(new MesQsImage { Id = id })
+ .ExecuteCommand());
+ }
+
+ public List<MesQsImage> getByFid(decimal id, string qsType)
+ {
+ var db = SqlSugarHelper.GetInstance();
+ var mesQsImages = db.Queryable<MesQsImage>()
+ .Where(s => s.Fid == id && s.QsType == qsType).ToList();
+ mesQsImages.ForEach(s =>
+ {
+ if (s.ImageData is { Length: > 0 })
+ s.base64Date = Convert.ToBase64String(s.ImageData);
+ });
+ return mesQsImages;
+ }
+}
\ No newline at end of file
--
Gitblit v1.9.3