//国内出境周边旅游线路
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 findSanxiaRoute(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();
List <ClassLibrary.Model.RouteClass> globalList = routeClassBll.GetSubList((int)SysConfig.RouteClass.峡旅游);
List <ClassLibrary.Model.Routes> routeList = routeBLL.GetModelList(6, "isdisplay=1 and (CHARINDEX('," + id + ",',','+routesPrentClassID+',') > 0)", "RouteOrder Asc,Createdtime Desc");
StringBuilder sb = new StringBuilder();
sb.AppendLine("<ul>");
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}' class='blk' ><img class='lazy' data-original='{0}' alt='' width='222' height='137' /></a>",
SysConfig.UploadFilePathRoutesImg + model.Image.Split(',')[0], model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite).AppendLine();
sb.AppendFormat("<p class='item_t'><a href='{4}/{2}/{3}.html' title='{1}'>{0}</a></p>",
Function.Clip(model.Title, 14, false), model.Title, temModel.ClassNamePY, model.ID, SysConfig.webSite).AppendLine();
sb.AppendFormat("<p class='item_f' title='{0}'>{1}</p>", model.Bright, Function.Clip(model.Bright, 18, false)).AppendLine();
string tp = string.Format("¥{0}<span>起</span>", Convert.ToInt32(model.Price));
if (Convert.ToInt32(model.Price) == 0)
{
tp = "电询";
}
sb.AppendFormat("<p class='item_p'>{0}</p>", tp).AppendLine();
sb.AppendLine("</li>");
}
sb.AppendLine("</ul>");
Print(context, sb.ToString());
}
private void RouteClassDelete(HttpContext context)
{
string id = context.Request.QueryString["id"];
ClassLibrary.BLL.Routes routeBll = new ClassLibrary.BLL.Routes();
if (routeBll.GetModelList("CHARINDEX('," + int.Parse(id) + ",',','+routesPrentClassID+',')>0").Count > 0)
{
Print(context, "existdata");
return;
}
ClassLibrary.BLL.News newsBll = new ClassLibrary.BLL.News();
if (newsBll.GetModelList("CHARINDEX('," + int.Parse(id) + ",',','+routeClassID+',')>0").Count > 0)
{
Print(context, "existdata");
return;
}
ClassLibrary.BLL.RouteClass routeClassBLL = new ClassLibrary.BLL.RouteClass();
if (routeClassBLL.Delete(int.Parse(id)) > 0)
{
Print(context, "success");
}
else
{
Print(context, "errors");
}
}
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 updateRouteImg(HttpContext context)
{
ClassLibrary.BLL.Routes routeBll = new ClassLibrary.BLL.Routes();
List <ClassLibrary.Model.Routes> routeList = routeBll.GetModelList(string.Empty);
string fileFullPath = context.Server.MapPath(SysConfig.UploadFilePathRoutesImg);
foreach (ClassLibrary.Model.Routes model in routeList)
{
string fileName = model.Image.Split(',')[0];
if (!File.Exists(fileFullPath + fileName))
{
continue;
}
//缩图
Bitmap tmp = new Bitmap(fileFullPath + fileName);
Bitmap bmp0 = Function.MakeThumNail(tmp, 100, 64);
tmp.Dispose();
//bmp0.Save(fileFullPath + fileName);
string ext = Path.GetExtension(fileName);
string appfileName = Function.GetRandomTime() + ext;
Function.SaveBitmapImg(bmp0, fileFullPath + appfileName, ((long)90));
bmp0.Dispose();
routeBll.Updates("appImg = '" + appfileName + "'", "id = " + model.ID);
}
Print(context, "success");
}
protected void GetHotRoute()
{
ClassLibrary.BLL.Routes bll = new ClassLibrary.BLL.Routes();
ClassLibrary.BLL.RouteClass rcBll = new ClassLibrary.BLL.RouteClass();
List <ClassLibrary.Model.RouteClass> rcList = rcBll.GetModelList(String.Empty);
List <ClassLibrary.Model.Routes> list = bll.GetModelList(6, "isdisplay = 1", "RecommendHot Desc,routeOrder Asc,CreatedTime Desc");
string strHTML = @"<div class='pro'>
<a href='{6}/{5}/{3}.html' target='_blank'>
<img src='{0}' width='180px' height='120px' alt='{1}' />
</a>
<p class='name'><a href='{6}/{5}/{3}.html' title='{1}' target='_blank'>{2}</a></p>
<p class='price'>{4}</p>
</div>";
StringBuilder sb = new StringBuilder();
foreach (ClassLibrary.Model.Routes model in list)
{
//int classId = Convert.ToInt32(model.routesClassID.Split(',')[1]);
sb.AppendFormat(strHTML,
SysConfig.GetRoutePhoto(model.Image),
model.Title,
Function.Clip(model.Title, 14, true),
model.ID,
(model.Price == 0 ? "价格电询" : "¥" + Convert.ToInt32(model.Price) + "起"),
rcList.Find(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ID == model.LocationID); }).ClassNamePY,
SysConfig.webSite);
}
hotRouteList = 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();
}
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 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 RefreshLinks(HttpContext context)
{
ClassLibrary.BLL.News newsBll = new ClassLibrary.BLL.News();
ClassLibrary.BLL.Routes routeBll = new ClassLibrary.BLL.Routes();
ClassLibrary.BLL.RouteDetails rdBll = new ClassLibrary.BLL.RouteDetails();
ClassLibrary.BLL.InternalLink linkBll = new ClassLibrary.BLL.InternalLink();
List <ClassLibrary.Model.InternalLink> linkList = linkBll.GetModelList(string.Empty);
List <ClassLibrary.Model.News> newsList = newsBll.GetModelList("");
foreach (ClassLibrary.Model.News model in newsList)
{
string tmpContent = ClassLibrary.BLL.WebClass.addInternelLink(model.Content, ClassLibrary.Common.SysConfig.linkCount, linkList);
if (model.Content != tmpContent)
{
model.Content = tmpContent;
newsBll.Update(model);
}
}
List <ClassLibrary.Model.Routes> routeList = routeBll.GetModelList("");
foreach (ClassLibrary.Model.Routes model in routeList)
{
model.RouteFeature = ClassLibrary.BLL.WebClass.addInternelLink(model.RouteFeature, 1, linkList);
model.DescriptionRoute = ClassLibrary.BLL.WebClass.addInternelLink(model.DescriptionRoute, 3, linkList);
model.DescriptionPrice = ClassLibrary.BLL.WebClass.addInternelLink(model.DescriptionPrice, 1, linkList);
model.RouteNotice = ClassLibrary.BLL.WebClass.addInternelLink(model.RouteNotice, 1, linkList);
routeBll.Update(model);
if (model.DetailType)
{
List <ClassLibrary.Model.RouteDetails> rdList = rdBll.GetModelList("routeid=" + model.ID);
foreach (ClassLibrary.Model.RouteDetails model2 in rdList)
{
string tmpDetail = ClassLibrary.BLL.WebClass.addInternelLink(model2.DayDetail, 1, linkList);
if (model2.DayDetail != tmpDetail)
{
model2.DayDetail = tmpDetail;
rdBll.Update(model2);
}
}
}
}
Print(context, "success");
}
private void BindRouteList()
{
StringBuilder sb = new StringBuilder();
List <ClassLibrary.Model.Routes> routeList = routeBll.GetModelList(8, "isdisplay = 1", "RecommendHot desc,RouteOrder Asc");
int i = 0;
foreach (ClassLibrary.Model.Routes model in routeList)
{
i++;
string tmpClassPy = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == model.LocationID); }).ClassNamePY;
sb.AppendFormat("<li class='{0}'>", i == 8 ? "lastline" : "");
sb.AppendFormat("<a href='{0}/mip/{1}/{2}.html' target='_blank'>", SysConfig.webSiteApp, tmpClassPy, 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, 20, true));
sb.AppendFormat("<div class='hot_price'>¥<em>{0}</em>起</div>", Convert.ToInt32(model.Price));
sb.AppendLine("</a>");
sb.AppendLine("</li>");
}
dataRouteList = sb.ToString();
}
private void BindSchedule()
{
DateTime dt = DateTime.Now;
StringBuilder sb = new StringBuilder();
gList = rcBll.GetModelList(string.Empty);
List <ClassLibrary.Model.Routes> routeList = routeBll.GetModelList("isdisplay = 1 and CHARINDEX('," + (int)SysConfig.RouteClass.豪华船 + ",',','+routesPrentClassID+',') > 0 and DateType = 1");
for (int n = 0; n < 30; n++)
{
dt = dt.AddDays(1);
sb.AppendLine("<dl>");
sb.AppendFormat("<dd class='tgs_date'>{0}月{1}日 {2}</dd>", dt.Month, dt.Day, System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(dt.DayOfWeek).Replace("星期", "周"));
string cdate = dt.Year + "-" + dt.Month + "-" + dt.Day;
List <ClassLibrary.Model.Routes> cList = routeList.FindAll(delegate(ClassLibrary.Model.Routes rs) { return(rs.DatePrice.IndexOf(cdate + ",") > -1); });
if (cList.Count == 0)
{
sb.AppendLine("<dd>今日暂无船期</dd>");
}
else
{
int cn = 0;
foreach (ClassLibrary.Model.Routes rm in cList)
{
cn++;
string price = getPrice(cdate, rm.DatePrice);
string tmpPing = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == rm.LocationID); }).ClassNamePY;
sb.AppendFormat("<dd><a href='{0}/{1}/{2}.html' target='_blank'>{3}</a><span>¥{4}元</span></dd>",
SysConfig.webSite, tmpPing, rm.ID, rm.BoatName, price);
if (cn >= 8)
{
break;
}
}
}
sb.AppendLine("</dl>");
}
scheduleList = sb.ToString();
}
private void BindItem()
{
rcList = classbll.GetModelList(String.Empty);
DataTable table = classbll.GetData(" classlevel=1 and id < 6", "createdtime desc");
StringBuilder sb = new StringBuilder();
/*国内旅游*/
sb.Append("<div class='SiteMap_Item'>");
sb.AppendFormat("<p><a href='{2}/{1}/'>{0}</a></p>", "国内旅游", "guonei", SysConfig.webSite);
List <ClassLibrary.Model.RouteClass> gnList = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == (int)SysConfig.RouteClass.国内旅游); });
foreach (ClassLibrary.Model.RouteClass model in gnList)
{
sb.AppendFormat("<p>{0}</p>", model.ClassName);
List <ClassLibrary.Model.RouteClass> level3List = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == model.ID); });
foreach (ClassLibrary.Model.RouteClass model3 in level3List)
{
sb.Append("<div class='SiteMap_Text'>");
sb.AppendFormat("<div class='SiteMap_Text_first'><a href='{2}/{1}/'>{0}旅游</a></div>", model3.ClassName, model3.ClassNamePY, SysConfig.webSite);
sb.Append(" <div class='SiteMap_Text_child'>");
List <ClassLibrary.Model.RouteClass> level4List = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == model3.ID); });
foreach (ClassLibrary.Model.RouteClass model4 in level4List)
{
sb.AppendFormat("<a href='{2}/{1}/'>{0}旅游</a>", model4.ClassName, model4.ClassNamePY, SysConfig.webSite);
}
sb.Append("</div></div>");
}
}
sb.Append("</div>");
/*出境旅游*/
sb.Append("<div class='SiteMap_Item'>");
sb.AppendFormat("<p><a href='{2}/{1}/'>{0}</a></p>", "出境旅游", "chujing", SysConfig.webSite);
List <ClassLibrary.Model.RouteClass> cjList = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == (int)SysConfig.RouteClass.出境旅游); });
foreach (ClassLibrary.Model.RouteClass model in cjList)
{
sb.Append("<div class='SiteMap_Text'>");
sb.AppendFormat("<div class='SiteMap_Text_first'><a href='{2}/{1}/'>{0}旅游</a></div>", model.ClassName, model.ClassNamePY, SysConfig.webSite);
sb.Append(" <div class='SiteMap_Text_child'>");
List <ClassLibrary.Model.RouteClass> level2List = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == model.ID); });
foreach (ClassLibrary.Model.RouteClass model2 in level2List)
{
sb.AppendFormat("<a href='{2}/{1}/'>{0}旅游</a>", model2.ClassName, model2.ClassNamePY, SysConfig.webSite);
}
sb.Append("</div></div>");
}
sb.Append("</div>");
/*三峡旅游*/
sb.Append("<div class='SiteMap_Item'>");
sb.AppendFormat("<p><a href='{2}/{1}/'>{0}</a></p>", "三峡旅游", "sanxia", SysConfig.webSite);
List <ClassLibrary.Model.RouteClass> sxList = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == (int)SysConfig.RouteClass.峡旅游); });
sb.Append("<div class='SiteMap_Text'>");
sb.AppendFormat("<div class='SiteMap_Text_first'> </div>");
sb.Append("<div class='SiteMap_Text_child'>");
foreach (ClassLibrary.Model.RouteClass model in sxList)
{
sb.AppendFormat("<a href='{2}/{1}/'>{0}</a>", model.ClassName, model.ClassNamePY, SysConfig.webSite);
}
sxList = rcList.FindAll(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ParentID == (int)SysConfig.RouteClass.豪华船); });
foreach (ClassLibrary.Model.RouteClass model in sxList)
{
sb.AppendFormat("<a href='{2}/{1}/'>{0}</a>", model.ClassName, model.ClassNamePY, SysConfig.webSite);
}
sb.Append("</div></div></div>");
/*主题旅游*/
ClassLibrary.BLL.RouteType rtBll = new ClassLibrary.BLL.RouteType();
sb.Append("<div class='SiteMap_Item'>");
sb.AppendFormat("<p>{0}</p>", "主题旅游");
List <ClassLibrary.Model.RouteType> ztList = rtBll.GetModelList(String.Empty);
sb.Append("<div class='SiteMap_Text'>");
sb.AppendFormat("<div class='SiteMap_Text_first'> </div>");
sb.Append("<div class='SiteMap_Text_child'>");
foreach (ClassLibrary.Model.RouteType model in ztList)
{
sb.AppendFormat("<a href='{2}/{1}/'>{0}</a>", model.ClassName, model.classNamePY, SysConfig.webSite);
}
sb.Append("</div></div></div>");
DataMap = sb.ToString();
ClassLibrary.BLL.Routes routeBll = new ClassLibrary.BLL.Routes();
List <ClassLibrary.Model.Routes> routeList = routeBll.GetModelList(20, "isdisplay = 1", "CreatedTime Desc");
StringBuilder sb2 = new StringBuilder();
foreach (ClassLibrary.Model.Routes model in routeList)
{
ClassLibrary.Model.RouteClass temClass = rcList.Find(delegate(ClassLibrary.Model.RouteClass trc) { return(trc.ID == model.LocationID); });
sb2.AppendFormat("<li><a href='{0}/{1}/{2}.html' target='_blank'>{3}</a></li>",
SysConfig.webSite, temClass.ClassNamePY, model.ID, model.Title).AppendLine();
}
mapRoute = sb2.ToString();
ClassLibrary.BLL.News newsBll = new ClassLibrary.BLL.News();
List <ClassLibrary.Model.News> newsList = newsBll.GetModelList(10, "isdisplay = 1 and newsClassId = 2", "CreatedTime Desc");
StringBuilder sb3 = new StringBuilder();
foreach (ClassLibrary.Model.News model in newsList)
{
sb3.AppendFormat("<li><a href='{0}/{1}/{2}.html' target='_blank'>{3}</a></li>",
SysConfig.webSite, Enum.GetName(typeof(SysConfig.NewsClassPY), model.newsClassID), model.ID, model.Title).AppendLine();
}
mapArticle = sb3.ToString();
newsList = newsBll.GetModelList(10, "isdisplay = 1 and newsClassId = 1", "CreatedTime Desc");
StringBuilder sb4 = new StringBuilder();
foreach (ClassLibrary.Model.News model in newsList)
{
sb4.AppendFormat("<li><a href='{0}/{1}/{2}.html' target='_blank'>{3}</a></li>",
SysConfig.webSite, Enum.GetName(typeof(SysConfig.NewsClassPY), model.newsClassID), model.ID, model.Title).AppendLine();
}
mapNews = sb4.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();
}
public void findZhutiRoute(HttpContext context)
{
int id = Convert.ToInt32(context.Request.QueryString["where"]);
string className = context.Request.QueryString["name"];
StringBuilder sbc = new StringBuilder();
ClassLibrary.BLL.Routes routeBLL = new ClassLibrary.BLL.Routes();
ClassLibrary.BLL.RouteClass routeClassBll = new ClassLibrary.BLL.RouteClass();
List <ClassLibrary.Model.RouteClass> globalList = routeClassBll.GetModelList(string.Empty);
sbc.AppendLine("<div class='ztc_img'>");
//if (ztAdList.Count > 0)
//{
// ztModel = ztAdList[0];
//}
//sbc.AppendFormat("<a href='{0}' title='{1}'><img class='lazy' data-original='{2}' alt='' width='222' height='467' /></a>",
// ztModel.LinkURL, ztModel.Title, SysConfig.UploadFilePathAdImg + ztModel.Img).AppendLine();
sbc.AppendLine("</div>");
sbc.AppendLine("<ul class='ztc_items'>");
List <ClassLibrary.Model.Routes> ztRouteListm = routeBLL.GetModelList(6, "isdisplay=1 and charindex('," + id + ",',','+ThemeID+',')>0 and CHARINDEX('1',RecommendIndex) > 0", "routeOrder Asc, CreatedTime Desc");
string ztids = "";
foreach (ClassLibrary.Model.Routes rm in ztRouteListm)
{
ClassLibrary.Model.RouteClass tmpc = globalList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == rm.LocationID); });
sbc.AppendLine("<li>");
sbc.AppendFormat("<a href='{0}/{1}/{2}.html' title='{3}' class='blk' ><img class='lazy' data-original='{4}' alt='' width='222' height='139' /></a>",
SysConfig.webSite, tmpc.ClassNamePY, rm.ID, rm.Title, SysConfig.UploadFilePathRoutesImg + rm.Image.Split(',')[0]).AppendLine();
sbc.AppendFormat("<p class='item_t'><a href='{0}/{1}/{2}.html' title='{3}'>{4}</a></p>",
SysConfig.webSite, tmpc.ClassNamePY, rm.ID, rm.Title, Function.Clip(rm.Title, 15, false)).AppendLine();
//sbc.AppendFormat("<p class='item_f' title='{0}'>{1}</p>", rm.Bright, Function.Clip(rm.Bright, 19, false)).AppendLine();
string tp = string.Format("¥{0}<span>起</span>", Convert.ToInt32(rm.Price));
if (Convert.ToInt32(rm.Price) == 0)
{
tp = "电询";
}
sbc.AppendFormat("<p class='item_p'>{0}</p>", tp).AppendLine();
sbc.AppendLine("</li>");
ztids += rm.ID + ",";
}
if (ztids.Length > 0)
{
ztids = ztids.Substring(0, ztids.Length - 1);
}
sbc.AppendLine("</ul>");
sbc.AppendLine("<div class='ztc_more'>");
sbc.AppendLine("<dl class='ztc_more_gn'>");
sbc.AppendFormat("<dt>国内热门{0}旅游线路</dt>", className).AppendLine();
if (ztids.Length > 0)
{
List <ClassLibrary.Model.Routes> ztRouteListg = routeBLL.GetModelList(6, "isdisplay=1 and id not in (" + ztids + ") and charindex('," + id + ",',','+ThemeID+',')>0 and charindex('," + (int)SysConfig.RouteClass.国内旅游 + ",',','+routesPrentClassID+',')>0", "routeOrder Asc, CreatedTime Desc");
foreach (ClassLibrary.Model.Routes rm in ztRouteListg)
{
ClassLibrary.Model.RouteClass tmpc = globalList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == rm.LocationID); });
string tp = string.Format("¥{0}起", Convert.ToInt32(rm.Price));
if (Convert.ToInt32(rm.Price) == 0)
{
tp = "电询";
}
sbc.AppendFormat("<dd><a href='{0}/{1}/{2}.html' title='{3}'>{4}</a><span>{5}</span></dd>",
SysConfig.webSite, tmpc.ClassNamePY, rm.ID, rm.Title, Function.Clip(rm.Title, 10, false), tp).AppendLine();
}
}
sbc.AppendLine("</dl>");
sbc.AppendLine("<dl class='ztc_more_cj'>");
sbc.AppendFormat("<dt>出境热门{0}旅游线路</dt>", className).AppendLine();
if (ztids.Length > 0)
{
List <ClassLibrary.Model.Routes> ztRouteListc = routeBLL.GetModelList(6, "isdisplay=1 and id not in (" + ztids + ") and charindex('," + id + ",',','+ThemeID+',')>0 and charindex('," + (int)SysConfig.RouteClass.出境旅游 + ",',','+routesPrentClassID+',')>0", "routeOrder Asc, CreatedTime Desc");
foreach (ClassLibrary.Model.Routes rm in ztRouteListc)
{
ClassLibrary.Model.RouteClass tmpc = globalList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == rm.LocationID); });
string tp = string.Format("¥{0}起", Convert.ToInt32(rm.Price));
if (Convert.ToInt32(rm.Price) == 0)
{
tp = "电询";
}
sbc.AppendFormat("<dd><a href='{0}/{1}/{2}.html' title='{3}'>{4}</a><span>{5}</span></dd>",
SysConfig.webSite, tmpc.ClassNamePY, rm.ID, rm.Title, Function.Clip(rm.Title, 10, false), Convert.ToInt32(rm.Price)).AppendLine();
}
}
sbc.AppendLine("</dl>");
//sbc.AppendLine("<div class='ztc_more_img'>");
//sbc.AppendFormat("<a href='{0}' title='{1}'><img src='{2}' alt='' width='190' height='111' /></a>",
// ztModel.LinkURL, ztModel.Title, SysConfig.UploadFilePathAdImg + ztImgr).AppendLine();
//sbc.AppendLine("</div>");
sbc.AppendLine("<div class='inx_zt_bg_right'></div>");
sbc.AppendLine("</div>");
Print(context, sbc.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());
}
private void updateImgAddress(HttpContext context)
{
ClassLibrary.BLL.Routes routeBll = new ClassLibrary.BLL.Routes();
ClassLibrary.BLL.RouteDetails rdBll = new ClassLibrary.BLL.RouteDetails();
List <ClassLibrary.Model.Routes> routeList = routeBll.GetModelList("id > 677");
foreach (ClassLibrary.Model.Routes model in routeList)
{
bool updated = false;
if (model.RouteFeature.IndexOf("www.ytszg.com") > -1)
{
model.RouteFeature = model.RouteFeature.Replace("www.ytszg.com", "www.qu17.com");
updated = true;
}
if (model.RouteFeature.IndexOf("file/newsImg/image") > -1)
{
model.RouteFeature = model.RouteFeature.Replace("file/newsImg/image", "images");
updated = true;
}
if (model.DescriptionRoute.IndexOf("www.ytszg.com") > -1)
{
model.DescriptionRoute = model.DescriptionRoute.Replace("www.ytszg.com", "www.qu17.com");
updated = true;
}
if (model.DescriptionRoute.IndexOf("file/newsImg/image") > -1)
{
model.DescriptionRoute = model.DescriptionRoute.Replace("file/newsImg/image", "images");
updated = true;
}
if (model.RouteNotice.IndexOf("www.ytszg.com") > -1)
{
model.RouteNotice = model.RouteNotice.Replace("www.ytszg.com", "www.qu17.com");
updated = true;
}
if (model.DescriptionPrice.IndexOf("www.ytszg.com") > -1)
{
model.DescriptionPrice = model.DescriptionPrice.Replace("www.ytszg.com", "www.qu17.com");
updated = true;
}
if (updated)
{
routeBll.Update(model);
}
}
List <ClassLibrary.Model.RouteDetails> routedList = rdBll.GetModelList(" routeid > 677");
foreach (ClassLibrary.Model.RouteDetails model in routedList)
{
bool updated = false;
if (model.DayDetail.IndexOf("www.ytszg.com") > -1)
{
model.DayDetail = model.DayDetail.Replace("www.ytszg.com", "www.qu17.com");
updated = true;
}
if (model.DayDetail.IndexOf("file/newsImg/image") > -1)
{
model.DayDetail = model.DayDetail.Replace("file/newsImg/image", "images");
updated = true;
}
if (updated)
{
rdBll.Update(model);
}
}
Print(context, "success");
}
//线路
private void BindRouteList()
{
string routewhere = " isdisplay=1 and CHARINDEX('" + sKey + "',Title) > 0";
string orderwhere = "routeOrder Asc";
if (order == 1)
{
orderwhere = "price Asc";
}
else if (order == 2)
{
orderwhere = "createdTime Desc";
}
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());
string currUrl = currentFilter2;
if (order != 0)
{
currUrl += "order" + order;
}
pageInfo = pg.pagination5(countRows, 10, pageIndex, currUrl);
StringBuilder sb = new StringBuilder();
List <ClassLibrary.Model.Routes> pgRouteList = bll.GetModelList(myTable);
foreach (ClassLibrary.Model.Routes model in pgRouteList)
{
string[] images = model.Image.Split(',');
string tmpPy = glClass.Find(delegate(ClassLibrary.Model.RouteClass tm) { return(tm.ID == model.LocationID); }).ClassNamePY;
sb.AppendLine("<div class='routeList_item'>");
if (model.RecommendHot)
{
sb.AppendLine("<div class='icon_tj'></div>");
}
sb.AppendLine("<div class='routelist_img'>");
sb.AppendFormat("<a href='{4}/{3}/{0}.html' target='_blank' title='{2}' rel='nofollow'><img src='{1}' alt='{2}' width='208' height='127'/></a>",
model.ID, ClassLibrary.Common.SysConfig.UploadFilePathRoutesImg + images[0], model.Title, tmpPy, SysConfig.webSite).AppendLine();
sb.AppendLine("</div>");
sb.AppendLine("<div class='routelist_middle'>");
sb.AppendLine("<div class='routelist_title'>");
sb.AppendFormat("<a href='{4}/{3}/{0}.html' target='_blank' title='{2}'>{1}</a>",
model.ID, Function.Clip(model.Title, 40, false), model.Title, tmpPy, SysConfig.webSite).AppendLine();
sb.AppendLine("</div>");
sb.AppendFormat("<div class='rootlist_feature'>{0}</div>", Function.Clip(model.Bright, 70, true)).AppendLine();
string maidian = "";
if (model.ThemeID != "")
{
string[] themeIds = model.ThemeID.Split(',');
int n = 0;
foreach (string themeid in themeIds)
{
ClassLibrary.Model.RouteType tim = grtClass.Find(delegate(ClassLibrary.Model.RouteType tm) { return(tm.ID.ToString() == themeid); });
if (tim == null)
{
continue;
}
n++;
maidian += string.Format("<span class='zhuti'><a href='{1}/{2}/' target='_blank'>{0}</a></span>", tim.ClassName, SysConfig.webSite, tim.classNamePY);
if (n >= 8)
{
break;
}
}
}
sb.AppendFormat("<div class='routeList_maidian'>{0}</div>", maidian).AppendLine();//<span class='youhui'><em>省</em>200元/人</span>
string startdate = "";
if (model.DatePrice != "")
{
int sn = 1;
string[] sdates = model.DatePrice.Split('|');
ArrayList priceList = new ArrayList();
foreach (string sd in sdates)
{
if (sd == "")
{
continue;
}
string curdate = sd.Split(',')[0];
string[] tpd = curdate.Split('-');
DateTime tmpDate = new DateTime(Convert.ToInt32(tpd[0]), Convert.ToInt32(tpd[1]), Convert.ToInt32(tpd[2]));
if (tmpDate < DateTime.Now)
{
continue;
}
priceList.Add(tmpDate);
//startdate += curdate.Substring(sd.IndexOf("-") + 1) + " , ";
}
if (priceList.Count > 0)
{
priceList.Sort();
foreach (DateTime dtitem in priceList)
{
startdate += dtitem.Month + "-" + dtitem.Day + " , ";
if (sn >= 12)
{
break;
}
sn++;
}
}
}
else if (!model.DateType)
{
DateTime rdtime = DateTime.Now;
for (int k = 0; k < 12; k++)
{
rdtime = rdtime.AddDays(1);
startdate += rdtime.Month + "-" + rdtime.Day + " , ";
}
}
if (startdate != "")
{
startdate = startdate.Substring(0, startdate.Length - 3);
}
else
{
startdate = "详情请咨询在线客服或拨打400-017-5761";
}
sb.AppendFormat("<div class='routeList_start'><span class='startTime'><i class='cftq_icon'></i>出发团期：{0}</span></div>", startdate).AppendLine();
sb.AppendLine("</div>");
sb.AppendLine("<div class='routelist_right'>");
string strPrice = "";
if (model.Price == 0)
{
strPrice = "电询";
}
else
{
strPrice = "¥<span>" + Convert.ToInt32(model.Price) + "</span>起";
}
sb.AppendFormat("<div class='rootlist_price'>{0}</div>", strPrice).AppendLine();
sb.AppendFormat("<div class='content_book'><a href='{2}/{1}/{0}.html' target='_blank' rel='nofollow'>立即查看</a></div>",
model.ID, tmpPy, SysConfig.webSite);
sb.AppendLine("</div>");
sb.AppendLine("</div>");
}
if (sb.Length == 0)
{
sb.Append("<div class='nopagedata'>没有" + currentfiltertext + "旅游线路</div>");
}
dataRouteList = sb.ToString();
}
