xiaohu.aspx.cs

一种模拟的手机计费软件

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

    }
    protected void xhqueding_Click(object sender, EventArgs e)
    {
        string connString = @"Data Source=.;Initial Catalog=shoujijifei;Integrated Security=True";
        using (SqlConnection conn = new SqlConnection(connString))
        {
            if ((TextBox1.Text.Trim() != "") && (TextBox2.Text.Trim() != ""))
            {
                conn.Open();
                string sql = "delete from Card WHERE CardNo='" + TextBox1.Text + "'";

                SqlCommand cmd = new SqlCommand(sql, conn);
                int i = cmd.ExecuteNonQuery();
                if (i == 1)
                {
                    Response.Write("<script>alert('卡号" + TextBox1.Text + "已被删除！')</script>");
                    TextBox1.Text = "";
                    TextBox2.Text = "";
                }
                else
                {
                    Response.Write("<script>alert('销户失败！该卡号不存在！')</script>");
                }
            }
            else
            {
                Response.Write("<script>alert('销户失败，卡号或密码不能为空！')</script>");

            }
        }
    }
    //    string CardNo = TextBox1.Text;
    //    DeleteCard(CardNo);
    //    Response.Write("<script>alert('卡号" + CardNo + "已被删除！')</script>");

    //}

    //public void DeleteCard(string CardNo)
    //{
    //    string ConnectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;
    //    SqlConnection conn = new SqlConnection();
    //    conn.ConnectionString = ConnectionString;
    //    conn.Open();
    //    SqlCommand comm = new SqlCommand();
    //    comm.Connection = conn;
    //    comm.CommandText = "usp_DeleteCard";
    //    comm.CommandType = CommandType.StoredProcedure;
    //    SqlParameter param1 = new SqlParameter("@CardNo", SqlDbType.Char, 11);
    //    param1.Direction = ParameterDirection.Input;
    //    param1.Value = CardNo;
    //    comm.Parameters.Add(param1);
    //    comm.ExecuteNonQuery();
    //    conn.Close();
    //}
    //protected void xhquxiao_Click(object sender, EventArgs e)
    //{
    //  TextBox1.Text = "";
    //    TextBox2.Text = "";
    //}
    protected void xhquxiao_Click(object sender, EventArgs e)
    {
        TextBox1.Text = "";
          TextBox2.Text = "";
    }
}