采购订单加字段

sjz

2025-06-07 a4e262ad5d6b8631e25e3cc0872b590a7dbdb480

 MES.Service/service/SentLaboratory/SaveLaboratoryManager.cs

@@ -27,6 +27,7 @@
        public DateTime? CompleteDate { get; set; }
        public string? REMARKS { get; set; }
        public string? SIM_REQ { get; set; }
        public string? Test_REQ { get; set; }
        //磁铁拉力
        public decimal? Check01 { get; set; }

@@ -118,6 +119,8 @@
            DEPARTMENTCODE=mainTable.DEPARTMENTCODE,
            REMARKS = mainTable.REMARKS,
            SIM_REQ = mainTable.SimReq,
            CompleteDate=mainTable.CompleteDate,
            Test_REQ=mainTable.TestReq,
            Check01 = mainTable.Check01,
            Check02 = mainTable.Check02,
            Check03 = mainTable.Check03,
@@ -376,16 +379,20 @@
            var updateResult = db.Updateable(updateMesQmsSample).ExecuteCommand();

            var mapping = db.Queryable<UpdateMesQmsSamplePjt>()
             .Where(t => t.RELEASE_NO == updateMesQmsSample.JYDH && t.SJ_NO == updateMesQmsSample.ReleaseNo)
             .Where(t => t.RELEASE_NO == updateMesQmsSample.JYDH && t.PID == updateMesQmsSample.Id)
             .Select(t => new UpdateMesQmsSamplePjt
             {
                 PID=t.PID
             })
             .ToList();


            Debug.WriteLine(updateMesQmsSample.JYDH);

            if (mapping.Any())
            {
                updateResult = db.Updateable<UpdateMesQmsSamplePjt>()
             .SetColumns(t => new UpdateMesQmsSamplePjt
                .SetColumns(t => new UpdateMesQmsSamplePjt
             {
                 SJ_NO = updateMesQmsSample.ReleaseNo,
                 RELEASE_NO = updateMesQmsSample.JYDH,
@@ -396,7 +403,7 @@
                 ITEM_ID = getLaboratoryDetails.ITEM_ID,
                 SUPP_NAME = getLaboratoryDetails.SUPP_NAME
             })
             .Where(t => t.PID == updateMesQmsSample.Id) // 显式指定更新条件
             .Where(t => t.RELEASE_NO == updateMesQmsSample.JYDH && t.PID == updateMesQmsSample.Id) // 显式指定更新条件
             .ExecuteCommand();
               
            }