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
| Dim debut,fin,englishDateDebut,englishDateFin
debut=CDate(data1)
fin=CDate(data2)
englishDateDebut=Month(debut)&"/"&Day(debut)&"/"&Year(debut)
englishDateFin=Month(fin)&"/"&Day(fin)&"/"&Year(fin)
%>
<div class="content">
<H3>Tubes Equivalents <% response.Write(data4)%></H3>
<TABLE ALIGN="left" BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="45%">
<TR>
<td><b>Ligne de Fabrication</b><div align=center><%response.write(data3)%></td>
<td><b>Date de début</b><div align=center><%response.write(data1)%></td>
<td><b>Date de fin</b> <div align=center><%response.write(data2)%></td>
</tr>
</Table>
<br><br></br></br>
<TABLE ALIGN="left" BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="75%">
<TR>
<td><b>Commande</b><div align=center></td>
<td><b>Diamètre</b><div align=center></td>
<td><b>Epaisseur</b> <div align=center></td>
<td><b>Filetage</b><div align=center></td>
<td><b>Grade</b> <div align=center></td>
<td><b>Client</b><div align=center></td>
<td><b>Tubes bons</b> <div align=center></td>
<td><b>Coef base2002</b> <div align=center></td>
<td><b>Tueq base2002</b> <div align=center></td>
</tr>
<%
Dim NomFil1,NomFil2,NomFil3,NomFil4
NomFil1="HT4822"
NomFil2="HT4821"
NomFil3="ST4420"
NomFil4="ST4421"
Dim RecupNumCommande
RecupNumCommande="Select Distinct Commande.NumCommande,Commande.diametre,Commande.epaisseur,Commande.TypeDeFiletage,Commande.grade,Commande.NomClient,Poste,OperationCasing.DateSaisie,TempsPresence,BoutsBons From OperationCasing,Commande Where (Commande.NumCommande=OperationCasing.NumCommande) AND (OperationCasing.NomPoste='"&NomFil1&"' OR OperationCasing.NomPoste='"&NomFil2&"' OR OperationCasing.NomPoste='"&NomFil3&"'OR OperationCasing.NomPoste='"&NomFil4&"') AND (OperationCasing.DateSaisie Between '"&englishDateDebut&"' and '"&englishDateFin&"')" |
Partager