//前台HTML代码
<%@ Import Namespace="chwl" %> <%@ Import Namespace="System.Text" %><%@ Page language="c#" Codebehind="mores.aspx.cs" AutoEventWireup="false" Inherits="chwl.mores" %>
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text;
namespace chwl
{
/// <summary>
/// mores 的摘要说明。
/// </summary>
public class mores : System.Web.UI.Page
{
private SqlConnection Sqlconn;
protected System.Web.UI.WebControls.Label fenlei;
protected System.Web.UI.WebControls.HyperLink HyperLink1;
protected System.Web.UI.WebControls.DataList datayingshi;
protected System.Web.UI.WebControls.HyperLink lnkNext;
protected System.Web.UI.WebControls.HyperLink InkPrev;
protected System.Web.UI.WebControls.Label lblCurPage;
protected System.Web.UI.WebControls.HyperLink diyiye;
protected System.Web.UI.WebControls.HyperLink zuihouye;
private SqlDataAdapter da;
private void Page_Load(object sender, System.EventArgs e)
{
BindList();
SqlConnection conn = new SqlConnection("Data Source=61.156.238.154;uid=yszxnew;pwd=yszxnew2006;database='yszx'");
SqlDataAdapter da = new SqlDataAdapter("select * from 产品库 where 小类别='"+Request["id"]+"'",conn);
DataSet ds = new DataSet();
da.Fill(ds,"testTable");
PagedDataSource objPage = new PagedDataSource();
objPage.DataSource = ds.Tables["testTable"].DefaultView;
objPage.AllowPaging = true;
objPage.PageSize = 20;
int CurPage;
if (Request.QueryString["Page"] != null)
{
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
}
else
{
CurPage = 1;
}
objPage.CurrentPageIndex = CurPage - 1;
lblCurPage.Text = "当前页：第" + CurPage.ToString() + "页";
if(!objPage.IsFirstPage)
diyiye.NavigateUrl= Request.CurrentExecutionFilePath +"?Page=1"+"&id="+Request["id"];
if (!objPage.IsFirstPage)
InkPrev.NavigateUrl = "mores.aspx?Page=" + Convert.ToString(CurPage-1)+"&id="+Request["id"];
if (!objPage.IsLastPage)
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage+1)+"&id="+Request["id"];
zuihouye.NavigateUrl= Request.CurrentExecutionFilePath+"?Page="+objPage.PageCount.ToString()+"&id="+Request["id"];
this.datayingshi.DataSource = objPage;
this.datayingshi.DataBind();
//
// //对PagedDataSource 对象的相关属性赋值
// PagedDataSource objPds = new PagedDataSource();
// objPds.DataSource = ds.Tables[0].DefaultView;
// objPds.AllowPaging = true;
// objPds.PageSize = 5;
// int CurPage;
// //当前页面从Page查询参数获取
// if (Request.QueryString["Page"] != null)
// CurPage=Convert.ToInt32(Request.QueryString["Page"]);
// else
// CurPage=1;
//
// objPds.CurrentPageIndex = CurPage-1;
// lblCurrentPage.Text = "Page: " + CurPage.ToString();
//
// if (!objPds.IsFirstPage)
// lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage-1);
//
// if (!objPds.IsLastPage)
// lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+ "?Page=" + Convert.ToString(CurPage+1);
//
// //把PagedDataSource 对象赋给Repeater控件
// Repeater1.DataSource=objPds;
// Repeater1.DataBind();
}
// 在此处放置用户代码以初始化页面
private void BindList()
{
string id=Request["id"];
string str="select * from 产品库 where 小类别='"+id+"' order by id desc";
this.Sqlconn=new SqlConnection(database.conStr);
this.da = new SqlDataAdapter(str,this.Sqlconn);
DataSet ds2 = new DataSet();
this.da.Fill(ds2,"temp");
DataTable dt = new DataTable();
dt=ds2.Tables[0];
this.fenlei.Text=Request["id"];
this.datayingshi.DataSource=dt;
this.datayingshi.DataBind();
}
public StringBuilder ss(string mm)
{
StringBuilder str = new StringBuilder();
if(mm=="摄影摄像视听家电")
{
str.Append("sheying.htm");
}
if (mm=="手机电话通讯器材")
{
str.Append("sj.htm");
}
if (mm=="电脑软件办公耗材")
{
str.Append("dn.htm");
}
if (mm=="化妆美容护肤")
{
str.Append("hz.htm");
}
if (mm=="体育健身休闲")
{
str.Append("ty.htm");
}
if(mm=="鲜花礼品玩具")
{
str.Append("xh.htm");
}
if(mm=="服装饰品珠宝手表")
{
str.Append("fz.htm");
}
if(mm=="图书音像光碟")
{
str.Append("ts.htm");
}
if(mm=="鲜花礼品玩具周边")
{
str.Append("xh.htm");
}
if(mm=="情侣保健营养健康")
{
str.Append("ql.htm");
}
if(mm=="票务旅游生活服务")
{
str.Append("pw.htm");
}
if(mm=="汽车用品")
{
str.Append("qc.htm");
}
if(mm=="儿童用品")
{
str.Append("et.htm");
}
return str;
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
