public async Task <IActionResult> GetDisheMaintenanceAsync(GetDisheMaintenanceAsyncRequestDto 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 MealMenuBiz().GetDisheMaintenanceAsync(request);
return(Success(response));
}
public async Task <IActionResult> GetCheckedDisheMaintenanceAsync(GetCheckedDisheMaintenanceAsyncRequestDto request)
{
if (string.IsNullOrWhiteSpace(request.HospitalGuid))
{
var userModel = await new MealOperatorBiz().GetModelAsync(UserID);
if (userModel == null)
{
return(Failed(ErrorCode.DataBaseError, "无法获取医院所在信息！"));
}
request.HospitalGuid = userModel.HospitalGuid;
}
GetDisheMaintenanceAsyncRequestDto newDto = new GetDisheMaintenanceAsyncRequestDto
{
CategoryGuid = request.CategoryGuid,
Date = request.Date,
HospitalGuid = request.HospitalGuid
};
var checkedMealMenuModelList = await new MealMenuBiz().GetDisheMaintenanceAsync(newDto);
var allDisheModel = await new MealDishesBiz().GetModelsByHospitalGuidAsync(request.HospitalGuid);
//var valList = checkedMealMenuModelList.Where(a => a.DishesGuid.Any(n => allDisheModel.Any(t => t.DishesGuid.Contains(n, StringComparison.InvariantCultureIgnoreCase))));
List <GetCheckedDisheMaintenanceAsyncResponseDto> reponse = new List <GetCheckedDisheMaintenanceAsyncResponseDto>();
foreach (var model in allDisheModel)
{
var newModel = new GetCheckedDisheMaintenanceAsyncResponseDto
{
DishesGuid = model.DishesGuid,
DishesName = model.DishesName,
IsChecked = false
};
foreach (var item in checkedMealMenuModelList)
{
if (model.DishesGuid.Equals(item.DishesGuid))
{
newModel.IsChecked = true;
}
}
reponse.Add(newModel);
}
return(Success(reponse));
}
/// <summary>
/// 菜品维护-查询
/// </summary>
/// <param name="hospitalGuid"></param>
/// <param name="menuDate"></param>
/// <returns></returns>
public async Task <List <GetDisheMaintenanceAsyncResponseDto> > GetDisheMaintenanceAsync(GetDisheMaintenanceAsyncRequestDto request)
{
using (var conn = MySqlHelper.GetConnection())
{
var sql = @"SELECT
md.dishes_guid,
md.dishes_name
FROM
t_meal_menu AS mm
LEFT JOIN t_meal_dishes AS md ON mm.dishes_guid = md.dishes_guid
WHERE
mm.hospital_guid = @HospitalGuid
AND mm.menu_date = @Date
AND mm.category_guid =@CategoryGuid
AND mm.ENABLE = 1
GROUP BY
md.dishes_guid,
md.dishes_name " ;
var res = await conn.QueryAsync <GetDisheMaintenanceAsyncResponseDto>(sql, new { request.HospitalGuid, Date = request.Date.Value.ToString("yyyy/MM/dd"), request.CategoryGuid });
return(res?.ToList());
}
}
