ujyxx.pas

来自「很好的汽车管理系统 很实用的 谢谢合作」· PAS 代码 · 共 96 行

unit UJYXX;

interface

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

type
  TJYXX = class(TForm)
    ToolBar1: TToolBar;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    procedure SpeedButton1Click(Sender: TObject);
    procedure DBGrid1DblClick(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure SpeedButton2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  JYXX: TJYXX;
  ActionCD:string;
implementation

uses UJYXX_ED, UDM, UMain;

{$R *.dfm}

procedure TJYXX.SpeedButton1Click(Sender: TObject);
begin
  Application.CreateForm(TJYXX_ED,JYXX_ED);
  ActionCD:='M';
  JYXX_ED.ShowModal;
  JYXX_ED.Free;
end;

procedure TJYXX.DBGrid1DblClick(Sender: TObject);
begin
  Application.CreateForm(TJYXX_ED,JYXX_ED);
  JYXX_ED.GetAll;
  JYXX_ED.ShowModal;
  JYXX_ED.Free;
end;

procedure TJYXX.SpeedButton4Click(Sender: TObject);
begin
  Close;
end;

procedure TJYXX.FormCreate(Sender: TObject);
begin
  with DM.QJYXX do
  begin
    close;
    sql.Clear;
    sql.Add('select * from JYXX');
    open;
  end;
  DM.ADODSJYXX.Open;
end;

procedure TJYXX.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  DM.QJYXX.Close;
  DM.QJYXX.Close;
end;
procedure TJYXX.SpeedButton2Click(Sender: TObject);
begin
   if DM.ADODSJYXX.RecordCount=0 then
   begin
     Application.MessageBox('已无记录可删除!','提示',0+MB_ICONINFORMATION);
     exit;
   end;
   if DM.ADODSJYXX.IsEmpty then
     exit;
   if ID_YES=application.MessageBox('确实要删除这条记录吗？','提示',MB_YESNO) then
   begin
     DM.ADODSJYXX.Delete;
   end;
end;

end.