public ActionResult EditUser(User user)
{
try
{
UserService service = new UserService();
var oldUser = service.GetUserById(UserInfo.UserId);
if (oldUser != null)
{
oldUser.Adress = user.Adress;
oldUser.QQ = user.QQ;
oldUser.LocationId = Request.Form["LocationId[]"];
if (!string.IsNullOrEmpty(Request.Form["Photo"]))
{
oldUser.Photo = Request.Form["Photo"];
}
if (service.UserUpdate(oldUser))
{
Session[USERINFO] = oldUser;
}
}
}
catch (Exception ex)
{
LogService.Log("会员列表", ex.ToString());
}
return RedirectToAction("ViewUser");
}
public User GetUserById(int id)
{
User user = new User();
try
{
user = userRepository.FindOne(u => u.UserId.Equals(id));
}
catch (Exception e)
{
LogService.Log("查询用户失败", e.ToString());
}
return user;
}
private User ConvertToUserObject(SqlDataReader reader)
{
User user = new User();
user.UserId = reader["UserId"].DBToInt32();
user.UserName = reader["UserName"].DBToString();
user.Adress = reader["Adress"].DBToString();
user.Cellphone = reader["Cellphone"].DBToString();
user.CreateTime = reader["CreateTime"].DBToDateTime();
user.Email = reader["Email"].DBToString();
user.IdentiyImg = reader["IdentiyImg"].DBToString();
user.LastUpdatedTime = reader["LastUpdatedTime"].DBToDateTime();
user.EncryptedPassword = reader["EncryptedPassword"].DBToString();
user.LocationId = reader["LocationId"].DBToString();
user.LoginIdentiy = reader["LoginIdentiy"].DBToString();
user.QQ = reader["QQ"].DBToString();
user.SiteUrl = reader["SiteUrl"].DBToString();
user.State = reader["State"].DBToInt32();
user.UCard = reader["UCard"].DBToString();
user.UserType = reader["UserType"].DBToInt32();
user.Vip = reader["Vip"].DBToInt32();
user.Photo = reader["Photo"].DBToString();
return user;
}
/// <summary>
/// 注册用户。返回UserId
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool UserRegister(SqlConnection conn, User user, out int userId)
{
bool result = false;
userId = -1;
SqlParameter[] parameters =
{
new SqlParameter(column_UserId, SqlDbType.Int,4),
new SqlParameter("@UserName", user.UserName),
new SqlParameter("@EncryptedPassword", user.EncryptedPassword),
new SqlParameter("@UserType", user.UserType),
new SqlParameter("@Adress", user.Adress),
new SqlParameter("@LocationId", user.LocationId),
new SqlParameter("@Cellphone", user.Cellphone),
new SqlParameter("@Email", user.Email),
new SqlParameter("@QQ", user.QQ),
new SqlParameter("@UCard", user.UCard),
new SqlParameter("@SiteUrl", user.SiteUrl),
new SqlParameter("@LoginIdentiy", user.LoginIdentiy),
new SqlParameter("@IdentiyImg", user.IdentiyImg),
new SqlParameter("@Vip", user.Vip),
new SqlParameter("@CreateTime", DateTime.Now),
new SqlParameter("@LastUpdatedTime", DateTime.Now)
};
parameters[0].Direction = ParameterDirection.Output;
DBHelper.CheckSqlSpParameter(parameters);
result = DBHelper.RunNonQueryProcedure(conn, SP_UserRegister, parameters) > 0;
userId = Convert.ToInt32(parameters[0].Value);
return result;
}
/// <summary>
/// 更新用户信息。
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool UpdateUser(SqlConnection conn, User user)
{
SqlParameter[] parameters =
{
new SqlParameter(Constants.column_UserId, user.UserId),
new SqlParameter("@Adress", user.Adress),
new SqlParameter(Constants.column_cellphone, user.Cellphone),
new SqlParameter("@LocationId", user.LocationId),
new SqlParameter("@Email", user.Email),
new SqlParameter("@QQ", user.QQ),
new SqlParameter("@UCard", user.UCard),
new SqlParameter("@SiteUrl", user.SiteUrl),
new SqlParameter("@Vip", user.Vip),
new SqlParameter("@Photo", user.Photo),
new SqlParameter("@IdentiyImg", user.IdentiyImg)
};
DBHelper.CheckSqlSpParameter(parameters);
return DBHelper.RunNonQueryProcedure(conn, sp_UpdateUser, parameters) > 0;
}
/// <summary>
/// 找回密码
/// </summary>
/// <param name="conn"></param>
/// <param name="column"></param>
/// <param name="value"></param>
/// <returns></returns>
public bool ResetUserPasswordById(SqlConnection conn, User user)
{
if (user == null)
{
throw new ArgumentNullException("密码重置：用户信息不能为空");
}
const string sp_GetBackPassword = "******";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter(Constants.column_UserId, user.UserId),
new SqlParameter("@EncryptedPassword", user.EncryptedPassword)
};
return DBHelper.RunNonQueryProcedure(conn,
sp_GetBackPassword, sqlParameters) > 0;
}
/// <summary>
/// 找回密码，成功返回True
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool ResetUserPassword(User user)
{
bool result = false;
var conn = DBHelper.GetSqlConnection();
try
{
conn.Open();
result = userDao.ResetUserPasswordById(conn, user);
}
catch (Exception e)
{
LogService.Log("用户注册失败--" + e.Message, e.ToString().ToString());
}
finally
{
conn.Close();
}
return result;
}
/// <summary>
/// 根据UserName查询用户
/// </summary>
/// <param name="username">用户名、用户注册邮箱、注册手机号</param>
/// <returns></returns>
public User GetUserByUserName(string username)
{
User user = new User();
var conn = DBHelper.GetSqlConnection();
try
{
conn.Open();
user = userDao.GetUserByUserName(username, conn);
}
catch (Exception e)
{
LogService.Log("查询用户失败--" + e.Message, e.ToString());
}
finally
{
conn.Close();
}
return user;
}
/// <summary>
/// 用户注册，成功返回True
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
private bool UserRegister(User user, out int userId, out string errorMessage, SqlConnection conn)
{
bool result = false;
errorMessage = "注册用户失败！请再次尝试，如频繁遇到此错误，请联系客户人员！我们会第一时间帮您解决问题！感谢您使用活动在线网！";
userId = -1;
try
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
if (user == null)
{
errorMessage = "当前网络不稳定，请稍后再试！";
}
else if (string.IsNullOrWhiteSpace(user.UserName))
{
errorMessage = "请输入用户名！";
}
else if (string.IsNullOrWhiteSpace(user.EncryptedPassword))
{
errorMessage = "请输入账户密码！";
}
else if (string.IsNullOrWhiteSpace(user.Email))
{
errorMessage = "请输入注册邮箱！邮箱可用于找回密码！";
}
else if (string.IsNullOrWhiteSpace(user.Cellphone))
{
errorMessage = "请输入手机号码！";
}
else if (string.IsNullOrWhiteSpace(user.UCard))
{
errorMessage = "请输入认证身份证号码！";
}
else if (!userDao.VerifyUserInfo(conn, "UserName", user.UserName))
{
errorMessage = "您当前使用的用户名已被使用，请重新输入！";
}
else if (!userDao.VerifyUserInfo(conn, "Email", user.Email))
{
errorMessage = "您当前注册的邮箱号已被使用，请仔细确认！如您的输入无误，建议您使用邮箱找回密码功能进行密码重置！";
}
else if (!userDao.VerifyUserInfo(conn, "Cellphone", user.Cellphone))
{
errorMessage = "您当前注册的手机号已被使用，请仔细确认！";
}
else if (!userDao.VerifyUserInfo(conn, "UCard", user.UCard))
{
errorMessage = "您当前注册认证的身份证号已被使用，请仔细确认！";
}
else
{
user.Vip = (int)VipState.Normal;
user.EncryptedPassword = user.EncryptedPassword.ToMD5();
result = userDao.UserRegister(conn, user, out userId);
}
}
catch (Exception e)
{
result = false;
errorMessage = "注册用户失败！请再次尝试，如频繁遇到此错误，请联系客户人员！我们会第一时间帮您解决问题！感谢您使用活动在线网！";
LogService.Log("用户注册失败--" + e.Message, e.ToString().ToString());
}
return result;
}
/// <summary>
/// 微信端用户注册，成功后自动绑定该微信账号
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool WeChatUserRegister(User user, string openId, out string errorMessage)
{
bool result = false;
errorMessage = "";
var conn = DBHelper.GetSqlConnection();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
conn.Open();
int userId;
result = UserRegister(user, out userId, out errorMessage, conn);
if (result)
{
WeChatUser wechatUser = userDao.GetWeChatUser(openId, conn);
wechatUser.UserId = userId;
result = userDao.UpdateWeChatUser(conn, wechatUser);
}
if (result)
{
scope.Complete();
}
}
}
catch (Exception e)
{
errorMessage = "注册用户失败！请再次尝试，如频繁遇到此错误，请联系客户人员！我们会第一时间帮您解决问题！感谢您使用活动在线网！";
LogService.Log("用户注册失败--" + e.Message, e.ToString().ToString());
}
finally
{
conn.Close();
}
return result;
}
/// <summary>
/// 用户修改基础信息，成功返回True
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool UserUpdate(User user)
{
bool result = false;
var conn = DBHelper.GetSqlConnection();
try
{
conn.Open();
result = userDao.UpdateUser(conn, user);
}
catch (Exception e)
{
LogService.Log("修改用户失败--" + e.Message, e.ToString().ToString());
}
finally
{
conn.Close();
}
return result;
}
/// <summary>
/// 用户注册，成功返回True
/// </summary>
/// <param name="user"></param>
/// <param name="errorMessage"></param>
/// <returns></returns>
public bool UserRegister(User user, out string errorMessage)
{
var conn = DBHelper.GetSqlConnection();
var result = false;
try
{
int userId = -1;
result = UserRegister(user, out userId, out errorMessage, conn);
}
finally
{
conn.Close();
}
return result;
}