PDA-Bank-Cards-Info

Staff.aspx
281 строка · 17.8 Кб
Перенос по словам
1
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Staff.aspx.cs"
2
    Inherits="Default" %>
3

4
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
5
<html xmlns="http://www.w3.org/1999/xhtml">
6
<head runat="server">
7
    <title>Банковские карты</title>
8
</head>
9
<body>
10
    <form id="form1" runat="server">
11
    <div>
12
        <center>
13
            <asp:Panel ID="PagePanel" runat="server" HorizontalAlign="Left"
14
                Width="100%" Height="100%">
15
                <table width="100%" cellspacing="0" cellpadding="2">
16
                    <tr valign="top">
17
                        <td align="left">
18
                            <asp:Label ID="Logo" runat="server" Text="<%$ AppSettings:Logo %>"
19
                                SkinID="Logo" />
20
                            <asp:DropDownList ID="AdminUserList" runat="server" AutoPostBack="True"
21
                                Visible="false" OnSelectedIndexChanged="AdminUserList_SelectedIndexChanged" />
22
                            <asp:DropDownList ID="AdminActionList" runat="server" Visible="False">
23
                                <asp:ListItem Value="AddUser" Text="Добавить нового" Selected="True" />
24
                                <asp:ListItem Value="Comment" Text="Комментарий" />
25
                                <asp:ListItem Value="Email" Text="Email" />
26
                                <asp:ListItem Value="Unlock" Text="Разблокировать" />
27
                                <asp:ListItem Value="Password" Text="Сменить пароль" />
28
                                <asp:ListItem Value="ChEmail" Text="Сменить email" />
29
                                <asp:ListItem Value="Disable" Text="Запретить доступ" />
30
                                <asp:ListItem Value="Enable" Text="Разрешить доступ" />
31
                                <asp:ListItem Value="User" Text="Права клиента" />
32
                                <asp:ListItem Value="Operator" Text="Права оператора" />
33
                                <asp:ListItem Value="Admin" Text="Права админа" />
34
                                <asp:ListItem Value="Delete" Text="Удалить насовсем" />
35
                            </asp:DropDownList>
36
                            <asp:Button ID="ActionButton" runat="server" Text="OK" CommandName="Action"
37
                                OnCommand="AdminButton_Command" Visible="False" />
38
                            <asp:Button ID="NextUserButton" runat="server" Text="&gt;&gt;"
39
                                CommandName="NextUser" OnCommand="AdminButton_Command" Visible="False" />
40
                        </td>
41
                        <td align="right">
42
                            <asp:LoginStatus ID="UserStatus" runat="server" LogoutAction="Redirect"
43
                                LogoutPageUrl="~/Default.aspx" />
44
                        </td>
45
                    </tr>
46
                </table>
47
                <asp:Panel ID="AddUserPanel" runat="server" Visible="False" SkinID="Admin"
48
                    DefaultButton="AddUserButton1">
49
                    <table width="100%">
50
                        <tr valign="top">
51
                            <td>
52
                                <asp:Label ID="AddUserNameLabel" runat="server" Text="Логин" />
53
                                <asp:TextBox ID="AddUserName" runat="server" MaxLength="20" TabIndex="1" />
54
                                <asp:Label ID="AddUserPassLabel" runat="server" Text="Пароль" />
55
                                <asp:TextBox ID="AddUserPass" runat="server" MaxLength="20" TabIndex="2" />
56
                                <asp:Label ID="AddUserEmailLabel" runat="server" Text="Email" />
57
                                <asp:TextBox ID="AddUserEmail" runat="server" MaxLength="256"
58
                                    TabIndex="3" />
59
                            </td>
60
                            <td align="right">
61
                                <asp:Button ID="AddUserButton1" runat="server" Text="OK" CommandName="AddUserOK"
62
                                    OnCommand="AdminButton_Command" TabIndex="4" />
63
                                <asp:Button ID="AddUserButton2" runat="server" Text="Отменить"
64
                                    CommandName="AdminCancel" OnCommand="AdminButton_Command"
