📄 select_teacherall.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="select_teacherall.aspx.cs" Inherits="human_manage_system_teacher_manage_teacher_all_set_select_teacherall" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>查询教师综合信息</title>
<link href="~/css/mm.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<td style="width: 139px">
查询教师综合信息</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
</tr>
<tr>
<td style="width: 139px">
部门</td>
<td style="width: 100px">
<asp:DropDownList ID="tl_dept" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="dept_name" DataValueField="dept_ID">
</asp:DropDownList><br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:XTeamConnectionString %>"
SelectCommand="SELECT [dept_ID], [dept_name] FROM [dept]"></asp:SqlDataSource>
</td>
<td style="width: 100px">
教师</td>
<td style="width: 100px">
<asp:DropDownList ID="tl_teacher" runat="server" DataSourceID="SqlDataSource2" DataTextField="teacher_name" DataValueField="teacher_ID">
<asp:ListItem Selected="True">----请选择----</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:XTeamConnectionString %>"
SelectCommand="SELECT [teacher_ID], [dept_ID], [teacher_name] FROM [teacher_info] WHERE ([dept_ID] = @dept_ID)">
<SelectParameters>
<asp:ControlParameter ControlID="tl_dept" DefaultValue="1" Name="dept_ID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td style="width: 139px; height: 21px">
类型</td>
<td style="width: 100px; height: 21px">
<asp:DropDownList ID="tl_type" runat="server" Width="112px">
<asp:ListItem Selected="True">----请选择----</asp:ListItem>
<asp:ListItem>奖励</asp:ListItem>
<asp:ListItem>惩罚</asp:ListItem>
<asp:ListItem>其他</asp:ListItem>
</asp:DropDownList></td>
<td style="width: 100px; height: 21px">
</td>
<td style="width: 100px; height: 21px">
</td>
</tr>
<tr>
<td style="width: 139px; height: 11px;">
</td>
<td style="width: 100px; height: 11px;">
<asp:Button ID="Button1" runat="server" Text="查询" OnClick="Button1_Click" /></td>
<td style="width: 100px; height: 11px;">
</td>
<td style="width: 100px; height: 11px;">
</td>
</tr>
</table>
<br />
</div>
<asp:GridView ID="tl_info" runat="server" AutoGenerateColumns="False" Width="624px" DataKeyNames="teacher_allID" OnRowDataBound="tl_info_RowDataBound" OnRowDeleting="tl_info_RowDeleting" OnSelectedIndexChanged="tl_info_SelectedIndexChanged">
<Columns>
<asp:BoundField DataField="teacher_allID" ReadOnly="True" Visible="False" />
<asp:BoundField DataField="teacher_alltype" HeaderText="类型" />
<asp:BoundField DataField="teacher_allcontent" HeaderText="内容" />
<asp:HyperLinkField DataNavigateUrlFields="teacher_allID" DataTextField="teacher_allID"
DataTextFormatString="查看" HeaderText="详细信息" DataNavigateUrlFormatString="~/human_manage_system/teacher_manage/teacher_all_set/alt_teacherall.aspx?teacherallID={0}" />
<asp:CommandField ShowDeleteButton="True" />
</Columns>
</asp:GridView>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -