达梦生成的SqlFunc.GetDate() ,生成sql脚本sysdate 带双号 返回

SqlSugar
190
该叫什么 beihui 发布于2周前
悬赏:100 飞吻

_db.Updateable<Lib_ItemsCollection>()

    .SetColumns(it => it.ItemStorageClass == 2)

    .SetColumns(it => it.UpdateTime == SqlFunc.GetDate()) 

    .Where(it => it.ItemID == 810464290177093 && it.ItemSchoolID == 1)

    .ExecuteCommand();


生成的sql

UPDATE "Lib_ItemsCollection"

            SET "ItemStorageClass" = 3 

                "UpdateTime" = "sysdate"

            WHERE "ItemID" = 810464290177093  AND "ItemSchoolID" = 1

d4bc4cd2-7c11-4ab3-8347-2e8284e064f5.png

热忱回答0