private void BindData()
{
DataTable myTable = routeClassBLL.GetData(" id =" + routeClassId);
if (myTable.Rows.Count == 1)
{
routeClassId = Convert.ToInt32(myTable.Rows[0]["ID"]);
parentId = Convert.ToInt32(myTable.Rows[0]["ParentID"]);
className = myTable.Rows[0]["ClassName"].ToString();
recommend = Convert.ToBoolean(myTable.Rows[0]["Recommend"]);
classNamePinYin = myTable.Rows[0]["classNamePY"].ToString();
seoKeyword = myTable.Rows[0]["SeoKeyword"].ToString();
seoDesc = myTable.Rows[0]["SeoDesc"].ToString();
classLevel = Convert.ToInt32(myTable.Rows[0]["ClassLevel"]);
seoTitle = myTable.Rows[0]["SeoTitle"].ToString();
classOrder = Convert.ToInt32(myTable.Rows[0]["ClassOrder"]);
image = myTable.Rows[0]["ClassImg"].ToString();
ishaidao = Convert.ToBoolean(myTable.Rows[0]["IsHaidao"]);
}
else
{
Function.goMessagePage("修改路线类型", "操作失败，数据不存在!", "RouteClass/RouteClassList.aspx?cid=" + maxClassID);
}
}
public void BindRouteSubClass()
{
string[] classid = routeParentClassIds.Split(',');
StringBuilder sb = new StringBuilder();
foreach (string text in classid)
{
if (text != "")
{
ClassLibrary.Model.RouteClass model = routeClassBLL.GetModel(Convert.ToInt32(text));
if (model.ClassLevel == 3 || model.ParentID == (int)ClassLibrary.Common.SysConfig.RouteClass.峡旅游)
{
DataTable myTable = routeClassBLL.GetData("parentID=" + text);
foreach (DataRow dr in myTable.Rows)
{
if (("," + routeParentClassIds + ",").Contains("," + dr["ID"].ToString() + ","))
{
sb.AppendFormat("<input name='ScenicCheckBox' onclick='LocationChange(this)' type='checkbox' value='{0}' checked />{1} ", dr["ID"].ToString(), dr["ClassName"].ToString());
}
else
{
sb.AppendFormat("<input name='ScenicCheckBox' onclick='LocationChange(this)' type='checkbox' value='{0}' />{1} ", dr["ID"].ToString(), dr["ClassName"].ToString());
}
}
}
}
}
routeSubClassList = sb.ToString();
}
private void GetCity(HttpContext context)
{
string ids = context.Request.QueryString["ids"];
ClassLibrary.BLL.RouteClass routeClassBLL = new ClassLibrary.BLL.RouteClass();
DataTable myTable = routeClassBLL.GetData("parentid in (" + ids + ")", "parentid");
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in myTable.Rows)
{
sb.AppendFormat("<input name='ScenicCheckBox' onclick='LocationChange(this)' type='checkbox' value='{0}' />{1} ", dr["ID"].ToString(), dr["ClassName"].ToString());
}
/*if (sb.ToString() == "")
* {
* myTable = routeClassBLL.GetData("id in (" + ids + ")", "parentid");
* foreach (DataRow dr in myTable.Rows)
* {
* sb.AppendFormat("<input name='ScenicCheckBox' type='checkbox' value='{0}' />{1} ", dr["ID"].ToString(), dr["ClassName"].ToString());
* }
* }*/
Print(context, sb.ToString());
}
public void BindLinkClass()
{
ClassLibrary.BLL.RouteClass bll = new ClassLibrary.BLL.RouteClass();
DataTable myTable = bll.GetData(string.Empty);
myTable = ClassLibrary.BLL.WebClass.GetRouteTree(myTable, 0);
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in myTable.Rows)
{
sb.AppendFormat("<option value='{0}' {2}>{1}</option>", dr["ID"].ToString(), dr["ClassName"].ToString(), dr["ID"].ToString() == linkClass ? "selected" : "");
}
dataLinkClass = 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();
}