//需要传值主页面
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>");
}
}