public async Task <IActionResult> CerateOrEdit([FromBody] ESysUserRole eSysUserRole) { bool flag = false; try { if (eSysUserRole.ID == 0) { using (var uow = _uowFactory.Create()) { flag = await _SysUserRoleRepository.AddAsync(eSysUserRole); uow.SaveChanges(); } if (flag) { return(Ok(new { status = true, message = "success" })); } else { return(Ok(new { status = false, message = "error" })); } } else { using (var uow = _uowFactory.Create()) { flag = await _SysUserRoleRepository.UpdateAsync(eSysUserRole); uow.SaveChanges(); } if (flag) { return(Ok(new { status = true, message = "success" })); } else { return(Ok(new { status = false, message = "error" })); } } } catch (Exception ex) { return(Ok(new { status = false, message = ex.Message })); } }
public async Task <bool> UpdateAsync(ESysUserRole eSysUserRole) { string sql = "update Sys_UserRole set RoleID=@RoleID,UserID=@UserID,UserName=@UserName where ID=@ID;"; return(await _context.ExecuteAsync(sql, eSysUserRole) > 0); }
public async Task <bool> AddAsync(ESysUserRole eSysUserRole) { string sql = "insert into Sys_UserRole(RoleID,UserID,UserName) values(@RoleID,@UserID,@UserName);select @@Identity;"; return(await _context.ExecuteAsync(sql, eSysUserRole) > 0); }