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"); } }
private void BindRelateArticles() { StringBuilder sb = new StringBuilder(); DataTable table = new DataTable(); string where = "isdisplay = 1"; if (news.IsSanxia) { table = newsBll.GetData(10, where + " and IsSanxia = 1", "ID desc "); } else { string where2 = " and CHARINDEX('," + routeClassId + ",',','+routeClassID+',') > 0 "; table = newsBll.GetData(10, where + where2, "ID desc "); if (table.Rows.Count < 10) { ClassLibrary.Model.RouteClass crc = gList.Find(delegate(ClassLibrary.Model.RouteClass rc) { return(rc.ID == routeClassId); }); if (crc.ClassLevel == 4) { DataTable table4 = newsBll.GetData(10, where + " and CHARINDEX('," + crc.ParentID + ",',','+routeClassID+',') > 0 ", "ID desc"); table.Merge(table4); table = table.AsDataView().ToTable(true); } } } if (table.Rows.Count < 10) { DataSet mySet2 = newsBll.GetPageData(10, 1, where, "ID desc "); DataTable table2 = mySet2.Tables["Data"]; table.Merge(table2); table = table.AsDataView().ToTable(true); } int i = 0; List <ClassLibrary.Model.News> raList = newsBll.GetModelList(table); foreach (ClassLibrary.Model.News model in raList) { i++; string preurl = Enum.GetName(typeof(SysConfig.NewsClassPY), model.newsClassID); sb.AppendFormat("<li><a href='{0}/{1}/{2}.html' title='{3}' target='_blank'>{4}</a><span>{5}</span></li>", SysConfig.webSite, preurl, model.ID, model.Title, Function.Clip(model.Title, 20, false), model.CreatedTime.ToString("yyyy-MM-dd")).AppendLine(); if (i >= 10) { break; } } relateArticleList = sb.ToString(); }
//列表 private void BindArticleList() { string where = "isdisplay = 1 and newsClassId = " + nid; DataSet mySet = newsBll.GetPageData(10, pageIndex, where, "ID desc"); DataTable tableCount = mySet.Tables["Count"]; DataTable myTable = mySet.Tables["Data"]; int countRows = 0; countRows = Convert.ToInt32(tableCount.Rows[0][0].ToString()); string currUrl = SysConfig.webSite + "/" + Enum.GetName(typeof(SysConfig.NewsClassPY), nid) + "/"; pageInfo = pg.pagination4(countRows, 10, pageIndex, currUrl); StringBuilder sb = new StringBuilder(); int i = 0; List <ClassLibrary.Model.News> newsList = newsBll.GetModelList(myTable); string preurl = Enum.GetName(typeof(SysConfig.NewsClassPY), nid); foreach (ClassLibrary.Model.News model in newsList) { i++; sb.AppendFormat("<li class='{0}'>", i == 10 ? "lastline" : "").AppendLine(); sb.AppendLine("<div class='dstn_gl_img'>"); string aimg = "/image/defaultImg.jpg"; if (model.Image != "") { aimg = SysConfig.UploadFilePathNewsImg + model.Image; } sb.AppendFormat("<a href='{0}/{4}/{1}.html' title='{2}' target='_blank' rel='nofollow'><img src='{3}' alt='' width='186' height='118' /></a>", SysConfig.webSite, model.ID, model.Title, aimg, preurl).AppendLine(); sb.AppendLine("</div>"); sb.AppendLine("<div class='dstn_gl_detail'>"); sb.AppendFormat("<div class='gl_detail_title'><a href='{0}/{4}/{1}.html' title='{2}' target='_blank'>{3}</a></div>", SysConfig.webSite, model.ID, model.Title, Function.Clip(model.Title, 30, false), preurl).AppendLine(); sb.AppendFormat("<div class='gl_detail_info'><div class='gl_detail_tag'>关键词:{0}</div><div class='gl_detail_time'>发表时间:{1}</div><div class='gl_detail_view'>{2}人浏览</div></div>", model.Ntag.Replace(",", " ").Replace(",", " "), model.CreatedTime.ToString("yyyy-MM-dd"), Convert.ToInt32(model.ViewCount)).AppendLine(); sb.AppendFormat("<div class='gl_detail_content'><p>{0}</p></div>", Function.Clip(Function.ClearHtml(model.Content), 150, true)).AppendLine(); sb.AppendLine("</div>"); sb.AppendLine("</li>"); } if (sb.Length == 0) { sb.Append("<div class='nodata'>没有相关数据!</div>"); } dataArticleList = sb.ToString(); }
private void BindArticles() { StringBuilder sb = new StringBuilder(); List <ClassLibrary.Model.News> newsList = newsBll.GetModelList(5, "isdisplay = 1"); foreach (ClassLibrary.Model.News model in newsList) { sb.AppendFormat("<li><a href='{0}/{1}/{2}.html'>{3}</a></li>", SysConfig.webSiteApp, Enum.GetName(typeof(SysConfig.NewsClassPY), model.newsClassID), model.ID, Function.Clip(model.Title, 14, true)); } dataArticleList = 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 setNewsImg(HttpContext context) { string ids = context.Request.QueryString["id"]; ClassLibrary.BLL.News newsBll = new ClassLibrary.BLL.News(); List <ClassLibrary.Model.News> newsList = newsBll.GetModelList("newsClassID in (" + ids + ") and charindex('<img',Content) > 0 and image = ''"); foreach (ClassLibrary.Model.News model in newsList) { string rule = "<img[^>]+?>"; Match match = Regex.Match(model.Content, rule); if (match.ToString() != "") { string imgurl = match.ToString(); imgurl = imgurl.Substring(imgurl.IndexOf("src=") + 5); imgurl = imgurl.Substring(0, imgurl.IndexOf("\"")); string fileFullPath = context.Server.MapPath(SysConfig.UploadFilePathNewsImg); string fileName = Function.GetRandomTime() + Path.GetExtension(imgurl); if (imgurl.IndexOf("file") != 1 && imgurl.IndexOf("ytszg.com") < 0) { continue; } if (imgurl.IndexOf("ytszg.com") >= 0) { imgurl = imgurl.Replace("http://www.qu17.com", "").Replace("www.qu17.com", ""); } imgurl = context.Server.MapPath(imgurl); if (File.Exists(imgurl)) { //缩图 Bitmap tmp = new Bitmap(imgurl); Bitmap bmp0 = Function.MakeThumNail(tmp, 300, 186); tmp.Dispose(); //bmp0.Save(fileFullPath + fileName); Function.SaveBitmapImg(bmp0, fileFullPath + fileName, ((long)80)); bmp0.Dispose(); newsBll.Updates("image='" + fileName + "'", "id = " + model.ID); } } } Print(context, "success"); }
public void loadArticleList(HttpContext context) { int typeid = Convert.ToInt32(context.Request.QueryString["typeid"]); int pageIndex = Convert.ToInt32(context.Request.QueryString["page"]); string strWhere = "isdisplay = 1"; if (typeid != 0) { strWhere += " and newsClassID=" + typeid; } ClassLibrary.BLL.News newsBll = new ClassLibrary.BLL.News(); ClassLibrary.BLL.RouteClass rcBll = new ClassLibrary.BLL.RouteClass(); List <ClassLibrary.Model.RouteClass> gList = new List <ClassLibrary.Model.RouteClass>(); DataSet mySet = newsBll.GetPageData(10, pageIndex, strWhere, "CreatedTime Desc"); DataTable myTable = mySet.Tables["Data"]; StringBuilder sb = new StringBuilder(); gList = rcBll.GetModelList(String.Empty, "ClassOrder Asc"); List <ClassLibrary.Model.News> tnewsList = newsBll.GetModelList(myTable); foreach (ClassLibrary.Model.News model in tnewsList) { string turl = Enum.GetName(typeof(SysConfig.NewsClassPY), model.newsClassID); sb.AppendLine("<div class='aricleitem'>"); sb.AppendFormat("<a href='{0}/{1}/{2}.html'>", SysConfig.webSiteApp, turl, model.ID); string aimg = "/image/defaultImg.jpg"; if (model.Image != "") { aimg = SysConfig.UploadFilePathNewsImg + model.Image; } sb.AppendFormat("<div class='ai_img'><img src='{0}{1}' alt='' /></div>", SysConfig.webSite, aimg); sb.AppendLine("<div class='ai_content'>"); sb.AppendFormat("<div class='ai_title'>{0}</div>", Function.Clip(model.Title, 13, true)); sb.AppendFormat("<div class='ai_desc'>{0}</div>", Function.Clip(Function.ClearHtml(model.Content), 27, true)); sb.AppendFormat("<div class='ai_ctime'>{0}</div>", model.CreatedTime.ToString("yyyy-MM-dd HH:mm")); sb.AppendLine("</div>"); sb.AppendLine("</a>"); sb.AppendLine("</div>"); } Print(context, sb.ToString()); }
//列表 private void BindArticleList() { string strWhere = "isdisplay = 1"; if (typeId != 0) { if (typeId == 5) { strWhere += " and newsClassID < " + typeId; } else { strWhere += " and newsClassID=" + typeId; } } //string urlMiddle = ""; //if (typeId == 0){ // urlMiddle = "zhinan"; //} //else if (typeId == (int)SysConfig.NewsClass.签证问题) //{ // urlMiddle = "visa/article"; //} //else //{ // urlMiddle = Enum.GetName(typeof(SysConfig.NewsClassPY), typeId); //} DataSet mySet = newsBll.GetPageData(10, pageIndex, strWhere, "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; } StringBuilder sb = new StringBuilder(); List <ClassLibrary.Model.News> tnewsList = newsBll.GetModelList(myTable); foreach (ClassLibrary.Model.News model in tnewsList) { string turl = Enum.GetName(typeof(SysConfig.NewsClassPY), model.newsClassID); sb.AppendLine("<div class='aricleitem'>"); sb.AppendFormat("<a href='{0}/{1}/{2}.html'>", SysConfig.webSiteApp, turl, model.ID); string aimg = "/image/defaultImg.jpg"; if (model.Image != "") { aimg = SysConfig.UploadFilePathNewsImg + model.Image; } sb.AppendFormat("<div class='ai_img'><img src='{0}{1}' alt='' /></div>", SysConfig.webSite, aimg); sb.AppendLine("<div class='ai_content'>"); sb.AppendFormat("<div class='ai_title'>{0}</div>", Function.Clip(model.Title, 13, true)); sb.AppendFormat("<div class='ai_desc'>{0}</div>", Function.Clip(Function.ClearHtml(model.Content), 27, true)); sb.AppendFormat("<div class='ai_ctime'>{0}</div>", model.CreatedTime.ToString("yyyy-MM-dd HH:mm")); sb.AppendLine("</div>"); sb.AppendLine("</a>"); sb.AppendLine("</div>"); } if (sb.Length == 0) { sb.Append("<div class='nodata'>没有相关数据!</div>"); } newsList = 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(); }