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
}));
}
