public ResponseCustomDataListSearch CustomDataListSearch(RequestCustomDataListSearch request) { ResponseCustomDataListSearch response = new ResponseCustomDataListSearch(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(request.Token, ts); string sql = this.GetPageSql("*", @" TKS_FAS_CaculateHelperDetail where accountId=@AccountId and parentId=@ParentId and (code like @Code or name like @Name)", "Code", request.PageSize, request.PageIndex); List <TKS_FAS_CaculateHelperDetail> data = cnn.Query <TKS_FAS_CaculateHelperDetail>(sql, new { AccountId = user.AccountId, ParentId = request.Head.Id, Code = "%" + request.Data.Code + "%", Name = "%" + request.Data.Name + "%" }, ts).ToList(); string countSql = @"select count(1) from TKS_FAS_CaculateHelperDetail where accountId=@AccountId and parentId=@ParentId and (code like @Code or name like @Name)"; int total = int.Parse(cnn.ExecuteScalar(countSql, new { AccountId = user.AccountId, ParentId = request.Head.Id, Code = "%" + request.Data.Code + "%", Name = "%" + request.Data.Name + "%" }, ts).ToString()); ts.Commit(); response.IsSuccess = true; response.Message = "加载完毕"; response.PageIndex = request.PageIndex; response.Data = data; response.Total = total; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseCustomDataListSearch); } } }
public ResponseCustomDataListSearch CustomDataListSearch([FromBody] RequestCustomDataListSearch request) { try { CustomDataBLL bll = new CustomDataBLL(); return(bll.CustomDataListSearch(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }