uvadgvpstockmedicine.pas

Software Requirements1. Delphi 6 SP22. Oracle 8i R33. Raize 3.0.94. ExpressQuantumGrid 4.505. Expres

unit UVADGVPStockMedicine;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, UAdapterDataGridView, cxStyles, cxCustomData, cxGraphics,
  cxFilter, cxData, cxDataStorage, cxEdit, DB, cxDBData, dxPSGlbl, dxPSUtl,
  dxPSEngn, dxPrnPg, dxBkgnd, dxWrap, dxPrnDev, dxPSCompsProvider,
  dxPSFillPatterns, dxPSEdgePatterns, dxPSCore, RzCommon, cxGridLevel,
  cxClasses, cxControls, cxGridCustomView, cxGridCustomTableView,
  cxGridTableView, cxGridDBTableView, cxGrid, jpeg, RzBckgnd, ExtCtrls,
  RzPanel, UCloneDataModel, Factory, UPrimaryDataModel, cxDBLookupComboBox,
  StdCtrls, RzLabel, Mask, RzEdit, RzButton;

type
  TVADGVPStockMedicine = class(TAdapterDataGridView)
    GridDBTableViewPSM_PSTOCKMEDICINEID: TcxGridDBColumn;
    GridDBTableViewPSM_SAMOUNT: TcxGridDBColumn;
    GridDBTableViewPSM_AMOUNT: TcxGridDBColumn;
    GridDBTableViewPSM_CREATED: TcxGridDBColumn;
    GridDBTableViewPSM_UPDATED: TcxGridDBColumn;
    GridDBTableViewPSM_MEDICINESTOCKID: TcxGridDBColumn;
    GridDBTableViewPSM_PRICE: TcxGridDBColumn;
    GridDBTableViewMS_MEDICINESTOCKID: TcxGridDBColumn;
    GridDBTableViewMS_CREATED: TcxGridDBColumn;
    GridDBTableViewMS_UPDATED: TcxGridDBColumn;
    GridDBTableViewMS_AMOUNT: TcxGridDBColumn;
    GridDBTableViewMS_MEDICINEID: TcxGridDBColumn;
    GridDBTableViewM_MEDICINEID: TcxGridDBColumn;
    GridDBTableViewM_CODE: TcxGridDBColumn;
    GridDBTableViewM_TOPQTY: TcxGridDBColumn;
    GridDBTableViewM_DOWNQTY: TcxGridDBColumn;
    GridDBTableViewM_MEMO: TcxGridDBColumn;
    GridDBTableViewM_ALAIS: TcxGridDBColumn;
    GridDBTableViewM_MODEL: TcxGridDBColumn;
    GridDBTableViewM_PINYIN: TcxGridDBColumn;
    GridDBTableViewM_CAPTION: TcxGridDBColumn;
    GridDBTableViewM_DOSEID: TcxGridDBColumn;
    GridDBTableViewM_UNITSID: TcxGridDBColumn;
    GridDBTableViewM_USEMETHODID: TcxGridDBColumn;
    GridDBTableViewM_MEDICINECATALOGID: TcxGridDBColumn;
    GridDBTableViewM_MINUNITSID: TcxGridDBColumn;
    GridDBTableViewM_PACKAMOUNT: TcxGridDBColumn;
    GridDBTableViewMINAMOUNT: TcxGridDBColumn;
    RzPanel3: TRzPanel;
    UnitsID: TDataSource;
    RzLabel1: TRzLabel;
    EditPinYin: TRzEdit;
    RzButton1: TRzButton;
    procedure RzButton1Click(Sender: TObject);
  private
    UnitsIDModel : TCloneDataModel;
  protected
     procedure InitModel; override;
  public
    function GetCaption: string; override;
  end;

implementation

uses
  UMADVPStockMedicine, UMADMedicine, UDataView, UMADUnits;
  
{$R *.dfm}

{ TVADGVPStockMedicine }

function TVADGVPStockMedicine.GetCaption: string;
begin
  Result := '药房药品库存信息';
end;

procedure TVADGVPStockMedicine.InitModel;
begin
  inherited;
  UnitsIDModel := GetCloneDataModel(TPrimaryDataModel(UnitsFactory.GetModel));
  UnitsID.DataSet := UnitsIDModel.GetDataSet;
end;

procedure TVADGVPStockMedicine.RzButton1Click(Sender: TObject);
begin
  inherited;
  EditPinYin.Text := UpperCase(Trim(EditPinYin.Text));
  if EditPinYin.Text = '' then Exit;
  GetDataModel.GetDataSet.First;
  if not GetDataModel.GetDataSet.Locate('M_PINYIN', EditPinYin.Text, [loPartialKey]) then
    ShowMessage('没有找到');
end;

end.