unit Unit108s;

interface

uses
    Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
    Dialogs, DB, ADODB, OleCtnrs, LbSpeedButton, DBCtrlsEh, StdCtrls, Mask,
    DBCtrls;

type
    TForm108s = class(TForm)
        LbSpeedButton1: TLbSpeedButton;
        LbSpeedButton2: TLbSpeedButton;
        OleContainer1: TOleContainer;
        ADOQuery1: TADOQuery;
        DataSource1: TDataSource;
        DBEdit1: TDBEdit;
        DBEdit2: TDBEdit;
        DBEdit3: TDBEdit;
        DBEdit4: TDBEdit;
        DBEditEh1: TDBEditEh;
        DBEdit5: TDBEdit;
        DBEditEh2: TDBEditEh;
        DBEditEh3: TDBEditEh;
        LbSpeedButton3: TLbSpeedButton;
        procedure FormClose(Sender: TObject; var Action: TCloseAction);
        procedure FormShow(Sender: TObject);
        procedure LbSpeedButton1Click(Sender: TObject);
        procedure LbSpeedButton2Click(Sender: TObject);
        procedure LbSpeedButton3Click(Sender: TObject);
    private
    { Private declarations }
    public
    { Public declarations }
    end;

var
    Form108s: TForm108s;

implementation
uses DM, mainUnit;
{$R *.dfm}

procedure TForm108s.FormClose(Sender: TObject; var Action: TCloseAction);
begin
    action := caFree;
    form108s := nil;
end;

procedure TForm108s.FormShow(Sender: TObject);
begin
    caption := SID + '===>第八條 交付期限';
    adoquery1.SQL.Text := sSQL;
   //ShowMessage(Ssql);
    ADOQuery1.Open;
    ADOQuery1.Edit;
end;

procedure TForm108s.LbSpeedButton1Click(Sender: TObject);
begin
    adoquery1.Cancel;
    Close;
end;

procedure TForm108s.LbSpeedButton2Click(Sender: TObject);

begin
 
    Application.ProcessMessages;
    dm.DataModule2.ADOConnection1.BeginTrans;
    try
        ADOQuery1.Post;
        DM.DataModule2.ADOConnection1.CommitTrans;
    except
        DM.DataModule2.ADOConnection1.RollbackTrans;
    end;
    Close;

end;

procedure TForm108s.LbSpeedButton3Click(Sender: TObject);
var
    I: Integer;
begin
    for i := 0 to FORM108S.ControlCount - 1 do begin
        if Form108s.Controls[i] is TDBEditEH then
            TDBEDITEH(FORM108S.Controls[I]).Text := '';

        if FORM108S.Controls[i] is TDBEDIT then
            TDBEDIT(FORM108S.Controls[I]).Text := '';
    end;
 { DBEdit1.Text :='2006';
  DBEdit2.Text :='3';
  DBEdit3.Text :='31';
  DBEdit4.Text :='1';
  DBEdit5.Text :='30';
  DBEditEh2.Text :='見補(bǔ)充協(xié)議';}
end;

end.