public async Task <IActionResult> GetUseFullDateListAsync(GetUseFullDateListAsyncRequestDto 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().GetUseFullDateListAsync(request);
return(Success(response));
}
/// <summary>
/// 获取分类List
/// </summary>
/// <returns></returns>
public async Task <List <GetUseFullDateListAsyncResponseDto> > GetUseFullDateListAsync(GetUseFullDateListAsyncRequestDto request)
{
string sqlWhere = "";
if (request.IsShowNullDate)
{
sqlWhere += " AND ENABLE = 1 ";
}
var date = DateTime.Now.AddDays(-2).Date;
var sql = $@"SELECT DISTINCT
menu_date
FROM
t_meal_menu
WHERE
hospital_guid = @HospitalGuid
AND menu_date>=@date
{sqlWhere}
GROUP BY
menu_date " ;
//AND ENABLE = 1
using (var conn = MySqlHelper.GetConnection())
{
return((await conn.QueryAsync <GetUseFullDateListAsyncResponseDto>(sql, new { request.HospitalGuid, date })).ToList());
}
}