/// <summary>
/// 获取菜品分页列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <GetMealDishesListResponseDto> GetMealDishes(GetMealDishesListRequestDto requestDto)
{
var sql = $@"select
d.dishes_guid,d.dishes_name,
concat(acc.base_path, acc.relative_path) as dishes_img_path,
d.dishes_img,
d.dishes_internal_price,d.dishes_external_price,
d.dishes_description,d.dishes_onsale
from t_meal_dishes as d
left join t_utility_accessory AS acc on d.dishes_img = acc.accessory_guid
where d.hospital_guid = '{requestDto.HospitalGuid}'";
if (!string.IsNullOrEmpty(requestDto.DishesName))
{
sql += $" and d.dishes_name like '%{requestDto.DishesName}%'";
}
sql += " order by d.creation_date desc";
return(await MySqlHelper.QueryByPageAsync <GetMealDishesListRequestDto, GetMealDishesListResponseDto, GetMealDishesItem>(sql, requestDto));
}
public async Task <IActionResult> GetMealDishes([FromQuery] GetMealDishesListRequestDto request)
{
var dishesBiz = new MealDishesBiz();
return(Success(await dishesBiz.GetMealDishes(request)));
}
