addcustomunit.pas

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

unit ADDCustomUnit;

interface

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

type
  TADDCustom_Form = class(TForm)
    Client_Panel: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBComboBox1: TDBComboBox;
    DBEdit5: TDBEdit;
    DBComboBox2: TDBComboBox;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    DBEdit8: TDBEdit;
    DBMemo1: TDBMemo;
    StatusBar1: TStatusBar;
    Top_Panel: TPanel;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    Save_But: TBitBtn;
    BitBtn5: TBitBtn;
    Label12: TLabel;
    DBEdit9: TDBEdit;
    DBGrid1: TDBGrid;
    SelectGuest_BUT: TBitBtn;
    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);
    procedure SelectGuest_BUTClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  ADDCustom_Form: TADDCustom_Form;

implementation

uses DataM, SelectFromGuestUnit;

{$R *.dfm}

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

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

procedure TADDCustom_Form.BitBtn2Click(Sender: TObject);
begin
DM.Custom_Query.Insert ;
Save_But.Enabled := True ;
SelectGuest_BUT.Enabled := True ;
end;

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

procedure TADDCustom_Form.Save_ButClick(Sender: TObject);
begin
DM.Custom_Query.Post ;
Save_But.Enabled := False ;
SelectGuest_BUT.Enabled := False ;
end;

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

procedure TADDCustom_Form.SelectGuest_BUTClick(Sender: TObject);
begin
Application.CreateForm(TSelectFromGuest_Form,SelectFromGuest_Form);
SelectFromGuest_Form.Caption := Application.Title + '--选择来访记录' ;
SelectFromGuest_Form.ShowModal  ;
SelectFromGuest_Form.Free ;
end;

end.