ie.pas

完整的delphi书籍源代码,大家有空的时候自己慢慢看看

unit IE;

interface

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

type
  TIEFrm = class(TForm)
    GroupBox1: TGroupBox;
    DateTimePicker1: TDateTimePicker;
    ComboBox1: TComboBox;
    Edit1: TEdit;
    Memo1: TMemo;
    Button1: TButton;
    Button2: TButton;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    ADOQuery1: TADOQuery;
    Edit2: TEdit;
    ADOTable1: TADOTable;
    procedure ComboBox1Change(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  IEFrm: TIEFrm;

implementation

{$R *.dfm}

procedure TIEFrm.ComboBox1Change(Sender: TObject);
begin
    with ADOQuery1 do
     begin
       close;
       sql.clear;
       sql.add('select * from IEType where IEName='+''''+ComboBox1.text+'''');
       open;
       first;
       Edit1.text:=fieldbyname('IEType').asstring;
     end;
end;

procedure TIEFrm.FormCreate(Sender: TObject);
begin
   DateTimePicker1.date:=date;
   ADOtable1.first;
   while not ADOtable1.eof do
      begin
       combobox1.items.insert(-1,ADOtable1.fieldbyname('IEName').asstring);
       ADOtable1.Next;
      end;
end;

procedure TIEFrm.Button2Click(Sender: TObject);
begin
  IEFrm.hide;
end;

procedure TIEFrm.Button1Click(Sender: TObject);
begin

   if combobox1.text='' then
     showmessage('请选择收支项目！')
   else
    if edit2.text='' then
        showmessage('请填写收支金额！')
   else
    begin
    with ADOQuery1 do
     begin
       close;
       sql.clear;
       sql.add('insert into IE (IEDate,IEName,');
       sql.add('IEType,Payment,Remark)values (' );
       sql.add(''''+datetostr(DateTimePicker1.DATE)+''''+',');
       sql.add(''''+combobox1.text+''''+','+''''+edit1.text+''''+',');
       sql.add(''''+edit2.text+''''+','+''''+memo1.text+''''+')');
       execsql;
    end;
   showmessage('请收支录入成功！')
  end;
end;

end.