Пример #1
0
        public void BindRouteSales()
        {
            StringBuilder sb = new StringBuilder();

            DataSet   mySet = bll.GetPageData(5, 1, "isdisplay=1", "RecommendHot Desc,RouteOrder Asc,Createdtime desc");
            DataTable table = mySet.Tables["Data"];

            int i = 0;

            foreach (DataRow dr in table.Rows)
            {
                i++;
                int tmpClassId = Convert.ToInt32(dr["LocationID"].ToString());
                string tmpPy = glClass.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == tmpClassId); }).ClassNamePY;

                sb.AppendFormat("<li class='{0} {1}'>", i == 1 ? "on" : "", (i == 5 || i == table.Rows.Count) ? "lastline" : "");
                sb.AppendFormat("<div class='side_rec_no'><span>{0}</span></div>", i);
                sb.AppendFormat("<a class='side_img' href='{0}/{1}/{2}.html' title='{3}' target='_blank' rel='nofollow'><img src='{4}' alt='' width='90px' height='68px' /></a>",
                                SysConfig.webSite, tmpPy, dr["ID"], dr["Title"], SysConfig.UploadFilePathRoutesImg + dr["Image"].ToString().Split(',')[0]);
                sb.AppendLine("<div class='side_info'>");
                sb.AppendFormat("<a class='side_title' href='{0}/{1}/{2}.html' title='{3}' target='_blank'>{4}</a>",
                                SysConfig.webSite, tmpPy, dr["ID"], dr["Title"], Function.Clip(dr["Title"].ToString(), 30, true));
                sb.AppendFormat("<span class='side_price'>&yen;<em>{0}</em>起</span>", Convert.ToInt32(dr["price"]));
                sb.AppendLine("</div>");
                sb.AppendLine("</li>");

                if (i == 5)
                {
                    break;
                }
            }
            dataSalesList = sb.ToString();
        }
Пример #2
0
        public void loadMoreSearch(HttpContext context)
        {
            string skey      = context.Request.QueryString["skey"];
            int    pageIndex = Convert.ToInt32(context.Request.QueryString["page"]);

            ClassLibrary.BLL.Routes     routeBLL      = new ClassLibrary.BLL.Routes();
            ClassLibrary.BLL.RouteClass routeClassBLL = new ClassLibrary.BLL.RouteClass();
            string    routewhere = " isdisplay=1 and CHARINDEX('" + skey + "',Title) > 0 ";
            DataSet   mySet      = routeBLL.GetPageData(10, pageIndex, routewhere, "RouteOrder Asc, CreatedTime Desc");
            DataTable myTable    = mySet.Tables["Data"];
            List <ClassLibrary.Model.RouteClass> glClass = routeClassBLL.GetModelList(string.Empty);
            StringBuilder sb = new StringBuilder();
            List <ClassLibrary.Model.Routes> pgRouteList = routeBLL.GetModelList(myTable);

            foreach (ClassLibrary.Model.Routes model in pgRouteList)
            {
                //string[] images = model.Image.Split(',');
                //int tmpClassId = Convert.ToInt32(model.routesClassID.Split(',')[1]);
                string tmpPy = glClass.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); }).ClassNamePY;
                sb.AppendLine("<li>");
                sb.AppendFormat("<a href='{0}/{1}/{2}.html'>", SysConfig.webSiteApp, tmpPy, model.ID);
                sb.AppendFormat("<div class='hot_img' style='background-image:url({0}{1})'></div>", SysConfig.webSite, SysConfig.UploadFilePathRoutesImg + model.AppImg);
                sb.AppendFormat("<div class='hot_price'>&yen;<em>{0}</em>起</div>", Convert.ToInt32(model.Price));
                sb.AppendFormat("<div class='hot_title'>{0}</div>", Function.Clip(model.Title, 18, true));
                sb.AppendLine("</a>");
                sb.AppendLine("</li>");
            }

            Print(context, sb.ToString());
        }
