private void PData()//珆尨眈茼珅豪陓洘
{
string strID = ViewState["ID"].ToString();
DBConn myDB = new DBConn();
string sql = "select * from Products where PID=" + strID;
SqlDataReader dr = myDB.getDataReader(sql);
if (dr.Read())
{
strPID = dr["PID"].ToString();
lblPName.Text = dr["PName"].ToString();
strPName = lblPName.Text;
lblPFPrice.Text = double.Parse(dr["PFPrice"].ToString()).ToString("f2");
lblPNPrice.Text = double.Parse(dr["PNPrice"].ToString()).ToString("f2");
strPBewrite = dr["PBewrite"].ToString();
strPUseMode = dr["PUseMode"].ToString();
strPValidity = dr["PValidity"].ToString();
string strPStock = dr["PStock"].ToString();
if (Int32.Parse(strPStock) > 0)
{
strBuy = "<img src='images/car.gif'> [ <A target=_blank href='makeOrder.aspx?id=" + strPID + "'>在线购买</A> ]";
}
else
{
strBuy = "[ 没有存货 ]";
}
}
dr.Close();
myDB.Close();
}
private string getNewOrderID()//获取新的流水帐号
{
string strOrderID = "";
DateTime myTime = System.DateTime.Now;
strOrderID = myTime.Year.ToString();
strOrderID += myTime.Month.ToString("00");
strOrderID += myTime.Day.ToString("00");
strOrderID += myTime.Hour.ToString("00");
strOrderID += myTime.Minute.ToString("00");
strOrderID += myTime.Second.ToString("00");
strOrderID += myTime.Millisecond.ToString("000");//毫秒
DBConn myDB = new DBConn();
string sql = "select OID from [Order] order by OID desc";
SqlDataReader dr = myDB.getDataReader(sql);
if (dr.Read())
{
string strTemp = dr["OID"].ToString();
int iTemp = Int32.Parse(strTemp.Substring(strTemp.Length - 2, 2)) + 1;
strOrderID += (iTemp % 100).ToString("00");
}
else
{
strOrderID += "00";
}
dr.Close();
myDB.Close();
return(strOrderID);
}
private void CData()//分类列表绑定
{
DBConn myDB = new DBConn();
string sql = "select * from Category";
CRepeater.DataSource = myDB.getDataReader( sql );
CRepeater.DataBind();
myDB.Close();
}
private void getNewDataList()//最新上架
{
DBConn myDB = new DBConn();
string sql = "select top 6 * from Products order by PID desc";
NDataList.DataSource = myDB.getDataReader( sql );
NDataList.DataBind();
myDB.Close();
}
private void getHotDataList()//热卖二手书
{
DBConn myDB = new DBConn();
string sql = "select top 10 * from Products where PHot=1 order by PID desc";
HDataList.DataSource = myDB.getDataReader( sql );
HDataList.DataBind();
myDB.Close();
}
public string strBuy = "";//打印在线购买 或 没有存货
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null)
{
string strID = Request.QueryString["id"].ToString();
strID = CleanString.htmlInputText(strID);
DBConn myDB = new DBConn();
string sql = "select * from products where PID=" + strID;
SqlDataReader dr;
try
{
dr = myDB.getDataReader(sql);
}
catch
{
Response.Write("<script>");
Response.Write("alert('没有这个二手书!!!');");
Response.Write("</script>");
Response.Redirect("index.aspx");
return;
}
if (dr.Read())
{
ViewState["CID"] = dr["CID"].ToString();
}
else
{
Response.Write("<script>");
Response.Write("alert('没有这个二手书!!!');");
Response.Write("</script>");
dr.Close();
myDB.Close();
Response.Redirect("index.aspx");
return;
}
dr.Close();
myDB.Close();
ViewState["ID"] = strID;
}
CData();
HData();//分类对应的热销二手书列表绑定
DHData();
leaveWord();
setSelectClass();//绑定 类别选框
}
PData();
}
private void getOrderData(string strOID, string strName, string strEmail) //获取订单信息
{
DBConn myDB = new DBConn();
string sql = "select * from [Order] where OID='" + strOID + "' and TName='" + strName + "' and Email='" + strEmail + "'";
SqlDataReader dr = myDB.getDataReader(sql);
if (dr.Read())
{
lblOrderID.Text = dr["OID"].ToString();
if (dr["PID"].ToString() == "0")
{
lblDetailP.Text = "<a href='P_OderInfo.aspx?id=" + dr["OID"].ToString() + "' target='_blank'>查看批量购买的产品详情</a>";
}
lblTName.Text = dr["TName"].ToString();
lblEmail.Text = dr["Email"].ToString();
lblPhone.Text = dr["Phone"].ToString();
lblPID.Text = dr["PID"].ToString();
lblPName.Text = dr["PName"].ToString();
lblPPrice.Text = double.Parse(dr["PPrice"].ToString()).ToString("C");
lblPNum.Text = dr["PNum"].ToString();
lblTotalPrice.Text = double.Parse(dr["TotalPrice"].ToString()).ToString("C");
lblPubdate.Text = dr["Pubdate"].ToString();
lblOState.Text = dr["OState"].ToString();
string strOState = lblOState.Text;
switch (strOState)
{
case "0":
strOState = "未处理";
break;
case "1":
strOState = "完成";
break;
case "2":
strOState = "等待";
break;
default:
strOState = "其他";
break;
}
lblOState.Text = strOState;
tableSelect.Visible = false;
tableInfo.Visible = true;
}
else
{
Response.Write("<script>");
Response.Write("alert('找不到相应的订单资料!!!');");
Response.Write("</script>");
}
dr.Close();
myDB.Close();
}
private void PData()//显示相应二手书信息
{
string strID = ViewState["ID"].ToString();
DBConn myDB = new DBConn();
string sql = "select * from Products where PID=" + strID;
SqlDataReader dr;
try
{
dr = myDB.getDataReader(sql);
}
catch
{
Response.Write("<script>");
Response.Write("alert('没有这个二手书!!!');");
Response.Write("</script>");
Response.Redirect("index.aspx");
return;
}
if (dr.Read())
{
string strPID = "";
strPID = dr["PID"].ToString();
myImg.Src = "showPP.aspx?id=" + strPID;
lblPName.Text = dr["PName"].ToString();
lblPFPrice.Text = double.Parse(dr["PFPrice"].ToString()).ToString("f2");
lblPNPrice.Text = double.Parse(dr["PNPrice"].ToString()).ToString("f2");
lblTotalPric.Text = lblPNPrice.Text;
ViewState["PCPrice"] = dr["PCPrice"].ToString();
string strPStock = dr["PStock"].ToString();
if (Int32.Parse(strPStock) > 0)
{
lblIsStock.Text = "[仓库有货]";
}
else
{
lblIsStock.Text = "[没有存货]";
btnOK.Enabled = false;
}
}
else
{
Response.Write("<script>");
Response.Write("alert('没有这个二手书!!!');");
Response.Write("</script>");
dr.Close();
myDB.Close();
Response.Redirect("index.aspx");
return;
}
dr.Close();
myDB.Close();
}
private void getNewDataList()//郔陔奻殤
{
DBConn myDB = new DBConn();
string sql = "select top 6 * from Products order by PID desc";
NDataList.DataSource = myDB.getDataReader(sql);
NDataList.DataBind();
myDB.Close();
}
private void CData()//煦濬蹈桶堂隅
{
DBConn myDB = new DBConn();
string sql = "select * from Category";
CRepeater.DataSource = myDB.getDataReader(sql);
CRepeater.DataBind();
myDB.Close();
}
private void getTJDataList()//儕芢熱
{
DBConn myDB = new DBConn();
string sql = "select top 10 * from Products where PCommend=1 order by PID desc";
JRepeater.DataSource = myDB.getDataReader(sql);
JRepeater.DataBind();
myDB.Close();
}
private void getHotDataList()//闖珅豪
{
DBConn myDB = new DBConn();
string sql = "select top 10 * from Products where PHot=1 order by PID desc";
HDataList.DataSource = myDB.getDataReader(sql);
HDataList.DataBind();
myDB.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Session["User"] != null)
{
string Pid = Request.QueryString["id"].ToString();
//检查库存
string strNum = DropDownList1.SelectedValue;
DBConn myDB = new DBConn();
string mySql = "select PStock from Products where PID=" + Pid;
SqlDataReader mydr = myDB.getDataReader(mySql);
if (mydr.Read())
{
int iPStock = Int32.Parse(mydr["PStock"].ToString());
if (iPStock < int.Parse(strNum))
{
Response.Write("<script>");
Response.Write("alert('库存不足!!!现在库存还有[ " + iPStock.ToString() + " ]');");
Response.Write("</script>");
return;
}
}
else
{
Response.Write("<script>");
Response.Write("alert('没有这个二手书!!!');");
Response.Write("</script>");
mydr.Close();
myDB.Close();
Response.Redirect("index.aspx");
return;
}
mydr.Close();
myDB.Close();
string tblUser = (String)Session["User"];
string sql = "insert into [tblBasket](tblUser,Pid,isN,isMoney) values ( '" + tblUser + "', '" + Pid + "', '" + strNum + "', " + lblCount.Text + ")";
DBConn myDB1 = new DBConn();
myDB1.ExecuteNonQuery(sql);
myDB1.Close();
Response.Write("<script>alert('加入购物车成功 ~');</script>");
}
else
{
Response.Write("<script>alert('未登陆无法收藏~');</script>");
}
}
public string strBuy = ""; //湖荂婓盄劃鎗 麼 羶衄湔億
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null)
{
string strID = Request.QueryString["id"].ToString();
strID = CleanString.htmlInputText(strID);
DBConn myDB = new DBConn();
string sql = "select * from products where PID=" + strID;
SqlDataReader dr;
try
{
dr = myDB.getDataReader(sql);
}
catch
{
Response.Write("<script>");
Response.Write("alert('没有这个鲜花!!!');");
Response.Write("</script>");
Response.Redirect("index.aspx");
return;
}
if (dr.Read())
{
ViewState["CID"] = dr["CID"].ToString();
}
else
{
Response.Write("<script>");
Response.Write("alert('没有这个鲜花!!');");
Response.Write("</script>");
dr.Close();
myDB.Close();
Response.Redirect("index.aspx");
return;
}
dr.Close();
myDB.Close();
ViewState["ID"] = strID;
}
CData();
HData();//煦濬勤茼腔种珅豪蹈桶堂隅
DHData();
leaveWord();
setSelectClass();//堂隅 濬梗恁遺
}
PData();
}
private void setSelectClass()//绑定 类别选框
{
DBConn myDB = new DBConn();
string mySql = "select CID,CName from Category order by CID desc";
ddlClass.DataSource = myDB.getDataReader( mySql );
ddlClass.DataTextField = "CName";
ddlClass.DataValueField = "CID";
ddlClass.DataBind();
myDB.Close();
ddlClass.Items.Insert(0,new ListItem("所有分类","-1"));
}
private void getOrderData( string strOID, string strName, string strEmail )//获取订单信息
{
DBConn myDB = new DBConn();
string sql="select * from [Order] where OID='" + strOID + "' and TName='" + strName + "' and Email='" + strEmail + "'";
SqlDataReader dr = myDB.getDataReader( sql );
if( dr.Read() )
{
lblOrderID.Text = dr["OID"].ToString();
if(dr["PID"].ToString()=="0") lblDetailP.Text = "<a href='P_OderInfo.aspx?id=" + dr["OID"].ToString() + "' target='_blank'>查看批量购买的产品详情</a>";
lblTName.Text = dr["TName"].ToString();
lblEmail.Text = dr["Email"].ToString();
lblPhone.Text = dr["Phone"].ToString();
lblPID.Text = dr["PID"].ToString();
lblPName.Text = dr["PName"].ToString();
lblPPrice.Text = double.Parse( dr["PPrice"].ToString() ).ToString("C");
lblPNum.Text = dr["PNum"].ToString();
lblTotalPrice.Text = double.Parse( dr["TotalPrice"].ToString() ).ToString("C");
lblPubdate.Text = dr["Pubdate"].ToString();
lblOState.Text = dr["OState"].ToString();
string strOState = lblOState.Text;
switch( strOState )
{
case "0":
strOState = "未处理";
break;
case "1":
strOState = "完成";
break;
case "2":
strOState = "等待";
break;
default:
strOState = "其他";
break;
}
lblOState.Text = strOState;
tableSelect.Visible = false;
tableInfo.Visible = true;
}
else
{
Response.Write("<script>");
Response.Write("alert('找不到相应的订单资料!!!');");
Response.Write("</script>");
}
dr.Close();
myDB.Close();
}
private void getAnnounce()//获取公告信息
{
string mySql="select * from append where id='3'";
DBConn myDB = new DBConn();
SqlDataReader mydr = myDB.getDataReader( mySql );
if( mydr.Read() )
{
lblAnnounce.Text = CleanString.htmlOutputText( mydr["text"].ToString() );
}
mydr.Close();
myDB.Close();
}
private void setSelectClass()
{
DBConn myDB = new DBConn();
string mySql = "select CID,CName from Category order by CID desc";
ddlClass.DataSource = myDB.getDataReader(mySql);
ddlClass.DataTextField = "CName";
ddlClass.DataValueField = "CID";
ddlClass.DataBind();
myDB.Close();
ddlClass.Items.Insert(0, new ListItem("所有分类", "-1"));
}
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 getAnnounce()//鳳鼠豢陓洘
{
string mySql = "select * from append where id='3'";
DBConn myDB = new DBConn();
SqlDataReader mydr = myDB.getDataReader(mySql);
if (mydr.Read())
{
lblAnnounce.Text = CleanString.htmlOutputText(mydr["text"].ToString());
}
mydr.Close();
myDB.Close();
}
private void HData()//煦濬勤茼腔种珅豪蹈桶堂隅
{
if (ViewState["CID"] == null)
{
DBConn myDB = new DBConn();
string sql = "SELECT TOP 5 * FROM Products WHERE PSellNum>0 ORDER BY PSellNum DESC,PID";
HotRepeater.DataSource = myDB.getDataReader(sql);
HotRepeater.DataBind();
myDB.Close();
}
else
{
string strCID = ViewState["CID"].ToString();
DBConn myDB = new DBConn();
string sql = "SELECT top 5 * From Products Where PSellNum>0 and CID=" + strCID + " order by PSellNum desc,PID";
HotRepeater.DataSource = myDB.getDataReader(sql);
HotRepeater.DataBind();
myDB.Close();
}
}
private void DHData()//絳瑤沭扢离
{
string strCID = ViewState["CID"].ToString();
if (ViewState["CID"] == null || ViewState["CID"].ToString() == String.Empty)
{
lblDaohang.Text = "所有鲜花";
}
else
{
DBConn myDB = new DBConn();
string sql = "select * from Category where CID=" + strCID;
SqlDataReader dr = myDB.getDataReader(sql);
if (dr.Read())
{
lblDaohang.Text = dr["CName"].ToString();
}
dr.Close();
myDB.Close();
}
}
private bool isAdmin(string strAdmin, string strPassword)
{
bool bTemp = false;
DBConn myDB = new DBConn();
string mySql = "select * from tblUser where UserName='******' and Psw='" + strPassword + "'";
SqlDataReader mydr = myDB.getDataReader(mySql);
if (mydr.Read())
{
bTemp = true;
}
else
{
bTemp = false;
}
mydr.Close();
myDB.Close();
return bTemp;
}
private void HData()//分类对应的热销二手书列表绑定
{
if (ViewState["CID"] == null || ViewState["CID"].ToString() == String.Empty)
{
DBConn myDB = new DBConn();
string sql = "SELECT TOP 5 * FROM Products WHERE PSellNum>0 ORDER BY PSellNum DESC,PID";
HotRepeater.DataSource = myDB.getDataReader(sql);
HotRepeater.DataBind();
myDB.Close();
}
else
{
string strCID = ViewState["CID"].ToString();
DBConn myDB = new DBConn();
string sql = "select top 5 * from Products where PSellNum>0 and CID=" + strCID + " order by PSellNum desc,PID";
HotRepeater.DataSource = myDB.getDataReader(sql);
HotRepeater.DataBind();
myDB.Close();
}
}
private bool isAdmin(string strAdmin, string strPassword)
{
bool bTemp = false;
DBConn myDB = new DBConn();
string mySql = "select * from tblUser where UserName='******' and Psw='" + strPassword + "'";
SqlDataReader mydr = myDB.getDataReader(mySql);
if (mydr.Read())
{
bTemp = true;
}
else
{
bTemp = false;
}
mydr.Close();
myDB.Close();
return(bTemp);
}
private string getNewOrderID()//获取新的流水帐号
{
string strOrderID = "";
DateTime myTime = System.DateTime.Now;
strOrderID = myTime.Year.ToString();
strOrderID += myTime.Month.ToString("00");
strOrderID += myTime.Day.ToString("00");
strOrderID += myTime.Hour.ToString("00");
strOrderID += myTime.Minute.ToString("00");
strOrderID += myTime.Second.ToString("00");
strOrderID += myTime.Millisecond.ToString("000");//毫秒
DBConn myDB = new DBConn();
string sql = "select OID from [Order] order by OID desc";
SqlDataReader dr = myDB.getDataReader(sql);
if (dr.Read())
{
string strTemp = dr["OID"].ToString();
int iTemp = Int32.Parse(strTemp.Substring(strTemp.Length - 2, 2)) + 1;
strOrderID += (iTemp % 100).ToString("00");
}
else
{
strOrderID += "00";
}
dr.Close();
myDB.Close();
return strOrderID;
}
private void PData()//显示相应二手书信息
{
string strID = ViewState["ID"].ToString();
DBConn myDB = new DBConn();
string sql = "select * from Products where PID=" + strID;
SqlDataReader dr = myDB.getDataReader(sql);
if (dr.Read())
{
strPID = dr["PID"].ToString();
lblPName.Text = dr["PName"].ToString();
strPName = lblPName.Text;
lblPFPrice.Text = double.Parse(dr["PFPrice"].ToString()).ToString("f2");
lblPNPrice.Text = double.Parse(dr["PNPrice"].ToString()).ToString("f2");
strPBewrite = dr["PBewrite"].ToString();
strPUseMode = dr["PUseMode"].ToString();
strPValidity = dr["PValidity"].ToString();
string strPStock = dr["PStock"].ToString();
if (Int32.Parse(strPStock) > 0)
{
strBuy = "<img src='images/car.gif'> [ <A target=_blank href='makeOrder.aspx?id=" + strPID + "'>在线购买</A> ]";
}
else
{
strBuy = "[ 没有存货 ]";
}
}
dr.Close();
myDB.Close();
}
private void DHData()//导航条设置
{
string strCID = ViewState["CID"].ToString();
if (ViewState["CID"] == null || ViewState["CID"].ToString() == String.Empty)
{
lblDaohang.Text = "所有二手书";
}
else
{
DBConn myDB = new DBConn();
string sql = "select * from Category where CID=" + strCID;
SqlDataReader dr = myDB.getDataReader(sql);
if (dr.Read())
{
lblDaohang.Text = dr["CName"].ToString();
}
dr.Close();
myDB.Close();
}
}
protected void btnOK_Click(object sender, System.EventArgs e)
{
string strID = ViewState["ID"].ToString();
string strName = txtName.Text.Trim();
string strEmail = txtEmail.Text.Trim();
string strPhone = txtPhone.Text.Trim();
string strNum = ddlNum.SelectedValue;
if (strName == String.Empty || strEmail == String.Empty || strPhone == String.Empty)
{
Response.Write("<script>");
Response.Write("alert('请把必填项添上!!!');");
Response.Write("</script>");
return;
}
// if (Session["CheckCode"] == null)
// {
// Response.Redirect("index.aspx");
// return;
// }
if (Session["CheckCode"].ToString() != txtCheck.Text.Trim())
{
Response.Write("<script>");
Response.Write("alert('输入的验证码有误！请重新输入！')");
Response.Write("</script>");
return;
}
//检查库存
DBConn myDB = new DBConn();
string mySql = "select PStock from Products where PID=" + strID;
SqlDataReader mydr = myDB.getDataReader(mySql);
if (mydr.Read())
{
int iPStock = Int32.Parse(mydr["PStock"].ToString());
if (iPStock < int.Parse(strNum))
{
Response.Write("<script>");
Response.Write("alert('库存不足!!!现在库存还有[ " + iPStock.ToString() + " ]');");
Response.Write("</script>");
return;
}
}
else
{
Response.Write("<script>");
Response.Write("alert('没有这个二手书!!!');");
Response.Write("</script>");
mydr.Close();
myDB.Close();
Response.Redirect("index.aspx");
return;
}
mydr.Close();
myDB.Close();
Order myOrder = new Order();
myOrder.PID = strID;
myOrder.PName = lblPName.Text;
myOrder.PNum = strNum.ToString();
myOrder.PPrice = lblPNPrice.Text;
myOrder.TotalPrice = lblTotalPric.Text;
myOrder.TName = CleanString.htmlInputText(strName);
myOrder.Email = strEmail;
myOrder.Phone = CleanString.htmlInputText(strPhone);
if (ViewState["PCPrice"] != null)
{
myOrder.PCPrice = ViewState["PCPrice"].ToString();
}
Session["myOrder"] = myOrder;
if (Session["SubmitCheck"] != null)
{
DateTime myDTime = (DateTime)Session["SubmitCheck"];
if (myDTime.AddMilliseconds(30000) > DateTime.Now)
{
Response.Write("<script>");
TimeSpan myTime = DateTime.Now - (DateTime)Session["SubmitCheck"];
Response.Write("alert('不能频繁提交,请在" + (30 - myTime.Seconds) + "秒后继续!!!');");
Response.Write("</script>");
return;
}
}
Session["SubmitCheck"] = DateTime.Now;
Response.Redirect("orderinfo.aspx?key=" + Server.UrlEncode("makeOrder.aspx?id=" + ViewState["ID"].ToString()));
}
private void PData()//显示相应二手书信息
{
string strID = ViewState["ID"].ToString();
DBConn myDB = new DBConn();
string sql = "select * from Products where PID=" + strID;
SqlDataReader dr;
try
{
dr = myDB.getDataReader(sql);
}
catch
{
Response.Write("<script>");
Response.Write("alert('没有这个二手书!!!');");
Response.Write("</script>");
Response.Redirect("index.aspx");
return;
}
if (dr.Read())
{
string strPID = "";
strPID = dr["PID"].ToString();
myImg.Src = "showPP.aspx?id=" + strPID;
lblPName.Text = dr["PName"].ToString();
lblPFPrice.Text = double.Parse(dr["PFPrice"].ToString()).ToString("f2");
lblPNPrice.Text = double.Parse(dr["PNPrice"].ToString()).ToString("f2");
lblTotalPric.Text = lblPNPrice.Text;
ViewState["PCPrice"] = dr["PCPrice"].ToString();
string strPStock = dr["PStock"].ToString();
if (Int32.Parse(strPStock) > 0)
{
lblIsStock.Text = "[仓库有货]";
}
else
{
lblIsStock.Text = "[没有存货]";
btnOK.Enabled = false;
}
}
else
{
Response.Write("<script>");
Response.Write("alert('没有这个二手书!!!');");
Response.Write("</script>");
dr.Close();
myDB.Close();
Response.Redirect("index.aspx");
return;
}
dr.Close();
myDB.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Session["User"] != null)
{
string Pid = Request.QueryString["id"].ToString();
//检查库存
string strNum = DropDownList1.SelectedValue;
DBConn myDB = new DBConn();
string mySql = "select PStock from Products where PID=" + Pid;
SqlDataReader mydr = myDB.getDataReader(mySql);
if (mydr.Read())
{
int iPStock = Int32.Parse(mydr["PStock"].ToString());
if (iPStock < int.Parse(strNum))
{
Response.Write("<script>");
Response.Write("alert('库存不足!!!现在库存还有[ " + iPStock.ToString() + " ]');");
Response.Write("</script>");
return;
}
}
else
{
Response.Write("<script>");
Response.Write("alert('没有这个二手书!!!');");
Response.Write("</script>");
mydr.Close();
myDB.Close();
Response.Redirect("index.aspx");
return;
}
mydr.Close();
myDB.Close();
string tblUser = (String)Session["User"];
string sql = "insert into [tblBasket](tblUser,Pid,isN,isMoney) values ( '" + tblUser + "', '" + Pid + "', '" + strNum + "', " + lblCount.Text +")";
DBConn myDB1 = new DBConn();
myDB1.ExecuteNonQuery(sql);
myDB1.Close();
Response.Write("<script>alert('加入购物车成功 ~');</script>");
}
else
{
Response.Write("<script>alert('未登陆无法收藏~');</script>");
}
}
protected void btnOK_Click(object sender, System.EventArgs e)
{
string strID = ViewState["ID"].ToString();
string strName = txtName.Text.Trim();
string strEmail = txtEmail.Text.Trim();
string strPhone = txtPhone.Text.Trim();
string strNum = ddlNum.SelectedValue;
if (strName == String.Empty || strEmail == String.Empty || strPhone == String.Empty)
{
Response.Write("<script>");
Response.Write("alert('请把必填项添上!!!');");
Response.Write("</script>");
return;
}
// if (Session["CheckCode"] == null)
// {
// Response.Redirect("index.aspx");
// return;
// }
if (Session["CheckCode"].ToString() != txtCheck.Text.Trim())
{
Response.Write("<script>");
Response.Write("alert('输入的验证码有误！请重新输入！')");
Response.Write("</script>");
return;
}
//检查库存
DBConn myDB = new DBConn();
string mySql = "select PStock from Products where PID=" + strID;
SqlDataReader mydr = myDB.getDataReader(mySql);
if (mydr.Read())
{
int iPStock = Int32.Parse(mydr["PStock"].ToString());
if (iPStock < int.Parse(strNum))
{
Response.Write("<script>");
Response.Write("alert('库存不足!!!现在库存还有[ " + iPStock.ToString() + " ]');");
Response.Write("</script>");
return;
}
}
else
{
Response.Write("<script>");
Response.Write("alert('没有这个二手书!!!');");
Response.Write("</script>");
mydr.Close();
myDB.Close();
Response.Redirect("index.aspx");
return;
}
mydr.Close();
myDB.Close();
Order myOrder = new Order();
myOrder.PID = strID;
myOrder.PName = lblPName.Text;
myOrder.PNum = strNum.ToString();
myOrder.PPrice = lblPNPrice.Text;
myOrder.TotalPrice = lblTotalPric.Text;
myOrder.TName = CleanString.htmlInputText(strName);
myOrder.Email = strEmail;
myOrder.Phone = CleanString.htmlInputText(strPhone);
if (ViewState["PCPrice"] != null)
{
myOrder.PCPrice = ViewState["PCPrice"].ToString();
}
Session["myOrder"] = myOrder;
if (Session["SubmitCheck"] != null)
{
DateTime myDTime = (DateTime)Session["SubmitCheck"];
if (myDTime.AddMilliseconds(30000) > DateTime.Now)
{
Response.Write("<script>");
TimeSpan myTime = DateTime.Now - (DateTime)Session["SubmitCheck"];
Response.Write("alert('不能频繁提交,请在" + (30 - myTime.Seconds) + "秒后继续!!!');");
Response.Write("</script>");
return;
}
}
Session["SubmitCheck"] = DateTime.Now;
Response.Redirect("orderinfo.aspx?key=" + Server.UrlEncode("makeOrder.aspx?id=" + ViewState["ID"].ToString()));
}
private void getTJDataList()//精品推荐
{
DBConn myDB = new DBConn();
string sql = "select top 10 * from Products where PCommend=1 order by PID desc";
JRepeater.DataSource = myDB.getDataReader( sql );
JRepeater.DataBind();
myDB.Close();
}
private void HData()//分类对应的热销二手书列表绑定
{
if( ViewState["CID"] == null )
{
DBConn myDB = new DBConn();
string sql = "SELECT TOP 5 * FROM Products WHERE PSellNum>0 ORDER BY PSellNum DESC,PID";
HotRepeater.DataSource = myDB.getDataReader( sql );
HotRepeater.DataBind();
myDB.Close();
}
else
{
string strCID = ViewState["CID"].ToString();
DBConn myDB = new DBConn();
string sql = "SELECT top 5 * From Products Where PSellNum>0 and CID=" + strCID + " order by PSellNum desc,PID";
HotRepeater.DataSource = myDB.getDataReader( sql );
HotRepeater.DataBind();
myDB.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();
}
}
