108 lines
10 KiB
Text
108 lines
10 KiB
Text
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeBehind="HphApprovePeople.aspx.cs" Inherits="safety.HphApprovePeople" MaintainScrollPositionOnPostback="true" %>
|
|
|
|
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
|
|
<fieldset>
|
|
<telerik:RadLabel runat="server" ID ="RadLabel1" AssociatedControlID="dChoice" Text="Soort" ></telerik:RadLabel>
|
|
<telerik:RadDropDownList runat="server" ID="dSoort" AutoPostBack="true">
|
|
<Items>
|
|
<telerik:DropDownListItem Value="" Text="Alles" />
|
|
<telerik:DropDownListItem Value="E" Text="Extern" />
|
|
<telerik:DropDownListItem Value="W" Text="Werknemer" Selected="true" />
|
|
</Items>
|
|
</telerik:RadDropDownList>
|
|
|
|
<telerik:RadLabel runat="server" ID ="ldc" AssociatedControlID="dChoice" Text="Filter todo" ></telerik:RadLabel>
|
|
<telerik:RadDropDownList runat="server" ID="dChoice" AutoPostBack="true">
|
|
<Items>
|
|
<telerik:DropDownListItem Value="" Text="Alles" />
|
|
<telerik:DropDownListItem Value="true" Text="To Do" Selected="true" />
|
|
<telerik:DropDownListItem Value="false" Text="Done" />
|
|
</Items>
|
|
</telerik:RadDropDownList>
|
|
</fieldset>
|
|
<telerik:RadGrid runat="server" ID="rg1" DataSourceID="SqlDataSource1" GroupPanelPosition="Top" AllowFilteringByColumn="True" CellSpacing="-1" GridLines="Both" OnItemDataBound="rg1_ItemDataBound">
|
|
<GroupingSettings CollapseAllTooltip="Collapse all groups" CaseSensitive="false" />
|
|
<MasterTableView AutoGenerateColumns="False" DataSourceID="SqlDataSource1" AllowFilteringByColumn="True" DataKeyNames="persid">
|
|
<DetailTables>
|
|
<telerik:GridTableView runat="server" AllowFilteringByColumn="False" DataKeyNames="persid,id" DataSourceID="SqlDataSource2" CommandItemDisplay="Top" AllowPaging="True" PageSize="100" AutoGenerateColumns="false" Name="ChildGrid">
|
|
<ParentTableRelation>
|
|
<telerik:GridRelationFields DetailKeyField="persid" MasterKeyField="persid" />
|
|
</ParentTableRelation>
|
|
<CommandItemSettings ShowAddNewRecordButton="False" />
|
|
<ColumnGroups>
|
|
|
|
<telerik:GridColumnGroup HeaderText="Risc datasheet" Name="RF" HeaderStyle-HorizontalAlign="Center"/>
|
|
<telerik:GridColumnGroup HeaderText="Max. Frequency" Name="MaxFreq" HeaderStyle-HorizontalAlign="Center"/>
|
|
<telerik:GridColumnGroup HeaderText="Approval" Name="Approve" HeaderStyle-HorizontalAlign="Center"/>
|
|
|
|
|
|
|
|
|
|
</ColumnGroups>
|
|
<Columns>
|
|
<telerik:GridBoundColumn DataField="persid" DataType="System.Int32" FilterControlAltText="Filter persid column" HeaderText="persid" SortExpression="persid" UniqueName="persid" Visible="false" />
|
|
<telerik:GridHyperLinkColumn DataType="System.Int32" HeaderText="RF" SortExpression="id" UniqueName="id" DataNavigateUrlFields="id,persid" DataNavigateUrlFormatString="~/HPHApprove.aspx?docaID={0}&persid={1}" DataTextField="id" DataTextFormatString="RF{0}" ColumnGroupName="RF"/>
|
|
<telerik:GridBoundColumn DataField="roleID" DataType="System.Int32" FilterControlAltText="Filter roleID column" HeaderText="roleID" SortExpression="roleID" UniqueName="roleID" ColumnGroupName="RF"/>
|
|
<telerik:GridBoundColumn DataField="roleName" FilterControlAltText="Filter roleName column" HeaderText="roleName" SortExpression="roleName" UniqueName="roleName" ColumnGroupName="RF"/>
|
|
<telerik:GridCheckBoxColumn DataField="checked" DataType="System.Boolean" FilterControlAltText="Filter checked column" HeaderText="checked" ReadOnly="True" SortExpression="checked" UniqueName="checked" ColumnGroupName="RF">
|
|
</telerik:GridCheckBoxColumn>
|
|
<telerik:GridBoundColumn DataField="text" FilterControlAltText="Filter text column" HeaderText="text" ReadOnly="True" SortExpression="text" UniqueName="text" ColumnGroupName="RF">
|
|
</telerik:GridBoundColumn>
|
|
<%--<telerik:GridBoundColumn DataField="wbcf" DataType="System.Int32" FilterControlAltText="Filter wbcf column" HeaderText="Wbc grid" SortExpression="wbcf" UniqueName="wbcf" ColumnGroupName="MaxFreq" />
|
|
<telerik:GridBoundColumn DataField="lrmf" DataType="System.Int32" FilterControlAltText="Filter lrmf column" HeaderText="urine grid" SortExpression="lrmf" UniqueName="lrmf" ColumnGroupName="MaxFreq" />
|
|
--%>
|
|
|
|
<telerik:GridBoundColumn DataField="MaxWbcFreq" DataType="System.Int32" FilterControlAltText="Filter MaxWbcFreq column" HeaderText="Wbc" SortExpression="MaxWbcFreq" UniqueName="MaxWbcFreq" ColumnGroupName="MaxFreq" />
|
|
|
|
<telerik:GridBoundColumn DataField="MaxWbcFreqOr" DataType="System.Int32" FilterControlAltText="Filter MaxWbcFreqOr column" HeaderText="Wbc Grid" SortExpression="MaxWbcFreqOr" UniqueName="MaxWbcFreqOr" ColumnGroupName="MaxFreq"/>
|
|
|
|
<telerik:GridBoundColumn DataField="MaxUrineFreq" DataType="System.Int32" FilterControlAltText="Filter MaxUrineFreq column" HeaderText="Urine" SortExpression="MaxUrineFreq" UniqueName="MaxUrineFreq" ColumnGroupName="MaxFreq"/>
|
|
<telerik:GridBoundColumn DataField="MaxUrineFreqOr" DataType="System.Int32" FilterControlAltText="Filter MaxUrineFreqOr column" HeaderText="Urine Grid" SortExpression="MaxUrineFreqOr" UniqueName="MaxUrineFreqOr" ColumnGroupName="MaxFreq"/>
|
|
<telerik:GridCheckBoxColumn DataField="AutoApprove" DataType="System.Boolean" FilterControlAltText="Filter AutoApprove column" HeaderText="Auto-Approve" ReadOnly="True" SortExpression="AutoApprove" UniqueName="AutoApprove" ColumnGroupName="Approve">
|
|
</telerik:GridCheckBoxColumn>
|
|
<telerik:GridBoundColumn DataField="HphChecked" DataType="System.DateTime" FilterControlAltText="Filter HphChecked column" HeaderText="Checked date" SortExpression="HphChecked" UniqueName="HphChecked" ColumnGroupName="Approve">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="HphCheckedBy" FilterControlAltText="Filter HphCheckedBy column" HeaderText="HphCheckedBy" SortExpression="Checked By" UniqueName="HphCheckedBy" ColumnGroupName="Approve">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridCheckBoxColumn DataField="toCheck" DataType="System.Boolean" FilterControlAltText="Filter toCheck column" HeaderText="To Check" ReadOnly="True" SortExpression="toCheck" UniqueName="toCheck" ColumnGroupName="Approve">
|
|
</telerik:GridCheckBoxColumn>
|
|
</Columns>
|
|
</telerik:GridTableView>
|
|
</DetailTables>
|
|
<Columns>
|
|
<telerik:GridBoundColumn DataField="persid" DataType="System.Int32" FilterControlAltText="Filter persid column" HeaderText="persid" SortExpression="persid" UniqueName="persid" AllowFiltering="false" HeaderStyle-Width="80px">
|
|
<HeaderStyle Width="80px"></HeaderStyle>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="fullname" FilterControlAltText="Filter fullname column" HeaderText="Fullname" ReadOnly="True" SortExpression="fullname" UniqueName="fullname" CurrentFilterFunction="Contains" ShowFilterIcon="false" AutoPostBackOnFilter="true" HeaderStyle-Width="150px" FilterControlWidth="120px">
|
|
<HeaderStyle Width="150px"></HeaderStyle>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="persGroup" FilterControlAltText="Filter persGroup column" HeaderText="persGroup" SortExpression="persGroup" UniqueName="persGroup" CurrentFilterFunction="Contains" ShowFilterIcon="false" AutoPostBackOnFilter="true" HeaderStyle-Width="60px" FilterControlWidth="30px">
|
|
<HeaderStyle Width="60px"></HeaderStyle>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="building" FilterControlAltText="Filter building column" HeaderText="Building" SortExpression="building" UniqueName="building" AllowFiltering="false">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="toCheck" DataType="System.Int32" FilterControlAltText="Filter toCheck column" HeaderText="# items" ReadOnly="True" SortExpression="toCheck" UniqueName="toCheck" AllowFiltering="false">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="TotalRF" DataType="System.Int32" FilterControlAltText="Filter TotalRF column" HeaderText="# of RF" ReadOnly="True" SortExpression="TotalRF" UniqueName="TotalRF" AllowFiltering="false">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="maxWbc" DataType="System.Int32" FilterControlAltText="Filter maxWbc column" HeaderText="WBC" ReadOnly="True" SortExpression="maxWbc" UniqueName="maxWbc" AllowFiltering="false">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="maxUrine" DataType="System.Int32" FilterControlAltText="Filter maxUrine column" HeaderText="Urine" ReadOnly="True" SortExpression="maxUrine" UniqueName="maxUrine" AllowFiltering="false">
|
|
</telerik:GridBoundColumn>
|
|
</Columns>
|
|
</MasterTableView>
|
|
</telerik:RadGrid>
|
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server" CancelSelectOnNullParameter="False" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>" SelectCommand="hphApprovePeople" SelectCommandType="StoredProcedure">
|
|
<SelectParameters>
|
|
<asp:ControlParameter ControlID="dSoort" DefaultValue="" Name="soort" PropertyName="SelectedValue" Type="String" />
|
|
<asp:ControlParameter ControlID="dChoice" Name="tocheck" PropertyName="SelectedValue" Type="Boolean" />
|
|
</SelectParameters>
|
|
</asp:SqlDataSource>
|
|
<br />
|
|
<asp:SqlDataSource ID="SqlDataSource2" runat="server" CancelSelectOnNullParameter="False" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>" SelectCommand="hphApprovePersid" SelectCommandType="StoredProcedure">
|
|
<SelectParameters>
|
|
<asp:Parameter DefaultValue="" Name="persid" Type="Int32" />
|
|
</SelectParameters>
|
|
</asp:SqlDataSource>
|
|
|
|
</asp:Content>
|