NKC/NKC_WF/WebUserControls/cmp_DailyStatsList.ascx

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="cmp_DailyStatsList.ascx.cs" Inherits="NKC_WF.WebUserControls.cmp_DailyStatsList" %>

<%@ Register Src="~/WebUserControls/cmp_numRow.ascx" TagPrefix="uc1" TagName="cmp_numRow" %>
<%@ Register Src="~/WebUserControls/cmp_DailyStatsPlot.ascx" TagPrefix="uc1" TagName="cmp_DailyStatsPlot" %>

<div class="row" runat="server" id="divGraph">
    <div class="col-12">
        <uc1:cmp_DailyStatsPlot runat="server" ID="cmp_DailyStatsPlot" />
    </div>
</div>
<div class="row">
    <div class="col-12 col-md-3">
        <b class="text-uppercase"><%: traduci("DayProdStats") %></b>
    </div>
    <div class="col-12 col-md-9 text-right small">
        <div class="form-row mb-2">
            <div class="col-2">
                <asp:LinkButton runat="server" ID="lbtExportCsv" CssClass="btn btn-sm btn-outline-success" OnClick="lbtExportCsv_Click">Create CSV <i class="fa fa-file-excel-o" aria-hidden="true"></i></asp:LinkButton>
                <asp:HyperLink runat="server" ID="hlDownload" CssClass="btn btn-sm btn-outline-success" Target="_blank">Download CSV <i class="fa fa-download" aria-hidden="true"></i></asp:HyperLink>
            </div>
            <div class="col-2">
                <div class="input-group input-group-sm" runat="server" id="divType">
                    <div class="input-group-prepend">
                        <span class="input-group-text small"><%: traduci("PlotType") %></span>
                    </div>
                    <asp:DropDownList runat="server" ID="ddlType" AutoPostBack="true" OnSelectedIndexChanged="ddlType_SelectedIndexChanged" CssClass="form-control form-control-sm">
                        <asp:ListItem Text="OEE" Value="OEE"></asp:ListItem>
                        <asp:ListItem Text="Avg Parts/Hour" Value="AvgPartsHour"></asp:ListItem>
                        <asp:ListItem Text="Run Time (h)" Value="RunTime"></asp:ListItem>
                        <asp:ListItem Text="Available Time (h)" Value="AvailTime"></asp:ListItem>
                        <asp:ListItem Text="# Parts Produced" Value="NumPartsProd"></asp:ListItem>
                        <asp:ListItem Text="# Part Scrapped" Value="NumPartsScrap"></asp:ListItem>
                    </asp:DropDownList>
                </div>
            </div>
            <div class="col-1">
                <div class="input-group input-group-sm">
                    <div class="input-group-prepend">
                        <span class="input-group-text small"><%: traduci("PlotGraph") %></span>
                    </div>
                    <asp:CheckBox runat="server" ID="chkPlotGraph" AutoPostBack="true" OnCheckedChanged="chkPlotGraph_CheckedChanged" CssClass="form-control form-control-sm" Checked="true" />
                </div>
            </div>
            <div class="col-2">
                <div class="input-group input-group-sm">
                    <div class="input-group-prepend">
                        <span class="input-group-text small"><%: traduci("Machine") %></span>
                    </div>
                    <asp:DropDownList runat="server" ID="ddlMachine" AutoPostBack="true" OnSelectedIndexChanged="ddlMachine_SelectedIndexChanged" CssClass="form-control form-control-sm">
                        <asp:ListItem Text="--- ALL ---" Value="*" />
                        <asp:ListItem Text="NE01" Value="NE01" />
                        <asp:ListItem Text="NE02" Value="NE02" />
                        <asp:ListItem Text="NE03" Value="NE03" />
                    </asp:DropDownList>
                </div>
            </div>
            <div class="col-2">
                <div class="input-group input-group-sm">
                    <div class="input-group-prepend">
                        <span class="input-group-text small"><%: traduci("DtStart") %></span>
                    </div>
                    <asp:TextBox runat="server" ID="txtDateStart" AutoPostBack="true" TextMode="Date" OnTextChanged="txtDateStart_TextChanged" CssClass="form-control form-control-sm" />
                </div>
            </div>
            <div class="col-2">
                <div class="input-group input-group-sm">
                    <div class="input-group-prepend">
                        <span class="input-group-text small"><%: traduci("DtEnd") %></span>
                    </div>
                    <asp:TextBox runat="server" ID="txtDateEnd" AutoPostBack="true" TextMode="Date" OnTextChanged="txtDateEnd_TextChanged" CssClass="form-control form-control-sm" />
                </div>
            </div>
            <div class="col-1">
                <uc1:cmp_numRow runat="server" ID="cmp_numRow" numRow="10" />
            </div>
        </div>
    </div>
</div>
<div class="row">
    <div class="col-12 textCondens px-0">
        <asp:GridView ID="grView" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="PlaceCod,DataRif" DataSourceID="ods" CssClass="table table-sm table-striped text-right" OnPageIndexChanged="grView_PageIndexChanged">
            <HeaderStyle CssClass="default" />
            <PagerStyle CssClass="active GridPager" />
            <PagerSettings Mode="NumericFirstLast" />
            <SelectedRowStyle CssClass="table-info" />
            <EmptyDataTemplate>
                <%: traduci("NoRecord") %>
            </EmptyDataTemplate>
            <Columns>
                <asp:BoundField DataField="DataRif" HeaderText="Date-Time" SortExpression="DataRif" />
                <asp:BoundField DataField="PlaceCod" HeaderText="Machine" SortExpression="PlaceCod" />
                <asp:TemplateField HeaderText="OEE %" SortExpression="MinRun">
                    <ItemTemplate>
                        <asp:Label ID="lblOee" runat="server" Text='<%# ratioFix(Eval("MinRun"), Eval("MinDisp")) %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Avg Part/Hour" SortExpression="ItmProd">
                    <ItemTemplate>
                        <asp:Label ID="lblAvgPartHour" runat="server" Text='<%# $"{ratioCalc(Eval("ItmProd"), Eval("MinRun"))*60:N2}" %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Run Time (h)" SortExpression="MinRun">
                    <ItemTemplate>
                        <asp:Label ID="lblHourRun" runat="server" Text='<%# $"{ratioCalc(Eval("MinRun"), 60):N2}" %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Available Time (h)" SortExpression="MinDisp">
                    <ItemTemplate>
                        <asp:Label ID="lblHourDisp" runat="server" Text='<%# $"{ratioCalc(Eval("MinDisp"), 60):N2}" %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="ItmProd" HeaderText="# Parts Produced" SortExpression="ItmProd" />
                <asp:BoundField DataField="ItmScrap" HeaderText="# Parts Scrapped" SortExpression="ItmScrap" />
            </Columns>
        </asp:GridView>
        <asp:ObjectDataSource ID="ods" runat="server" SelectMethod="getFilt" TypeName="AppData.DS_AppTableAdapters.ProductionStatsDayTableAdapter">
            <SelectParameters>
                <asp:ControlParameter ControlID="txtDateStart" Name="dtStart" PropertyName="Text" Type="DateTime" />
                <asp:ControlParameter ControlID="txtDateEnd" Name="dtEnd" PropertyName="Text" Type="DateTime" />
                <asp:ControlParameter ControlID="ddlMachine" Name="PlaceCod" PropertyName="SelectedValue" DefaultValue="*" />
            </SelectParameters>
        </asp:ObjectDataSource>
        <asp:HiddenField runat="server" ID="hfFileName" />
    </div>
</div>