/// <summary>
/// 登录
/// </summary>
/// <param name="account">用户名</param>
/// <param name="password">密码</param>
/// <returns>登录状态</returns>
//public static SignInStatus PasswordSignIn(string account, string password)
//{
// using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
// {
// var truePassword = _db.tbl_UserAccount.Where(p => p.user_Account == account).ToList();
// if (truePassword.Count() == 0)
// {
// return SignInStatus.UndefinedAccount;
// }
// else if (truePassword[0].user_Password == DESEncryption.DesEncrypt(password))
// {
// FormsAuthentication.SetAuthCookie(account, true, FormsAuthentication.FormsCookiePath);
// return SignInStatus.Success;
// }
// else
// {
// return SignInStatus.Failure;
// }
// }
//}
public static SignInStatus SignInWithPassword(string account, string password)
{
var validate = SqlHepler.ExecuteSqlQuery("Select * From tbl_UserAccount Where user_Account=@name", new SqlParameter("@name", account));
if (validate.Count == 0)
{
return(SignInStatus.UndefinedAccount);
}
else if (validate[0].user_Password == DESEncryption.DesEncrypt(password))
{
CookieHepler.SetCookie("user", account);
CookieHepler.SetCookie("userid", validate[0].user_Id.ToString());
CookieHepler.SetCookie("usertype", validate[0].user_IsAdmin.ToString());
//HttpCookie cookie = new HttpCookie("user", account);
//cookie.Expires = DateTime.Now.AddHours(12);
//HttpContext.Current.Response.Cookies.Add(cookie);
//cookie = new HttpCookie("userid", validate[0].user_Id.ToString());
//cookie.Expires = DateTime.Now.AddHours(12);
//HttpContext.Current.Response.Cookies.Add(cookie);
//cookie = new HttpCookie("usertype", validate[0].user_IsAdmin.ToString());
//cookie.Expires = DateTime.Now.AddHours(12);
//HttpContext.Current.Response.Cookies.Add(cookie);
return(SignInStatus.Success);
}
else
{
return(SignInStatus.Failure);
}
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="account">账号</param>
/// <param name="oldpassword">原密码</param>
/// <param name="newpassword">新密码</param>
/// <returns>成功 or 失败，错误信息</returns>
public static RequestResult ChangePassword(string account, string oldpassword, string newpassword)
{
if (oldpassword == newpassword)
{
return(new RequestResult()
{
Succeeded = false, Error = "新密码不能与原密码相同"
});
}
using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
{
oldpassword = DESEncryption.DesEncrypt(oldpassword);
var rightPassword = _db.tbl_UserAccount.Where(p => p.user_Account == account && p.user_Password == oldpassword).ToList();
if (rightPassword.Count() == 0)
{
return(new RequestResult()
{
Succeeded = false, Error = "原密码输入错误"
});
}
else
{
newpassword = DESEncryption.DesEncrypt(newpassword);
var newAccount = _db.tbl_UserAccount.SingleOrDefault(p => p.user_Account == account);
newAccount.user_Password = newpassword;
_db.SubmitChanges();
_db.AlterUserAlterTime(newAccount.user_Id);
return(new RequestResult()
{
Succeeded = true, Error = "密码 更改成功"
});
}
}
}
/// <summary>
/// 重置密码
/// </summary>
/// <param name="account">账号</param>
/// <param name="password">密码</param>
/// <returns>成功 or 失败，错误信息</returns>
public static RequestResult ResetPassword(string account, string password)
{
using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
{
password = DESEncryption.DesEncrypt(password);
var newAccount = _db.tbl_UserAccount.SingleOrDefault(p => p.user_Account == account);
newAccount.user_Password = password;
_db.SubmitChanges();
return(new RequestResult()
{
Succeeded = true
});
}
}
/// <summary>
/// 创建账户
/// </summary>
/// <param name="account">用户名</param>
/// <param name="password">密码</param>
/// <returns>成功 or 失败，错误信息</returns>
public static RequestResult Create(string account, string password)
{
using (MRDataEntities _db = new MRDataEntities())
//using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
{
var hasAccount = _db.tbl_UserAccount.Where(p => p.user_Account == account);
if (hasAccount.Count() > 0)
{
return(new RequestResult()
{
Succeeded = false, Error = "用户名已存在"
});
}
else
{
password = DESEncryption.DesEncrypt(password);
//string guid;
//do
//{
// guid = Guid.NewGuid().ToString("N").ToUpper();
//} while (_db.tbl_UserAccount.Where(p => p.user_Id == guid).Count() != 0);
var addAccount = new tbl_UserAccount()
{
//user_Id = guid,
user_Id = Guid.NewGuid().ToString("N").ToUpper(),
user_Account = account,
user_Password = password,
user_IsAdmin = false,
user_CreateTime = DateTime.Now
};
addAccount.user_Avatar = "User_1.jpg";
addAccount.user_Cover = "Cover_1.jpg";
_db.tbl_UserAccount.Add(addAccount);
_db.SaveChanges();
//_db.tbl_UserAccount.InsertOnSubmit(addAccount);
//_db.SubmitChanges();
//_db.SetUserTime(guid);
return(new RequestResult()
{
Succeeded = true
});
}
}
}
/// <summary>
/// 登录
/// </summary>
/// <param name="account">用户名</param>
/// <param name="password">密码</param>
/// <returns>登录状态</returns>
public static SignInStatus PasswordSignIn(string account, string password)
{
using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext())
{
var truePassword = _db.tbl_UserAccount.Where(p => p.user_Account == account).ToList();
if (truePassword.Count() == 0)
{
return(SignInStatus.UndefinedAccount);
}
else if (truePassword[0].user_Password == DESEncryption.DesEncrypt(password))
{
FormsAuthentication.SetAuthCookie(account, true, FormsAuthentication.FormsCookiePath);
return(SignInStatus.Success);
}
else
{
return(SignInStatus.Failure);
}
}
}