Пример #3
0
        private void BindRouteSales()
        {
            StringBuilder sb = new StringBuilder();

            string where = "isdisplay=1 and CHARINDEX('," + routeClassId + ",',','+routesPrentClassID+',')>0";
            DataSet   mySet = routeBll.GetPageData(5, 1, where, "RecommendHot Desc,RouteOrder Asc,Createdtime Desc");
            DataTable table = mySet.Tables["Data"];

            int countRows = table.Rows.Count;

            if (countRows < 5)
            {
                DataSet   mySet2 = routeBll.GetPageData(5, 1, "isdisplay=1", "id desc");
                DataTable table2 = mySet2.Tables["Data"];
                table.Merge(table2);
                table = table.AsDataView().ToTable(true);
            }
            int i = 0;
            List <ClassLibrary.Model.Routes> pgRouteList = routeBll.GetModelList(table);

            foreach (ClassLibrary.Model.Routes model in pgRouteList)
            {
                string tmpPy = gList.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); }).ClassNamePY;
                string[] images = model.Image.Split(',');
                i++;
                sb.AppendFormat("<li class='{0}'>", (i == 5 || i == pgRouteList.Count) ? "lastline" : "");
                sb.AppendLine("<div class='item_order'><span>" + i + "</span></div>");
                sb.AppendFormat("<a href='{4}/{3}/{2}.html' title='{0}' rel='nofollow'><img alt='{0}' src='{1}' width='202' height='128' /></a>",
                                model.Title, SysConfig.UploadFilePathRoutesImg + images[0], model.ID, tmpPy, SysConfig.webSite).AppendLine();
                sb.AppendFormat("<div class='item_title'><a href='{3}/{2}/{0}.html' title='{4}'>{1}</a></div>",
                                model.ID, Function.Clip(model.Title, 33, true), tmpPy, SysConfig.webSite, model.Title).AppendLine();
                string tp = string.Format("&yen;{0}起", Convert.ToInt32(model.Price));
                if (Convert.ToInt32(model.Price) == 0)
                {
                    tp = "电询";
                }
                sb.AppendFormat("<div class='item_visit'><div class='visit_cnt'><i></i>{0}次</div><div class='item_price'>{1}</div></div>",
                                model.ViewCount, tp);
                sb.AppendLine("</li>");

                if (i == 5)
                {
                    break;
                }
            }
            dataSalesList = sb.ToString();
        }
Пример #4
0
        //绑定相关线路
        private void BindXiangRoute()
        {
            DataSet   mySet      = bll.GetPageData(5, 1, "isdisplay=1 and id <> " + routeID + " and CHARINDEX('," + route.LocationID + ",',','+routesPrentClassID+',')>0", " RouteOrder,CreatedTime desc");
            DataTable table      = mySet.Tables["Data"];
            DataTable tableCount = mySet.Tables["Count"];

            int countRows = 0;

            countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString());

            if (countRows < 5)
            {
                DataSet   mySet2 = bll.GetPageData(5, 1, "isdisplay=1 and id <> " + routeID, "RouteOrder,CreatedTime desc");
                DataTable table2 = mySet2.Tables["Data"];
                table.Merge(table2);
                table = table.AsDataView().ToTable(true);
            }
            int           index = 0;
            StringBuilder sb    = new StringBuilder();

            foreach (DataRow dr in table.Rows)
            {
                index++;
                //sb.Append("<div class='main_car_main'>");
                string[] imgs       = dr["image"].ToString().Split(',');
                int      tmpClassId = Convert.ToInt32(dr["LocationID"].ToString());
                string tmpPy = gList.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == tmpClassId); }).ClassNamePY;
                sb.AppendLine("<li>");
                sb.AppendFormat("<a href='{4}/{3}/{2}.html' title='{1}' rel='nofollow'><img src='{0}' alt='{1}' width='217' height='136' /></a>",
                                SysConfig.UploadFilePathRoutesImg + imgs[0], dr["Title"].ToString() + dr["Bright"].ToString(), dr["ID"], tmpPy, SysConfig.webSite).AppendLine();
                sb.AppendFormat("<p class='item_t'><a href='{4}/{3}/{2}.html' title='{1}'>{0}</a></p>",
                                Function.Clip(dr["Title"].ToString(), 14, false), dr["Title"].ToString() + dr["Bright"].ToString(), dr["ID"], tmpPy, SysConfig.webSite).AppendLine();
                sb.AppendFormat("<p class='item_f'>{0}</p>", Function.Clip(dr["Bright"].ToString(), 16, false));
                string tp = string.Format("&yen;{0}<span>起</span>", Convert.ToInt32(dr["price"]));
                if (Convert.ToInt32(dr["price"]) == 0)
                {
                    tp = "电询";
                }
                sb.AppendFormat("<p class='item_p'>{0}</p>", tp);
                sb.AppendLine("</li>");
                if (index == 5)
                {
                    break;
                }
            }
            dataXiangRoute = sb.ToString();
        }
