public string delete(string userName)
{
try
{
//根据不可重复的用户名找到userSecurity里面的userId,将其删除
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userInfo> dbInfo = db.userInfo.Where(u => u.userName == userName.Trim()) as DbQuery <userInfo>;
userInfo obInfo = dbInfo.FirstOrDefault();
//创建一个要删除的对象
userSecurity deleSecurity = new userSecurity
{
userId = obInfo.userId,
};
//附加到ef中
db.userSecurity.Attach(deleSecurity);
//标记为删除--标记当前对象为删除状态
db.userSecurity.Remove(deleSecurity);
db.SaveChanges();
return("删除成功");
}
}
catch
{
return("删除失败");
}
}
public string update(userInfo info, userSecurity security)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userInfo> dbInfosearch = db.userInfo.Where(u => u.userName == info.userName) as DbQuery <userInfo>;
userInfo _userInfo = dbInfosearch.FirstOrDefault();
DbQuery <userSecurity> dbSecuritysearch = db.userSecurity.Where(u => u.userId == _userInfo.userId) as DbQuery <userSecurity>;
userSecurity _userSecurity = dbSecuritysearch.FirstOrDefault();
//将要修改的值，放到数据上下文中
_userSecurity.userId = security.userId;
_userSecurity.loginId = security.loginId;
_userSecurity.userPwd = security.userPwd;
_userInfo.userId = info.userId;
_userInfo.userName = info.userName;
_userInfo.userAge = info.userAge;
_userInfo.userSex = info.userSex;
_userInfo.userTel = info.userTel;
_userInfo.userStatus = info.userStatus;
_userInfo.userAccount = info.userAccount;
db.SaveChanges(); //将修改之后的值保存到数据库中
}
return("修改成功");
}
catch
{
return("修改失败");
}
}
public string add(userSecurity security)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
//先判断登录Id是否可用
var isLoginId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim());
if (isLoginId.ToList().Count != 0)
{
return("用户已存在");
}
userSecurity user = new userSecurity
{
loginId = security.loginId,
userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd)
};
db.userSecurity.Add(user);
db.SaveChanges();
}
return("增加成功");
}
catch
{
return("增加失败");
}
}
public string login(userSecurity security)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userSecurity> dbSecuritySureId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()) as DbQuery <userSecurity>;
userSecurity obSureId = dbSecuritySureId.FirstOrDefault();
string MD5Pwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim());
if (obSureId == null)
{
return("未注册");
}
DbQuery <userSecurity> dbSecuritySurePwd = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()).Where(u => u.userPwd == MD5Pwd) as DbQuery <userSecurity>;
userSecurity obSurePwd = dbSecuritySurePwd.FirstOrDefault();
if (obSurePwd != null)
{
HttpCookie cookieName = new HttpCookie("loginId");
cookieName.Value = security.loginId.Trim();
cookieName.Expires = DateTime.Now.AddHours(1);
Response.Cookies.Add(cookieName);
return("登录成功");
}
else
{
return("密码错误");
}
}
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public string changePassword(string loginId, string userOldPwd, string userPwd)
{
try
{
string MD5Pwd = MD5Helper.MD5Helper.encrypt(userOldPwd.Trim());
string MD5NewPwd = MD5Helper.MD5Helper.encrypt(userPwd.Trim());
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userSecurity> dbSecurity = db.userSecurity.Where(u => u.loginId == loginId.Trim()).Where(u => u.userPwd == MD5Pwd) as DbQuery <userSecurity>;
userSecurity obSecurity = dbSecurity.FirstOrDefault();
if (obSecurity == null)
{
Tools.AlertAndRedirect("用户名或密码错误", Url.Action("changePassword", "passwordManager", new { area = "account" }));
return("用户名或密码错误");
}
obSecurity.userPwd = MD5NewPwd;
db.SaveChanges();
Tools.AlertAndRedirect("修改成功", Url.Action("Logout", "userManagement"));
return("修改成功");
}
}
catch
{
Tools.AlertAndRedirect("修改失败,请与管理员联系", Url.Action("changePassword", "passwordManager", new { area = "account" }));
return("修改失败");
}
}
public ActionResult VerifyInfo(userSecurity security, userInfo info, string code)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
userSecurity[] securityInfo = toolsHelpers.selectToolsController.selectUserSecurity(u => u.loginId == security.loginId, u => u.userId);
if (securityInfo == null || securityInfo.Length == 0)
{
Tools.AlertAndRedirect("没有此用户", Url.Action("VerifyInfo", "passwordManager", new { area = "account" }));
return(Content("没有此用户"));
}
int userId = securityInfo[0].userId;
userInfo[] user = toolsHelpers.selectToolsController.selectUserInfo(u => u.userId == userId, u => u.userId);
if (user == null || user.Length == 0)
{
Tools.AlertAndRedirect("登录名与邮箱不匹配", Url.Action("VerifyInfo", "passwordManager", new { area = "account" }));
return(Content("登录名与邮箱不匹配"));
}
//获取邮箱
string Email = user[0].userEmail;
//把用户输入的验证码 和邮箱地址进行加密验证
string encryptCode = certificateTools.encryptContent(Email);
string encryptemailAddress = certificateTools.encryptContent(code);
//获取Cookies的值
HttpCookie cookieName = Request.Cookies["emailCodePassword"];
var rightCode = Server.HtmlEncode(cookieName.Value);
HttpCookie cookieAddress = Request.Cookies["emailAddressPassword"];
var rightEmail = Server.HtmlEncode(cookieAddress.Value);
if (rightEmail != encryptCode || rightCode != encryptemailAddress)
{
//验证码错误
Tools.AlertAndRedirect("验证失败！", Url.Action("VerifyInfo", "passwordManager", new { area = "account" }));
return(Content("验证失败！"));
}
userSecurity obSecurity = db.userSecurity.Where(u => u.userId == userId).FirstOrDefault();
obSecurity.userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim());
db.SaveChanges();
//清空找回密码相关的cookies
Response.Cookies.Add(CookiesHelper.CookiesHelper.clearCookie("emailCodePassword"));
Response.Cookies.Add(CookiesHelper.CookiesHelper.clearCookie("emailAddressPassword"));
Tools.AlertAndRedirect("修改成功", Url.Action("login", "userManagement", new { area = "account" }));
return(Content("修改成功！"));
}
}
catch
{
Tools.AlertAndRedirect("验证出错,请与管理员联系", Url.Action("VerifyInfo", "passwordManager", new { area = "account" }));
return(Content("验证出错"));
}
}
public JsonResult AjaxTest()
{
userSecurity obj = new userSecurity
{
userId = 10086,
loginId = "CY",
userPwd = "123"
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
public string add(userSecurity security)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
//先判断登录Id是否可用
var isLoginId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim());
if (isLoginId.ToList().Count != 0)
{
return("用户已存在");
}
userSecurity user = new userSecurity
{
loginId = security.loginId,
userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd)
};
//得到插入成功的数据对象以获得userId
userSecurity successUser = toolsHelpers.insertToolsController.insertUserSecurity(user);
if (successUser == null)
{
return("false");
}
//把这个userId写入userInfo表中
userInfo newUserInfo = new userInfo
{
userId = successUser.userId,
userName = successUser.loginId,
userAge = 0,
userSex = 2,
userEmail = null,
userStatus = 1,
userAccount = 0,
userIntroduce = "这个人很懒，没有说什么",
userHeaderPic = "/Resource/picture/DefaultHeadPic1.png",
};
if (toolsHelpers.insertToolsController.insertUserInfo(newUserInfo) == true)
{
Response.Redirect("/backStage/userManagement/Index");
return("success");
}
else
{
return("false");
}
}
}
catch
{
return("false");
}
}
public string registerUser(userSecurity security, userInfo info, string code)
{
//使用entity framework 进行数据的插入
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
//先把用户写入userSecurity表
var isLoginID = db.userSecurity.Where <userSecurity>(u => u.loginId == security.loginId.Trim());
if (isLoginID.ToList().Count != 0)
{
return("已经有账户");
}
userSecurity obSecurity = new userSecurity
{
loginId = security.loginId.Trim(),
userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim()),
};
db.userSecurity.Add(obSecurity);
db.SaveChanges();
//把userInfo表写入默认数据
int uniformId;
DbQuery <userSecurity> dbSecuritySureUserId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()) as DbQuery <userSecurity>;
userSecurity dbSecurity = dbSecuritySureUserId.FirstOrDefault();
uniformId = dbSecurity.userId;
userInfo obInfo = new userInfo
{
userId = uniformId,
userName = security.loginId.Trim(),
userAge = info.userAge,
userSex = info.userSex,
userEmail = info.userEmail,
userStatus = 1,
userAccount = 0,
userIntroduce = "这个人很懒，没有说什么",
userHeaderPic = "/Resource/picture/DefaultHeadPic1.png"
};
db.userInfo.Add(obInfo);
db.SaveChanges();
}
Response.Redirect(Url.Action("Index", "Home", new { area = "" }));
return("Ok");
}
catch (Exception EX)
{
return(EX.ToString());
}
}
/// <summary>
/// 查找用户安全表中符合条件的信息
/// </summary>
/// <param name="whereLambda"></param>
/// <returns></returns>
public static userSecurity[] selectUserSecurity <TKey>(Expression <Func <userSecurity, bool> > whereLambda, Expression <Func <userSecurity, TKey> > orderBy)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userSecurity> dataObject = db.userSecurity.Where(whereLambda).OrderBy(orderBy) as DbQuery <userSecurity>;
userSecurity[] infoList = dataObject.ToArray();
return(infoList);
}
}
catch
{
userSecurity[] nullInfo = new userSecurity[0];
return(nullInfo);
}
}
/// <summary>
/// 往用户安全表中插入数据
/// </summary>
/// <param name="info"></param>
/// <returns>插入数据后的对象</returns>
public static userSecurity insertUserSecurity(userSecurity info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
db.userSecurity.Add(info);
db.SaveChanges();
DbQuery <userSecurity> data = db.userSecurity.Where(u => u.loginId == info.loginId) as DbQuery <userSecurity>;
userSecurity objectUser = data.FirstOrDefault();
return(objectUser);
}
}
catch
{
return(null);
}
}
public string register(userSecurity security, userInfo info)
{
//使用entity framework 进行数据的插入
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
var isLoginID = db.userSecurity.Where <userSecurity>(u => u.loginId == info.userName.Trim());
if (isLoginID.ToList().Count != 0)
{
return("已经有账户");
}
userSecurity obSecurity = new userSecurity
{
loginId = info.userName.Trim(),
userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim()),
};
db.userSecurity.Add(obSecurity);
db.SaveChanges();
int uniformId;
DbQuery <userSecurity> dbSecuritySureUserId = db.userSecurity.Where(u => u.loginId == info.userName.Trim()) as DbQuery <userSecurity>;
userSecurity dbSecurity = dbSecuritySureUserId.FirstOrDefault();
uniformId = dbSecurity.userId;
userInfo obInfo = new userInfo
{
userId = uniformId,
userName = info.userName.Trim(),
userAge = info.userAge,
userSex = info.userSex,
userTel = info.userTel.Trim(),
};
db.userInfo.Add(obInfo);
db.SaveChanges();
}
return("T");
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public string login(userSecurity security)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userSecurity> dbSecuritySureId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()) as DbQuery <userSecurity>;
userSecurity obSureId = dbSecuritySureId.FirstOrDefault();
string MD5Pwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim());
if (obSureId == null)
{
return("未注册");
}
DbQuery <userSecurity> dbSecuritySurePwd = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()).Where(u => u.userPwd == MD5Pwd) as DbQuery <userSecurity>;
userSecurity obSurePwd = dbSecuritySurePwd.FirstOrDefault();
if (obSurePwd != null)
{
HttpCookie cookieName = new HttpCookie("loginId");
cookieName.Value = security.loginId.Trim();
cookieName.Expires = DateTime.Now.AddHours(1);
System.Web.HttpContext.Current.Response.Cookies.Add(CookiesHelper.CookiesHelper.creatCookieHours("userId", obSurePwd.userId.ToString(), 1));
string encryptCertification = certificateTools.makeCertification(obSureId.userId.ToString());
System.Web.HttpContext.Current.Response.Cookies.Add(CookiesHelper.CookiesHelper.creatCookieHours("certification", encryptCertification, 1));
System.Web.HttpContext.Current.Response.Cookies.Add(cookieName);
Response.Redirect(Url.Action("Index", "Home", new { area = "" }));
return("登录成功");
}
else
{
return("密码错误");
}
}
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public ActionResult search(userInfo info)
{
try
{
ViewBag.IsSearchSuccess = false;
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userInfo> dbInfosearch = db.userInfo.Where(u => u.userName == info.userName) as DbQuery <userInfo>;
userInfo _userInfo = dbInfosearch.FirstOrDefault();
DbQuery <userSecurity> dbSecuritysearch = db.userSecurity.Where(u => u.userId == _userInfo.userId) as DbQuery <userSecurity>;
userSecurity _userSecurity = dbSecuritysearch.FirstOrDefault();
if (_userInfo != null)
{
ViewBag.userId = _userSecurity.userId;
ViewBag.loginId = _userSecurity.loginId;
ViewBag.userPwd = _userSecurity.userPwd;
ViewBag.userName = _userInfo.userName;
ViewBag.userAge = _userInfo.userAge;
ViewBag.userSex = _userInfo.userSex;
ViewBag.userTel = _userInfo.userTel;
ViewBag.userStatus = _userInfo.userStatus;
ViewBag.userAccount = _userInfo.userAccount;
}
else
{
return(View("update"));
}
}
ViewBag.IsSearchSuccess = true;
return(View("update"));
}
catch
{
return(View("update"));
}
}
public string chagePassword(userSecurity security, string userNewPwd)
{
try
{
string MD5Pwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim());
string MD5NewPwd = MD5Helper.MD5Helper.encrypt(userNewPwd.Trim());
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userSecurity> dbSecurity = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()).Where(u => u.userPwd == MD5Pwd) as DbQuery <userSecurity>;
userSecurity obSecurity = dbSecurity.FirstOrDefault();
if (obSecurity == null)
{
return("用户名或密码错误");
}
obSecurity.userPwd = MD5NewPwd;
db.SaveChanges();
return("修改成功");
}
}
catch
{
return("修改失败");
}
}
public string findPassword(userSecurity security, userInfo info)
{
try
{
using (LazyfitnessEntities db = new LazyfitnessEntities())
{
DbQuery <userInfo> dbInfo = db.userInfo.Where(u => u.userName == info.userName.Trim()).Where(u => u.userTel == info.userTel.Trim()) as DbQuery <userInfo>;
userInfo obInfo = dbInfo.FirstOrDefault();
if (obInfo == null)
{
return("用户名或电话不正确");
}
//实例化一个要修改的对象
userSecurity obSecurity = db.userSecurity.Where(u => u.loginId == info.userName.Trim()).FirstOrDefault();
obSecurity.userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim());
db.SaveChanges();
return("修改成功");
}
}
catch
{
return("验证失败");
}
}
