closeidfrm.~pas

基于Interbase的图书管理系统

unit closeidfrm;

interface

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

type
  TCloseidForm = 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;
    Panel3: TPanel;
    GroupBox6: TGroupBox;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    DBE6: TDBEdit;
    DBE7: TDBEdit;
    DBE8: TDBEdit;
    DBE9: TDBEdit;
    DBE10: TDBEdit;
    Splitter2: TSplitter;
    GBoption: TGroupBox;
    Label7: TLabel;
    DBE11: TDBEdit;
    PC2: TPageControl;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    Panel4: TPanel;
    BtBcancel1: TBitBtn;
    BtBcloseid: TBitBtn;
    Panel5: TPanel;
    BtBgoid: TBitBtn;
    BtBcancel2: TBitBtn;
    Label22: TLabel;
    Label23: TLabel;
    procedure FormDestroy(Sender: TObject);
    procedure DBE2Change(Sender: TObject);
    procedure BtBreaderidClick(Sender: TObject);
    procedure BtBreadernoClick(Sender: TObject);
    procedure EdreaderidKeyPress(Sender: TObject; var Key: Char);
    procedure LBbookClick(Sender: TObject);
    procedure BtBcancel1Click(Sender: TObject);
    procedure BtBgoidClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure BtBcloseidClick(Sender: TObject);
  private
        { Private declarations }
  public
     procedure clearDBEdit;
     procedure clearedit;
        { Public declarations }
  end;

var
  CloseidForm: TCloseidForm;

implementation

uses dmfrm, rpcloseidfrm;

{$R *.dfm}

procedure TCloseidForm.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;
  LBbook.Clear;
  PC2.Enabled:=false;
end;

procedure TCloseidForm.clearedit;
begin
  DBE6.Clear;
  DBE7.Clear;
  DBE8.Clear;
  DBE9.Clear;
  DBE10.Clear;
  DBE11.Clear;
end;

procedure TCloseidForm.FormDestroy(Sender: TObject);
begin
  inherited;
CloseidForm:=nil;
end;

procedure TCloseidForm.DBE2Change(Sender: TObject);
begin
  inherited;
  IF TDBEdit(sender).Text=Emptystr then
  begin
  PC2.Enabled:=false;
  GBoption.Cursor:=crNo;
  end
  else begin
  PC2.Enabled:=true;
  GBoption.Cursor:=crDefault;
  end;
end;

procedure TCloseidForm.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);
clearedit;
end;

procedure TCloseidForm.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']);
clearedit;
end;

procedure TCloseidForm.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 TCloseidForm.LBbookClick(Sender: TObject);
var
 tmpstring:string;
begin
  inherited;
 tmpstring:=LBbook.Items.Strings[LBbook.ItemIndex];
 tmpstring:=copy(tmpstring,2,length(tmpstring));
 tmpstring:=copy(tmpstring,1,pos(']',tmpstring)-1);
 dmbook.Qrybook.Locate('book_id',tmpstring,[]);
 dmbook.Qrybook.EnableControls;
end;

procedure TCloseidForm.BtBcancel1Click(Sender: TObject);
begin
  inherited;
clearDBEdit;
end;

procedure TCloseidForm.BtBgoidClick(Sender: TObject);
var
Aresult:boolean;
begin
  inherited;
if DBE2.Text=Emptystr then
  begin
   bookInformation('请输入借书证号！');
   Edreaderid.SetFocus;
   Edreaderid.Clear;
   exit;
  end;
if LBbook.Count<>0 then
 begin
    bookInformation('他借有书，不能退借书证！'+#13+'还书以后，再退借书证！');
    clearDBEdit;
    exit;
 end;
//退借书证处理
if dmbook.comparedatemothed(StrToDateTime(DBE5.Text),now)=1 then
   begin
    bookInformation('退证日期不能小于办借日期,'+#13+'系统日期有误,修改系统日期！');
    exit;
   end;
dmbook.goreaderid(DBE2.Text,Aresult);
if not Aresult then
begin
   bookError('退借书证失败！'+#13+'可能他没有还完书或是操作失败！');
   exit;
end;
dmbook.closereader;
dmbook.openreader;
clearDBEdit;
end;

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

procedure TCloseidForm.BtBcloseidClick(Sender: TObject);
begin
  inherited;
if LBbook.Count<>0 then
 begin
    bookInformation('他借有书，不能祉办借书证！'+#13+'还书以后，再祉办借书证！');
    clearDBEdit;
    exit;
 end;
dmbook.closereader;
dmbook.Qryreader.Filter:='reader_id='+QuotedStr(Edreaderid.Text);
dmbook.Qryreader.Filtered:=true;
if not assigned(rpcloseidform) then
 rpcloseidform:=trpcloseidform.create(self);
 try
 rpcloseidform.QRreaderid.Print;
 finally
 rpcloseidform.Free;
 rpcloseidform:=nil;
 end;
 dmbook.closereader;
dmbook.openreader;
end;

end.