{*******************************************************}
{                                                       }
{                省級單去向多品種分配                   }
{                                                       }
{            中軟金馬公司版權所有。2002.12              }
{                                                       }
{                    編制：楊俊                         }
{                                                       }
{                                                       }
{*******************************************************}
(*
   省級集郵管理

   思路步驟：

   選擇該單沒有選擇的票品
*)

unit CKJH_JJW_AddPP2;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Grids, DBGrids, StdCtrls, Buttons, RXCtrls, Spin, Db, DBTables;

type
  TFrm_CKJH_JJW_AddPP2 = class(TForm)
    sp_ND: TSpinEdit;
    Label1: TLabel;
    bbtn_OK: TBitBtn;
    bbtn_Cancel: TBitBtn;
    dbg_PP: TDBGrid;
    qry_SelPP: TQuery;
    DataSource1: TDataSource;
    qry_SelPPKFDM: TStringField;
    qry_SelPPKFMC: TStringField;
    qry_SelPPPPDM: TStringField;
    qry_SelPPPPMC: TStringField;
    qry_SelPPZH: TStringField;
    qry_SelPPMZ: TFloatField;
    qry_SelPPSJ: TFloatField;
    qry_SelPPKWH: TStringField;
    qry_SelPPPPLB: TStringField;
    qry_SelPPJJ: TFloatField;
    qry_SelPPXJ: TFloatField;
    qry_SelPPJSJ: TFloatField;
    qry_SelPPZK: TFloatField;
    qry_SelPPSL: TFloatField;
    procedure sp_NDChange(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure qry_SelPPJJGetText(Sender: TField; var Text: String;
      DisplayText: Boolean);
    procedure bbtn_OKClick(Sender: TObject);
    procedure qry_SelPPSLGetText(Sender: TField; var Text: String;
      DisplayText: Boolean);
  private
    { Private declarations }
  public
    { Public declarations }
    procedure Set_TJ(a_TJ: TStrings);                       {已經被選擇的票品的票品代碼}
  end;

var
  Frm_CKJH_JJW_AddPP2: TFrm_CKJH_JJW_AddPP2;

implementation

uses
  Datas, pub;

{$R *.DFM}

var
  VL_KFPP: String;

  { TFrm_CKJH_JJW_AddPP2 }

{-------------------------------------------------------------------------------}
{默認為當前的年度}
procedure TFrm_CKJH_JJW_AddPP2.FormShow(Sender: TObject);
begin
  sp_ND.Text := FormatDateTime('YYYY', GetSysDate);
end;

{-------------------------------------------------------------------------------}
{傳入已經選擇的票品}
procedure TFrm_CKJH_JJW_AddPP2.Set_TJ(a_TJ: TStrings);
var
  i: Integer;
  l_HaveSel: String;
begin
  VL_KFPP := 'Select KFDM, PPDM, JJ, KWH, YJ, XJ, JSJ, ZK, TS, BZ from TYS_JYPPKC ';
  l_HaveSel := 'Select KFDM, PPDM, JJ, KWH, YJ, XJ, JSJ, ZK, TS, BZ from TYS_JYPPKC where 1>2';
  for i := 0 to a_TJ.Count - 1 do
    l_HaveSel := l_HaveSel + ' or (' + a_TJ[i] + ' ) ';
  VL_KFPP := VL_KFPP + ' minus ' + l_HaveSel;
end;

{-------------------------------------------------------------------------------}
{根據年度的改變，選擇票品}
procedure TFrm_CKJH_JJW_AddPP2.sp_NDChange(Sender: TObject);
var
  l_SQL: String;
begin
  l_sql :=
    'Select a.KFDM, d.KFMC, a.PPDM , b.TMC PPMC, b.ZH, b.TPMZ MZ, b.TPSJ SJ, a.KWH, b.PPLB,a.JJ, a.XJ, a.JSJ, a.ZK, a.TS SL '#13#10 +
    ' from ('+VL_KFPP+') a, TB_YZPPTXXB b, TGS_KFRYDZB c, TGS_KFB d '#13#10 +
    ' where a.PPDM = b.TDM  and d.KFDM = a.KFDM  and c.KFDM = d.KFDM '#13#10 +
    ' and a.TS>0 and c.YGDM =' + QuotedStr(VG_UserID) + ' and b.ND = ' + QuotedStr(sp_ND.Text);
  with qry_SelPP do
  begin
    Close;
    SQL.Text := l_SQL;
    Open;
  end;
end;


procedure TFrm_CKJH_JJW_AddPP2.qry_SelPPJJGetText(Sender: TField;
  var Text: String; DisplayText: Boolean);
begin
  if Trim(Sender.AsString) = '' then
    Exit;

  try
    if Sender.AsInteger <> 0 then
      Text := FormatFloat('￥#,##0.000', Sender.AsFloat / 100);
  except

  end;

end;

procedure TFrm_CKJH_JJW_AddPP2.bbtn_OKClick(Sender: TObject);
begin
  if dbg_PP.SelectedRows.Count = 0 then
    dbg_PP.SelectedRows.CurrentRowSelected := True;
end;

procedure TFrm_CKJH_JJW_AddPP2.qry_SelPPSLGetText(Sender: TField;
  var Text: String; DisplayText: Boolean);
begin
  if Trim(Sender.AsString) = '' then
    Exit;

  try
    if Sender.AsInteger <> 0 then
      Text := FormatFloat('#,##0', Sender.AsFloat);
  except

  end;

end;

end.