修改代码(2.0)

//需要传值主页面

protected void Button1_Click(object sender, EventArgs e)
    {

        try
        {
            string t = this.TreeView1.SelectedNode.Value.ToString();
            Response.Redirect("UpdateDepartment.aspx?name=" + t + "");
        }

        catch {
           
          
            Page.RegisterStartupScript("u", "<script language='javascript'>alert('请点击要修改的部门名称');</script>");
       
        }      
         
               
          
    }

//修改页面

public partial class UpdateDepartment : System.Web.UI.Page
{
  
    private void Page_Load(object sender, System.EventArgs e)
    {

        if (!IsPostBack)
        {
            string str = Request.QueryString["name"];

            string strinfU = " <B> 你现在修改的是部门编号为<B> " + str + "<B> 的部门信息";
            this.lblUpdate.Text = strinfU;

            string sql1 = "select * from Department where EM_deptCode =@str";
            SqlConnection myConnection = new SqlConnection(
           "Data Source=XIAOHUA;Initial Catalog=HRIS;User ID=sa");
            myConnection.Open();
            SqlCommand com = new SqlCommand(sql1, myConnection);
            SqlParameter par = new SqlParameter("@str", SqlDbType.VarChar);
            par.Value = str;
            com.Parameters.Add(par);

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

                this.Name1.Text = dr["EM_Dept"].ToString();
                this.Num1.Text = dr["EM_deptCode"].ToString();
                this.SinpName1.Text = dr["SimpleName"].ToString();
                this.TopNum1.Text = dr["ParentID"].ToString();
                this.Phone1.Text = dr["Phone"].ToString();
                this.txtTopdpName1.Text = dr["ParentName"].ToString();
                this.Remark1.Text = dr["Remark"].ToString();

 

 

            }
            dr.Close();
            myConnection.Close();
        }
       

}

           
            //上级部门名称自动弹出窗体，点击返回给文本框
            //this.txtTopdpName1.Attributes["onClick"] = "TopdpName1Openner1()";

            //this.Num1.Attributes["onClick"] = "DpCodeOpenner()";

      

    protected void UpdateBtn_Click(object sender, EventArgs e)
    {

        //页面数据根据部门编号修改，并添加到数据库中

        string sql = "update  Department set EM_Dept=@EM_Dept,EM_deptCode=@EM_deptCode,SimpleName=@SimpleName,Phone=@Phone,ParentID=@ParentID,ParentName=@ParentName,Remark=@Remark where EM_deptCode=@EM_deptCode";
        SqlConnection Connn = new SqlConnection( "Data Source=XIAOHUA;Initial Catalog=HRIS;User ID=sa");
        Connn.Open();
        SqlCommand com = Connn.CreateCommand();
        com.CommandText = sql;
        SqlParameter[] par = new SqlParameter[7];
        par[0] = new SqlParameter("@EM_Dept", SqlDbType.VarChar, 200);
        par[0].Value = this.Name1.Text.ToString();

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

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

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

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

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

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

        foreach (SqlParameter pa in par)
        {
            com.Parameters.Add(pa);
        }
        try
        {
            if (com.ExecuteNonQuery() > 0)
            {
                Page.RegisterStartupScript("S", "<script language='javascript'>alert('修改成功');</script>");
            }

        }
        catch
        {
            Connn.Close();

            Page.RegisterStartupScript("S", "<script language='javascript'>alert('请重新修改');</script>");
        }

 

 

    }