Пример #5
0
        //线路
        private void BindRouteList()
        {
            string routewhere = " isdisplay=1 ";

            if (sKey != "")
            {
                //routewhere += " and (CHARINDEX('" + sKey + "',Title) > 0 or CHARINDEX('" + sKey + "',DescriptionRoute) > 0 or Exists(select RouteID from Routedetails where routeid=routes.ID and CHARINDEX('" + sKey + "',DayDetail)>0))";
                routewhere += " and CHARINDEX('" + sKey + "',Title) > 0 ";
            }
            string orderwhere = "routeOrder Asc";

            ClassLibrary.Common.Pagination pg = new ClassLibrary.Common.Pagination();
            //ClassLibrary.BLL.Routes rbll = new ClassLibrary.BLL.Routes();

            DataSet   mySet      = bll.GetPageData(10, pageIndex, routewhere, orderwhere);
            DataTable tableCount = mySet.Tables["Count"];
            DataTable myTable    = mySet.Tables["Data"];

            int countRows = 0;

            countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString());

            if (countRows % 10 == 0)
            {
                countPage = countRows / 10;
            }
            else
            {
                countPage = countRows / 10 + 1;
            }

            StringBuilder sb = new StringBuilder();

            List <ClassLibrary.Model.Routes> pgRouteList = bll.GetModelList(myTable);

            foreach (ClassLibrary.Model.Routes model in pgRouteList)
            {
                string[] images = model.Image.Split(',');
                //int tmpClassId = Convert.ToInt32(model.routesClassID.Split(',')[1]);
                string tmpPy = glClass.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); }).ClassNamePY;
                sb.AppendLine("<li>");
                sb.AppendFormat("<a href='{0}/mip/{1}/{2}.html' target='_blank'>", SysConfig.webSiteApp, tmpPy, model.ID);
                sb.AppendFormat("<mip-img class='hot_img' src='{0}{1}'></mip-img>", SysConfig.webSite, SysConfig.UploadFilePathRoutesImg + images[0]);
                sb.AppendFormat("<div class='hot_title'>{0}</div>", Function.Clip(model.Title, 18, true));
                sb.AppendFormat("<div class='hot_price'>&yen;<em>{0}</em>起</div>", Convert.ToInt32(model.Price));
                sb.AppendLine("</a>");
                sb.AppendLine("</li>");
            }
            if (sb.Length == 0)
            {
                sb.Append("<div class='nopagedata'>没有相关" + sKey + "旅游线路</div>");
            }
            dataRouteList = sb.ToString();
        }
