PDA-Bank-Cards-Info

1
<%@ Page Title="Экспорт в Excel" Language="C#" MasterPageFile="~/MasterPage.master"
2
    AutoEventWireup="true" CodeFile="Excel.aspx.cs" Inherits="Excel" %>
3

4
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
5
</asp:Content>
6
<asp:Content ID="Content2" ContentPlaceHolderID="Content" runat="Server">
7
    <asp:GridView ID="TransGrid" runat="server" 
8
        Caption="Операции по карте" 
9
        DataSourceID="SqlTrans" >
10
    </asp:GridView>
11
    <asp:GridView ID="CardsGrid" runat="server" 
12
        Caption="Карточки" DataSourceID="SqlCards" 
13
        onselectedindexchanged="CardsGrid_SelectedIndexChanged" 
14
        DataKeyNames="card_id">
15
        <Columns>
16
            <asp:CommandField ShowSelectButton="True" />
17
        </Columns>
18
    </asp:GridView>
19
    <asp:SqlDataSource ID="SqlCards" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionDataMart %>"
20
        SelectCommand="wsp_dm_pc_get_cards_num" SelectCommandType="StoredProcedure">
21
        <SelectParameters>
22
            <asp:Parameter Name="client_login" Type="String" />
23
        </SelectParameters>
24
    </asp:SqlDataSource>
25
    <asp:SqlDataSource ID="SqlTrans" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionDataMart %>"
26
        SelectCommand="wsp_dm_pc_get_operations" SelectCommandType="StoredProcedure"
27
        FilterExpression="transaction_date&gt;='{0}' and transaction_date&lt;'{1}'">
28
        <SelectParameters>
29
            <asp:Parameter Name="client_login" Type="String" />
30
            <asp:ControlParameter ControlID="CardsGrid" Name="card_id" PropertyName="SelectedValue"
31
                Type="Int32" />
32
        </SelectParameters>
33
    </asp:SqlDataSource>
34
</asp:Content>
35