/// <summary> /// 更新 /// 注意:rowObj为T类型将更新该实体的非主键所有列,如果rowObj类型为匿名类将更新指定列 /// 使用说明:sqlSugar.Update《T》(rowObj,whereObj); /// </summary> /// <typeparam name="T"></typeparam> /// <param name="rowObj">new T(){name="张三",sex="男"}或者new {name="张三",sex="男"}</param> /// <param name="expression">it.id=100</param> /// <returns></returns> public bool Update <T>(object rowObj, System.Linq.Expressions.Expression <Func <T, bool> > expression) where T : class { var tasks = new Task <bool> [configList.Count]; for (int i = 0; i < tasks.Length; i++) { CloudPubMethod.TaskFactory <bool>(ti => { var connName = configList[ti].ConnectionString; var db = new SqlSugarClient(connName); SettingConnection(db); return(db.Update <T>(rowObj, expression)); }, tasks, i); } Task.WaitAll(tasks); return(tasks.Any(it => it.Result)); }
/// <summary> /// 更新 /// 注意:rowObj为T类型将更新该实体的非主键所有列,如果rowObj类型为匿名类将更新指定列 /// 使用说明:sqlSugar.Update《T》(rowObj,whereObj); /// </summary> /// <typeparam name="T"></typeparam> /// <typeparam name="FiledType">主键类型</typeparam> /// <param name="rowObj">new T(){name="张三",sex="男"}或者new {name="张三",sex="男"}</param> /// <param name="whereIn">new int[]{1,2,3}</param> /// <returns></returns> public bool Update <T, FiledType>(object rowObj, params FiledType[] whereIn) where T : class { var tasks = new Task <bool> [configList.Count]; for (int i = 0; i < tasks.Length; i++) { CloudPubMethod.TaskFactory <bool>(ti => { var connName = configList[ti].ConnectionString; var db = new SqlSugarClient(connName); SettingConnection(db); return(db.Update <T, FiledType>(rowObj, whereIn)); }, tasks, i); } Task.WaitAll(tasks); return(tasks.Any(it => it.Result)); }
/// <summary> /// 更新是否查看推送状态 /// </summary> /// <param name="contentModel"></param> /// <returns></returns> public bool UpdateIsReadStatus(U_Content contentModel, string invalidusers = "") { using (SqlSugar.SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance()) { bool result = false; try { foreach (var item in contentModel.PushObject) { if (!invalidusers.Contains(item.UserID)) { result = _dbMsSql.Update <Business_WeChatPushDetail_Information>(new { ISRead = "1" }, i => i.Business_WeChatPushVguid == contentModel.VGUID && i.PushObject == item.UserID); } } } catch (Exception exp) { LogManager.WriteLog(LogFile.Error, "更新推送是否查看:" + exp.ToString()); } return(result); } }