unttinaccessory.pas

销售软件

(*===========================================================*)
(*                                                           *)
(*              Jerk Computer Assembly Manager               *)
(*                                                           *)
(*                    程序作者：杨芹勍                       *)
(*          武汉科技大学 理学院 信息与计算科学031班          *)
(*                  武汉科技大学 莘特工作室                  *)
(*                                                           *)
(*              IDE：Borland Delphi 2006 Update 2            *)
(*                 第三方控件：Raize 4.03                    *)
(*             数据库：Microsoft SQL Server 2000             *)
(*            数据库访问引擎：原生ADO（ADODB_TLB）           *)
(*           数据库管理引擎：JERK DBMANAGER ALPHA            *)
(*                                                           *)
(*           此软件及源代码归 JERK SYSTEM 版权所有           *)
(*            (C)Copyright 2002-2006 Jerk System.            *)
(*                                                           *)
(*===========================================================*)

unit untTInAccessory;

interface

uses
  SysUtils,
  Variants,
  ADODB_TLB,
  JCAMTableView;

const
  TN_INACCESSORY: string = 't_InAccessory';
  VN_INACCESSORY: string = 'v_InAccessory';
  KFN_INACCESSORY: string = 'InAccessory_ID';
  FN_INACCESSORYNAME: string = 'InAccessory_Name';
  PN_SAVEINACCESSORYINFO: string = 'sp_SaveInAccessoryInfo';
  PN_DELETEINACCESSORYINFO: string = 'sp_DeleteInAccessoryInfo';

type
  TTableInAccessory = class( TCustomTableView )
  private
    m_rsInAccessory: _Recordset;
    m_nInAccessoryID: Integer;
    m_sInAccessoryName: string;
    procedure SetInAccessoryID( const Value: Integer );
    procedure SetInAccessoryName( const Value: string );
  protected
    procedure GetAllFieldsValue; override;
  public
    constructor Create; override;
    destructor Destroy; override;
    property Connection;
    property InAccessoryID: Integer
      read m_nInAccessoryID
      write SetInAccessoryID
      default -1;
    property InAccessoryName: string
      read m_sInAccessoryName
      write SetInAccessoryName;
  end;

implementation

{ TTableInAccessory }

constructor TTableInAccessory.Create;
begin
  inherited;

  m_rsInAccessory := CoRecordset.Create;
end;

destructor TTableInAccessory.Destroy;
begin
  m_rsInAccessory := nil;

  inherited;
end;

procedure TTableInAccessory.GetAllFieldsValue;
begin
  inherited;

  if m_rsInAccessory.EOF then
  begin
    m_nInAccessoryID := -1;
    m_sInAccessoryName := EmptyStr;
  end
  else
  begin
    m_nInAccessoryID := Integer( m_rsInAccessory.Fields[ 'InAccessory_ID'
      ].Value );
    m_sInAccessoryName := VarToStr( m_rsInAccessory.Fields[ 'InAccessory_Name'
      ].Value );
  end;
end;

procedure TTableInAccessory.SetInAccessoryID( const Value: Integer );
begin
  if m_rsInAccessory.State <> adStateClosed then
    m_rsInAccessory.Close;
  m_rsInAccessory.Open( 'SELECT * FROM [' + TN_INACCESSORY +
    '] WHERE [InAccessory_ID]=' + IntToStr( Value ),
    Connection, adOpenForwardOnly, adLockReadOnly, adCmdText );
  GetAllFieldsValue;
end;

procedure TTableInAccessory.SetInAccessoryName( const Value: string );
begin
  if m_rsInAccessory.State <> adStateClosed then
    m_rsInAccessory.Close;
  m_rsInAccessory.Open( 'SELECT * FROM [' + TN_INACCESSORY +
    '] WHERE [InAccessory_Name]=''' + Value + '''',
    Connection, adOpenForwardOnly, adLockReadOnly, adCmdText );
  GetAllFieldsValue;
end;

end.