{
throw new NotImplementedException(); }
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args) {
int i;
string myvalue = args.Value;
if (myvalue[0] != '1' || myvalue.Length != 11) {
args.IsValid = false; } else {
for (i = 1; i < myvalue.Length; i++) {
if (myvalue[i] < '0' || myvalue[i] > '9') {
args.IsValid = false; break; } }
if (i == myvalue.Length) {
args.IsValid = true; } } }
protected void Button2_Click(object sender, EventArgs e) {
name.Text = \ password.Text=\ repassword.Text = \ truename.Text = \
for (int i = 0; i < hb.Items.Count; i++) {
if (hb.Items[i].Selected == true) hb.Items[i].Selected = false; }
sex.SelectedItem.Value = \ mobile.Text = \ email.Text = \ qq.Text = \ age.Text = \} }
14
7.3首页界面功能实现
首页界面显示
首页是全部商品都显示出来的界面 using System;
using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;
using System.Web.UI.WebControls; using System.Data;
using System.Data.SqlClient; using System.Configuration;
public partial class WareShow : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
if (Session[\ {
Label3.Visible = false; HyperLink6.Visible =false; HyperLink7.Visible = true; HyperLink8.Visible = false; HyperLink9.Visible = false; }
else { Label3.Text = Session[\ HyperLink6.Visible = true; HyperLink7.Visible = false; HyperLink8.Visible = true; HyperLink9.Visible = true;
15
}
if (!IsPostBack) {
DatalistBind(); } }
protected void DatalistBind() {
string connstr =
ConfigurationManager.ConnectionStrings[\ SqlConnection conn = new SqlConnection(connstr); conn.Open();
PagedDataSource pd = new PagedDataSource();
pd.DataSource = SqlDataSource1.Select(DataSourceSelectArguments.Empty); pd.AllowPaging = true; pd.PageSize = 6;
pd.CurrentPageIndex = CurrentPage() - 1; DataList1.DataSource = pd; DataList1.DataBind();
Label1.Text = \第\页\ Label2.Text = \共\页\ if (!pd.IsFirstPage) {
Visible = true;
HyperLink2.NavigateUrl = \ 1).ToString();
HyperLink4.NavigateUrl = \ } else {
HyperLink2.Visible = false; HyperLink4.Visible = false; }
if (!pd.IsLastPage) {
HyperLink3.NavigateUrl = \ 1).ToString();
HyperLink5.NavigateUrl = \ } else {
HyperLink3.Visible = false; HyperLink5.Visible = false; } }
protected int CurrentPage() {
if (Request[\ {
16
return Convert.ToInt16(Request[\ } else {
return 1; } }
protected void DatiaList1_ItemCommand(object soure, DataListCommandEventArgs e) {
TextBox tb = (TextBox)e.Item.FindControl(\ int m = Convert.ToInt16(tb.Text);
if (Session[\ {
int spWareID = Convert.ToInt16(DataList1.DataKeys[e.Item.ItemIndex]); string connstr =
ConfigurationManager.ConnectionStrings[\
SqlConnection conn = new SqlConnection(connstr); conn.Open(); //链接数据库
string sqlstr = \ sp_WareID=@sp_WareID\
SqlCommand cmd = new SqlCommand(sqlstr, conn);
SqlParameter para1 = new SqlParameter(\ cmd.Parameters.Add(para1);
SqlParameter para2 = new SqlParameter(\ cmd.Parameters.Add(para2);
SqlDataReader sdr = cmd.ExecuteReader(); //查询这个用户有没有购买过此商品 if (sdr.Read()) {
int sid = Convert.ToInt16(sdr[\ int num = Convert.ToInt16(sdr[\ //读取购物号和商品数量 conn.Close(); conn.Open();
//对商品数进行+1操作 string sqlstr1 = \T_ShoppingInfo set Shop_Num = @Shop_Num WHERE (Shop_ID = @Shop_ID) and (SCarID = @SCarID)\
SqlCommand cmd1 = new SqlCommand(sqlstr1, conn);
SqlParameter para3 = new SqlParameter(\ para3.Value = num + m;
SqlParameter para4 = new SqlParameter(\ para4.Value = sid; SqlParameter para5 = new SqlParameter(\Session[\ cmd1.Parameters.Add(para5); cmd1.Parameters.Add(para3); cmd1.Parameters.Add(para4); cmd1.ExecuteNonQuery(); conn.Close(); }
17
else {
conn.Close(); conn.Open();
//插入一条新数据到购物信息表
string sqlstr1 = \
T_ShoppingInfo(SCarID,sp_WareID,Shop_Num) values (@SCarID,@sp_WareID,@Shop_Num)\ SqlCommand cmd1 = new SqlCommand(sqlstr1, conn);
SqlParameter para3 = new SqlParameter(\ para3.Value = Convert.ToInt16(Session[\ cmd1.Parameters.Add(para3);
SqlParameter para4 = new SqlParameter(\SqlDbType.Int); para4.Value = spWareID; cmd1.Parameters.Add(para4);
SqlParameter para5 = new SqlParameter(\ para5.Value =m;
cmd1.Parameters.Add(para5); cmd1.ExecuteNonQuery(); conn.Close(); }
Response.Redirect(\ Convert.ToInt16(Session[\ } else {
Page.RegisterStartupScript(\请登录 ');location.href='login.aspx';\ } } }
7.4购物车功能实现
会员购物车界面
18