/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/pc/sfrep.aspx
199 строк
11 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="sfrep.aspx.vb" Inherits="PC_sfrep" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>SOP Fluctuation Report</title> <link href="../Styles/page.css" rel="stylesheet" /> <script src="../Scripts/jquery-1.9.1.min.js"></script> <script src="../Scripts/jquery.stickytableheaders.min.js"></script> <style type="text/css"> #header { width: 100%; margin: 0 auto; text-align: center; color: black; background-color: white; text-shadow: none; opacity: .99; /*position: fixed;*/ top: 0px; z-index: 1000; left: 0px; } #body { padding-top: 220px; } .gridHeaderCell { } .auto-style1 { height: 26px; } </style> </head> <body> <form id="form1" runat="server" defaultbutton ="refresh"> <div> <div id="header"> <table id="filters"> <tr> <td>Type</td> <td>Division</td> <td>Inch</td> <td>Model</td> <td>Rate</td> <td rowspan ="2"> <asp:ImageButton ID="refresh" runat="server" ImageUrl ="~/Images/Refresh.png" /></td> <td rowspan ="2"> <asp:ImageButton ID="toExcel" runat="server" ImageUrl ="~/Images/mexcel.png" /></td> <td rowspan ="2"> <asp:ImageButton ID="mail" runat="server" ImageUrl ="~/Images/Buttons/24/mail.png" Visible="False" /></td> </tr> <tr> <td class="auto-style1"><asp:DropDownList runat ="server" ID="type" AutoPostBack="True"></asp:DropDownList></td> <td> <asp:DropDownList ID="division" runat="server" AutoPostBack="True"> <asp:ListItem Value="A1">CTV</asp:ListItem> <asp:ListItem Value="C1">MON</asp:ListItem> </asp:DropDownList></td> <td class="auto-style1"> <asp:TextBox runat="server" ID="inchFilter" Width ="40" TextMode="Number"></asp:TextBox></td> <td class="auto-style1"> <asp:TextBox runat="server" ID="modelFilter" TextMode="Search"></asp:TextBox></td> <td class="auto-style1"> <asp:RadioButtonList ID="ratioSelector" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" AutoPostBack="True"> <asp:ListItem Value="0" Selected="True">All</asp:ListItem> <asp:ListItem Value="-1">From ZERO</asp:ListItem> <asp:ListItem Value="-2">To ZERO</asp:ListItem> <asp:ListItem Value="-3">No change</asp:ListItem> <asp:ListItem style="visibility: hidden" ><br /></asp:ListItem> <asp:ListItem Value="50">>50%</asp:ListItem> <asp:ListItem Value="100">>100%</asp:ListItem> <asp:ListItem Value="200">>200%</asp:ListItem> <asp:ListItem Value="1000">>1000%</asp:ListItem> <%-- <asp:ListItem Value="10000000">Over 1000%</asp:ListItem>--%> </asp:RadioButtonList></td> </tr> </table> <table> <tr> <td rowspan="2">Legend:</td> <td>11~50</td> <td>51~100</td> <td>101~200</td> <td>201~1000</td> <td>1000~</td> </tr> <tr> <td style="background-color: #ffff00"> </td> <td style="background-color: #ffbf00"> </td> <td style="background-color: #ff7f00"> </td> <td style="background-color: #ff3f00"> </td> <td style="background-color: #ff0000"> </td> </tr> </table> <asp:Label ID="message" runat="server" CssClass="center "></asp:Label> <div id="Total"> <asp:GridView ID="total" runat="server" AutoGenerateColumns="True" CellPadding="4" ForeColor="#333333"> <AlternatingRowStyle BackColor="White" /> <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="sfTotal" runat="server" ConnectionString="<%$ ConnectionStrings:ProjectManagementConnectionString %>" SelectCommand=" select plan_id as [site], SUM(cast(CASE t1.CurWeek WHEN '' THEN 0 ELSE t1.CurWeek END as decimal)), SUM(cast(CASE t1.CurWeekNo1 WHEN '' THEN 0 ELSE t1.CurWeekNo1 END as decimal)), SUM(cast(CASE t1.CurWeekNo2 WHEN '' THEN 0 ELSE t1.CurWeekNo2 END as decimal)), SUM(cast(CASE t1.CurWeekNo3 WHEN '' THEN 0 ELSE t1.CurWeekNo3 END as decimal)), SUM(cast(CASE t1.CurWeekNo4 WHEN '' THEN 0 ELSE t1.CurWeekNo4 END as decimal)), SUM(cast(CASE t1.CurWeekNo5 WHEN '' THEN 0 ELSE t1.CurWeekNo5 END as decimal)), SUM(cast(CASE t1.CurWeekNo6 WHEN '' THEN 0 ELSE t1.CurWeekNo6 END as decimal)), SUM(cast(CASE t1.CurWeekNo7 WHEN '' THEN 0 ELSE t1.CurWeekNo7 END as decimal)), SUM(cast(CASE t1.CurWeekNo8 WHEN '' THEN 0 ELSE t1.CurWeekNo8 END as decimal)), SUM(cast(CASE t1.CurWeekNo9 WHEN '' THEN 0 ELSE t1.CurWeekNo9 END as decimal)), SUM(cast(CASE t1.CurWeekNo10 WHEN '' THEN 0 ELSE t1.CurWeekNo10 END as decimal)), SUM(cast(CASE t1.CurWeekNo11 WHEN '' THEN 0 ELSE t1.CurWeekNo11 END as decimal)), SUM(cast(CASE t1.CurWeekNo12 WHEN '' THEN 0 ELSE t1.CurWeekNo12 END as decimal)), SUM(cast(CASE t1.CurWeekNo13 WHEN '' THEN 0 ELSE t1.CurWeekNo13 END as decimal)), SUM(cast(CASE t1.CurWeekNo14 WHEN '' THEN 0 ELSE t1.CurWeekNo14 END as decimal)), SUM(cast(CASE t1.CurWeekNo15 WHEN '' THEN 0 ELSE t1.CurWeekNo15 END as decimal)), SUM(cast(CASE t1.CurWeekNo16 WHEN '' THEN 0 ELSE t1.CurWeekNo16 END as decimal)), SUM(cast(CASE t1.CurWeekNo17 WHEN '' THEN 0 ELSE t1.CurWeekNo17 END as decimal)), SUM(cast(CASE t1.CurWeekNo18 WHEN '' THEN 0 ELSE t1.CurWeekNo18 END as decimal)), SUM(cast(CASE t1.CurWeekNo19 WHEN '' THEN 0 ELSE t1.CurWeekNo19 END as decimal)), SUM(cast(CASE t1.CurWeekNo20 WHEN '' THEN 0 ELSE t1.CurWeekNo20 END as decimal)), SUM(cast(CASE t1.CurWeekNo21 WHEN '' THEN 0 ELSE t1.CurWeekNo21 END as decimal)), SUM(cast(CASE t1.CurWeekNo22 WHEN '' THEN 0 ELSE t1.CurWeekNo22 END as decimal)), SUM(cast(CASE t1.CurWeek WHEN '' THEN 0 ELSE t1.CurWeek END as decimal))+ SUM(cast(CASE t1.CurWeekNo1 WHEN '' THEN 0 ELSE t1.CurWeekNo1 END as decimal))+ SUM(cast(CASE t1.CurWeekNo2 WHEN '' THEN 0 ELSE t1.CurWeekNo2 END as decimal))+ SUM(cast(CASE t1.CurWeekNo3 WHEN '' THEN 0 ELSE t1.CurWeekNo3 END as decimal))+ SUM(cast(CASE t1.CurWeekNo4 WHEN '' THEN 0 ELSE t1.CurWeekNo4 END as decimal))+ SUM(cast(CASE t1.CurWeekNo5 WHEN '' THEN 0 ELSE t1.CurWeekNo5 END as decimal))+ SUM(cast(CASE t1.CurWeekNo6 WHEN '' THEN 0 ELSE t1.CurWeekNo6 END as decimal))+ SUM(cast(CASE t1.CurWeekNo7 WHEN '' THEN 0 ELSE t1.CurWeekNo7 END as decimal))+ SUM(cast(CASE t1.CurWeekNo8 WHEN '' THEN 0 ELSE t1.CurWeekNo8 END as decimal))+ SUM(cast(CASE t1.CurWeekNo9 WHEN '' THEN 0 ELSE t1.CurWeekNo9 END as decimal))+ SUM(cast(CASE t1.CurWeekNo10 WHEN '' THEN 0 ELSE t1.CurWeekNo10 END as decimal))+ SUM(cast(CASE t1.CurWeekNo11 WHEN '' THEN 0 ELSE t1.CurWeekNo11 END as decimal))+ SUM(cast(CASE t1.CurWeekNo12 WHEN '' THEN 0 ELSE t1.CurWeekNo12 END as decimal))+ SUM(cast(CASE t1.CurWeekNo13 WHEN '' THEN 0 ELSE t1.CurWeekNo13 END as decimal))+ SUM(cast(CASE t1.CurWeekNo14 WHEN '' THEN 0 ELSE t1.CurWeekNo14 END as decimal))+ SUM(cast(CASE t1.CurWeekNo15 WHEN '' THEN 0 ELSE t1.CurWeekNo15 END as decimal))+ SUM(cast(CASE t1.CurWeekNo16 WHEN '' THEN 0 ELSE t1.CurWeekNo16 END as decimal))+ SUM(cast(CASE t1.CurWeekNo17 WHEN '' THEN 0 ELSE t1.CurWeekNo17 END as decimal))+ SUM(cast(CASE t1.CurWeekNo18 WHEN '' THEN 0 ELSE t1.CurWeekNo18 END as decimal))+ SUM(cast(CASE t1.CurWeekNo19 WHEN '' THEN 0 ELSE t1.CurWeekNo19 END as decimal))+ SUM(cast(CASE t1.CurWeekNo20 WHEN '' THEN 0 ELSE t1.CurWeekNo20 END as decimal))+ SUM(cast(CASE t1.CurWeekNo21 WHEN '' THEN 0 ELSE t1.CurWeekNo21 END as decimal))+ SUM(cast(CASE t1.CurWeekNo22 WHEN '' THEN 0 ELSE t1.CurWeekNo22 END as decimal)) as Total from usermodules.[user].sop_fluctuation t1 WHERE [type]=@type and ([division]=@division or [division]='Division') group by plan_id order by plan_id desc "> <SelectParameters> <asp:ControlParameter ControlID="type" DefaultValue="W1" Name="type" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="division" DefaultValue="A1" Name="division" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> </div> </div> <hr /> <div id="body"> <asp:GridView ID="report" runat="server" CellPadding="4" ForeColor="#333333" PageSize="30" ViewStateMode="Disabled"> <AlternatingRowStyle BackColor="White" /> <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> </div> </div> <script type="text/javascript"> //$(document).ready(function () { // $("#report").stickyTableHeaders({ fixedOffset: $("#fixedheader") }); //}); </script> </form> </body> </html>