Esempio n. 1
0
        /// <summary>
        /// 审核记录
        /// </summary>
        /// <param name="ownerGuid"></param>
        /// <returns></returns>
        public async Task <GetReviewRecordPageResponseDto> GetReviewRecordPageAsync(GetReviewRecordPageRequestDto request)
        {
            var sqlWhere   = $@"AND ENABLE = 1 and owner_guid=@OwnerGuid and type=@Type";
            var sqlOrderBy = "creation_date desc";
            var sql        = $@"
SELECT * FROM
    t_manager_review_record
 WHERE
	1 = 1 {sqlWhere}
ORDER BY
	{sqlOrderBy}"    ;

            return(await MySqlHelper.QueryByPageAsync <GetReviewRecordPageRequestDto, GetReviewRecordPageResponseDto, GetReviewRecordPageItemDto>(sql, request));
        }
        public async Task <IActionResult> GetReviewRecordPageAsync([FromBody] GetReviewRecordPageRequestDto request)
        {
            var response = await new ReviewRecordBiz().GetReviewRecordPageAsync(request);

            return(Success(response));
        }