fixform.pas

基本的物业管理系统

unit FixForm;

interface

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

type
  TFrmFix = class(TForm)
    Panel1: TPanel;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Memo1: TMemo;
    btAdd: TButton;
    ComboBox1: TComboBox;
    Edit4: TEdit;
    btSearch: TButton;
    DBGrid1: TDBGrid;
    Label8: TLabel;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure btAddClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure btSearchClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FrmFix: TFrmFix;

implementation
Uses DataM,MainFrm;
{$R *.dfm}

procedure TFrmFix.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  FrmMain.Show;
end;

procedure TFrmFix.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('Error! Not Null Allowed!',mtError,[mbOK],0)
else MessageDlg('IDCardNo Error',mtError,[mbOK],0);
Data.ADOtHJGL.Close;
Data.ADOtHJGL.SQL.Clear;
Data.ADOtHJGL.SQL.Add('select * from HomeMaster');
Data.ADOtHJGL.Open;
end;

procedure TFrmFix.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;

procedure TFrmFix.btSearchClick(Sender: TObject);
begin
  if Edit4.Text<>'' then
  begin
  Data.ADOFix.Close;
  Data.ADOFix.SQL.Clear;
  Data.ADOFix.SQL.Add(Edit4.Text);
  try
  Data.ADOFix.Open;
  except
    MessageDlg('SQL Error!',mtError,[mbOK],0);
  end;
  end
  else MessageDlg('Error! Not Null Allowed',mtError,[mbOK],0);

end;

end.