adduser.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 adduser : System.Web.UI.Page
{
    SqlConnection cn;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["branch"].ToString() == "0")
        {
            
        }
        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 sysuser where Login=@user_id", cn);
        cm.Parameters.Add("@user_id", SqlDbType.VarChar, 20);
        cm.Parameters["@user_id"].Value = userid.Text;
        SqlDataReader dr = cm.ExecuteReader();
        if (dr.Read())
        {
            args.IsValid = false;
        }
        else
        {
            args.IsValid = true;
        }
        cn.Close();
    }
    protected void Btn_ok_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            SqlCommand cm = new SqlCommand("Addsysuser", cn);
            cm.CommandType = CommandType.StoredProcedure;
            cm.Parameters.Add(new SqlParameter("@Login", SqlDbType.VarChar, 20));
            cm.Parameters.Add(new SqlParameter("@password", SqlDbType.VarChar, 50));
            cm.Parameters.Add(new SqlParameter("@name", SqlDbType.VarChar, 50));
            cm.Parameters.Add(new SqlParameter("@branch", SqlDbType.Int, 4));
          

            cm.Parameters["@Login"].Value = userid.Text;
            cm.Parameters["@password"].Value = userid.Text;
            cm.Parameters["@name"].Value = name.Text;
            cm.Parameters["@branch"].Value = Ddl_kind.SelectedItem.Value;
         
            cm.Connection.Open();
            try
            {
                cm.ExecuteNonQuery();
                Response.Redirect("edituser.aspx");

            }
            catch (SqlException)
            {
                Lbl_note.Text = "添加失败";
                Lbl_note.Style["color"] = "red";
            }
            cm.Connection.Close();
        }
    }
    protected void Btn_cancel_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("adduser.aspx");
    }
}