11

啊鑫

2024-12-13 554fa8ad99c42b6c0e3ed2c56358a3d7dd9ded6e

 MES.Service/service/WomcaaManager.cs

@@ -58,10 +58,11 @@
            db.Deleteable<Womcab>()
                .Where(s => s.Pid == mesWomcaa.Erpid).ExecuteCommand();

        //插入忽略空字段
        //单条插入忽略空字段
        var orUpdate = db.Insertable(mesWomcaa)
            .IgnoreColumns(true).ExecuteCommand() > 0;

        //批量插入忽略空字段
        var baOrUpdate = db.Insertable(mesWomcabs).PageSize(1)
            .IgnoreColumnsNull()
            .ExecuteCommand() > 0;