shunxudayin.pas

有不足之处请指出

unit shunxudayin;

interface

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

type
  TshunxudayinForm = class(TForm)
    Label1: TLabel;
    ComboBox1: TComboBox;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    SeektoprnQuery: TQuery;
    SeektoprnQueryXuehao: TStringField;
    SeektoprnQueryXingming: TStringField;
    SeektoprnQueryXingbie: TStringField;
    SeektoprnQueryBanji: TStringField;
    SeektoprnQueryChushengnianyue: TStringField;
    SeektoprnQueryJiguan: TStringField;
    SeektoprnQueryFumuxingming: TStringField;
    SeektoprnQueryLianxidianhua: TStringField;
    SeektoprnQueryXianzhuzhi: TStringField;
    QuickRep1: TQuickRep;
    QRBand1: TQRBand;
    QRBand2: TQRBand;
    QRBand3: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel2: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRSysData1: TQRSysData;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel10: TQRLabel;
    QRDBText8: TQRDBText;
    QRDBText9: TQRDBText;
    BanjiTable: TTable;
    BanjiTableBianhao: TStringField;
    BanjiTableMingcheng: TStringField;
    BanjiTableNansheng: TIntegerField;
    BanjiTableNvsheng: TIntegerField;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button3Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure ComboBox1Change(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  shunxudayinForm: TshunxudayinForm;

implementation

{$R *.dfm}

procedure TshunxudayinForm.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
Action:=caFree;
end;

procedure TshunxudayinForm.Button3Click(Sender: TObject);
begin
close;
end;

procedure TshunxudayinForm.FormCreate(Sender: TObject);
var i:integer;
begin
ComboBox1.Clear ;
banjiTable.Open ;
i:=0;
banjiTable.First ;
while i<banjiTable.RecordCount do
   begin
     ComboBox1.Items.Insert(i,banjiTablemingcheng.Value);
     banjiTable.Next ;
     i:=i+1;
   end;
banjiTable.Close ;
end;

procedure TshunxudayinForm.FormShow(Sender: TObject);
begin
Button1.Enabled :=False;
Button2.Enabled :=False;
end;

procedure TshunxudayinForm.ComboBox1Change(Sender: TObject);
begin
if length(ComboBox1.Text)=0 then
    begin
      Button1.Enabled :=False;
      Button1.Enabled :=False;
    end
else
    begin
      Button1.Enabled :=True;
      Button2.Enabled :=True;
    end;
end;

procedure TshunxudayinForm.Button1Click(Sender: TObject);
begin
SeektoprnQuery.Close ;
SeektoprnQuery.SQL.Clear ;
SeektoprnQuery.Params.Clear ;
SeektoprnQuery.Params.CreateParam(ftstring,'bj',ptinput).AsString :=ComboBox1.Text ;
SeektoprnQuery.SQL.Add('select * from students where banji=:bj order by xuehao;');
SeektoprnQuery.ExecSQL ;
SeektoprnQuery.Open ;
Qrlabel1.Caption :=ComboBox1.Text +'的学生档案信息报表清单';
Qrlabel1.Font.Size :=16;
QuickRep1.Preview;
SeektoprnQuery.Close;
ComboBox1.Text :='';
Button1.Enabled :=False;
Button2.Enabled :=False;
end;

procedure TshunxudayinForm.Button2Click(Sender: TObject);
begin
SeektoprnQuery.Close ;
SeektoprnQuery.SQL.Clear ;
SeektoprnQuery.Params.Clear ;
SeektoprnQuery.Params.CreateParam(ftstring,'bj',ptinput).AsString :=ComboBox1.Text ;
SeektoprnQuery.SQL.Add('select * from students where banji=:bj order by xuehao;');
SeektoprnQuery.ExecSQL ;
SeektoprnQuery.Open ;
Qrlabel1.Caption :=ComboBox1.Text +'的学生档案信息报表清单';
Qrlabel1.Font.Size :=16;
QuickRep1.Print ;
SeektoprnQuery.Close ;
ComboBox1.Text :='';
Button1.Enabled :=False;
Button1.Enabled :=False;
end;

end.