添加代码2.0中

 //主页面的代码并传值过去到add页面

protected void Button2_Click(object sender, EventArgs e)
    {
        try
        {
            string strAdd = this.TreeView1.SelectedNode.Value.ToString();
            Response.Redirect("AddDepartment.aspx?addName=" + strAdd + "");
        }

        catch
        {

            Page.RegisterStartupScript("add", "<script language='javascript'>alert('请点击要添加的名称');</script>");

        }    



     protected void Button2_Click(object sender, EventArgs e)
    {
        try
        {
            string strAdd = this.TreeView1.SelectedNode.Value.ToString();
            Response.Redirect("AddDepartment.aspx?addName=" + strAdd + "");
        }

        catch
        {

            Page.RegisterStartupScript("add", "<script language='javascript'>alert('请点击要添加部门到的上级部门名称');</script>");

        }      
         
               

    }
          
 

 // add页面的.代码
   public partial class AddDepartment : System.Web.UI.Page
{
    private void Page_Load(object sender, System.EventArgs e)
    {

        if (!IsPostBack)
        {
            try
            {

                string strAdd = Request.QueryString["addName"];

                string strAdd1 = Request.QueryString["addName"];

                string strinfU = " <B> 你现在添加的是为<B> " + strAdd + "<B> 的信息";
                this.lblAdd.Text = strinfU;

                string sqlAdd = "select * from Department where EM_deptCode = @strAdd ";

                string sqlFilter = "select EM_deptCode from department  where ParentID= @strAdd1";

                SqlConnection AddConnection = new SqlConnection(
               "Data Source=XIAOHUA;Initial Catalog=HRIS;User ID=sa");
                AddConnection.Open();

                SqlCommand comAdd = new SqlCommand(sqlAdd, AddConnection);
                SqlParameter parAdd = new SqlParameter("@strAdd", SqlDbType.VarChar);
                parAdd.Value = strAdd;
                comAdd.Parameters.Add(parAdd);

                SqlDataReader dr = comAdd.ExecuteReader();
                dr.Read();
                if (dr.HasRows)
                {

                    string f = dr["EM_deptCode"].ToString();
                    this.TopNum.Text =f;
             
                    this.txtTopdpName.Text = dr["EM_Dept"].ToString();

                }

               //*******添加时,部门编号的自动生成********

                SqlConnection conn = new SqlConnection(
               "Data Source=XIAOHUA;Initial Catalog=HRIS;User ID=sa");
                conn.Open();
                SqlCommand com = new SqlCommand(sqlFilter, conn);
                SqlParameter par = new SqlParameter("@strAdd1", SqlDbType.VarChar);
                par.Value = strAdd1;
                com.Parameters.Add(par);

                SqlDataAdapter myCommand = new SqlDataAdapter(com);

                DataSet ds = new DataSet();
                myCommand.Fill(ds, "ClassTable");

                DataTable dt = ds.Tables["ClassTable"];

                //当没有子部门时
                if (dt.Rows.Count < 1)
                {

                    //string o = dr["EM_deptCode"].ToString();
                    //this.Num.Text = o;
                    string o = dr["EM_deptCode"].ToString();
                    int h = Convert.ToInt32(o);
                    int p = h*100 + 1;//you  wen ti*
                    this.Num.Text = "0" + p.ToString();
              
                }
               
                //有子部门时
                else
                {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string strClassName = dt.Rows[i]["EM_DeptCode"].ToString();
                    int h1 = Convert.ToInt32(strClassName);
                    int p1 = h1 + 1;
                    this.Num.Text = "0"+ p1.ToString();
                    //this.Num.Text = strClassName.ToString();
                    //string str = "aaaa,caa";
                    //str = Regex.Replace(str, "aa", "bb");

                }

            }
            conn.Close();
            }

      

            catch
            {

                Page.RegisterStartupScript("S", "<script language='javascript'>alert('请选择你要添加的部门的上级部门的名称');</script>");
            }
        }
    }

//添加按纽代码
    protected void AddBtn_Click(object sender, EventArgs e)
    {
        //页面数据添加到数据库中
        string sql = "insert into Department (EM_Dept,EM_deptCode,SimpleName,Phone,ParentID,ParentName,Remark)values(@EM_Dept,@EM_deptCode,@SimpleName,@Phone,@ParentID,@ParentName,@Remark)";
        SqlConnection myConnection = new SqlConnection(
         "Data Source=XIAOHUA;Initial Catalog=HRIS;User ID=sa");
        myConnection.Open();
        SqlCommand com = myConnection.CreateCommand();
        com.CommandText = sql;
        SqlParameter[] par = new SqlParameter[7];
        par[0] = new SqlParameter("@EM_Dept",SqlDbType.VarChar,200);
        par[0].Value = this.Name.Text.ToString();

        par[1] = new SqlParameter("@EM_deptCode", SqlDbType.VarChar);
        par[1].Value = this.Num.Text.ToString();

        par[2] = new SqlParameter("@SimpleName", SqlDbType.VarChar);
        par[2].Value = this.SimpName.Text.ToString();

        par[3] = new SqlParameter("@ParentID", SqlDbType.VarChar);
        par[3].Value = this.TopNum.Text.ToString();

        par[4] = new SqlParameter("@Phone", SqlDbType.VarChar);
        par[4].Value = this.Phone.Text.ToString();

        par[5] = new SqlParameter("@ParentName", SqlDbType.VarChar);
        par[5].Value = this.txtTopdpName.Text.ToString();

        par[6] = new SqlParameter("@Remark", SqlDbType.VarChar ,200);
        par[6].Value = this.Remark.Text .ToString();

        foreach (SqlParameter pa in par)
        {
            com.Parameters.Add(pa);
       
        }
        try
        {
            if (com.ExecuteNonQuery() > 0)
            {

                Page.RegisterStartupScript("S", "<script language='javascript'>alert('添加成功');</script>");

            }
         
        }
        catch
        {
            myConnection.Close();
          
            Page.RegisterStartupScript("S", "<script language='javascript'>alert('部门编号不能够重复');</script>");
        }
      
      

    }