/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/innovation/bp/bpvrttl.aspx
76 строк
5 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="bpvrttl.aspx.vb" Inherits="SWAT_swatvrttl" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>SWAT Total voting results</title> <link href="../Styles/page.css" rel="stylesheet" /> <style> .border_right { border-right: 2px solid black; } </style> </head> <body> <form id="form1" runat="server"> <div> <div class="center"> <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2" DataTextField="PROJECTS_GROUP" DataValueField="PROJECTS_GROUP" AutoPostBack="True"></asp:DropDownList> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="SELECT DISTINCT [PROJECTS_GROUP] FROM usermodules.[user].[SWATNoPROJECTS_AND_IDEAS]"></asp:SqlDataSource> <asp:Button ID="Button1" runat="server" Text="Refresh" CssClass ="center " /> <br /> <br /> </div> <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:BoundField DataField="serk_group" HeaderText="SERK Group" SortExpression="serk_group" /> <asp:BoundField DataField="project_id" HeaderText="Project ID" SortExpression="project_id" Visible="False" /> <asp:BoundField DataField="name" HeaderText="Project name" SortExpression="name" > <ItemStyle CssClass="border_right" /> </asp:BoundField> <asp:BoundField DataField="PIC_TTL" HeaderText="PIC TTL" SortExpression="PIC_TTL" /> <asp:BoundField DataField="PIC_AVG" HeaderText="PIC AVG" SortExpression="PIC_AVG" /> <asp:BoundField DataField="PIC_RANK" HeaderText="PIC RANK" SortExpression="PIC_RANK" > <ItemStyle CssClass="border_right" Font-Bold="True" HorizontalAlign="Center" Font-Size="X-Large" /> </asp:BoundField> <asp:BoundField DataField="LOCAL_TTL" HeaderText="LOCAL MANAGERS TTL" SortExpression="LOCAL_TTL" /> <asp:BoundField DataField="LOCAL_AVG" HeaderText="LOCAL MANAGERS AVG" SortExpression="LOCAL_AVG" /> <asp:BoundField DataField="LOCAL_RANK" HeaderText="LOCAL MANAGERS RANK" SortExpression="LOCAL_RANK" > <ItemStyle CssClass="border_right" Font-Bold="True" HorizontalAlign="Center" Font-Size="X-Large" /> </asp:BoundField> <asp:BoundField DataField="KOREAN_TTL" HeaderText="DISPATCHER TTL" SortExpression="KOREAN_TTL" /> <asp:BoundField DataField="KOREAN_AVG" HeaderText="DISPATCHER AVG" SortExpression="KOREAN_AVG" /> <asp:BoundField DataField="KOREAN_RANK" HeaderText="DISPATCHER RANK" SortExpression="KOREAN_RANK" > <ItemStyle CssClass="border_right" Font-Bold="True" HorizontalAlign="Center" Font-Size="X-Large" /> </asp:BoundField> <asp:BoundField DataField="SUM_TTL" HeaderText="SUM" SortExpression="SUM_TTL" /> <asp:BoundField DataField="AVG_TTL" HeaderText="AVG" SortExpression="AVG_TTL" > <ItemStyle CssClass="border_right" /> </asp:BoundField> <asp:BoundField DataField="TTL_RANK" HeaderText="FINAL RANK" SortExpression="TTL_RANK" > <ItemStyle Font-Bold="True" HorizontalAlign="Center" Font-Size="X-Large" BackColor ="LightGray" /> </asp:BoundField> </Columns> <EditRowStyle BackColor="#2461BF" /> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#EFF3FB" /> <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /> <SortedAscendingCellStyle BackColor="#F5F7FB" /> <SortedAscendingHeaderStyle BackColor="#6D95E1" /> <SortedDescendingCellStyle BackColor="#E9EBEF" /> <SortedDescendingHeaderStyle BackColor="#4870BE" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="SELECT * FROM [user].[VI_SWAT_VOTING_RESULT_TTL] WHERE projects_group = @projects_group"> <SelectParameters> <asp:ControlParameter ControlID="DropDownList1" Name="projects_group" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> </div> </form> </body> </html>