?? 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 + -