ufmwxjl.~pas

物业管理系统

unit Ufmwxjl;

interface

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

type
  Tfmwxjl = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    DBGrid1: TDBGrid;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    GroupBox2: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label8: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit4: TEdit;
    Edit7: TEdit;
    DateTimePicker1: TDateTimePicker;
    DataSource1: TDataSource;
    Table1: TTable;
    Table1Wyno: TStringField;
    Table1Xingm: TStringField;
    Table1Shenfzh: TStringField;
    Table1Dianh: TStringField;
    Table1Fangx: TStringField;
    Table1Zhuzh: TStringField;
    Table1Qianrshj: TDateField;
    Table1Juzfsh: TStringField;
    Table1Beizh: TStringField;
    Table2: TTable;
    Table2Wyno: TStringField;
    Table2Xingm: TStringField;
    Table2Dianh: TStringField;
    Table2Zhuzh: TStringField;
    Table2Ddate: TDateField;
    Table2Wxxm: TStringField;
    Table2Beizh: TStringField;
    Label4: TLabel;
    Edit3: TEdit;
    Label7: TLabel;
    Edit5: TEdit;
    Button1: TButton;
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  fmwxjl: Tfmwxjl;

implementation

uses wuyeform;

{$R *.dfm}

procedure Tfmwxjl.Button1Click(Sender: TObject);
begin
if table1.Locate('wyno',trim(edit1.Text),[])  then
begin
edit2.Text:=table1.FieldValues['xingm'];
edit4.Text:=table1.FieldValues['dianh'];
edit3.Text:=table1.FieldValues['zhuzh'];
end
else
begin
showmessage('你输入的物业编号不存在，请核查!!');
fmwxjl.OnCreate(sender);
edit1.SelectAll;
edit1.SetFocus;
end;

end;

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


end;

procedure Tfmwxjl.BitBtn2Click(Sender: TObject);
begin
table2.Active:=true;
table2.Append;
table2.FieldByName('wyno').Value:=edit1.Text;
table2.FieldByName('xingm').Value:=edit2.Text;;
table2.FieldByName('dianh').Value:=edit4.Text;
table2.FieldByName('zhuzh').Value:=edit3.Text;
table2.FieldByName('ddate').Value:=datetimepicker1.Date;
table2.FieldByName('wxxm').Value:=edit7.Text;
table2.FieldByName('beizh').Value:=edit5.Text;
table2.Post;
end;

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

end;

procedure Tfmwxjl.BitBtn3Click(Sender: TObject);
begin
table2.Active:=true;
table2.Edit;
table2.Post;
fmwxjl.Close;
end;

procedure Tfmwxjl.FormActivate(Sender: TObject);
begin
datetimepicker1.Date:=date();
edit1.SetFocus;
end;

end.