dzczzhm.pas

用delphi开发的电力调度操作票系统并带有access数据库

unit DZCZZHM;

interface

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

type
  TFrm_DZCZZHM = class(TForm)
    DBGrid: TDBGrid;
    ADOQuery: TADOQuery;
    DataSource: TDataSource;
    DBNavigator1: TDBNavigator;
    Label1: TLabel;
    DBGrid_CZXH: TDBGrid;
    DataSource_CZXH: TDataSource;
    ADOTable_CZXH: TADOTable;
    ADOTable_KGLX: TADOTable;
    DataSource_KGLX: TDataSource;
    DBGrid_KGLX: TDBGrid;
    Label2: TLabel;
    ADOTable: TADOTable;
    Label3: TLabel;
    ListBox1: TListBox;
    ListBox2: TListBox;
    procedure FormCreate(Sender: TObject);
    procedure DBGridCellClick(Column: TColumn);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_DZCZZHM: TFrm_DZCZZHM;

implementation
   uses Filters;
{$R *.dfm}

procedure TFrm_DZCZZHM.FormCreate(Sender: TObject);
var
  SFilters:TFilters;
begin
  ADOQuery.Connection:=Frm_Com.ADOConnection;

  ADOQuery.SQL.Text:='Select 操作编号 from CZXH order by 操作编号';
  ADOQuery.Open;
  ADOQuery.First;
  DBGRid.Columns[0].PickList.Clear;
  while not ADOQuery.Eof do
  begin
    DBGRid.Columns[0].PickList.ADD(ADOQuery.FieldByName('操作编号').AsString);
    ADOQuery.Next;
  end;

  ADOTable_CZXH.Connection:=Frm_Com.ADOConnection;
  ADOTable_CZXH.TableName:='CZXH';
  ADOTable_CZXH.Active:=true;
  

  ADOTable_KGLX.Connection:=Frm_Com.ADOConnection;
  ADOTable_KGLX.TableName:='KGLX';
  ADOTable_KGLX.Active:=True;
  ADOTable_KGLX.Sort:='类型编号';

  ADOTable.Connection:=Frm_Com.ADOConnection;
  ADOTable.TableName:='DZCZZH';
  ADOTable.Active:=true;
  ADOTable.Filtered:=true;

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

  Self.DBGrid_CZXH.Top:=DBGrid.Top;
  Self.DBGrid_KGLX.Top:=DBGrid.Top;
  Self.Label1.Top:=DBGrid.Top-Self.Label1.Height-10;
  Self.Label2.Top:=DBGrid.Top-Self.Label2.Height-10;

  Label3.Top:=DBGrid_kGLX.Top+DBGrid_kGLX.Height+10;
  ListBox1.Top:=Label3.Top+Label3.Height+10;
  ListBox2.Top:=ListBox1.Top;

end;

procedure TFrm_DZCZZHM.DBGridCellClick(Column: TColumn);
begin
  DBGrid.Columns[2].PickList.Clear;
  if ADOTable.FieldByName('表类型').AsString='KG' then
  begin
     ADOTable_KGLX.Active:=False;
     ADOTable_KGLX.TableName:='KGLX';
     ADOTable_KGLX.Active:=True;
     ADOTable_KGLX.First;
     while not ADOTable_KGLX.Eof do
     begin
       DBGrid.Columns[2].PickList.Add(ADOTable_KGLX.FieldByName('类型编号').AsString);
       ADOTable_KGLX.Next;
     end;
  end
  else if ADOTable.FieldByName('表类型').AsString='XLKG' then
  begin
     ADOTable_KGLX.Active:=False;
     ADOTable_KGLX.TableName:='XLKGLX';
     ADOTable_KGLX.Active:=True;
     ADOTable_KGLX.First;
     while not ADOTable_KGLX.Eof do
     begin
       DBGrid.Columns[2].PickList.Add(ADOTable_KGLX.FieldByName('类型编号').AsString);
       ADOTable_KGLX.Next;
     end;
  end
  else ADOTable_KGLX.Active:=False;
end;

end.