ModuleMaster/ga/noaccdayscountwdetails.aspx - main - ivan/ModMas

ModuleMaster/ga/noaccdayscountwdetails.aspx
163 строки6 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:4900d9fb6
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="noaccdayscountwdetails.aspx.vb" Inherits="GA_noaccdayscount" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <%--<meta http-equiv="refresh" content="60" />--%>
    <title>Working safe!</title>
    <style>
        html, body, form {
            width: 100%;
            height: 100%;
            margin: 0;
            overflow: hidden;
        }

        table {
            /*width: 100%;
            height: 100%;*/
            text-align: center;
        }

        .caption {
            font-size: 58pt;
            text-align: center;
            font-weight: bold;
            margin-top: 50px;
            margin-bottom: 50px;
            padding-left: 10px;
            padding-right: 10px;
            color: navy;
           
        }

        .caption2 {
            font-size: 44pt;
            text-align: center;
            font-weight: bold;
        }

        .caption3 {
            font-size: 210pt;
            text-align: center;
            font-weight: bold;
            color: green;
            background-color: lightyellow;
        }

        .container {
            height: 100%;
            background-color: green;
            background-image: url('../Images/yellowblack.jpg');

            font-family: Tahoma, Geneva, Verdana, sans-serif;
            overflow: hidden;
        }

        .maindiv {
            margin: 10px;
            background-color: white;
            border: 4px solid navy;
            height: auto;
        }

        .tbl {
            width: 100%;
            height: 80%;
            /*margin-top: 120px; 
            margin-bottom: 210px;*/
            display: block;
            border-top: 4px solid navy;
            border-bottom: 4px solid navy;
        }

        .tbl_td {
            /*padding-top: 65px; 
            padding-bottom: 65px;*/
            padding-left: 120px;
            padding-right: 120px;
            border-left: 4px solid navy;
        }

        .tbl_td1 {
            height: 50%;
        }
        #GridView1 th {
            width: 11%;
            border: 1px solid white;
        }
                #GridView1 td {
            font-size: 78pt;
            border: 1px solid navy;
            color: green;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <div class="container">
            <div class="maindiv">
                <div class="caption">
                    <div >
                        НАША ЦЕЛЬ - РАБОТАТЬ БЕЗ ПРОИСШЕСТВИЙ!
                    </div>

                    <div style="margin-top: 60px; color: black;">
                        OUR TARGET IS WORKING  SAFE!
                    </div>
                </div>
                <div>
                    <table class="tbl">
                        <tr>
                            <td class="caption2 tbl_td1"  style="color: navy;">МАКСИМАЛЬНОЕ КОЛИЧЕСТВО ДНЕЙ БЕЗ ПРОИСШЕСТВИЙ</td>
                            <td rowspan="2" class="caption3 tbl_td">
                                <asp:Label ID="lblDaysWOAccident" runat="server" Text="Label"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td class="caption2 tbl_td1 " style="color: black;">MAXIMUM DAYS WITHOUT ACCIDENT</td>
                        </tr>

                    </table>
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None"
                        style="margin: 0 auto; font-size: 32pt; text-align: center; vertical-align: middle;">
                        <Columns>
                            <asp:BoundField DataField="Production" HeaderText="Production" ReadOnly="True" SortExpression="Production" />
                            <asp:BoundField DataField="Washing Machine" HeaderText="Washing Machine" ReadOnly="True" SortExpression="WashingMachine" />
                            <asp:BoundField DataField="Injection" HeaderText="Injection" ReadOnly="True" SortExpression="Injection" />
                            <asp:BoundField DataField="TOC" HeaderText="TOC" ReadOnly="True" SortExpression="TOC" />
                            <asp:BoundField DataField="Production Control" HeaderText="Production Control" ReadOnly="True" SortExpression="Production Control" />
                            <asp:BoundField DataField="MM" HeaderText="MM" ReadOnly="True" SortExpression="MM" />
                            <asp:BoundField DataField="CS" HeaderText="CS" ReadOnly="True" SortExpression="CS" />
                            <asp:BoundField DataField="Total" HeaderText="Total" ReadOnly="True" SortExpression="Total" />
                        </Columns>
                        <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" 
                            Font-Bold="true" Font-Size="32"
                             />
                   </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="
select * from
(select id, DEPARTMENT from usermodules.[user].SAFETY_HISTORY_LOG )
src PIVOT (count(id) for DEPARTMENT in (
[Production]
,[Washing Machine]
,[Injection]
,[TOC]
,[Production Control]
,[MM]
,[CS]
)) pvt
left join (
SELECT COUNT(*) -1  as [Total] FROM usermodules.[user].SAFETY_HISTORY_LOG
) Ttl on 1=1"></asp:SqlDataSource>
                </div>
            </div>

        </div>
    </form>
</body>
</html>