unit PRINT_SPXSMX;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  DB, DBTables, QRCTRLS, QUICKRPT, ExtCtrls,QRPrntr,myself,frmmain;

type
  TFrm_print_spxsmx = class(TForm)
    Query_DATA: TQuery;
    QuickRep_spxsmx: TQuickRep;
    DetailBand1: TQRBand;
    QRE_peoplename: TQRExpr;
    QRE_date: TQRExpr;
    QRE_depotname: TQRExpr;
    QRE_goodsname: TQRExpr;
    QRE_type: TQRExpr;
    QRE_unit: TQRExpr;
    QRE_number: TQRExpr;
    QRE_selldj: TQRExpr;
    QRE_price: TQRExpr;
    QRE_memo: TQRExpr;
    PageFooterBand1: TQRBand;
    QRExpr11: TQRExpr;
    QRLabel12: TQRLabel;
    TitleBand1: TQRBand;
    QRS_TITLE: TQRSysData;
    QRL_coname: TQRLabel;
    QRExpr13: TQRExpr;
    QRL_printdate: TQRLabel;
    ColumnHeaderBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel2: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel10: TQRLabel;
    QRBand1: TQRBand;
    QRExpr12: TQRExpr;
    procedure FormCreate(Sender: TObject);
    procedure QuickRep_spxsmxPreview(Sender: TObject);
    procedure Query_DATAAfterScroll(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_print_spxsmx: TFrm_print_spxsmx;

implementation

uses MAIN_QUERY_SPXSMX, PRINT_TEMP;

{$R *.dfm}

procedure TFrm_print_spxsmx.FormCreate(Sender: TObject);
begin
  qrl_coname.Caption :=S_name;
    QRL_printdate.Caption :='統(tǒng)計日期：'+formatdatetime('yyyy-mm-dd',frm_main_query_spxsmx.DTP_begin.DateTime)
               +' 至 '+formatdatetime('yyyy-mm-dd',frm_main_query_spxsmx.DTP_end.DateTime);
    if frm_main_query_spxsmx.CB_goods.Text='' then
      QRS_TITLE.Text :=QRS_TITLE.Text+'（所有）'
    else
      QRS_TITLE.Text :=QRS_TITLE.Text+'（'+frm_main_query_spxsmx.CB_goods.Text +'）';
  with query_data do
  begin
     DatabaseName :=HWSHOPDATA;
     close;
     sql.Clear ;
     SQL.Text :=frm_main_query_spxsmx.Query_data.SQL.Text ;
     try
        Open ;
     except
        messagedlg(Errormsg0001+'0000',mtError,[mbok],0);
        close;
     end;
  end;
end;

procedure TFrm_print_spxsmx.QuickRep_spxsmxPreview(Sender: TObject);
begin
   with Tfrm_print_temp.Create(Application) do
   begin
    	QRP_print.QRPrinter := TQRPrinter(Sender);
    	frm_print_temp.CurRep := QuickRep_spxsmx;
      show;
   end;
end;

procedure TFrm_print_spxsmx.Query_DATAAfterScroll(DataSet: TDataSet);
begin
   if QRE_number.Value.intResult < 0 then
   begin
      QRE_peoplename.Font.Color :=clred;
      qre_date.Font.Color :=clred;
      qre_depotname.Font.Color :=clred;
      qre_goodsname.Font.Color :=clred;
      qre_type.Font.Color :=clred;
      QRE_unit.Font.Color :=clred;
      qre_number.Font.Color :=clred;
      QRE_selldj.Font.Color :=clred;
      qre_price.Font.Color :=clred;
      QRE_memo.Font.Color :=clred;
   end
   else
   begin
      QRE_peoplename.Font.Color :=clWindowText;
      qre_date.Font.Color :=clWindowText;
      qre_depotname.Font.Color :=clWindowText;
      qre_goodsname.Font.Color :=clWindowText;
      qre_type.Font.Color :=clWindowText;
      QRE_unit.Font.Color :=clWindowText;
      qre_number.Font.Color :=clWindowText;
      QRE_selldj.Font.Color :=clWindowText;
      qre_price.Font.Color :=clWindowText;
      QRE_memo.Font.Color :=clWindowText;
   end;
end;

end.