User/orderlist.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

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;
using System.Data.SqlClient;
using LYF.SqlHelper;

public partial class User_orderlist : System.Web.UI.Page
{
    private SqlHelper shp = new SqlHelper("XS");
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["username"] == null || Session["username"].ToString() == "")
        {
            Response.Write("<script>alert('您还未登录，登录后可以进行订单查询！');parent.location.href='index.aspx'</script>");
        }
        else
        {
            if (!IsPostBack)
            {
                LoadBind();
            }
        }
    }
    private void LoadBind()
    {
        int pageno = this.OrderPage.CurrentPageIndex;
        int pagesize = this.OrderPage.PageSize;
        string sqlstr = "select top " + pagesize + " * from XS_Order where username='"+Session["username"].ToString()+"'";
        string sqlstr1 = "select top " + ((pageno - 1) * pagesize) + " id from XS_Order where username='" + Session["username"].ToString() + "'";
        string selcount = "select count(*) from XS_Order where username='" + Session["username"].ToString() + "'";
        string sql = sqlstr + " and id not in(" + sqlstr1 + " order by id desc)order by id desc";
        this.OrderRP.DataSource = shp.GetTable(sql, CommandType.Text, null);
        this.OrderRP.DataBind();
        int count = 0;
        using (SqlDataReader dr = shp.ExecuteReader(selcount))
        {
            if (dr.Read())
            {
                count = Int32.Parse(dr[0].ToString());
            }
        }
        shp.CloseDB();
        if (count == 0)
        {
            this.msgtr.Visible = true;
        }
        else
        {
            this.msgtr.Visible = false;
        }
        this.OrderPage.RecordCount = count;
    }
    /// <summary>