/// <summary>
/// 初始化菜单列表
/// </summary>
public void InitMenuList()
{
using (HelloWordEntities entity = new HelloWordEntities())
{
StringBuilder sb = new StringBuilder();
List<tbhw_Category> categoryList = entity.tbhw_Category.Where(m => m.category_parent_ky == 0 && m.category_state_code == 0).ToList();
for (int i = 0; i < categoryList.Count; i++)
{
sb.Append("<div class=\"menu_title\">" + categoryList[i].category_name + "</div>");
int category_ky = categoryList[i].category_ky;
List<tbhw_Category> childCategoryList = entity.tbhw_Category.Where(m => m.category_parent_ky == category_ky && m.category_state_code == 0).ToList();
for (int j = 0; j < childCategoryList.Count; j++)
{
if (j == 0)
{
if (i == 0)
{
sb.Append(" <div class=\"menu_content\">");
}
else
{
sb.Append(" <div class=\"menu_content\" style='display:none'>");
}
}
sb.Append(" <div style='text-align:left;padding-left:15px;'><a href=\"Category/" + Tools.Encrypt(childCategoryList[j].category_name) + "\">" + childCategoryList[j].category_name + "</a></div>");
if ((j + 1) == childCategoryList.Count)
{
sb.Append("</div>");
}
}
}
this.menuListHtml.InnerHtml = sb.ToString();
}
}
/// <summary>
/// 初始化文档排行榜
/// </summary>
public void InitDocument()
{
HelloWordEntities entity = new HelloWordEntities();
IQueryable<tbhw_Document> documentList = entity.tbhw_Document.Where(m => m.document_state_code == 0).OrderByDescending(m => m.document_down_count).Take(20);
this.repDocumentList.DataSource = documentList.ToList();
this.repDocumentList.DataBind();
}
/// <summary>
/// 初始化文章信息
/// </summary>
public void InitArticleList()
{
using (HelloWordEntities entity = new HelloWordEntities())
{
List<tbhw_Article> articleList = entity.tbhw_Article.Where(m => m.article_state_code == 0).OrderByDescending(m => m.article_add_time).Take(500).ToList();
this.AspNetPager1.RecordCount = articleList.Count();
this.repArticleList.DataSource = articleList.Where(m => m.article_state_code == 0).OrderByDescending(m => m.article_add_time).Skip((AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize).Take(AspNetPager1.PageSize);
this.repArticleList.DataBind();
}
}
/// <summary>
/// 获取用户头像
/// </summary>
/// <param name="user_ky"></param>
/// <returns></returns>
public string GetUserFace(object user_ky)
{
int user_ky_1 = Convert.ToInt16(user_ky);
using (HelloWordEntities entity = new HelloWordEntities())
{
tbhw_User user = entity.tbhw_User.Where(m => m.user_ky == user_ky_1).FirstOrDefault();
if (user == null)
{
return "<img src='/userzone/user_face/user_not_face.jpg' class='img-rounded' style='border: solid 1px #ccc; width: 60px; height: 60px'/>";
}
else if (user.user_face_img == null || user.user_face_img.Length == 0)
{
return "<a href='User/" + Tools.Encrypt(user_ky.ToString()) + "'><img src='/userzone/user_face/user_not_face.jpg' class='img-rounded' style='border: solid 1px #ccc; width: 60px; height: 60px'/></a>";
}
else
{
return " <a href='User/" + Tools.Encrypt(user_ky.ToString()) + "'><img src='" + user.user_face_img + "' class='img-rounded' style='border: solid 1px #ccc; width: 60px; height: 60px'/></a>";
}
}
}
/// <summary>
/// 初始化用户信息
/// </summary>
public void InitUser()
{
HelloWordEntities entity = new HelloWordEntities();
var r = (from a in entity.tbhw_User
join b in entity.tbhw_Article on a.user_ky equals b.article_user_ky
where a.user_state_code == 0 && b.article_state_code == 0
group new { a.user_ky, a.user_nick_name, b.article_user_ky, b.article_ky } by new { a.user_ky }
into result
select new
{
result.Key,
user_nick_name = result.Min(m => m.user_nick_name),
article_count = result.Count(m => m.article_ky > 0)
}
into Q
orderby Q.article_count descending
select Q).Take(50);
List<Temp_UserList> list = new List<Temp_UserList>();
foreach (var item in r)
{
list.Add(new Temp_UserList { user_ky = Tools.Encrypt(item.Key.ToString()), user_nick_name = item.user_nick_name, article_count = item.article_count.ToString() });
}
this.repUserList.DataSource = list;
this.repUserList.DataBind();
}
/// <summary>
/// 初始化统计信息
/// </summary>
public void InitStatistics()
{
HelloWordEntities entity = new HelloWordEntities();
int article_count = entity.tbhw_Article.Where(m => m.article_state_code == 0).Count();
int software_count = entity.tbhw_Software.Where(m => m.software_state_code == 0).Count();
this.spanArticleCount.InnerHtml = article_count.ToString();
this.spanSoftCount.InnerHtml = software_count.ToString();
}
/// <summary>
/// 初始化软件排行列表
/// </summary>
public void InitSoftware()
{
HelloWordEntities entity = new HelloWordEntities();
IQueryable<tbhw_Software> softwareList = entity.tbhw_Software.Where(m => m.software_state_code == 0).OrderByDescending(m => m.software_down_count).Take(20);
this.repSoftwareList.DataSource = softwareList.ToList();
repSoftwareList.DataBind();
}
/// <summary>
/// 初始化阅读排行文章信息
/// </summary>
public void InitOrderbyRead()
{
HelloWordEntities entity = new HelloWordEntities();
List<tbhw_Article> list = entity.tbhw_Article.Where(m => m.article_state_code == 0).OrderByDescending(m => m.article_view_count).Take(50).ToList();
this.repReadList.DataSource = list;
this.repReadList.DataBind();
}
