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