chongqian.aspx.cs

Asp.net购物车示例源码[VS2005] 可以实现购物车基本功能：在线购物、在线结算、在线充值、在线支付（未完成） 有用户注册功能 默认用户密码51aspx 数据库文件在App

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class chongqian : System.Web.UI.Page
{
    static decimal sum1,sum2,sum3,sum4;
    protected void Page_Load(object sender, EventArgs e)
    {
        //接受传送数据
        Label7.Text = Request.QueryString["id"];
        sum2 = decimal.Parse(Request.QueryString["total"]);
        sum1 = decimal.Parse(Request.QueryString["yue"]);
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string sUrl = "qianbao.aspx?id=" + Label7.Text + "&total=" + sum2.ToString();
        Response.Redirect(sUrl);
    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        if (TextBox1.Text != "" && TextBox2.Text != "" && TextBox3.Text != "")
        {
            SqlConnection sqlcon;
            string strCon = "Data Source=(local);Database=db_11;Uid=sa;Pwd=";
            string sqlstr = "select id,mima ,money from yinhang where id='" + this.TextBox1.Text.Trim() + "' and mima='" + this.TextBox2.Text.Trim() + "'";
            sqlcon = new SqlConnection(strCon);
            SqlCommand com = new SqlCommand(sqlstr, sqlcon);
            sqlcon.Open();
            SqlDataReader read = com.ExecuteReader();
            if (read.Read())
            {
                read.Close();

                SqlDataAdapter da = new SqlDataAdapter(sqlstr, sqlcon);
                DataSet ds = new DataSet();
                da.Fill(ds);
                sqlcon.Close();

                DataRow[] row1 = ds.Tables[0].Select();
                foreach (DataRow dr in row1)
                {
                    sum3 = decimal.Parse(dr["money"].ToString().Trim());

                }


                sum4 = decimal.Parse(TextBox3.Text.ToString());
                if (sum3 >= sum4)
                {   
                    ////////////////////////////////从银行取钱
                    sum3 -= sum4;
                    string strCon3 = "Data Source=(local);Database=db_11;Uid=sa;Pwd=";
                    string sqlstr3 = "update yinhang set money = " + sum3 + " where  id= '" + this.TextBox1.Text.Trim() + " '";
                    SqlConnection sqlcon3 = new SqlConnection(strCon3);
                    SqlCommand com3 = new SqlCommand(sqlstr3, sqlcon3);
                    sqlcon3.Open();
                    com3.ExecuteNonQuery();
                    sqlcon3.Close();
                    ///////////////////////////////////////往钱包里存钱
                    sum1 += sum4;
                    string strCon2 = "Data Source=(local);Database=db_11;Uid=sa;Pwd=";
                    string sqlstr2 = "update tb_Member111 set money = " + sum1 + " where  id= '" + this.Label7.Text.Trim() + " '";
                    SqlConnection sqlcon2 = new SqlConnection(strCon2);
                    SqlCommand com2 = new SqlCommand(sqlstr2, sqlcon2);
                    sqlcon2.Open();
                    com2.ExecuteNonQuery();
                    sqlcon2.Close();

                    Response.Write("<script>alert('充值成功')</script>");
                    TextBox1.Text = "" ;
                    TextBox3.Text = "";
                }
                else
                {
                    Response.Write("<script>alert('银行帐户余额不足')</script>");
                }
            }
            else
                Response.Write("<script>alert('用户名或密码错误')</script>");
        }
        else
        {
            Response.Write("<script>alert('信息不完整')</script>");
        }
    
    }
}