57 lines
5.4 KiB
Text
57 lines
5.4 KiB
Text
|
<%@ Page Title="" Language="C#" MasterPageFile="~/Siten.master" AutoEventWireup="true" CodeBehind="phoneEmployees.aspx.cs" Inherits="safety.phoneEmployees" %>
|
||
|
|
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
|
||
|
|
<telerik:RadGrid runat="server" ID="gridRooms" AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1" GroupPanelPosition="Top" CellSpacing="-1" GridLines="Both" AllowFilteringByColumn="True" AllowSorting="True" AutoGenerateColumns="False">
|
||
|
|
|
||
|
|
<GroupingSettings CollapseAllTooltip="Collapse all groups" CaseSensitive="false"></GroupingSettings>
|
||
|
|
|
||
|
|
<ExportSettings OpenInNewWindow="true">
|
||
|
|
<Excel FileExtension="xlsx" />
|
||
|
|
</ExportSettings>
|
||
|
|
|
||
|
|
<MasterTableView AllowAutomaticUpdates="True" CommandItemDisplay="Top" DataKeyNames="persid" DataSourceID="SqlDataSource1">
|
||
|
|
<CommandItemSettings ShowAddNewRecordButton="False" ShowExportToExcelButton="True" />
|
||
|
|
|
||
|
|
<Columns>
|
||
|
|
<telerik:GridBoundColumn DataField="persid" DataType="System.Int32" FilterControlAltText="Filter persid column" HeaderText="persid" ReadOnly="True" SortExpression="persid" UniqueName="persid" CurrentFilterFunction="EqualTo" AutoPostBackOnFilter="true" ShowFilterIcon="false" FilterControlWidth="80px" HeaderStyle-Width="110px">
|
||
|
|
<HeaderStyle Width="110px"></HeaderStyle>
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="name" FilterControlAltText="Filter name column" HeaderText="Name" SortExpression="name" UniqueName="name" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" ShowFilterIcon="false" ReadOnly="true">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="callingname" FilterControlAltText="Filter callingname column" HeaderText="First name" SortExpression="callingname" UniqueName="callingname" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" ShowFilterIcon="false" ReadOnly="true">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="building" FilterControlAltText="Filter building column" HeaderText="Building" SortExpression="building" UniqueName="building" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" ShowFilterIcon="false" ReadOnly="true">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="office" FilterControlAltText="Filter office column" HeaderText="Office" SortExpression="office" UniqueName="office" AllowFiltering="false" ReadOnly="true">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="phone" FilterControlAltText="Filter phone column" HeaderText="Phone" SortExpression="phone" UniqueName="phone" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" ShowFilterIcon="false" FilterControlWidth="80px" HeaderStyle-Width="110px">
|
||
|
|
<HeaderStyle Width="110px"></HeaderStyle>
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="phone2" FilterControlAltText="Filter phone2 column" HeaderText="Phone2" SortExpression="phone2" UniqueName="phone2" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" ShowFilterIcon="false">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="fax" FilterControlAltText="Filter fax column" HeaderText="Fax" SortExpression="fax" UniqueName="fax" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" ShowFilterIcon="false" FilterControlWidth="80px" HeaderStyle-Width="110px">
|
||
|
|
<HeaderStyle Width="110px"></HeaderStyle>
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="gsm" FilterControlAltText="Filter gsm column" HeaderText="Gsm" SortExpression="gsm" UniqueName="gsm" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" ShowFilterIcon="false" FilterControlWidth="80px" HeaderStyle-Width="110px">
|
||
|
|
<HeaderStyle Width="110px"></HeaderStyle>
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="unit" FilterControlAltText="Filter unit column" HeaderText="Unit" SortExpression="unit" UniqueName="unit" DataType="System.Int16" CurrentFilterFunction="EqualTo" AutoPostBackOnFilter="true" ShowFilterIcon="false" ReadOnly="true" FilterControlWidth="80px" HeaderStyle-Width="110px">
|
||
|
|
<HeaderStyle Width="110px"></HeaderStyle>
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="unitInitials" FilterControlAltText="Filter unitInitials column" HeaderText="UnitInitials" SortExpression="unitInitials" UniqueName="unitInitials" ReadOnly="True" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true" ShowFilterIcon="false">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
</Columns>
|
||
|
|
</MasterTableView>
|
||
|
|
|
||
|
|
</telerik:RadGrid>
|
||
|
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:HRConnectionString %>" SelectCommand="phoneEmployeesSelect" SelectCommandType="StoredProcedure" UpdateCommand="phoneEmployeesUpdate" UpdateCommandType="StoredProcedure">
|
||
|
|
<UpdateParameters>
|
||
|
|
<asp:Parameter Name="persid" Type="Int32" />
|
||
|
|
<asp:Parameter Name="phone" Type="String" />
|
||
|
|
<asp:Parameter Name="phone2" Type="String" />
|
||
|
|
<asp:Parameter Name="gsm" Type="String" />
|
||
|
|
<asp:Parameter Name="fax" Type="String" />
|
||
|
|
</UpdateParameters>
|
||
|
|
|
||
|
|
</asp:SqlDataSource>
|
||
|
|
</asp:Content>
|