public async Task <IActionResult> GetMealCategories([FromQuery] GetCategoryListRequestDto requestDto)
{
var categories = (List <GetCategoryListResponseDto>)null;
var categoryBiz = new MealCategoryBiz();
var modelCategories = await categoryBiz.GetMealCategories(requestDto);
if (modelCategories is null || modelCategories.Count <= 0)
{
return(Success(categories));
}
categories = modelCategories.Select(d => new GetCategoryListResponseDto()
{
CategoryGuid = d.CategoryGuid,
CategoryName = d.CategoryName,
MealStartTime = d.MealStartTime,
MealEndTime = d.MealEndTime,
CategoryAdvanceDay = d.CategoryAdvanceDay,
CategoryScheduleTime = d.CategoryScheduleTime
}).ToList();
return(Success(categories));
}
/// <summary>
/// 获取餐别列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <List <MealCategoryModel> > GetMealCategories(GetCategoryListRequestDto requestDto)
{
var sql = @"where hospital_guid = @HospitalGuid and enable = 1";
var parameters = new DynamicParameters();
parameters.Add("@HospitalGuid", requestDto.HospitalGuid);
if (!string.IsNullOrEmpty(requestDto.CategoryName))
{
sql += " and category_name LIKE @categoryName";
parameters.Add("@categoryName", "%" + requestDto.CategoryName + "%");
}
using (var conn = MySqlHelper.GetConnection())
{
return((await conn.GetListAsync <MealCategoryModel>(sql, parameters)).AsList());
}
}
