controls/GiftRule.ascx

（开头部分） 4KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="GiftRule.ascx.cs" Inherits="controls_GiftRule" %>
&nbsp;<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MemberCardConnectionString %>"
    DeleteCommand="DELETE FROM [GiftRule] WHERE [RuleID] = @RuleID"
    InsertCommand="INSERT INTO [GiftRule] ([StockID], [CardCount]) VALUES (@StockID, @CardCount)"
    SelectCommand="SELECT GiftRule.StockID, Stock.StockName, GiftRule.CardCount, GiftRule.RuleID FROM GiftRule INNER JOIN Stock ON GiftRule.StockID = Stock.StockID"
    UpdateCommand="UPDATE [GiftRule] SET [StockID] = @StockID, [CardCount] = @CardCount WHERE [RuleID] = @RuleID">
    <DeleteParameters>
        <asp:Parameter Name="RuleID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="StockID" Type="String" />
        <asp:Parameter Name="CardCount" Type="Decimal" />
        <asp:Parameter Name="RuleID" Type="Int32" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="StockID" Type="String" />
        <asp:Parameter Name="CardCount" Type="Decimal" />
    </InsertParameters>
</asp:SqlDataSource>
&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MemberCardConnectionString %>"
    DeleteCommand="DELETE FROM [GiftRule] WHERE [RuleID] = @RuleID" InsertCommand="INSERT INTO [GiftRule] ([StockID], [CardCount]) VALUES (@StockID, @CardCount)"
    SelectCommand="SELECT [RuleID], [StockID], [CardCount] FROM [GiftRule] WHERE ([RuleID] = @RuleID)"
    UpdateCommand="UPDATE [GiftRule] SET [StockID] = @StockID, [CardCount] = @CardCount WHERE [RuleID] = @RuleID">
    <DeleteParameters>
        <asp:Parameter Name="RuleID" Type="Int32" />
    </DeleteParameters>
    <UpdateParameters>
        <asp:Parameter Name="StockID" Type="String" />
        <asp:Parameter Name="CardCount" Type="Decimal" />
        <asp:Parameter Name="RuleID" Type="Int32" />
    </UpdateParameters>
    <SelectParameters>
        <asp:ControlParameter ControlID="GridView1" DefaultValue="0" Name="RuleID" PropertyName="SelectedValue"
            Type="Int32" />
    </SelectParameters>
    <InsertParameters>
        <asp:Parameter Name="StockID" Type="String" />
        <asp:Parameter Name="CardCount" Type="Decimal" />
    </InsertParameters>
</asp:SqlDataSource>
<table style="width: 496px">
    <tr>
        <td colspan="2">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
    DataSourceID="SqlDataSource1" DataKeyNames="RuleID" Width="463px">
    <Columns>
        <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowSelectButton="True" />
        <asp:BoundField DataField="StockID" HeaderText="商品编码" SortExpression="StockID" />
        <asp:BoundField DataField="StockName" HeaderText="商品名称" SortExpression="StockName" />
        <asp:BoundField DataField="CardCount" HeaderText="积分总数" SortExpression="CardCount" />
    </Columns>
</asp:GridView>
        </td>
    </tr>
    <tr>
        <td>
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="RuleID"
    DataSourceID="SqlDataSource2" Height="50px" Width="173px" OnItemInserted="DetailsView1_ItemInserted">
    <Fields>
后面还有 16 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。