public Result UpdateUnits(UserUnits model) { ApiResultEnum result = UnitDA.UpdateUserID(model); if (result == ApiResultEnum.Success && MonitorRA.GetStatusTrade() != 0) { string[] keys = TradeRA.KeySearch("U_*"); foreach (string key in keys) { string _user_id = TradeRA.Get(key, "user_id"); if (model.unit_ids.Contains(int.Parse(key.Substring(2)))) { if (model.id != _user_id) { UnitRA.UpdateUserID(model.id, key); } } else { if (model.id == _user_id) { UnitRA.UpdateUserID("0", key); } } } } return(Result(result)); }
public static ApiResultEnum UpdateUserID(UserUnits model) { List <string> sqls = new List <string>(); sqls.Add(string.Format("UPDATE unit SET user_id = NULL WHERE user_id = {0}", model.id)); if (model.unit_ids.Count > 0) { sqls.Add(string.Format("UPDATE unit SET user_id = {0} WHERE id in ({1})", model.id, string.Join(",", model.unit_ids))); } if (MySQLHelper.ExecuteNonQuery(sqls)) { return(ApiResultEnum.Success); } return(ApiResultEnum.Failed); }