Пример #6
0
        //特色旅游 推荐 热门等等  不查三峡旅游
        public void FindIndexRoute(HttpContext context)
        {
            int    sanid = (int)SysConfig.RouteClass.峡旅游;
            string type  = context.Request.QueryString["type"];

            ClassLibrary.BLL.Routes routebll = new ClassLibrary.BLL.Routes();
            DataSet       mySet = routebll.GetPageData(8, 1, "  isdisplay=1 and CHARINDEX('," + sanid + ",',','+routesPrentClassID+',') = 0 and CHARINDEX('" + type + "',RecommendIndex) > 0 ", " RouteOrder,CreatedTime desc ");
            DataTable     table = mySet.Tables["Data"];
            StringBuilder sb    = new StringBuilder();

            ClassLibrary.BLL.RouteClass          rcBLL  = new ClassLibrary.BLL.RouteClass();
            List <ClassLibrary.Model.RouteClass> rcList = rcBLL.GetModelList(String.Empty);

            int q = 0;

            sb.Append("<div class='main_hot_body'>");
            foreach (DataRow dr in table.Rows)
            {
                q++;
                string temClassPy = rcList.Find(delegate(ClassLibrary.Model.RouteClass trc) { return(trc.ID == Convert.ToInt32(dr["LocationID"].ToString())); }).ClassNamePY;

                if (q <= 4)
                {
                    sb.Append("<div class='main_hot_body_item'>");
                    string[] imgs = dr["Image"].ToString().Split(',');
                    sb.AppendFormat("<img alt='{0}' src='{1}' width='230px' height='147px'/>", dr["Title"], ClassLibrary.Common.SysConfig.UploadFilePathRoutesImg + imgs[0]);
                    sb.AppendFormat("<p><span class='c_destin'>{1}</span><span class='c_price'>&yen;{0}起</span></p>", Convert.ToInt32(dr["Price"]), Function.Clip(dr["Destination"].ToString(), 8, true));
                    sb.Append("<div class='main_hot_body_font'><ul>");
                    sb.AppendFormat(" <li><a href='{3}/{2}/{1}.html' style='width:100%;'>{0}</a></li>", ClassLibrary.Common.Function.Clip(dr["Title"].ToString(), 10, true), dr["ID"], temClassPy, SysConfig.webSite);
                    sb.AppendFormat(" <li>{0}</li>", ClassLibrary.Common.Function.Clip(ClassLibrary.Common.Function.ClearHtml(dr["RouteFeature"].ToString()), 18, true));
                    sb.AppendFormat("<li><a href='{2}/{1}/{0}.html' target='_blank' >查看线路</a></li>", dr["ID"], temClassPy, SysConfig.webSite);
                    sb.Append("</ul></div> </div>");
                    if (q == 4)
                    {
                        sb.Append("</div><div class='main_hot_bottom'><ul>");
                    }
                }
                else
                {
                    sb.AppendFormat("<li><a href='{3}/{2}/{1}.html' target='_blank' >{0}</a></li>", ClassLibrary.Common.Function.Clip(dr["Title"].ToString(), 18, true), dr["ID"], temClassPy, SysConfig.webSite);
                    sb.AppendFormat("<li class='hei'>&yen;<em>{0}</em>元起</li>", Convert.ToInt32(dr["Price"]));
                }
            }
            sb.Append("</ul></div>");
            if (q == 0)
            {
                Print(context, "");
            }
            else
            {
                Print(context, sb.ToString());
            }
        }
