/// <summary> /// Gets the search tour model. /// </summary> /// <param name="search">The search.</param> /// <param name="pageIndex">Index of the page.</param> /// <param name="take">The take.</param> /// <param name="total">The total.</param> /// <returns></returns> public IQueryable <Dto.SearchTourDto> GetSearchTourModel(Dto.SearchInfoDto search, int pageIndex, int take, ref int total) { IQueryable <Dto.SearchTourDto> data = null; var temp = tourPlanRepository.GetList(e => e.Days <= search.Days && e.Days > ((search.Days - 2) > 0 ? (search.Days - 2) : 0)) .Where(e => e.IsDelete == 0) .Where(e => e.PlanTitle.Contains(search.Bide) || e.Destination.Contains(search.Bide) || e.Remark.Contains(search.Bide) ) .OrderByDescending(e => e.Days); total = temp.Count(); data = temp.Select(e => new Dto.SearchTourDto { ViCount = e.VisitCount, Id = e.PlanID, PlanTitle = e.PlanTitle, Days = e.Days, TopReason = e.Destination, PlanTotalMoney = tourPlanDetailRepository.GetList(c => c.PlanID == e.PlanID).Sum(d => d.CurrentPrice), UserName = e.UserName, ClassId = e.PlanClass, AddTime = e.AddTime }).OrderByDescending(e => e.ViCount) .Skip(((pageIndex - 1) < 0 ? 0 : (pageIndex - 1)) * take) .Take(take).AsQueryable(); return(data); }
private IEnumerable <iPow.Infrastructure.Data.DataSys.Sys_TourPlan> CurrentUserTourPlan() { var data = tourPlanRepository.GetList().OrderByDescending(e => e.AddTime).AsEnumerable(); var currentUserId = 0; if (currentUserId != 0) { //data = data.Where(e => e.UserId == currentUserId); } return(data); }
public bool DeleteTrue(IList <int> idList, iPow.Infrastructure.Data.DataSys.Sys_AdminUser operUser) { var res = false; if (idList != null && idList.Count > 0) { var delete = tourPlanRepository.GetList(e => idList.Contains(e.PlanID)).ToList(); if (delete != null && delete.Count > 0) { res = DeleteTrue(delete, operUser); } } return(res); }
/// Gets the list type mid tour plan list. /// </summary> /// <param name="id">The id.</param> /// <param name="pageIndex">Size of the page.</param> /// <param name="take">The take.</param> /// <param name="total">The total.</param> /// <returns></returns> public IQueryable <ListTypeMidTourPlanDto> GetListTypeMidTourPlanListByTypeId(int id, int pi, int take, ref int total) { IQueryable <ListTypeMidTourPlanDto> data = null; var temp = tourPlanRepository.GetList(e => (e.IsDelete == 0 || e.IsDelete == null)) .Where(e => e.PlanClass == id); total = temp.Count(); data = temp.OrderByDescending(e => e.VisitCount) .Select(e => new ListTypeMidTourPlanDto { Id = e.PlanID, PlanTitle = e.PlanTitle, Days = e.Days, TopReason = e.Destination, PlanTotalMoney = tourPlanDetailRepository.GetList(c => c.PlanID == e.PlanID).Sum(d => d.CurrentPrice), UserName = e.UserName, ViCount = e.VisitCount, ClassId = e.PlanClass, AddTime = e.AddTime }).Skip(((pi - 1) < 0 ? 0 : (pi - 1)) * take).Take(take).AsQueryable(); return(data); }
public ActionResult Index(int id) { var model = tourPlanService.GetTourDetailTopById(id); try { tourPlanRepository.GetList(d => d.PlanID == id).FirstOrDefault().VisitCount++; tourPlanRepository.Uow.Commit(); } catch { throw new ArgumentNullException("plan is null"); } return(View(model)); }
protected iPow.Infrastructure.Data.DataSys.Sys_TourPlan SysSingleTourPlan(int id) { var data = tourPlanRepository.GetList(e => e.PlanID == id).FirstOrDefault(); return(data); }
/// <summary> /// Gets the tour info count. /// </summary> /// <returns></returns> public int GetTourInfoCount() { return(tourPlanRepository.GetList().Count()); }
//用于根据城市查询路线并分页 public IQueryable <Dto.TopTourPlanDto> GetTourPlanListByCity(string city, int pi, int take, ref int total) { IQueryable <Dto.TopTourPlanDto> temp = null; if (!string.IsNullOrEmpty(city)) { temp = tourPlanRepository.GetList(d => d.Destination != null) .Where(d => d.Destination.Contains(city)) .Where(d => d.IsDelete == 0 || d.IsDelete == null) .Select(e => new Dto.TopTourPlanDto { Id = e.PlanID, PlanTitle = e.PlanTitle, Days = e.Days, TopReason = e.Destination, PlanTotalMoney = tourPlanDetailRepository.GetList(c => c.PlanID == e.PlanID).Sum(d => d.CurrentPrice), UserName = e.UserName, ViCount = e.VisitCount, ClassId = e.PlanClass }).AsQueryable();; } else { temp = (from e in tourPlanRepository.GetList() where (e.IsDelete == 0 || e.IsDelete == null) orderby e.VisitCount descending select new Dto.TopTourPlanDto { Id = e.PlanID, PlanTitle = e.PlanTitle, Days = e.Days, TopReason = e.Destination, PlanTotalMoney = tourPlanDetailRepository.GetList(c => c.PlanID == e.PlanID).Sum(d => d.CurrentPrice), UserName = e.UserName, ViCount = e.VisitCount, ClassId = e.PlanClass } ).AsQueryable(); } return(temp); }