unit14.pas

图书管理系统

unit Unit14;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, QRCtrls, QuickRpt, ExtCtrls, DB, ADODB;

type
  TfrmScore = class(TForm)
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    QuickRep1: TQuickRep;
    ColumnHeaderBand1: TQRBand;
    DetailBand1: TQRBand;
    PageFooterBand1: TQRBand;
    TitleBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel2: TQRLabel;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    QRDBText9: TQRDBText;
    QRDBText10: TQRDBText;
    ADOQuery3: TADOQuery;
    QRLabel12: TQRLabel;
    QRLabel13: TQRLabel;
    QRLabel18: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel11: TQRLabel;
    QRLabel15: TQRLabel;
    QRLabel16: TQRLabel;
    QRLabel17: TQRLabel;
    QRLabel19: TQRLabel;
    QRLabel3: TQRLabel;
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmScore: TfrmScore;

implementation

uses Main;

{$R *.dfm}

procedure TfrmScore.FormCreate(Sender: TObject);
var
  score:integer;
begin
  ADOQuery3.Active:=false;
  with ADOQuery1 do begin   //从表Readers和Borrowinfo查询得到读者的编号、累计借书量及超期天数
    close;
    SQL.Clear;
    SQL.Add('select reader_no,reader_amount,BR_days from');
    SQL.Add('Readers,Borrowinfo where Readers.reader_no=Borrowinfo.BR_readerno');
    Open;

    while not ADOQuery1.Eof do   //修改读者的信用分数
      begin
        score:=1000+ ADOQuery1.FieldByName('reader_amount').AsInteger-ADOQuery1.FieldByName('BR_days').AsInteger*50;
        with ADOQuery2 do begin
          close;
          SQL.Clear;
          SQL.Add('update Readers set reader_score='+QuotedStr(IntToStr(score))+' where reader_no=:ReaderNo');
          Parameters.ParamByName('ReaderNo').Value:=ADOQuery1.FieldByName('reader_no').AsString;
          ExecSQL;
        end;
      Next;
      end;
  end;
end;

end.