1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12public partial class WebFiles_Department_Search_Depart : System.Web.UI.Page
13...{
14    protected void Page_Load(object sender, EventArgs e)
15    ...{
16
17    }
18    protected void brn_search_Click(object sender, EventArgs e)
19    ...{
20        if (role.SelectedValue == "部门编号")
21        ...{
22            if (TxtContent.Text.Trim() == "")
23            ...{
24                Response.Write("<script>alert('部门编号不能为空!')</script>");
25            }
26            else
27            ...{
28                string sql = "select D_ID 部门编号,D_Name 部门名称,D_Tel 联系电话,D_Address 联系地址,D_Chief 负责人,D_Belong 所属部门 from [Tb_department] where [D_ID]='" + TxtContent.Text.Trim() + "'";
29                user Search = new user();
30                SqlDataReader myreader = Search.Login(sql);
31                List_employee.DataSource = myreader;
32                List_employee.DataBind();
33            }
34        }
35        else if (role.SelectedValue == "部门名称")
36        ...{
37            if (TxtContent.Text.Trim() == "")
38            ...{
39                Response.Write("<script>alert('部门名称不能为空!')</script>");
40            }
41            else
42            ...{
43                string sql = "select D_ID 部门编号,D_Name 部门名称,D_Tel 联系电话,D_Address 联系地址,D_Chief 负责人,D_Belong 所属部门 from [Tb_department] where [D_Name]='" + TxtContent.Text.Trim() + "'";
44                user Search = new user();
45                SqlDataReader myreader = Search.Login(sql);
46                List_employee.DataSource = myreader;
47                List_employee.DataBind();
48            }
49        }
50        else
51        ...{
52            if (TxtContent.Text.Trim() == "")
53            ...{
54                Response.Write("<script>alert('负责人不能为空!')</script>");
55            }
56            else
57            ...{
58                string sql = "select D_ID 部门编号,D_Name 部门名称,D_Tel 联系电话,D_Address 联系地址,D_Chief 负责人,D_Belong 所属部门 from [Tb_department] where [D_Chief]='" + TxtContent.Text.Trim() + "'";
59                user Search = new  user();
60                SqlDataReader myreader = Search.Login(sql);
61                List_employee.DataSource = myreader;
62                List_employee.DataBind();
63            }
64        }
65    }
66}
67