public async Task <IActionResult> GetMealWalletRecordAsync([FromBody] GetMealWalletRecordRequestDto requestDto) { if (string.IsNullOrWhiteSpace(requestDto.UserGuid)) { requestDto.UserGuid = UserID; } var response = await new MealAccountDetailBiz().GetMealWalletRecordAsync(requestDto); return(Success(response)); }
/// <summary> /// 查询个人钱包账户交易流水 /// </summary> /// <param name="requestDto"></param> /// <returns></returns> public async Task <GetMealWalletRecordResponseDto> GetMealWalletRecordAsync(GetMealWalletRecordRequestDto requestDto) { var sql = @"SELECT b.account_type, a.account_detail_description, a.account_detail_fee, a.creation_date , a.account_detail_income_type, a.remark FROM t_meal_account_detail a INNER JOIN t_meal_account b ON a.account_guid = b.account_guid WHERE b.hospital_guid = @HospitalGuid AND b.user_guid = @UserGuid order by a.creation_date desc " ; return(await MySqlHelper.QueryByPageAsync <GetMealWalletRecordRequestDto, GetMealWalletRecordResponseDto, GetMealWalletRecordItemDto>(sql, requestDto)); }