/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/innovation/bp/bpvs.aspx
69 строк
6 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="bpvs.aspx.vb" Inherits="SWAT_vs" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource3" DataTextField="PROJECTS_GROUP" DataValueField="PROJECTS_GROUP"> </asp:DropDownList> <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2" DataTextField="GROUP_NAME" DataValueField="GROUP_NAME"> </asp:DropDownList> <asp:Button ID="Button1" runat="server" Text="Refresh" /> <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333"> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> <Columns> <asp:BoundField DataField="Group" HeaderText="Group" SortExpression="Group" /> <asp:BoundField DataField="User ID" HeaderText="User ID" SortExpression="User ID" /> <asp:BoundField DataField="Total Projects" HeaderText="Total Projects" ReadOnly="True" SortExpression="Total Projects" /> <asp:BoundField DataField="Voted" HeaderText="Voted" ReadOnly="True" SortExpression="Voted" /> <asp:BoundField DataField="Not Voted" HeaderText="Not Voted" ReadOnly="True" SortExpression="Not Voted" /> <asp:BoundField DataField="Amount avg" HeaderText="Amount avg" ReadOnly="True" SortExpression="Amount avg" /> <asp:BoundField DataField="Innovation avg" HeaderText="Innovation avg" ReadOnly="True" SortExpression="Innovation avg" /> <asp:BoundField DataField="Implement avg" HeaderText="Implement avg" ReadOnly="True" SortExpression="Implement avg" /> <asp:BoundField DataField="Total avg" HeaderText="Total avg" ReadOnly="True" SortExpression="Total avg" /> <asp:BoundField DataField="Average score" HeaderText="Average score" ReadOnly="True" SortExpression="Average score" /> <asp:BoundField DataField="deviation" HeaderText="deviation" ReadOnly="True" SortExpression="deviation" /> </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="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="SELECT DISTINCT [GROUP_NAME] FROM usermodules.[user].[SWAT_PIC_LIST] ORDER BY [GROUP_NAME]"></asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="select ttt.*, "Average score" - "Total avg" as deviation from ( select distinct group_name as "Group", user_id as [User ID], (select count(*) from UserModules.[user].[SWATNoPROJECTS_AND_IDEAS_VOTING] where user_id = pic.user_id and projects_group = @projects_group) as "Total Projects", (select count(*) from UserModules.[user].[SWATNoPROJECTS_AND_IDEAS_VOTING] where user_id = pic.user_id and projects_group = @projects_group and ttl is not null) as Voted, (select count(*) from UserModules.[user].[SWATNoPROJECTS_AND_IDEAS_VOTING] where user_id = pic.user_id and projects_group = @projects_group and ttl is null) as "Not Voted", (select CAST(AVG(cast(EFF_AMT__PROJECT____CREATIVITY__IDEA___MAX_4_ as decimal(18,4))) as decimal (18,2)) FROM UserModules.[user].[SWATNoPROJECTS_AND_IDEAS_VOTING] where user_id = pic.user_id and projects_group = @projects_group) as "Amount avg", (select CAST(AVG(cast(INNOVATION__PROJECT____POTENTIAL__IDEA___MAX_4_ as decimal(18,4))) as decimal (18,2)) FROM UserModules.[user].[SWATNoPROJECTS_AND_IDEAS_VOTING] where user_id = pic.user_id and projects_group = @projects_group) as "Innovation avg", (select CAST(AVG(cast(IMPLEMENT__PROJECT____REPLICATION__IDEA___MAX_2_ as decimal(18,4))) as decimal (18,2)) FROM UserModules.[user].[SWATNoPROJECTS_AND_IDEAS_VOTING] where user_id = pic.user_id and projects_group = @projects_group) as "Implement avg", (select CAST(AVG(cast(TTL as decimal(18,4))) as decimal (18,2)) FROM UserModules.[user].[SWATNoPROJECTS_AND_IDEAS_VOTING] where user_id = pic.user_id and projects_group = @projects_group) as "Total avg", (select CAST(AVG(cast(TTL as decimal(18,4))) as decimal (18,2)) FROM UserModules.[user].[SWATNoPROJECTS_AND_IDEAS_VOTING] WHERE projects_group = @projects_group) as "Average score" from usermodules.[user].swat_pic_list pic where group_name = @group_name ) ttt"> <SelectParameters> <asp:ControlParameter ControlID="DropDownList1" Name="group_name" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="DropDownList2" Name="projects_group" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="SELECT DISTINCT [PROJECTS_GROUP] FROM usermodules.[user].[SWATNoPROJECTS_AND_IDEAS]"></asp:SqlDataSource> </div> </form> </body> </html>