unit PPartsCode;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Db, ADODB, ExtCtrls, DBCtrls, Grids, DBGrids, ComCtrls;

type
  TFormPartsCode = class(TForm)
    StatusBarProductCode: TStatusBar;
    DBGridUsers: TDBGrid;
    DBNavigatorProductCode: TDBNavigator;
    DataSourceUsers: TDataSource;
    ADOTableUsers: TADOTable;
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FormPartsCode: TFormPartsCode;

implementation

uses PDataModuleMain;

{$R *.DFM}

procedure TFormPartsCode.FormCreate(Sender: TObject);
begin
    AdoTableUsers.Connection:=DataModuleMain.ADOConnectionBarCode;
    AdoTableUsers.TableName:='PartsCode';
    AdoTableUsers.Open;

    DbgridUsers.Columns.Items[0].Title.Caption:='編碼';
    DbgridUsers.Columns.Items[1].Title.Caption:='說明';
    StatusBarProductCode.SimpleText:='總數:'+IntToStr(AdoTableUsers.RecordCount);
end;

end.