public async Task <JsonData> DeleteStaffPostAsync(int id) { var count = await Context.Staffs.CountAsync(a => a.Status == EntityStatus.Normal && a.StaffPostId == id); if (count > 0) { return(new JsonData { Msg = $"有[{count}]位员工属于该岗位,不允许删除" }); } var entity = new StaffPost { ID = id }; Context.Attach(entity); entity.Status = EntityStatus.Deleted; var result = new JsonData { Success = await Context.SaveChangesAsync() > 0 }; if (result.Success) { result.Msg = "删除成功"; return(result); } result.Msg = "未找到岗位数据,请刷新后重试"; return(result); }
public async Task <int> UpdateStaffPostAsync(StaffPost post) { var entity = new StaffPost { ID = post.ID }; Context.Attach(entity); entity.Name = post.Name; entity.Authority = post.Authority; entity.ModifyTime = DateTime.Now; return(await Context.SaveChangesAsync()); }
/// <summary> /// 修改岗位 /// </summary> /// <param name="post"></param> /// <returns></returns> public async Task <IActionResult> UpdateStaffPost([FromBody] StaffPost post) { if (await Service.IsExistPostAsync(Business.ID, post)) { return(Json(new JsonData { Msg = $"已存在名为【{post.Name}】的岗位,请选用其他名称", Success = false })); } await Service.UpdateStaffPostAsync(post); return(Json(new JsonData { Msg = "修改成功", Success = true })); }
/// <summary> /// 添加岗位 /// </summary> /// <param name="post"></param> /// <returns></returns> public async Task <IActionResult> AddStaffPost([FromBody] StaffPost post) { if (await Service.IsExistPostAsync(Business.ID, post)) { return(Json(new JsonData { Msg = $"已存在名为【{post.Name}】的岗位,请选用其他名称", Success = false })); } post.BusinessId = Business.ID; post.Status = EntityStatus.Normal; await Service.AddAsync(post); return(Json(new JsonData { Msg = "新增成功", Success = true, Data = post })); }
public async Task <bool> IsExistPostAsync(int businessId, StaffPost post) { var name = post.Name.ToLower(); return(await Context.StaffPosts.CountAsync(a => a.Status == EntityStatus.Normal && a.BusinessId == businessId && a.ID != post.ID && a.Name.ToLower() == name) > 0); }