65
                                    TabIndex="5" />
66
                            </td>
67
                        </tr>
68
                    </table>
69
                </asp:Panel>
70
                <asp:Panel ID="BigTextPanel" runat="server" Visible="False" SkinID="Admin"
71
                    DefaultButton="BigTextButton1">
72
                    <table width="100%">
73
                        <tr valign="top">
74
                            <td>
75
                                <asp:TextBox ID="BigTextBox" runat="server" TextMode="MultiLine"
76
                                    Rows="5" MaxLength="3000" Width="98%" TabIndex="1" />
77
                            </td>
78
                        </tr>
79
                        <tr valign="top">
80
                            <td align="right">
81
                                <asp:Button ID="BigTextButton1" runat="server" Text="OK" CommandName="BigTextOK"
82
                                    OnCommand="AdminButton_Command" TabIndex="2" />
83
                                <asp:Button ID="BigTextButton2" runat="server" Text="Отменить"
84
                                    CommandName="AdminCancel" OnCommand="AdminButton_Command"
85
                                    TabIndex="3" />
86
                            </td>
87
                        </tr>
88
                    </table>
89
                </asp:Panel>
90
                <asp:Panel ID="ConfirmPanel" runat="server" Visible="False" SkinID="Admin"
91
                    DefaultButton="ConfirmButton1">
92
                    <table width="100%">
93
                        <tr valign="top">
94
                            <td>
95
                                <asp:Label ID="ConfirmLabel" runat="server" />
96
                            </td>
97
                            <td align="right">
98
                                <asp:Button ID="ConfirmButton1" runat="server" Text="OK" CommandName="ConfirmOK"
99
                                    OnCommand="AdminButton_Command" TabIndex="1" />
100
                                <asp:Button ID="ConfirmButton2" runat="server" Text="Отменить"
101
                                    CommandName="AdminCancel" OnCommand="AdminButton_Command"
102
                                    TabIndex="2" />
103
                            </td>
104
                        </tr>
105
                    </table>
106
                </asp:Panel>
107
                <asp:Panel ID="MsgPanel" runat="server" Visible="false" SkinID="Message"
108
                    DefaultButton="MsgOK">
109
                    <table width="100%">
110
                        <tr valign="top">
111
                            <td>
112
                                <asp:Label ID="Msg" runat="server" />
113
                            </td>
114
                            <td align="right">
115
                                <asp:Button ID="MsgOK" runat="server" Text="OK" CommandName="MessageOK"
116
                                    OnCommand="AdminButton_Command" />
117
                            </td>
118
                        </tr>
119
                    </table>
120
                </asp:Panel>
121
                <asp:Panel ID="Content" runat="server">
122
                    <asp:GridView ID="GridCards" runat="server" AutoGenerateColumns="False"
123
                        DataKeyNames="card_id,card_number,card_type_name" DataSourceID="SqlCards"
124
                        OnRowDataBound="GridCards_RowDataBound" AllowSorting="True"
125
                        EmptyDataText="Нет подключенных карт" 
126
                        onrowcommand="GridCards_RowCommand">
127
                        <Columns>
128
                            <asp:TemplateField HeaderText="Карта" SortExpression="card_number">
129
                                <ItemTemplate>
130
                                    <asp:Label ID="CardNo" runat="server" />
131
                                    <asp:Label ID="CardType" runat="server" />
132
                                    <asp:Label ID="CardExp" runat="server" />
133
                                    <asp:Label ID="CardStatus" runat="server" />
134
                                </ItemTemplate>
135
                                <ItemStyle Wrap="False" />
136
                            </asp:TemplateField>
137
                            <asp:TemplateField HeaderText="Доступно" SortExpression="amount_available">
138
                                <ItemTemplate>
139
                                    <asp:Label ID="CardAmount" runat="server" />
140
                                    <asp:LinkButton ID="CardAmountQ" runat="server" Text="?"
141
                                        CommandName="select" CommandArgument="Trans" />
