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" */ }