📄 delete.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="delete.aspx.cs" Inherits="delete" %>
<%@ Register Src="mycontroler/foot.ascx" TagName="foot" TagPrefix="uc1" %>
<%@ Register Src="mycontroler/head.ascx" TagName="head" TagPrefix="uc2" %>
<!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 style="background-image: url(image/back.jpg)" scroll="yes">
<form id="form1" runat="server">
<div>
<table width=100% border="0" style="background-color: #999933;">
<tr>
<td style="background-image: url(image/head.png); width: 1051px; vertical-align: middle; height: 245px; text-align: center;"></td>
</tr>
<tr>
<td height="48" style="width: 1051px">
<asp:Label ID="Label4" runat="server" ForeColor="#8080FF" Width="177px"></asp:Label>
<uc2:head ID="Head1" runat="server" />
</td>
</tr>
<tr>
<td style="width: 1051px; height: 494px;">
<table>
<tr>
<td style="width: 823px; height: 397px">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:voteConnectionString2 %>"
DeleteCommand="DELETE FROM [voteMaster] WHERE [id] = @id" InsertCommand="INSERT INTO [voteMaster] ([voteTitle], [voteSum], [image], [endTime]) VALUES (@voteTitle, @voteSum, @image, @endTime)"
SelectCommand="SELECT [id], [voteTitle], [voteSum], [image], [endTime] FROM [voteMaster]"
UpdateCommand="UPDATE [voteMaster] SET [voteTitle] = @voteTitle, [voteSum] = @voteSum, [image] = @image, [endTime] = @endTime WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="voteTitle" Type="String" />
<asp:Parameter Name="voteSum" Type="Int32" />
<asp:Parameter Name="image" Type="String" />
<asp:Parameter Name="endTime" Type="DateTime" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="voteTitle" Type="String" />
<asp:Parameter Name="voteSum" Type="Int32" />
<asp:Parameter Name="image" Type="String" />
<asp:Parameter Name="endTime" Type="DateTime" />
</InsertParameters>
</asp:SqlDataSource>
<asp:Label ID="Label3" runat="server" Font-Size="X-Large" ForeColor="#00C0C0" Text="主题修改"></asp:Label>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="id" DataSourceID="SqlDataSource1" PageSize="5" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal" Width="100%" >
<PagerSettings PageButtonCount="5" />
<Columns>
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
SortExpression="id" />
<asp:BoundField DataField="voteTitle" HeaderText="voteTitle" SortExpression="voteTitle" />
<asp:BoundField DataField="voteSum" HeaderText="voteSum" SortExpression="voteSum" />
<asp:BoundField DataField="endTime" HeaderText="endTime" SortExpression="endTime" />
<asp:TemplateField>
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("image") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Image ID="Image1" runat="server" ImageUrl='<%#"image/master/"+ Eval("image") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True" ShowSelectButton="True" ButtonType="Button" ShowEditButton="True" />
</Columns>
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<AlternatingRowStyle BackColor="#F7F7F7" />
</asp:GridView>
<asp:Label ID="Label2" runat="server" Font-Size="X-Large" ForeColor="#00C0C0"></asp:Label></td>
</tr>
<tr>
<td style="width: 823px; height: 416px">
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:voteConnectionString2 %>"
DeleteCommand="DELETE FROM [voetDetails] WHERE [voteDetailsID] = @voteDetailsID"
InsertCommand="INSERT INTO [voetDetails] ([voteItem], [voteNum], [id]) VALUES (@voteItem, @voteNum, @id)"
SelectCommand="SELECT * FROM [voetDetails] WHERE ([id] = @id)" UpdateCommand="UPDATE [voetDetails] SET [voteItem] = @voteItem, [voteNum] = @voteNum, [id] = @id WHERE [voteDetailsID] = @voteDetailsID">
<DeleteParameters>
<asp:Parameter Name="voteDetailsID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="voteItem" Type="String" />
<asp:Parameter Name="voteNum" Type="Int32" />
<asp:Parameter Name="id" Type="Int32" />
<asp:Parameter Name="voteDetailsID" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter ControlID="GridView1" DefaultValue="1" Name="id" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="voteItem" Type="String" />
<asp:Parameter Name="voteNum" Type="Int32" />
<asp:Parameter Name="id" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
DataKeyNames="voteDetailsID" DataSourceID="SqlDataSource2" Height="50px" Width="100%" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal" OnItemDeleted="DetailsView1_ItemDeleted" OnItemInserted="DetailsView1_ItemInserted" OnItemUpdated="DetailsView1_ItemUpdated" >
<Fields>
<asp:BoundField DataField="voteDetailsID" HeaderText="voteDetailsID" InsertVisible="False"
ReadOnly="True" SortExpression="voteDetailsID" />
<asp:BoundField DataField="voteItem" HeaderText="voteItem" SortExpression="voteItem" />
<asp:BoundField DataField="voteNum" HeaderText="voteNum" SortExpression="voteNum" />
<asp:BoundField DataField="id" HeaderText="id" SortExpression="id" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" ButtonType="Button" />
</Fields>
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<EditRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<AlternatingRowStyle BackColor="#F7F7F7" />
</asp:DetailsView>
<br />
<br />
<br />
<br />
<br />
<asp:Label ID="Label1" runat="server" Font-Size="X-Large" ForeColor="#00C0C0" Height="27px" Width="162px"></asp:Label><br />
<br />
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:voteConnectionString3 %>"
DeleteCommand="DELETE FROM [voteConfig] WHERE [id] = @id" InsertCommand="INSERT INTO [voteConfig] ([id], [checkIP], [checkTime]) VALUES (@id, @checkIP, @checkTime)"
SelectCommand="SELECT * FROM [voteConfig] WHERE ([id] = @id)" UpdateCommand="UPDATE [voteConfig] SET [checkIP] = @checkIP, [checkTime] = @checkTime WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="checkIP" Type="Int32" />
<asp:Parameter Name="checkTime" Type="Int32" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter ControlID="GridView1" Name="id" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="id" Type="Int32" />
<asp:Parameter Name="checkIP" Type="Int32" />
<asp:Parameter Name="checkTime" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
<asp:DetailsView ID="DetailsView2" runat="server" AutoGenerateRows="False" BackColor="White"
BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="id"
DataSourceID="SqlDataSource3" GridLines="Horizontal" Height="50px"
Width="100%">
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<EditRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<Fields>
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True" SortExpression="id" />
<asp:BoundField DataField="checkIP" FooterText="IP设置" HeaderText="checkIP" SortExpression="checkIP" />
<asp:BoundField DataField="checkTime" HeaderText="checkTime" SortExpression="checkTime" />
<asp:CommandField ButtonType="Button" ShowDeleteButton="True" ShowEditButton="True" />
</Fields>
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<AlternatingRowStyle BackColor="#F7F7F7" />
</asp:DetailsView>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="78" style="width: 1051px; vertical-align: middle; text-align: center;">
<uc1:foot ID="Foot1" runat="server" />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -