admin_taxrates.aspx

一个很好的网上购物系统！进行了新的修改具有很多的功能！

<%@ Page Language="C#" MasterPageFile="~/admin.master" AutoEventWireup="true" CodeFile="admin_taxrates.aspx.cs" Inherits="admin_taxrates" Title="后台管理 - 税率管理" StylesheetTheme="White" %>
<asp:Content ID="Content1" ContentPlaceHolderID="AdminPlaceHolder" Runat="Server">
   <h1>税率管理</h1>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
        AutoGenerateColumns="False" DataKeyNames="rateID" DataSourceID="SqlDataSource1" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" >
        <Columns>
            <asp:BoundField DataField="rate" HeaderText="税率" SortExpression="rate" />
            <asp:BoundField DataField="state" HeaderText="状态" SortExpression="state" />
            <asp:BoundField DataField="zipCode" HeaderText="地区码" SortExpression="zipCode" />
        </Columns>
    </asp:GridView>
    <br />
    <h1>
        增加税率</h1>
    <asp:FormView ID="FormView1" runat="server" DataKeyNames="rateID" DataSourceID="SqlDataSource1"
        DefaultMode="Insert">

        <InsertItemTemplate>
           <b>税率</b><br />
            <asp:TextBox ID="rateTextBox" runat="server" Text='<%# Bind("rate") %>' Width="82px"></asp:TextBox><asp:RequiredFieldValidator
                ID="RequiredFieldValidator1" runat="server" ControlToValidate="rateTextBox" Display="Dynamic"
                ErrorMessage="Required"></asp:RequiredFieldValidator>
            <asp:RangeValidator ID="RangeValidator1" runat="server" ControlToValidate="rateTextBox"
                ErrorMessage="Invalid Number" MaximumValue="1" MinimumValue="0.001"></asp:RangeValidator><br />
            <b>状态</b><br />
            <asp:DropDownList ID="stateDropDownList" runat="server" Width="169px" SelectedValue='<%# Bind("state") %>'>
                <asp:ListItem Value="DL">大连</asp:ListItem>
                <asp:ListItem Value="BJ">北京</asp:ListItem>
            </asp:DropDownList><br />
            <b>地区码</b><br />
            <asp:TextBox ID="zipCodeTextBox" runat="server" Text='<%# Bind("zipCode") %>' Width="84px"></asp:TextBox><br />
            <br />
            <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                Text="增加">
            </asp:LinkButton>
        </InsertItemTemplate>

    </asp:FormView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CommerceTemplate %>"
        SelectCommand="SELECT [rateID], [rate], [state], [zipCode] FROM [CMRC_TaxRates]" 
        DeleteCommand="DELETE FROM [CMRC_TaxRates] WHERE [rateID] = @rateID" 
        InsertCommand="INSERT INTO [CMRC_TaxRates] ([rate], [state], [zipCode]) VALUES (@rate, @state, @zipCode)" 
        UpdateCommand="UPDATE [CMRC_TaxRates] SET [rate] = @rate, [state] = @state, [zipCode] = @zipCode WHERE [rateID] = @rateID">
        <DeleteParameters>
            <asp:Parameter Name="rateID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="rate" Type="Decimal" />
            <asp:Parameter Name="state" Type="String" />
            <asp:Parameter Name="zipCode" Type="String" />
            <asp:Parameter Name="original_rateID" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="rate" Type="Decimal" />
            <asp:Parameter Name="state" Type="String" />
            <asp:Parameter Name="zipCode" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
    &nbsp;</asp:Content>