freportform.~pas

简单的小区物业管理系统,户籍管理,出入管理,系统管理,收费管理,

unit freportform;

interface

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

type
  Tfreport = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Memo1: TMemo;
    Label7: TLabel;
    btadd: TButton;
    ComboBox1: TComboBox;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure btaddClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  freport: Tfreport;

implementation

uses mainform, DataM;

{$R *.dfm}

procedure Tfreport.FormClose(Sender: TObject; var Action: TCloseAction);
begin
frmmain.show;
end;

procedure Tfreport.btaddClick(Sender: TObject);
begin
Data.ADOtHJGL.Close;
Data.ADOtHJGL.SQL.Clear;
Data.ADOtHJGL.SQL.Add('select * from HomeMaster where HomeMasterSIDCardNo="'+Edit1.Text+'"');
Data.ADOtHJGL.Open;
if  ((Length(Edit1.Text)=15) or (Length(Edit1.Text)=18)) and (Data.ADOtHJGL.RecordCount=1) then
  if (Edit1.Text<>'') and (Edit3.Text<>'') and (Edit5.Text<>'') and (Edit6.Text<>'') then
  begin
  Data.ADOFix.Append;
  Data.ADOFix['HomeMasterSIDCardNo']:=Edit1.Text;
  Data.ADOFix['HomeMasterName']:=Edit2.Text;
  Data.ADOFix['FixterName']:=Edit3.Text;
  Data.ADOFix['FixKind']:=ComboBox1.Text;
  Data.ADOFix['FixBeginDate']:=Edit5.Text;
  Data.ADOFix['FixEndDate']:=Edit6.Text;
  Data.ADOFix['Memo']:=Memo1.Lines.Text;
  Data.ADOFix.Post;
  Edit1.Text:='';
  Edit2.Text:='';
  Edit3.Text:='';
  Edit5.Text:='';
  Edit6.Text:='';
  Memo1.Text:='';
  end
  else MessageDlg('错误! 输入值不能为空!',mtError,[mbOK],0)
else MessageDlg('身份证号输入错误',mtError,[mbOK],0);
Data.ADOtHJGL.Close;
Data.ADOtHJGL.SQL.Clear;
Data.ADOtHJGL.SQL.Add('select * from HomeMaster');
Data.ADOtHJGL.Open;

end;

procedure Tfreport.FormCreate(Sender: TObject);
begin
Data.ADOFix.Close;
  Data.ADOFix.SQL.Clear;
  Data.ADOFix.SQL.Add('select * from Fix');
  Data.DataSFix.DataSet:=Data.ADOFix;
  Data.ADOFix.Open;

end;

end.