public ActionResult StartUser(string id) { bool success = false; string msg = ""; try { SYS_LOGIN_BLL loginbll = SYS_LOGIN_BLL.getInstance(); SYS_LOGIN model = loginbll.GetByUserID(id); if (model.State == 2) { model.State = 1; success = loginbll.Edit(model); } else if (model.State == 0) { msg = "用户尚未授权,无法启用"; } else if (true) { msg = "用户已启用,请勿重复启用"; } } catch (Exception ex) { Common.Helper.Logger.Info(string.Format("启用用户保存异常,异常信息:{0}", ex.ToString())); msg = "启用用户发生异常"; } return(this.Json(new { success = success, msg = msg })); }
public ActionResult Delet(string id) { bool success = false; string msg = ""; try { SYS_LOGIN loginmodel = SYS_LOGIN_BLL.getInstance().GetByUserID(id); if (loginmodel.State == 0) { success = bll.Remove(id, loginmodel.ID); } else { msg = "用户已在使用中,不能删除"; } } catch (Exception ex) { Common.Helper.Logger.Info(string.Format("删除用户,删除异常,UserID-【0】异常信息:{1}", id, ex.ToString())); msg = "删除异常"; } return(this.Json(new { success = success, msg = msg })); }
public ActionResult Edit(SYS_USER usermodel, SYS_LOGIN loginmodel) { bool success = false; string msg = ""; try { SYS_USER editmodel = SYS_USER_BLL.getInstance().GetById(usermodel.UserID.ToString()); SYS_LOGIN logineditmodel = SYS_LOGIN_BLL.getInstance().GetByUserID(usermodel.UserID.ToString()); //输入密码 if (!string.IsNullOrWhiteSpace(loginmodel.UserPassword)) { loginmodel.UpdateDate = DateTime.Now; loginmodel.UpdateUserID = UserSession.AccountInfo.UserID; loginmodel.CreateUserID = logineditmodel.CreateUserID; loginmodel.CreateDate = loginmodel.CreateDate; loginmodel.UserPassword = EncryptHelper.MD5DecryptString(loginmodel.UserPassword); } usermodel.UpdateDate = DateTime.Now; usermodel.UpdateUserID = UserSession.AccountInfo.UserID; usermodel.CreateDate = editmodel.CreateDate; usermodel.CreateUserID = editmodel.CreateUserID; success = bll.EditUser(usermodel, loginmodel); } catch (Exception ex) { Common.Helper.Logger.Info(string.Format("保存用户信息,保存异常,异常信息:{0}", ex.ToString())); msg = "保存异常"; } return(this.Json(new { success = success, msg = msg })); }
public ActionResult Add(SYS_USER usermodel, SYS_LOGIN loginmodel) { bool success = false; string msg = "保存成功"; try { if (!bll.IsExist(loginmodel.UserName)) { usermodel.CreateDate = DateTime.Now; usermodel.CreateUserID = UserSession.AccountInfo.UserID; loginmodel.CreateDate = DateTime.Now; loginmodel.CreateUserID = UserSession.AccountInfo.UserID; loginmodel.State = 0; loginmodel.UserPassword = EncryptHelper.MD5DecryptString(loginmodel.UserPassword); success = bll.SaveUser(usermodel, loginmodel); } else { msg = "用户名已存在"; } } catch (Exception ex) { Common.Helper.Logger.Info(string.Format("保存用户信息,保存异常,异常信息:{0}", ex.ToString())); msg = "保存异常"; } return(this.Json(new { success = success, msg = msg })); }
/// <summary> /// 编辑用户信息,登录信息 /// </summary> /// <param name="usermodel"></param> /// <param name="loginmodel"></param> /// <returns></returns> public bool EditUser(SYS_USER usermodel, SYS_LOGIN loginmodel) { bool success = false; using (var dbcontext = DbFactory.Create()) { try { //重置密码 if (!string.IsNullOrWhiteSpace(loginmodel.UserPassword)) { dbcontext.Update(loginmodel); } dbcontext.Update(usermodel); dbcontext.Save(); success = true; } catch (Exception ex) { success = false; Logger.Error(string.Format("SYS_USER_BLL 编辑用户信息,异常信息:{0}", ex.ToString())); } } return(success); }
/// <summary> /// 存入Session /// </summary> /// <param name="LoginID"></param> public void SaveSession(SYS_LOGIN loginmodel) { List <UserMenuModel> mennulist = null; SYS_USER usermodel = null; List <SYS_ROLE> userrolelist = null; using (var dbcontext = DbFactory.Create()) { #region 获取用户菜单 var args1 = new DbParameter[] { new SqlParameter { ParameterName = "@id", Value = loginmodel.ID }, }; StringBuilder strmenuSql = new StringBuilder(); strmenuSql.Append(" SELECT distinct(M.MenuCode),M.MenuName,M.ParentCode,M.LinkAddress,M.Sort,M.IconScript FROM [SYS_USER] U "); strmenuSql.Append(" INNER JOIN [SYS_LOGIN] L ON L.UserName =U.UserName"); strmenuSql.Append(" INNER JOIN [SYS_ROLE_USER] R ON R.UserID=U.UserID"); strmenuSql.Append(" INNER JOIN [SYS_ROLE_MENU_BUTTON] MB ON R.RoleID=MB.RoleID"); strmenuSql.Append(" INNER JOIN [SYS_MENU] M ON M.MenuCode=MB.MenuCode WHERE L.ID=@id order by M.ParentCode,M.Sort"); mennulist = dbcontext.SqlQuery <UserMenuModel>(strmenuSql.ToString(), args1); #endregion #region 获取用户信息 Expression <Func <SYS_USER, bool> > exp = a => a.UserName == loginmodel.UserName; usermodel = dbcontext.Get(exp); #endregion #region 获取用户角色 var args2 = new DbParameter[] { new SqlParameter { ParameterName = "@userid", Value = usermodel.UserID }, }; StringBuilder strroleSql1 = new StringBuilder(); strroleSql1.Append(" SELECT R.* FROM [SYS_ROLE_USER] RU"); strroleSql1.Append(" INNER JOIN [SYS_USER] U ON RU.UserID=U.UserID"); strroleSql1.Append(" INNER JOIN [SYS_ROLE] R ON R.RoleID=RU.RoleID"); strroleSql1.Append(" WHERE U.UserID=@userid"); userrolelist = dbcontext.SqlQuery <SYS_ROLE>(strroleSql1.ToString(), args2); #endregion UserSession user = new UserSession(); user.Rolelist = userrolelist; user.Menulist = mennulist; user.AccountInfo = usermodel; user.logininfo = loginmodel; SessionHelper.Add("Account", user, 30); } }
/// <summary> /// 验证登录 /// </summary> /// <param name="para"></param> /// <returns></returns> public LoginState CheckLogin(SYS_LOGIN logininfo) { LoginState state = LoginState.NoLogin; using (var dbcontext = DbFactory.Create()) { try { Expression <Func <SYS_LOGIN, bool> > exp = a => a.UserName == logininfo.UserName; SYS_LOGIN model = dbcontext.Get(exp); if (model == null) { //账号不存在 state = LoginState.AccountNoExist; } else { string inputpwd = EncryptHelper.MD5DecryptString(logininfo.UserPassword); if (inputpwd == model.UserPassword) { if (model.State == 1) { //成功 state = LoginState.Success; SaveSession(model); } else if (model.State == 0) { //未授权 state = LoginState.NoAuthorize; } else if (model.State == 2) { //账号锁定 state = LoginState.AccountLock; } } else { //密码错误 state = LoginState.PwdError; } } } catch (Exception ex) { Logger.Error(string.Format("【账号】-{0},登录异常,异常信息:{1}", logininfo.UserName, ex.ToString())); } } return(state); }
////// <summary> ////// 分页查询 ////// </summary> ////// <param name="pageIndex"></param> ////// <param name="pageSize"></param> ////// <param name="whLamdba"></param> ////// <param name="recordCount"></param> ////// <param name="pageCount"></param> ////// <returns></returns> ///public List<SYS_LOGIN> PageQuery<TKey>(int pageIndex, int pageSize, Expression<Func<SYS_LOGIN, bool>> whLamdba,Expression<Func<SYS_LOGIN, TKey>> orderByLamdba, out int recordCount, out int pageCount) ///{ /// List<SYS_LOGIN> list = null; /// try /// { /// if (pageIndex == 0) /// { /// pageIndex = 1; /// } /// list = idal.PageQuery(pageIndex, pageSize, out recordCount, out pageCount, whLamdba, orderByLamdba); /// } /// catch (Exception ex) /// { /// recordCount = 0; /// pageCount = 0; /// Logger.Error(string.Format("SYS_LOGIN_BLL 分页查询异常,异常信息:{0}", ex.ToString())); /// } /// return list; ///} /// <summary> /// 分页查询 /// </summary> /// <param name="modle"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="recordCount"></param> /// <param name="pageCount"></param> /// <returns></returns> public DataTable PageQuery(SYS_LOGIN modle, int pageIndex, int pageSize, out int recordCount, out int pageCount) { DataTable dt = new DataTable(); using (var dbcontext = DbFactory.Create()) { try { SearchCondition condition = new SearchCondition(); if (modle != null) { #region 组装查询条件 //if (!string.IsNullOrWhiteSpace(modle.PlayerNickname)) //{ // condition.AddCondition("a.PlayerNickname", modle.PlayerNickname, SqlOperator.Like, true); //} #endregion } PagerInfo pager = new PagerInfo(); #region 组装存储过程调用参数 //pager.curPage = pageIndex; //pager.pageSize = pageSize; //pager.isDescending = true; //pager.fields = "a.*,c.GameName"; //pager.sortField = "a.UploadTime"; //pager.indexField = "a.ID"; //pager.where = null; //pager.condition = condition; //pager.tableName = "[ZhpGame].[dbo].[Zhp_GameRecord] a left join [Zhp_OnlineGame] b on a.Gameid=b.Gameid left join [Zhp_GameConfig] c on b.GameCode= c.GameCode "; #endregion dt = dbcontext.PageQuery(pager, out recordCount, out pageCount); } catch (Exception ex) { recordCount = 0; pageCount = 0; Logger.Error(string.Format("SYS_LOGIN_BLL 分页查询异常,异常信息:{0}", ex.ToString())); } } return(dt); }
/// <summary> /// 新增记录 /// </summary> /// <param name="model">待新增实体</param> /// <returns></returns> public bool BulkAdd(List <SYS_ROLE_USER> list, string userid) { bool success = false; using (var dbcontext = DbFactory.Create()) { try { //批量删除 int keyid = Convert.ToInt32(userid); Expression <Func <SYS_ROLE_USER, bool> > exp = a => a.UserID == keyid; dbcontext.Delete(exp); //批量插入 if (list != null && list.Count > 0) { foreach (var item in list) { dbcontext.Insert(item); } //改变授权状态 已授权 SYS_LOGIN loginmodel = SYS_LOGIN_BLL.getInstance().GetByUserID(userid); loginmodel.State = 1; dbcontext.Update(loginmodel); } else { //改变授权状态 未授权 SYS_LOGIN loginmodel = SYS_LOGIN_BLL.getInstance().GetByUserID(userid); loginmodel.State = 0; dbcontext.Update(loginmodel); } //保存 dbcontext.Save(); success = true; } catch (Exception ex) { Logger.Error(string.Format("SYS_ROLE_USER_BLL 新增记录异常,异常信息:{0}", ex.ToString())); } } return(success); }
/// <summary> /// 根据主键获取实体 /// </summary> /// <param name="pkId">主键</param> /// <returns></returns> public SYS_LOGIN GetById(string pkId) { SYS_LOGIN model = null; using (var dbcontext = DbFactory.Create()) { try { int id = Convert.ToInt32(pkId); Expression <Func <SYS_LOGIN, bool> > exp = a => a.ID == id; model = dbcontext.Get(exp); } catch (Exception ex) { Logger.Error(string.Format("SYS_LOGIN_BLL 根据主键获取实体异常,异常信息:{0}", ex.ToString())); } } return(model); }
/// <summary> /// 获取登录信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public SYS_LOGIN GetByUserID(string id) { SYS_LOGIN model = null; using (var dbcontext = DbFactory.Create()) { try { string username = SYS_USER_BLL.getInstance().GetById(id).UserName; Expression <Func <SYS_LOGIN, bool> > exp = a => a.UserName == username; model = dbcontext.Get(exp); } catch (Exception ex) { Logger.Error(string.Format("判断用户是否授权,异常,异常信息:UserID-【0】-{1}", id, ex.ToString())); } } return(model); }
/// <summary> /// 编辑 /// </summary> /// <param name="model">新实体</param> /// <returns></returns> public bool Edit(SYS_LOGIN model) { bool success = false; using (var dbcontext = DbFactory.Create()) { try { dbcontext.Update(model); dbcontext.Save(); success = true; } catch (Exception ex) { success = false; Logger.Error(string.Format("SYS_LOGIN_BLL 编辑记录异常,异常信息:{0}", ex.ToString())); } } return(success); }
/// <summary> /// 根据条件获取列表 /// </summary> /// <param name="querymodel">条件</param> /// <returns></returns> public List <SYS_LOGIN> GetList(SYS_LOGIN querymodel) { List <SYS_LOGIN> list = null; using (var dbcontext = DbFactory.Create()) { try { int id = Convert.ToInt32(querymodel.ID); Expression <Func <SYS_LOGIN, bool> > exp = a => a.ID == id; Expression <Func <SYS_LOGIN, bool> > temp = a => 1 == 1; exp = CompileLinqSearch.AndAlso(exp, temp); list = dbcontext.Find(exp); } catch (Exception ex) { Logger.Error(string.Format("SYS_LOGIN_BLL 根据条件获取列表异常,异常信息:{0}", ex.ToString())); } } return(list); }
/// <summary> /// 保存用户信息,登录信息 /// </summary> /// <param name="usermodel"></param> /// <param name="loginmodel"></param> /// <returns></returns> public bool SaveUser(SYS_USER usermodel, SYS_LOGIN loginmodel) { bool success = false; using (var dbcontext = DbFactory.Create()) { try { dbcontext.Insert(usermodel); dbcontext.Insert(loginmodel); dbcontext.Save(); success = true; } catch (Exception ex) { success = false; Logger.Error(string.Format("SYS_USER_BLL 插入用户信息,异常信息:{0}", ex.ToString())); } } return(success); }
/// <summary> /// 验证登录 /// </summary> /// <param name="username"></param> /// <param name="pwd"></param> /// <param name="usercode"></param> /// <param name="remember"></param> /// <returns></returns> public ActionResult CheckLogin(string username, string pwd, string usercode, bool remember) { // 验证码如果不为空,则需要验证码判断 if (!string.IsNullOrEmpty(usercode)) { string valerror = string.Empty; //if (!ValiDateCode(0, usercode.ToUpper(), out valerror)) //{ // return this.Json(new // { // success = false, // error = valerror // }); //} } SYS_LOGIN para = new SYS_LOGIN(); para.UserName = username; para.UserPassword = pwd; try { // 1.返回用户信息,权限信息,菜单信息等 LoginState state = SYS_LOGIN_BLL.getInstance().CheckLogin(para); // 2.密码错误 if (state == LoginState.PwdError) { return(this.Json(new { success = false, error = "密码输入错误" })); } // 3.用户被禁用 if (state == LoginState.AccountLock) { return(this.Json(new { success = false, error = "用户已被禁用,请联系管理员" })); } // 4.账户不存在 if (state == LoginState.AccountNoExist) { return(this.Json(new { success = false, error = "账号不存在" })); } // 5.账户未授权 if (state == LoginState.NoAuthorize) { return(this.Json(new { success = false, error = "账号未经授权,请联系管理员" })); } // 用户选择记住账号 if (remember) { CookieHelper.SetCookie("username", username); } return(this.Json(new { success = true, })); } catch (Exception ex) { Logger.Error(string.Format("【账号】-{0},登录异常,异常信息:{1}", username, ex.ToString())); return(Json(new { success = false, error = ex.Message })); } }