//国内出境周边旅游线路
private string BindRouteList(int classId)
{
string where = "isdisplay=1 and (CHARINDEX('," + classId + ",',','+routesPrentClassID+',') > 0)";
if (classId == homeid)
{
where += "and (CHARINDEX('," + cqid + ",',','+routesPrentClassID+',') = 0)";
}
DataTable mytable = routeBLL.GetData(6, where, " RecommendHot Desc, RouteOrder Asc, Createdtime Desc");
List <ClassLibrary.Model.Routes> routeList = routeBLL.GetModelList(mytable);
StringBuilder sb = new StringBuilder();
foreach (ClassLibrary.Model.Routes model in routeList)
{
ClassLibrary.Model.RouteClass temModel = globalList.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); });
sb.AppendLine("<li>");
sb.AppendFormat("<a href='{4}/{2}/{3}.html' title='{1}' target='_blank' rel='nofollow' class='imglink'><img alt='' src='{0}' width='264' height='153' /></a>",
SysConfig.UploadFilePathRoutesImg + model.Image.Split(',')[0], model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite);
sb.AppendLine("<div class='rinfo'>");
sb.AppendFormat("<a class='rlink' href='{4}/{2}/{3}.html' title='{1}' target='_blank'><span>{0}</span></a>",
Function.Clip(model.Title, 16, true), model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite);
sb.AppendFormat("<div class='rprice'>¥<em>{0}</em>起</div>", Convert.ToInt32(model.Price));
sb.AppendLine("</div>");
sb.AppendLine("</li>");
}
return(sb.ToString());
}
//国内
public void findhomeRoute(HttpContext context)
{
int id = Convert.ToInt32(context.Request.QueryString["where"]);
ClassLibrary.BLL.Routes routeBLL = new ClassLibrary.BLL.Routes();
ClassLibrary.BLL.RouteClass routeClassBLL = new ClassLibrary.BLL.RouteClass();
DataTable mytable = routeBLL.GetData(4, "isdisplay=1 and (CHARINDEX('," + id + ",',','+routesPrentClassID+',') > 0) and RecommendHot = 1", "Createdtime Desc");
mytable.Merge(routeBLL.GetData(16, "isdisplay=1 and (CHARINDEX('," + id + ",',','+routesPrentClassID+',') > 0)", "RouteOrder Asc,Createdtime Desc"));
mytable = mytable.AsDataView().ToTable(true);
List <ClassLibrary.Model.Routes> routeList = routeBLL.GetModelList(mytable);
//List<ClassLibrary.Model.Routes> routeList = routeBLL.GetModelList(8, "(CHARINDEX('," + id + ",',','+routesPrentClassID+',') > 0)", "RouteOrder Asc,Createdtime Desc");
List <ClassLibrary.Model.RouteClass> globalList = routeClassBLL.GetSubList((int)SysConfig.RouteClass.国内旅游);
StringBuilder sb = new StringBuilder();
StringBuilder sb2 = new StringBuilder();
int count = 0;
sb.AppendLine("<ul class='gnc_down'>");
sb2.AppendLine("<ul class='gnc_up'>");
foreach (ClassLibrary.Model.Routes model in routeList)
{
if (count >= 16)
{
break;
}
ClassLibrary.Model.RouteClass temModel = globalList.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); });
if (count < 4)
{
sb2.AppendLine("<li>");
sb2.AppendFormat("<a href='{4}/{2}/{3}.html' title='{1}' class='blk' target='_blank'><img class='lazy' data-original='{0}' alt='' width='222' height='138' /></a>",
SysConfig.UploadFilePathRoutesImg + model.Image.Split(',')[0], model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite).AppendLine();
sb2.AppendFormat("<p class='item_t'><a href='{4}/{2}/{3}.html' title='{1}' target='_blank'>{0}</a></p>",
Function.Clip(model.Title, 28, false), model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite).AppendLine();
sb2.AppendFormat("<p class='item_f' title='{0}'>{1} </p>", model.Bright, Function.Clip(model.Bright, 16, false)).AppendLine();
string tp = string.Format("¥{0}<span>起</span>", Convert.ToInt32(model.Price));
if (Convert.ToInt32(model.Price) == 0)
{
tp = "电询";
}
sb2.AppendFormat("<p class='item_p'>{0}</p>", tp).AppendLine();
sb2.AppendLine("</li>");
}
else
{
sb.AppendLine("<li>");
sb.AppendFormat("<p class='item_title'><a href='{4}/{2}/{3}.html' title='{1}' target='_blank'>{0}</a></p>",
Function.Clip(model.Title, 26, false), model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite).AppendLine();
string tp = string.Format("¥{0}起", Convert.ToInt32(model.Price));
if (Convert.ToInt32(model.Price) == 0)
{
tp = "电询";
}
sb.AppendFormat("<div class='gnc_left_price'>{0}</div>", tp).AppendLine();
sb.AppendLine("</li>");
}
count++;
}
sb.AppendLine("</ul>");
sb2.AppendLine("</ul>");
Print(context, sb2.ToString() + sb.ToString());
}
