//根据条件查询部门
private Expression <Func <Food_Info, bool> > SearchFoodWhere(FoodInfoSearchViewModel foodInfoSearchViewModel)
{
var predicate = WhereExtension.True <Food_Info>();//初始化where表达式
predicate = predicate.And(p => p.Price.ToString().Contains(foodInfoSearchViewModel.Price.ToString()));
predicate = predicate.And(p => p.FoodName.Contains(foodInfoSearchViewModel.FoodName));
predicate = predicate.And(p => p.FoodType.Contains(foodInfoSearchViewModel.FoodType));
predicate = predicate.And(p => p.Remark.Contains(foodInfoSearchViewModel.Remark));
if (foodInfoSearchViewModel.flag == "0")//手机，默认查询当前周
{
System.Globalization.GregorianCalendar gc = new System.Globalization.GregorianCalendar();
int weekOfYear = gc.GetWeekOfYear(DateTime.Now, System.Globalization.CalendarWeekRule.FirstDay, DayOfWeek.Monday);
predicate = predicate.And(p => p.WeekNumber == weekOfYear.ToString()); //默认当前周
predicate = predicate.And(p => p.Year == DateTime.Now.Year.ToString()); //默认当前年
}
else//PC查询任意周
{
if (foodInfoSearchViewModel.flag != "")
{
predicate = predicate.And(p => p.WeekNumber == foodInfoSearchViewModel.flag);
}
predicate = predicate.And(p => p.Year.Contains(foodInfoSearchViewModel.Year));
}
predicate = predicate.And(p => p.isDelete == "0");
return(predicate);
}
/// <summary>
/// 菜单查询
/// </summary>
/// <param name="foodInfoSearchViewModel"></param>
/// <returns></returns>
public List <FoodInfoSearchMiddle> Food_Search(FoodInfoSearchViewModel foodInfoSearchViewModel)
{
List <Food_Info> food_info = _IFoodInfoRepository.SearchFoodInfoByWhere(foodInfoSearchViewModel);
var food_Info_result = _IMapper.Map <List <Food_Info>, List <FoodInfoSearchMiddle> >(food_info);
if (foodInfoSearchViewModel.userId != "0")
{
foreach (var food in food_Info_result)
{
string temp = "2";
int up = _IRelate_Food_UserRepository.SearchByUserAndFoodId(food.Id, Convert.ToInt32(foodInfoSearchViewModel.userId), "0");
int down = _IRelate_Food_UserRepository.SearchByUserAndFoodId(food.Id, Convert.ToInt32(foodInfoSearchViewModel.userId), "1");
if (up > 0)
{
temp = "0";//存在点赞
}
if (down > 0)
{
temp = "1";//存在差评
}
food.UpDownStatus = temp;
}
}
return(food_Info_result);
}
/// <summary>
/// 菜单查询
/// </summary>
/// <param name="foodInfoSearchViewModel"></param>
/// <returns></returns>
public List <Food_Info> Food_Search(FoodInfoSearchViewModel foodInfoSearchViewModel)
{
List <Food_Info> user_Departs = _IFoodInfoRepository.SearchFoodInfoByWhere(foodInfoSearchViewModel);
//List<string> a=_IFoodInfoRepository.SearchFoodTypeInfoByWhere(foodInfoSearchViewModel);
return(user_Departs);
}
//只查菜品类型
public List <string> SearchFoodTypeInfoByWhere(FoodInfoSearchViewModel foodInfoSearchViewModel)
{
//查询条件
var predicate = SearchFoodWhere(foodInfoSearchViewModel);
var result = DbSet.Where(predicate).Select(a => a.Picture)
.Distinct()
.ToList();
return(result);
}
//根据条件查询部门
private Expression <Func <Food_Info, bool> > SearchFoodWhere(FoodInfoSearchViewModel foodInfoSearchViewModel)
{
var predicate = WhereExtension.True <Food_Info>();//初始化where表达式
predicate = predicate.And(p => p.Price.ToString().Contains(foodInfoSearchViewModel.Price.ToString()));
predicate = predicate.And(p => p.FoodName.Contains(foodInfoSearchViewModel.FoodName));
predicate = predicate.And(p => p.FoodType.Contains(foodInfoSearchViewModel.FoodType));
predicate = predicate.And(p => p.Remark.Contains(foodInfoSearchViewModel.Remark));
return(predicate);
}
public List <Food_Info> SearchFoodInfoByWhere(FoodInfoSearchViewModel foodInfoSearchViewModel)
{
//查询条件
int SkipNum = foodInfoSearchViewModel.pageViewModel.CurrentPageNum * foodInfoSearchViewModel.pageViewModel.PageSize;
//查询条件
var predicate = SearchFoodWhere(foodInfoSearchViewModel);
var result = DbSet.Where(predicate)
.Skip(SkipNum)
.Take(foodInfoSearchViewModel.pageViewModel.PageSize)
.OrderBy(o => o.AddDate).ToList();
return(result);
}
public ActionResult <FoodInfoSearchResModel> Manage_Food_Search(FoodInfoSearchViewModel foodInfoSearchViewModel)
{
FoodInfoSearchResModel foodInfoSearchResModel = new FoodInfoSearchResModel();
var BusSearchResult = _foodService.Food_Search(foodInfoSearchViewModel);
var foodtype = _foodService.FoodType_Search(foodInfoSearchViewModel);
// var TotalNum = _userService.User_Get_ALLNum();
var TotalNum = _foodService.Food_Get_ALLNum(foodInfoSearchViewModel);
foodInfoSearchResModel.foodInfo = BusSearchResult;
foodInfoSearchResModel.foodType = foodtype;
foodInfoSearchResModel.IsSuccess = true;
foodInfoSearchResModel.baseViewModel.Message = "查询成功";
foodInfoSearchResModel.baseViewModel.ResponseCode = 200;
foodInfoSearchResModel.TotalNum = TotalNum;
_ILogger.Information("查询菜单信息成功");
return(Ok(foodInfoSearchResModel));
}
/// <summary>
/// 菜单数量
/// </summary>
/// <param name="foodInfoSearchViewModel"></param>
/// <returns></returns>
public IQueryable <Food_Info> GetFoodAll(FoodInfoSearchViewModel foodInfoSearchViewModel)
{
var predicate = SearchFoodWhere(foodInfoSearchViewModel);
return(DbSet.Where(predicate));
}
/// 只查询菜品种类
/// </summary>
/// <param name="foodInfoSearchViewModel"></param>
/// <returns></returns>
public List <string> FoodType_Search(FoodInfoSearchViewModel foodInfoSearchViewModel)
{
List <string> foodType = _IFoodInfoRepository.SearchFoodTypeInfoByWhere(foodInfoSearchViewModel);
return(foodType);
}
/// <summary>
/// 获取菜单数量
/// </summary>
/// <param name="foodInfoSearchViewModel"></param>
/// <returns></returns>
public int Food_Get_ALLNum(FoodInfoSearchViewModel foodInfoSearchViewModel)
{
return(_IFoodInfoRepository.GetFoodAll(foodInfoSearchViewModel).Count());
}