unit3.pas

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

unit Unit3;

interface

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

type
  TForm3 = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    Label5: TLabel;
    Edit5: TEdit;
    Label6: TLabel;
    Edit6: TEdit;
    Button1: TButton;
    GroupBox2: TGroupBox;
    Label7: TLabel;
    Label9: TLabel;
    Edit7: TEdit;
    Edit8: TEdit;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    DataSource1: TDataSource;
    Query1: TQuery;
    Label10: TLabel;
    Edit9: TEdit;
    Edit10: TEdit;
    Label11: TLabel;
    Label12: TLabel;
    Label8: TLabel;
    Memo1: TMemo;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Edit6Enter(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;

implementation
uses unit2;
{$R *.dfm}

procedure TForm3.Button1Click(Sender: TObject);
begin
button2.Enabled:=true;
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.SQL.Add('where  学生编号='''+edit6.text+'''');
query1.Prepare;
query1.open;
if query1.RecordCount>0 then
      begin
  edit1.Text:=query1['学生姓名'];
  edit2.Text:=query1['年级'];
  edit3.Text:=query1['班级'];
  edit4.Text:=query1['学年年度'];
  edit5.Text:=query1['应缴费用'];
  edit9.Text:=query1['缴费'];
       end
   else
   begin
   button2.Enabled:=false;
   edit1.Text:='';
   edit2.Text:='';
   edit3.Text:='';
   edit4.Text:='';
   edit5.Text:='';
   edit9.Text:='';
   showmessage('输入有误！！！');


  end;
   if query1['缴费']=true then
     begin
      button2.Enabled:=false;
     showmessage('已缴费');
     end


  end;

procedure TForm3.Button2Click(Sender: TObject);
var shi,yin:integer;
begin

if edit7.Text<>'' then
begin
 if strtoint(edit7.Text)>strtoint(edit5.Text)  then
    begin
 shi:=strtoint(edit7.Text);
 yin:=strtoint(edit5.Text);
 edit8.Text:=inttostr(shi-yin);
 query1.Close;
query1.SQL.Clear;
query1.SQL.Add('update 学生缴费');
query1.SQL.Add('set 缴费=true,实缴费找零='''+edit8.text+''',缴费日期='''+edit10.Text+''',经手人备注='''+memo1.Lines[0]+memo1.lines[1]+'''');
query1.SQL.add('where 学生编号='''+edit6.text+'''');
query1.ExecSQL;

query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.SQL.Add('where  学生编号='''+edit6.text+'''');
query1.Prepare;
query1.open;
edit9.Text:=query1['缴费'];
  end
  end
  else
  showmessage('输入有误！！！');
  end;

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

procedure TForm3.Edit6Enter(Sender: TObject);
begin
    query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.SQL.Add('where  学生编号='''+edit6.text+'''');
query1.Prepare;
query1.open;
if query1.RecordCount>0 then
  begin
  edit1.Text:=query1['学生姓名'];
  edit2.Text:=query1['年级'];
  edit3.Text:=query1['班级'];
  edit4.Text:=query1['学年年度'];
  edit5.Text:=query1['应缴费用'];
  end
  end;

procedure TForm3.Button4Click(Sender: TObject);
begin
form2.Show;
     form3.close;
end;

procedure TForm3.Button3Click(Sender: TObject);
begin
application.Terminate;
end;

procedure TForm3.FormCreate(Sender: TObject);
begin
        button2.Enabled:=false;
        edit10.Text:=datetostr(now);
end;

end.