176.C# SqlSugar 更新数据

摘要

单条更新，批量更新。

正文

单条更新，批量更新。

正文

根据实体对象更新

var user = new wms_user
{
    id = 1586977355308601346,
    name = "李四2",
    dept = "IT2",
    duty = "程序员2",
    hire_date = DateTime.Parse("2022-11-1"),
    term_date = null
};
var ret= Db.Updateable(user).ExecuteCommand();

           

函数	说明
ExecuteCommand	返回受影响行数 ， update where 如果没找到那么就会返回 0
ExecuteCommandHasChange	返回bool ,等同于 bool isChange= ExecuteCommand()>0

批量更新

List<wms_user> users = new List<wms_user>();
var user1 = new wms_user
{
    id = 1586979335129141248,
    name = "王五",
    dept = "电气",
    duty = "程序员",
    hire_date = DateTime.Parse("2021-09-1"),
    term_date = null
};
var user2 = new wms_user
{
    id = 1586977355308601346,
    name = "李四",
    dept = "IT",
    duty = "程序员",
    hire_date = DateTime.Parse("2012-09-1"),
    term_date = null
};
users.Add(user1);
users.Add(user2);
var ret= Db.Updateable(users).ExecuteCommand();

           

不更新某列

var user1 = new wms_user
{
    id = 1586979335129141248,
    name = "王五",
    dept = "电气1",
    duty = "工程师",
    hire_date = DateTime.Parse("2021-12-23"),
    term_date = null
};
var ret= Db.Updateable(user1).IgnoreColumns(it=>new {it.dept,it.hire_date }).ExecuteCommand();

           

只更新某列

var user1 = new wms_user
{
    id = 1586979335129141248,
    name = "王五A",
    dept = "电气1",
    duty = "工程师",
    hire_date = DateTime.Parse("2021-12-23"),
    term_date = null
};
var ret= Db.Updateable(user1).UpdateColumns(it => new {it.name,it.hire_date}).ExecuteCommand();

           

NULL列不更新

var ret= Db.Updateable(user1).IgnoreColumns(ignoreAllNullColumns:true).ExecuteCommand();
           

whereColumns子句更新

根据指定列更新

var user1 = new wms_user
{
    id = 1586979335129141248,
    name = "王五A",
    dept = "电气1",
    duty = "工程师2",
    hire_date = DateTime.Parse("2020-12-23"),
    term_date = null
};
var ret= Db.Updateable(user1).WhereColumns(x=>x.name).ExecuteCommand();

           

更新where条件

var user1 = new wms_user
{
    id = 1586979335129141248,
    name = "王五A",
    dept = "电气12",
    duty = "工程师21",
    hire_date = DateTime.Parse("2020-01-23"),
    term_date = null
};
var ret= Db.Updateable(user1).Where(x=>x.name== "王五A").ExecuteCommand();

           

大批量更新

List<wms_user> users = new List<wms_user>();
var user1 = new wms_user
{
    id = 1586979335129141248,
    name = "王五",
    dept = "IT",
    duty = "程序员",
    hire_date = DateTime.Parse("2021-09-1"),
    term_date = null
};
var user2 = new wms_user
{
    id = 1586977355308601346,
    name = "李四",
    dept = "IT",
    duty = "程序员",
    hire_date = DateTime.Parse("2012-09-1"),
    term_date = null
};
users.Add(user1);
users.Add(user2);
var ret = Db.Fastest<wms_user>().BulkUpdate(users);

           

根据表达式更新

var ret = Db.Updateable<wms_user>()
    .SetColumns(it => new wms_user() { name = "张飞" })
    .Where(it => it.id == 1586979335129141248)
    .ExecuteCommand();

           

用SetColumns可以叠加更新

var ret = Db.Updateable<wms_user>()
    .SetColumns(it =>it.name=="TOM")
    .SetColumns(it=>it.dept=="演员")
    .Where(it => it.id == 1586979335129141248)
    .ExecuteCommand();

           

根据字典更新

var dc = new Dictionary<string, object>();
dc.Add("id", 1586977355308601346);
dc.Add("name", "张飞");
dc.Add("dept", "IT");
dc.Add("duty", "程序员");
dc.Add("hire_date", DateTime.Now.AddDays(-100));
var ret = Db.Updateable(dc).AS("wms_user").WhereColumns("id").ExecuteCommand();