protected void btnSelect_Click(object sender, System.EventArgs e)
{
string strClass = ddlClass.SelectedValue;
string strText = txtSelect.Text;
strText = CleanString.htmlInputText(strText);
getSelectResult(strClass, strText);//脤戙
}
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();
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != String.Empty)
{
if (Session["User"] != null)
{
txtName.Enabled = false;
txtName.Text = (string)Session["User"];
DBConn db1 = new DBConn();
TextBox1.Text = db1.LookUp("select 真实姓名 from tblUser where UserName='******'", "真实姓名");
}
else
{
Response.Write("<script>alert('未登陆禁止订购');window.close();</script>");
Response.End();
return;
}
string strID = Request.QueryString["id"].ToString();
strID = CleanString.htmlInputText(strID);
ViewState["ID"] = strID;
PData();
string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];
string connStr = (DBPath);
SqlConnection con = new SqlConnection(connStr);
con.Open();
string sql = "select * from tblMode";
SqlDataAdapter sda1 = new SqlDataAdapter(sql, con);
DataSet ds1 = new DataSet();
sda1.Fill(ds1, "tblMode");
foreach (DataRow row in ds1.Tables[0].Rows)
{
this.dplBm.Items.Add(row["名称"].ToString());
}
}
else
{
Response.Write("<script>");
Response.Write("alert('没有这个二手书!!!');");
Response.Write("</script>");
Response.Redirect("index.aspx");
return;
}
double dblNum = Int32.Parse(DropDownList1.SelectedValue) * double.Parse(lblPNPrice.Text);
lblCount.Text = dblNum.ToString("f2");
}
}
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();
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
#endregion
protected void btnOK_Click(object sender, System.EventArgs e)
{
string strName = txtName.Text.Trim();
string strEmail = txtEmail.Text.Trim();
string strPhone = txtPhone.Text.Trim();
if (strName == String.Empty || strEmail == String.Empty || strPhone == String.Empty)
{
Response.Write("<script>");
Response.Write("alert('请把必填项添上!!!');");
Response.Write("</script>");
return;
}
if (lblTotalPric.Text == String.Empty || lblTotalPric.Text == "0")
{
Response.Write("<script>");
Response.Write("alert('购物车空,没办法生成订单!!!');");
Response.Write("</script>");
return;
}
if (Session["CheckCode"].ToString() != txtCheck.Text.Trim())
{
Response.Write("<script>");
Response.Write("alert('输入的验证码有误！请重新输入！')");
Response.Write("</script>");
return;
}
Order myOrder = new Order();
myOrder.PID = "0"; //特定批量购物的标识
myOrder.TotalPrice = lblTotalPric.Text;
myOrder.TName = CleanString.htmlInputText(strName);
myOrder.Email = strEmail;
myOrder.Phone = CleanString.htmlInputText(strPhone);
Session["myOrder"] = myOrder;
Response.Redirect("orderinfo.aspx?key=" + Server.UrlEncode("makeOrder.aspx?id="));
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
ViewState["CID"] = null;
if (Request.QueryString["cid"] != null)
{
string strCID = Request.QueryString["cid"].ToString();
ViewState["CID"] = CleanString.htmlInputText(strCID);
}
CData(); //煦濬蹈桶堂隅
PData(); //珅豪蹈桶堂隅
HData(); //煦濬勤茼腔种珅豪蹈桶堂隅
setSelectClass(); //堂隅濬梗
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
ViewState["CID"] = null;
if (Request.QueryString["cid"] != null)
{
string strCID = Request.QueryString["cid"].ToString();
ViewState["CID"] = CleanString.htmlInputText(strCID);
}
CData(); //分类列表绑定
PData(); //二手书列表绑定
HData(); //分类对应的热销二手书列表绑定
setSelectClass(); //绑定类别
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
setSelectClass(); //堂隅濬梗
if (Request.QueryString["class"] != null && Request.QueryString["text"] != null) //婓翋珜換徹懂腔刲坰腔濬倰睿珅豪靡
{
string strClass = Request.QueryString["class"].ToString();
string strText = Request.QueryString["text"].ToString();
strClass = CleanString.htmlInputText(strClass);
strText = CleanString.htmlInputText(Server.UrlDecode(strText));
CData(); //煦濬蹈桶堂隅
getSelectResult(strClass, strText); //脤戙
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
setSelectClass(); //绑定类别
if (Request.QueryString["class"] != null && Request.QueryString["text"] != null) //在主页传过来的搜索的类型和二手书名
{
string strClass = Request.QueryString["class"].ToString();
string strText = Request.QueryString["text"].ToString();
strClass = CleanString.htmlInputText(strClass);
strText = CleanString.htmlInputText(Server.UrlDecode(strText));
CData(); //分类列表绑定
getSelectResult(strClass, strText); //查询
}
}
}
private void ibtnSelect_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string strOrderid = txtOrderid.Text.Trim();
string strName = txtName.Text.Trim();
string strEmail = txtEmail.Text.Trim();
if (strOrderid == String.Empty || strName == String.Empty || strEmail == String.Empty)
{
Response.Write("<script>");
Response.Write("alert('订单相应资料不能为空!!!');");
Response.Write("</script>");
return;
}
strOrderid = CleanString.htmlInputText(strOrderid);
strName = CleanString.htmlInputText(strName);
strEmail = CleanString.htmlInputText(strEmail);
getOrderData(strOrderid, strName, strEmail); //获取订单信息
}
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()));
}
protected void btnOK_Click(object sender, System.EventArgs e)
{
string strUName = txtUserName.Text.Trim();
string strUPhone = txtUserPhone.Text.Trim();
string strUEmail = txtEmail.Text.Trim();
string strMTitle = txtTitle.Text.Trim();
string strMContent = txtContent.Text.Trim();
if (strUEmail == String.Empty || strMTitle == String.Empty || strMContent == String.Empty)
{
Response.Write("<script>");
Response.Write("alert('请把必填项添上!!!');");
Response.Write("</script>");
return;
}
if (strMContent.Length > 300)
{
Response.Write("<script>");
Response.Write("alert('内容太长了..(300字以内)!!!');");
Response.Write("</script>");
return;
}
//防止恶意刷信息
if (Session["messageCheck"] != null)
{
DateTime myDTime = (DateTime)Session["messageCheck"];
if (myDTime.AddMilliseconds(30000) > DateTime.Now)
{
Response.Write("<script>");
TimeSpan myTime = DateTime.Now - (DateTime)Session["messageCheck"];
Response.Write("alert('不能频繁提交,请在" + (30 - myTime.Seconds) + "秒后继续!!!');");
Response.Write("</script>");
return;
}
}
//过滤输入字符串
strUName = CleanString.htmlInputText(strUName);
strUPhone = CleanString.htmlInputText(strUPhone);
strUEmail = CleanString.htmlInputText(strUEmail);
strMTitle = CleanString.htmlInputText(strMTitle);
strMContent = CleanString.htmlInputText(strMContent);
string mySql = "insert into [message](UName,UPhone,UEmail,MTitle,MContent,Pubdate) values('" +
strUName + "','" + strUPhone + "','" + strUEmail + "','" + strMTitle
+ "','" + strMContent + "','" + DateTime.Now + "')";
DBConn myDB = new DBConn();
myDB.ExecuteNonQuery(mySql);
myDB.Close();
Session["messageCheck"] = DateTime.Now; //防止恶意刷信息 记录提交时间
Response.Write("<script>");
Response.Write("alert('成功提交！')");
Response.Write("</script>");
txtUserName.Text = "";
txtUserPhone.Text = "";
txtEmail.Text = "";
txtTitle.Text = "";
txtContent.Text = "";
}