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.Article
{
    using MySite.Utils;
    using SubSonic;
    using SubSonic.Generated;
    using System.Linq;
    using System.Collections.Generic;
    public partial class List : System.Web.UI.UserControl
    {

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                this._GetRecordCount();
                this._BindDDL();
            }
        }
        private void _GetRecordCount() 
        {
            Category cate=new Category(this.DropDownList1.SelectedValue);
            if (cate.IsLoaded)
                this.AspNetPager1.RecordCount = cate.GetArticleCollection().Count;
            else
                this.AspNetPager1.RecordCount = 0;
        }
        private void _BindDDL()
        {
            //Query qry = Category.CreateQuery().WHERE("parentIds is null").OR(Category.Columns.ParentIds, "").SetSelectList("Name,PKId");
            DataTable dt=DB.Select("Name,PKId").From<Category>().Where(Category.Columns.ParentIds).IsNull().Or(Category.Columns.ParentIds).IsEqualTo("").ExecuteDataSet().Tables[0];
            this.DropDownList1.DataSource = dt;
                this.DropDownList1.DataTextField = "Name";
            this.DropDownList1.DataValueField = "PKId";
            this.DropDownList1.DataBind();
        }

        protected void btnAdd_Click(object sender, EventArgs e)
        {
            //this.Server.Transfer("add.aspx?categoryName="+this.DropDownList1.SelectedValue);
            this.Response.Redirect("add.aspx?categoryName=" + this.DropDownList1.SelectedItem.Text);
        }

        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            switch (e.CommandName.ToLower()) 
            {
                case "view":
                    this.Response.Redirect(ConfigurationManager.AppSettings["Path"]+"ArticleView.aspx?articleid="+e.CommandArgument.ToString());
                    break;
                case "edit":
                    this.Server.Transfer("add.aspx?id=" + e.CommandArgument.ToString());
                    break;
                case "del":
                    Article arti=new Article(e.CommandArgument);
                    if (arti.IsLoaded)
                    {
                        //删除已有标签集
                        //Article.DeleteTagMap(arti.PKId);
                        foreach (Tag t in arti.GetTagCollection())
                        {
                            if (t.UseTimes == 1)
                            {
                                DB.Delete().From<ArticleTagMapping>().Where(ArticleTagMapping.Columns.TagId).IsEqualTo(t.PKId).Execute();
                                Tag.Destroy(t.PKId);
                            }
                            else
                            {
                                t.UseTimes -= 1;
                                t.Save();
                                DB.Delete().From<ArticleTagMapping>().Where("ArticleId").IsEqualTo(arti.PKId).And("TagId").IsEqualTo(t.PKId).Execute();
                            }
                        }
                        //删除已有分类集
                        Article.DeleteCategoryMap(arti.PKId);
                        //删除评论
                        Comment.Destroy(Comment.Columns.FkArticleId, arti.PKId);
                        //删除文章
                        Article.Destroy(arti.PKId);
                        MessageBox.Show("删除成功");
                        WebSugar.UpdateImmediately();
                    }
                    else 
                    {
                        MessageBox.Show("非法参数，哥们想玩阴的啊~~");
                    }

                    break;
            }
        }

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

        protected void ObjectDataSource1_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
        {
            e.InputParameters["currentPageIndex"] = this.AspNetPager1.CurrentPageIndex;
            e.InputParameters["pageSize"] = this.AspNetPager1.PageSize;
        }

        protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType==ListItemType.AlternatingItem) 
            {
                Label lbl = e.Item.FindControl("lblCategoryNames") as Label;
                Label lbl2 = e.Item.FindControl("lblCommentNum") as Label;
                Article arti=new Article(DataBinder.Eval(e.Item.DataItem, "PKId"));
                CategoryCollection cateColl=arti.GetCategoryCollection();
                List<string> list = new List<string>();
                cateColl.ForEach(t => list.Add(t.Name));
                lbl.Text = string.Join(",", list.ToArray());
                lbl2.Text = arti.GetCommentCollection().Count.ToString();


            }
        }
    }
}