ufmqianrjl.pas

物业管理系统

unit Ufmqianrjl;

interface

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

type
  TFmqianrjl = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    DBGrid1: TDBGrid;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    DataSource1: TDataSource;
    Table1: TTable;
    GroupBox2: TGroupBox;
    Label2: TLabel;
    Edit1: TEdit;
    Label3: TLabel;
    Edit2: TEdit;
    Label4: TLabel;
    Edit3: TEdit;
    Label5: TLabel;
    Edit4: TEdit;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Edit7: TEdit;
    ComboBox1: TComboBox;
    DateTimePicker1: TDateTimePicker;
    Table2: TTable;
    Table1Wyno: TStringField;
    Table1Xingm: TStringField;
    Table1Shenfzh: TStringField;
    Table1Dianh: TStringField;
    Table1Fangx: TStringField;
    Table1Zhuzh: TStringField;
    Table1Qianrshj: TDateField;
    Table1Juzfsh: TStringField;
    Table1Beizh: TStringField;
    Table3: TTable;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Edit1Exit(Sender: TObject);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Fmqianrjl: TFmqianrjl;

implementation

uses wuyeform;

{$R *.dfm}

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

end;

procedure TFmqianrjl.BitBtn2Click(Sender: TObject);
begin
if table2.Locate('wyno',edit1.Text,[]) and not table1.Locate('wyno',edit1.Text,[]) then begin
table1.Active:=true;
table1.Append;
table1.FieldByName('wyno').Value:=edit1.Text;
table1.FieldByName('xingm').Value:=edit2.Text;
table1.FieldByName('shenfzh').Value:=edit3.Text;
table1.FieldByName('dianh').Value:=edit4.Text;
table1.FieldByName('fangx').Value:=table2.FieldValues['fangx'];
table1.FieldByName('zhuzh').Value:=table2.FieldValues['zhuzh'];
table1.FieldByName('qianrshj').Value:=datetimepicker1.Date;
table1.FieldByName('juzfsh').Value:=combobox1.Text;
table1.FieldByName('beizh').Value:=edit7.Text;
table1.Post;

table3.Active:=true;
table3.Append;
table3.FieldByName('wyno').Value:=edit1.Text;
table3.FieldByName('xingm').Value:=edit2.Text;
table3.FieldByName('dianh').Value:=edit4.Text;
table3.FieldByName('fangx').Value:=table2.FieldValues['fangx'];
table3.FieldByName('zhuzh').Value:=table2.FieldValues['zhuzh'];
table3.FieldByName('jianzmj').Value:=table2.FieldValues['jianzmj'];
table3.FieldByName('jiezh').Value:=datetimepicker1.Date;
table3.Post;


fmqianrjl.OnCreate(sender);
end
else
begin
showmessage('你输入的物业编号已经存在或错误！请核查！！');
edit1.SelectAll;
edit1.SetFocus;
end;
end;

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

procedure TFmqianrjl.FormCreate(Sender: TObject);
begin
application.OnMessage:=wuye.doenterastab;
edit1.Text:='';
edit2.Text:='';
edit3.Text:='';
edit4.Text:='';
edit7.Text:='';
datetimepicker1.Date:=date();
end;

procedure TFmqianrjl.Edit1Exit(Sender: TObject);
begin
//edit2.Text:=table1.FieldValues['xingm'];
end;

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

end.