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));
}
