当前文件路径：XiaoFanWeb/admin/product_type_add.aspx

		            
 1<%...@ Page Language="C#" MasterPageFile="~/admin/admin.master" AutoEventWireup="true" CodeFile="product_type_add.aspx.cs" Inherits="admin_product_type_add" Title="Untitled Page" %>
 2<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
 3</asp:Content>
 4<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 5    <table width="500">
 6        <tr>
 7            <td style="height: 24px" width="120">
 8            </td>
 9            <td align="left" style="height: 24px" width="350">
10                <asp:Label ID="OKmessage" runat="server" Text="Label" Visible="False"></asp:Label></td>
11            <td style="height: 24px">
12            </td>
13        </tr>
14        <tr>
15            <td style="height: 24px" width="120">
16                一级分类：</td>
17            <td align="left" style="height: 24px" width="350">
18                <asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="True" DataSourceID="AccessDataSource1"
19                    DataTextField="Name" DataValueField="Id">
20                    <asp:ListItem Value="0">一级分类</asp:ListItem>
21                </asp:DropDownList>*添加一级分类选择默认</td>
22            <td style="height: 24px">
23            </td>
24        </tr>
25        <tr>
26            <td>
27                分类名称：</td>
28            <td align="left">
29                <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
30                <asp:Label ID="Label1" runat="server" ForeColor="Red" Text="*"></asp:Label>
31                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1"
32                    ErrorMessage="分类不能为空"></asp:RequiredFieldValidator></td>
33            <td>
34            </td>
35        </tr>
36        <tr>
37            <td>
38                分类排序：</td>
39            <td align="left">
40                <asp:TextBox ID="TextBox2" runat="server">0</asp:TextBox></td>
41            <td>
42            </td>
43        </tr>
44        <tr>
45            <td>
46            </td>
47            <td align="left">
48                <asp:Button ID="Button1" runat="server" Text="添加" OnClick="Button1_Click" />
49                <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/dbs.mdb"
50                    DeleteCommand="DELETE FROM [FZ_Product_Type] WHERE [Id] = ?" InsertCommand="INSERT INTO [FZ_Product_Type] ([Id], [Name], [Ord], [pid]) VALUES (?, ?, ?, ?)"
51                    SelectCommand="SELECT * FROM [FZ_Product_Type] WHERE ([pid] = ?) ORDER BY [Ord]"
52                    UpdateCommand="UPDATE [FZ_Product_Type] SET [Name] = ?, [Ord] = ?, [pid] = ? WHERE [Id] = ?">
53                    <DeleteParameters>
54                        <asp:Parameter Name="Id" Type="Int32" />
55                    </DeleteParameters>
56                    <UpdateParameters>
57                        <asp:Parameter Name="Name" Type="String" />
58                        <asp:Parameter Name="Ord" Type="Int32" />
59                        <asp:Parameter Name="pid" Type="Int32" />
60                        <asp:Parameter Name="Id" Type="Int32" />
61                    </UpdateParameters>
62                    <SelectParameters>
63                        <asp:Parameter DefaultValue="0" Name="pid" Type="Int32" />
64                    </SelectParameters>
65                    <InsertParameters>
66                        <asp:Parameter Name="Id" Type="Int32" />
67                        <asp:Parameter Name="Name" Type="String" />
68                        <asp:Parameter Name="Ord" Type="Int32" />
69                        <asp:Parameter Name="pid" Type="Int32" />
70                    </InsertParameters>
71                </asp:AccessDataSource>
72            </td>
73            <td>
74            </td>
75        </tr>
76    </table>
77</asp:Content>
78
79