142
                                </ItemTemplate>
143
                                <ItemStyle HorizontalAlign="Right" />
144
                            </asp:TemplateField>
145
                            <asp:TemplateField HeaderText="Блокировано" SortExpression="amount_on_hold">
146
                                <ItemTemplate>
147
                                    <asp:Label ID="CardHold" runat="server" />
148
                                    <asp:LinkButton ID="CardHoldQ" runat="server" Text="?" Visible="false"
149
                                        CommandName="select" CommandArgument="Holds" />
150
                                </ItemTemplate>
151
                                <ItemStyle HorizontalAlign="Right" />
152
                            </asp:TemplateField>
153
                            <asp:TemplateField HeaderText="Задолженность" SortExpression="amount_debt">
154
                                <ItemTemplate>
155
                                    <asp:Label ID="CardDebt" runat="server" />
156
                                    <asp:LinkButton ID="CardDebtQ" runat="server" Text="?" Visible="false"
157
                                        CommandName="select" CommandArgument="Debts" />
158
                                </ItemTemplate>
159
                                <ItemStyle HorizontalAlign="Right" />
160
                            </asp:TemplateField>
161
                        </Columns>
162
                    </asp:GridView>
163
                    <asp:GridView ID="GridTrans" runat="server" AutoGenerateColumns="False"
164
                        DataSourceID="SqlTrans" AllowPaging="True" AllowSorting="True"
165
                        OnRowDataBound="GridTrans_RowDataBound">
166
                        <Columns>
167
                            <asp:TemplateField HeaderText="Дата" SortExpression="operation_date">
168
                                <ItemTemplate>
169
                                    <asp:Label ID="TranDate" runat="server" />
170
                                </ItemTemplate>
171
                                <ItemStyle Wrap="False" />
172
                            </asp:TemplateField>
173
                            <asp:TemplateField HeaderText="Сумма" SortExpression="amount">
174
                                <ItemTemplate>
175
                                    <asp:Label ID="TranAmount" runat="server" Font-Bold="true" />
176
                                </ItemTemplate>
177
                                <ItemStyle HorizontalAlign="Right" Wrap="False" />
178
                            </asp:TemplateField>
179
                            <asp:TemplateField HeaderText="Вал." SortExpression="operation_currency_iso">
180
                                <ItemTemplate>
181
                                    <asp:Label ID="TranCur" runat="server" />
182
                                </ItemTemplate>
183
                                <ItemStyle HorizontalAlign="Center" Wrap="False" />
184
                            </asp:TemplateField>
185
                            <asp:TemplateField HeaderText="Операция" SortExpression="comment">
186
                                <ItemTemplate>
187
                                    <asp:Label ID="TranComment" runat="server" />
188
                                </ItemTemplate>
189
                            </asp:TemplateField>
190
                        </Columns>
191
                    </asp:GridView>
192
                    <asp:GridView ID="GridHolds" runat="server" 
193
                        AllowPaging="True" AllowSorting="True" 
194
                        AutoGenerateColumns="False" DataSourceID="SqlHolds" 
195
                        OnRowDataBound="GridHolds_RowDataBound">
196
                        <Columns>
197
                            <asp:TemplateField HeaderText="Дата" 
198
                                SortExpression="operation_date">
199
                                <ItemTemplate>
200
                                    <asp:Label ID="HoldDate" runat="server" />
201
                                </ItemTemplate>
202
                                <ItemStyle Wrap="False" />
203
                            </asp:TemplateField>
204
                            <asp:TemplateField HeaderText="Сумма" 
205
                                SortExpression="amount">
206
                                <ItemTemplate>
207
                                    <asp:Label ID="HoldAmount" runat="server" />
208
                                </ItemTemplate>
209
                                <ItemStyle HorizontalAlign="Right" Wrap="False" />
210
                            </asp:TemplateField>
211
                            <asp:TemplateField HeaderText="Блокировка" 
212
                                SortExpression="comment">
213
                                <ItemTemplate>
214
                                    <asp:Label ID="HoldComment" runat="server" />
