addclient.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 addclient : System.Web.UI.Page
{
    SqlConnection cn;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["branch"].ToString() == "0" || Session["branch"].ToString() == "2")
        {
           
        }
        else
        {
            Response.Write("您不是合法用户，请登入后再操作，<a href='default.aspx'>返回登录</a>");
            Page.Response.End();
        }
        string strconn = ConfigurationSettings.AppSettings["ConnectionString"];
        cn = new SqlConnection(strconn);
        
    }
    private void Cv_id_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
    {
        //测试客户编号是否重复
        cn.Open();
        SqlCommand cm = new SqlCommand("select * from client where client_id=@client_id", cn);
        cm.Parameters.Add("@client_id", SqlDbType.VarChar, 20);
        cm.Parameters["@client_id"].Value = client_id.Text;
        SqlDataReader dr = cm.ExecuteReader();
        if (dr.Read())
        {
            args.IsValid = false;
        }
        else
        {
            args.IsValid = true;
        }
        cn.Close();
    }
    protected void Btn_add_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            SqlCommand cm = new SqlCommand("Addclient", cn);
            cm.CommandType = CommandType.StoredProcedure;
            cm.Parameters.Add(new SqlParameter("@client_id", SqlDbType.VarChar, 20));
            cm.Parameters.Add(new SqlParameter("@client_name", SqlDbType.VarChar, 20));
            cm.Parameters.Add(new SqlParameter("@client_charge", SqlDbType.VarChar, 20));
            cm.Parameters.Add(new SqlParameter("@client_level", SqlDbType.Int, 4));
            cm.Parameters.Add(new SqlParameter("@address", SqlDbType.VarChar, 50));
            cm.Parameters.Add(new SqlParameter("@email", SqlDbType.VarChar, 30));
            cm.Parameters.Add(new SqlParameter("@tell", SqlDbType.VarChar, 20));
            

            cm.Parameters["@client_id"].Value = client_id.Text;
            cm.Parameters["@client_name"].Value = client_name.Text;
            cm.Parameters["@client_charge"].Value = client_person.Text;
            cm.Parameters["@client_level"].Value = Ddl_level.SelectedItem.Value;
            cm.Parameters["@address"].Value = address.Text;
            cm.Parameters["@email"].Value = Email.Text;
            cm.Parameters["@tell"].Value = Tell.Text;
           

            cm.Connection.Open();
            try
            {
                cm.ExecuteNonQuery();
                Lbl_note.Text = "添加成功";
                Response.Redirect("editclient.aspx");
            }
            catch (SqlException)
            {
                Lbl_note.Text = "添加失败";
                Lbl_note.Style["color"] = "red";
            }
            cm.Connection.Close();
        }
    }
    protected void Btn_reset_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("addclient.aspx");
    }
}