addguestunit.pas

帮朋友编写的幼儿教育的管理平台

unit ADDGuestUnit;

interface

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

type
  TADDGuest_Form = class(TForm)
    Top_Panel: TPanel;
    Client_Panel: TPanel;
    StatusBar1: TStatusBar;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBComboBox1: TDBComboBox;
    DBEdit5: TDBEdit;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    Save_But: TBitBtn;
    BitBtn5: TBitBtn;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    DBComboBox2: TDBComboBox;
    Label8: TLabel;
    DBEdit6: TDBEdit;
    Label9: TLabel;
    DBEdit7: TDBEdit;
    Label10: TLabel;
    DBEdit8: TDBEdit;
    Label11: TLabel;
    DBMemo1: TDBMemo;
    DBGrid1: TDBGrid;
    DBComboBox3: TDBComboBox;
    Label12: TLabel;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure Save_ButClick(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  ADDGuest_Form: TADDGuest_Form;

implementation

uses DataM;

{$R *.dfm}

procedure TADDGuest_Form.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
DM.Guest_Query.Close ;
Free ;
end;

procedure TADDGuest_Form.FormShow(Sender: TObject);
Var SQLString:String;
begin
DM.Guest_Query.Close ;
DM.Guest_Query.SQL.Clear ;
SQLString := 'select * from tblGuest where IsDisplay=''1'' and 登记时间>= #'+ DateToStr(now()-1)+'# Order By 登记时间';
DM.Guest_Query.SQL.Add(SQLString) ;
DM.Guest_Query.Open ;
end;

procedure TADDGuest_Form.BitBtn2Click(Sender: TObject);
begin
DM.Guest_Query.Insert ;
Save_But.Enabled := True ;
end;

procedure TADDGuest_Form.BitBtn3Click(Sender: TObject);
begin
DM.Guest_Query.Edit ;
Save_But.Enabled := True ;
end;

procedure TADDGuest_Form.Save_ButClick(Sender: TObject);
begin
DM.Guest_Query.Post ;
Save_But.Enabled := False ;
end;

procedure TADDGuest_Form.BitBtn5Click(Sender: TObject);
begin
DM.Guest_Query.Cancel ;
Save_But.Enabled := False ;
end;

end.