C#-经典购物车流程全代码6页

1、C#购物车及后台代码C#程序语言一.防止SQL注入public static bool SqlFilter2(string InText) string word = and|exec|insert|select|delete|update|chr|mid|master|or|truncate|char|declare|join|;if (InText = null)return false;foreach (string str_t in word.Split(|)if (InText.ToLower().IndexOf(str_t + ) -1) | (InText.ToLower().I

2、ndexOf( + str_t) -1) | (InText.ToLower().IndexOf(str_t) -1) return true;/返回有二.MD5加密using system.web.securitystring pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(TextBox2.Text,MD5);四.配置文件的加密与解密数据库连接字符串 0)dbcon.message(此产品编号已登记！);elseif (DropDownList1.SelectedItem.Text = 产品分类)dbcon.mess

3、age(请选择分类!);elseconn.Open();SqlCommand cmd=new SqlCommand (insert into shop(sortid, sortname, product, ,buy, inventory, discount, price, path, parentpath) values ( + TextBox6.Text + , + TextBox1.Text+ , + FCKeditor1.Value+ , + TextBox3.Text + , + TextBox3.Text+ , + TextBox4.Text+ , +(int.Parse(TextB

4、ox5.Text) * int.Parse(TextBox4.Text).ToString()+ , +Sessionpicid.ToString()+ , + DropDownList1.SelectedItem.Text + ), conn);int num = cmd.ExecuteNonQuery();conn.Close();if (num 0) dbcon.message(添加产品成功！);七用户登录状态的保存if (Sessionuid != null)string uid = ;|if (Requestid.ToString() != )uid = Requestid.ToSt

5、ring();if (!Page.IsPostBack)uid = username.Text;SqlDataReader rd = select(uid);八购物车a = e.CommandArgument.ToString();/if (SessionID != null)/如果用户没有登录/ if (SessionCart = null)/如果购物篮不存在/ Response.Write(alert(1);this.BuildCart();/创建购物篮并将商品存入else/购物篮存在 DataTable cart = SessionCart as DataTable;if (this.E

6、xistBook(cart)/如果购物篮已存在该商品this.BuildSession(cart); /修改购物篮中的商品/Response.Redirect(buy car.aspx);/跳转到购物车界面/else/如果没有登录，跳转到登录界面/Response.Redirect(denglu.aspx);/public bool ExistBook(DataTable cart) foreach (DataRow dr in cart.Rows)if (drQID.ToString()=a)drNUM = Convert.ToInt32(drNUM) + 1;SessionCart = c

7、art;/Response.Redirect(Cart.aspx);return true;public void BuildCart()/创建购物车DataTable cart = new DataTable();/已经创建了表，但是没有字段cart.Columns.Add(QID);cart.Columns.Add(ID);cart.Columns.Add(NUM);cart.Columns.Add(IID);cart.Columns.Add(name);cart.Columns.Add(jiage);/Response.Write(alert(创建了表);/cart表中已有5个字段/将点

8、击的商品加入购物车中this.BuildSession(cart);/往cart中添加一条记录/ / 添加新书/ / public void BuildSession(DataTable cart)/新建一个数据行的记录DataRow dr = cart.NewRow();SqlDataReader rd=select(a);if (rd.Read()drQID = a;/存商品编号drID = rd1;/存商品名称drNUM = 1;/存商品数量driid = rd2;drname = rd3;/存入单价drjiage = rd4;/存入商品图片地址cart.Rows.Add(dr);/将数

9、据行加入到cart表中/Response.Write(alert(添加了记录);/Response.Write(rd1);/Response.Write(rd2);/Response.Write(rd3);/Response.Write(rd4);SessionCart = cart;/将数据表cart的值存入session保存/Response.Write(alert(购买成功);RegisterStartupScript(, alert(购买成功);九.计算总价if (Sessioncart = null)Response.Write(alert(购物车为空，请挑选商品);window.l

10、ocation.href=shengri.aspx?id=1;); DataTable cart = (DataTable)Sessioncart;GridView1.DataSource = cart;GridView1.DataBind();int NUM = 0;foreach (DataRow dr in cart.Rows)NUM += int.Parse(drNUM.ToString() * int.Parse(drjiage.ToString();Label3.Text = NUM.ToString();十删除时跳出对话框双击GridView的OnRowDataBound事件；protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)if (e.Row.RowType = DataControlRowType.DataRow)if (e.Row.RowState = DataControlRowState.Normal | e