protected override void OnAuthentication(AuthenticationContext filterContext) { var authCookie = HttpContext.Request.Cookies[FormsAuthentication.FormsCookieName]; if (authCookie != null) { FormsAuthenticationTicket ticket = null; try { ticket = FormsAuthentication.Decrypt(authCookie.Value); } catch (Exception) { LogOut(filterContext); } if (ticket != null) { CurrentUser = ticket.UserData.JsonToObject <CsSystemUsers>(); ViewBag.UserName = CurrentUser.SysUserName; if (CurrentUser == null) { LogOut(filterContext); } } else { LogOut(filterContext); } } else { LogOut(filterContext); } }
public bool Update(CsSystemUsers model) { var strSql = new StringBuilder(); strSql.Append("UPDATE CrabShop.dbo.[CsSystemUsers] SET "); strSql.Append("SysUserName = @SysUserName,SysUserPassword = @SysUserPassword,SysUserType = @SysUserType,SysUserState = @SysUserState,SysUserDate = @SysUserDate,DeleteDate = @DeleteDate,DeleteDescribe = @DeleteDescribe"); strSql.Append(" WHERE SysUserId = @SysUserId"); return(DbClient.Excute(strSql.ToString(), model) > 0); }
public int Add(CsSystemUsers model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsSystemUsers] ("); strSql.Append("SysUserName,SysUserPassword,SysUserType,SysUserState,SysUserDate,DeleteDate,DeleteDescribe"); strSql.Append(") VALUES ("); strSql.Append("@SysUserName,@SysUserPassword,@SysUserType,@SysUserState,@SysUserDate,@DeleteDate,@DeleteDescribe);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }
public ActionResult SubmitCsSystemUsers(CsSystemUsers model) { if (_csSystemUsersBll.GetModelList($" AND SysUserName = '******' ").Any() && model.SysUserId == 0) { return(Json(new ResModel { ResStatus = ResStatue.Warn, Data = "已存在的用户名,请重新设置" })); } var admin = _csSystemUsersBll.GetModelList(" AND SysUserType = 1 AND SysUserState = 1").FirstOrDefault(); if (model.SysUserType == SysUserType.管理员.GetHashCode() && admin != null && admin.SysUserId != model.SysUserId) { return(Json(new ResModel { ResStatus = ResStatue.Warn, Data = "最多只能存在一个管理员, 请勿重复设置管理员" })); } if (model.SysUserType == SysUserType.普通用户.GetHashCode() && model.SysUserId == admin?.SysUserId) { return(Json(new ResModel { ResStatus = ResStatue.Warn, Data = "此用户是管理员不能设置为普通用户,以及不能无效管理员数据" })); } ResStatue code; var msg = string.Empty; if (model.SysUserId > 0) { code = _csSystemUsersBll.Update(model) ? ResStatue.Yes : ResStatue.No; } else { model.SysUserDate = DateTime.Now; code = _csSystemUsersBll.Add(model) > 0 ? ResStatue.Yes : ResStatue.No; } return(Json(new ResModel { ResStatus = code, Data = msg })); }