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'>¥<em>{0}</em>起</span>", Convert.ToInt32(dr["price"]));
sb.AppendLine("</div>");
sb.AppendLine("</li>");
if (i == 5)
{
break;
}
}
dataSalesList = sb.ToString();
}
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'>¥<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());
}
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("¥{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();
}
//绑定相关线路
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("¥{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();
}
//线路
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'>¥<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();
}
//特色旅游 推荐 热门等等 不查三峡旅游
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'>¥{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'>¥<em>{0}</em>元起</li>", Convert.ToInt32(dr["Price"]));
}
}
sb.Append("</ul></div>");
if (q == 0)
{
Print(context, "");
}
else
{
Print(context, sb.ToString());
}
}
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'>¥<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();
}
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();
}
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}'>更 多</a>",
* // SysConfig.webSiteApp, currClass.ClassNamePY, pageIndex + 1);
* //}
* pageInfo += string.Format("<a class='pagelink' rel='nofollow' onclick='loadMore({0},{1},{2},{3})' >更 多</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'>¥<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();
}