人员信息修改

CRZ

2 天以前 89fa5f03903ed6161474dcbe8528503f69f804d1

 MES.Service/service/WomcaaManager.cs

@@ -88,29 +88,15 @@
                                it.SrcBillType == mesWomcaa.SrcBillType)
                   .ExecuteCommand();

                };


            if (mesWomcabs.Count > 0)
            {

            var mesWomcab = mesWomcabs.Select(s => new { CAB001 = s.Cab001, CAB002 = s.Cab002, CAB003 = s.Cab003 }).ToList();
            //var mesWomcab = mesWomcabs.Select(s => new { CAB001 = s.Cab001, CAB002 = s.Cab002}).ToList();


            // 删除该任务单的所有WOMCAB记录（BOM明细）
            // 这样可以确保WOMCAB与JSON完全一致
            db.Deleteable<Womcab>()
                .Where(it => mesWomcab
                .Any(p => p.CAB001 == it.Cab001 
                && p.CAB002 == it.Cab002 
                && p.CAB003 == it.Cab003))
           .Where(it => it.Cab001 == mesWomcaa.Caa001 &&
                        it.Cab002 == mesWomcaa.SrcBillType)
                .ExecuteCommand();
            //db.Deleteable<Womcab>()
            //    .Where(it => mesWomcab
            //    .Any(p => p.CAB001 == it.Cab001
            //    && p.CAB002 == it.Cab002))
            //    .ExecuteCommand();

        };
        }
        ;
           

            var orUpdate = db.Insertable(mesWomcaa).ExecuteCommand();