jiezhangfrm.pas

程序用Delphi6编写

unit JieZhangFrm;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DBCtrls, Mask, ExtCtrls, Grids, DBGridEh, ComCtrls,
  LingXiFrame;

type
  TfrmJz = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    DBGridEh1: TDBGridEh;
    Frame11: TFrame1;
    btnOK: TButton;
    btnCancel: TButton;
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    lblTimeAll: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    DBText1: TDBText;
    DBText2: TDBText;
    Label3: TLabel;
    Label4: TLabel;
    DBEdit1: TDBEdit;
    Label8: TLabel;
    Label9: TLabel;
    lblNetMoney: TLabel;
    lblFjMoney: TLabel;
    lblYsMoney: TLabel;
    DBText3: TDBText;
    DBText4: TDBText;
    Label10: TLabel;
    lblCardMoney: TLabel;
    CheckBox1: TCheckBox;
    ComboBox1: TComboBox;
    Label11: TLabel;
    procedure CheckBox1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    procedure SetLabel;
  end;

var
  frmJz: TfrmJz;

implementation

uses MainDM, DB, ADODB;

{$R *.dfm}

{ TfrmJz }

procedure TfrmJz.SetLabel;
begin

end;

procedure TfrmJz.CheckBox1Click(Sender: TObject);
var
  SQLstr: string;
  ComputerNo: string;
  TheComputerNo: string;
begin
  ComboBox1.Items.Clear;
  TheComputerNo := dmMain.tblMain.FieldByName('机号').AsString;
  SQLstr := 'SELECT 机号 FROM 计费 WHERE 上机时间<>NULL AND 下机时间 IS NULL';
  with dmMain.qryForAll do
  begin
    Close;
    SQL.Clear;
    SQL.Add(SQLstr);
    Open;
    First;
    while not Eof do
    begin
      ComputerNo := Fields[0].AsString;
       if ComputerNo <> TheComputerNo then
        ComboBox1.Items.Add(ComputerNo);
      Next;
    end;
  end;
  ComboBox1.Enabled := not ComboBox1.Enabled;
end;

end.