/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/oh/ot.aspx
101 строка
6 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="ot.aspx.vb" Inherits="oh_ot" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>OT Report</title> <link href="../Styles/page.css" rel="stylesheet" /> <link href="../Styles/editableGrid1.css" rel="stylesheet" /> </head> <body> <form id="form1" runat="server"> <div class="center"> Report type: <asp:DropDownList ID="ddlReportType" runat="server"> <asp:ListItem Selected ="true">GHR_DEPT</asp:ListItem> <asp:ListItem>GHR_BAND</asp:ListItem> <asp:ListItem>NAME_ENG</asp:ListItem> <asp:ListItem Value="DATEPART(month, [date])">MONTH</asp:ListItem> </asp:DropDownList> Period: <asp:DropDownList ID="DropDownList1" runat="server"> <asp:ListItem>2017</asp:ListItem> <asp:ListItem>2016</asp:ListItem> <asp:ListItem>2015</asp:ListItem> </asp:DropDownList> <asp:ImageButton ID="Button1" runat="server" Text="Refresh" ImageUrl="~/Images/Refresh.png" /> </div> <div> <asp:GridView ID="gvReport" runat="server" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" style="margin: auto auto;" AutoGenerateColumns="False" DataSourceID="sdsData" AllowSorting="True"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:BoundField DataField="CRITERIA" HeaderText="CRITERIA" SortExpression="CRITERIA" /> <asp:BoundField DataField="WORKDAY_WHITE_OT_HR" HeaderText="WORKDAY WHITE hrs" ReadOnly="True" SortExpression="WORKDAY_WHITE_OT_HR" > <HeaderStyle CssClass="border_left" /> <ItemStyle CssClass="border_left" /> </asp:BoundField> <asp:BoundField DataField="WORKDAY_BLACK_OT_HR" HeaderText="WORKDAY BLACK hrs" ReadOnly="True" SortExpression="WORKDAY_BLACK_OT_HR" /> <asp:BoundField DataField="WORKDAY_OT_HR" HeaderText="WORKDAY TTL hrs" ReadOnly="True" SortExpression="WORKDAY_OT_HR" /> <asp:BoundField DataField="OT_WORKDAY_CNT" HeaderText="WORKDAY Count" ReadOnly="True" SortExpression="OT_WORKDAY_CNT" /> <asp:BoundField DataField="WEEKEND_WHITE_OT_HR" HeaderText="WEEKEND WHITE hrs" ReadOnly="True" SortExpression="WEEKEND_WHITE_OT_HR" > <HeaderStyle CssClass="border_left" /> <ItemStyle CssClass="border_left" /> </asp:BoundField> <asp:BoundField DataField="WEEKEND_BLACK_OT_HR" HeaderText="WEEKEND BLACK hrs" ReadOnly="True" SortExpression="WEEKEND_BLACK_OT_HR" /> <asp:BoundField DataField="WEEKEND_OT_HR" HeaderText="WEEKEND TTL hrs" ReadOnly="True" SortExpression="WEEKEND_OT_HR" /> <asp:BoundField DataField="OT_WEEKEND_CNT" HeaderText="WEEKEND Count" ReadOnly="True" SortExpression="OT_WEEKEND_CNT" /> <asp:BoundField DataField="TTL_WHITE_OT_HR" HeaderText="TTL WHITE hrs" ReadOnly="True" SortExpression="TTL_WHITE_OT_HR" > <HeaderStyle CssClass="border_left" /> <ItemStyle CssClass="border_left" /> </asp:BoundField> <asp:BoundField DataField="TTL_BLACK_OT_HR" HeaderText="TTL BLACK hrs" ReadOnly="True" SortExpression="TTL_BLACK_OT_HR" /> <asp:BoundField DataField="TTL_OT_HR" HeaderText="TTL hrs" ReadOnly="True" SortExpression="TTL_OT_HR" /> <asp:BoundField DataField="TTL_CNT" HeaderText="TTL Count" ReadOnly="True" SortExpression="TTL_CNT" /> </Columns> <FooterStyle BackColor="#CCCC99" /> <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" /> <RowStyle BackColor="#F7F7DE" /> <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#FBFBF2" /> <SortedAscendingHeaderStyle BackColor="#848384" /> <SortedDescendingCellStyle BackColor="#EAEAD3" /> <SortedDescendingHeaderStyle BackColor="#575357" /> </asp:GridView> <asp:SqlDataSource ID="sdsData" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="SELECT @PARAM as CRITERIA , sum(white_ot_hr) as TTL_WHITE_OT_HR , sum(black_ot_hr) as TTL_BLACK_OT_HR , sum(ttl_ot_hr) as TTL_OT_HR , sum( CASE IS_WEEKEND WHEN 0 THEN white_ot_hr ELSE 0 END ) as WORKDAY_WHITE_OT_HR , sum(CASE IS_WEEKEND WHEN 0 THEN BLACK_ot_hr ELSE 0 END ) as WORKDAY_BLACK_OT_HR , sum(CASE IS_WEEKEND WHEN 0 THEN ttl_ot_hr ELSE 0 END ) as WORKDAY_OT_HR , sum( CASE IS_WEEKEND WHEN 1 THEN white_ot_hr ELSE 0 END ) as WEEKEND_WHITE_OT_HR , sum(CASE IS_WEEKEND WHEN 1 THEN BLACK_ot_hr ELSE 0 END ) as WEEKEND_BLACK_OT_HR , sum(CASE IS_WEEKEND WHEN 1 THEN ttl_ot_hr ELSE 0 END ) as WEEKEND_OT_HR , count(*) as TTL_CNT , sum( CASE IS_WEEKEND WHEN 0 THEN 1 ELSE 0 END ) as OT_WORKDAY_CNT , sum(IS_WEEKEND) as OT_WEEKEND_CNT FROM hr.[dbo].[TB_OT_HISTORY] WHERE datepart(year,[DATE]) = @YEAR GROUP BY @PARAM"> <SelectParameters> <asp:ControlParameter ControlID="DropDownList1" Name="YEAR" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> </div> </form> </body> </html>