215
                                </ItemTemplate>
216
                            </asp:TemplateField>
217
                        </Columns>
218
                    </asp:GridView>
219
                    <asp:Button ID="Excel" runat="server" onclick="Excel_Click" 
220
                        Text="Экспорт в Microsoft Excel" Visible="False" />
221
                    <asp:DetailsView ID="DetailsDebts" runat="server" AutoGenerateRows="False"
222
                        DataSourceID="SqlDebts">
223
                        <HeaderTemplate>
224
                            Задолженность по валютам
225
                        </HeaderTemplate>
226
                        <Fields>
227
                            <asp:BoundField DataField="amount_810" DataFormatString="{0:F2}RUR"
228
                                HeaderText="Рубли РФ:" SortExpression="amount_810">
229
                                <ItemStyle HorizontalAlign="Right" Wrap="False" />
230
                            </asp:BoundField>
231
                            <asp:BoundField DataField="amount_840" DataFormatString="{0:F2}USD"
232
                                HeaderText="Доллары США:" SortExpression="amount_840">
233
                                <ItemStyle HorizontalAlign="Right" Wrap="False" />
234
                            </asp:BoundField>
235
                            <asp:BoundField DataField="amount_978" DataFormatString="{0:F2}EUR"
236
                                HeaderText="Евро:" SortExpression="amount_978">
237
                                <ItemStyle HorizontalAlign="Right" Wrap="False" />
238
                            </asp:BoundField>
239
                        </Fields>
240
                    </asp:DetailsView>
241
                    <asp:SqlDataSource ID="SqlCards" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionDataMart %>"
242
                        SelectCommand="wsp_dm_pc_get_cards_num" SelectCommandType="StoredProcedure">
243
                        <SelectParameters>
244
                            <asp:ControlParameter ControlID="AdminUserList" Name="client_login"
245
                                PropertyName="SelectedValue" Type="String" />
246
                        </SelectParameters>
247
                    </asp:SqlDataSource>
248
                    <asp:SqlDataSource ID="SqlTrans" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionDataMart %>"
249
                        SelectCommand="wsp_dm_pc_get_operations" SelectCommandType="StoredProcedure">
250
                        <SelectParameters>
251
                            <asp:ControlParameter ControlID="AdminUserList" Name="client_login"
252
                                PropertyName="SelectedValue" Type="String" />
253
                            <asp:ControlParameter ControlID="GridCards" Name="card_id" PropertyName="SelectedValue"
254
                                Type="Int32" />
255
                        </SelectParameters>
256
                    </asp:SqlDataSource>
257
                    <asp:SqlDataSource ID="SqlHolds" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionDataMart %>"
258
                        SelectCommand="wsp_dm_pc_get_on_hold" SelectCommandType="StoredProcedure">
259
                        <SelectParameters>
260
                            <asp:ControlParameter ControlID="AdminUserList" Name="client_login"
261
                                PropertyName="SelectedValue" Type="String" />
262
                            <asp:ControlParameter ControlID="GridCards" Name="card_id" PropertyName="SelectedValue"
263
                                Type="Int32" />
264
                        </SelectParameters>
265
                    </asp:SqlDataSource>
266
                    <asp:SqlDataSource ID="SqlDebts" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionDataMart %>"
267
                        SelectCommand="wsp_dm_pc_get_debt" SelectCommandType="StoredProcedure">
268
                        <SelectParameters>
269
                            <asp:ControlParameter ControlID="AdminUserList" Name="client_login"
270
                                PropertyName="SelectedValue" Type="String" />
271
                            <asp:ControlParameter ControlID="GridCards" Name="card_id" PropertyName="SelectedValue"
272
                                Type="Int32" />
273
                        </SelectParameters>
274
                    </asp:SqlDataSource>
275
                </asp:Panel>
276
            </asp:Panel>
277
        </center>
278
    </div>
279
    </form>
280
</body>
281
</html>
282
PDA-Bank-Cards-Info

Использование cookies
