Esempio n. 1
0
        /// <summary>
        /// Inits the cir sight info.
        /// 初始化当前景区附近的景区信息
        /// 前10 条
        /// </summary>
        /// <param name="sight">The sight.</param>
        /// <param name="take">The take.</param>
        /// <returns></returns>
        public List <iPow.Domain.Dto.Sys_SightInfoDto> GetCirSightListBySight(iPow.Domain.Dto.Sys_SightInfoDto sight, int take)
        {
            var sightCirSightIdList = sightInfoCirSightRepository.GetList(e => e.SightId == sight.ParkID).Select(e => e.CirId);
            var si = (from e in sightInfoRepository.GetList()
                      where sightCirSightIdList.Contains(e.ParkID) && e.Latitude != 0 && e.Longitude != 0
                      orderby e.ViCount descending
                      select e).Take(take).ToList();

            if (si == null)
            {
                si = new List <iPow.Infrastructure.Data.DataSys.Sys_SightInfo>();
            }
            #region 2012.3.28.15.12 modify by yjihrpg
            //数据库改变,新添加景区周边表
            //var cir = sight.CirParkID;
            //List<iPow.Infrastructure.Data.DataSys.Sys_SightInfo> si = null;
            //if (!string.IsNullOrEmpty(cir))
            //{
            //    cir = (cir.Length > 1 && (cir.LastIndexOf(',') == 0)) ? cir.Substring(0, cir.Length - 1) : cir;
            //    string[] cirStrArray = cir.Split(',');
            //    List<int> cirList = new List<int>();
            //    for (int i = 0; i < cirStrArray.Length; i++)
            //    {
            //        int temp = 0;
            //        int.TryParse(cirStrArray[i], out temp);
            //        if (temp != 0)
            //        { cirList.Add(temp); }
            //    }
            //    si = (from e in sightInfoRepository.GetList()
            //          where cirList.Contains(e.ParkID) && e.Latitude != 0 && e.Longitude != 0
            //          orderby e.ViCount descending
            //          select e).Take(take).ToList();
            //}
            //if (si == null)
            //{
            //    si = new List<iPow.Infrastructure.Data.DataSys.Sys_SightInfo>();
            //}

            #endregion
            var dto = si.ToDto().ToList();
            dto.Insert(0, sight);
            return(dto);
        }
Esempio n. 2
0
        /// <summary>
        /// Inits the cir hotel info.
        /// 初始化当前景区附近的酒店信息列表
        /// 前10条
        /// </summary>
        /// <param name="sight">The sight.</param>
        /// <param name="take">The take.</param>
        /// <returns></returns>
        public List <iPow.Domain.Dto.Sys_HotelPropertyInfoDto> GetCirHotelListBySight(iPow.Domain.Dto.Sys_SightInfoDto sight, int take)
        {
            var sightCirHotelIdList = sightInfoCirHotelRepository.GetList(e => e.SightId == sight.ParkID).Select(e => e.HotelId);
            var hi = (from e in hotelPropertyInfoRepository.GetList()
                      where sightCirHotelIdList.Contains(e.ID) &&
                      !string.IsNullOrEmpty(e.latitude) &&
                      !string.IsNullOrEmpty(e.longitude)
                      orderby e.VisitCount descending
                      select e).Take(take).ToList();

            #region modified by yjihrp 2012.3.28.16.05

            //景区表添加
            //var cir = sight.CirHotelID;
            //List<iPow.Infrastructure.Data.DataSys.Sys_HotelPropertyInfo> hi = null;
            //if (!string.IsNullOrEmpty(cir))
            //{
            //    cir = (cir.Length > 1 && (cir.LastIndexOf(',') == 0)) ? cir.Substring(0, cir.Length - 1) : cir;
            //    string[] cirStrArray = cir.Split(',');
            //    List<int?> cirList = new List<int?>();
            //    for (int i = 0; i < cirStrArray.Length; i++)
            //    {
            //        int temp = 0;
            //        int.TryParse(cirStrArray[i], out temp);
            //        if (temp != 0)
            //        { cirList.Add(temp); }
            //    }
            //    hi = (from e in hotelPropertyInfoRepository.GetList()
            //          where cirList.Contains(e.ID) &&
            //          !string.IsNullOrEmpty(e.latitude) &&
            //          !string.IsNullOrEmpty(e.longitude)
            //          orderby e.VisitCount descending
            //          select e).Take(take).ToList();
            //}
            #endregion

            return(hi.ToDto().ToList());
        }