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.
79 lines
4.1 KiB
79 lines
4.1 KiB
<%@ Page Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="MergeAthlethen.aspx.cs" Inherits="QW2021C.Administration.MergeAthlethen" %>
|
|
|
|
<%@ Register Assembly="Syncfusion.EJ.Web, Version=18.3460.0.35, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" Namespace="Syncfusion.JavaScript.Web" TagPrefix="ej" %>
|
|
<%@ Register Assembly="Syncfusion.EJ, Version=18.3460.0.35, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" Namespace="Syncfusion.JavaScript.Models" TagPrefix="ej" %>
|
|
|
|
<%@ Register Assembly="Syncfusion.EJ" Namespace="Syncfusion.JavaScript.Models" TagPrefix="ej" %>
|
|
|
|
<asp:Content ID="MainContent" ContentPlaceHolderID="MainContent" runat="Server">
|
|
<asp:Label runat="server"><h4>Zusammenführung nicht lizenzierte Teilnehmer / lizenzierte Athleten</h4></asp:Label>
|
|
<ej:Grid ID="Grid1" runat="server" CssClass="" DataSourceCachingMode="None" DataSourceID="SqlDataSource1" EnableLoadOnDemand="True" Locale="de-CH" MinWidth="0" AllowPaging="True" AllowSorting="True" AllowFiltering="True" OnServerCommandButtonClick="Grid1_ServerCommandButtonClick">
|
|
<ClientSideEvents RowDataBound="rowDataBound" />
|
|
<Columns>
|
|
<ej:Column DataType="number" Field="id_athlete" AllowEditing="False" IsIdentity="True" IsPrimaryKey="True" HeaderText="ID">
|
|
</ej:Column>
|
|
<ej:Column DataType="number" Field="Teilnehmernr" IsPrimaryKey="True" HeaderText="TLNr">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="license" HeaderText="Lic">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="lastname" HeaderText="Name">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="firstname" HeaderText="Vorname">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="sex" HeaderText="G.">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="license_cat">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="nationality" HeaderText="Nat.">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="account_code" HeaderText="Verein">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="birth_date" HeaderText="Geb.-DaT">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="TLizenz" HeaderText="Zuget Liz.">
|
|
</ej:Column>
|
|
<%-- <ej:Column DataType="string" Field="Name">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="Vorname">
|
|
</ej:Column>
|
|
<ej:Column AllowEditing="False" DataType="string" Field="TGebDat">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="Kategorie">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="Geschlecht">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="Nationalitaet">
|
|
</ej:Column>--%>
|
|
<ej:Column DataType="string" Field="base_lizenz" HeaderText="Base-Liz.">
|
|
|
|
</ej:Column>
|
|
<ej:Column HeaderText="Funktion" Width="170px">
|
|
<Command>
|
|
<ej:Commands Type="Merge" >
|
|
<ButtonOptions Text="Zusammenführen" Click="onClick" Width="130px" />
|
|
</ej:Commands>
|
|
</Command>
|
|
|
|
</ej:Column>
|
|
</Columns>
|
|
</ej:Grid>
|
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:QWToolConnectionstring %>"
|
|
SelectCommand="sp_mergeathleten" SelectCommandType="StoredProcedure">
|
|
<SelectParameters>
|
|
<asp:Parameter DefaultValue="0" Name="fnkt" Type="Int32" />
|
|
<asp:Parameter DefaultValue="1.ZH.1837" Name="verein" Type="String" />
|
|
</SelectParameters>
|
|
</asp:SqlDataSource>
|
|
<script type="text/javascript">
|
|
|
|
function rowDataBound(args) {
|
|
|
|
if (args.data.base_lizenz != "")
|
|
args.row.css("backgroundColor", "#F3C3C3").css("color", "black");/*custom css applied to the row */
|
|
if (args.data.base_lizenz != "")
|
|
args.row.find(".e-unboundcell").find("button").ejButton({ text: "Aufheben" });
|
|
}
|
|
|
|
</script>
|
|
</asp:Content>
|