unit7.pas

学生缴费管理系统是以面向对象的观点进行开发的。根据对学生缴费信息与软件要求所做分析然后利用DELPHI开发出来的软件

unit Unit7;

interface

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

type
  TForm7 = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    Label2: TLabel;
    Button2: TButton;
    Label3: TLabel;
    Edit3: TEdit;
    Button3: TButton;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Query1: TQuery;
    Button5: TButton;
    Button6: TButton;
    Label4: TLabel;
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form7: TForm7;

implementation
 uses unit2;
{$R *.dfm}

procedure TForm7.Button1Click(Sender: TObject);
begin
if  edit1.Text<>''then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select sum(应缴费用) as 班级已缴费用 from 学生缴费');
query1.SQL.Add('where 缴费=true and 班级='''+edit1.text+'''');
query1.Prepare;
query1.open;
end
else
showmessage('请输入班级');
end;

procedure TForm7.Button3Click(Sender: TObject);
begin
if edit3.Text<>'' then
begin
   query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select sum(应缴费用) as 年级已缴费用 from 学生缴费');
query1.SQL.Add('where 缴费=true and 年级='''+edit3.text+'''');
query1.Prepare;
query1.open;
end
else
showmessage('请输入年纪');
end;

procedure TForm7.Button5Click(Sender: TObject);
begin
form2.Show;
     form7.close;
end;

procedure TForm7.Button6Click(Sender: TObject);
begin
application.Terminate;
end;

procedure TForm7.Button2Click(Sender: TObject);
begin
   query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select sum(应缴费用) as 全校总缴费 from 学生缴费');
query1.SQL.Add('where 缴费=true ');
query1.Prepare;
query1.open;
end;

procedure TForm7.FormClose(Sender: TObject; var Action: TCloseAction);
begin
form2.Show;
     
end;

end.