/// <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); }
public bool DeleteTrue(IList <int> idList, iPow.Infrastructure.Data.DataSys.Sys_AdminUser operUser) { var res = false; if (idList != null && idList.Count > 0) { var delete = tourPlanDetailRepository.GetList(e => idList.Contains(e.PlanDetailID)).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 DeleteTourDetailPlan(int id) { int?planId = 0; if (id > 0) { var temp = tourPlanDetailRepository.GetList(e => e.PlanDetailID == id).FirstOrDefault(); if (temp != null && temp.PlanDetailID > 0) { planId = temp.PlanID; //tourPlanDetailRepository.Delete(temp); tourPlanDetailRepository.Uow.Commit(); } } if (planId.HasValue) { var modelList = CurrentUserTourPlanDetail().Where(e => e.PlanID == planId); var dto = modelList.ToDto(); InitDetailPlan(dto); var model = new { Data = dto.ToList(), Total = dto.Count() }; return(Json(model, JsonRequestBehavior.AllowGet)); } return(View()); }
//用于根据城市查询路线并分页 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); }
/// <summary> /// Check Is Exist /// </summary> /// <param name="PlanID"></param> /// <param name="Remark"></param> /// <returns></returns> public bool CheckTourPlanDetailIsExist(int PlanID, int SightID, string Remark) { var res = tourPlanDetailRepository.GetList(e => e.SightIDOrHotelID == SightID && e.Remark == Remark).Where(e => e.PlanID == PlanID).Any(); return(res); }