<html>

<head>
<meta http-equiv="Content-Language" content="pt-br">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>CLIENTE BOM DE SORTE</title>
<style>
<!--

.O
	{color:black;}
-->
</style>
</head>
<%
wMes=request.item("Mes")
wAno=request.item("Ano")
wAchou="N"

if (wMes <> "") then
  Set Database = Server.CreateObject("ADODB.Connection")
  Database.Open session("stringconexaobomdesorte")

  SQL = "SELECT * FROM TICKETS_SORTEADOS WHERE MES = '" & wMES & "' and ANO = " & wANO & " ORDER BY DATA"

  Set oRs= DataBase.Execute(SQL) 
  if oRs.EOF then
    wAchou="N"
  else  
    wAchou="S"  
 
if (wSorteio  <> "") then
wSorteio = oRs("N_TICKET")
oRs.MoveNext  

  While NOT oRs.EoF
    wSorteio = wSorteio & "   -    " & oRs("N_TICKET")
  oRs.MoveNext  
  Wend
  end if
     end if
       end if 
  
%>


<body topmargin="0" leftmargin="0" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF" style="text-align: left">

<table border="0" cellpadding="0" cellspacing="0" id="table1" height="214" width="646">
	<tr>
		<td valign="top" width="646" height="214">
		<table border="0" cellpadding="0" cellspacing="0" id="table2" width="645">
			<tr>
				<td align="center" colspan="4">
				<p style="line-height: 150%">&nbsp;</td>
			</tr>
			<tr>
				<td align="center" colspan="4">
				<p style="margin-top: 0; margin-bottom: 0" align="left">
				<span style="font-family: Arial; color: #333399; font-weight: 700">
				Confira os números compostos através do resultado da Loteria 
				Federal do dia:</span></p>
				</td>
			</tr>
			<tr>
				<td align="center" colspan="4">
				&nbsp;</td>
			
			</tr>
			<form method="POST" action="Cliente_Bom_de_Sorte_Sorteio.asp">
			<tr>
				<td align="left" width="157">
				<p align="right"><b><font face="Arial" size="2">Mês</font></b></td>
				<td align="left" width="10">
				<b><font face="Arial" size="2">:</font></b></td>
				<td align="left" width="263">
				<font face="Arial">
				<select size="1" name="MES">
				<option selected>Selecione . . .</option>
				<option value="JANEIRO">JANEIRO</option>
				<option value="FEVEREIRO">FEVEREIRO</option>
				<option value="MARÇO">MARÇO</option>
				<option value="ABRIL">ABRIL</option>
				<option value="MAIO">MAIO</option>
				<option value="JUNHO">JUNHO</option>
				<option value="JULHO">JULHO</option>
				<option value="AGOSTO">AGOSTO</option>
				<option value="SETEMBRO">SETEMBRO</option>
				<option value="OUTUBRO">OUTUBRO</option>
				<option value="NOVEMBRO">NOVEMBRO</option>
				<option value="DEZEMBRO">DEZEMBRO</option>
				</select></font><b><font size="2" face="Arial">&nbsp; Ano:
				</font></b><font face="Arial">
				<select size="1" name="ANO">
				<option value="2008">2008</option>
				<option selected value="2009">2009</option>
				<option value="2010">2010</option>
				</select></font></td>
				<td align="left" width="215">
				<input type="submit" value="Continuar" name="B1"></td>
			</tr>
			<% if wAchou = "N" then %>
			<tr>
				<td align="left" width="645" colspan="4">
				&nbsp;</td>
			</tr>
			<tr>
				<td align="left" width="645" colspan="4">
				<div align="center">
					<font face="Arial">
					<% else %>
					</font>
					<table border="0" width="400" id="table3">
						<tr>
							<td colspan="3">&nbsp;</td>
						</tr>
						<tr>
							<td colspan="3">
							<p align="center"><font face="Arial" size="2">Tickets Sorteados no mês de <b><%=oRs("MES")%> 
							</b>de<b> <%=oRs("ANO")%></b></font></td>
						</tr>
						<tr>
							<td colspan="3">&nbsp;</td>
						<% While NOT oRs.EoF %></tr>
						<tr>
							<td width="171">
							<p align="right"><font face="Arial" size="2">Dia :</font></td>
							<td width="60"><font face="Arial" size="2"><b><%=oRs("DIA")%></b> - </font></td>
							<td width="155"><font face="Arial" color="#FF0000"><b><%=oRs("N_TICKET")%></b></font></td>
						</tr>
						<% oRs.MoveNext %> 
                        <% Wend %>  
					</table>
				</div>
				</td>
			</tr>
			</form>
			<tr>
				<td align="center" colspan="4" height="73" valign="bottom"><p><b>
				<a href="cliente_bom_de_Sorte.asp">
				<font color="#000080" face="Arial" size="2">Voltar</font></a></b></td>
			</tr>
			<tr>
				<td colspan="4"></td>
			</tr>
		</table></td>
	</tr>
</table>
 <% end if %>
</body>

</html>