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.