Пример #7
0
        private void BindRouteList()
        {
            string routewhere = " isdisplay=1 ";

            if (pid == 0)
            {
                routewhere += " and charindex('," + cid + ",',','+themeId+',')>0";
            }
            else
            {
                routewhere += " and charindex('," + cid + ",',','+routesPrentClassID+',')>0";
            }

            ClassLibrary.Common.Pagination pg = new ClassLibrary.Common.Pagination();
            //ClassLibrary.BLL.Routes rbll = new ClassLibrary.BLL.Routes();

            DataSet   mySet      = bll.GetPageData(20, pageIndex, routewhere, "RouteOrder Asc, CreatedTime Desc");
            DataTable tableCount = mySet.Tables["Count"];
            DataTable myTable    = mySet.Tables["Data"];

            int countRows = 0;

            countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString());

            string url = SysConfig.webSiteApp + "/mip/" + (isZhuti ? currZtClass.classNamePY : currClass.ClassNamePY) + "/";

            pageInfo = pg.paginationMip(countRows, 20, pageIndex, url);

            StringBuilder sb = new StringBuilder();
            List <ClassLibrary.Model.Routes> pgRouteList = bll.GetModelList(myTable);

            foreach (ClassLibrary.Model.Routes model in pgRouteList)
            {
                string tmpPy = glClass.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); }).ClassNamePY;
                sb.AppendLine("<li>");
                sb.AppendFormat("<a href='{0}/mip/{1}/{2}.html' target='_blank'>", SysConfig.webSiteApp, tmpPy, model.ID);
                sb.AppendFormat("<mip-img class='hot_img' src='{0}{1}'></mip-img>", SysConfig.webSite, SysConfig.UploadFilePathRoutesImg + model.AppImg);
                sb.AppendFormat("<div class='hot_title'>{0}</div>", Function.Clip(model.Title, 18, true));
                sb.AppendFormat("<div class='hot_price'>&yen;<em>{0}</em>起</div>", Convert.ToInt32(model.Price));
                sb.AppendLine("</a>");
                sb.AppendLine("</li>");
            }
            if (sb.Length == 0)
            {
                sb.Append("<div class='nopagedata'>没有相关旅游线路</div>");
            }
            dataRouteList = sb.ToString();
        }
