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();