protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
if (Page.IsValid)
{
Departmentmr department = new Departmentmr(); //创建Departmentmr对象
department.DepartmentId = Convert.ToInt32(txtDepartmentId.Text.Trim());
if (!department.CheckDepartment(department.DepartmentId)) //使用CheckDepartment方法验证是否存在
{
department.DepartmentId = Convert.ToInt32(txtDepartmentId.Text.Trim());
department.DepartmentName = txtDepartmentName.Text;
if (department.InsertByStr())
{
lblMessage.Text = "成功插入该部门信息！";
Server.Transfer("DepartmentManage.aspx");
}
else
{
lblMessage.Text = "添加部门失败！";
}
}
else//用户存在，给出提示
{
lblMessage.Text = "数据库中存在具有该编号的部门，请重新输入！";
}
}
}
private void GridViewBind()
{
Departmentmr department = new Departmentmr(); //创建Usersmr类对象user
DataSet ds = department.QueryDepartment(); //使用Usersmr类QueryUsers方法查询所有用户信息
GridView1.DataSource = ds; //为GridView控件设置数据源
GridView1.DataBind(); //GridView控件绑定数据
}
//GridView控件RowDeleting事件
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string departmentid = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出要删除记录的主键值
Departmentmr department = new Departmentmr(); //创建Departmentmr类对象department
if (department.DeleteByStr(departmentid)) //根据主键使用DeleteByProc方法删除用户
{
Response.Write("<script language=javascript>alert('删除成功!')</script>");
}
else
{
Response.Write("<script language=javascript>alert('删除失败!')</script>");
}
GridView1.EditIndex = -1;
GridViewBind();//重新绑定数据
}
//GridView控件RowUpdating事件
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string departmentid = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出记录的主键值
Departmentmr department = new Departmentmr();
department.DepartmentName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtDepartmentName")).Text;
if (department.UpdateByStr(departmentid))//使用Usersmr类UpdateByProc方法修改用户信息
{
GridViewBind();
Response.Write("<script language=javascript>alert('修改成功!')</script>");
}
else
{
Response.Write("<script language=javascript>alert('修改成功!')</script>");
}
GridView1.EditIndex = -1;
GridViewBind();
}