Пример #8
0
        private void BindData()
        {
            searchKey = Function.GetQueryString("key");
            supKey    = Function.GetQueryString("sKey");
            int routeClassID = 0;

            string strWhere = "1=1 ";

            //搜索 - 大类
            searchClass1 = Function.GetQueryString("cid1");
            if (Function.IsNumber(searchClass1))
            {
                routeClassID = Convert.ToInt32(searchClass1);
            }
            //搜索 - 小类
            searchClass2 = Function.GetQueryString("cid2");
            if (Function.IsNumber(searchClass2))
            {
                routeClassID = Convert.ToInt32(searchClass2);
            }
            //跟据传过来的类别ID
            if (routeClassID != 0)
            {
                strWhere += " AND (CHARINDEX('," + routeClassID + ",',','+routesPrentClassID+',')>0)";
            }

            if (!string.IsNullOrEmpty(searchKey))
            {
                strWhere += " AND CHARINDEX('" + searchKey + "',Title)>0";
            }
            if (!string.IsNullOrEmpty(supKey))
            {
                strWhere += " AND CHARINDEX('" + supKey + "',Supplier)>0";
            }

            /*DataTable myTable = routeBLL.GetData(strWhere, "firstTime desc, createdTime desc");
             *
             * string[] urlParam = { "key", "cid1", "cid2" };
             * myTable = pg.pagination(myTable, 20, urlParam);
             * pageInfo = pg.pageNumList;*/
            string strOrder = "isdisplay desc";

            if (!string.IsNullOrEmpty(supKey))
            {
                strOrder += ",Supplier desc";
            }
            if (Function.GetQueryString("rorder") != "")
            {
                routeorder = Convert.ToInt32(Function.GetQueryString("rorder"));
            }
            if (Function.GetQueryString("torder") != "")
            {
                timeorder = Convert.ToInt32(Function.GetQueryString("torder"));
            }
            if (routeorder != 0)
            {
                if (routeorder == 1)
                {
                    strOrder += ",RouteOrder asc, createdtime desc";
                }
                else if (routeorder == 2)
                {
                    strOrder += ",RouteOrder desc, createdtime desc";
                }
            }
            else if (timeorder != 0)
            {
                if (timeorder == 1)
                {
                    strOrder += ",createdtime desc";
                }
                else if (timeorder == 2)
                {
                    strOrder += ",createdtime asc";
                }
            }
            else
            {
                strOrder += ",firstTime desc";
            }
            DataSet   mySet      = routeBLL.GetPageData(20, pageIndex, strWhere, strOrder);
            DataTable tableCount = mySet.Tables["Count"];
            DataTable myTable    = mySet.Tables["Data"];

            int countRows = 0;

            countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString());
            string[] urlParam = { "key", "cid1", "cid2", "rorder", "torder", "sKey" };
            pageInfo = pg.pageForDynamic(countRows, 20, pageIndex, urlParam);

            StringBuilder sb = new StringBuilder();

            foreach (DataRow dr in myTable.Rows)
            {
                sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString());
                sb.AppendFormat("<td align='center'><input type='checkbox' name='routeCheckbox' id='checkbox{0}' value='{0}' /></td>", dr["ID"].ToString());
                string pingyin = rcList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == Convert.ToInt32(dr["LocationID"].ToString())); }).ClassNamePY;

                sb.AppendFormat("<td title='{1}'><a href='/{3}/{2}.html' target='_blank'>{0}</a></td>", Function.Clip(dr["Title"].ToString(), 10, true), dr["Title"].ToString(), dr["ID"].ToString(), pingyin);
                sb.AppendFormat("<td align='center'>{0}</td>", GetRouteClass(Convert.ToInt32(dr["LocationID"].ToString())));
                sb.AppendFormat("<td align='center'>{0}<br/>{1}</td>", dr["Supplier"].ToString(), dr["SupplierTel"].ToString());
                sb.AppendFormat("<td align='center'><input type='text' class='ipt' id='RoutePrice_{1}' value='{0}' maxlength='6' size='5'/><input type='button' class='button' value='修改' size='3' onclick='UpdateRoutePrice({1})' /></td>", Convert.ToInt32(dr["Price"]) == 0 ? 0 : Convert.ToInt32(dr["Price"]), Convert.ToInt32(dr["ID"].ToString()));
                //sb.AppendFormat("<td align='center'>{0}</td>", dr["StartPosition"].ToString());
                sb.AppendFormat("<td align='center'><input type='text' class='ipt' id='RouteOrder_{1}' value='{0}' maxlength='5' size='3'/><input type='button' class='button' value='修改' size='3' onclick='UpdateRouteOrder({1})' /></td>", dr["RouteOrder"].ToString(), Convert.ToInt32(dr["ID"].ToString()));
                //sb.AppendFormat("<td align='center'>{0}</td>", Function.Clip(dr["Destination"].ToString(), 8, true));
                //sb.AppendFormat("<td align='center'><select name='routeShow_{0}' onchange='UpdateRouteShow({0})'><option value='1'>是</option><option value='0'>否</option></select></td>", Convert.ToInt32(dr["ID"].ToString()));
                //sb.AppendFormat("<td align='center'>{0}</td>", dr["RouteTime"].ToString());
                //sb.AppendFormat("<td align='center'>{0}</td>", dr["TrafficModel"].ToString());
                //sb.AppendFormat("<td align='center'>{0}</td>", dr["StartTime"].ToString());
                sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToBoolean(dr["RecommendHot"]) ? "<span class='red'>是<span>" : "否");
                sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToBoolean(dr["IsDisplay"]) ? "<span class='red'>是</span>" : "否");
                sb.AppendFormat("<td align='center'>{0}</td>", dr["ViewCount"].ToString());
                sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToDateTime(dr["firstTime"]).ToString("yyyy-MM-dd"));
                sb.AppendFormat("<td align='center'>{0}</td>", Convert.ToDateTime(dr["CreatedTime"]).ToString("yyyy-MM-dd"));
                //sb.AppendFormat("<td align='center'>{0}</td>", dr["FirstTime"].ToString());
                sb.Append("<td align='center'>");
                //sb.AppendFormat("<a href='javascript:void(0)' onclick='routeCopy({0})'>复制</a> ", dr["ID"].ToString());
                sb.AppendFormat("<a href='RouteEdit.aspx?id={0}'>修改</a> ", dr["ID"].ToString());
                sb.AppendFormat("<a href='javascript:void(0)' onclick='routeDelete({0})'>删除</a> ", dr["ID"].ToString());
                sb.AppendFormat("<a href='../RouteComment/RouteCommentList.aspx?routeId={0}'>查看评论</a>", dr["ID"].ToString());
                sb.Append("</td>");

                sb.Append("</tr>");
            }
            dataRouteList = sb.ToString();
        }
