unit8.pas

本系统规模较小,适合小型宿舍,公寓等人员的安排,管理.本系统采用delphi开发界面,使用文件型的数据库Access.,界面亲和力强,容易上手,使用方便.

unit Unit8;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, TFlatSpeedButtonUnit;

type
  Tsskxxcx = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    FlatSpeedButton1: TFlatSpeedButton;
    procedure FormShow(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FlatSpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  sskxxcx: Tsskxxcx;

implementation

{$R *.dfm} uses datamodule, Unit9;

procedure Tsskxxcx.FormShow(Sender: TObject);
begin
label3.Caption:='';
with dm.ADOQuery6 do
  begin
  close;
  sql.Clear;
  sql.Add('select count(a.sslh) as sslhcount from (select distinct sslh from sskxx) as a ');
  open;
  label3.Caption:=dm.ADOQuery6.Fields[0].AsString;
  end;
with dm.ADOQuery6 do
  begin
  close;
  sql.Clear;
  sql.Add('select count(a.ssh) as sshcount from (select distinct ssh from sskxx) as a ');
  open;
  label4.Caption:=dm.ADOQuery6.Fields[0].AsString;
  end;

with dm.ADOQuery6 do
  begin
  close;
  sql.Clear;
  sql.Add('select count(a.xh) as stucount from (select distinct xh from xskxx) as a ');
  open;
  label6.Caption:=dm.ADOQuery6.Fields[0].AsString;
  end;

with dm.ADOQuery6 do
  begin
  close;
  sql.Clear;
  sql.Add('select count(a.xh) as sturzcount from (select distinct xh from zs) as a ');
  open;
  label8.Caption:=dm.ADOQuery6.Fields[0].AsString;
  end;
  sjcx.Close;
end;

procedure Tsskxxcx.FormClose(Sender: TObject; var Action: TCloseAction);
begin
sjcx.Close;
end;

procedure Tsskxxcx.FlatSpeedButton1Click(Sender: TObject);
begin
close;

end;

end.


//此源码由程序太平洋收集整理发布,任何人都可自由转载,但需保留本站信息
//╭⌒╮┅~ ¤　欢迎光临程序太平洋╭⌒╮
//╭⌒╭⌒╮╭⌒╮～╭⌒╮  ︶  ,︶︶
//,︶︶︶︶,''︶~~ ,''~︶︶　 ,''
//╔　╱◥███◣═╬╬╬╬╬╬╬╬╬╗
//╬ ︱田︱田 田 ︱　　　　　　　　　 ╬
//╬　　　　　　　http://www.5ivb.net ╬
//╬　 ╭○╮●　                   　╬
//╬　　/■\/■\　　                  ╬
//╬　　 <|　||　   有希望,就有成功！ ╬
//╬　　　　　　　　　　　　　　　　　╬
//╚╬╬╬╬╬╬╬╬╬╬╗  ╔╬╬╬╬╝
//
//说明：
//专业提供VB、．NET、Delphi、ASP、PB源码下载
//包括:程序源码,控件,商业源码,系统方案，开发工具，书籍教程，技术文档