testwin.pas

电力行业前台收费程序,需要有后台SQL数据库,和电费管理系统配合应用.

unit TestWin;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Grids, DBGrids, Db;

type
  TFormTest = class(TForm)
    DBGridTest: TDBGrid;
    DataSourceTest: TDataSource;
    procedure FormDeactivate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
    procedure DBGridTestMouseDown(Sender: TObject; Button: TMouseButton;
      Shift: TShiftState; X, Y: Integer);
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

implementation

uses DataMod;

{$R *.DFM}

procedure TFormTest.FormDeactivate(Sender: TObject);
begin
  Close;
end;

procedure TFormTest.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action:=caFree;
end;

procedure TFormTest.FormShow(Sender: TObject);
var
  I:Integer;
  CanShow:Boolean;
begin
  CanShow:=True;
  with DataMD.QueryPublic do
  for I:=0 to FieldCount-1 do begin
    case Fields[I].DataType of
      ftString:Fields[I].DisplayWidth:=25;
      ftDate,ftDateTime:
        begin
          TDateTimeField(Fields[I]).DisplayFormat:='yyyy-mm-dd';
          Fields[I].DisplayWidth:=15;
        end;
      else
        Fields[I].DisplayWidth:=15;
    end;
    if UpperCase(Fields[I].FieldName)='HIDE' then
      CanShow:=False;
    if Copy(Fields[I].FieldName,1,1)='#' then
      if Copy(Fields[I].FieldName,Length(Fields[I].FieldName),1)='#' then
        Fields[I].DisplayLabel:=Copy(Fields[I].FieldName,2,Length(Fields[I].FieldName)-2);
    Fields[I].Visible:=CanShow;
  end;
end;

procedure TFormTest.DBGridTestMouseDown(Sender: TObject;
  Button: TMouseButton; Shift: TShiftState; X, Y: Integer);
begin
  Close;
end;

procedure TFormTest.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=VK_ESCAPE then
    Close;
end;

end.