You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
560 lines
32 KiB
560 lines
32 KiB
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Schueler.aspx.vb" Inherits="LPWeb.Schueler" %>
|
|
<%@ Register Src="~/Defaults/Header.ascx" TagPrefix="shu" TagName="Header" %>
|
|
<%@ Register Src="~/UserControls/Menu1.ascx" TagPrefix="shu" TagName="Menu" %>
|
|
<%@ Register Src="~/Defaults/Footer.ascx" TagPrefix="shu" TagName="Footer" %>
|
|
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
|
|
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
|
|
|
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
|
<head id="Head1" runat="server">
|
|
<title></title>
|
|
<link href="~/Styles/Site.css" rel="stylesheet" type="text/css" />
|
|
<style type="text/css">
|
|
|
|
.style3
|
|
{
|
|
height: 111px;
|
|
}
|
|
.style4
|
|
{
|
|
width: 256px;
|
|
}
|
|
.style5
|
|
{
|
|
}
|
|
.style6
|
|
{
|
|
width: 78px;
|
|
}
|
|
.style8
|
|
{
|
|
width: 130px;
|
|
}
|
|
.style9
|
|
{
|
|
box-sizing: border-box;
|
|
-moz-box-sizing: border-box;
|
|
-ms-box-sizing: border-box;
|
|
-webkit-box-sizing: border-box;
|
|
-khtml-box-sizing: border-box;
|
|
width: 130px;
|
|
}
|
|
.auto-style4 {
|
|
height: 25px;
|
|
}
|
|
.auto-style5 {
|
|
width: 256px;
|
|
height: 25px;
|
|
}
|
|
</style>
|
|
<script type="text/javascript" id="telerikClientEvents1">
|
|
//<![CDATA[
|
|
function alertCallBackFn(arg) {
|
|
window.location = "../Firmen/Firmendaten1.aspx?Tab=3"
|
|
//radalert("<strong>radalert</strong> returned the following result: <h3 style='color: #ff0000;'>" + arg + "</h3>", null, null, "Result");
|
|
}
|
|
function alertCallBackFnError(arg) {
|
|
//window.location = "../Firmen/Firmendaten1.aspx?Tab=3"
|
|
//radalert("<strong>radalert</strong> returned the following result: <h3 style='color: #ff0000;'>" + arg + "</h3>", null, null, "Result");
|
|
}
|
|
|
|
|
|
//]]>
|
|
</script>
|
|
</head>
|
|
|
|
<body>
|
|
<script type="text/javascript">
|
|
function ConfirmCallBackFn(arg) {
|
|
var ajaxManager = $find("<%=RadAjaxManager1.ClientID%>");
|
|
if (arg) {
|
|
ajaxManager.ajaxRequest('ok');
|
|
}
|
|
else {
|
|
ajaxManager.ajaxRequest('cancel');
|
|
}
|
|
}
|
|
function ConfirmCallBackFn1(arg) {
|
|
var ajaxManager = $find("<%=RadAjaxManager1.ClientID%>");
|
|
if (arg) {
|
|
ajaxManager.ajaxRequest('neu');
|
|
}
|
|
else {
|
|
ajaxManager.ajaxRequest('save');
|
|
}
|
|
}
|
|
|
|
function pageLoad() {
|
|
var list = $find("<%=RadListBox1.ClientID %>");
|
|
var item = list.get_selectedItem();
|
|
try {
|
|
if (item == null) {
|
|
var items = list.get_items();
|
|
item = items.getItem(0);
|
|
item.set_selected(true);
|
|
}
|
|
|
|
item.scrollIntoView();
|
|
}
|
|
catch (err) { };
|
|
}
|
|
</script>
|
|
<form id="form1" runat="server" method="post">
|
|
<telerik:RadScriptManager ID="ScriptManager1" runat="server"
|
|
EnableTheming="True">
|
|
<scripts>
|
|
<asp:ScriptReference Assembly="Telerik.Web.UI"
|
|
Name="Telerik.Web.UI.Common.Core.js">
|
|
</asp:ScriptReference>
|
|
<asp:ScriptReference Assembly="Telerik.Web.UI"
|
|
Name="Telerik.Web.UI.Common.jQuery.js">
|
|
</asp:ScriptReference>
|
|
<asp:ScriptReference Assembly="Telerik.Web.UI"
|
|
Name="Telerik.Web.UI.Common.jQueryInclude.js">
|
|
</asp:ScriptReference>
|
|
</scripts>
|
|
</telerik:RadScriptManager>
|
|
<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
|
|
|
|
<script type="text/javascript">
|
|
// this method is invoked from the flash animation
|
|
function InitiateAsyncRequest(argument) {
|
|
var ajaxManager = $find("<%= RadAjaxManager1.ClientID %>");
|
|
ajaxManager.ajaxRequest(argument);
|
|
return false;
|
|
}
|
|
function RefreshDescription(sender, eventArgs) {
|
|
var ajaxManager = $find("<%= RadAjaxManager1.ClientID %>");
|
|
//ajaxManager.ajaxRequest(sender.get_selectedItem().get_value())
|
|
ajaxManager.ajaxRequestWithTarget("<%= RadListBox1.UniqueID %>", sender.get_selectedItem().get_text());
|
|
//alert(sender.get_selectedItem().get_value())
|
|
}
|
|
function RefreshKlasse(sender, eventArgs) {
|
|
var ajaxManager = $find("<%= RadAjaxManager1.ClientID %>");
|
|
//ajaxManager.ajaxRequest(sender.get_selectedItem().get_value())
|
|
ajaxManager.ajaxRequestWithTarget("<%= RadComboBox1.UniqueID %>", sender.get_selectedItem().get_text());
|
|
//alert(sender.get_selectedItem().get_value())
|
|
}
|
|
</script>
|
|
|
|
</telerik:RadCodeBlock>
|
|
|
|
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
|
|
<AjaxSettings>
|
|
<telerik:AjaxSetting AjaxControlID="RadAjaxManager1">
|
|
<UpdatedControls>
|
|
<telerik:AjaxUpdatedControl ControlID="Panel1" LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel2" LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
</UpdatedControls>
|
|
</telerik:AjaxSetting>
|
|
<telerik:AjaxSetting AjaxControlID="RadComboBox1">
|
|
<UpdatedControls>
|
|
<telerik:AjaxUpdatedControl ControlID="Panel1"
|
|
LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel2"
|
|
LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel4"
|
|
LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
</UpdatedControls>
|
|
</telerik:AjaxSetting>
|
|
<telerik:AjaxSetting AjaxControlID="RadListBox1">
|
|
<UpdatedControls>
|
|
<telerik:AjaxUpdatedControl ControlID="lblklassestatus" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel2"
|
|
LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel3" />
|
|
<telerik:AjaxUpdatedControl ControlID="lblschuelerstatus" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel4"
|
|
LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
</UpdatedControls>
|
|
</telerik:AjaxSetting>
|
|
<telerik:AjaxSetting AjaxControlID="chkAlleSchuler">
|
|
<UpdatedControls>
|
|
<telerik:AjaxUpdatedControl ControlID="Panel1"
|
|
LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
</UpdatedControls>
|
|
</telerik:AjaxSetting>
|
|
<telerik:AjaxSetting AjaxControlID="RadButton3">
|
|
<UpdatedControls>
|
|
<telerik:AjaxUpdatedControl ControlID="lblklassestatus" />
|
|
<telerik:AjaxUpdatedControl ControlID="RadListBox1" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel3" />
|
|
<telerik:AjaxUpdatedControl ControlID="lblschuelerstatus" />
|
|
<telerik:AjaxUpdatedControl ControlID="RadGridSchuelerberuf" />
|
|
</UpdatedControls>
|
|
</telerik:AjaxSetting>
|
|
<telerik:AjaxSetting AjaxControlID="btnneuerschueler">
|
|
<UpdatedControls>
|
|
<telerik:AjaxUpdatedControl ControlID="lblklassestatus" />
|
|
<telerik:AjaxUpdatedControl ControlID="RadListBox1"
|
|
LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel2"
|
|
LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel3" />
|
|
<telerik:AjaxUpdatedControl ControlID="lblschuelerstatus" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel4"
|
|
LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
</UpdatedControls>
|
|
</telerik:AjaxSetting>
|
|
<telerik:AjaxSetting AjaxControlID="RadButton1">
|
|
<UpdatedControls>
|
|
<telerik:AjaxUpdatedControl ControlID="Panel1"
|
|
LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel3" />
|
|
<telerik:AjaxUpdatedControl ControlID="lblschuelerstatus" />
|
|
<telerik:AjaxUpdatedControl ControlID="RadGridSchuelerberuf" />
|
|
</UpdatedControls>
|
|
</telerik:AjaxSetting>
|
|
<telerik:AjaxSetting AjaxControlID="cbBeruf">
|
|
<UpdatedControls>
|
|
<telerik:AjaxUpdatedControl ControlID="txtBerufnr" />
|
|
</UpdatedControls>
|
|
</telerik:AjaxSetting>
|
|
<telerik:AjaxSetting AjaxControlID="btnInsertBeruf">
|
|
<UpdatedControls>
|
|
<telerik:AjaxUpdatedControl ControlID="RadWindowManager1" />
|
|
<telerik:AjaxUpdatedControl ControlID="RadListBox1" />
|
|
<telerik:AjaxUpdatedControl ControlID="cbKlassentyp" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel3" LoadingPanelID="RadAjaxLoadingPanel1" />
|
|
<telerik:AjaxUpdatedControl ControlID="lblschuelerstatus" />
|
|
<telerik:AjaxUpdatedControl ControlID="Panel4" LoadingPanelID="RadAjaxLoadingPanel1" UpdatePanelCssClass="" />
|
|
</UpdatedControls>
|
|
</telerik:AjaxSetting>
|
|
<telerik:AjaxSetting AjaxControlID="RadGridSchuelerberuf">
|
|
<UpdatedControls>
|
|
<telerik:AjaxUpdatedControl ControlID="RadListBox1" />
|
|
<telerik:AjaxUpdatedControl ControlID="cbKlassentyp" UpdatePanelCssClass="" />
|
|
<telerik:AjaxUpdatedControl ControlID="lblschuelerstatus" />
|
|
</UpdatedControls>
|
|
</telerik:AjaxSetting>
|
|
</AjaxSettings>
|
|
</telerik:RadAjaxManager>
|
|
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" >
|
|
</telerik:RadAjaxLoadingPanel>
|
|
<telerik:RadWindowManager ID="RadWindowManager1" ShowContentDuringLoad="false" VisibleStatusbar="false"
|
|
ReloadOnShow="true" runat="server" EnableShadow="true" Skin="Default">
|
|
<Windows>
|
|
<telerik:RadWindow ID="RadWindow1" runat="server" Behaviors="Close"
|
|
NavigateUrl="~/UserControls/Dialogbox.aspx">
|
|
</telerik:RadWindow>
|
|
</Windows>
|
|
</telerik:RadWindowManager>
|
|
|
|
|
|
<div class="page">
|
|
<shu:Header runat="Server" ID="Header1"></shu:Header>
|
|
<shu:Menu runat="server" ID="Menu1" NavigationLanguage="VB"></shu:Menu>
|
|
<div class="main">
|
|
<h2>Schüler</h2>
|
|
<p>
|
|
<table style="width:100%;">
|
|
<tr>
|
|
<td valign="top" >
|
|
<asp:Panel ID="Panel1" runat="server" BorderStyle="None"
|
|
height="412px" width="200px" BorderWidth="1px">
|
|
<telerik:RadComboBox ID="RadComboBox1" Runat="server"
|
|
Culture="de-DE" DataSourceID="SqlDataSource1"
|
|
DataTextField="Bezeichnung" DataValueField="KlasseNr" Width="140px" Label="Klasse"
|
|
OnClientSelectedIndexChanged="RefreshKlasse">
|
|
</telerik:RadComboBox>
|
|
<br />
|
|
<asp:Label ID="lblklassestatus" runat="server" Text=""></asp:Label>
|
|
<br />
|
|
|
|
<telerik:RadListBox ID="RadListBox1" runat="server" Culture="de-DE"
|
|
DataSourceID="SqlDataSource2" DataTextField="Schuelername"
|
|
DataValueField="Schuelernr" Height="300px"
|
|
Width="198px" OnClientSelectedIndexChanged="RefreshDescription"
|
|
>
|
|
</telerik:RadListBox>
|
|
<asp:CheckBox ID="chkAlleSchuler" runat="server" AutoPostBack="True"
|
|
Text="Alle Schüler" />
|
|
</asp:Panel>
|
|
</td>
|
|
<td valign="top" class="style3">
|
|
|
|
<asp:Panel ID="Panel2" runat="server" height="111px" BackColor="#CCE6FF">
|
|
<table style="width:100%; height: 85px;">
|
|
<tr>
|
|
<td class="auto-style4">
|
|
<strong>Schüler</strong></td>
|
|
<td class="auto-style4">
|
|
</td>
|
|
<td class="auto-style5">
|
|
<telerik:RadTextBox ID="txtname" Runat="server" Label="Name" LabelWidth="80px"
|
|
Width="220px" TabIndex="1">
|
|
</telerik:RadTextBox>
|
|
</td>
|
|
<td class="auto-style4">
|
|
<telerik:RadComboBox ID="cbklasse" Runat="server" Culture="de-DE"
|
|
DataSourceID="SqlDataSource1" DataTextField="Bezeichnung"
|
|
DataValueField="KlasseNr" Label="Klasse " LabelCssClass="riLabel"
|
|
Width="140px" TabIndex="4">
|
|
</telerik:RadComboBox>
|
|
</td>
|
|
<td class="auto-style4">
|
|
<telerik:RadButton ID="RadButton3" runat="server" Text="Schüler löschen"
|
|
Width="90px">
|
|
</telerik:RadButton>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>
|
|
<telerik:RadButton ID="btnneuerschueler" runat="server" Text="Neu"
|
|
TabIndex="-1">
|
|
</telerik:RadButton>
|
|
</td>
|
|
<td class="riLabel">
|
|
</td>
|
|
<td class="style4">
|
|
<telerik:RadTextBox ID="txtvorname" Runat="server" Label="Vorname"
|
|
LabelWidth="80px" Width="220px" TabIndex="2">
|
|
</telerik:RadTextBox>
|
|
</td>
|
|
<td>
|
|
<telerik:RadComboBox ID="cbKlassentyp" Runat="server" Culture="de-DE"
|
|
DataSourceID="SqlDataSource4" DataTextField="bezeichnung"
|
|
DataValueField="klassenr" Label="Stufe "
|
|
Width="140px" TabIndex="5">
|
|
</telerik:RadComboBox>
|
|
</td>
|
|
<td>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="riLabel">
|
|
</td>
|
|
<td class="riLabel">
|
|
</td>
|
|
<td class="style5">
|
|
<telerik:RadTextBox ID="txtBemerkung" Runat="server" Label="Bemerk."
|
|
LabelWidth="80px" Width="220px" TabIndex="3">
|
|
</telerik:RadTextBox>
|
|
</td>
|
|
<td colspan="2">
|
|
<asp:CheckBox ID="chkaktiv" runat="server" Text="Aktiv" TextAlign="Left"
|
|
TabIndex="6" Visible="False" />
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="riLabel" align="center" colspan="5">
|
|
<telerik:RadButton ID="RadButton1" runat="server" TabIndex="7"
|
|
Text="Schülerdaten speichern">
|
|
</telerik:RadButton>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</asp:Panel>
|
|
<br />
|
|
<asp:Panel id="Panel3" runat="server" Height="83px" BackColor="#EEEEEE">
|
|
<table style="width:100%;">
|
|
<tr>
|
|
<td class="style6">
|
|
<strong>Berufe</strong></td>
|
|
<td class="style8">
|
|
<asp:Label ID="Label1" runat="server" CssClass="riLabel" Text="Beruf"></asp:Label>
|
|
wählen oder</td>
|
|
<td class="style4">
|
|
<telerik:RadComboBox ID="cbBeruf" Runat="server" Culture="de-DE"
|
|
DataSourceID="SqlDataSource3" DataTextField="bezeichnung"
|
|
DataValueField="Berufnr" LabelCssClass="riLabel" Width="300px"
|
|
TabIndex="8">
|
|
</telerik:RadComboBox>
|
|
</td>
|
|
<td>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="style6">
|
|
</td>
|
|
<td class="style9">
|
|
<asp:Label ID="Label2" runat="server" CssClass="riLabel" Text="Berufs-Nr"></asp:Label>
|
|
eingeben</td>
|
|
<td class="style4">
|
|
<telerik:RadTextBox ID="txtBerufnr" Runat="server" TabIndex="9">
|
|
</telerik:RadTextBox>
|
|
</td>
|
|
<td>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="riLabel" style="width: 78px">
|
|
</td>
|
|
<td class="riLabel" colspan="3">
|
|
<telerik:RadButton ID="btnInsertBeruf" runat="server"
|
|
Text="Berufswahl einfügen" TabIndex="10">
|
|
</telerik:RadButton>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</asp:Panel>
|
|
<br />
|
|
<asp:Label ID="lblschuelerstatus" runat="server" Text=""></asp:Label>
|
|
<asp:Panel ID="Panel4" runat="server" Height="180px">
|
|
<telerik:RadGrid ID="RadGridSchuelerberuf" runat="server" AutoGenerateColumns="False"
|
|
CellSpacing="0" Culture="de-DE" DataSourceID="SqlDataSource5"
|
|
GridLines="None" AllowAutomaticDeletes="True"
|
|
AllowAutomaticUpdates="True" AllowPaging="True" AllowSorting="True" PageSize="5">
|
|
<MasterTableView DataSourceID="SqlDataSource5" CommandItemDisplay="Top"
|
|
TableLayout="Fixed" DataKeyNames="SchuelerBerufNr" NoMasterRecordsText="Keine Daten vorhanden"
|
|
EditMode="PopUp">
|
|
<CommandItemSettings ExportToPdfText="PDF-Export"
|
|
ExportToExcelText="Excel-Export"
|
|
RefreshText="Aktualisieren" AddNewRecordText="" ShowAddNewRecordButton="False">
|
|
</CommandItemSettings>
|
|
<RowIndicatorColumn Visible="True"
|
|
FilterControlAltText="Filter RowIndicator column">
|
|
</RowIndicatorColumn>
|
|
<ExpandCollapseColumn Visible="True"
|
|
FilterControlAltText="Filter ExpandColumn column">
|
|
</ExpandCollapseColumn>
|
|
<Columns>
|
|
<telerik:GridBoundColumn DataField="SchuelerBerufNr" DataType="System.Int32"
|
|
FilterControlAltText="Filter SchuelerBerufNr column"
|
|
HeaderText="SchuelerBerufNr" ReadOnly="True" SortExpression="SchuelerBerufNr"
|
|
UniqueName="SchuelerBerufNr" Visible="False" >
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="SchuelerNr" DataType="System.Int32"
|
|
FilterControlAltText="Filter SchuelerNr column" HeaderText="SchuelerNr"
|
|
SortExpression="SchuelerNr" UniqueName="SchuelerNr" Visible="False" ReadOnly="true">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="BerufNr" DataType="System.Int32"
|
|
FilterControlAltText="Filter BerufNr column" HeaderText="Berufs-Nr"
|
|
SortExpression="BerufNr" UniqueName="BerufNr" Visible="true" ReadOnly="true">
|
|
<HeaderStyle Width="90px" />
|
|
<ItemStyle Wrap="False" />
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="Beruf"
|
|
FilterControlAltText="Filter Beruf column" HeaderText="Beruf"
|
|
SortExpression="Beruf" UniqueName="Beruf" ReadOnly="true">
|
|
<HeaderStyle Width="200px" />
|
|
<ItemStyle Wrap="False" />
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="Bemerkung"
|
|
FilterControlAltText="Filter Bemerkung column" HeaderText="Bemerkung"
|
|
SortExpression="Bemerkung" UniqueName="Bemerkung">
|
|
<HeaderStyle Width="200px" />
|
|
<ItemStyle Wrap="False" />
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridCheckBoxColumn DataField="Aktiv" DataType="System.Boolean"
|
|
FilterControlAltText="Filter Aktiv column" HeaderText="Aktiv"
|
|
SortExpression="Aktiv" UniqueName="Aktiv" Visible="False" ReadOnly="true">
|
|
</telerik:GridCheckBoxColumn>
|
|
<telerik:GridBoundColumn DataField="Erstellt_am" DataType="System.DateTime"
|
|
FilterControlAltText="Filter Erstellt_am column" HeaderText="Erstellt_am"
|
|
SortExpression="Erstellt_am" UniqueName="Erstellt_am" Visible="False" ReadOnly="true">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="Mutiert_am" DataType="System.DateTime"
|
|
FilterControlAltText="Filter Mutiert_am column" HeaderText="Mutiert_am"
|
|
SortExpression="Mutiert_am" UniqueName="Mutiert_am" Visible="False" ReadOnly="true">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="Mutierer" DataType="System.Int32"
|
|
FilterControlAltText="Filter Mutierer column" HeaderText="Mutierer"
|
|
SortExpression="Mutierer" UniqueName="Mutierer" Visible="False" ReadOnly="true">
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="Prioritaet" DataType="System.Int32"
|
|
FilterControlAltText="Filter Prioritaet column" HeaderText="Priorität"
|
|
SortExpression="Prioritaet" UniqueName="Prioritaet">
|
|
<HeaderStyle Width="80px" />
|
|
<ItemStyle Wrap="False" />
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridEditCommandColumn FilterControlAltText="Filter EditCommandColumn column"
|
|
HeaderText="" ButtonType="ImageButton" ItemStyle-HorizontalAlign="Center">
|
|
<HeaderStyle Width="40px" />
|
|
|
|
<ItemStyle HorizontalAlign="Center"></ItemStyle>
|
|
</telerik:GridEditCommandColumn>
|
|
<telerik:GridButtonColumn ConfirmText="Berufswahl wirklich löschen?" ConfirmDialogType="RadWindow"
|
|
ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete" HeaderText=""
|
|
UniqueName="DeleteColumn" ItemStyle-HorizontalAlign="Center">
|
|
<ItemStyle HorizontalAlign="Center" CssClass="MyImageButton" />
|
|
<HeaderStyle Width="40px" />
|
|
</telerik:GridButtonColumn>
|
|
</Columns>
|
|
<EditFormSettings>
|
|
<EditColumn ButtonType="ImageButton" CancelText="Abbruch"
|
|
FilterControlAltText="Filter EditCommandColumn column" InsertText="Einfügen"
|
|
UpdateText="Speichern">
|
|
</EditColumn>
|
|
</EditFormSettings>
|
|
</MasterTableView>
|
|
<FilterMenu EnableImageSprites="False">
|
|
</FilterMenu>
|
|
</telerik:RadGrid>
|
|
|
|
* Priorität: Priorität der Berufe, wie der Schüler diese gewählt hat.</asp:Panel>
|
|
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td valign="top">
|
|
|
|
<telerik:RadButton ID="RadButton2" runat="server" Text="<- Zurück">
|
|
</telerik:RadButton>
|
|
|
|
<telerik:RadButton ID="RadButton4" runat="server" Text="Erfasste Daten drucken">
|
|
</telerik:RadButton>
|
|
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</p>
|
|
</div>
|
|
</div>
|
|
|
|
<shu:Footer runat="Server" ID="Footer1"></SHU:Footer>
|
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
|
|
ConnectionString="<%$ ConnectionStrings:LPConnectionString %>"
|
|
SelectCommand="SELECT [KlasseNr], [Bezeichnung] FROM [Klasse] WHERE aktiv=1 and lehrernr=@lehrernr">
|
|
<SelectParameters>
|
|
<asp:SessionParameter Name="Lehrernr" Type="Int32" sessionfield="Lehrer" />
|
|
</SelectParameters>
|
|
</asp:SqlDataSource>
|
|
|
|
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
|
|
ConnectionString="<%$ ConnectionStrings:LPConnectionString %>"
|
|
SelectCommand="select Schuelernr, name+' '+vorname as Schuelername from schueler where aktiv=1 and klassenr=@klassenr order by name, vorname">
|
|
<SelectParameters>
|
|
<asp:ControlParameter ControlID="RadComboBox1" DefaultValue="0" Name="klassenr"
|
|
PropertyName="SelectedValue" />
|
|
</SelectParameters>
|
|
</asp:SqlDataSource>
|
|
|
|
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
|
|
ConnectionString="<%$ ConnectionStrings:LPConnectionString %>"
|
|
SelectCommand="SELECT distinct dbo.Beruf.Berufnr, dbo.Beruf.Bezeichnung, dbo.Beruf.KlasseNr FROM dbo.Beruf INNER JOIN dbo.FirmaBeruf ON dbo.Beruf.Berufnr = dbo.FirmaBeruf.Berufnr WHERE (dbo.Beruf.Aktiv = 1) AND (dbo.FirmaBeruf.Aktiv = 1) ORDER BY dbo.Beruf.Bezeichnung">
|
|
</asp:SqlDataSource>
|
|
|
|
<asp:SqlDataSource ID="SqlDataSource4" runat="server"
|
|
ConnectionString="<%$ ConnectionStrings:LPConnectionString %>"
|
|
SelectCommand="SELECT [klassenr], [bezeichnung] FROM [web_klasse] where aktiv=1 and klassenr>0">
|
|
</asp:SqlDataSource>
|
|
|
|
<asp:SqlDataSource ID="SqlDataSource5" runat="server"
|
|
ConnectionString="<%$ ConnectionStrings:LPConnectionString %>"
|
|
SelectCommand="SELECT SchuelerBeruf.SchuelerBerufNr, SchuelerBeruf.SchuelerNr, SchuelerBeruf.BerufNr, SchuelerBeruf.Bemerkung, SchuelerBeruf.Aktiv, SchuelerBeruf.Erstellt_am,
|
|
SchuelerBeruf.Mutiert_am, SchuelerBeruf.Mutierer, SchuelerBeruf.Prioritaet, Beruf.Bezeichnung AS Beruf
|
|
FROM SchuelerBeruf INNER JOIN Beruf ON SchuelerBeruf.BerufNr = Beruf.Berufnr
|
|
WHERE schuelerberuf.aktiv=1 and Schuelerberuf.SchuelerNr = @Schuelernr"
|
|
DeleteCommand="Update schuelerberuf set aktiv=0, mutiert_am=getdate(), mutierer=@Mutierer where schuelerberufnr=@schuelerberufnr"
|
|
UpdateCommand="Update schuelerberuf set prioritaet=@prioritaet, bemerkung=@bemerkung, mutiert_am=getdate(), mutierer=@mutierer where schuelerberufnr=@schuelerberufnr">
|
|
<SelectParameters>
|
|
<asp:ControlParameter ControlID="RadListBox1" DefaultValue="0"
|
|
Name="SchuelerNr" PropertyName="SelectedValue" Type="Int32" />
|
|
</SelectParameters>
|
|
<DeleteParameters>
|
|
<asp:Parameter Name="Schuelerberufnr" Type="Int32" />
|
|
<asp:SessionParameter Name="Mutierer" Type="Int32" sessionfield="UserID" />
|
|
</DeleteParameters>
|
|
<UpdateParameters>
|
|
<asp:Parameter Name="Bemerkung" Type="String" />
|
|
<asp:Parameter Name="Prioritaet" Type="String" />
|
|
<asp:Parameter Name="Schuelerberufnr" Type="Int32" />
|
|
<asp:SessionParameter Name="Mutierer" Type="Int32" sessionfield="UserID" />
|
|
</UpdateParameters>
|
|
</asp:SqlDataSource>
|
|
</form>
|
|
</body>
|
|
</html> |