当前文件路径：DaDaEnterprise/Admin/Admin_Works.aspx.cs

		            
 1using System;
 2using System.Collections;
 3using System.Configuration;
 4using System.Data;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.HtmlControls;
 9using System.Web.UI.WebControls;
10using System.Web.UI.WebControls.WebParts;
11
12public partial class Admin_Admin_Works : System.Web.UI.Page
13...{
14    protected void Page_Load(object sender, EventArgs e)
15    ...{
16        DataAccess.IsAdmin();
17        if (!IsPostBack)
18        ...{
19            this.labPage.Text = "1";
20            this.contrlRepeater();
21            string sql = "select count(*) from [Works]";
22            Count.Text = DataAccess.CountCmd(sql).ToString();
23        }
24    }
25
26    protected void Del_Click(Object sender,CommandEventArgs e)
27    ...{
28        string id = e.CommandName;
29        string sql = "delete * from [Works] where id=" + id;
30        if (DataAccess.ExecuteCmd(sql) > 0)
31        ...{
32            Response.Redirect("./Admin_Works.aspx");
33        }
34        else Response.Write("<script>alert('删除失败!');</script>");
35    }
36
37    public void contrlRepeater()
38    ...{
39        string sql = "select * from [Works] order by id desc";
40        DataSet Ds = DataAccess.GetDataSet(sql);
41
42        //使用PagedDataSource来实现分页
43        PagedDataSource pds = new PagedDataSource();
44        pds.DataSource = Ds.Tables[0].DefaultView;
45        pds.AllowPaging = true;
46        pds.PageSize = 17;
47        Label1.Text = pds.Count.ToString();
48        pds.CurrentPageIndex = Convert.ToInt32(this.labPage.Text) - 1;
49        Repeater1.DataSource = pds;
50        LabCountPage.Text = pds.PageCount.ToString();
51        labPage.Text = (pds.CurrentPageIndex + 1).ToString();
52        this.lbtnpritPage.Enabled = true;
53        this.lbtnFirstPage.Enabled = true;
54        this.lbtnNextPage.Enabled = true;
55        this.lbtnDownPage.Enabled = true;
56        if (pds.CurrentPageIndex < 1)
57        ...{
58            this.lbtnpritPage.Enabled = false;
59            this.lbtnFirstPage.Enabled = false;
60        }
61        if (pds.CurrentPageIndex == pds.PageCount - 1)
62        ...{
63            this.lbtnNextPage.Enabled = false;
64            this.lbtnDownPage.Enabled = false;
65        }
66        Repeater1.DataBind();
67    }
68    protected void lbtnpritPage_Click(object sender, EventArgs e)
69    ...{
70        this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) - 1);
71        this.contrlRepeater();
72    }
73    protected void lbtnFirstPage_Click(object sender, EventArgs e)
74    ...{
75        this.labPage.Text = "1";
76        this.contrlRepeater();
77    }
78    protected void lbtnDownPage_Click(object sender, EventArgs e)
79    ...{
80        this.labPage.Text = this.LabCountPage.Text;
81        this.contrlRepeater();
82    }
83
84    protected void lbtnNextPage_Click(object sender, EventArgs e)
85    ...{
86        this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) + 1);
87        this.contrlRepeater();
88    }
89}
90