public ResponseUserRoleCheckedUpdate UserRoleCheckedUpdate(RequestUserRoleCheckedUpdate request) { ResponseUserRoleCheckedUpdate response = new ResponseUserRoleCheckedUpdate(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { string sql = @"delete from tks_fas_user2role where userid=@UserId"; cnn.Execute(sql, new { UserId = request.UserId }, ts); foreach (var item in request.RoleIds) { TKS_FAS_User2Role _row = new TKS_FAS_User2Role(); _row.Id = Guid.NewGuid().ToString("N"); _row.RoleId = item; _row.UserId = request.UserId; cnn.Insert <TKS_FAS_User2Role>(_row, ts); } ts.Commit(); response.IsSuccess = true; response.Message = "设置成功"; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseUserRoleCheckedUpdate); } } }
public ResponseUserRoleCheckedUpdate UserRoleCheckedUpdate([FromBody] RequestUserRoleCheckedUpdate request) { try { PermissionBLL bll = new PermissionBLL(); return(bll.UserRoleCheckedUpdate(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }