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