rkd_cx_search.pas

省级集邮品管理ERP

{*******************************************************}
{                                                       }
{            集邮入库单查询条件                         }
{                                                       }
{            中软金马公司版权所有。2002.12前            }
{                                                       }
{            编制：中软金马邮资票品项目开发组           }
{                                                       }
{                                                       }
{*******************************************************}
(*
省级集邮品，省级市场购入票，省级集邮票管理，省级库房管理
地市集邮品，地市市场购入票，地市集邮票管理

*)

unit RKD_CX_Search;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  FormBase, StdCtrls, Buttons, Mask, ToolEdit, ExtCtrls, FieldComboBox, SQlStrings,
  CurrEdit, RXDBCtrl;

type
  TFrm_RKD_CX_Search = class(TFFormBase)
    Label1: TLabel;
    cmbCkxz: TFieldComboBox;
    cmbQXDW: TFieldComboBox;
    Label4: TLabel;
    Label5: TLabel;
    rdFHZT: TRadioGroup;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    editFHDH: TEdit;
    Panel2: TPanel;
    Label6: TLabel;
    db1: TRxCalcEdit;
    GroupBox1: TGroupBox;
    d1: TDateEdit;
    d2: TDateEdit;
    Label7: TLabel;
    Label8: TLabel;
    procedure FormCreate(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
    io_Type: TIO_TYPE;
    s: string;
  public
    { Public declarations }
  end;

function Show_FHDCXTJ(var str: string; io_typ: TIO_TYPE): Boolean;
var
  Frm_RKD_CX_Search: TFrm_RKD_CX_Search;

implementation

uses datas, Pub;
{$R *.DFM}

function Show_FHDCXTJ(var str: string; io_typ: TIO_TYPE): Boolean;
begin
  if Frm_RKD_CX_Search = nil then
    Application.CreateForm(TFrm_RKD_CX_Search, Frm_RKD_CX_Search);
  with Frm_RKD_CX_Search do
  begin
    io_Type := io_typ;
    s := '';
    if io_typ = io_txp then
      GroupBox1.Visible := True
    else
      panel2.Visible := False;
    db1.Value := 0;
    result := ShowModal = MB_OK;
    str := s;
  end;
end;                                       

procedure TFrm_RKD_CX_Search.FormCreate(Sender: TObject);
const
  CKXZSQL = 'SELECT RCKXZMC, RCKXZDM FROM TGS_JRCKXZDM WHERE TO_NUMBER(RCKXZDM) >= 20';
var
  year, month, day: Word;
//  rq: TDateTime;
begin
  inherited;
  DecodeDate(GetSysDate, year, month, day);
  d1.Date := strToDate(Format('%u-%u-01', [year, month]));
  d2.DateTime := GetSysDate;
  initList(cmbCkxz.Items, CKXZSQL, cmbCkxz.FieldItems, True);
  
end;

procedure TFrm_RKD_CX_Search.BitBtn1Click(Sender: TObject);
begin
  inherited;
  s := '';
  if EditFHDH.Text <> '' then s := ' AND J.RKDH = ''' + EditFHDH.text + '''';
  if cmbCkxz.ItemIndex > 0 then
    s := s + ' AND RKXZ = ''' + cmbCkxz.FieldItems.Strings[cmbCkxz.ItemIndex] + '''';

  if cmbQXDW.ItemIndex > 0 then
    s := s + ' AND  LYDW = ''' + cmbQXDW.FieldItems.Strings[cmbQXDW.ItemIndex] + '''';

  if rdFHZT.ItemIndex > 0 then
    s := s + iif(rdFHZT.ItemIndex = 1, ' AND JZY is null ', ' AND not (JZY is null)');

  if db1.Value > 0 then s := s + Format(' AND Y.TPMZ = %f ', [db1.Value]);

  s := ' TO_CHAR(KDRQ, ''YYYYMMDD'') >= ''' + FormatDateTime('YYYYMMDD', d1.Date) + ''' AND TO_CHAR(KDRQ, ''YYYYMMDD'') <= ''' + FormatDateTime('YYYYMMDD', d2.Date) + '''' + s;
end;

procedure TFrm_RKD_CX_Search.FormShow(Sender: TObject);
const
  QXDWSQL = 'SELECT DWJC DWMC, DWDM FROM TGS_GXDWSJB where BJ<> ''1'' and (%s=''1'' or (ZJSJ=''1'' or SJFH=''1'')) and DWDM not in (''-1'', ''-2'', ''-3'', ''-4'') order by PXM';
begin
  inherited;
  if cmbCkxz.ItemIndex > 0 then cmbCkxz.ItemIndex := 0;
  case IO_TYPE of
    io_txp:
      InitList(cmbQXDW.items, format(QXDWSQL, ['TXYW']), cmbQXDW.FieldItems, True);
  else
    InitList(cmbQXDW.items, format(QXDWSQL, ['JYYW']), cmbQXDW.FieldItems, True);
  end;
  if cmbQXDW.ItemIndex > 0 then cmbQXDW.ItemIndex := 0;
end;

end.