📄 borrowhistory.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="BorrowHistory.aspx.cs" Inherits="链接页面_BorrowHistory" %>
<!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>
</head>
<body>
<form id="form1" runat="server">
<div id="container">
<div id="header"><asp:Image ID="topiamge" runat="server" Width="100%" Height="100px" ImageUrl="~/Images/image.jpg"/></div>
<div id="maincontent" align="center"><asp:Button ID="mainpage" runat="server" Text="网站首页" OnClick="mainpage_Click"/>
<asp:Button ID="personinfo" runat="server" Text="个人信息" OnClick="personinfo_Click" />
<asp:Button ID="borrowbook" runat="server" Text="货物出库" OnClick="borrowbook_Click" />
<asp:Button ID="returnbook" runat="server" Text="货物入库" OnClick="returnbook_Click"/>
<asp:Button ID="history" runat="server" Text="出入库清单" OnClick="history_Click"/>
<asp:Button ID="changepwd" runat="server" Text="修改密码" OnClick="changepwd_Click" />
<asp:Button ID="logout" runat="server" Text="注销登录" OnClick="logout_Click"/><br />
<asp:Label ID="ReturnedLable" runat="server">入库货物:<br /></asp:Label><asp:GridView ID="ReturnedGridview" runat="server" AutoGenerateColumns="False" DataKeyNames="Snum,Booknum" DataSourceID="SqlDataSource3">
<Columns>
<asp:BoundField DataField="Returnnum" HeaderText="Returnnum" InsertVisible="False"
ReadOnly="True" SortExpression="Returnnum" />
<asp:BoundField DataField="Snum" HeaderText="Snum" ReadOnly="True" SortExpression="Snum" />
<asp:BoundField DataField="Booknum" HeaderText="Booknum" ReadOnly="True" SortExpression="Booknum" />
<asp:BoundField DataField="Bookname" HeaderText="Bookname" SortExpression="Bookname" />
<asp:BoundField DataField="Bookclass" HeaderText="Bookclass" SortExpression="Bookclass" />
<asp:BoundField DataField="Returnbookdate" HeaderText="Returnbookdate" SortExpression="Returnbookdate" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:MaterialsystemConnectionString %>"
SelectCommand="SELECT * FROM [Returnbook] WHERE ([Snum] = @Snum)">
<SelectParameters>
<asp:SessionParameter Name="Snum" SessionField="studentnumber" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:Label ID="NotReturnLable" runat="server">出库货物:<br /></asp:Label><asp:GridView ID="NotReturnGridview" runat="server" AutoGenerateColumns="False" DataKeyNames="Snum,Booknum" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="Borrownum" HeaderText="Borrownum" InsertVisible="False"
ReadOnly="True" SortExpression="Borrownum" />
<asp:BoundField DataField="Snum" HeaderText="Snum" ReadOnly="True" SortExpression="Snum" />
<asp:BoundField DataField="Booknum" HeaderText="Booknum" ReadOnly="True" SortExpression="Booknum" />
<asp:BoundField DataField="Bookname" HeaderText="Bookname" SortExpression="Bookname" />
<asp:BoundField DataField="Bookclass" HeaderText="Bookclass" SortExpression="Bookclass" />
<asp:BoundField DataField="Borrowbookdate" HeaderText="Borrowbookdate" SortExpression="Borrowbookdate" />
<asp:BoundField DataField="Shouldreturnbookdate" HeaderText="Shouldreturnbookdate"
SortExpression="Shouldreturnbookdate" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MaterialsystemConnectionString %>"
SelectCommand="SELECT * FROM [Borrowbook] WHERE ([Snum] = @Snum)">
<SelectParameters>
<asp:SessionParameter Name="Snum" SessionField="studentnumber" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -