createsalarytable.pas

工资管理系统

unit CreateSalaryTable;

interface

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

type
  TSetTaxRateTableForm = class(TForm)
    Table1: TTable;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    procedure FormActivate(Sender: TObject);
    procedure Table1AfterScroll(DataSet: TDataSet);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    procedure ReadFromTable;
  end;

var
  SetTaxRateTableForm: TSetTaxRateTableForm;

implementation

{$R *.dfm}

procedure TSetTaxRateTableForm.FormActivate(Sender: TObject);
begin
    Table1.DatabaseName:='gzgl';
    Table1.TableName:='tax';
    Table1.Active:=true;
    ReadFromTable;
end;

procedure TSetTaxRateTableForm.Table1AfterScroll(DataSet: TDataSet);
begin
    ReadFromTable;
end;

procedure TSetTaxRateTableForm.BitBtn1Click(Sender: TObject);
begin
    Table1.Append;
    Edit1.Text:='';
    Edit2.Text:='';
    Edit3.Text:='';
    Edit1.SetFocus;
end;

procedure TSetTaxRateTableForm.BitBtn4Click(Sender: TObject);
begin
    Table1.Active:=false;
    close;
end;

procedure TSetTaxRateTableForm.BitBtn3Click(Sender: TObject);
begin
      Table1.Edit;
      Table1.FieldByName('division').AsInteger:=StrToInt(Edit1.Text);
      Table1.FieldByName('rate').AsFloat:=StrToFloat(Edit2.Text);
      Table1.FieldByName('note').AsString:=Edit3.Text;
      Table1.Post;
end;

procedure TSetTaxRateTableForm.BitBtn2Click(Sender: TObject);
begin
    Table1.Delete;
    Table1.First;
    ReadFromTable;
end;
procedure TSetTaxRateTableForm.ReadFromTable;
begin
    Edit1.Text:=IntToStr(Table1.FieldByname('division').asinteger);
    Edit2.Text:=FloatToStr(Table1.FieldByname('rate').asFloat);
    Edit3.Text:=Table1.FieldByname('note').asString;
end;
end.