PublicSetColumns中间处理null值,这种方式好像不可以 返回
SqlSugar
沟通中
2
1151

悬赏:0 飞吻
string sql = db.Db.Updateable(Ysxxb_list)
.PublicSetColumns(it => SqlFunc.IsNull(it.yfdjje, 0), "-") //set yfdjje=isnull(yfdjje,0)-list[i].yfdjje
.PublicSetColumns(it => SqlFunc.IsNull(it.yffsje, 0), "+")
.UpdateColumns(t => new { t.yfdjje, t.yffsje })
.WhereColumns(x => new { x.cbzx, x.yskm, x.yf })
.ToSqlString();
热忱回答(2)
-
fate sta VIP0
2024/10/30什么库
0 回复 -
Gally VIP0
2024/10/30sqlserver数据库
0 回复