Пример #9
0
        private void BindRouteList()
        {
            string routewhere = " isdisplay=1 ";

            if (pid == 0)
            {
                routewhere += " and charindex('," + cid + ",',','+themeId+',')>0";
            }
            else
            {
                routewhere += " and charindex('," + cid + ",',','+routesPrentClassID+',')>0";
            }

            ClassLibrary.Common.Pagination pg = new ClassLibrary.Common.Pagination();
            //ClassLibrary.BLL.Routes rbll = new ClassLibrary.BLL.Routes();

            DataSet   mySet      = bll.GetPageData(10, pageIndex, routewhere, "RouteOrder Asc, CreatedTime Desc");
            DataTable tableCount = mySet.Tables["Count"];
            DataTable myTable    = mySet.Tables["Data"];

            int countRows = 0;

            countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString());

            if (countRows % 10 == 0)
            {
                countPage = countRows / 10;
            }
            else
            {
                countPage = countRows / 10 + 1;
            }

            /*if (countPage > 1)
             * {
             *  //if (pageIndex != 1)
             *  //{
             *  //    pageInfo += string.Format("<a class='pagelink' rel='nofollow' href='{0}/{1}/{2}'>上一页</a>",
             *  //        SysConfig.webSiteApp, currClass.ClassNamePY, pageIndex == 2 ? "" : ("page" + (pageIndex - 1)));
             *  //}
             *  //if (countPage > pageIndex)
             *  //{
             *  //    pageInfo += string.Format("<a class='pagelink' rel='nofollow' href='{0}/{1}/page{2}'>更&nbsp;&nbsp;多</a>",
             *  //        SysConfig.webSiteApp, currClass.ClassNamePY, pageIndex + 1);
             *  //}
             *  pageInfo += string.Format("<a class='pagelink' rel='nofollow' onclick='loadMore({0},{1},{2},{3})' >更&nbsp;&nbsp;多</a>",
             *      pageIndex + 1, countPage, cid, pid);
             * }*/
            StringBuilder sb = new StringBuilder();
            List <ClassLibrary.Model.Routes> pgRouteList = bll.GetModelList(myTable);

            foreach (ClassLibrary.Model.Routes model in pgRouteList)
            {
                //string[] images = model.Image.Split(',');
                //int tmpClassId = Convert.ToInt32(model.routesClassID.Split(',')[1]);
                string tmpPy = glClass.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); }).ClassNamePY;
                sb.AppendLine("<li>");
                sb.AppendFormat("<a href='{0}/{1}/{2}.html'>", SysConfig.webSiteApp, tmpPy, model.ID);
                sb.AppendFormat("<div class='hot_img' style='background-image:url({0}{1})'></div>", SysConfig.webSite, SysConfig.UploadFilePathRoutesImg + model.AppImg);
                sb.AppendFormat("<div class='hot_title'>{0}</div>", Function.Clip(model.Title, 18, true));
                sb.AppendFormat("<div class='hot_price'>&yen;<em>{0}</em>起</div>", Convert.ToInt32(model.Price));
                sb.AppendLine("</a>");
                sb.AppendLine("</li>");
            }
            if (sb.Length == 0)
            {
                sb.Append("<div class='nopagedata'>没有相关旅游线路</div>");
            }
            dataRouteList = sb.ToString();
        }