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
|
Screen.Cursor := crHourGlass;
qDep := TZQuery.Create(nil);
try
with qDep do begin
Connection := DM.FANNY;
SQL.Clear;
myIdDep := DM.GetGenerator('GEN_DEPENSE_ID');
SQL.Add('INSERT INTO DEPENSE ' +
' (ID_DEPENSE, NO_DEPENSE, DATE_DEPENSE, '+
' TYPE_DEPENSE, ID_BEN, OBJET, REMBOURS, ' +
' ID_USER, DATEC, DATEM ) ' +
'VALUES(:ID_DEPENSE, :NO_DEPENSE, :DATE_DEPENSE, '+
' :TYPE_DEPENSE, :ID_BEN, :OBJET, :REMBOURS, ' +
' :ID_USER, :DATEC, :DATEM ) ' );
ParamByName('TYPE_DEPENSE').AsInteger := SALAIRE;
ParamByName('REMBOURS').AsInteger := PAIEMENT;
ParamByName('NO_DEPENSE').AsString := IntToStr(myIdDep);
ParamByName('DATEC').AsDateTime := Date;
ParamByName('ID_DEPENSE').AsInteger := myIdDep;
ParamByName('DATE_DEPENSE').AsDateTime:= StrToDate(edDFact.Text);
ParamByName('ID_BEN').AsInteger := StrToInt(edBen.Text);
ParamByName('OBJET').AsString := Trim(edObjet.Text);
ParamByName('ID_USER').AsString := myUserId;
ParamByName('DATEM').AsDateTime := Date;
ExecSQL;
DM.CommitData;
Application.ProcessMessages;
end;
finally
FreeAndNil(qDep);
Application.ProcessMessages;
qDepense.Close;
qDepense.ParamByName('TYPE_DEPENSE').AsInteger := SALAIRE;
qDepense.Open;
qDepense.Refresh;
Application.ProcessMessages;
qDepense.Locate('ID_DEPENSE', myIdDep, []);
DisplayRec;
Screen.Cursor := crDefault;
Application.ProcessMessages;
end; |
Partager