homeadminGoodhome.aspx
(完整代码) 2KB<%@ Page Language="C#" MasterPageFile="~/homeAdmin.master" AutoEventWireup="true" CodeFile="homeadminGoodhome.aspx.cs" Inherits="adminGoodhome" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table style="width: 778px" border="1">
<tr>
<td colspan="3">
<div align="center">
<br />
优秀宿舍如下:<asp:GridView ID="GridView1" runat="server" Width="535px" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" DataKeyNames="寝室长学号">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="区域名" HeaderText="区域名" SortExpression="区域名" />
<asp:BoundField DataField="楼栋名" HeaderText="楼栋名" SortExpression="楼栋名" />
<asp:BoundField DataField="寝室号" HeaderText="寝室号" SortExpression="寝室号" />
<asp:BoundField DataField="寝室分数" HeaderText="寝室分数" SortExpression="寝室分数" />
<asp:BoundField DataField="寝室长" HeaderText="寝室长" SortExpression="寝室长" />
<asp:BoundField DataField="寝室长学号" HeaderText="寝室长学号" ReadOnly="True" SortExpression="寝室长学号" />
</Columns>
</asp:GridView>
</div>
<div align="center">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:studHomeConnectionString %>"
SelectCommand="SELECT eare.eareName AS 区域名, flood.floodName AS 楼栋名, home.homeNo AS 寝室号, home.homefen AS 寝室分数, student.studName AS 寝室长, student.studNo AS 寝室长学号 FROM eare INNER JOIN flood ON eare.eareID = flood.eareID INNER JOIN home ON flood.floodID = home.floodID INNER JOIN student ON student.homeID = home.homeID AND student.shenfen = '寝室长' AND home.homefen > '85'">
</asp:SqlDataSource>
</div>
</td>
</tr>
</table>
</asp:Content>
24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明
AI 解读 AI
登录后可用,每次 10 算力,解读结果公开显示在下面。
还没有人解读过这个文件。