private void getData()
{
string sql = "select * from [viwBasket] where tblUser='******'order by ID desc";
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "FavDataGrid", sql, "ID desc", 20);
}
private void getData()
{
string sql = "select * from [viwPorder] where orderno='" + Request.QueryString["id"].ToString() + "'";
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "FavDataGrid", sql, "ID desc", 20);
}
private void getData()//绑定数据
{
string sql = "select * from [tblLeaveWord] order by ID desc";
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "FavDataGrid", sql, "3000000-ID", 20);
}
private void getData()
{
string sql = "select * from [viwPorder] where orderno='" + Request.QueryString["id"].ToString() + "'";
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "FavDataGrid", sql, "ID desc", 20);
}
private void getData()//绑定数据
{
string sql = "select * from [tblLeaveWord] order by ID desc";
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "FavDataGrid", sql, "3000000-ID", 20);
}
private void PData()//珅豪蹈桶堂隅
{
if (ViewState["CID"] == null)
{
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "PDataList", "select * from Products order by PID desc", "PID desc", 12);
lblDaohang.Text = "所有鲜花";
}
else
{
string strCID = ViewState["CID"].ToString();
DBConn myDB = new DBConn();
string sql = "select * from Products where CID=" + strCID + " order by PID desc";
try
{
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "PDataList", sql, "PID desc", 12);
}
catch
{
Response.Write("<script>");
Response.Write("alert('没有记录!!!');");
Response.Write("</script>");
myDB.Close();
Response.Redirect("index.aspx");
return;
}
myDB.Close();
DBConn DB = new DBConn();
string mySql = "select * from Category where CID=" + strCID;
SqlDataReader dr = DB.getDataReader(mySql);
if (dr.Read())
{
lblDaohang.Text = dr["CName"].ToString();
}
else
{
Response.Write("<script>");
Response.Write("alert('没有这个类别!!!');");
Response.Write("</script>");
dr.Close();
DB.Close();
Response.Redirect("index.aspx");
return;
}
dr.Close();
DB.Close();
}
}
private void PData()//二手书列表绑定
{
if( ViewState["CID"] == null )
{
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute( SqlPager1, "PDataList", "select * from Products order by PID desc", "PID desc", 12);
lblDaohang.Text = "所有二手书";
}
else
{
string strCID = ViewState["CID"].ToString();
DBConn myDB = new DBConn();
string sql="select * from Products where CID=" + strCID + " order by PID desc";
try
{
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute( SqlPager1, "PDataList", sql, "PID desc", 12);
}
catch
{
Response.Write("<script>");
Response.Write("alert('没有记录!!!');");
Response.Write("</script>");
myDB.Close();
Response.Redirect("index.aspx");
return;
}
myDB.Close();
DBConn DB = new DBConn();
string mySql = "select * from Category where CID=" + strCID;
SqlDataReader dr = DB.getDataReader( mySql );
if( dr.Read() )
{
lblDaohang.Text = dr["CName"].ToString();
}
else
{
Response.Write("<script>");
Response.Write("alert('没有这个类别!!!');");
Response.Write("</script>");
dr.Close();
DB.Close();
Response.Redirect("index.aspx");
return;
}
dr.Close();
DB.Close();
}
}
private void getSelectResult(string strClass, string strText)//查询
{
string mySql= "select * from Products order by PID desc";
if( strClass.Equals("-1") )
{
mySql= "select * from Products where PName like '%" + strText + "%' order by PID desc";
}
else
{
mySql= "select * from Products where CID=" + strClass + " and PName like '%" + strText + "%' order by PID desc";
}
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute( SqlPager1, "PDataList", mySql, "PID desc", 10);
}
private void getSelectResult(string strClass, string strText)//脤戙
{
string mySql = "select * from Products order by PID desc";
if (strClass.Equals("-1"))
{
mySql = "select * from Products where PName like '%" + strText + "%' order by PID desc";
}
else
{
mySql = "select * from Products where CID=" + strClass + " and PName like '%" + strText + "%' order by PID desc";
}
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "PDataList", mySql, "PID desc", 10);
}
private void getData()//绑定数据
{
string sql = "select * from [viwFav] where tblUser='******'order by ID desc";
/*
* DBConn myDB = new DBConn();
* OrderDataGrid.DataSource = myDB.getDataReader( sql );
* OrderDataGrid.DataBind();
* myDB.Close();
*/
//分页
//MySqlPager SqlPager = new MySqlPager();
//SqlPager.setAttribute( SqlPager1, "OrderDataGrid", sql, "'3000-1-1'-Pubdate", 20);
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "FavDataGrid", sql, "3000000-ID", 20);
}
private void getData()//绑定数据
{
string sql = "select * from [viwFav] where tblUser='******'order by ID desc";
/*
DBConn myDB = new DBConn();
OrderDataGrid.DataSource = myDB.getDataReader( sql );
OrderDataGrid.DataBind();
myDB.Close();
*/
//分页
//MySqlPager SqlPager = new MySqlPager();
//SqlPager.setAttribute( SqlPager1, "OrderDataGrid", sql, "'3000-1-1'-Pubdate", 20);
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "FavDataGrid", sql, "3000000-ID", 20);
}
private void getData()
{
string sql = "select * from [viwBasket] where tblUser='******'order by ID desc";
MySqlPager SqlPager = new MySqlPager();
SqlPager.setAttribute(SqlPager1, "FavDataGrid", sql, "ID desc", 20);
}
