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