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
| procedure TForm37.FormKeyDown(Sender: TObject; var Key: Word;
Shift: TShiftState);
var croute : Integer;
begin
if (Key = VK_F5) then
begin
if (Edit1.Text = '') or (Edit2.Text = '') then
begin
MessageDlg('Il faut saisir un numéro matricule et un numero d''ordre de mission!', mtWarning, [mbOK],0);
Edit2.SetFocus;
end
Else
begin
//Recherche rpix casse croute
Query_Prix.Sql.Clear;
Query_Prix.sql.Add('Select ca_croute as croute from categorie');
Query_Prix.Open;
Croute := Query_Prix.fieldbyname('Croute').AsInteger;
Casse.FieldByName('cc_num').value := Edit1.Text;
Casse.FieldByName('a_matricule').value := Edit1.Text;
Casse.FieldByName('cc_date').value := DateToStr(date);
Casse.FieldByName('cc_prix').value := Croute;
Casse.FieldByName('cc_cpte').value := 638300;
Casse.FieldByName('cc_dest').value := Edit6.Text;
//Archivage
Query_Arch.sql.Clear;
Query_Arch.sql.Add('Insert into compte(co_code, co_cpte, co_cout, co_mnt, co_mat)');
Query_Arch.sql.Add('Select cc_num, cc_cpte, cc_dest, cc_prix, a_matricule from casse');
Query_Arch.sql.Add('where cc_num = ' + QuotedStr(Edit1.text));
Query_Arch.sql.Add('And a_matricule =' + QuotedStr(Edit2.text));
Query_Arch.sql.Add('Group by cc_num, cc_cpte, cc_dest, cc_prix, a_matricule');
Query_Arch.ExecSQL;
//Rafraichissement
Query_Casse.Sql.Clear;
Query_Casse.sql.Add('Select agent.a_matricule, agent.a_nom, agent.a_prenom, agent.a_fonction, agent.a_cout from agent, casse');
Query_Casse.sql.Add('Where casse.cc_num = ' + QuotedStr(Edit1.text));
Query_Casse.sql.Add('And agent.a_matricule = Casse.a_matricule');
Query_Casse.Open;
Edit2.Text := '';
Edit3.Text := '';
Edit4.Text := '';
Edit5.Text := '';
Edit6.Text := '';
Edit1.SetFocus;
end;
end;
end; |
Partager