readeridnofrm.pas

基于Interbase的图书管理系统

unit readeridnofrm;

interface

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

type
  TreaderidnoForm = class(TChildForm)
    GroupBox1: TGroupBox;
    GroupBox3: TGroupBox;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label13: TLabel;
    DBE1: TDBEdit;
    DBE2: TDBEdit;
    DBE3: TDBEdit;
    DBE4: TDBEdit;
    DBE5: TDBEdit;
    GroupBox4: TGroupBox;
    LBbook: TListBox;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    Panel1: TPanel;
    Label1: TLabel;
    Edreaderno: TEdit;
    BtBreaderno: TBitBtn;
    Panel2: TPanel;
    Label2: TLabel;
    Edreaderid: TEdit;
    BtBreaderid: TBitBtn;
    Splitter1: TSplitter;
    GroupBox6: TGroupBox;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label7: TLabel;
    DBE6: TDBEdit;
    DBE7: TDBEdit;
    DBE8: TDBEdit;
    DBE9: TDBEdit;
    DBE10: TDBEdit;
    DBE11: TDBEdit;
    Label14: TLabel;
    EdBorrowdate: TEdit;
    Label15: TLabel;
    EdBorrowday: TEdit;
    Label16: TLabel;
    EdBorrowpass: TEdit;
    Label17: TLabel;
    EdRenewaldate: TEdit;
    Label18: TLabel;
    EdRenewalday: TEdit;
    Label19: TLabel;
    EdRenewalpass: TEdit;
    Label20: TLabel;
    DBE12: TDBEdit;
    Label21: TLabel;
    DBE13: TDBEdit;
    Label22: TLabel;
    Label23: TLabel;
    procedure FormDestroy(Sender: TObject);
    procedure BtBreaderidClick(Sender: TObject);
    procedure BtBreadernoClick(Sender: TObject);
    procedure EdreaderidKeyPress(Sender: TObject; var Key: Char);
    procedure LBbookClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
        { Private declarations }
  public
     procedure clearDBEdit;
     procedure clearedit;
        { Public declarations }
  end;

var
  readeridnoForm: TreaderidnoForm;

implementation

uses dmfrm;

{$R *.dfm}

procedure TreaderidnoForm.clearDBEdit;
begin
  Edreaderid.Clear;
  EdReaderno.Clear;
  DBE1.Clear;
  DBE2.Clear;
  DBE3.Clear;
  DBE4.Clear;
  DBE5.Clear;
  DBE6.Clear;
  DBE7.Clear;
  DBE8.Clear;
  DBE9.Clear;
  DBE10.Clear;
  DBE11.Clear;
  DBE12.Clear;
  DBE13.Clear;
  LBbook.Clear;
  EdBorrowdate.Clear;
  EdBorrowday.Clear;
  EdBorrowpass.Clear;
  EdRenewaldate.Clear;
  EdRenewalday.Clear;
  EdRenewalpass.Clear;
end;

procedure TreaderidnoForm.clearedit;
begin
  DBE6.Clear;
  DBE7.Clear;
  DBE8.Clear;
  DBE9.Clear;
  DBE10.Clear;
  DBE11.Clear;
  DBE12.Clear;
  DBE13.Clear;
  EdBorrowdate.Clear;
  EdBorrowday.Clear;
  EdBorrowpass.Clear;
  EdRenewaldate.Clear;
  EdRenewalday.Clear;
  EdRenewalpass.Clear;
end;

procedure TreaderidnoForm.FormDestroy(Sender: TObject);
begin
  inherited;
readeridnoForm:=nil;
end;

procedure TreaderidnoForm.BtBreaderidClick(Sender: TObject);
begin
  inherited;
 if Edreaderid.Text=Emptystr then
  begin
   bookInformation('请输入借书证号！');
   Edreaderid.SetFocus;
   Edreaderid.Clear;
   exit;
  end;
 dmbook.readerfirst;
 if not dmbook.Qryreader.Locate('reader_id',Edreaderid.Text,[]) then
   begin
    clearDBEdit;
    bookInformation('输入借书证号在数据库中不存在！');
    Edreaderid.SetFocus;
    exit;
   end;
