update报错 返回
C#论坛
老数据
1
2277
悬赏:5 飞吻
var db = SugarDAO.GetInstance();
db.Updateable<T_Shop>().UpdateColumns(c => new
{
ShowStatus = request.Body.ShowStatus,
EditDate = DateTime.Now,
EditUser = request.Header.Name
}).Where(c => request.Body.SysNoList.Contains(c.ShopID)).ExecuteCommand();
生成SQL如下
UPDATE [T_Shop] SET
WHERE ([ShopID] IN ('1'))
热忱回答(1)
-
liftlei VIP0
2018/7/14UpdateColumns 不是这样用的吧,可以看看文档
0 回复