uyldyzjtz_1.pas

行业应急系统 包括: 应急系统（待遇核发） 发放系统 开发环境:Delphi5 (sp1)+ Oracle 8.05 MultiExport是一个可以将数据按指定字段倒出

unit uYLDYZJTZ_1;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Qrctrls, QuickRpt, ExtCtrls, Db, DBTables;

type
  TfrmYLDYZJTZ_1 = class(TForm)
    QuickRep1: TQuickRep;
    QRLabel1: TQRLabel;
    DetailBand1: TQRBand;
    QRLabel2: TQRLabel;
    QRShape1: TQRShape;
    QRShape2: TQRShape;
    QRShape3: TQRShape;
    QRShape5: TQRShape;
    QRShape4: TQRShape;
    QRShape6: TQRShape;
    QRShape7: TQRShape;
    QRShape8: TQRShape;
    QRShape9: TQRShape;
    QRShape10: TQRShape;
    QRShape11: TQRShape;
    QRShape13: TQRShape;
    QRShape14: TQRShape;
    QRShape16: TQRShape;
    QRShape17: TQRShape;
    QRShape18: TQRShape;
    QRShape19: TQRShape;
    QRShape20: TQRShape;
    QRShape22: TQRShape;
    QRShape23: TQRShape;
    QRShape24: TQRShape;
    QRShape25: TQRShape;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel12: TQRLabel;
    QRLabel13: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRLabel16: TQRLabel;
    QRLabel18: TQRLabel;
    QRLabel19: TQRLabel;
    QRLabel20: TQRLabel;
    QRLabel21: TQRLabel;
    QRLabel22: TQRLabel;
    QRLabel25: TQRLabel;
    QRLabel26: TQRLabel;
    QRLabel27: TQRLabel;
    QRLabel29: TQRLabel;
    QRLabel30: TQRLabel;
    QRLabel32: TQRLabel;
    QRLabel33: TQRLabel;
    QRLabel34: TQRLabel;
    QRLabel35: TQRLabel;
    QRLabel36: TQRLabel;
    QRLabel39: TQRLabel;
    QRLabel23: TQRLabel;
    QRLabel31: TQRLabel;
    QRLabel40: TQRLabel;
    QRLabel41: TQRLabel;
    QRLabel42: TQRLabel;
    QRShape26: TQRShape;
    QRShape27: TQRShape;
    QRShape28: TQRShape;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText8: TQRDBText;
    QRDBText10: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText12: TQRDBText;
    QRDBText13: TQRDBText;
    QRDBText15: TQRDBText;
    QRDBText16: TQRDBText;
    QRDBText17: TQRDBText;
    QRDBText18: TQRDBText;
    QRDBText19: TQRDBText;
    QRDBText20: TQRDBText;
    QRDBText22: TQRDBText;
    QRDBText23: TQRDBText;
    QRDBText24: TQRDBText;
    QRDBText25: TQRDBText;
    qryReport: TQuery;
    QRDBText26: TQRDBText;
    QRLabel44: TQRLabel;
    QRSysData1: TQRSysData;
    QRDBText9: TQRDBText;
    qryReportYJRQ: TDateTimeField;
    qryReportBH: TStringField;
    qryReportDWSL: TFloatField;
    qryReportJCYLJ_ZJ: TFloatField;
    qryReportGDXYLJ_ZJ: TFloatField;
    qryReportGRZHYLJ_ZJ: TFloatField;
    qryReportHYGDXBT_ZJ: TFloatField;
    qryReportTZJ_ZJ: TFloatField;
    qryReportHLF_ZJ: TFloatField;
    qryReportDFBCLXDY_ZJ: TFloatField;
    qryReportHJ_ZJ: TFloatField;
    qryReportJCYLJ_JS: TFloatField;
    qryReportGDXYLJ_JS: TFloatField;
    qryReportGRZHYLJ_JS: TFloatField;
    qryReportHYGDXBT_JS: TFloatField;
    qryReportTZJ_JS: TFloatField;
    qryReportHLF_JS: TFloatField;
    qryReportDFBCLXDY_JS: TFloatField;
    qryReportHJ_JS: TFloatField;
    qryReportJCYLJ: TFloatField;
    qryReportGDXYLJ: TFloatField;
    qryReportGRZHYLJ: TFloatField;
    qryReportHYGDXBT: TFloatField;
    qryReportTZJ: TFloatField;
    qryReportHLF: TFloatField;
    qryReportDFBCLXDY: TFloatField;
    qryReportBYHJ: TFloatField;
    procedure QRDBText1Print(sender: TObject; var Value: String);
    procedure QRSysData1Print(sender: TObject; var Value: String);
    procedure QRDBText9Print(sender: TObject; var Value: String);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmYLDYZJTZ_1: TfrmYLDYZJTZ_1;

implementation

{$R *.DFM}

procedure TfrmYLDYZJTZ_1.QRDBText1Print(sender: TObject; var Value: String);
var
  sTemp,sResult : string;
  i : integer;
begin
   //  Value := FormatDateTime('YYYY年MM月',StrToDate(Value));

   //存储结果
   sResult := '';
   //提取年
   sTemp := FormatDateTime('YYYY',StrToDate(Value));
   for i := 1 to 4 do
   begin
     case sTemp[i] of
     '0' : sResult := sResult + '零';
     '1' : sResult := sResult + '一';
     '2' : sResult := sResult + '二';
     '3' : sResult := sResult + '三';
     '4' : sResult := sResult + '四';
     '5' : sResult := sResult + '五';
     '6' : sResult := sResult + '六';
     '7' : sResult := sResult + '七';
     '8' : sResult := sResult + '八';
     '9' : sResult := sResult + '九';
     else continue;//其他的忽略
     end;//end case
   end;//end for

   //加上'年'
   sResult := sResult + '年';

   //提取月
   sTemp := FormatDateTime('MM',StrToDate(Value));
   for i := 1 to 2 do
   begin
     case sTemp[i] of
     '0' : continue;//忽略零
     '1' : if i = 1 then
             sResult := sResult + '十'
           else
             sResult := sResult + '一';
     '2' : sResult := sResult + '二';
     '3' : sResult := sResult + '三';
     '4' : sResult := sResult + '四';
     '5' : sResult := sResult + '五';
     '6' : sResult := sResult + '六';
     '7' : sResult := sResult + '七';
     '8' : sResult := sResult + '八';
     '9' : sResult := sResult + '九';
     else continue;//其他的忽略
     end;//end case
   end;//end for
   //加上'月'
   sResult := sResult + '月';

   Value := sResult;
end;

procedure TfrmYLDYZJTZ_1.QRSysData1Print(sender: TObject; var Value: String);
begin
  Value := FormatDateTime(LongDateFormat,StrToDate(Value));
end;

procedure TfrmYLDYZJTZ_1.QRDBText9Print(sender: TObject; var Value: String);
begin
  Value := Value + '个';
end;

procedure TfrmYLDYZJTZ_1.FormShow(Sender: TObject);
begin

  self.QuickRep1.Preview;

end;

end.