alist.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class m_alist : System.Web.UI.Page
{
    public string ArticalType = "";
    public string var_pagecount = "";

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindArticalType();
            bindArtical();
        }
    }

    private void bindArticalType()
    {
        string ArticalTypeID = DES.MD5Decrypt(Request.QueryString["atype"]);
        string strSql = "select * from tbl_atype where ID =" + ArticalTypeID;
        DataTable dt = DB.GetTable(strSql);

        ArticalType = dt.Rows[0]["Type"].ToString();

        int idx = ArticalType.IndexOf("-");
        if (idx > -1)
        {
            ArticalType = ArticalType.Substring(idx + 1);
        }
    }

    ////绑定分页和GridView方法
    private void bindArtical()
    {

        string ArticalTypeID = DES.MD5Decrypt(Request.QueryString["atype"]);

        int count = int.Parse(DB.GetField("select count(*) from v_Artical where TypeID = " + ArticalTypeID).ToString());

        string strSql = "select top 20 [ID], [Title], [Date] from v_Artical where TypeID =" + ArticalTypeID + " order by ID desc";
        DataTable dt = DB.GetTable(strSql);

        repeatAlist.DataSource = dt;
        repeatAlist.DataBind();

        var_pagecount = Math.Ceiling((double)count / 10).ToString();
    }
}