public void EditColumnSqlTest()
{
string colm = "img", val = "(select value from skin limit 1 offset 1)"; DateTime cdate = DateTime.Now;
var update = DBSqlite <Users> .Update().EditColumn(p => new bool[] {
SM.Sql(colm, val), SM.Sql(p.Remark, "(select '奥德赛 终于改好了')")
}).Where(p => p.Id == 6 && SM.SQL("IsDel == 0"));
WriteSqlParams(update.RawSqlParams());
}
public void EditShortTest()
{
short stnum = 1;
var edit = DBSqlite <EsySysUser_> .Update().EditColumn(p => new bool[] { p.Gen == stnum,
SM.Sql(p.Gen, " 1 "), p.F_UserId == "001" }).Where(p => p.F_UserId == "001");
var rawsp = edit.RawSqlParams();
WriteSqlParams(rawsp);
//.ExecuteUpdate();
}
public void 更新部分字段_含子查询_测试lt()
{
var model = new Users()
{
CreateTime = DateTime.Now
};
string colm = "img", val = "(select value from skin limit 1 offset 1)"; DateTime cdate = DateTime.Now;
var update = DBSqlite <Users> .Update().EditColumn(p => new bool[] {
p.UserName == "几十行代码几十个错 调一步改一步....", p.Password == "bug制造者"
, p.CreateTime == model.CreateTime, SM.Sql(p.Remark, "(select '奥德赛 终于改好了')")
}).Where(p => p.Id == 6 && SM.SQL("IsDel == 0"));
Console.WriteLine(update.RawSqlParams().Item1);
var efrow = update.ExecuteUpdate();
Console.WriteLine(efrow);
}
public void 修改字段_多次拼接_20_6_5()
{
string colm = "img", val = "(select value from skin limit 1 offset 1)"; DateTime cdate = DateTime.Now;
var update = DBSqlite <Users> .Update()
.EditColumn(p => new bool[] { p.UserName == "123" })
.EditColumn(p => new bool[] { SM.Sql(colm, val) })
.EditColumn(p => new bool[] { SM.Sql(p.Remark, "(select '奥德赛 终于改好了')") })
.EditColumn(p => new bool[] { p.numx == 123 })
//.EditColumnEnd()
.Where(p => p.Id == 6 && SM.SQL("IsDel == 0"));
WriteSqlParams(update.RawSqlParams());
/*
* 测试名称: 动态拼修改的字段_20_6_5
* 测试结果: 已通过
* 结果 的标准输出:
* update Users set UserName=@UserName1_ , img=(select value from skin limit 1 offset 1) , Remark=(select '奥德赛 终于改好了') , numx=@numx1_ where Id = @Id0 and IsDel == 0
* "UserName1_ -- \"123\""
* "numx1_ -- 123.0"
* "Id0 -- 6"
*/
}