public ActionResult InsertAsync(SysAccountInfo entity) { entity.CreatorId = mLogin.Id.ToString(); //所有AJAX的结果,返回统一数据格式 var result = new AjaxResult(); try { var queryLogin = SysAccountInfoContract.CheckExists(m => m.Login.Equals(entity.Login) && m.IsDeleted == false); var querySuName = SysAccountInfoContract.CheckExists(m => m.SuName.Equals(entity.SuName) && m.IsDeleted == false); if (queryLogin) { result.Type = AjaxResultType.Error; result.Content = "登录名已被使用"; } else if (querySuName) { result.Type = AjaxResultType.Error; result.Content = "员工已经存在"; } else { var count = SysAccountInfoContract.Insert(entity); if (count > 0) { result.Type = AjaxResultType.Success; result.Content = "录入成功"; } else { result.Type = AjaxResultType.Error; result.Content = "录入失败"; } } } catch (Exception ex) { result.Type = AjaxResultType.Error; result.Content = "异常操作"; } return(JsonEx(result)); }
/// <summary> /// 修改信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public ActionResult EditAsync(SysAccountInfo entity) { var result = new AjaxResult(); try { var count = SysAccountInfoContract.UpdateDirect(d => d.Id == entity.Id, d => new SysAccountInfo { SuName = entity.SuName, Position = entity.Position, Role = entity.Role, Phone = entity.Phone, Identity = entity.Identity, Email = entity.Email, Explain = entity.Explain, Login = entity.Login, Password = entity.Password }); if (count > 0) { result.Type = AjaxResultType.Success; result.Content = "修改成功"; } else { result.Type = AjaxResultType.Error; result.Content = "修改失败"; } } catch { result.Type = AjaxResultType.Error; result.Content = "异常操作"; } return(JsonEx(result)); }
public AjaxResult <SysAccountInfo> GetSysAccountInfo(int managerid) { var user = db.WebSysManager.FirstOrDefault(m => m.ManagerId == managerid); if (user == null) { user = new WebSysManager(); } SysAccountInfo info = new SysAccountInfo() { IsSupper = user.IsSupper ?? 0, ManagerEmail = user.ManagerEmail, ManagerId = user.ManagerId, ManagerRealname = user.ManagerRealname, ManagerStatus = user.ManagerStatus ?? 0, ManagerTel = user.ManagerTel, ManagerName = user.ManagerName, }; var roles = db.WebSysRole.ToList(); var userRoles = db.WebSysManagerRole.Where(m => m.ManagerId == user.ManagerId); info.Roles = new List <RoleItemInfo>(); foreach (var role in roles) { RoleItemInfo addItem = new RoleItemInfo() { RoleID = role.RoleId, RoleName = role.RoleName, }; var userRole = userRoles.FirstOrDefault(m => m.RoleId == role.RoleId); if (userRole != null) { addItem.Checked = 1; } info.Roles.Add(addItem); } return(new AjaxResult <SysAccountInfo>(info)); }
/// <summary> /// 删除实体 /// </summary> /// <param name="entity">实体对象</param> /// <returns>操作影响的行数</returns> public int Delete(SysAccountInfo entity) { return(Repository.Delete(entity)); }
/// <summary> /// 插入实体 /// </summary> /// <param name="entity">实体对象</param> /// <returns>操作影响的行数</returns> public int Insert(SysAccountInfo entity) { return(Repository.Insert(entity)); }
/// <summary> /// 异步更新实体对象 /// </summary> /// <param name="entity">更新后的实体对象</param> /// <returns>操作影响的行数</returns> public Task <int> UpdateAsync(SysAccountInfo entity) { return(Repository.UpdateAsync(entity)); }
/// <summary> /// 异步插入实体 /// </summary> /// <param name="entity">实体对象</param> /// <returns>操作影响的行数</returns> public Task <int> InsertAsync(SysAccountInfo entity) { return(Repository.InsertAsync(entity)); }
/// <summary> /// 更新实体对象 /// </summary> /// <param name="entity">更新后的实体对象</param> /// <returns>操作影响的行数</returns> public int Update(SysAccountInfo entity) { return(Repository.Update(entity)); }
public AjaxResult <Object> SaveAccountInfo(SysAccountInfo model) { if (string.IsNullOrEmpty(model.ManagerName)) { return(new AjaxResult <Object>("请输入登录名")); } if (model.ManagerId == 0) { var userN = db.WebSysManager.FirstOrDefault(m => m.ManagerName == model.ManagerName); if (userN != null) { return(new AjaxResult <Object>("该登录名已存在")); } } using (var scope = new TransactionScope()) { var user = db.WebSysManager.FirstOrDefault(m => m.ManagerId == model.ManagerId); if (user == null) { Random rd = new Random(); string scal = rd.Next(10000, 99999).ToString(); user = new WebSysManager() { ManagerName = model.ManagerName, IsSupper = model.IsSupper, CreateTime = DateTime.Now, UpdateTime = DateTime.Now, ManagerEmail = model.ManagerEmail, ManagerIsdel = 0, ManagerPwd = Encrypt.MD5Encrypt(Encrypt.MD5Encrypt("123456") + scal), ManagerScal = scal, ManagerRealname = model.ManagerRealname, ManagerStatus = model.ManagerStatus, ManagerTel = model.ManagerTel }; db.WebSysManager.Add(user); db.SaveChanges(); } else { user.IsSupper = model.IsSupper; user.UpdateTime = DateTime.Now; user.ManagerEmail = model.ManagerEmail; user.ManagerRealname = model.ManagerRealname; user.ManagerStatus = model.ManagerStatus; user.IsSupper = model.IsSupper; user.ManagerTel = model.ManagerTel; db.SaveChanges(); } //删除原先分配的角色 var dels = db.WebSysManagerRole.Where(m => m.ManagerId == user.ManagerId).ToList(); if (dels.Count > 0) { db.WebSysManagerRole.RemoveRange(dels); } if (model.Roles != null) { List <WebSysManagerRole> InSertRoles = new List <WebSysManagerRole>(); foreach (var item in model.Roles) { WebSysManagerRole addItem = new WebSysManagerRole() { ManagerId = user.ManagerId, RoleId = item.RoleID, }; InSertRoles.Add(addItem); } if (InSertRoles.Count > 0) { db.WebSysManagerRole.AddRange(InSertRoles); db.SaveChanges(); } } scope.Complete(); } return(new AjaxResult <Object>("帐号保存成功!", 0)); }
public JsonResult AccountSaveInfo(SysAccountInfo model) { var result = sysUserManager.SaveAccountInfo(model); return(Json(result)); }