Img_List.aspx.cs

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Img_List : BasicPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Title = "图片文章--" + Title;
        Anthem.Manager.Register(this);
        if (!IsPostBack)
        {
            ltImgList.Text = getImgList(1);
        }
    }

    [Anthem.Method]
    public string getImgList(int page)
    {
        int pageCount = 1;
        int currentPage = page == 0 ? 1 : page;
        int pageSize = 30;
        System.Text.StringBuilder sb = new System.Text.StringBuilder();
        DataTable dt;
        int countNum = 0;
        string sqlStr = " from [xk_Content] where id>0";
        string whereStr = " and isEdit=1 and isImg=1";
        string orderStr = " order by id desc";
        sqlStr += whereStr;
        countNum = Convert.ToInt32(WebFunction.getValueByKey("count(id)", "xk_Content", "id>0" + whereStr));

        pageCount = countNum % pageSize == 0 ? countNum / pageSize : countNum / pageSize + 1;
        page = page > pageCount ? pageCount : page;

        if (page > 1)
            sqlStr = sqlStr + " and id not in (select top " + pageSize * (page - 1) + " id " + sqlStr + orderStr + ")";
        sqlStr += orderStr;
        sqlStr = "select top " + pageSize.ToString() + " id,title,img " + sqlStr;
        dt = WebFunction.dataTable(sqlStr);
        if (dt.Rows.Count == 0)
            sb.Append("<div class='content'>暂无内容</div>");
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            sb.Append("<div style='width:130px;height:150px;' class='imgListImg'>");
            sb.Append("<a href=\"article.aspx?id=" + dt.Rows[i][0].ToString() + "\" target='_blank'>");
            sb.Append("<img src='" + dt.Rows[i][2].ToString() + "' onload='reSize(this,130,130)' onmousemove='reSize(this,130,130)' border='0'><br>");
            sb.Append(WebFunction.cutTitle(dt.Rows[i][1].ToString(), 20) + "</a>");
            sb.Append("</div>");
        }
        sb.Append("<div class='pager'>" + WebFunction.PageList(pageSize, "getImgList(0", pageCount, currentPage) + "</div>");
        return sb.ToString();
    }
}