public int UpdateState(VipUserQuery query)
{
string sql = string.Empty;
int result = 0;
try
{
query.updatedate = Convert.ToUInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
sql = _vipUserDao.UpdateState(query);
if (query.user_id == 0)
{
VipUser vimodel = new VipUser();
vimodel = _dbAccess.getSinggleObj<VipUser>(_vipUserDao.GetSingleByID(Convert.ToInt32(query.v_id)));
if (vimodel != null)
{
query.user_id = vimodel.user_id;
}
}
if (query.user_id != 0)
{
UserLifeDao _userLifeDao = new UserLifeDao(conn);
if (query.status == 1)//z狀態改為鎖定時記錄會員取消電子報的時間和操作人
{
//將取消電子報的時間和人員加入會員生活信息表（user_life）edit by shuangshuang0420j 20150814 11:00
UserLife modelUF = new UserLife();
modelUF = _userLifeDao.GetSingle(query.user_id, "cancel_edm_time");
if (modelUF != null)
{
sql = sql + _userLifeDao.UpdateEdmTime(query.user_id, 0, (int)query.update_id);
}
sql = sql + _userLifeDao.UpdateEdmTime(query.user_id, query.updatedate, (int)query.update_id);
}
else if (query.user_status == 0)//狀態改為解鎖時清空會員取消電子報的信息
{
sql = sql + _userLifeDao.UpdateEdmTime(query.user_id, 0, (int)query.update_id);
}
}
result = _dbAccess.execCommand(sql);
return result;
}
catch (Exception ex)
{
throw new Exception("VipUserMgr-->UpdateState-->" + ex.Message, ex);
}
}
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);
}
}
public int UpdateBlackList(string email)
{
string sqlEmail = string.Empty;
string sqlUserID = string.Empty;
string sqlUpdate = string.Empty;
uint userID = 0;
int sum = 0;
try
{
sqlUserID = _usersDao.GetUserIDbyEmail(email);
DataTable users = _dbAccess.getDataTable(sqlUserID);
if (users != null && users.Rows.Count > 0)
{
userID = Convert.ToUInt32(users.Rows[0][0]);
}
if (string.IsNullOrEmpty(userID.ToString()) || userID == 0)
{
return -1;//郵箱不存在對應的用戶
}
else
{
sqlEmail = _vipUserDao.SelectEmail(userID);
DataTable temail = _dbAccess.getDataTable(sqlEmail);
if (temail != null && temail.Rows.Count > 0)
{
sum = Convert.ToInt32(temail.Rows[0][0]);
}
if (sum > 0)
{
return -2;//該用戶已加入黑名單
}
else
{
uint update_id = Convert.ToUInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
uint phpTime = (uint)Common.CommonFunction.GetPHPTime();
VipUserQuery query = new VipUserQuery();
query.vuser_email = email;
query.v_id = userID;
query.create_id = update_id;
query.update_id = update_id;
query.createdate = phpTime;
query.updatedate = phpTime;
sqlUpdate = _vipUserDao.UpdateBlackList(query);
//將取消電子報的時間和人員加入會員生活信息表（user_life）edit by shuangshuang0420j 20150814 11:00
UserLifeDao _userLifeDao = new UserLifeDao(conn);
sqlUpdate = sqlUpdate + _userLifeDao.UpdateEdmTime(userID, phpTime, (int)update_id);
return _dbAccess.execCommand(sqlUpdate);
}
}
}
catch (Exception ex)
{
throw new Exception("VipUserMgr-->UpdateBlackList-->" + ex.Message, ex);
}
}
public int UserCancel(UsersListQuery u)
{
StringBuilder sb = new StringBuilder();
StringBuilder sel = new StringBuilder();
string email = DateTime.Now.ToString("yyyyMMdd") + "_" + u.user_email;
try
{
if (u.user_id > 0)
{
sb.Append("set sql_safe_updates = 0;");
sb.AppendFormat("Update users set user_status=2,user_email='{1}' where user_id='{0}';", u.user_id, email);
sel.AppendFormat("SELECT * from edm_email where email_address='{0}' ;", u.user_email);
if (_access.getDataTable(sel.ToString()).Rows.Count > 0)
{//修改會員電子報信息
sb.AppendFormat("Update edm_email set email_updatedate='{2}' , email_address='{1}' where email_address='{0}';", u.user_email, email, CommonFunction.GetPHPTime(DateTime.Now.ToString()));
}
sel.Clear();
sel.AppendFormat("SELECT * from epaper_email where email_address='{0}'", u.user_email);
if (_access.getDataTable(sel.ToString()).Rows.Count > 0)
{//修改會員電子報信息
sb.AppendFormat("Update epaper_email set email_updatedate='{2}', email_address='{1}' where email_address='{0}';", u.user_email, email, CommonFunction.GetPHPTime(DateTime.Now.ToString()));
}
sb.Append("set sql_safe_updates = 1; ");
//保存禁用會員的時間和操作人至會員生活表（user_life）edit by shuangshuang0420j 20150814 09:42
UserLifeDao _userLifeDao = new UserLifeDao(conn);
sb.Append(_userLifeDao.UpdateDisableTime(u.user_id, (uint)CommonFunction.GetPHPTime(), u.update_user));
return _access.execCommand(sb.ToString());
}
else
{
return 0;
}
}
catch (Exception ex)
{
throw new Exception("UsersListDao-->UserCancel-->" + ex.Message + sb.ToString(), ex);
}
}
public int CancelEdm(string mail, uint update_id, out uint vid)
{
int result = 0;
string sqlEmail = string.Empty;
string sqlUpdate = string.Empty;
uint userID = 0;
vid = 0;
int sum = 0;
uint status = 0;
VipUserQuery query = new VipUserQuery();
try
{
if (_edmEmailDao.GetModel(mail) == null)//郵箱不存在
{
result = -1;
return result;
}
else
{
result = _IEdmContentDao.CancelEdm(mail);
int num = updateGroupCount(mail);
if (result > 0 && num > 0)
{
DataTable dt = _accessMySql.getDataTable(_usersDao.GetUserIDbyEmail(mail));//判斷郵箱是否有對應的用戶id
if (dt != null && dt.Rows.Count > 0)
{
userID = Convert.ToUInt32(dt.Rows[0][0]);
}
if (string.IsNullOrEmpty(userID.ToString()) || userID == 0)
{
result = -2;
return result;//郵箱不存在對應的用戶
}
else
{
sqlEmail = _vipUserDao.SelectEmail(userID);//根據用戶id查詢郵箱是否已經加入黑名單
DataTable temail = _accessMySql.getDataTable(sqlEmail);
uint phpTime = (uint)Common.CommonFunction.GetPHPTime();
#region 將取消電子報的時間和人員加入會員生活信息表（user_life）edit by shuangshuang0420j 20150814 11:00
//將取消電子報的時間和人員加入會員生活信息表（user_life）edit by shuangshuang0420j 20150814 11:00
UserLifeDao _userLifeDao = new UserLifeDao(conn);
UserLife modelUF = new UserLife();
modelUF = _userLifeDao.GetSingle(userID, "cancel_edm_time");
if (modelUF != null)
{
_accessMySql.execCommand(_userLifeDao.UpdateEdmTime(userID, 0, (int)update_id));
}
_accessMySql.execCommand(_userLifeDao.UpdateEdmTime(userID, phpTime, (int)update_id));
#endregion
if (temail != null && temail.Rows.Count > 0)
{
sum = Convert.ToInt32(temail.Rows[0][0]);
}
if (sum > 0)
{
status = Convert.ToUInt32(temail.Rows[0][1]);
vid = Convert.ToUInt32(temail.Rows[0][2]);
if (status == 0)
{
result = -3;
return result;//該用戶已加入黑名單且狀態為解鎖
}
else if (status == 1)
{
result = -4;
return result;//該用戶已加入黑名單,狀態為鎖定
}
}
else
{
query.vuser_email = mail;
query.v_id = userID;
query.create_id = update_id;
query.update_id = update_id;
query.createdate = phpTime;
query.updatedate = phpTime;
sqlUpdate = _vipUserDao.UpdateBlackList(query);
result = _accessMySql.execCommand(sqlUpdate);
return result;
}
}
}
else
{
result = -5;
}
return result;
}
}
catch (Exception ex)
{
throw new Exception("EdmContentMgr-->CancelEdm-->" + ex.Message, ex);
}
}
