1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
|
<%
SELECT CASE Request.Querystring("modeAff")
CASE "","LaListe"
'-------------------------------------------------------------------------------------------------------------------
varMois=Month(Now)
strRequete="SELECT * FROM Tbl_Congres ORDER BY Id_num"
Set RsCongres=Server.CreateObject("ADODB.Recordset")
RsCongres.Open strRequete,ConnexAdmin
If Not RsCongres.Eof Then
%>
Cochez ou décochez les titres selon que vous souhaitez ou non les inclure dans la sélection.<br>Pour voir la fiche descriptive d'un congrès, cliquez sur son intitule
</font>
<table width="100%" border="0" bordercolorlight="#FFFFCC" cellspacing="3" cellpadding="0" style="border-collapse: collapse">
<tr>
<td width="2%" bgcolor="#FFFFCC"><b><font color="#FF0000"> </font></b></td>
<td width="58%" bgcolor="#FFFFCC"><b><font color="#FF0000">intitule</font></b></td>
<td width="10%" bgcolor="#FFFFCC"><b><font color="#FF0000">Ville</font></b></td>
<td width="10%" bgcolor="#FFFFCC"><b><font color="#FF0000">Du</font></b></td>
<td width="10%" bgcolor="#FFFFCC"><b><font color="#FF0000">Au</font></b></td>
</tr>
<form name="SELECTION" method="get" action="Votre_Selection.asp">
<%
indx=0
While Not RsCongres.Eof
indx=indx+1
strRequete="SELECT * FROM Tbl_SelectionMonCompte WHERE numero_Congres=" & RsCongres("Id_num") ',' id_Code='" & Session("user") & "'"
Set RsSelection=Server.CreateObject("ADODB.Recordset")
RsSelection.Open strRequete,ConnexAdmin
If Not RsSelection.Eof Then
Numero_Inscription=RsCongres("Id_num")
Else
Numero_Inscription=0
End If
Set RsSelection=Nothing
varChaine=Rtrim(RsCongres("debut_congres"))
' varMonth=cInt(Mid(varChaine,4,2))
' varYear=cInt(Mid(varChaine,7,4))
varMonth=Mid(varChaine,4,2)
varYear=Mid(varChaine,7,4)
If varMonth>=varMois And varYear>=Year(Now) Then
%>
<tr>
<td width="2%" bgcolor="#FFFFFF">
<%If Numero_Inscription=RsCongres("Id_num") Then%>
<input type="checkbox" name="cb_Congres" value="<%=RsCongres("Id_num")%>" checked style="color: #0000FF;border-style: solid; border-width: 1; background-color: #FFFFFF"></td>
<%Else%>
<input type="checkbox" name="cb_Congres" value="<%=RsCongres("Id_num")%>" style="color: #0000FF;border-style: solid; border-width: 1; background-color: #FFFFFF"></td>
<%End If%>
<%
If indx mod 2 Then
%>
<td width="58%" bgcolor="#FFFFFF"><a href="selection_congres.asp?Individuel=Oui&specialite=<%=Request.Querystring("specialite")%>&pays=<%=Request.Querystring("pays")%>&Ville=<%=Request.Querystring("Ville")%>&Mois=<%=Request.Querystring("Mois")%>&numCongres=<%=RsCongres("id_num")%>&modeAff=LaFiche"><font color="black"><%=RsCongres("intitule")%></font></a><font color="black"> </td>
<td width="10%" bgcolor="#FFFFFF"><font color="black"><%=RsCongres("Ville")%></font> </td>
<td width="10%" bgcolor="#FFFFFF"><font color="black"><%=RsCongres("debut_congres")%></font> </td>
<td width="10%" bgcolor="#FFFFFF"><font color="black"><%=RsCongres("fin_congres")%></font> </td>
<%
else
%>
<td width="58%"><a href="selection_congres.asp?Individuel=Oui&specialite=<%=Request.Querystring("specialite")%>&pays=<%=Request.Querystring("pays")%>&Ville=<%=Request.Querystring("Ville")%>&Mois=<%=Request.Querystring("Mois")%>&numCongres=<%=RsCongres("id_num")%>&modeAff=LaFiche"><font color="black"><%=RsCongres("intitule")%></font></a><font color="black"> </td>
<td width="10%"><font color="black"><%=RsCongres("Ville")%></font> </td>
<td width="10%"><font color="black"><%=RsCongres("debut_congres")%></font> </td>
<td width="10%"><font color="black"><%=RsCongres("fin_congres")%></font> </td>
<%
End If
%>
</tr>
<%
End If
indice=indice+1
RsCongres.MoveNext
Wend
%>
<tr>
<td colspan="5" width="100%"> </td>
</tr>
<tr>
<td colspan="5" width="100%" align="center">
<input type="submit" name="Action" value="Valider la sélection"> <input type="submit" name="Action" value="Retour à la liste"></td>
</tr>
</form> |
Partager