public bool SaveUserList(Model.Query.UsersListQuery usr, List<Model.UserLife> userLife)
{
try
{
ArrayList sqlList = new ArrayList();
sqlList.Add(_UserIplDao.SaveUserList(usr));
UserLifeDao _UserLifeDao = new UserLifeDao(conn);
sqlList.Add(_UserLifeDao.DeleteUserLife(usr.user_id));//刪除原有數據
foreach (Model.UserLife model in userLife)
{
sqlList.Add(_UserLifeDao.SaveUserLife(model));
}
List<Model.UserLife> old_user_life = _UserLifeDao.GetUserLife(usr.user_id);
var alist = old_user_life.Find(m => m.info_type == "cancel_info_time");
if (alist == null)
{
if (!usr.send_sms_ad)
{
sqlList.Add(_UserLifeDao.UpdateCancelTime(usr.user_id, (uint)Common.CommonFunction.GetPHPTime(), usr.update_user));
}
}
else
{
if (usr.send_sms_ad)
{
sqlList.Add(_UserLifeDao.UpdateCancelTime(usr.user_id, 0, usr.update_user));
}
}
MySqlDao _MySqlDao = new MySqlDao(conn);
return _MySqlDao.ExcuteSqls(sqlList);
}
catch (MySqlException ex)
{
throw new Exception(ex.Number.ToString() + ":UsersListMgr-->SaveUserList-->" + ex.Message, ex);
}
catch (Exception ex)
{
throw new Exception("UsersListMgr-->SaveUserList-->" + ex.Message, ex);
}
}
