public async Task <IActionResult> GetCategoryListAsync(GetCategoryListAsyncRequestDto request)
{
if (string.IsNullOrWhiteSpace(request.HospitalGuid))
{
var userModel = await new MealOperatorBiz().GetModelAsync(UserID);
if (userModel == null)
{
return(Failed(ErrorCode.DataBaseError, "无法获取医院所在信息！"));
}
request.HospitalGuid = userModel.HospitalGuid;
}
var response = await new MealCategoryBiz().GetCategoryListAsync(request);
return(Success(response));
}
/// <summary>
/// 获取分类List
/// </summary>
/// <returns></returns>
public async Task <List <GetCategoryListAsyncResponseDto> > GetCategoryListAsync(GetCategoryListAsyncRequestDto request)
{
var sql = @"SELECT DISTINCT
category_guid,
category_name
FROM
t_meal_category
WHERE
hospital_guid =@HospitalGuid
AND ENABLE = 1 " ;
using (var conn = MySqlHelper.GetConnection())
{
return((await conn.QueryAsync <GetCategoryListAsyncResponseDto>(sql, new { request.HospitalGuid })).ToList());
}
}
