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(); }