unit3.pas

电费管理系统,DELPHI课程设计,需要重新连接数据库

unit Unit3;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Grids, DBGrids, DB, ADODB, Mask, DBCtrls, ExtCtrls;

type
  TForm3 = class(TForm)
    Image1: TImage;
    Label1: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label2: TLabel;
    DBGrid1: TDBGrid;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    ADOQuery1: TADOQuery;
    ADOConnection1: TADOConnection;
    DataSource1: TDataSource;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit7: TDBEdit;
    Edit1: TEdit;
    Label9: TLabel;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Button6: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Edit2Exit(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;

implementation

uses Unit1, Unit2;

{$R *.dfm}

procedure TForm3.Button1Click(Sender: TObject);
begin
adoquery1.Active:=false;
adoquery1.SQL.Clear;
dbedit5.DataField:='上月节转';
dbedit7.DataField:='本月节余';
adoquery1.SQL.Add('select * from 用电收费 where 帐户='+''''+edit1.Text+'''');
adoquery1.Active:=true;
adoquery1.Last;
end;

procedure TForm3.Button2Click(Sender: TObject);
begin
adoquery1.Active:=false;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from 用电收费 where 帐户='+''''+edit1.Text+'''');
adoquery1.Active:=true;
adoquery1.Last;
adoquery1.Edit;
adoquery1.Fields[7].Value:=1.5*strtoint(edit2.Text)+strtoint(adoquery1.Fields[7].AsString);
adoquery1.Fields[9].Value:=strtoint(edit2.Text);
adoquery1.Fields[8].Value:=edit3.Text;
adoquery1.Fields[10].Value:=edit4.Text;
adoquery1.Post;
adoquery1.Append;
edit2.Clear;
button2.Enabled:=false;

end;

procedure TForm3.Button3Click(Sender: TObject);
begin
form1.show;
close;
end;

procedure TForm3.Button6Click(Sender: TObject);
begin
adoquery1.Active:=false;
adoquery1.SQL.Clear;
dbedit5.DataField:='';
dbedit7.DataField:='';
adoquery1.SQL.Add('select * from 基本资料 where 帐户='+''''+edit1.Text+'''');
adoquery1.Active:=true;
end;

procedure TForm3.Button4Click(Sender: TObject);
begin
adoquery1.Active:=false;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from 用电收费 where 本月节余<10');
adoquery1.Active:=true;
button5.Enabled:=true;
end;

procedure TForm3.Edit2Exit(Sender: TObject);
begin
 button2.Enabled:=true;
end;

procedure TForm3.Button7Click(Sender: TObject);
begin
adoquery1.Append;
end;

procedure TForm3.Button5Click(Sender: TObject);
begin
while (adoquery1.Eof<>true) do
begin
form1.memo1.Lines.Add(form2.ComboBox1.Text+'：');
form1.memo1.Lines.Add(inttostr(adoquery1.Fields[2].Value)+'宿舍 '+inttostr(adoquery1.Fields[3].Value)+'寝室 剩余电量已不足'+inttostr(adoquery1.Fields[7].Value));
form1.Memo1.Lines.Add('请及时购电，为此造成的不便向您致歉');
form3.ADOQuery1.Next;
end;
button5.Enabled:=false;
form1.memo1.Lines.SaveToFile('D:\我的文档\My Delphi Files\电费管理系统\新建文件夹\001.txt');
form1.Show;
end;
end.