当前文件路径：DaDaEnterprise/View.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 View : System.Web.UI.Page
 13...{
 14    protected void Page_Load(object sender, EventArgs e)
 15    ...{
 16        if (!IsPostBack)
 17        ...{
 18
 19            Title = ConfigurationManager.AppSettings["Web"] + " - 建站心得";
 20            this.labPage.Text = "1";
 21            this.contrlRepeater();
 22            string count = "select count(*) from [View]";
 23            Count.Text = DataAccess.CountCmd(count).ToString();
 24
 25            //左边作品数据源
 26            string Works = "select top 15 * from [Works] order by id desc";
 27            Repeater3.DataSource = DataAccess.GetDataSet(Works);
 28            Repeater3.DataBind();
 29
 30            string cls = "select * from[Class] order by Sort";
 31            DataList1.DataSource = DataAccess.GetDataSet(cls);
 32            DataList1.DataBind();
 33        }
 34        
 35    }
 36
 37    /**//// <summary>
 38    /// 字符截断
 39    /// </summary>
 40    /// <param name="scatitle"></param>
 41    /// <param name="cid"></param>
 42    /// <returns></returns>
 43    public static string getleft(string scatitle, int cid)
 44    ...{  
 45        string rtn = "";
 46        if (scatitle.Trim().Length > cid)
 47        ...{
 48            rtn = scatitle.Substring(0, cid) + "...";
 49        }
 50        else
 51        ...{
 52            rtn = scatitle;
 53        }
 54        return rtn;
 55    }
 56
 57    /**//// <summary>
 58    /// 分页
 59    /// </summary>
 60    public void contrlRepeater()
 61    ...{
 62        string sql = "select * from [View] order by id desc";
 63        DataSet Ds = DataAccess.GetDataSet(sql);
 64
 65        //使用PagedDataSource来实现分页
 66        PagedDataSource pds = new PagedDataSource();
 67        pds.DataSource = Ds.Tables[0].DefaultView;
 68        pds.AllowPaging = true;
 69        pds.PageSize = 20;
 70        Label1.Text = pds.Count.ToString();
 71        pds.CurrentPageIndex = Convert.ToInt32(this.labPage.Text) - 1;
 72        Repeater2.DataSource = pds;
 73        LabCountPage.Text = pds.PageCount.ToString();
 74        labPage.Text = (pds.CurrentPageIndex + 1).ToString();
 75        this.lbtnpritPage.Enabled = true;
 76        this.lbtnFirstPage.Enabled = true;
 77        this.lbtnNextPage.Enabled = true;
 78        this.lbtnDownPage.Enabled = true;
 79        if (pds.CurrentPageIndex < 1)
 80        ...{
 81            this.lbtnpritPage.Enabled = false;
 82            this.lbtnFirstPage.Enabled = false;
 83        }
 84        if (pds.CurrentPageIndex == pds.PageCount - 1)
 85        ...{
 86            this.lbtnNextPage.Enabled = false;
 87            this.lbtnDownPage.Enabled = false;
 88        }
 89        Repeater2.DataBind();
 90    }
 91    protected void lbtnpritPage_Click(object sender, EventArgs e)
 92    ...{
 93        this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) - 1);
 94        this.contrlRepeater();
 95    }
 96    protected void lbtnFirstPage_Click(object sender, EventArgs e)
 97    ...{
 98        this.labPage.Text = "1";
 99        this.contrlRepeater();
100    }
101    protected void lbtnDownPage_Click(object sender, EventArgs e)
102    ...{
103        this.labPage.Text = this.LabCountPage.Text;
104        this.contrlRepeater();
105    }
106
107    protected void lbtnNextPage_Click(object sender, EventArgs e)
108    ...{
109        this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) + 1);
110        this.contrlRepeater();
111    }
112}
113