/// <summary> /// 获取最新更新的书籍 Metro风格 /// </summary> /// <param name="top"></param> /// <returns></returns> public string getnoveltopmetroupdate(string top) { int i_top = top.ToInt32(); List <Book> bs = BookView.GetModelList("Enable=1 order by UpdateTime desc", i_top); StringBuilder sb = new StringBuilder(); int i = 1; foreach (Book b in bs) { Class c = BookView.GetClass(b); sb.AppendLine(string.Format("<li style=\" background-color:{0};\"><div class=\"item\"><h1><a href=\"{1}\">" + i + ".{2}</a></h1><div><div class=\"lastchapter\"><a href=\"{5}\">{6}</a></div></div></div><div class=\"item\"><h1><a href=\"{1}\">阅读书籍</a></h1><div><div class=\"lastchapter\"><a href=\"{5}\" title=\"{6}\">阅读最新章节</a></div><div class=\"class\">分类:<a href=\"{3}\">{4}</a></div><div class=\"author\">作者:{8}</div><div class=\"time\">更新时间:{9}</div></div></div></li>", BasePage.RandomBGColor(), BasePage.GetBookUrl(b, c), b.Title, BasePage.GetClassUrl(c), b.ClassName, BasePage.GetBookChapterUrl(BookChapterView.GetModelByID(b.LastChapterID.ToS()), c), b.LastChapterTitle, b.LastChapterTitle.CutString(12), b.Author, b.UpdateTime.ToString("MM-dd HH:mm") )); i++; } return(sb.ToS()); }
/// <summary> /// 获取小说列表 /// </summary> /// <param name="m_where"></param> /// <returns></returns> public static string getnovellist(string m_where, string Top, string CutTitle, string firstClass, string ShowClickCount) { StringBuilder sb = new StringBuilder(); var NovelList = BookView.GetModelList(m_where, Top.ToInt32()); foreach (var b in NovelList) { string str_cls = ""; if (firstClass.Length > 0 && b == NovelList.First()) { str_cls = " class=\"" + firstClass + "\""; } string str_clickcount = ""; if (ShowClickCount.ToBoolean()) { str_clickcount = string.Format("<span>{0}</span>", b.ClickCount); } sb.Append(string.Format("<li" + str_cls + "><a title=\"{0}\" href=\"{1}\">{2}</a>{3}</li>", b.Title, BasePage.GetBookUrl(b, BookView.GetClass(b)), b.Title.CutString(CutTitle.ToInt32(10)), str_clickcount)); } return(sb.ToS()); }
/// <summary> /// 获取最新更新的书籍 /// </summary> /// <param name="top"></param> /// <returns></returns> public string getnoveltopupdate(string top) { int i_top = top.ToInt32(); List <Book> bs = BookView.GetModelList("Enable=1 order by UpdateTime desc", i_top); StringBuilder sb = new StringBuilder(); //foreach (Book b in bs) for (int i = 0; i < bs.Count; i++) { Book b = bs[i]; Class c = BookView.GetClass(b); string str_style = ""; if (i % 2 == 0) { str_style = " style=\"background-color: #f5f5f5\""; } sb.AppendLine(string.Format("<tr" + str_style + "><td>[<a target=\"_blank\" href=\"{0}\" class=\"sort\">{1}</a>]</td><td><a class=\"name\" target=\"_blank\" href=\"{2}\">{3}</a> <a target=\"_blank\" href=\"{4}\" class=\"chapter\">{5}</a></td><td><a target=\"_blank\" href=\"/Search.aspx?m=4&key={6}\" class=\"author\">{6}</a></td><td style=\"color: #666666\">{7}</td></tr>", BasePage.GetClassUrl(c), b.ClassName, BasePage.GetBookUrl(b, c), b.Title, BasePage.GetBookChapterUrl(BookChapterView.GetModelByID(b.LastChapterID.ToS()), c), b.LastChapterTitle, b.Author, b.UpdateTime.ToString("MM-dd HH:mm") )); } return(sb.ToS()); }
public static string Getnovellist(string m_where, int Top, int CutTitle, string Model) { StringBuilder sb = new StringBuilder(); var NovelList = BookView.GetModelList(m_where, Top.ToInt32()); foreach (var b in NovelList) { string str = Model; str = str.Replace("{id}", b.ID.ToS()); str = str.Replace("{title}", b.Title.CutString(CutTitle)); str = str.Replace("{author}", b.Author); str = str.Replace("{classid}", b.ClassID.ToS()); str = str.Replace("{classname}", b.ClassName); str = str.Replace("{clickcount}", b.ClickCount.ToS()); str = str.Replace("{lastchapterid}", b.LastChapterID.ToS()); str = str.Replace("{lastchaptertitle}", b.LastChapterTitle); str = str.Replace("{tjcount}", b.TjCount.ToS()); str = str.Replace("{url}", BasePage.GetBookUrl(b, BookView.GetClass(b))); sb.Append(str); } return(sb.ToS()); }
protected void CreateTxt(int Bookid) { DataEntities ent = new DataEntities(); Book b = (from l in ent.Book where l.ID == Bookid select l).FirstOrDefault(); Class cls = b.GetClass(); var cs = (from l in ent.BookChapter where l.BookID == Bookid orderby l.ChapterIndex orderby l.ID select l).ToList(); ent.Dispose(); StringBuilder sb = new StringBuilder(); sb.AppendLine(string.Format("《{0}》\n 作者:{1} \n 更多精彩小说,请访问{2}\n\n\n\n\n", b.Title, b.Author, BasePage.SystemSetting.SiteName)); foreach (var c in cs) { sb.AppendLine(c.Title); sb.AppendLine(Voodoo.IO.File.Read(Server.MapPath(BasePage.GetBookChapterTxtUrl(c, cls)), Voodoo.IO.File.EnCode.UTF8).TrimHTML()); } HttpContext.Current.Response.ContentType = "application/text"; HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}.txt", b.Title)); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.BinaryWrite(sb.ToS().ToByteArray(Encoding.UTF8)); HttpContext.Current.Response.End(); }
/// <summary> /// 通过关键词读取新闻 /// </summary> /// <param name="count"></param> /// <param name="TitleLength"></param> /// <param name="showTime"></param> /// <param name="key"></param> /// <param name="Order"></param> /// <returns></returns> public string getnewsbykeywords(string count, string TitleLength, string showTime, string key, string Order) { string str_sql = ""; str_sql += "("; string[] keys = Regex.Replace(key, "\\s+", ",").Split(','); foreach (string k in keys) { str_sql += " keywords like '%" + k + "%' or "; } str_sql += " 1=2)"; List <News> nlist = NewsView.GetModelList(str_sql + " " + Order, count.ToInt32()); StringBuilder sb = new StringBuilder(); foreach (News n in nlist) { string title = n.Title; if (TitleLength.ToInt32() > 0) { title = title.CutString(TitleLength.ToInt32()); } string timespan = ""; if (showTime.ToInt32() > 0) { timespan = string.Format("<span class=\"news_time_span\">{0}</span>", n.NewsTime.ToString("yyyy/MM/dd")); } sb.AppendLine(string.Format("<li>{0}{1}<a href='{2}' title='{3}'>{4}</a></li>", "", timespan, BasePage.GetNewsUrl(n, NewsView.GetNewsClass(n)), n.Title, title)); } return(sb.ToS()); }
/// <summary> /// 获取演员列表 /// </summary> /// <param name="top"></param> /// <param name="m_where"></param> /// <param name="templatestring"></param> /// <returns></returns> public static string getactorlist(string cutstring, string m_where, string top, string templatestring) { StringBuilder sb = new StringBuilder(); var movies = MovieInfoView.GetModelList(m_where); List <string> results = new List <string>(); var actors = movies.GroupBy(p => p.Actors).OrderByDescending(p => p.Count()).Take(top.ToInt32(10)); foreach (var actor in actors) { string[] acts = actor.Key.Split('/', ':', ','); foreach (string str in acts) { results.Add(str); } } //分组处理最终结果 var al_result = results.GroupBy(p => p.ToString()).OrderByDescending(p => p.Count()); foreach (var str in al_result) { string tmp = templatestring; tmp = tmp.Replace("{name}", str.Key.ToS()); tmp = tmp.Replace("{fname}", str.Key.ToS().CutString(cutstring.ToInt32(100))); sb.AppendLine(tmp); } return(sb.ToS()); }
protected void Page_Load(object sender, EventArgs e) { try { string chapters = ""; if (Voodoo.Cookies.Cookies.GetCookie("history") != null) { chapters = Voodoo.Cookies.Cookies.GetCookie("history").Value; } string[] cs = chapters.Split(','); List <Cook> cookie = new List <Cook>(); string ids = ""; foreach (string chapter in cs) { string[] Arr_chapter = chapter.Split('|'); cookie.Add(new Cook() { id = Arr_chapter[0].ToInt64(), time = Arr_chapter[1].ToDateTime() }); ids += Arr_chapter[0] + ","; } ids = ids.TrimEnd(','); List <BookChapter> list_chapter = BookChapterView.GetModelList(string.Format("id in({0})", ids)); StringBuilder sb = new StringBuilder(); sb.Append("document.write('"); foreach (BookChapter bc in list_chapter) { Book b = BookView.GetModelByID(bc.BookID.ToString()); Class c = ClassView.GetModelByID(bc.ClassID.ToString()); BookChapter new_Chapter = BookChapterView.GetModelByID(b.LastChapterID.ToString()); sb.Append(string.Format("<a href=\"{0}\">{1}</a>(<a href=\"{2}\">{3}</a>) 最新:<a href=\"{4}\">{5}</a><br />", BasePage.GetBookUrl(b, c), bc.BookTitle, BasePage.GetBookChapterUrl(bc, c), bc.Title, BasePage.GetBookChapterUrl(new_Chapter, c), b.LastChapterTitle )); } sb.Append("');"); Response.Clear(); Response.Write(sb.ToS()); }// end try catch { Voodoo.Cookies.Cookies.Remove("history"); } }
/// <summary> /// 获取小说栏目列表 /// </summary> /// <param name="str"></param> /// <returns></returns> public string getallnovelclass(string str) { List <Class> cls = ClassView.GetModelList("ModelID=4"); StringBuilder sb = new StringBuilder(); foreach (Class c in cls) { sb.Append(string.Format("<a href=\"{0}\">{1}</a> ", BasePage.GetClassUrl(c), c.ClassName)); } return(sb.ToS()); }
/// <summary> /// 获取所有子栏目 /// </summary> /// <param name="ClassID"></param> /// <returns></returns> protected string GetAllSubClass(int ClassID) { var cls = ClassView.GetModelList(string.Format("ParentID={0}", ClassID)); StringBuilder sb = new StringBuilder(); foreach (var c in cls) { sb.Append(c.ID + ","); } sb.Append(ClassID); return(sb.ToS()); }
/// <summary> /// 获取系统搜索关键词 /// </summary> /// <param name="Top"></param> /// <returns></returns> public static string getsearchkey(string Top, string ModelID) { StringBuilder sb = new StringBuilder(); var list = SysKeywordView.GetModelList(string.Format("ModelID={0} order by ClickCount desc", ModelID), Top.ToInt32(10)); foreach (var item in list) { sb.Append(string.Format("<a href=\"/Search.aspx?m={1}&key={0}\">{0}</a> ", item.Keyword, ModelID)); } return(sb.ToS()); }
/// <summary> /// 对字符串进行MD5加密 /// </summary> /// <param name="str"></param> /// <returns></returns> public static string ToMD5(this string str) { MD5 md5 = new MD5CryptoServiceProvider(); byte[] data = Encoding.UTF8.GetBytes(str); byte[] md5data = md5.ComputeHash(data); md5.Clear(); StringBuilder sBuilder = new StringBuilder(); for (int i = 0; i < md5data.Length; i++) { sBuilder.Append(md5data[i].ToString("X2")); } return sBuilder.ToS(); }
protected void LoadInfo() { StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { var qs = from l in ent.Province select l; foreach (var q in qs) { sb.AppendLine(q.province1); } } txt_Provinces.Text = sb.ToS(); }
/// <summary> /// 提交章节内容到目标站点 /// </summary> /// <param name="b"></param> public void SubmitBook(BookAndChapter b) { Setting s = Book.RulesOperate.GetSetting(); foreach (Chapter c in b.Chapters) { CollectStatus.ChapterTitle = c.Title; CollectStatus.Status = "正在提交"; BookChapter chapter_Submited; Status_Chage(); StringBuilder sb = new StringBuilder(); sb.Append(string.Format("书籍{0}的章节:{1}正在处理中,请稍后访问阅读,或者百度搜索“{0}{1}”查找本章节。阅读{0}最新章节,尽在<a href={2}>{2}</a>。", b.BookTitle, c.Title, s.TargetUrl)); if (c.Content.IsNullOrEmpty() || c.Content.Trim().IsNullOrEmpty()) { this.CollectStatus.Status = "这张没有采集到"; Status_Chage(); chapter_Submited = BH.ChapterAdd(b.ID, c.Title, sb.ToS(), true, true); //生成章节页面 this.CollectStatus.Status = "生成章节"; Status_Chage(); BH.CreateChapters(chapter_Submited.ID); continue; } chapter_Submited = BH.ChapterAdd(b.ID, c.Title, c.Content, c.IsImageChapter); if (chapter_Submited.ID < 0) { this.CollectStatus.Status = "章节保存失败"; Status_Chage(); Thread.Sleep(2000); } else { //保存成功 ,更新章节地址 c.Url = b.Url + chapter_Submited.ID + ".htm"; b.Changed = true; } //生成章节页面 this.CollectStatus.Status = "生成章节"; Status_Chage(); BH.CreateChapters(chapter_Submited.ID); } BookNeedCollect = b; }
/// <summary> /// 书籍列表 /// </summary> /// <param name="top"></param> /// <param name="custitle"></param> /// <param name="m_where"></param> /// <param name="orderby"></param> /// <param name="htmlTemp"></param> /// <returns></returns> public static string booklist(string top, string custitle, string m_where, string orderby, string htmlTemp) { StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { var list = ent.CreateQuery<Book>(string.Format("select VALUE t from Book as t where {0} order by {1} limit {2}",m_where,orderby,top)); var i = 0; foreach (var q in list) { i++; string item = htmlTemp; item = item.Replace("{addtime}", q.Addtime.ToDateTime().ToString("yyyy-MM-dd")); item=item.Replace("{author}",q.Author); item=item.Replace("{classid}",q.ClassID.ToS()); item=item.Replace("{classname}",q.ClassName); item=item.Replace("{clickcount}",q.ClickCount.ToS()); item=item.Replace("{corpusid}",q.CorpusID.ToS()); item=item.Replace("{corpustitle}",q.CorpusTitle); item=item.Replace("{enable}",q.Enable.ToBoolean().ToChinese()); item=item.Replace("{faceimage}",q.FaceImage); item=item.Replace("{id}",q.ID.ToS()); item=item.Replace("{intro}",q.Intro); item=item.Replace("{isfirstpost}",q.IsFirstPost.ToBoolean().ToChinese()); item=item.Replace("{isvip}",q.IsVip.ToBoolean().ToChinese()); item=item.Replace("{lastchapterid}",q.LastChapterID.ToS()); item=item.Replace("{lastchaptertitle}",q.LastChapterTitle); item=item.Replace("{lastvipchapterid}",q.LastVipChapterID.ToS()); item=item.Replace("{lastvipchaptertitle}",q.LastVipChapterTitle); item=item.Replace("{length}",q.Length.ToS()); item=item.Replace("{replycount}",q.ReplyCount.ToS()); item=item.Replace("{savecount}",q.SaveCount.ToS()); item=item.Replace("{status}",q.Status==0?"连载中":"已完结"); item=item.Replace("{title}",q.Title); item=item.Replace("{tjcount}",q.TjCount.ToS()); item=item.Replace("{updatetime}",q.UpdateTime.ToDateTime().ToString("yyyy-MM-dd")); item=item.Replace("{vipupdatetime}",q.VipUpdateTime.ToDateTime().ToString("yyyy-MM-dd")); item=item.Replace("{ztid}",q.ZtID.ToS()); item=item.Replace("{ztname}",q.ZtName); item=item.Replace("{title}",q.Title); item=item.Replace("{url}",BasePage.GetBookUrl(q,q.GetClass())); item = item.Replace("{ftitle}", custitle.ToInt32() > 0 ? q.Title.CutString(custitle.ToInt32()) : q.Title); item = item.Replace("{index}", (i - 1).ToS()); item = item.Replace("{rownum}", (i).ToS()); sb.Append(item); } } return sb.ToS(); }
/// <summary> /// 对字符串进行MD5加密 /// </summary> /// <param name="str"></param> /// <returns></returns> public static string ToMD5(this string str) { MD5 md5 = new MD5CryptoServiceProvider(); byte[] data = Encoding.UTF8.GetBytes(str); byte[] md5data = md5.ComputeHash(data); md5.Clear(); StringBuilder sBuilder = new StringBuilder(); for (int i = 0; i < md5data.Length; i++) { sBuilder.Append(md5data[i].ToString("X2")); } return(sBuilder.ToS()); }
/// <summary> /// 获取员工数量选择项 /// </summary> /// <param name="value"></param> /// <returns></returns> public string GetEmplyeeCountItems(int?value) { StringBuilder sb = new StringBuilder(); employeeCount = null; newUrl(); sb.AppendFormat("<option value=\"{0}\" {1}>不限规模</option>", curUrl, value == null ? "selected='selected'" : ""); foreach (var item in JobAction.EmployeeCount) { employeeCount = item.Key; newUrl(); sb.AppendFormat("<option value=\"{0}\" {1}>{2}</option>", curUrl, item.Key == value ? "selected='selected'" : "", item.Value); } return(sb.ToS()); }
public static string Getsearchkey(string m_where, int Top, string Model) { StringBuilder sb = new StringBuilder(); var list = SysKeywordView.GetModelList(m_where, Top); foreach (var item in list) { string str = Model; str = str.Replace("{clickcount}", item.ClickCount.ToS()); str = str.Replace("{id}", item.Id.ToS()); str = str.Replace("{keyword}", item.Keyword); sb.Append(str); } return(sb.ToS()); }
/// <summary> /// 获取章节正文 /// </summary> /// <param name="r"></param> /// <param name="html"></param> /// <returns></returns> public string GetChapterContent(BookRule r, string html) { StringBuilder sb = new StringBuilder(); var regexResult = (ChapterContent)SetMatchResult(typeof(ChapterContent), html, r.ContentRule).FirstOrDefault(); sb.Append(regexResult.content); if (r.NextContentRule.IsNullOrEmpty() == false && html.GetMatchGroup(r.NextContentRule).Groups.Count > 0) { string nextHtml = Url.GetHtml(html.GetMatch(r.NextContentRule).FirstOrDefault().AppendToDomain(RootUrl)); sb.Append(GetChapterContent(r, nextHtml)); } return(sb.ToS()); }
protected string GetUserGroupString() { List <UserGroup> gs = UserGroupView.GetModelList(); gs = gs.Where(p => p.EnableReg).ToList(); StringBuilder sb = new StringBuilder(); sb.Append("<tr>"); foreach (var g in gs) { sb.AppendLine("<td style='color:#000;width:100px'><input type=\"radio\" name=\"group\" id=\"" + g.ID + "\" value=\"" + g.ID + "\" /><label for=\"" + g.ID + "\">" + g.GroupName + "</label></td>"); } sb.Append("</tr>"); return(sb.ToS()); }
protected void ddl_Province_SelectedIndexChanged(object sender, EventArgs e) { int selectID = ddl_Province.SelectedValue.ToInt32(); StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { var qs = from l in ent.City where l.ProvinceID == selectID select l; foreach (var q in qs) { sb.AppendLine(q.city1); } } txt_Provinces.Text = sb.ToS(); }
protected string GetUserGroupString() { DataEntities ent = new DataEntities(); List<UserGroup> gs = (from l in ent.UserGroup select l).ToList(); ent.Dispose(); gs = gs.Where(p => p.EnableReg==true).ToList(); StringBuilder sb = new StringBuilder(); sb.Append("<tr>"); foreach (var g in gs) { sb.AppendLine("<td style='color:#000;width:100px'><input type=\"radio\" name=\"group\" id=\"" + g.ID + "\" value=\"" + g.ID + "\" /><label for=\"" + g.ID + "\">" + g.GroupName + "</label></td>"); } sb.Append("</tr>"); return sb.ToS(); }
/// <summary> /// 绑定行业选项 /// </summary> protected void BindIndustry() { using (DataEntities ent = new DataEntities()) { StringBuilder sb = new StringBuilder(); var qs = (from l in ent.JobIndustry where l.ParentID == 0 select l).AsCache("parent0"); foreach (var q in qs) { industry = q.ID; newUrl(); sb.AppendFormat("<a href=\"{0}\" class={1}>{2}</a> ", curUrl, q.ID == WS.RequestNullInt32("i") ? "select" : "", q.Name); } str_Industry = sb.ToS(); LoadSearchPars(); } }
/// <summary> /// 获取小说分类新闻 /// </summary> /// <param name="ClassID">分类ID</param> /// <param name="Top">所取条数</param> /// <returns></returns> public static string getclassnews(string ClassID, string Top) { List <Book> qs = BookView.GetModelList(string.Format("ClassID in(select id from Class where ID={0} union select id from Class where ParentID={0}) order by clickcount desc", ClassID), Top.ToInt32(12)); StringBuilder sb = new StringBuilder(); for (int i = 0; i < qs.Count; i++) { if (i == 0) { sb.AppendLine(string.Format("<ul class=\"picList\"><li><a href=\"{0}\" title=\"{1}\" class=\"ablum\"><img src=\"{3}\" alt=\"{1}\" width=\"120\" height=\"160\" /></a><div class=\"text\"><h2 class=\"h22\"><a href=\"{0}\" title=\"{1}\" target=\"_blank\">《{1}》</a></h2><p>{2}</p></div></li>", BasePage.GetBookUrl(qs[i], BookView.GetClass(qs[i])), qs[i].Title, qs[i].Intro.CutString(150), qs[i].FaceImage.IsNull("/Book/Bookface/0.jpg") )); } else if (i == 1) { sb.AppendLine(string.Format("<li><a href=\"{0}\" title=\"{1}\" class=\"ablum\"><img src=\"{3}\" alt=\"{1}\" width=\"120\" height=\"160\" /></a><div class=\"text\"><h2 class=\"h22\"><a href=\"{0}\" title=\"{1}\" target=\"_blank\">《{1}》</a></h2><p>{2}</p></div></li></ul>", BasePage.GetBookUrl(qs[i], BookView.GetClass(qs[i])), qs[i].Title, qs[i].Intro.CutString(150), qs[i].FaceImage.IsNull("/Book/Bookface/0.jpg") )); } else if (i == 2) { sb.AppendLine(string.Format("<ul class=\"newsList\"><li><a target=\"_blank\" title=\"{1}\" href=\"{0}\">{1}:{2}</a></li>", BasePage.GetBookUrl(qs[i], BookView.GetClass(qs[i])), qs[i].Title, qs[i].Intro.CutString(25) )); } else { sb.AppendLine(string.Format("<li><a target=\"_blank\" title=\"{1}\" href=\"{0}\">{1}:{2}</a></li>", BasePage.GetBookUrl(qs[i], BookView.GetClass(qs[i])), qs[i].Title, qs[i].Intro.CutString(25) )); } }//end for sb.AppendLine("</ul>"); return(sb.ToS()); }
/// <summary> /// Load Book Info /// </summary> protected void LoadInfo() { #region 数据绑定 var classes = NewsAction.NewsClass.Where(p => p.ModelID == 4 && p.IsLeafClass == true); ddl_CLass.DataSource = classes; ddl_CLass.DataTextField = "ClassName"; ddl_CLass.DataValueField = "id"; ddl_CLass.DataBind(); if (cls > 0) { ddl_CLass.SelectedValue = cls.ToS(); } var book = BookView.GetModelByID(id.ToS()); if (book.ID > 0) { txt_Title.Text = book.Title; txt_Author.Text = book.Author; ddl_Status.SelectedValue = book.Status.ToS(); txt_Intro.Text = book.Intro; txt_Length.Text = book.Length.ToS(); txt_ClickCount.Text = book.ClickCount.ToS(); txt_SaveCount.Text = book.SaveCount.ToS(); txt_Replycount.Text = book.ReplyCount.ToS(); txt_TjCount.Text = book.TjCount.ToS(); chk_IsVip.Checked = book.IsVip; chk_IsFirstpost.Checked = book.IsFirstPost; chk_Enable.Checked = book.Enable; img_Bookface.ImageUrl = book.FaceImage; List <BookRole> roles = BookRoleView.GetModelList(string.Format("BookID={0}", book.ID.ToS())); StringBuilder sb = new StringBuilder(); foreach (var role in roles) { sb.AppendLine(role.RoleName); } txt_BookRole.Text = sb.ToS(); } #endregion }
/// <summary> /// DataTable转换为XML /// </summary> /// <param name="dt">要进行转换的DataTable</param> /// <returns>返回XML源文件</returns> public static string DataTableToXML(DataTable dt) { StringBuilder sb = new StringBuilder(); sb.Append("<" + dt.TableName + ">"); foreach (DataRow row in dt.Rows) { sb.Append("<item>"); for (int i = 0; i < dt.Columns.Count; i++) { sb.Append("<" + dt.Columns[i].ColumnName + ">" + row[i].ToString() + "</" + dt.Columns[i].ColumnName + ">"); } sb.Append("</item>"); } sb.Append("</" + dt.TableName + ">"); return(sb.ToS()); }
/// <summary> /// 获取年代列表 /// </summary> /// <param name="m_where"></param> /// <param name="top"></param> /// <param name="templatestring"></param> /// <returns></returns> public static string getyearlist(string cutstring, string m_where, string top, string templatestring) { StringBuilder sb = new StringBuilder(); var movies = MovieInfoView.GetModelList(m_where); var years = movies.GroupBy(p => p.PublicYear).OrderByDescending(p => p.Count()).Take(top.ToInt32(10)); foreach (var year in years) { string tmp = templatestring; tmp = tmp.Replace("{name}", year.Key.Replace(":", "")); tmp = tmp.Replace("{fname}", year.Key.Replace(":", "").CutString(cutstring.ToInt32(100))); sb.AppendLine(tmp); } return(sb.ToS()); }
protected void MovieClickCount(int id) { StringBuilder sb = new StringBuilder(); string now = DateTime.UtcNow.AddHours(8).ToString("yyyy-MM-dd HH:mm:ss"); string yesterday = DateTime.UtcNow.AddHours(8).AddDays(-1).ToString("yyyy-MM-dd 23:59:59"); string lastweek = DateTime.UtcNow.AddHours(8).LastWeekLastDay().ToString("yyyy-MM-dd 23:59:59"); string lastMonth = DateTime.UtcNow.AddHours(8).LastMonthLastDay().ToString("yyyy-MM-dd 23:59:59"); sb.AppendLine(string.Format("update MovieInfo set DayClick=0 where LastClickTime<='{0}'", yesterday)); sb.AppendLine(string.Format("update MovieInfo set WeekClick=0 where LastClickTime<='{0}'", lastweek)); sb.AppendLine(string.Format("update MovieInfo set MonthClick=0 where LastClickTime<='{0}'", lastMonth)); sb.AppendLine(string.Format("update MovieInfo set LastClickTime='{0}'", now)); sb.AppendLine(string.Format("update MovieInfo set ClickCount=ClickCount+1,MonthClick=MonthClick+1,WeekClick=WeekClick+1,DayClick=DayClick+1,LastClickTime='{0}' where id={1}", now, id )); DataBase.GetHelper().ExecuteNonQuery(CommandType.Text, sb.ToS()); }
protected string GetUserGroupString() { DataEntities ent = new DataEntities(); List <UserGroup> gs = (from l in ent.UserGroup select l).ToList(); ent.Dispose(); gs = gs.Where(p => p.EnableReg == true).ToList(); StringBuilder sb = new StringBuilder(); sb.Append("<tr>"); foreach (var g in gs) { sb.AppendLine("<td style='color:#000;width:100px'><input type=\"radio\" name=\"group\" id=\"" + g.ID + "\" value=\"" + g.ID + "\" /><label for=\"" + g.ID + "\">" + g.GroupName + "</label></td>"); } sb.Append("</tr>"); return(sb.ToS()); }
public static string GetPostEdu(this JobPost post) { StringBuilder sb = new StringBuilder(); try { var list = (List <JobPostEduAndEmployeeCount>)Voodoo.IO.XML.DeSerialize(typeof(List <JobPostEduAndEmployeeCount>), post.Ext1); foreach (var j in list.Where(p => p.Checked == true)) { sb.AppendFormat("{0}/", j.Text); } sb = sb.TrimEnd('/'); } catch { sb.Append("未知"); } return(sb.ToS()); }
/// <summary> /// 获取经验下拉列表 /// </summary> /// <param name="value"></param> /// <returns></returns> public string GetExpItems(int?value) { Dictionary <int, string> dic = new Dictionary <int, string>(); dic.Add(0, "实习"); dic.Add(1, "应届"); StringBuilder sb = new StringBuilder(); exp = null; newUrl(); sb.AppendFormat("<option value=\"{0}\" {1}>{2}</option>", curUrl, WS.RequestNullInt32("ex") == null ? "selected='selected'" : "", "工作性质"); foreach (var item in dic) { exp = item.Key; newUrl(); sb.AppendFormat("<option value=\"{0}\" {1}>{2}</option>", curUrl, item.Key == value ? "selected='selected'" : "", item.Value); } return(sb.ToS()); }
protected void CreateTxt(int Bookid) { Book b = BookView.GetModelByID(Bookid.ToS()); Class cls = BookView.GetClass(b); var cs = BookChapterView.GetModelList(string.Format("bookid={0} order by ChapterIndex,id", b.ID)); StringBuilder sb = new StringBuilder(); foreach (var c in cs) { sb.AppendLine(c.Title); sb.AppendLine(Voodoo.IO.File.Read(Server.MapPath(BasePage.GetBookChapterTxtUrl(c, cls)), Voodoo.IO.File.EnCode.UTF8).TrimHTML()); } HttpContext.Current.Response.ContentType = "application/text"; HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}.txt", b.Title)); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.BinaryWrite(sb.ToS().ToByteArray(Encoding.UTF8)); HttpContext.Current.Response.End(); }
/// <summary> /// 绑定ENUM项 /// </summary> /// <param name="val"></param> /// <param name="value"></param> /// <returns></returns> private string bindItems(Dictionary <int, string> val, int?value, string parName) { StringBuilder sb = new StringBuilder(); page = 1; foreach (var item in val) { switch (parName) { case "s": salary = item.Key; break; case "t": updatetime = item.Key; break; case "e": edu = item.Key; break; case "i": industry = item.Key; break; case "p": province = item.Key; break; case "c": city = item.Key; break; } newUrl(); sb.AppendFormat("<a href=\"{0}\" class={1}>{2}</a> ", curUrl, item.Key == value ? "select" : "", item.Value); } LoadSearchPars(); return(sb.ToS()); }
/// <summary> /// 获取JOB系统 首页右侧的城市列表 /// </summary> /// <param name="linkTemp"></param> /// <returns></returns> public static string GetIndexCitys(string linkTemp) { StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { var cts = (from l in ent.City orderby l.Hot descending select l).AsCache().Take(5); int i = 0; foreach (var ct in cts) { if (i % 5 == 0) { sb.AppendLine("<tr><td><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"22\"><tr>"); } i++; string tmp = linkTemp.Replace("{city1}", ct.city1).Replace("市", ""); tmp = tmp.Replace("{id}", ct.id.ToS()); string item = string.Format("<td width=\"16%\" align=\"center\">{0}</td>", tmp); sb.AppendLine(item); if (i == cts.Count()) { for (int j = 0; j < cts.Count() % 5; j++) { sb.AppendLine("<td width=\"16%\" align=\"center\"> </td>"); } sb.AppendLine("</tr></table></td></tr>"); } if (i % 5 == 0) { sb.AppendLine("</tr></table></td></tr>"); } } } return sb.ToS(); }
/// <summary> /// 获取广告列表 /// </summary> /// <param name="top"></param> /// <param name="custitle"></param> /// <param name="m_where"></param> /// <param name="orderby"></param> /// <param name="htmlTemp"></param> /// <returns></returns> public string getadlist(string top, string custitle, string m_where, string orderby, string htmlTemp) { StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { var ads = ent.CreateQuery<Ad>(string.Format("select VALUE t from Ad as t where {1} order by {2} limit {0}", top, m_where, orderby)).ToList(); var i = 0; foreach (var q in ads) { i++; string item = htmlTemp; item = item.Replace("{id}", q.ID.ToS()); item = item.Replace("{title}", q.Title); item = item.Replace("{groupid}", q.GroupID.ToS()); item = item.Replace("{image}", q.Image); item = item.Replace("{url}", q.Url); item = item.Replace("{rownum}", i.ToS()); item = item.Replace("{index}", (i - 1).ToS()); sb.Append(item); } } return sb.ToS(); }
/// <summary> /// 获取职位列表 /// </summary> /// <param name="top"></param> /// <param name="custitle"></param> /// <param name="m_where"></param> /// <param name="orderby"></param> /// <param name="htmlTemp"></param> /// <returns></returns> public static string getpostlistkip(string skip, string top, string custitle, string m_where, string orderby, string htmlTemp) { StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { List<JobPost> list = ent.CreateQuery<JobPost>(string.Format("select VALUE t from JobPost as t where {0} order by {1} skip {2} limit {3}", m_where, orderby, skip, top)).ToList(); List<JobCompany> coms = (from l in ent.JobCompany select l).ToList(); var i = 0; foreach (var q in list) { i++; var com = coms.Where(p => p.ID == q.CompanyID).FirstOrDefault(); string item = htmlTemp; item = item.Replace("{city}", JobAction.GetCityName(q.City.ToInt32())); item = item.Replace("{companyid}", q.CompanyID.ToS()); item = item.Replace("{companyname}", com.CompanyName); item = item.Replace("{employeecount}", JobAction.GetEmployeeCountName(com.EmployeeCount.ToInt32())); item = item.Replace("{edu}", JobAction.GetEduName(q.Edu.ToInt32())); item = item.Replace("{employeenumber}", q.EmployNumber == 0 ? "若干" : q.EmployNumber.ToS()); item = item.Replace("{expressions}", JobAction.GetExpressionsName(q.Expressions.ToInt32())); item = item.Replace("{id}", q.ID.ToS()); item = item.Replace("{intro}", q.Intro); item = item.Replace("{posttime}", q.PostTime.ToDateTime().ToString("yyyy-MM-dd")); item = item.Replace("{province}", JobAction.GetProviceName(q.Province.ToInt32())); item = item.Replace("{salary}", JobAction.GetSalaryDegreeName(q.Salary.ToInt32())); item = item.Replace("{title}", q.Title); item = item.Replace("{ftitle}", custitle.ToInt32() > 0 ? q.Title.CutString(custitle.ToInt32()) : q.Title); item = item.Replace("{ext1}", q.GetPostEduAndNumber()); item = item.Replace("{postedu}", q.GetPostEdu()); item = item.Replace("{index}", (i - 1).ToS()); sb.Append(item); } return sb.ToS(); } }
/// <summary> /// 获取地区列表 /// </summary> /// <param name="m_where"></param> /// <param name="top"></param> /// <param name="templatestring"></param> /// <returns></returns> public static string getlocationlist(string cutstring, string m_where, string top, string templatestring) { StringBuilder sb = new StringBuilder(); DataEntities ent = new DataEntities(); var movies = //MovieInfoView.GetModelList(m_where); ent.CreateQuery<MovieInfo>(string.Format("select * from MovieInfo where {0}", m_where)).ToList(); ent.Dispose(); var locations = movies.GroupBy(p => p.Location).OrderByDescending(p => p.Count()).Take(top.ToInt32(10)); foreach (var location in locations) { string tmp = templatestring; tmp = tmp.Replace("{name}", location.Key.Replace(":", "")); tmp = tmp.Replace("{fname}", location.Key.Replace(":", "").CutString(cutstring.ToInt32(100))); sb.AppendLine(tmp); } return sb.ToS(); }
public static string getnovellist(string m_where,string Order, string Top, string CutTitle, string firstClass, string ShowClickCount) { DataEntities ent = new DataEntities(); StringBuilder sb = new StringBuilder(); var NovelList = //BookView.GetModelList(m_where, Top.ToInt32()); ent.CreateQuery<Book>(string.Format("select VALUE t from Book as t where {1} order by {2} take {0}", Top, m_where,Order)).ToList(); ent.Dispose(); foreach (var b in NovelList) { string str_cls = ""; if (firstClass.Length > 0 && b == NovelList.First()) { str_cls = " class=\"" + firstClass + "\""; } string str_clickcount = ""; if (ShowClickCount.ToBoolean()) { str_clickcount = string.Format("<span>{0}</span>", b.ClickCount); } sb.Append(string.Format("<li" + str_cls + "><a title=\"{0}\" href=\"{1}\">{2}</a>{3}</li>", b.Title, BasePage.GetBookUrl(b, b.GetClass()), b.Title.CutString(CutTitle.ToInt32(10)), str_clickcount)); } return sb.ToS(); }
/// <summary> /// 获取演员列表 /// </summary> /// <param name="top"></param> /// <param name="m_where"></param> /// <param name="templatestring"></param> /// <returns></returns> public static string getactorlist(string cutstring, string m_where, string top, string templatestring) { StringBuilder sb = new StringBuilder(); DataEntities ent = new DataEntities(); var movies = //MovieInfoView.GetModelList(m_where); ent.CreateQuery<MovieInfo>(string.Format("select * from MovieInfo where {0}", m_where)).ToList(); ent.Dispose(); List<string> results = new List<string>(); var actors = movies.GroupBy(p => p.Actors).OrderByDescending(p => p.Count()).Take(top.ToInt32(10)); foreach (var actor in actors) { string[] acts = actor.Key.Split('/', ':', ','); foreach (string str in acts) { results.Add(str); } } //分组处理最终结果 var al_result = results.GroupBy(p => p.ToString()).OrderByDescending(p => p.Count()); foreach (var str in al_result) { string tmp = templatestring; tmp = tmp.Replace("{name}", str.Key.ToS()); tmp = tmp.Replace("{fname}", str.Key.ToS().CutString(cutstring.ToInt32(100))); sb.AppendLine(tmp); } return sb.ToS(); }
/// <summary> /// 获取行业列表 /// </summary> /// <param name="top"></param> /// <param name="custitle"></param> /// <param name="m_where"></param> /// <param name="orderby"></param> /// <param name="htmlTemp"></param> /// <returns></returns> public static string getindustrylist(string top, string custitle, string m_where, string orderby, string htmlTemp) { StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { List<JobIndustry> list = ent.CreateQuery<JobIndustry>(string.Format("select VALUE t from JobIndustry as t where {1} order by {2} limit {0}", top, m_where, orderby)).ToList(); var i = 0; foreach (var q in list) { i++; string item = htmlTemp; item = item.Replace("{id}", q.ID.ToS()); item = item.Replace("{name}", q.Name); item = item.Replace("{parentid}", q.ParentID.ToS()); item = item.Replace("{isleaf}", q.IsLeaf.ToS()); item = item.Replace("{index}", (i - 1).ToS()); sb.Append(item); } return sb.ToS(); } }
/// <summary> /// 获取最新更新的书籍 /// </summary> /// <param name="top"></param> /// <returns></returns> public string getnoveltopupdate(string top) { DataEntities ent = new DataEntities(); int i_top = top.ToInt32(); List<Book> bs = (from l in ent.Book where l.Enable == true && l.LastChapterID>0 orderby l.UpdateTime descending select l).Take(i_top).ToList(); StringBuilder sb = new StringBuilder(); //foreach (Book b in bs) for (int i = 0; i < bs.Count; i++) { Book b = bs[i]; Class c = b.GetClass(); string str_style = ""; if (i % 2 == 0) { str_style = " style=\"background-color: #f5f5f5\""; } sb.AppendLine(string.Format("<tr" + str_style + "><td>[<a target=\"_blank\" href=\"{0}\" class=\"sort\">{1}</a>]</td><td><a class=\"name\" target=\"_blank\" href=\"{2}\">{3}</a> <a target=\"_blank\" href=\"{4}\" class=\"chapter\">{5}</a></td><td><a target=\"_blank\" href=\"/Search.aspx?m=4&key={6}\" class=\"author\">{6}</a></td><td style=\"color: #666666\">{7}</td></tr>", BasePage.GetClassUrl(c), b.ClassName, BasePage.GetBookUrl(b, c), b.Title, BasePage.GetBookChapterUrl(ObjectExtents.Chapter(b.LastChapterID), c), b.LastChapterTitle, b.Author, b.UpdateTime.ToDateTime().ToString("MM-dd HH:mm") )); } ent.Dispose(); return sb.ToS(); }
/// <summary> /// 获取所有子栏目 /// </summary> /// <param name="ClassID"></param> /// <returns></returns> protected string GetAllSubClass(int ClassID) { var cls = ClassAction.Classes.Where(p => p.ParentID == ClassID); StringBuilder sb = new StringBuilder(); foreach (var c in cls) { sb.Append(c.ID + ","); } sb.Append(ClassID); return sb.ToS(); }
/// <summary> /// 获取最新更新的书籍 Metro风格 /// </summary> /// <param name="top"></param> /// <returns></returns> public string getnoveltopmetroupdate(string top) { DataEntities ent = new DataEntities(); int i_top = top.ToInt32(); List<Book> bs = //BookView.GetModelList("Enable=1 order by UpdateTime desc", i_top); (from l in ent.Book where l.Enable == true orderby l.UpdateTime descending select l).Take(i_top).ToList(); StringBuilder sb = new StringBuilder(); int i = 1; foreach (Book b in bs) { Class c = b.GetClass(); sb.AppendLine(string.Format("<li style=\" background-color:{0};\"><div class=\"item\"><h1><a href=\"{1}\">" + i + ".{2}</a></h1><div><div class=\"lastchapter\"><a href=\"{5}\">{6}</a></div></div></div><div class=\"item\"><h1><a href=\"{1}\">阅读书籍</a></h1><div><div class=\"lastchapter\"><a href=\"{5}\" title=\"{6}\">阅读最新章节</a></div><div class=\"class\">分类:<a href=\"{3}\">{4}</a></div><div class=\"author\">作者:{8}</div><div class=\"time\">更新时间:{9}</div></div></div></li>", BasePage.RandomBGColor(), BasePage.GetBookUrl(b, c), b.Title, BasePage.GetClassUrl(c), b.ClassName, BasePage.GetBookChapterUrl(ObjectExtents.Chapter(b.LastChapterID), c), b.LastChapterTitle, b.LastChapterTitle.CutString(12), b.Author, b.UpdateTime.ToDateTime().ToString("MM-dd HH:mm") )); i++; } ent.Dispose(); return sb.ToS(); }
/// <summary> /// 通过关键词读取新闻 /// </summary> /// <param name="count"></param> /// <param name="TitleLength"></param> /// <param name="showTime"></param> /// <param name="key"></param> /// <param name="Order"></param> /// <returns></returns> public string getnewsbykeywords(string count, string TitleLength, string showTime, string key, string Order) { DataEntities ent = new DataEntities(); string str_sql = ""; str_sql += "("; string[] keys = Regex.Replace(key, "\\s+", ",").Split(','); foreach (string k in keys) { str_sql += " t.keywords like '%" + k + "%' or "; } str_sql += " 1=2)"; List<News> nlist = ent.CreateQuery<News>(string.Format("select VALUE t from News as t where {1} {2} order by t.id desc take {0}", count, str_sql, Order)).ToList(); StringBuilder sb = new StringBuilder(); foreach (News n in nlist) { string title = n.Title; if (TitleLength.ToInt32() > 0) { title = title.CutString(TitleLength.ToInt32()); } string timespan = ""; if (showTime.ToInt32() > 0) { timespan = string.Format("<span class=\"news_time_span\">{0}</span>", n.NewsTime.ToDateTime().ToString("yyyy/MM/dd")); } sb.AppendLine(string.Format("<li>{0}{1}<a href='{2}' title='{3}'>{4}</a></li>", "", timespan, BasePage.GetNewsUrl(n, n.GetClass()), n.Title, title)); } ent.Dispose(); return sb.ToS(); }
/// <summary> /// 获取小说栏目列表 /// </summary> /// <param name="str"></param> /// <returns></returns> public string getallnovelclass(string str) { List<Class> cls = ClassAction.Classes.Where(p => p.ModelID == 4).ToList(); StringBuilder sb = new StringBuilder(); foreach (Class c in cls) { sb.Append(string.Format("<a href=\"{0}\">{1}</a> ", BasePage.GetClassUrl(c), c.ClassName)); } return sb.ToS(); }
/// <summary> /// 获取JOB系统 首页下面的行业列表 /// </summary> /// <returns></returns> public static string GetIndexIndustrys(string nn) { StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { var qs = (from l in ent.JobIndustry where l.IsLeaf == false select l).AsCache(); var parents = qs.Where(p => p.ParentID == 0); foreach (var p in parents) { sb.Append("<li>"); sb.Append(string.Format("<b>{0}</b>:", p.Name)); var subs = qs.Where(o => o.ParentID == p.ID); foreach (var s in subs) { sb.AppendFormat("<a target=\"_blank\" href=\"{0}\">{1}</a>", s.ID, s.Name); } sb.Append("</li>"); } } return sb.ToS(); }
/// <summary> /// 根据类别获取书籍排行 /// </summary> /// <param name="top"></param> /// <param name="custitle"></param> /// <param name="cls"></param> /// <param name="htmlTemp"></param> /// <returns></returns> public static string gettopbookbyclass(string top,string custitle, string cls, string htmlTemp) { int i_top = top.ToInt32(); int cid = cls.ToInt32(); StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { var list = (from l in ent.Book from c in ent.Class where (l.ClassID == cid && c.ID == cid) || (l.ClassID == c.ID && c.ParentID == cid) orderby l.ClickCount descending select l).Take(i_top); if (cid < 0) { list = (from l in ent.Book orderby l.ClickCount descending select l).Take(i_top); } var i = 0; foreach (var q in list) { i++; string item = htmlTemp; item = item.Replace("{addtime}", q.Addtime.ToDateTime().ToString("yyyy-MM-dd")); item = item.Replace("{author}", q.Author); item = item.Replace("{classid}", q.ClassID.ToS()); item = item.Replace("{classname}", q.ClassName); item = item.Replace("{clickcount}", q.ClickCount.ToS()); item = item.Replace("{corpusid}", q.CorpusID.ToS()); item = item.Replace("{corpustitle}", q.CorpusTitle); item = item.Replace("{enable}", q.Enable.ToBoolean().ToChinese()); item = item.Replace("{faceimage}", q.FaceImage); item = item.Replace("{id}", q.ID.ToS()); item = item.Replace("{intro}", q.Intro); item = item.Replace("{isfirstpost}", q.IsFirstPost.ToBoolean().ToChinese()); item = item.Replace("{isvip}", q.IsVip.ToBoolean().ToChinese()); item = item.Replace("{lastchapterid}", q.LastChapterID.ToS()); item = item.Replace("{lastchaptertitle}", q.LastChapterTitle); item = item.Replace("{lastvipchapterid}", q.LastVipChapterID.ToS()); item = item.Replace("{lastvipchaptertitle}", q.LastVipChapterTitle); item = item.Replace("{length}", q.Length.ToS()); item = item.Replace("{replycount}", q.ReplyCount.ToS()); item = item.Replace("{savecount}", q.SaveCount.ToS()); item = item.Replace("{status}", q.Status == 0 ? "连载中" : "已完结"); item = item.Replace("{title}", q.Title); item = item.Replace("{tjcount}", q.TjCount.ToS()); item = item.Replace("{updatetime}", q.UpdateTime.ToDateTime().ToString("yyyy-MM-dd")); item = item.Replace("{vipupdatetime}", q.VipUpdateTime.ToDateTime().ToString("yyyy-MM-dd")); item = item.Replace("{ztid}", q.ZtID.ToS()); item = item.Replace("{ztname}", q.ZtName); item = item.Replace("{title}", q.Title); item = item.Replace("{url}", BasePage.GetBookUrl(q, q.GetClass())); item = item.Replace("{ftitle}", custitle.ToInt32() > 0 ? q.Title.CutString(custitle.ToInt32()) : q.Title); item = item.Replace("{index}", (i - 1).ToS()); item = item.Replace("{rownum}", (i).ToS()); sb.Append(item); } return sb.ToS(); } }
/// <summary> /// 获取首页专业树 /// </summary> /// <param name="s"></param> /// <returns></returns> public static string getindexSpelist(string s) { StringBuilder sb = new StringBuilder(); DataEntities ent = new DataEntities(); var list = (from l in ent.JobEduSpecialty select l).AsCache(); var parents = from l in list from t in list where l.ParentID == t.ID && t.ParentID == 0 select l; foreach (var p in parents) { sb.AppendFormat("<li><b>{0}</b>:", p.Name); var subs = from l in list where l.ParentID == p.ID select l; foreach (var sub in subs) { sb.AppendFormat("<a target=\"_blank\" href=\"Search.aspx?sp={0}\">{1}</a>", sub.ID, sub.Name); } sb.Append("</li>"); } return sb.ToS(); ent.Dispose(); }
/// <summary> /// 获取城市列表 /// </summary> /// <param name="top"></param> /// <param name="custitle"></param> /// <param name="m_where"></param> /// <param name="orderby"></param> /// <param name="htmlTemp"></param> /// <returns></returns> public static string getcitylist(string top, string custitle, string m_where, string orderby, string htmlTemp) { StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { var ads = ent.CreateQuery<City>(string.Format("select VALUE t from City as t where {1} order by {2} limit {0}", top, m_where, orderby)).ToList(); var i = 0; foreach (var q in ads) { i++; string item = htmlTemp; item = item.Replace("{id}", q.id.ToS()); item = item.Replace("{hot}", q.Hot.ToS()); item = item.Replace("{city1}", q.city1); item = item.Replace("{rownum}", i.ToS()); item = item.Replace("{index}", (i - 1).ToS()); sb.Append(item); } } return sb.ToS(); }
/// <summary> /// 职位申请列表 /// </summary> /// <param name="top"></param> /// <param name="custitle"></param> /// <param name="m_where"></param> /// <param name="htmlTemp"></param> /// <returns></returns> public static string getjobapplicationlist(string top, string custitle, string m_where, string orderby, string htmlTemp) { StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { List<JobApplicationRecord> list = ent.CreateQuery<JobApplicationRecord>(string.Format("select VALUE t from JobApplicationRecord as t where {1} order by {2} limit {0}", top, m_where, orderby)).ToList(); var qs = from a in list from c in ent.JobCompany from u in ent.User from r in ent.JobResumeInfo from p in ent.JobPost where a.UserID == u.ID && a.ResumeID == r.ID && a.PostID == p.ID && a.CompanyID == c.ID select new { a.ID, u.UserName, c.CompanyName, p.Title, rTitle = r.Title, a.ApplicationTime, a.CompanyID, a.PostID, a.ResumeID, a.UserID }; var i = 0; foreach (var q in qs) { i++; string item = htmlTemp; item = item.Replace("{applicationtime}", q.ApplicationTime.ToDateTime().ToString("yyyy-MM-dd")); item = item.Replace("{companyid}", q.CompanyID.ToS()); item = item.Replace("{companyname}", q.CompanyName); item = item.Replace("{id}", q.ID.ToS()); item = item.Replace("{postid}", q.PostID.ToS()); item = item.Replace("{resumeid}", q.ResumeID.ToS()); item = item.Replace("{rtitle}", q.rTitle); item = item.Replace("{title}", q.Title); item = item.Replace("{userid}", q.UserID.ToS()); item = item.Replace("{username}", q.UserName); item = item.Replace("{index}", (i - 1).ToS()); sb.Append(item); } return sb.ToS(); } }
/// <summary> /// 获取类别列表 /// </summary> /// <param name="top">获取的条数</param> /// <param name="custitle">标题截取长度</param> /// <param name="m_where">条件语句</param> /// <param name="htmlTemp">模板</param> /// <returns></returns> public static string getclasslist(string top, string custitle, string m_where, string htmlTemp) { StringBuilder sb = new StringBuilder(); DataEntities ent = new DataEntities(); List<Class> cls = ent.CreateQuery<Class>(string.Format("select VALUE t from Class as t where {1} order by t.id desc limit {0}", top, m_where)).ToList(); ent.Dispose(); foreach (Class c in cls) { string item = htmlTemp; item = item.Replace("{url}", BasePage.GetClassUrl(c)); item = item.Replace("{alter}", c.Alter); item = item.Replace("{classdescription}", c.ClassDescription); item = item.Replace("{classfolder}", c.ClassForder); item = item.Replace("{classicon}", c.ClassICON); item = item.Replace("{classkeywords}", c.ClassKeywords); item = item.Replace("{classname}", c.ClassName); item = item.Replace("{fclassname}", c.ClassName.CutString(custitle.ToInt32(10))); item = item.Replace("{classpageextname}", c.ClassPageExtName); item = item.Replace("{id}", c.ID.ToS()); sb.Append(item); } return sb.ToS(); }
/// <summary> /// 获取电影列表 /// </summary> /// <param name="top">条数</param> /// <param name="custitle">标题截取</param> /// <param name="m_where">条件语句</param> /// <param name="htmlTemp">模板</param> /// <returns></returns> public static string getmovielist(string top, string custitle, string m_where, string htmlTemp) { StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { List<MovieInfo> movies = ent.CreateQuery<MovieInfo>(string.Format("select top {0} * from MovieInfo where {1}", top, m_where)).ToList(); var i = 0; foreach (MovieInfo m in movies) { i++; string item = htmlTemp; item = item.Replace("{url}", BasePage.GetMovieUrl(m, m.GetClass())); item = item.Replace("{id}", m.id.ToS()); item = item.Replace("{authors}", m.Actors); item = item.Replace("{classid}", m.ClassID.ToS()); item = item.Replace("{classname}", m.ClassName); item = item.Replace("{director}", m.Director); item = item.Replace("{faceimage}", m.FaceImage); item = item.Replace("{inserttime}", m.InsertTime.ToDateTime().ToString("yyyy-MM-dd")); item = item.Replace("{intro}", m.Intro); item = item.Replace("{ismovie}", m.IsMove == true ? "电影" : "电视剧"); item = item.Replace("{lastdramatitle}", m.LastDramaTitle); item = item.Replace("{location}", m.Location); item = item.Replace("{publicyear}", m.PublicYear); item = item.Replace("{status}", m.Status == 0 ? "更新中" : "完结"); item = item.Replace("{tags}", m.Tags); item = item.Replace("{title}", m.Title); item = item.Replace("{ftitle}", m.Title.CutString(custitle.ToInt32())); item = item.Replace("{updatetime}", m.UpdateTime.ToDateTime().ToString("yyyy-MM-dd")); item = item.Replace("{clickcount}", m.ClickCount.ToS()); item = item.Replace("{replycount}", m.ReplyCount.ToS()); item = item.Replace("{scoreavg}", m.ScoreAvg.ToS()); item = item.Replace("{rownum}", i.ToS()); item = item.Replace("{index}", (i - 1).ToS()); sb.Append(item); } } return sb.ToS(); }
/// <summary> /// 获取小说分类新闻 /// </summary> /// <param name="ClassID">分类ID</param> /// <param name="Top">所取条数</param> /// <returns></returns> public static string getclassnews(string ClassID, string Top) { DataEntities ent = new DataEntities(); int int_cls = ClassID.ToInt32(); List<Book> qs = (from l in ent.Book from cp in ent.Class from cl in ent.Class where cp.ID == int_cls && cl.ParentID == cp.ID && (l.ClassID == cp.ID || l.ClassID == cl.ID) select l ).Take(Top.ToInt32()).ToList(); ent.Dispose(); StringBuilder sb = new StringBuilder(); for (int i = 0; i < qs.Count; i++) { if (i == 0) { sb.AppendLine(string.Format("<ul class=\"picList\"><li><a href=\"{0}\" title=\"{1}\" class=\"ablum\"><img src=\"{3}\" alt=\"{1}\" width=\"120\" height=\"160\" /></a><div class=\"text\"><h2 class=\"h22\"><a href=\"{0}\" title=\"{1}\" target=\"_blank\">《{1}》</a></h2><p>{2}</p></div></li>", BasePage.GetBookUrl(qs[i], qs[i].GetClass()), qs[i].Title, qs[i].Intro.TrimHTML().CutString(150), qs[i].FaceImage.IsNull("/Book/Bookface/0.jpg") )); } else if (i == 1) { sb.AppendLine(string.Format("<li><a href=\"{0}\" title=\"{1}\" class=\"ablum\"><img src=\"{3}\" alt=\"{1}\" width=\"120\" height=\"160\" /></a><div class=\"text\"><h2 class=\"h22\"><a href=\"{0}\" title=\"{1}\" target=\"_blank\">《{1}》</a></h2><p>{2}</p></div></li></ul>", BasePage.GetBookUrl(qs[i], qs[i].GetClass()), qs[i].Title, qs[i].Intro.TrimHTML().CutString(150), qs[i].FaceImage.IsNull("/Book/Bookface/0.jpg") )); } else if (i == 2) { sb.AppendLine(string.Format("<ul class=\"newsList\"><li><a target=\"_blank\" title=\"{1}\" href=\"{0}\">{1}:{2}</a></li>", BasePage.GetBookUrl(qs[i], qs[i].GetClass()), qs[i].Title, qs[i].Intro.TrimHTML().CutString(25) )); } else { sb.AppendLine(string.Format("<li><a target=\"_blank\" title=\"{1}\" href=\"{0}\">{1}:{2}</a></li>", BasePage.GetBookUrl(qs[i], qs[i].GetClass()), qs[i].Title, qs[i].Intro.TrimHTML().CutString(25) )); } }//end for sb.AppendLine("</ul>"); return sb.ToS(); }
public static string Getsearchkey(string m_where, int Top, string Model) { StringBuilder sb = new StringBuilder(); DataEntities ent = new DataEntities(); var list = ent.CreateQuery<SysKeyword>(string.Format("select VALUE t from SysKeyword as t where {1} order by t.ClickCount desc limit {0}", Top, m_where)).ToList(); ent.Dispose(); foreach (var item in list) { string str = Model; str = str.Replace("{clickcount}", item.ClickCount.ToS()); str = str.Replace("{id}", item.ID.ToS()); str = str.Replace("{keyword}", item.Keyword); sb.Append(str); } return sb.ToS(); }
/// <summary> /// 获取公司列表 /// </summary> /// <param name="top"></param> /// <param name="custitle"></param> /// <param name="m_where"></param> /// <param name="orderby"></param> /// <param name="htmlTemp"></param> /// <returns></returns> public static string getcompanylist(string top, string custitle, string m_where, string orderby, string htmlTemp) { StringBuilder sb = new StringBuilder(); using (DataEntities ent = new DataEntities()) { List<JobCompany> list = ent.CreateQuery<JobCompany>(string.Format("select VALUE t from JobCompany as t where {1} order by {2} limit {0}", top, m_where, orderby)).ToList(); var i = 0; foreach (var q in list) { i++; string item = htmlTemp; item = item.Replace("{companyname}", custitle.ToInt32() > 0 ? q.CompanyName.CutString(custitle.ToInt32()) : q.CompanyName); item = item.Replace("{fcompanyname}", q.CompanyName); item = item.Replace("{companytype}", JobAction.GetCompanyTypeName(q.CompanyType.ToInt32())); item = item.Replace("{employeecount}", JobAction.GetEmployeeCountName(q.EmployeeCount.ToInt32())); item = item.Replace("{id}", q.ID.ToS()); item = item.Replace("{Industry}", JobAction.GetIndustryName(q.Industry.ToInt32())); item = item.Replace("{intro}", q.Intro); item = item.Replace("{userid}", q.UserID.ToS()); item = item.Replace("{dayclick}", q.DayClick.ToS()); item = item.Replace("{rownum}", i.ToS()); item = item.Replace("{index}", (i - 1).ToS()); sb.Append(item); } return sb.ToS(); } }
public static string Getnovellist(string m_where, int Top, int CutTitle, string Model) { StringBuilder sb = new StringBuilder(); DataEntities ent = new DataEntities(); var NovelList = ent.CreateQuery<Book>(string.Format("select VALUE t from Book as t where {1} order by t.id desc take {0}", Top, m_where)).ToList(); ent.Dispose(); foreach (var b in NovelList) { string str = Model; str = str.Replace("{id}", b.ID.ToS()); str = str.Replace("{title}", b.Title.CutString(CutTitle)); str = str.Replace("{author}", b.Author); str = str.Replace("{classid}", b.ClassID.ToS()); str = str.Replace("{classname}", b.ClassName); str = str.Replace("{clickcount}", b.ClickCount.ToS()); str = str.Replace("{lastchapterid}", b.LastChapterID.ToS()); str = str.Replace("{lastchaptertitle}", b.LastChapterTitle); str = str.Replace("{tjcount}", b.TjCount.ToS()); str = str.Replace("{url}", BasePage.GetBookUrl(b, b.GetClass())); sb.Append(str); } return sb.ToS(); }
/// <summary> /// 首页底部地区树 /// </summary> /// <param name="ss"></param> /// <returns></returns> public static string getindexbottomareas(string ss) { StringBuilder sb = new StringBuilder(); DataEntities ent = new DataEntities(); var areas = (from l in ent.Area where l.ShowInIndex == true select l).ToList(); var ps = (from l in ent.Province where l.ShowInIndex == true select l).ToList(); var cs = (from l in ent.City where l.ShowInIndex == true select l).ToList(); ent.Dispose(); foreach (var area in areas) { sb.AppendLine("<li>"); sb.AppendFormat("<span class=\"fl\"><b>{0}:</b></span>", area.Name); var subps = from l in ps where l.AreaID == area.ID select l; foreach (var subp in subps) { sb.AppendFormat("<a href=\"Search.aspx?l={0}\" target=\"_blank\">{0}</a>", subp.province1); var subcs = from l in cs where l.ProvinceID == subp.ID select l; if (subcs.Count() > 0) { sb.Append("("); } foreach (var subc in subcs) { sb.AppendFormat("<a href=\"Search.aspx?l={0}\" target=\"_blank\">{0}</a>", subc.city1); } if (subcs.Count() > 0) { sb.Append(")"); } } sb.AppendLine("</li>"); } return sb.ToS(); }
/// <summary> /// 获取系统搜索关键词 /// </summary> /// <param name="Top"></param> /// <returns></returns> public static string getsearchkey(string Top, string ModelID) { StringBuilder sb = new StringBuilder(); DataEntities ent = new DataEntities(); var list = //SysKeywordView.GetModelList(string.Format("ModelID={0} order by ClickCount desc", ModelID), Top.ToInt32(10)); ent.CreateQuery<SysKeyword>(string.Format("select VALUE t from SysKeyword as t where t.ModelID={1} order by t.ClickCount desc limit {0}", Top, ModelID)).AsCache(); ent.Dispose(); foreach (var item in list) { sb.Append(string.Format("<a href=\"/Book/Search/?key={0}\">{0}</a> ", item.Keyword, ModelID)); } return sb.ToS(); }
/// <summary> /// 新闻列表 /// </summary> /// <param name="ClassID">栏目ID</param> /// <param name="TitlePreChar">标题前字符</param> /// <param name="count">索取条数</param> /// <param name="TitleLength">标题保留长度</param> /// <param name="ExtSql">额外的Sql条件</param> /// <param name="Order">排序语句</param> /// <returns></returns> public string cmsnewslist(string ClassID, string TitlePreChar, string count, string TitleLength, string showTime, string ExtSql, string Order) { Class cls = NewsAction.NewsClass.Where(p => p.ID.ToString() == ClassID).First(); DataEntities ent = new DataEntities(); if (cls.ModelID == 1) { string str_sql = string.Format("t.classID in ({0})", GetAllSubClass(ClassID.ToInt32())); if (ExtSql.Length > 1) { str_sql += " and " + ExtSql; } str_sql += Order; List<News> nlist = ent.CreateQuery<News>(string.Format("select Value t from News as t where {1} Order by t.id desc take {0}", count, str_sql)).ToList(); StringBuilder sb = new StringBuilder(); foreach (News n in nlist) { string title = n.Title; if (TitleLength.ToInt32() > 0) { title = title.CutString(TitleLength.ToInt32()); } string timespan = ""; if (showTime.ToInt32() > 0) { timespan = string.Format("<span class=\"news_time_span\">{0}</span>", n.NewsTime.ToDateTime().ToString("yyyy/MM/dd")); } sb.AppendLine(string.Format("<li>{0}{1}<a href='{2}' title='{3}'>{4}</a></li>", TitlePreChar, timespan, BasePage.GetNewsUrl(n, n.GetClass()), n.Title, title)); } return sb.ToS(); }//Model=1 新闻 else if (cls.ModelID == 2) { return "图"; } else if (cls.ModelID == 3)//问答 { string str_sql = string.Format("t.classID in ({0})", GetAllSubClass(ClassID.ToInt32())); if (ExtSql.Length > 1) { str_sql += " and " + ExtSql; } str_sql += Order; List<Question> qlist = ent.CreateQuery<Question>(string.Format("select VALUE t from Question as t where {1} orderby t.id desc take {0}", count, str_sql)).ToList(); StringBuilder sb = new StringBuilder(); foreach (Question q in qlist) { string title = q.Title; if (TitleLength.ToInt32() > 0) { title = title.CutString(TitleLength.ToInt32()); } string timespan = ""; if (showTime.ToInt32() > 0) { timespan = string.Format("<span class=\"news_time_span\">{0}</span>", q.AskTime.ToDateTime().ToString("yyyy/MM/dd")); } sb.AppendLine(string.Format("<li>{0}{1}<a href='{2}' title='{3}'>{4}</a></li>", TitlePreChar, timespan, BasePage.GetQuestionUrl(q, q.GetClass()), q.Title, title)); } return sb.ToS(); } else { return "未知模型"; } }