productprice.pas

从网友处得到的蓝图财务进销存源程序

unit ProductPrice;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, BaseInfo, PrintForm, DB, ADODB, Grids, DBGridEh, ComCtrls,
  ToolWin;

type
  TProductPriceForm = class(TBaseInfoForm)
    QBaseInfoID: TAutoIncField;
    QBaseInfoDSDesigner: TStringField;
    QBaseInfoDSDesigner2: TStringField;
    QBaseInfoDSDesigner3: TFloatField;
    QBaseInfoDSDesigner4: TFloatField;
    QBaseInfoDSDesigner5: TWideStringField;
    procedure tbInsClick(Sender: TObject);
    procedure tbEdiClick(Sender: TObject);
    procedure QBaseInfoBeforePost(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  ProductPriceForm: TProductPriceForm;

implementation

uses SysPublic, ProductPriceEdit, Product;

{$R *.dfm}

procedure TProductPriceForm.tbInsClick(Sender: TObject);
begin
  inherited;
  ShowProductPriceEditForm(QBaseInfo, 'dsInsert');
end;

procedure TProductPriceForm.tbEdiClick(Sender: TObject);
begin
  inherited;
  ShowProductPriceEditForm(QBaseInfo, 'dsEdit');
end;

procedure TProductPriceForm.QBaseInfoBeforePost(DataSet: TDataSet);
var
  S: string;
  ADOQryTmp: TADOQuery;
begin
  inherited;
  S:= QBaseInfo.FieldByName('卡级编号').AsString;
  ADOQryTmp:= TADOQuery.Create(Nil);
  GetConn(ADOQryTmp);
  ADOQryTmp.Close;
  ADOQryTmp.SQL.Clear;
  ADOQryTmp.SQL.Add('Select * From 会员卡级 where 卡级编号=' + QuotedStr(S));
  ADOQryTmp.Open;

  QBaseInfo.FieldByName('卡级名称').AsString := ADOQryTmp.FieldByName('卡级名称').AsString;

  ADOQryTmp.Close;
  ADOQryTmp.Free;
end;

end.