//dmbook.Qryreader.EnableControls;
LBbook.Items.text:=dmbook.getborrowedbook(Edreaderid.Text);
Edreaderno.Text:=DBE1.Text;
clearedit;
end;

procedure TreaderidnoForm.BtBreadernoClick(Sender: TObject);
begin
  inherited;
 if Edreaderno.Text=Emptystr then
  begin
   bookInformation('请输入工号！');
   Edreaderno.SetFocus;
   Edreaderno.Clear;
   exit;
  end;
   dmbook.readerfirst;
  if not dmbook.Qryreader.Locate('reader_no',Edreaderno.Text,[]) then
   begin
    clearDBEdit;
    bookInformation('输入工号在数据库中不存在！');
    Edreaderno.SetFocus;
    exit;
   end;
//dmbook.Qryreader.EnableControls;
LBbook.Items.text:=dmbook.getborrowedbook(dmbook.Qryreader['reader_id']);
Edreaderid.Text:=DBE2.Text;
clearedit;
end;

procedure TreaderidnoForm.EdreaderidKeyPress(Sender: TObject; var Key: Char);
begin
  inherited;
 if key=#13 then
 begin
  if TEdit(Sender)=Edreaderid then BtBreaderidClick(Sender);
  if TEdit(Sender)=Edreaderno then BtBreadernoClick(Sender);
 end
 else begin
        if not(key in ['0'..'9',#8]) then
         begin
          key:=#0;
          beep;
         end;
       end;
end;

procedure TreaderidnoForm.LBbookClick(Sender: TObject);
var
 tmpstring,Aborrowdate,Aborrowday,Arenewaldate,Arenewalday:string;
 begin
  inherited;
 tmpstring:=LBbook.Items.Strings[LBbook.ItemIndex];
 tmpstring:=copy(tmpstring,2,length(tmpstring));
 tmpstring:=copy(tmpstring,1,pos(']',tmpstring)-1);
 dmbook.bookfirst;
 dmbook.Qrybook.Locate('book_id',tmpstring,[]);
 //得到借书信息
 DMbook.getborrowdateday(DBE2.Text,tmpstring,Aborrowdate,Aborrowday,Arenewaldate,Arenewalday);
EdBorrowdate.Text:=Aborrowdate;
EdBorrowday.Text:=Aborrowday;
EdRenewaldate.Text:=Arenewaldate;
EdRenewalday.Text:=Arenewalday;
if Arenewaldate=Emptystr then
 begin
   if dmbook.comparedatemothed(StrToDateTime(Aborrowdate),now)=1 then
   begin
    bookInformation('他没有续借该书,'+#13+'还书日期不能小于初借日期,'+#13+'系统日期有误,修改系统日期！');
   clearedit;
    exit;
   end;
 EdBorrowpass.Text:=inttostr(dmbook.passdaymothed(StrToDateTime(Aborrowdate),now,strtoint(Aborrowday)));
 if strtoint(EdBorrowpass.Text)<0 then EdBorrowpass.Text:='0';
 EdRenewalpass.Text:=Emptystr;
 end
else begin
     if dmbook.comparedatemothed(StrToDateTime(ARenewaldate),now)=1 then
   begin
    bookInformation('他续借了该书,'+#13+'还书日期不能小于续借日期,'+#13+'系统日期有误,修改系统日期！');
   clearedit;
   exit;
   end;
EdBorrowpass.Text:=inttostr(dmbook.passdaymothed(StrToDateTime(Aborrowdate),StrToDateTime(Arenewaldate),strtoint(Aborrowday)));
EdRenewalpass.Text:=inttostr(dmbook.passdaymothed(StrToDateTime(Arenewaldate),now,strtoint(Arenewalday)));
if strtoint(EdBorrowpass.Text)<0 then EdBorrowpass.Text:='0';
if strtoint(EdRenewalpass.Text)<0 then EdRenewalpass.Text:='0';
    end;
//使数据显示控件显示数据
 if dmbook.Qrybook.ControlsDisabled then dmbook.Qrybook.EnableControls;
end;

procedure TreaderidnoForm.FormShow(Sender: TObject);
begin
  inherited;
  dmbook.closebook;
  dmbook.closereader; 
  dmbook.openbook;
  dmbook.openreader;
  clearDBEdit;
end;

end.