unit Unit3;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ComCtrls, StdCtrls, ExtCtrls, DB, ADODB, Grids, DBGrids;

type
  TForm3 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Edit3: TEdit;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Edit4: TEdit;
    Edit5: TEdit;
    Button1: TButton;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    Label6: TLabel;
    Label7: TLabel;
    Edit6: TEdit;
    Edit7: TEdit;
    Button2: TButton;
    ComboBox1: TComboBox;
    Label8: TLabel;
    Label9: TLabel;
    Edit8: TEdit;
    Label10: TLabel;
    Edit9: TEdit;
    Button3: TButton;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    DBGrid2: TDBGrid;
    Label11: TLabel;
    Label12: TLabel;
    Edit10: TEdit;
    ComboBox2: TComboBox;
    Button4: TButton;
    TabSheet5: TTabSheet;
    Label13: TLabel;
    Button5: TButton;
    Label14: TLabel;
    Button6: TButton;
    Button7: TButton;
    Button8: TButton;
    Button9: TButton;
    Label15: TLabel;
    ComboBox3: TComboBox;
    ComboBox4: TComboBox;
    ComboBox5: TComboBox;
    Button10: TButton;
    DBGrid3: TDBGrid;
    Label16: TLabel;
    Timer1: TTimer;
    Label18: TLabel;
    ADOQuery2: TADOQuery;
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Timer1Timer(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;
  aa,bb,i:integer;

implementation
{$R *.dfm}

procedure TForm3.Button1Click(Sender: TObject);
begin
if edit4.Text=edit5.Text
then
   begin
  adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('insert into customer values(:id,:name)');
  adoquery1.Parameters[0].Value:=edit2.text;
  adoquery1.Parameters[1].Value:= edit1.text;
  adoquery1.execsql;
  //adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('insert into account values(:number,:pw,:b,:a)');
  adoquery1.Parameters[0].Value:=edit8.Text;
  adoquery1.Parameters[1].Value:=edit4.Text;
  adoquery1.Parameters[2].Value:=strtofloat(edit3.Text);
  adoquery1.Parameters[3].Value:=combobox1.Items[combobox1.ItemIndex];
  adoquery1.execsql;
  adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('insert into depositor values(:num,:na)');
  adoquery1.Parameters[0].Value:=edit8.Text;
  adoquery1.Parameters[1].Value:=edit4.Text;
  adoquery1.execsql;
  showmessage('你開戶成功！'+#13+'開戶銀行是：'+combobox1.Items[combobox1.ItemIndex]+#13+'密碼是：'+edit4.Text+#13
  +'存款是：'+edit3.Text+#13+'帳號是：'+ edit8.Text);
 end
else showmessage('兩次輸入的密碼不一樣！'+#13+'請重新輸入！');
end;

procedure TForm3.Button3Click(Sender: TObject);
begin
  adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('select customer.customer_id as 身份證,customer_name as 姓名,account_number as 卡號 from customer,depositor where customer_name like :p and customer.customer_id=depositor.customer_id');
  adoquery1.Parameters[0].Value:='%'+edit9.Text+'%';
  adoquery1.open;
end;

procedure TForm3.Button4Click(Sender: TObject);
begin
  adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('select account.account_number as 帳號,balance as 存款 from depositor,account where account.account_number=depositor.account_number and branch_name=:bn and customer_id=:id');
  adoquery1.Parameters[0].Value:=combobox2.Items[combobox2.ItemIndex];
  adoquery1.Parameters[1].Value:=edit10.text;
  adoquery1.open;
end;

procedure TForm3.Button9Click(Sender: TObject);
begin
close;
end;

procedure TForm3.Button5Click(Sender: TObject);
begin
Edit1.Text:='';
Edit2.Text:='';
Edit3.Text:='';
Edit4.Text:='';
Edit5.Text:='';
Edit8.Text:='';
combobox1.Text :='';
end;

procedure TForm3.Button6Click(Sender: TObject);
begin
Edit6.Text:='';
Edit7.Text:='';
end;

procedure TForm3.Button7Click(Sender: TObject);
begin
Edit10.Text:='';
combobox2.Text:='';
end;

procedure TForm3.Button8Click(Sender: TObject);
begin
Edit9.Text:='';

end;

procedure TForm3.Timer1Timer(Sender: TObject);
begin
label18.Caption:=formatdatetime('yyyy-mm-dd,hh:mm:ss',now);
end;

end.