对添加巡检单物料编码进行去重

fcx

4 天以前 a619299816f2f632c7c6ba3a1bb869e2c212797d

 StandardPda/MES.Service/service/QC/SJService.cs

@@ -4,6 +4,7 @@
using MES.Service.util;
using SqlSugar;
using System.Data;
using System.Runtime.InteropServices.JavaScript;

namespace MES.Service.service.QC;

@@ -292,7 +293,8 @@
                    Picture = b.Picture,
                    Picturename = b.Picturename,
                    result = "未检测",
                    isCheck = 0,UP_FILE=b.UP_FILE
                    isCheck = 0,
                    UP_FILE=b.UP_FILE
                }).ToList();
    }

@@ -412,7 +414,7 @@

            // 2. 查找 MesQa 对应主表ID（通过 item.ItemNo）
            var mesQa = db.Queryable<MesQa>()
                .Where(q => q.ItemNo == item.ItemNo)
                .Where(q => q.ItemNo == item.ItemNo && q.QsType== "1")
                .Select(q => new { q.Id })
                .First();

@@ -733,7 +735,6 @@
            SqlSugarHelper.UseTransactionWithOracle(db =>
            {
                return db.Updateable<QsItemIpiReq>()
                    .SetColumns(s => s.Fsubmit == 1)
                    .SetColumns(s => s.FsubmitBy == rkjDto.userNo)
                    .SetColumns(s => s.FsubmitDate == DateTime.Now)
                    .Where(s => s.Id == rkjDto.gid)