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
| TDate DateDebut;
TDate DateFin;
//AnsiString dateDebut ;
//AnsiString dateFin ;
TForm1 *Form1;
//---------------------------------------------------------------------------
__fastcall TForm1::TForm1(TComponent* Owner)
: TForm(Owner)
{
}
//---------------------------------------------------------------------------
void __fastcall TForm1::AnnulerButtonClick(TObject *Sender)
{
Close();
}
//---------------------------------------------------------------------------
void __fastcall TForm1::OKButtonClick(TObject *Sender)
{
//ouverture et connexion, bdd et table
Session1->Open();
Database1->Open();
Table1->Open();
//si les champs sont vides ou contiennent des espaces
if(Trim(LoginZone->Text) == "" || Trim(PasswordZone->Text) =="")
{
ShowMessage("Veuillez saisir un nom d'utilisateur et un mot de passe svp");
LoginZone->Text="";
PasswordZone->Text="";
}
else {
// requête SQL
Query1->SQL->Clear();
AnsiString requete = "select count(Login) as nbReponse from T_User where Login= '"+LoginZone->Text+"' and Password= '"+PasswordZone->Text+"'";
Query1->SQL->Add(requete);
Query1->Open();
int nbrep = Query1->FieldByName("nbReponse")->AsInteger;
if (nbrep>0){ //bon Login, bon Password
ShowMessage("Bienvenue");
DateDebut=FormatDateTime("DD/MM/YYYY HH:MM:SS",Now());
ShellExecute(NULL,"open","winmine.exe","","",SW_SHOWDEFAULT);
//std::system( "winmine.exe" );
}
else{ ShowMessage("Nom d'utilisateur ou mot de passe invalide");}
Query1->Close();
}
// fermeture et déconnexion
//Session1->Close();
//Database1->Close();
//Table1->Close();
}
//---------------------------------------------------------------------------
void __fastcall TForm1::QuitterButtonClick(TObject *Sender)
{
DateFin=FormatDateTime("DD/MM/YYYY HH:MM:SS",Now());
ShowMessage("durée = " + (DateFin - DateDebut)) ;
Query2->SQL->Clear();
AnsiString requete2 = "INSERT INTO T_User (TpsConnexion) VALUES ('"+(AnsiString)(DateFin - DateDebut)+"')" ;
Query2->SQL->Add(requete2);
requete2 = "WHERE Login='"+LoginZone->Text+"'";
Query2->SQL->Add(requete2);
Query2->ExecSQL();
} |
Partager