userm.pas

delphi开发的电力调度系统并带有access数据库。完成动态添加

unit USERM;

interface

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

type
  TFrm_USERM = class(TForm)
    DBGrid: TDBGrid;
    DataSource: TDataSource;
    DBNavigator1: TDBNavigator;
    ADOTable: TADOTable;
    Label2: TLabel;
    DBGrid_UserType: TDBGrid;
    ADOTable_UserType: TADOTable;
    DataSource_UserType: TDataSource;
    ADOQuery: TADOQuery;
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  
  public
    { Public declarations }
  end;

var
  Frm_USERM: TFrm_USERM;

implementation
  uses Filters;
{$R *.dfm}


procedure TFrm_USERM.FormCreate(Sender: TObject);
var
  SFilters:TFilters;
begin
  ADOQuery.Connection:=Frm_Com.ADOConnection;
  
  ADOQuery.SQL.Text:='Select * from UserType order by UserType';
  ADOQuery.Open;
  ADOQuery.First;
  DBGRid.Columns[2].PickList.Clear;
  while not ADOQuery.Eof do
  begin
    DBGRid.Columns[2].PickList.ADD(ADOQuery.FieldByName('UserType').AsString);
    ADOQuery.Next;
  end;


  ADOTable.Connection:=Frm_Com.ADOConnection;
  ADOTable.TableName:='LogonUser';
  ADOTable.Active:=true;
  ADOTable.Filtered:=true;
  ADOTable.Sort:='UserNum';
  ADOTable.First;

  ADOTable_UserType.Connection:=Frm_Com.ADOConnection;
  ADOTable_UserType.TableName:='UserType';
  ADOTable_UserType.Active:=True;
  ADOTable_UserType.Sort:='UserType';
  ADOTable_UserType.First;

  SFilters:=TFilters.Create(ADOTable,DBGrid,DBNavigator1.Top+DBNavigator1.Height+10);
  SFilters.AddEdit;
  Self.Height:=DBGrid.Top+DBGrid.Height+50;


  Self.DBGrid_UserType.Top:=DBGrid.Top;
  Self.Label2.Top:=DBGrid.Top-Self.Label2.Height-10;
  
end;

end.