/// <summary> /// 获取所有按钮(分页) /// </summary> /// <param name="request"></param> /// <returns></returns> public PagingResult <GetPagingButtonsResponse> GetPagingButtons(GetPagingButtonsRequest request) { PagingResult <GetPagingButtonsResponse> result = null; var totalCount = 0; var startIndex = (request.PageIndex - 1) * request.PageSize + 1; var endIndex = request.PageIndex * request.PageSize; using (var conn = DapperHelper.CreateConnection()) { var multi = conn.QueryMultiple(@"--获取所有按钮(分页) SELECT rs.* FROM (SELECT ROW_NUMBER() OVER (ORDER BY btn.created_time DESC) AS RowNum, btn.created_time AS CreatedTime, btn.last_updated_time AS LastUpdatedTIme,* FROM dbo.t_rights_button AS btn) AS rs WHERE rs.RowNum BETWEEN @Start AND @End; --获取所有按钮total SELECT COUNT(btn.id) FROM dbo.t_rights_button AS btn;", new { @Start = startIndex, @End = endIndex }); var query1 = multi.Read <GetPagingButtonsResponse>(); var query2 = multi.Read <int>(); totalCount = query2.First(); result = new PagingResult <GetPagingButtonsResponse>(totalCount, request.PageIndex, request.PageSize, query1); } return(result); }
/// <summary> /// 获取所有按钮(分页) /// </summary> /// <returns></returns> public ActionResult GetPagingButtons(GetPagingButtonsRequest request, int page, int rows) { var result = string.Empty; if (request == null) { request = new GetPagingButtonsRequest(); } request.PageIndex = page; request.PageSize = rows; var rs = _buttonService.GetPagingButtons(request); if (rs.ReturnCode == ReturnCodeType.Success) { result = "{\"total\": " + rs.Content.TotalCount + ",\"rows\":" + rs.Content.Entities.ToJson(dateTimeFormat: DateTimeTypeConst.DATETIME) + "}"; } return(Content(result)); }
/// <summary> /// 获取所有按钮(分页) /// </summary> /// <returns></returns> public ActionResult GetPagingButtons(GetPagingButtonsRequest request, int page, int rows) { var result = string.Empty; if (request == null) { request = new GetPagingButtonsRequest(); } request.PageIndex = page; request.PageSize = rows; using (var factory = new ChannelFactory <IRightsButtonService>("*")) { var client = factory.CreateChannel(); var rs = client.GetPagingButtons(request); if (rs.ReturnCode == ReturnCodeType.Success) { result = "{\"total\": " + rs.Content.TotalCount + ",\"rows\":" + rs.Content.Entities.ToJson(dateTimeFormat: DateTimeTypeConst.DATETIME) + "}"; } } return(Content(result)); }
/// <summary> /// 获取所有按钮(分页) /// </summary> /// <param name="request"></param> /// <returns></returns> public ServiceResult <PagingResult <GetPagingButtonsResponse> > GetPagingButtons(GetPagingButtonsRequest request) { var result = new ServiceResult <PagingResult <GetPagingButtonsResponse> > { ReturnCode = ReturnCodeType.Error, Content = new PagingResult <GetPagingButtonsResponse>() }; var rs = _btnDao.GetPagingButtons(request); result.ReturnCode = ReturnCodeType.Success; result.Content = rs; return(result); }