public JsonResult List(SysUserViewModel viewModel, PageInfo pageInfo) { QueryCollection queries = new QueryCollection(); if (!string.IsNullOrEmpty(viewModel.UserName)) { queries.Add(new Query { Name = "UserName", Operator = Query.Operators.Contains, Value = viewModel.UserName }); } if (!string.IsNullOrEmpty(viewModel.NickName)) { queries.Add(new Query { Name = "NickName", Operator = Query.Operators.Contains, Value = viewModel.NickName }); } var list = SysUserService.GetListByPage(queries.AsExpression <SysUser>(), x => true, pageInfo.Limit, pageInfo.Page, out int totalCount, true).Select(x => new { x.Id, x.UserName, x.NickName, x.HeadIcon, x.MobilePhone, x.Email, x.EnabledMark }).ToList(); return(Json(Pager.Paging(list, totalCount), JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> Remove(SysUserViewModel model) { if (ModelState.IsValid) { SysUser currentUser = UserManager.FindById(model.Id); if (currentUser == null) { ModelState.AddModelError("", "用户不存在。"); } if (currentUser != null && currentUser.Id < 1) //if (model.UserName == "admin") { ModelState.AddModelError("", "系统内置用户不能删除。"); //"admin用户不允许删除"); } else { var result = await UserManager.DeleteAsync(currentUser); if (!result.Succeeded) { foreach (string error in result.Errors) { ModelState.AddModelError("", error); } } } } var allErrors = this.GetModelStateErrors(ModelState); return(Json(allErrors)); }
public async Task <ActionResult> Edit(SysUserViewModel model) { if (ModelState.IsValid) { if (model.Id < 1) { ModelState.AddModelError(string.Empty, "系统内置用户不允许修改。"); } SysUser currentUser = UserManager.FindById(model.Id); if (currentUser == null) { ModelState.AddModelError("", "用户不存在"); } else if (model.UserName != currentUser.UserName && UserManager.FindByName(model.UserName) != null) { ModelState.AddModelError("", "用户名已存在"); } else { List <string> errorMsgs = new List <string>(); await HandleUserEditWithRole(model, currentUser, errorMsgs); foreach (string error in errorMsgs) { ModelState.AddModelError("", error); } } } var allErrors = this.GetModelStateErrors(ModelState); return(Json(allErrors)); }
public IActionResult Index() { Expression <Func <Sys_User, bool> > exp = c => c.UserId == "admin" && c.PassWord == "111"; SysUserViewModel list = _sysUserService.GetMany(exp); //SysUserViewModel studentViewModel = _sysUserService.GetAll().FirstOrDefault(); return(View(_sysUserService.GetAll())); }
public async Task <ApiResult <object> > Item(int id) { var res = new ApiResult <object>(); int UserID = GetUserID(); if (UserID > 0) { UserInfo m; SysUserViewModel d; if (id > 0) { d = new SysUserViewModel(); m = db.GetId(id); if (m != null) { d.ID = m.ID; d.UserName = m.UserName; d.Password = m.Password; d.HeadPortrait = m.HeadPortrait; d.NickName = m.NickName; d.FullName = m.FullName; d.Position = m.Position; d.IdCard = Utility.IdCardUnEncrypt(m.IdCard); d.Gender = m.Gender; d.MobilePhone = m.MobilePhone; d.QQ = m.QQ; d.Mail = m.Mail; d.State = m.State; d.RoleID = m.RoleID; } else { res.msg = "参数丢失"; res.statusCode = (int)ApiEnum.Status; } } else { d = new SysUserViewModel(); // 设置默认值用于页面显示 d.RoleID = 0; d.State = 2; } res.data = d; if (res.data != null) { res.success = true; } } else { res.statusCode = (int)ApiEnum.Status; res.msg = "无法获取用户信息!"; } return(await Task.Run(() => res)); }
public ActionResult EditUser(SysUserViewModel model) { if (ModelState.IsValid) { if (model.UserModel.Id == 0) { model.UserModel.Password = WebUtils.GetAppSettingValue(StaticKey.AppDefaultUserPwd).ToMd5(); _uow.SysUserService.Add(model.UserModel); _uow.Commit(); if (model.HaveRoles != null) { foreach (var item in model.HaveRoles) { _uow.RelUserRoleService.Add(new RelUserRole() { UserId = model.UserModel.Id, RoleId = item }); } } } else { var old = _uow.SysUserService.Get(t => t.Id == model.UserModel.Id); if (old != null) { old.LogonName = model.UserModel.LogonName; old.TrueName = model.UserModel.TrueName; old.Phone = model.UserModel.Phone; old.Email = model.UserModel.Email; //删除角色 var urList = _uow.RelUserRoleService.GetQueryList(t => t.UserId == old.Id); foreach (var item in urList) { _uow.RelUserRoleService.Delete(item); } //新加角色 if (model.HaveRoles != null) { foreach (var item in model.HaveRoles) { _uow.RelUserRoleService.Add(new RelUserRole() { UserId = model.UserModel.Id, RoleId = item }); } } } } _uow.Commit(); } return(RedirectToAction("User")); }
public ActionResult EditUser(int?id) { var vm = new SysUserViewModel(); vm.SubMenuList = GetSubMenuList(); vm.UserModel = new SysUser(); vm.UserModel.Password = WebUtils.GetAppSettingValue(StaticKey.AppDefaultUserPwd).ToMd5(); vm.HaveRoles = new HashSet <int>(); vm.RoleList = _uow.SysRoleService.GetQueryList().ToList(); if (id.HasValue) { vm.UserModel = _uow.SysUserService.Get(t => t.Id == id.Value); vm.HaveRoles = _uow.RelUserRoleService.GetQueryList(t => t.UserId == id.Value).Select(t => t.RoleId).ToHashSet(); } return(View(vm)); }
public ActionResult User(string logonName, int?pageIndex) { var vm = new SysUserViewModel(); if (pageIndex.HasValue) { vm.PageIndex = pageIndex.Value; } var list = _uow.SysUserService.GetQueryList(); if (!string.IsNullOrEmpty(logonName)) { list = list.Where(t => t.LogonName.Contains(logonName)); } vm.SysUserList = new Common.Helper.PageList <SysUser>(list.OrderBy(t => t.Id), vm.PageIndex, vm.PageCount); vm.SubMenuList = GetSubMenuList(); return(View(vm)); }
public ActionResult Edit(int id, SysUserViewModel viewModel) { if (ModelState.IsValid == false) { return(WriteError("实体验证失败")); } var user = SysUserService.GetList(x => x.UserName == viewModel.UserName && x.Id != id).FirstOrDefault(); if (user != null) { return(WriteError("该账号已存在")); } //获取角色 var roleList = new List <SysRole>(); if (!string.IsNullOrEmpty(viewModel.RoleIds)) { var RoleIdsArray = Array.ConvertAll(viewModel.RoleIds.Split(','), s => int.Parse(s)); roleList = SysRoleService.GetList(x => RoleIdsArray.Contains(x.Id)).ToList(); } //赋值 var entity = SysUserService.GetList(x => x.Id == id).FirstOrDefault(); entity.SysRoles.Clear(); foreach (var item in roleList) { entity.SysRoles.Add(item); } entity.UserName = viewModel.UserName; entity.NickName = viewModel.NickName; entity.HeadIcon = viewModel.HeadIcon; entity.MobilePhone = viewModel.MobilePhone; entity.Email = viewModel.Email; entity.EnabledMark = (int)viewModel.EnabledMark; entity.MobilePhone = viewModel.MobilePhone; entity.Email = viewModel.Email; entity.UpdateTime = DateTime.Now; entity.UpdateUserId = UserManager.GetCurrentUserInfo().Id; SysUserService.Update(entity); return(WriteSuccess()); }
private async Task HandleUserEditWithRole(SysUserViewModel model, SysUser currentUser, List <string> errorMsgs) { currentUser.UserName = model.UserName; currentUser.Name = model.Name; currentUser.Email = model.Email; currentUser.PhoneNumber = model.PhoneNumber; var result = await UserManager.UpdateAsync(currentUser); if (!result.Succeeded) { errorMsgs.AddRange(result.Errors); return; } result = IdentityResult.Success; if (!UserManager.IsInRole(currentUser.Id, model.RoleName)) { result = await UserManager.AddToRoleAsync(currentUser.Id, model.RoleName); } if (!result.Succeeded) { errorMsgs.AddRange(result.Errors); return; } var roleList = UserManager.GetRoles(currentUser.Id); foreach (var r in roleList) { if (r.Equals(model.RoleName)) { continue; } var res = UserManager.RemoveFromRole(currentUser.Id, r); if (!result.Succeeded) { errorMsgs.AddRange(result.Errors); } } }
public string UserLoginCheck(string userName, string pass) { string result = null; try { if (OperateWithRedis.KeyExpireFun("UserKey:" + userName, TimeSpan.FromMinutes(20))) { Expression <Func <Sys_User, bool> > exp = c => c.UserId == userName && c.PassWord == pass; SysUserViewModel list = _sysUserService.GetMany(exp); SysUserListsVO ss = _sysUserService.GetUserRoles(Guid.Parse("5F77AF22-33F1-429E-AB51-3A3F46B65734")); OperateWithRedis.StringSetFun("UserKey:" + userName, JsonConvert.SerializeObject(ss), 0, TimeSpan.FromMinutes(20)); JsonConvert.SerializeObject(ss); } } catch (Exception ex) { return(""); } }
public ActionResult Create(SysUserViewModel studentView) { try { if (!ModelState.IsValid) { return(View(studentView)); } _sysUserService.Add(studentView); ////对错误进行记录,还需要抛给前台 var notificacoes = _domainNotificationHandler.GetNotifications(); notificacoes.ForEach(c => ViewData.ModelState.AddModelError(string.Empty, c.Value)); return(View()); } catch (Exception ex) { throw; } //return View(studentView); }
public ActionResult Create(SysUserViewModel viewModel) { try { if (ModelState.IsValid == false) { return(WriteError("实体验证失败")); } var user = SysUserService.GetList(x => x.UserName == viewModel.UserName).FirstOrDefault(); if (user != null) { return(WriteError("该账号已存在")); } string salt = VerifyCodeUtils.CreateVerifyCode(5); string passwordHash = Md5Utils.EncryptTo32(salt + ConfigUtils.GetValue("InitUserPwd")); SysUser entity = viewModel.EntityMap(); entity.CreateUserId = UserManager.GetCurrentUserInfo().Id; entity.UpdateUserId = UserManager.GetCurrentUserInfo().Id; entity.CreateTime = DateTime.Now; entity.UpdateTime = DateTime.Now; entity.PasswordSalt = salt; entity.PasswordHash = passwordHash; if (!string.IsNullOrEmpty(viewModel.RoleIds)) { var RoleIdsArray = Array.ConvertAll(viewModel.RoleIds.Split(','), s => int.Parse(s)); var roleList = SysRoleService.GetList(x => RoleIdsArray.Contains(x.Id)).ToList(); entity.SysRoles = roleList; } SysUserService.Add(entity); return(WriteSuccess()); } catch (Exception ex) { return(WriteError(ex)); } }
public IList <GameHistoryViewModel> SearchGameHistoryFunc(DataTableAjaxPostModel model, out int filteredResultsCount, out int totalResultsCount, int sysUserId) { var user = new SysUserViewModel(); if (sysUserId > 0) { user = Mapper.Map <SysUserViewModel>(_sysUserService.Queryable().Where(x => x.Id == sysUserId).FirstOrDefault()); } else { user = HttpContext.Session.GetObjectFromJson <SysUserViewModel>("CurrentUser"); } var searchBy = (model.search.value != null) ? model.search.value : ""; var pageSize = model.length; var pageIndex = model.start + 1; var take = model.length; var skip = model.start; string sortBy = ""; string sortDir = "desc"; if (model.order != null) { // in this example we just default sort on the 1st column sortBy = model.columns[model.order[0].column].data; sortDir = model.order[0].dir.ToLower(); } // search the dbase taking into consideration table sorting and paging List <SqlParameter> storeParams = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@SysUserId", SqlDbType = SqlDbType.Int, Value = sysUserId }, new SqlParameter() { ParameterName = "@PageSize", SqlDbType = SqlDbType.Int, Value = pageSize }, new SqlParameter() { ParameterName = "@PageIndex", SqlDbType = SqlDbType.Int, Value = pageIndex }, new SqlParameter() { ParameterName = "@OrderColumn", SqlDbType = SqlDbType.NVarChar, Value = sortBy }, new SqlParameter() { ParameterName = "@OrderDirection", SqlDbType = SqlDbType.NVarChar, Value = sortDir }, new SqlParameter() { ParameterName = "@SearchValue", SqlDbType = SqlDbType.NVarChar, Value = searchBy }, }; var dataSet = _dataContextAsync.ExecuteStoredProcedure("[usp_GetGameHistory]", storeParams); DataTable table = dataSet.Tables[0]; var rows = new List <DataRow>(table.Rows.OfType <DataRow>()); // the Rows property of the DataTable object is a collection that implements IEnumerable but not IEnumerable<T> totalResultsCount = Convert.ToInt32((dataSet.Tables[1].Rows[0])["TotalCount"]); filteredResultsCount = Convert.ToInt32((dataSet.Tables[2].Rows[0])["FilteredCount"]); return(Mapper.Map <List <DataRow>, List <GameHistoryViewModel> >(rows)); }
public async Task <ApiResult <IEnumerable <SysUserViewModel> > > List(int pageIndex, int RoleID, int StateID, string Title, string Phone) { // 以接口的形式返回数据 var res = new ApiResult <IEnumerable <SysUserViewModel> >(); int UserID = GetUserID(); if (UserID > 0) { if (pageIndex == 0) { pageIndex = 1; } List <SysUserViewModel> list = new List <SysUserViewModel>(); var parm = Expressionable.Create <UserInfo>() .AndIF(!string.IsNullOrEmpty(Title), m => m.FullName.Contains(Title) || m.NickName.Contains(Title)) .AndIF(RoleID != 0, m => m.RoleID == RoleID) .AndIF(StateID != 0, m => m.State == StateID) .AndIF(!string.IsNullOrEmpty(Phone), m => m.MobilePhone.Contains(Phone)); var Paged = db.GetPages(parm.ToExpression(), new PageParm(pageIndex), "ID DESC"); var data = Paged.DataSource; if (data != null) { foreach (var item in data) { SysUserViewModel sysUserView = new SysUserViewModel(); sysUserView.ID = item.ID; sysUserView.UserName = item.UserName; sysUserView.Password = item.Password; sysUserView.HeadPortrait = item.HeadPortrait; sysUserView.NickName = item.NickName; sysUserView.FullName = item.FullName; sysUserView.Position = item.Position; sysUserView.IdCard = item.IdCard; sysUserView.Gender = item.Gender; sysUserView.MobilePhone = item.MobilePhone; sysUserView.QQ = item.QQ; sysUserView.Mail = item.Mail; sysUserView.State = item.State; sysUserView.AddDate = Utility.GetDateFormat(item.AddDate); if (item.RoleID == 0) { sysUserView.RoleName = ""; } else { sysUserView.RoleName = roleDb.GetId(item.RoleID).Names; } list.Add(sysUserView); } res.data = list; if (res.data != null) { res.success = true; res.index = pageIndex; res.count = Paged.TotalCount; res.size = Paged.PageSize; } else { res.msg = "无数据"; res.statusCode = (int)ApiEnum.Status; } } else { res.msg = "参数丢失"; res.statusCode = (int)ApiEnum.Status; } } else { res.msg = "无法获取用户信息!"; res.statusCode = (int)ApiEnum.Status; } return(await Task.Run(() => res)); }
/// <summary> /// 添加用户 /// </summary> /// <param name="sysUserViewModel"></param> public void Add(SysUserViewModel sysUserViewModel) { var addCommand = _mapper.Map <AddUserCommand>(sysUserViewModel); _bus.SendCommand(addCommand); }
public void Update(SysUserViewModel sysUserViewModel) { _sysUserRepository.Update(_mapper.Map <Sys_User>(sysUserViewModel)); }