gsry.~pas

汽车配件管理系统 采用ACCESS数据库 配件销售类公司适用 。 主要是目录树的学习

unit gsry;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, Grids, DBGridEh, dxfColorButton;

type
  Tgsryck = class(TForm)
    dxfColorButton1: TdxfColorButton;
    DBGridEh1: TDBGridEh;
    Table1: TADOTable;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    DBGridEh2: TDBGridEh;
    dxfColorButton2: TdxfColorButton;
    table2: TADOQuery;
    procedure dxfColorButton1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure dxfColorButton2Click(Sender: TObject);
    procedure DBGridEh1DblClick(Sender: TObject);
    procedure table2NewRecord(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  gsryck: Tgsryck;

implementation

{$R *.dfm}

uses main;

procedure Tgsryck.dxfColorButton1Click(Sender: TObject);
begin
table1.UpdateBatch();
end;

procedure Tgsryck.FormCreate(Sender: TObject);
begin
table1.Open;
table2.Open;
end;

procedure Tgsryck.dxfColorButton2Click(Sender: TObject);
begin
table2.UpdateBatch();
end;

procedure Tgsryck.DBGridEh1DblClick(Sender: TObject);
begin
table2.Close;
table2.SQL.Clear;
table2.SQL.Add('select * from gsry where bm=:mc');
table2.Parameters[0].Value:=table1['bm'];
table2.Open;
end;

procedure Tgsryck.table2NewRecord(DataSet: TDataSet);
begin
table2.Edit;
table2['bm']:=table1['bm'];
end;

end.