shop_display.aspx.cs

B2B网上商城

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

public partial class shop_display : System.Web.UI.Page
{
    public string dianpuid = "0";
    public string dianpuname;
    public string dianpuuser;
    public string dianpulogo;
    public string dianputime;
    public string dianpugonggao;
    public string dianpuclass;
    public string dianpuitem;
    public string DianPuAdd;

    public static int TotalPage;//定义变量来保存总页数
    public int CurPage;//定义变量来保存当前页索引
    public int Tnum;//总条数;
    public int EachPage;//每页总条数

    public string dianpujieshao;
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["id"] == null || Request.QueryString["id"].ToString() == String.Empty)
        {
            Response.Write("<script language='JavaScript'>");
            Response.Write("alert('没有这个店铺！');");
            Response.Write("</script>");
            return;
        }

        if (!IsPostBack)
        {
            dianpuid = Request.QueryString["id"].ToString();
            shopLogo.Src = "showProductshopLogo.aspx?id=" + dianpuid;

            SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);
            string sql = "select * from DianPuDetail where DianPuId=" + dianpuid;
            SqlCommand command = new SqlCommand(sql, connection);
            connection.Open();
            SqlDataReader dr = command.ExecuteReader();
            if (dr.Read())
            {
                dianpuname = dr["DianPuName"].ToString();
                dianpuuser = dr["DianPuUser"].ToString();
                dianputime = Convert.ToDateTime(dr["DianPuTime"]).ToShortDateString();
                dianpugonggao = dr["DianPuGongGao"].ToString();
                dianpuclass = dr["DianPuClass"].ToString();
                dianpuitem = dr["DianPuItem"].ToString();
                dianpujieshao = dr["DianPuJieshao"].ToString();
                DianPuAdd = dr["DianPuAdd"].ToString();
            }
            else
            {
                Response.Write("<script language='JavaScript'>");
                Response.Write("alert('没有这个店铺！');");
                Response.Write("</script>");
                return;
            }
            dr.Close();
            connection.Close();

            //绑定 新进店铺对应的商品列表
            String mysql = "SELECT * FROM Products where UserName='" + dianpuuser + "' and ProductState=0 order by ProductId desc";
            /*
            SqlCommand mycommand=new SqlCommand(mysql,connection);
            connection.Open();
            SqlDataReader mydr=mycommand.ExecuteReader();
            */
            SqlDataAdapter da = new SqlDataAdapter(mysql, connection);
            DataSet ds = new DataSet();
            da.Fill(ds, "Table");

            PagedDataSource objPage = new PagedDataSource();//创建分页类
            objPage.DataSource = ds.Tables["Table"].DefaultView;//设置数据源

            objPage.AllowPaging = true;
            objPage.PageSize = 10;

            if (Request.QueryString["Page"] != null)
            {
                CurPage = Convert.ToInt32(Request.QueryString["Page"]);
                CurPage = Math.Min(CurPage, objPage.PageCount);
                CurPage = Math.Max(CurPage, 1);
            }
            else
                CurPage = 1;
            objPage.CurrentPageIndex = CurPage - 1;
            TotalPage = objPage.PageCount;
            Tnum = objPage.DataSourceCount;
            EachPage = objPage.Count;
            lblCurPage.Text = "第 " + CurPage.ToString() + " / " + TotalPage.ToString() + " 页";
            lblTnum.Text = "共: " + Tnum + " 条记录";
            lblEachPage.Text = "每页有: " + EachPage.ToString() + " 条记录";

            if (objPage.CurrentPageIndex != 0)
                lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?id=" + dianpuid + "&Page=" + Convert.ToString(1);
            if (objPage.CurrentPageIndex != TotalPage - 1)
                lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?id=" + dianpuid + "&Page=" + Convert.ToString(TotalPage);

            if (!objPage.IsFirstPage)
                lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?id=" + dianpuid + "&Page=" + Convert.ToString(CurPage - 1);
            if (!objPage.IsLastPage)
                lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?id=" + dianpuid + "&Page=" + Convert.ToString(CurPage + 1);

            DataList1.DataSource = objPage;
            DataList1.DataBind();
            dr.Close();
            connection.Close();
        }
    }
    protected void btnPage_Click(object sender, EventArgs e)
    {
        int PageNum = 0;
        if (!Request.Form["txtPage"].Equals(""))
            PageNum = Convert.ToInt32(Request.Form["txtPage"]);
        if (PageNum <= 0 || PageNum > TotalPage)
            Response.Redirect(Request.CurrentExecutionFilePath + "?id=" + Request.QueryString["id"].ToString() + "&Page=" + Convert.ToString(1));
        else
            Response.Redirect(Request.CurrentExecutionFilePath + "?id=" + Request.QueryString["id"] + "&Page=" + Convert.ToString(PageNum));

    }
}