Login.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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 Login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
   
    protected void btnConfirm_Click(object sender, EventArgs e)
    {
        //如果用户名和密码没有输入，给用户一个提示
        if (txtUserName.Text == "" || txtUserPwd.Text == "")
        {
            Page.RegisterStartupScript("", "<script>alert('请输入用户名和密码');</script>");
        }
        else
        {
            //从数据库检索当前输入的用户名和密码是否存在
            string connstr = ConfigurationManager.ConnectionStrings["SMDBConnectionString"].ConnectionString;
            SqlConnection conn = new SqlConnection(connstr);
            conn.Open();
            string sqlstr = " select * from t_vip where hy_Username=@hy_Username and hy_Passwod=@hy_Passwod";
            SqlCommand cmd = new SqlCommand(sqlstr, conn);
            SqlParameter para1 = new SqlParameter("@hy_Username", txtUserName.Text);
            cmd.Parameters.Add(para1);
            SqlParameter para2 = new SqlParameter("@hy_Passwod", txtUserPwd.Text);
            cmd.Parameters.Add(para2);
            SqlDataReader sdr = cmd.ExecuteReader();
            if (sdr.Read())
            {
                int hyVipID = Convert.ToInt16(sdr["hy_VipID"]);
                int ScarID;
                sdr.Close();
                //判断当前用户是否已经有购物车，如果没有就创建一个
                sqlstr = " select * from T_ShoppingCar where hy_VipID = @hy_VipID";
                cmd = new SqlCommand(sqlstr, conn);
                para1 = new SqlParameter("@hy_VipID", hyVipID);
                cmd.Parameters.Add(para1);
                sdr = cmd.ExecuteReader();
                if (sdr.Read())
                {
                    ScarID = Convert.ToInt16(sdr["Scar_ID"]);
                    sdr.Close();
                }
                else
                {
                    sdr.Close();
                    sqlstr = " insert into T_ShoppingCar values(@hy_VipID,@Scar_Time)";
                    cmd = new SqlCommand(sqlstr, conn);