gy_addppdm.pas

省级集邮品管理ERP

{*******************************************************}
{                                                       }
{                     选择票品                          }
{                                                       }
{            中软金马公司版权所有。2002.12前            }
{                                                       }
{            编制：中软金马邮资票品项目开发组           }
{                                                       }
{                                                       }
{*******************************************************}
(*
省级集邮票管理  ，地市集邮票

*)
unit GY_ADDPPDM;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Buttons, ExtCtrls, Mask, ToolEdit, CurrEdit, Grids, DBGrids,
  Db, DBTables, Spin;

type
  TFrmY_ADDPPDM1 = class(TForm)
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Qry_PPDM: TQuery;
    DataSource1: TDataSource;
    Label3: TLabel;
    ND: TSpinEdit;
    DBG_YZPPTXXB: TDBGrid;
    Qry_PPDMTDM: TStringField;
    Qry_PPDMZH: TStringField;
    Qry_PPDMTPMS: TFloatField;
    Qry_PPDMTPMZ: TFloatField;
    Qry_PPDMTPSJ: TFloatField;
    Qry_PPDMTMC: TStringField;
    Qry_PPDMFXRQ: TDateTimeField;
    Qry_PPDMJHH: TStringField;
    Qry_PPDMMC: TStringField;
    procedure FormCreate(Sender: TObject);
    procedure NDChange(Sender: TObject);
    procedure Qry_PPDMTPMZGetText(Sender: TField; var Text: String;
      DisplayText: Boolean);
  private
    { Private declarations }                           
  public
    { Public declarations }
  end;

var
  FrmY_ADDPPDM1: TFrmY_ADDPPDM1;

implementation
uses
  pub;

{$R *.DFM}

procedure TFrmY_ADDPPDM1.FormCreate(Sender: TObject);
begin
  ND.Value := VG_Year;
end;

procedure TFrmY_ADDPPDM1.NDChange(Sender: TObject);
begin
  with Qry_PPDM do
  begin
    Close;
    SQL.Clear ;
    SQL.Add ('Select A.TDM,A.TJC TMC,A.ZH,A.TPMS,A.TPSJ,A.TPMZ,A.FXRQ,A.JHH,B.MC from TB_YZPPTXXB A,TG_YZPPLDMB B');
    SQL.Add ('where A.ND='''+IntToStr(ND.Value)+''' and A.PPLB=B.YZLDM');
    SQL.Add('and  ((A.PPLB like ''1%'' and A.PPLB <> ''101'') or (A.PPLB like ''8%'') or (A.PPLB like ''9%'')) ');
    SQL.Add ('order by A.TDM  ');
    Open;
  end;
  DBG_YZPPTXXB.SelectedRows.CurrentRowSelected := True;
end;

procedure TFrmY_ADDPPDM1.Qry_PPDMTPMZGetText(Sender: TField;
  var Text: String; DisplayText: Boolean);
begin
  if Sender.IsNull then Exit;
  Text := FloatToStr(Sender.AsFloat/100);
end;

end.