📄 photomanage.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="photoManage.aspx.cs" Inherits="photoManage" %>
<%@ Register Src="UserLoginl.ascx" TagName="UserLoginl" TagPrefix="uc1" %>
<!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 type="text/css" href="css/UserLogin.css" rel="Stylesheet" />
</head>
<body>
<form id="form1" runat="server" enctype="multipart/form-data">
<div>
<table align="center" style="width: 768px">
<tr>
<td style="width: 764px; height: 21px; background-color: #d2e4fc">
<uc1:UserLoginl ID="UserLoginl1" runat="server" />
</td>
</tr>
<tr>
<td style="width: 764px; height: 21px">
<asp:GridView ID="GridView1" runat="server" DataKeyNames="PhotoID" DataSourceID="SqlDataSource1" AllowPaging="True" AutoGenerateColumns="False" OnPageIndexChanging="GridView1_PageIndexChanging" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" OnRowCommand="GridView1_RowCommand">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowInsertButton="True" ShowSelectButton="True" />
<asp:BoundField DataField="PhotoID" HeaderText="相片ID" Visible="False" />
<asp:BoundField DataField="PhotoTitle" HeaderText="相片标题" >
<ItemStyle Width="200px" />
<HeaderStyle Width="200px" />
</asp:BoundField>
<asp:BoundField DataField="PhotoDesc" HeaderText="相片说明" Visible="False" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Provider=SQLOLEDB;Data Source=.;Persist Security Info=True;Password=123456;User ID=sa;Initial Catalog=chp09" DeleteCommand="DeletePhoto;1" DeleteCommandType="StoredProcedure" InsertCommand="AddPhoto;1" InsertCommandType="StoredProcedure" ProviderName="System.Data.OleDb" SelectCommand="SELECT PhotoID,PhotoTitle,PhotoDesc,PhotoFileName,CateID,UserID FROM Photos WHERE UserID=@UserID" UpdateCommand="UpdatePhoto;1" UpdateCommandType="StoredProcedure">
<DeleteParameters>
<asp:Parameter Name="PhotoID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="PhotoID" Type="Int32" />
<asp:Parameter Name="PhotoTitle" Type="String" />
<asp:Parameter Name="PhotoDesc" Type="String" />
<asp:Parameter Name="PhotoFileName" Type="String" />
<asp:Parameter Name="UserID" Type="Int32" />
<asp:Parameter Name="CateID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="PhotoTitle" Type="String" />
<asp:Parameter Name="PhotoDesc" Type="String" />
<asp:Parameter Name="PhotoFileName" Type="String" />
<asp:Parameter Name="UserID" Type="Int32" />
<asp:Parameter Name="CateID" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td style="width: 764px; height: 21px">
<asp:Panel ID="plEdit" runat="server" Height="50px" Visible="False" Width="700px">
<asp:Label ID="Label1" runat="server" Text="相片标题"></asp:Label>
<asp:TextBox ID="txtTitle" runat="server" Width="76px"></asp:TextBox>
<asp:Label ID="Label4" runat="server" Text="所在类别"></asp:Label>
<asp:DropDownList ID="listCate" runat="server" DataSourceID="listTypeSource" DataTextField="CateName"
DataValueField="CateID">
</asp:DropDownList><br />
<asp:Label ID="Label2" runat="server" Text="相片说明"></asp:Label>
<asp:TextBox ID="txtDesc" runat="server" Height="60px" TextMode="MultiLine" Width="564px"></asp:TextBox><br />
选择要上传相片<asp:FileUpload ID="FileUpload1" runat="server" /><br />
<asp:Button ID="btnSave" runat="server" Text="保存" OnClick="btnSave_Click" />
<br />
<asp:HiddenField ID="PhotoID" runat="server" />
<asp:SqlDataSource ID="listTypeSource" runat="server" ConnectionString="Provider=SQLOLEDB;Data Source=.;Persist Security Info=True;Password=123456;User ID=sa;Initial Catalog=chp09"
DeleteCommand="DeleteCategory;1" DeleteCommandType="StoredProcedure" InsertCommand="AddCategory;1"
InsertCommandType="StoredProcedure" ProviderName="System.Data.OleDb" SelectCommand="GetCategorys;1"
SelectCommandType="StoredProcedure" UpdateCommand="UpdateCategory;1" UpdateCommandType="StoredProcedure">
<DeleteParameters>
<asp:Parameter Name="CateID" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="CateID" Type="Int32" />
<asp:Parameter Name="CateName" />
<asp:Parameter Name="ParentCateID" />
<asp:Parameter Name="UserID" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:Parameter Name="UserID" Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="UserID" />
<asp:Parameter Name="CateName" />
<asp:Parameter Name="ParentCateID" />
</InsertParameters>
</asp:SqlDataSource>
</asp:Panel>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -