protected void btn_search_Click(object sender, EventArgs e)
{
if (role.SelectedValue == "员工编号")
{
if (TxtContent.Text.Trim() == "")
{
Response.Write("<script>alert('员工编号不能为空!')</script>");
}
else
{
string sql = "select E_ID 员工编号,E_Name 员工姓名,E_Sex 员工性别,E_Birth 出生年月,E_Tel 联系电话,E_Address 联系地址 from [Tb_employee] where E_ID='" + TxtContent.Text.Trim() + "'";
user Search = new user();
SqlDataReader myreader = Search.Login(sql);
List_employee.DataSource = myreader;
List_employee.DataBind();
}
}
else
{
if (TxtContent.Text.Trim() == "")
{
Response.Write("<script>alert('员工姓名不能为空!')</script>");
}
else
{
string sql = "select E_ID 员工编号,E_Name 员工姓名,E_Sex 员工性别,E_Birth 出生年月,E_Tel 联系电话,E_Address 联系地址 from [Tb_employee] where E_Name='" + TxtContent.Text.Trim() + "'";
user Search = new user();
SqlDataReader myreader = Search.Login(sql);
List_employee.DataSource = myreader;
List_employee.DataBind();
}
}
}
protected void brn_search_Click(object sender, EventArgs e)
{
if (role.SelectedValue == "部门编号")
{
if (TxtContent.Text.Trim() == "")
{
Response.Write("<script>alert('部门编号不能为空!')</script>");
}
else
{
string sql = "select D_ID 部门编号,D_Name 部门名称,D_Tel 联系电话,D_Address 联系地址,D_Chief 负责人,D_Belong 所属部门 from [Tb_department] where [D_ID]='" + TxtContent.Text.Trim() + "'";
user Search = new user();
SqlDataReader myreader = Search.Login(sql);
List_employee.DataSource = myreader;
List_employee.DataBind();
}
}
else if (role.SelectedValue == "部门名称")
{
if (TxtContent.Text.Trim() == "")
{
Response.Write("<script>alert('部门名称不能为空!')</script>");
}
else
{
string sql = "select D_ID 部门编号,D_Name 部门名称,D_Tel 联系电话,D_Address 联系地址,D_Chief 负责人,D_Belong 所属部门 from [Tb_department] where [D_Name]='" + TxtContent.Text.Trim() + "'";
user Search = new user();
SqlDataReader myreader = Search.Login(sql);
List_employee.DataSource = myreader;
List_employee.DataBind();
}
}
else
{
if (TxtContent.Text.Trim() == "")
{
Response.Write("<script>alert('负责人不能为空!')</script>");
}
else
{
string sql = "select D_ID 部门编号,D_Name 部门名称,D_Tel 联系电话,D_Address 联系地址,D_Chief 负责人,D_Belong 所属部门 from [Tb_department] where [D_Chief]='" + TxtContent.Text.Trim() + "'";
user Search = new user();
SqlDataReader myreader = Search.Login(sql);
List_employee.DataSource = myreader;
List_employee.DataBind();
}
}
}
