//国内出境周边旅游线路 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()); }