/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/fi/gtd_sum.aspx
83 строки
6 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="gtd_sum.aspx.vb" Inherits="FI_gtd_sum" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Summary report by GTD-Material</title> <link href="../Styles/Site.css" rel="stylesheet" /> <link href="../Styles/page.css" rel="stylesheet" /> </head> <body> <form id="form1" runat="server"> <br /> <div class="center"> GTD: <asp:TextBox ID="gtd" runat="server" TextMode ="Search" Width="180px"></asp:TextBox> Material: <asp:TextBox ID="material" runat="server" TextMode ="Search"></asp:TextBox><asp:Button ID="Button1" runat="server" Text="Refresh" /> </div> <hr /> <div> <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" PageSize="30"> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> <Columns> <asp:BoundField DataField="gtd" HeaderText="gtd" SortExpression="gtd" /> <asp:BoundField DataField="material" HeaderText="material" SortExpression="material" /> <asp:BoundField DataField="000" HeaderText="000" SortExpression="000" /> <asp:BoundField DataField="101" HeaderText="101" SortExpression="101" /> <asp:BoundField DataField="122" HeaderText="122" SortExpression="122" /> <asp:BoundField DataField="161" HeaderText="161" SortExpression="161" /> <asp:BoundField DataField="162" HeaderText="162" SortExpression="162" /> <asp:BoundField DataField="261" HeaderText="261" SortExpression="261" /> <asp:BoundField DataField="262" HeaderText="262" SortExpression="262" /> <asp:BoundField DataField="301" HeaderText="301" SortExpression="301" /> <asp:BoundField DataField="309" HeaderText="309" SortExpression="309" /> <asp:BoundField DataField="311" HeaderText="311" SortExpression="311" /> <asp:BoundField DataField="321" HeaderText="321" SortExpression="321" /> <asp:BoundField DataField="325" HeaderText="325" SortExpression="325" /> <asp:BoundField DataField="326" HeaderText="326" SortExpression="326" /> <asp:BoundField DataField="343" HeaderText="343" SortExpression="343" /> <asp:BoundField DataField="344" HeaderText="344" SortExpression="344" /> <asp:BoundField DataField="350" HeaderText="350" SortExpression="350" /> <asp:BoundField DataField="551" HeaderText="551" SortExpression="551" /> <asp:BoundField DataField="552" HeaderText="552" SortExpression="552" /> <asp:BoundField DataField="555" HeaderText="555" SortExpression="555" /> <asp:BoundField DataField="601" HeaderText="601" SortExpression="601" /> <asp:BoundField DataField="602" HeaderText="602" SortExpression="602" /> <asp:BoundField DataField="708" HeaderText="708" SortExpression="708" /> <asp:BoundField DataField="A01" HeaderText="A01" SortExpression="A01" /> <asp:BoundField DataField="A87" HeaderText="A87" SortExpression="A87" /> <asp:BoundField DataField="B01" HeaderText="B01" SortExpression="B01" /> <asp:BoundField DataField="B02" HeaderText="B02" SortExpression="B02" /> <asp:BoundField DataField="B13" HeaderText="B13" SortExpression="B13" /> <asp:BoundField DataField="B14" HeaderText="B14" SortExpression="B14" /> <asp:BoundField DataField="B31" HeaderText="B31" SortExpression="B31" /> <asp:BoundField DataField="B33" HeaderText="B33" SortExpression="B33" /> <asp:BoundField DataField="C53" HeaderText="C53" SortExpression="C53" /> <asp:BoundField DataField="C54" HeaderText="C54" SortExpression="C54" /> <asp:BoundField DataField="C56" HeaderText="C56" SortExpression="C56" /> <asp:BoundField DataField="C59" HeaderText="C59" SortExpression="C59" /> <asp:BoundField DataField="C60" HeaderText="C60" SortExpression="C60" /> </Columns> <EditRowStyle BackColor="#999999" /> <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <SortedAscendingCellStyle BackColor="#E9E7E2" /> <SortedAscendingHeaderStyle BackColor="#506C8C" /> <SortedDescendingCellStyle BackColor="#FFFDF8" /> <SortedDescendingHeaderStyle BackColor="#6F8DAE" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="select * from tools.dbo.PIVOT_FOR_GTD_SUM where gtd like @gtd and material like @material"> <SelectParameters> <asp:ControlParameter ControlID="gtd" DefaultValue="%" Name="gtd" PropertyName="Text" /> <asp:ControlParameter ControlID="material" DefaultValue="%" Name="material" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> </div> </form> </body> </html>