?? search_depart.aspx.cs
字號:
?using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class WebFiles_Department_Search_Depart : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
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 聯(lián)系電話,D_Address 聯(lián)系地址,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 聯(lián)系電話,D_Address 聯(lián)系地址,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 聯(lián)系電話,D_Address 聯(lián)系地址,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();
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -