holdmodifyform.pas

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

unit holdmodifyform;

interface

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

type
  Tholdmodify = class(TForm)
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    Label1: TLabel;
    Edit12: TEdit;
    Label2: TLabel;
    Edit13: TEdit;
    Edit14: TEdit;
    Edit15: TEdit;
    Edit16: TEdit;
    Edit17: TEdit;
    Edit21: TEdit;
    Edit18: TEdit;
    Edit19: TEdit;
    Edit20: TEdit;
    Edit22: TEdit;
    Edit23: TEdit;
    Edit24: TEdit;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label3: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    btfind: TButton;
    btchange: TButton;
    ComboBox4: TComboBox;
    Label9: TLabel;
    ComboBox6: TComboBox;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    ComboBox5: TComboBox;
    btfindr: TButton;
    Label15: TLabel;
    btchanger: TButton;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure btfindClick(Sender: TObject);
    procedure btchangeClick(Sender: TObject);
    procedure btfindrClick(Sender: TObject);
    procedure btchangerClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  holdmodify: Tholdmodify;

implementation

uses mainform, DataM;

{$R *.dfm}

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

procedure Tholdmodify.btfindClick(Sender: TObject);
begin
 if (Edit12.Text<>'') and ((Length(Edit12.Text)=15) or (Length(Edit12.Text)=18)) then
  Begin
  Data.ADOtHJGL.Close;
  Data.ADOtHJGL.SQL.Clear;
  Data.ADOtHJGL.SQL.Add('select * from HomeMaster where HomeMasterSIDCardNo="'+Edit12.Text+'"');
  Data.ADOtHJGL.Open;
  if Data.ADOtHJGL.RecordCount=1 then
  begin
    Edit13.Text:=Data.ADOtHJGL['HomeMasterName'];
    Edit14.Text:=Data.ADOtHJGL['HomeMasterSIDCardNo'];
    Edit15.Text:=Data.ADOtHJGL['ZoneNo'];
    Edit16.Text:=Data.ADOtHJGL['BuildingNo'];
    Edit17.Text:=Data.ADOtHJGL['UnitNo'];
    Edit18.Text:=Data.ADOtHJGL['HomePhoneNo'];
    if Data.ADOtHJGL.FieldByName('MasterBirthday').AsString<>'' then
      Edit19.Text:=Data.ADOtHJGL['MasterBirthday'];
    Edit21.Text:=Data.ADOtHJGL['DoorNo'];
    ComboBox4.Text:=Data.ADOtHJGL['Sex'];
    btChange.Enabled:=True;
    Edit12.Enabled:=False;
  end
  else
    MessageDlg('错误! 没有找到记录!',mtError,[mbOK],0);
  end
  else
    MessageDlg('错误! 身份证号输入不合法.',mtError,[mbOK],0);
  Data.ADOtHJGL.Close;
  Data.ADOtHJGL.SQL.Clear;
  Data.ADOtHJGL.SQL.Add('select * from HomeMaster');
  Data.ADOtHJGL.Open;

end;

procedure Tholdmodify.btchangeClick(Sender: TObject);
begin
if (Edit13.Text<>'') and (Edit14.Text<>'') and (Edit15.Text<>'') and (Edit16.Text<>'') and (Edit17.Text<>'') and (Edit21.Text<>'') then
  begin
  Data.ADOtHJGL.Close;
  Data.ADOtHJGL.SQL.Clear;
  Data.ADOtHJGL.SQL.Add('select * from HomeMaster where HomeMasterSIDCardNo="'+Edit12.Text+'"');
  Data.ADOtHJGL.Open;
  if Data.ADOtHJGL.RecordCount=1 then
  begin
    Data.ADOtHJGL.Edit;
    Data.ADOtHJGL['HomeMasterName']:=Edit13.Text;
    Data.ADOtHJGL['HomeMasterSIDCardNo']:=Edit14.Text;
    Data.ADOtHJGL['ZoneNo']:=Edit15.Text;
    Data.ADOtHJGL['BuildingNo']:=Edit16.Text;
    Data.ADOtHJGL['UnitNo']:=Edit17.Text;
    Data.ADOtHJGL['HomePhoneNo']:=Edit18.Text;
    Data.ADOtHJGL['MasterBirthday']:=Edit19.Text;
    Data.ADOtHJGL['DoorNo']:=Edit21.Text;
    Data.ADOtHJGL['Sex']:=ComboBox4.Text;
    Data.ADOtHJGL.Post;
    Edit13.Text:='';
    Edit14.Text:='';
    Edit15.Text:='';
    Edit16.Text:='';
    Edit17.Text:='';
    Edit18.Text:='';
    Edit19.Text:='';
    Edit21.Text:='';
    ComboBox4.Text:='';
    btChange.Enabled:=False;
    Edit12.Enabled:=True;
  end
  else
    MessageDlg('没有找到记录',mtError,[mbOK],0);
  end
  else
    MessageDlg('输入值不能为空',mtError,[mbOK],0);
  Data.ADOtHJGL.Close;
  Data.ADOtHJGL.SQL.Clear;
  Data.ADOtHJGL.SQL.Add('select * from HomeMaster');
  Data.ADOtHJGL.Open;

end;

procedure Tholdmodify.btfindrClick(Sender: TObject);
begin
 if (Edit20.Text<>'') and ((Length(Edit20.Text)=15) or (Length(Edit20.Text)=18)) then
  Begin
  Data.ADOtMember.Close;
  Data.ADOtMember.SQL.Clear;
  Data.ADOtMember.SQL.Add('select * From OtherMembers where IDcardno="'+Edit20.Text+'"');
  Data.ADOtMember.Open;
  if Data.ADOtMember.RecordCount=1 then
  begin
    Edit22.Text:=Data.ADOtMember['Name'];
    Edit23.Text:=Data.ADOtMember['HomeMasterSIDCardNo'];
    Edit24.Text:=Data.ADOtMember['IDCardNo'];
    ComboBox6.Text:=Data.ADOtMember['RelationToMaster'];
    ComboBox5.Text:=Data.ADOtMember['Sex'];
    btChangeR.Enabled:=True;
    Edit20.Enabled:=False;
  end
  else
    MessageDlg('错误! 没有找到记录!',mtError,[mbOK],0);
  end
  else
    MessageDlg('错误! 身份证号输入不合法.',mtError,[mbOK],0);
  Data.ADOtMember.Close;
  Data.ADOtMember.SQL.Clear;
  Data.ADOtMember.SQL.Add('select * from OtherMembers');
  Data.ADOtMember.Open;

end;

procedure Tholdmodify.btchangerClick(Sender: TObject);
begin
if (Edit22.Text<>'') and (Edit23.Text<>'') then
  begin
  Data.ADOtMember.Close;
  Data.ADOtMember.SQL.Clear;
  Data.ADOtMember.SQL.Add('select * From OtherMembers where IDCardNo="'+Edit20.Text+'"');
  Data.ADOtMember.Open;
  if Data.ADOtMember.RecordCount=1 then
  begin
    Data.ADOtMember.Edit;
    Data.ADOtMember['Name']:=Edit22.Text;
    Data.ADOtMember['HomeMasterSIDCardNo']:=Edit23.Text;
    Data.ADOtMember['IDCardNo']:=Edit24.Text;
    Data.ADOtMember['Sex']:=ComboBox5.Text;
    Data.ADOtMember['RelationToMaster']:=ComboBox6.Text;
    Data.ADOtMember.Post;
    Edit22.Text:='';
    Edit23.Text:='';
    Edit24.Text:='';
    ComboBox5.Text:='';
    ComboBox6.Text:='';
    btChangeR.Enabled:=False;
    Edit20.Enabled:=True;
  end
  else
    MessageDlg('没有找到记录',mtError,[mbOK],0);
  end
  else
    MessageDlg('输入值不能为空',mtError,[mbOK],0);
  Data.ADOtMember.Close;
  Data.ADOtMember.SQL.Clear;
  Data.ADOtMember.SQL.Add('select * from OtherMembers');
  Data.ADOtMember.Open;

end;

end.