unit3.~pas

高校图书管理系统采用Delphi结合数据库

unit Unit3;

interface

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

type
  Tfrm_xxlr = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    GroupBox1: TGroupBox;
    Table1: TTable;
    DataSource1: TDataSource;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    GroupBox2: TGroupBox;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    DBEdit8: TDBEdit;
    DBEdit9: TDBEdit;
    DBNavigator1: TDBNavigator;
    DBGrid1: TDBGrid;
    DBNavigator2: TDBNavigator;
    Button5: TButton;
    Label11: TLabel;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    Label12: TLabel;
    Label13: TLabel;
    DBEdit12: TDBEdit;
    Label14: TLabel;
    DBEdit13: TDBEdit;
    DBEdit14: TDBEdit;
    DateTimePicker1: TDateTimePicker;
    Label15: TLabel;
    Label16: TLabel;
    DBEdit15: TDBEdit;
    Label17: TLabel;
    DBEdit16: TDBEdit;
    Label18: TLabel;
    DBEdit17: TDBEdit;
    DBEdit18: TDBEdit;
    DateTimePicker2: TDateTimePicker;
    procedure TabSheet1ContextPopup(Sender: TObject; MousePos: TPoint;
      var Handled: Boolean);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure TabSheet2ContextPopup(Sender: TObject; MousePos: TPoint;
      var Handled: Boolean);
    procedure DBEdit9Change(Sender: TObject);
    procedure DateTimePicker2Change(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frm_xxlr: Tfrm_xxlr;

implementation

uses Unit1;

{$R *.dfm}

procedure Tfrm_xxlr.TabSheet1ContextPopup(Sender: TObject;
  MousePos: TPoint; var Handled: Boolean);
begin
table1.Last ;
datetimepicker1.Date :=table1.FieldValues['出生年月'];
end;

procedure Tfrm_xxlr.Button1Click(Sender: TObject);
begin
groupbox1.Enabled :=true;
table1.Append ;
datetimepicker1.Date :=strtodate('1981-1-1');
button1.Enabled :=false;
button2.Enabled :=true;
 button3.Enabled :=true;
end;

procedure Tfrm_xxlr.Button2Click(Sender: TObject);
begin
table1.FieldByName('出生年月').AsDateTime :=datetimepicker1.Date ;
table1.Post ;
table1.Refresh ;
button1.Enabled :=true;
 button2.Enabled :=false;
 button3.Enabled :=false;
 groupbox1.Enabled :=false;
 table1.Last ;
end;

procedure Tfrm_xxlr.Button3Click(Sender: TObject);
begin
table1.Cancel ;
button1.Enabled :=true;
button2.Enabled :=false;
button3.Enabled :=false;
groupbox1.Enabled :=false;
table1.Last ;
end;

procedure Tfrm_xxlr.TabSheet2ContextPopup(Sender: TObject;
  MousePos: TPoint; var Handled: Boolean);
begin
table1.First ;
datetimepicker2.Date:=table1.FieldValues ['出生年月'];
end;

procedure Tfrm_xxlr.DBEdit9Change(Sender: TObject);
begin
 if dbedit9.Text ='' then exit;
  datetimepicker2.Date:=strtodate(dbedit9.Field.Value);
end;
procedure Tfrm_xxlr.DateTimePicker2Change(Sender: TObject) ;
begin
table1.Edit;
dbedit9.Field.Value :=datetostr(datetimepicker2.Date);
end;
procedure Tfrm_xxlr.Button4Click(Sender: TObject);
var
a:integer;
begin
a:=application.MessageBox('删除记录吗？','提示',mb_yesno);
if a=idok then table1.Delete ;
end;

procedure Tfrm_xxlr.Button5Click(Sender: TObject);
begin
close;
end;

end.