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 67 68 69 70 71 72 73 74 75 76 77 78 79 80
|
procedure Tfiche_BP.SpeedButton8Click(Sender: TObject);
begin
if (trim(Edit1.text)<>'')and( trim(Edit2.text)<>'')and (trim(Edit3.Text)<>'')and (trim(Edit8.Text)<>'')
and (trim(Edit9.Text)<>'')and (trim(Edit10.Text)<>'') then
begin
if (StrToCurr(edit3.Text)+StrTocurr(edit9.Text)> StrToCurr(edit2.text)) then
Begin
MessageDlg('ÎØà Ýí ãÌãæÚ äÝÞÇÊ ÞÓã ÇáÊÓííÑ æ ÇáÊÌåíÒ æ ÇáãÌãæÚ ÇáÅÌãÇáí ÊÃßÏ ãä ÇáãÚØíÇÊ',mtError,[mbCancel],0) ;
end
else
begin
test.Close;
test.Parameters[0].Value:=DateToStr(DateTimePicker1.Date);
test.Parameters[1].Value:=StrToCurr(edit1.Text);
test.Parameters[2].Value:=StrToCurr(edit2.Text);
test.Open();
////////////////////
test2.Close;
test2.Parameters[0].Value:=edit11.Text;
test2.Parameters[1].Value:=DateToStr(DateTimePicker1.Date);
test2.Parameters[2].Value:=StrToCurr(edit3.Text);
test2.Parameters[3].Value:=StrToCurr(edit8.Text);
test2.Open();
//////////////////////////
test3.Close;
test3.Parameters[0].Value:=edit12.Text;
test3.Parameters[1].Value:=DateToStr(DateTimePicker1.Date);
test3.Parameters[2].Value:=StrToCurr(edit9.Text);
test3.Parameters[3].Value:=StrToCurr(edit10.Text);
test3.Open();
if(not test.IsEmpty)and (not test2.IsEmpty)and(not test3.IsEmpty) then
begin
MessageDlg('áÞÏ ÞãÊ ÈÅÖÇÝÉ ãíÒÇäíÉ ÓÇÈÞÇ áÇ íãßäß ÅÖÇÝÉ ãíÒÇäíÉ ÃÎÑì áåÐÇ ÇáÚÇã',mtError,[mbCancel],0);
edit1.Clear ; edit2.Clear; edit3.Clear; edit8.Clear; edit9.Clear; edit10.Clear;
end
else
begin
if MessageDlg('åá ÃäÊ ãÊÃßÏ ãä ÅÖÇÝÉ ÇáãÚáæãÇÊ ¿',mtConfirmation,[mbYes,mbNo],0)=mrYes then
begin
ajoutBG.sql.clear;
ajoutBG.sql.add('Insert into BG(Date_debut,Rev_total,Dep_total)values('+DateToStr(DateTimePicker1.Date)+','+(edit1.Text)+','+(edit2.text)+' ) ');
ajoutBG.ExecSQL;
ajoutBG.Close;
///////////
ajout.sql.clear;
ajout.sql.add('Insert into budgetg(code_sec,dateBP,Total_dep,Total_Rev)values('+QuotedSTR(edit11.text)+','+DATETOSTR(DateTimePicker1.Date)+','+(edit3.text)+','+(edit8.text)+' ) ');
ajout.ExecSQL;
ajout.Close;
////////////////
ajoutBudget.sql.clear;
ajoutBudget.sql.add('Insert into budgetg(code_sec,dateBP,Total_dep,Total_Rev)values('+QuotedSTR(edit12.text)+','+DATETOSTR(DateTimePicker1.Date)+','+(edit9.text)+','+(edit10.text)+' ) ');
ajoutBudget.ExecSQL;
ajoutBudget.Close;
showmessage('áÞÏ Êã ÅÖÇÝÉ ÇáãíÒÇäíÉ ÈäÌÇÍ');
edit1.Clear ; edit2.Clear; edit3.Clear; edit8.Clear; edit9.Clear; edit10.Clear;
end;
end;
end;
end
else showmessage(' ãä ÝÖáß Þã ÈÅÏÎÇá ÇáãÚáæãÇÊ ');
end; |
Partager