±ÏÒµÉè¼Æ(ÂÛÎÄ)-ÆóÒµÈËʹÜÀíϵͳ(º¬Ô´³ÌÐò) ÏÂÔØ±¾ÎÄ

17 else

{Response.Redirect(\}}

protected void Delete_Click(object sender, EventArgs e) {if ((string)Session[\{ if ((string)Session[\¹ÜÀíÔ±\{string id = (string)Session[\

string sql = \string connstr =

ConfigurationManager.ConnectionStrings[\String;

SqlConnection Sqlconn = new SqlConnection(connstr); Sqlconn.Open();

SqlCommand sc = new SqlCommand(sql, Sqlconn); sc.ExecuteNonQuery(); Sqlconn.Close();

Response.Redirect(\} else

{Response.Write(\Ö»ÓйÜÀíÔ±²Å¿ÉÒÔ½øÐд˲Ù×÷')\

}} else

{Response.Redirect(\3.3.3 ²¿ÃÅÐÅÏ¢Áбí

²¿ÃÅÐÅÏ¢ÁбíÖ÷ÒªÊÇ»ã×ÜÏÔʾËùÓв¿ÃŵÄÐÅÏ¢£¬ÕâÀïÖ÷ÒªÓõ½µÄ¼¼ÊõÊý¾Ý¿âµÄ°ó¶¨¸úµ¼Èë¡£ÒªÕýÈ·µÄ°ó¶¨Êý¾Ý±íTb_departmentÈ»ºóµ¼Èëÿһ¸ö²¿ÃŵÄÐÅÏ¢£¬¸ù¾Ý¸÷×ֶεÄ˳ÐòÒ»´ÎÏÔʾ:²¿ÃűàºÅ×÷ΪÖ÷¼üÏÔʾÔÚǰ£¬È»ºóÒÀ´ÎÏÔʾ²¿ÃÅÃû³Æ¡¢ÁªÏµµç»°¡¢ÁªÏµµØÖ·¡¢¸ºÔðÈË¡¢ºÍËùÊô²¿ÃÅ¡£Õâ¸ö˳ÐòÊǸúǰÁ½¸öµ¥ÔªÌí¼Ó²¿ÃÅÐÅÏ¢ºÍÃÅÏêϸÐÅÏ¢µÄÊý¾Ý±í½øÐйØÏµ´¦ÀíµÄ£¬Ã¿¸öµ¥Ôª¶¼ÊÇͬ²½´¦ÀíÒ»¸öÊý¾Ý¿â±íµÄ¡£ÔÚÕâ¸öµ¥ÔªÄ£¿éÉÏ£¬Ò»°ãÓû§ºÍ¹ÜÀíÔ±Ö®¼äµÄȨÏÞÊÇÒ»ÑùµÄ£¬¶¼ÊDz鿴²¿ÃÅÐÅÏ¢µÄÁÐ±í¡£µã»÷µÚÒ»Ïî¿ÉÒÔÏÔʾ²¿ÃŵÄÏêϸÐÅÏ¢¡£²¿ÃÅÐÅÏ¢ÁбíµÄ½çÃæÉè¼ÆÈçͼËùʾ:

ͼ3-5 ²¿ÃÅÐÅÏ¢ÁбíÉè¼ÆÍ¼ ²¿ÃÅÐÅÏ¢ÁÐ±í¹¦ÄÜʵÏÖ´úÂë:

public partial class WebFiles_Department_List_Depart : System.Web.UI.Page

{protected void Page_Load(object sender, EventArgs e) {if(!IsPostBack) Bind(); 18 }

private void Bind() {SqlConnection con = new

SqlConnection(ConfigurationManager.ConnectionStrings[\n\

string sql = \²¿ÃűàºÅ,D_Name ²¿ÃÅÃû³Æ,D_Tel ÁªÏµµç»°,D_Address ÁªÏµµØÖ·,D_Chief ¸ºÔðÈË,D_Belong ËùÊô²¿ÃÅrom [Tb_department]\

SqlDataAdapter sda = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); sda.Fill(ds, \con.Close();

ListDepart.DataSource = ds.Tables[\ListDepart.DataBind(); }

protected void ListDepart_PageIndexChanging(object sender, GridViewPageEventArgs e)

{ListDepart.PageIndex = e.NewPageIndex; DataBind(); },

3.3.4 ²¿ÃÅÐÅÏ¢ËÑË÷

ÔÚÕâÒ»¸öµ¥ÔªÄ£¿éÖÐÖ»ÒªÊäÈë·ûºÏϵͳµÄËÑË÷Ìõ¼þ£¬²¿ÃÅÐÅÏ¢ËÑË÷Õâһģ¿éÊÇÏòËùÓеÄÓû§¿ª·ÅµÄ¡£²¿ÃÅÐÅÏ¢ËÑË÷ÊǸù¾Ý²¿ÃÅÖ÷Òª¹Ø¼ü×ֶμìË÷(²¿ÃűàºÅ¡¢²¿ÃÅÃû³Æ¡¢¸ºÔðÈË)£¬È»ºóÌø³öÓû§ÏëÒªËÑË÷µÄ²¿ÃÅ£¬²¿ÃÅÐÅÏ¢Ö÷ÒªÉè¼Æ·½·¨¾ÍÊÇÊ×ÏȸúÊý¾Ý±íTb_department²¢µ¼È룬ȻºóÔÚ֮ǰÉè¼Æ²¼¾Ö±í¸ñ¹¤¾ßµÄ»ù´¡Ö®ÉÏÌí¼ÓÒ»¸ö DropDownList¿Ø¼þ£¬È»ºóÌí¼ÓÒ»¸ö²éѯ°´Å¥µÄʼþ¡£¸Ãľ¿éÖ÷ÒªÊǸúÊý¾Ý±íTb_department°ó¶¨Á¬½ÓµÄ¡£²¿ÃÅÐÅÏ¢ËÑË÷Ä£¿éµÄÔËÐÐЧ¹ûÈçͼËùʾ:

ͼ3-6 ²¿ÃÅÐÅÏ¢ËÑË÷½çÃæ ²¿ÃÅÐÅÏ¢ËÑË÷¹¦ÄÜʵÏֵĴúÂë:

public partial class WebFiles_Department_Search_Depart : System.Web.UI.Page

{ protected void brn_search_Click(object sender, EventArgs e) {if (role.SelectedValue == \²¿ÃűàºÅ\{if (TxtContent.Text.Trim() == \

{Response.Write(\²¿ÃűàºÅ²»ÄÜΪ¿Õ!')\} else 19

{string sql = \²¿ÃűàºÅ,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 == \²¿ÃÅÃû³Æ\