コード例 #1
0
ファイル: UserBlogs.aspx.cs プロジェクト: Berrywrq/SparkBlogs
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         //绑定用户文章列表
         //获取用户ID
         string    userId = Request.QueryString["userId"];
         DataTable dt     = new BlogManager().SelectByUser(userId);
         Repuserblogs.DataSource = dt;
         Repuserblogs.DataBind();
         //绑定用户信息
         dt = new UsersManager().SelectById(userId);
         Repuserinfo.DataSource = dt;
         Repuserinfo.DataBind();
         //绑定用户详情
         dt = new UsersManager().SelectDetailById(userId);
         Repuserdetail.DataSource = dt;
         Repuserdetail.DataBind();
         //绑定个人分类
         dt = new BlogManager().SelectPersonalCateByUser(userId);
         Reppersonalcate.DataSource = dt;
         Reppersonalcate.DataBind();
         //绑定阅读排行榜
         dt = new BlogManager().SelectTopByReadCount(userId);
         Reptopreadcount.DataSource = dt;
         Reptopreadcount.DataBind();
         //绑定评论排行榜
         dt = new BlogManager().SelectTopByCommentCount(userId);
         Reptopcommentcount.DataSource = dt;
         Reptopcommentcount.DataBind();
     }
 }
コード例 #2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         //获取用户ID和博客ID
         string    userId = Request.QueryString["userId"];
         string    blogId = Request.QueryString["blogId"];
         DataTable dt     = null;
         //绑定用户信息
         dt = new UsersManager().SelectById(userId);
         Repuserinfo.DataSource = dt;
         Repuserinfo.DataBind();
         //绑定用户详情
         dt = new UsersManager().SelectDetailById(userId);
         Repuserdetail.DataSource = dt;
         Repuserdetail.DataBind();
         //绑定个人分类
         dt = new BlogManager().SelectPersonalCateByUser(userId);
         Reppersonalcate.DataSource = dt;
         Reppersonalcate.DataBind();
         //绑定阅读排行榜
         dt = new BlogManager().SelectTopByReadCount(userId);
         Reptopreadcount.DataSource = dt;
         Reptopreadcount.DataBind();
         //绑定评论排行榜
         dt = new BlogManager().SelectTopByCommentCount(userId);
         Reptopcommentcount.DataSource = dt;
         Reptopcommentcount.DataBind();
         //绑定文章主体
         dt = new BlogManager().SelectById(blogId);
         Repblogdetail.DataSource = dt;
         Repblogdetail.DataBind();
         //绑定评论量
         //dt = new BlogManager().SelectCommentCountByBlog(blogId);
         //lblCommentCount.Text = dt.Rows[0]["comment_count"].ToString();
     }
 }