/// <summary>
/// 判断用户名是否存在
/// </summary>
/// <param name="loginName"></param>
/// <returns></returns>
public bool IsLoginNameExist(string loginName)
{
string sql = @" select * from bbsuser bbsu where bbsu.LoginName = @loginName ";
using (var dbContext = new DbContext().ConnectionStringName(ConnectionUtil.connBBS, new MySqlProvider()))
{
BBSUserVM user = dbContext.Sql(sql).Parameter("loginName", loginName).QuerySingle <BBSUserVM>();
return(user == null ? false : true);
}
}
public ActionResult Register(BBSUserVM user)
{
if (user == null || string.IsNullOrEmpty(user.LoginName) || string.IsNullOrEmpty(user.Password))
{
return(Json(new
{
Code = -400,
Msg = "参数不能为空",
Data = ""
}));
}
try
{
BBSUserService userSV = new BBSUserService();
if (userSV.IsLoginNameExist(user.LoginName))
{
return(Json(new
{
Code = -200,
Msg = "用户名已存在",
Data = ""
}));
}
user.InputTime = DateTime.Now;
user = userSV.Register(user);
MyFormsAuthentication.SetAuthCookie(user.LoginName, new MyFormsAuthentication()
{
UserID = user.ID, UserName = user.LoginName
}, false);
return(Json(new
{
Code = 200,
Msg = "注册成功",
Data = user
}));
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.Message);
throw ex;
}
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public BBSUserVM Login(BBSUserVM user)
{
if (user == null || string.IsNullOrEmpty(user.LoginName) || string.IsNullOrEmpty(user.Password))
{
return(null);
}
using (var dbContext = new DbContext().ConnectionStringName(ConnectionUtil.connBBS, new MySqlProvider()))
{
user = dbContext.Sql("select * from bbsuser u where u.LoginName = @loginName and u.Password = @password ")
.Parameter("loginName", user.LoginName)
.Parameter("password", EDcryptUtil.MD5Encrypt(user.Password))
.QuerySingle <BBSUserVM>();
return(user);
}
}
/// <summary>
/// 用户注册
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public BBSUserVM Register(BBSUserVM user)
{
if (user == null || string.IsNullOrEmpty(user.LoginName) || string.IsNullOrEmpty(user.Password))
{
return(null);
}
using (var dbContext = new DbContext().ConnectionStringName(ConnectionUtil.connBBS, new MySqlProvider()))
{
user.ID = dbContext.Insert("bbsuser").Column("LoginName", user.LoginName)
.Column("Password", EDcryptUtil.MD5Encrypt(user.Password))
.Column("HeadImageUrl", user.HeadImageUrl)
.Column("InputTime", user.InputTime).ExecuteReturnLastId <int>();
return(user);
}
}
