listbydatedesc.ascx.cs

Maolz个人展示网站源码,全部的代码,.net

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

namespace MySite.WebUI.Controls.Comment
{
    using SubSonic;
    using SubSonic.Generated;
    using MySite.Utils;
    public partial class ListByDateDesc : System.Web.UI.UserControl
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack) 
            {
                this._BindDDL();
                this._GetRecordCount();
                this._DataBind();
            }
        }

        private void _BindDDL()
        {
            DataTable dt = DB.Select("Name,PKId").From<Category>().Where(Category.Columns.ParentIds).IsNull().Or(Category.Columns.ParentIds).IsEqualTo("").ExecuteDataSet().Tables[0];
            this.ddlCategoryNames.DataSource = dt;
            this.ddlCategoryNames.DataTextField = "Name";
            this.ddlCategoryNames.DataValueField = "PKId";
            this.ddlCategoryNames.DataBind();
        }

        private void _GetRecordCount()
        {
            Category cate = new Category(this.ddlCategoryNames.SelectedValue);
            if (cate.IsLoaded)
            {
                this.AspNetPager1.RecordCount=DB.Query().ExecuteScalar<int>(string.Format("select count(*) from comments where fk_articleid in (select ArticleId from ArticleCategoryMappings where categoryId={0})", cate.PKId));

            }
            else
            {
                this.AspNetPager1.RecordCount = DB.Query().ExecuteScalar<int>("select count(*) from Comments");
            }
        }

        private void _DataBind()
        {
            Category cate = new Category(this.ddlCategoryNames.SelectedValue);
            if (cate.IsLoaded)
            {
                //获取指定分类下的所有文章的评论集
                this.Repeater1.DataSource=DB.Query().ExecuteAsCollection<CommentCollection>(string.Format("select * from comments where fk_articleid in (select ArticleId from ArticleCategoryMappings where categoryId={0})", cate.PKId));
            }
            else
            {
                //Query qry = Comment.CreateQuery();
                //qry.OrderBy = OrderBy.Desc(Comment.Columns.PKId);
                //this.Repeater1.DataSource = qry.ExecuteDataSet().Tables[0];
                this.Repeater1.DataSource = DB.Query().ExecuteAsCollection<CommentCollection>("select * from comments order by PKId desc");
            }
            this.Repeater1.DataBind();
        }

        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            switch (e.CommandName)
            {
                case "view":
                    this.Response.Redirect(ConfigurationManager.AppSettings["Path"]+"ArticleView.aspx?articleid="+e.CommandArgument.ToString());
                    break;
                case "del":
                    Comment.Destroy(e.CommandArgument);
                    MessageBox.Show("评论删除成功");
                    WebSugar.UpdateImmediately();
                    break;
            
            }
        }

        protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
        {
            this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
            this._DataBind();
        }

        protected void ddlCategoryNames_SelectedIndexChanged(object sender, EventArgs e)
        {
            this._GetRecordCount();
            this._DataBind();
        }
    }
}