fangtai.pas

小管理程序主要管理的小咖啡厅我是从网上下的经测试可用

unit fangtai;

interface

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

type
  TFrmfangtai = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit4: TDBEdit;
    Btnnew: TSpeedButton;
    Btnmodi: TSpeedButton;
    Btndel: TSpeedButton;
    BtnSave: TSpeedButton;
    GroupBox2: TGroupBox;
    DBGrid1: TDBGrid;
    DBComboBox1: TDBComboBox;
    DBoprate: TDBNavigator;
    Btncancel: TSpeedButton;
    procedure BtnnewClick(Sender: TObject);
    procedure BtnmodiClick(Sender: TObject);
    procedure BtndelClick(Sender: TObject);
    procedure BtnSaveClick(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormActivate(Sender: TObject);
    procedure BtncancelClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frmfangtai: TFrmfangtai;
implementation
 uses  dbmodule;
{$R *.dfm}

procedure TFrmfangtai.BtnnewClick(Sender: TObject);
begin
  dboprate.BtnClick(nbInsert);
  dbedit1.SetFocus;
end;

procedure TFrmfangtai.BtnmodiClick(Sender: TObject);
begin
  dboprate.BtnClick(nbEdit);
end;

procedure TFrmfangtai.BtndelClick(Sender: TObject);
begin
 if messagedlg('确定删除所选房台吗？',mtWarning,[mbOK,mbCancel],0)=mrOk  then
  begin
    if dm.Qfangtai.RecordCount>0 then
      begin
        dm.Qfangtai.Refresh;
        dm.Qfangtai.Edit;
        dm.Qfangtai.FieldByName('isdel').AsInteger :=1;
        dm.Qfangtai.Post;
      end;
  end;
end;

procedure TFrmfangtai.BtnSaveClick(Sender: TObject);
begin
  if (dm.Qfangtai.State in [dsEdit,dsInsert])  then
     dboprate.BtnClick(nbPost);
end;

procedure TFrmfangtai.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  if dm.Qfangtai.Active then
    dm.Qfangtai.Close ;
end;

procedure TFrmfangtai.FormActivate(Sender: TObject);
begin
   if not dm.Qfangtai.Active  then
   dm.Qfangtai.Open ;
end;

procedure TFrmfangtai.BtncancelClick(Sender: TObject);
begin
   dboprate.BtnClick(nbCancel);
end;

end.