uvadgpstockmedicine.pas

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

unit UVADGPStockMedicine;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, UMasterAdapterDataGridView, 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,
  UMADPstockmedicine, UCloneDataModel, UPrimaryDataModel, Factory,
  cxDBLookupComboBox, UAdapterDataGridView, UView, MyTools, StdCtrls, Mask,
  RzEdit, RzLabel, RzButton, cxCurrencyEdit, dxPScxGridLnk, ppCtrls, ppVar,
  ppPrnabl, ppClass, ppBands, ppCache, ppDB, ppProd, ppReport, ppComm,
  ppRelatv, ppDBPipe;

type
  TVADGPstockmedicine = class(TAdapterDataGridView)
    GridDBTableViewPSM_PSTOCKMEDICINEID: TcxGridDBColumn;
    GridDBTableViewPSM_SAMOUNT: TcxGridDBColumn;
    GridDBTableViewPSM_AMOUNT: TcxGridDBColumn;
    GridDBTableViewPSM_CREATED: TcxGridDBColumn;
    GridDBTableViewPSM_UPDATED: TcxGridDBColumn;
    GridDBTableViewPSM_MEDICINESTOCKID: 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;
    EditPinYin: TRzEdit;
    RzLabel1: TRzLabel;
    RzButton1: TRzButton;
    GridDBTableViewPSM_PRICE: TcxGridDBColumn;
    RzButton2: TRzButton;
    csPrinter: TdxGridReportLink;
    procedure RzButton1Click(Sender: TObject);
    procedure RzButton2Click(Sender: TObject);
  private
    UnitsIDModel: TCloneDataModel;
  protected
    procedure InitModel; override;
  public
    function GetCaption: string; override;
//    function GetDetailView: TView; override;
    procedure Append(Parameters: IParameters); override;
    procedure Delete(Parameters: IParameters); override;
    procedure Save(Parameters: IParameters); override;
    destructor Destroy; override;
    procedure Print; override;
  end;

implementation

uses UMADMedicineStock, UVADIPStockMedicine, UMADUnits;

{$R *.dfm}

{ TVADGPstockmedicine }

procedure TVADGPstockmedicine.Append(Parameters: IParameters);
begin
//
end;

procedure TVADGPstockmedicine.Delete(Parameters: IParameters);
begin
//
end;

function TVADGPstockmedicine.GetCaption: string;
begin
  Result := '药房库存';
end;

{
function TVADGPstockmedicine.GetDetailView: TView;
var
  View : TVADIPStockMedicine;
begin
{
  View := TVADIPStockMedicine.Create(Self, GetModelFactory);
  View.SetModel(GetModel);
  Result := View;
end;
}

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

procedure TVADGPstockmedicine.Save(Parameters: IParameters);
begin
  inherited;
end;

procedure TVADGPstockmedicine.RzButton1Click(Sender: TObject);
begin
  inherited;
  EditPinYin.Text := Trim(UpperCase(EditPinYin.Text));
  GetDataModel.GetDataSet.First;
  GetDataModel.GetDataSet.Locate('M_PinYin', EditPinYin.Text, [loPartialKey]);
end;

procedure TVADGPstockmedicine.RzButton2Click(Sender: TObject);
begin
  inherited;
  EditPinYin.Text := Trim(UpperCase(EditPinYin.Text));
  GetDataModel.GetDataSet.Filtered := True;
  GetDataModel.GetDataSet.Filter := 'M_PinYin LIKE ''' + EditPinYin.Text + '%''';
end;

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

procedure TVADGPstockmedicine.Print;
begin
  csPrinter.Preview(True);
end;

end.