60 lines
4.5 KiB
Text
60 lines
4.5 KiB
Text
<%@ Page Title="" Language="C#" MasterPageFile="~/Site2n.master" AutoEventWireup="true" CodeBehind="ctsBuildings.aspx.cs" Inherits="safety.IES.ctsBuildings" %>
|
|
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
|
|
</asp:Content>
|
|
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
|
|
|
|
<telerik:RadGrid runat="server" ID="rgBuildings" DataSourceID="sqlDSBuildings" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AutoGenerateColumns="False" AutoGenerateEditColumn="True" >
|
|
<GroupingSettings CollapseAllTooltip="Collapse all groups" CaseSensitive="False"></GroupingSettings>
|
|
<ExportSettings IgnorePaging="True" OpenInNewWindow="True" FileName="Buildings">
|
|
<Excel FileExtension="xlsx" Format="Xlsx" />
|
|
</ExportSettings>
|
|
|
|
<MasterTableView DataSourceID="sqlDSBuildings" AllowSorting="True" CommandItemDisplay="Top" DataKeyNames="BuildingID">
|
|
<Columns>
|
|
<telerik:GridBoundColumn DataField="BuildingID" DataType="System.Int32" FilterControlAltText="Filter BuildingID column" HeaderText="BuildingID" ReadOnly="True" SortExpression="BuildingID" UniqueName="BuildingID" Visible="false">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="BuildingSiteID" DataType="System.Int32" FilterControlAltText="Filter BuildingSiteID column" HeaderText="BuildingSiteID" SortExpression="BuildingSiteID" UniqueName="BuildingSiteID" Visible="false">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="BuildingSite" FilterControlAltText="Filter BuildingSite column" HeaderText="BuildingSite" SortExpression="BuildingSite" UniqueName="BuildingSite">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="BuildingCode" FilterControlAltText="Filter BuildingCode column" HeaderText="BuildingCode" SortExpression="BuildingCode" UniqueName="BuildingCode">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="BuildingName" FilterControlAltText="Filter BuildingName column" HeaderText="BuildingName" SortExpression="BuildingName" UniqueName="BuildingName">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="BuildingRemark" FilterControlAltText="Filter BuildingRemark column" HeaderText="BuildingRemark" SortExpression="BuildingRemark" UniqueName="BuildingRemark">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="BuildingSAP" FilterControlAltText="Filter BuildingSAP column" HeaderText="BuildingSAP" SortExpression="BuildingSAP" UniqueName="BuildingSAP">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="SvgBuildingCode" HeaderText="SVG Code" SortExpression="SvgBuildingCode" UniqueName="SvgBuildingCode" HeaderTooltip="contact Katrijn">
|
|
</telerik:GridBoundColumn>
|
|
|
|
</Columns>
|
|
</MasterTableView>
|
|
</telerik:RadGrid>
|
|
|
|
<asp:SqlDataSource ID="sqlDSBuildings" runat="server" ConnectionString="<%$ ConnectionStrings:IESConnectionString %>" SelectCommand="cts.BuildingsSelect" SelectCommandType="StoredProcedure" CancelSelectOnNullParameter="False" UpdateCommand="cts.BuildingsUpdate" UpdateCommandType="StoredProcedure" InsertCommand="cts.BuildingsInsert" InsertCommandType="StoredProcedure" >
|
|
<InsertParameters>
|
|
<asp:Parameter Direction="ReturnValue" Name="RETURN_VALUE" Type="Int32" />
|
|
<asp:Parameter Name="BuildingSiteID" Type="Int32" />
|
|
<asp:Parameter Name="BuildingCode" Type="String" />
|
|
<asp:Parameter Name="BuildingName" Type="String" />
|
|
<asp:Parameter Name="BuildingRemark" Type="String" />
|
|
<asp:Parameter Name="BuildingSAP" Type="String" />
|
|
<asp:Parameter Name="SvgBuildingCode" Type="String" />
|
|
</InsertParameters>
|
|
<SelectParameters>
|
|
<asp:Parameter Direction="ReturnValue" Name="RETURN_VALUE" Type="Int32" />
|
|
</SelectParameters>
|
|
<UpdateParameters>
|
|
<asp:Parameter Direction="ReturnValue" Name="RETURN_VALUE" Type="Int32" />
|
|
<asp:Parameter Name="BuildingID" Type="Int32" />
|
|
<asp:Parameter Name="BuildingSiteID" Type="Int32" />
|
|
<asp:Parameter Name="BuildingCode" Type="String" />
|
|
<asp:Parameter Name="BuildingName" Type="String" />
|
|
<asp:Parameter Name="BuildingRemark" Type="String" />
|
|
<asp:Parameter Name="BuildingSAP" Type="String" />
|
|
<asp:Parameter Name="SvgBuildingCode" Type="String" />
|
|
</UpdateParameters>
|
|
</asp:SqlDataSource>
|
|
|
|
</asp:Content>
|