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, cxCurrencyEdit;

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;
    RzLabel2: TRzLabel;
    EditCaption: TRzEdit;
    RzButton2: TRzButton;
    RzButton3: TRzButton;
    RzButton4: TRzButton;
    procedure RzButton1Click(Sender: TObject);
    procedure RzButton2Click(Sender: TObject);
    procedure RzButton3Click(Sender: TObject);
    procedure RzButton4Click(Sender: TObject);
  private
    UnitsIDModel : TCloneDataModel;
  protected
     procedure InitModel; override;
  public
    function GetCaption: string; override;
    destructor Destroy; override;
  end;

implementation

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

{ TVADGVPStockMedicine }

destructor TVADGVPStockMedicine.Destroy;
begin
  GetDataModel.GetDataSet.Filtered := False;
  inherited;
end;

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;

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

procedure TVADGVPStockMedicine.RzButton3Click(Sender: TObject);
begin
  inherited;
  EditPinYin.Text := UpperCase(Trim(EditPinYin.Text));
  if EditPinYin.Text = '' then
    GetDataModel.GetDataSet.Filtered := False;
  GetDataModel.GetDataSet.Filtered := True;
  GetDataModel.GetDataSet.Filter := 'M_PinYin LIKE ''' + EditPinYin.Text + '%''';
end;

procedure TVADGVPStockMedicine.RzButton4Click(Sender: TObject);
begin
  inherited;
  EditCaption.Text := Trim(EditCaption.Text);
  if EditCaption.Text = '' then
    GetDataModel.GetDataSet.Filtered := False;
  GetDataModel.GetDataSet.Filtered := True;
  GetDataModel.GetDataSet.Filter := 'M_CAPTION LIKE ''' + EditCaption.Text + '%''';
end;

end.