list.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 SubSonic.Sugar;
    public partial class List : System.Web.UI.UserControl
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            Response.Expires = 0;
            Response.Buffer = true;
            Response.ExpiresAbsolute = DateTime.Now.AddSeconds(-1);
            Response.AddHeader("pragma", "no-cache");
            Response.CacheControl = "no-cache";
            //ViewState["ArticleId"]=1;
            //if (!this.IsPostBack) 
            //{
                this.AspNetPager1.RecordCount = this._BuildQuery().GetRecordCount();
            //}
        }
        private Query _BuildQuery()
        {
            Query qry = new Query(Comment.Schema);
            qry.WHERE(Comment.Columns.FkArticleId, ViewState["ArticleId"]);
            return qry;
        }
        public int? ArticleId 
        {
            get { return new int?(Convert.ToInt32(ViewState["ArticleId"])); }
            set { ViewState["ArticleId"] = value; }
        }


        protected void ObjectDataSource1_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
        {
            e.Arguments.StartRowIndex = AspNetPager1.StartRecordIndex;
            e.Arguments.MaximumRows = AspNetPager1.PageSize;
            e.InputParameters["articleId"] = ViewState["ArticleId"];

        }

        protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
        {
            this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
            this.Repeater1.DataBind();
        }
        /// <summary>
        /// 获取该条评论在该文章中的楼层数
        /// </summary>
        /// <param name="pkid"></param>
        /// <returns></returns>
        protected string Floor(object pkid)
        {
            System.Data.IDataReader dr = this._BuildQuery().ExecuteReader();
            CommentCollection cc = new CommentCollection();
            cc.LoadAndCloseReader(dr);
            Comment comm=new Comment(pkid);
            return (cc.IndexOf(comm)+1).ToString();
        }
    }
}