68 lines
4.8 KiB
Text
68 lines
4.8 KiB
Text
<%@ Page Title="" Language="C#" MasterPageFile="~/Site2n.master" AutoEventWireup="true" CodeBehind="ctsCylinders.aspx.cs" Inherits="safety.IES.ctsCylinders" %>
|
|
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
|
|
</asp:Content>
|
|
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
|
|
<telerik:RadDropDownList runat="server" ID="dBuilding" AutoPostBack="true" DataSourceID="SqlDSBuildings" DataTextField="BuildingText" DataValueField="BuildingID" DropDownWidth="400px" AppendDataBoundItems="true" >
|
|
<Items>
|
|
<telerik:DropDownListItem Text="Kies een gebouw" Value="0" />
|
|
</Items>
|
|
</telerik:RadDropDownList>
|
|
|
|
<telerik:RadGrid runat="server" ID="rgCylinders" DataSourceID="SqlDSCylinders" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AutoGenerateColumns="False" AutoGenerateEditColumn="True" >
|
|
<GroupingSettings CollapseAllTooltip="Collapse all groups" CaseSensitive="False"></GroupingSettings>
|
|
<ExportSettings IgnorePaging="True" OpenInNewWindow="True" FileName="Cylinders">
|
|
<Excel FileExtension="xlsx" Format="Xlsx" />
|
|
</ExportSettings>
|
|
|
|
<MasterTableView DataSourceID="SqlDSCylinders" CommandItemDisplay="Top" DataKeyNames="CylinderID">
|
|
<CommandItemSettings ShowExportToExcelButton="True" />
|
|
<Columns>
|
|
<telerik:GridBoundColumn DataField="CylinderID" DataType="System.Int32" FilterControlAltText="Filter CylinderID column" HeaderText="CylinderID" ReadOnly="True" SortExpression="CylinderID" UniqueName="CylinderID" Visible="False">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="Niveau" FilterControlAltText="Filter Niveau column" HeaderText="Niveau" SortExpression="Niveau" UniqueName="Niveau" ReadOnly="true">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridTemplateColumn DataField="RoomID" HeaderText="Room" SortExpression="Room" UniqueName="RoomID">
|
|
<EditItemTemplate>
|
|
<telerik:RadComboBox ID="RoomID" DataSourceID="SqlDSRooms" runat="server" SelectedValue='<%# Bind("RoomId") %>' DataTextField="RoomText" DataValueField="RoomID" Width="400px" />
|
|
</EditItemTemplate>
|
|
<ItemTemplate>
|
|
<asp:Label ID="RoomLabel" runat="server" Text='<%# Eval("Room") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</telerik:GridTemplateColumn>
|
|
<telerik:GridBoundColumn DataField="Omschrijving" FilterControlAltText="Filter Omschrijving column" HeaderText="Omschrijving" SortExpression="Omschrijving" UniqueName="Omschrijving" ReadOnly="true">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="Door" FilterControlAltText="Filter Door column" HeaderText="Door" SortExpression="Door" UniqueName="Door">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="Cylinder" FilterControlAltText="Filter Cylinder column" HeaderText="Cylinder" SortExpression="Cylinder" UniqueName="Cylinder">
|
|
</telerik:GridBoundColumn>
|
|
</Columns>
|
|
</MasterTableView>
|
|
|
|
</telerik:RadGrid>
|
|
|
|
|
|
<asp:SqlDataSource ID="SqlDSCylinders" runat="server" ConnectionString="<%$ ConnectionStrings:IESConnectionString %>" SelectCommand="cts.CylindersSelect" SelectCommandType="StoredProcedure" CancelSelectOnNullParameter="False" UpdateCommand="cts.CylindersUpdate" UpdateCommandType="StoredProcedure" InsertCommand="cts.CylindersInsert" InsertCommandType="StoredProcedure" >
|
|
<InsertParameters>
|
|
<asp:Parameter Name="RoomId" Type="Int32" />
|
|
<asp:Parameter Name="Door" Type="String" />
|
|
<asp:Parameter Name="Cylinder" Type="String" />
|
|
</InsertParameters>
|
|
<SelectParameters>
|
|
<asp:ControlParameter ControlID="dBuilding" Name="BuildingID" PropertyName="SelectedValue" Type="Int32" />
|
|
</SelectParameters>
|
|
<UpdateParameters>
|
|
<asp:Parameter Name="CylinderID" Type="Int32" />
|
|
<asp:Parameter Name="RoomId" Type="Int32" />
|
|
<asp:Parameter Name="Door" Type="String" />
|
|
<asp:Parameter Name="Cylinder" Type="String" />
|
|
</UpdateParameters>
|
|
</asp:SqlDataSource>
|
|
|
|
<asp:SqlDataSource ID="SqlDSBuildings" runat="server" ConnectionString="<%$ ConnectionStrings:IESConnectionString %>" SelectCommand="[cts].[CylindersBuildingsList]" SelectCommandType="StoredProcedure" CancelSelectOnNullParameter="False"/>
|
|
<asp:SqlDataSource ID="SqlDSRooms" runat="server" ConnectionString="<%$ ConnectionStrings:IESConnectionString %>" SelectCommand="[cts].[RoomsList]" SelectCommandType="StoredProcedure" CancelSelectOnNullParameter="False">
|
|
<SelectParameters>
|
|
<asp:ControlParameter ControlID="dBuilding" Name="BuildingID" PropertyName="SelectedValue" Type="Int32" />
|
|
</SelectParameters>
|
|
</asp:SqlDataSource>
|
|
|
|
</asp:Content>
|