ufmxiaoqu.pas

物业管理系统

unit Ufmxiaoqu;

interface

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

type
  Tfmxiaoqu = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    Table1: TTable;
    Table1Wyno: TStringField;
    Table1Zhuzh: TStringField;
    Table1Fangx: TStringField;
    Table1Jianzmj: TFloatField;
    Table1Sshiymj: TFloatField;
    Table1Beizh: TStringField;
    GroupBox2: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit7: TEdit;
    Edit5: TEdit;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  fmxiaoqu: Tfmxiaoqu;

implementation

uses wuyeform;

{$R *.dfm}

procedure Tfmxiaoqu.BitBtn1Click(Sender: TObject);
begin
table1.Active:=true;
table1.Edit;
if not table1.Eof then
table1.Delete else showmessage('没有可删除的记录!');
table1.post;
end;

procedure Tfmxiaoqu.BitBtn3Click(Sender: TObject);
begin
table1.Active:=true;
table1.Edit;
table1.Post;
fmxiaoqu.Close;
end;

procedure Tfmxiaoqu.BitBtn2Click(Sender: TObject);
begin
if (edit1.Text<>'') and (edit2.Text<>'') and (edit3.Text<>'') and (edit4.Text<>'') and (edit5.Text<>'') then
begin
if not table1.Locate('wyno',edit1.Text,[]) then begin
table1.Active:=true;
table1.Append;
table1.FieldByName('wyno').Value:=edit1.Text;
table1.FieldByName('zhuzh').Value:=edit2.Text;
table1.FieldByName('fangx').Value:=edit3.Text;
if trim(edit4.text)='' then table1.FieldByName('jianzmj').Value:=0 else
table1.FieldByName('jianzmj').Value:=strtofloat(edit4.Text);
if trim(edit5.text)='' then table1.FieldByName('sshiymj').Value:=0 else
table1.FieldByName('sshiymj').Value:=strtofloat(edit5.Text);
table1.FieldByName('beizh').Value:=edit7.Text;
table1.Post;
showmessage('添加记录成功!');
fmxiaoqu.OnCreate(sender);
end
else
begin
showmessage('你输入的物业编号已经存在！请核查！！');
edit1.SelectAll;
edit1.SetFocus;
end;
end



else
showmessage('你输入的有些内容不能为空！请核查！！');
end;

procedure Tfmxiaoqu.FormCreate(Sender: TObject);
begin
application.OnMessage:=wuye.doenterastab;
edit1.Text:='';
edit2.Text:='';
edit3.Text:='';
edit4.Text:='';
edit5.Text:='';
edit7.Text:='';
end;

procedure Tfmxiaoqu.FormActivate(Sender: TObject);
begin
edit1.SetFocus;
end;

end.