udyhd.~pas

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

unit uDyhd;

interface

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

type
  TfrmDyhd = class(TForm)
    QuickRep1: TQuickRep;
    he: TQRBand;
    QRShape1: TQRShape;
    QRShape2: TQRShape;
    QRShape3: TQRShape;
    QRShape4: TQRShape;
    QRShape5: TQRShape;
    QRShape6: TQRShape;
    QRShape7: TQRShape;
    QRShape8: TQRShape;
    QRShape9: TQRShape;
    QRShape10: TQRShape;
    QRShape11: TQRShape;
    QRShape12: TQRShape;
    QRShape14: TQRShape;
    QRShape15: TQRShape;
    QRShape16: TQRShape;
    QRLabel1: TQRLabel;
    QRLabel2: TQRLabel;
    QRDBText1: TQRDBText;
    QRShape17: TQRShape;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRShape18: TQRShape;
    QRShape19: TQRShape;
    QRShape20: TQRShape;
    QRShape21: TQRShape;
    QRShape22: TQRShape;
    QRShape23: TQRShape;
    QRLabel5: TQRLabel;
    QRLabel6: TQRLabel;
    QRShape24: TQRShape;
    QRShape25: TQRShape;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel10: TQRLabel;
    QRLabel11: TQRLabel;
    QRLabel12: TQRLabel;
    QRShape26: TQRShape;
    QRShape27: TQRShape;
    QRShape28: TQRShape;
    QRShape29: TQRShape;
    QRLabel13: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRLabel16: TQRLabel;
    QRShape30: TQRShape;
    QRLabel17: TQRLabel;
    QRShape31: TQRShape;
    QRLabel18: TQRLabel;
    QRLabel19: TQRLabel;
    QRShape32: TQRShape;
    QRShape33: TQRShape;
    QRShape34: TQRShape;
    QRLabel20: TQRLabel;
    QRLabel21: TQRLabel;
    QRLabel23: TQRLabel;
    QRLabel24: TQRLabel;
    QRLabel26: TQRLabel;
    QRShape35: TQRShape;
    QRShape36: TQRShape;
    QRShape38: TQRShape;
    QRShape39: TQRShape;
    QRShape40: TQRShape;
    QRShape41: TQRShape;
    QRShape42: TQRShape;
    QRShape43: TQRShape;
    QRShape44: TQRShape;
    QRShape45: TQRShape;
    QRShape46: TQRShape;
    QRShape47: TQRShape;
    QRShape48: TQRShape;
    QRShape50: TQRShape;
    QRShape51: TQRShape;
    QRShape52: TQRShape;
    QRShape49: TQRShape;
    QRShape53: TQRShape;
    QRShape54: TQRShape;
    QRLabel27: TQRLabel;
    QRLabel28: TQRLabel;
    QRLabel30: TQRLabel;
    QRLabel31: TQRLabel;
    QRLabel32: TQRLabel;
    QRLabel33: TQRLabel;
    QRLabel34: TQRLabel;
    QRLabel35: TQRLabel;
    QRLabel36: TQRLabel;
    QRLabel37: TQRLabel;
    QRLabel38: TQRLabel;
    QRLabel39: TQRLabel;
    QRLabel40: TQRLabel;
    QRLabel41: TQRLabel;
    QRLabel42: TQRLabel;
    QRLabel43: TQRLabel;
    QRLabel44: TQRLabel;
    QRLabel45: TQRLabel;
    QRLabel46: TQRLabel;
    QRLabel47: TQRLabel;
    QRLabel48: TQRLabel;
    QRLabel49: TQRLabel;
    QRLabel50: TQRLabel;
    QRLabel52: TQRLabel;
    QRLabel53: TQRLabel;
    QRLabel54: TQRLabel;
    QRLabel56: TQRLabel;
    QRLabel57: TQRLabel;
    QRLabel58: TQRLabel;
    QRLabel59: TQRLabel;
    QRLabel60: TQRLabel;
    QRLabel61: TQRLabel;
    QRLabel62: TQRLabel;
    QRLabel63: TQRLabel;
    QRLabel64: TQRLabel;
    QRLabel65: TQRLabel;
    QRLabel66: TQRLabel;
    QRLabel67: TQRLabel;
    QRLabel68: TQRLabel;
    QRLabel69: TQRLabel;
    QRLabel70: TQRLabel;
    QRLabel71: TQRLabel;
    QRLabel72: TQRLabel;
    QRLabel73: TQRLabel;
    QRLabel74: TQRLabel;
    QRLabel75: TQRLabel;
    QRLabel76: TQRLabel;
    QRLabel77: TQRLabel;
    QRLabel78: TQRLabel;
    QRLabel79: TQRLabel;
    QRLabel80: TQRLabel;
    QRLabel81: TQRLabel;
    QRLabel82: TQRLabel;
    QRLabel83: TQRLabel;
    QRLabel84: TQRLabel;
    QRLabel85: TQRLabel;
    QRLabel86: TQRLabel;
    QRLabel89: TQRLabel;
    qryInfo: TQuery;
    QRLabel90: TQRLabel;
    QRLabel91: TQRLabel;
    QRLabel92: TQRLabel;
    QRLabel93: TQRLabel;
    QRLabel94: TQRLabel;
    QRLabel95: TQRLabel;
    QRLabel96: TQRLabel;
    QRLabel97: TQRLabel;
    QRLabel98: TQRLabel;
    QRLabel99: TQRLabel;
    QRLabel100: TQRLabel;
    QRLabel101: TQRLabel;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    QRDBText9: TQRDBText;
    QRDBText10: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText12: TQRDBText;
    QRDBText13: TQRDBText;
    QRDBText14: TQRDBText;
    QRLabel102: TQRLabel;
    QRDBText15: TQRDBText;
    QRDBText16: TQRDBText;
    QRDBText17: TQRDBText;
    QRDBText18: TQRDBText;
    QRDBText20: TQRDBText;
    QRDBText19: TQRDBText;
    QRLabel103: TQRLabel;
    QRDBText21: TQRDBText;
    QRLabel104: TQRLabel;
    QRDBText22: TQRDBText;
    QRLabel105: TQRLabel;
    QRLabel106: TQRLabel;
    QRDBText23: TQRDBText;
    QRDBText24: TQRDBText;
    QRLabel107: TQRLabel;
    QRLabel108: TQRLabel;
    QRLabel109: TQRLabel;
    QRDBText25: TQRDBText;
    QRDBText26: TQRDBText;
    QRLabel110: TQRLabel;
    QRDBText27: TQRDBText;
    QRLabel111: TQRLabel;
    QRLabel112: TQRLabel;
    QRDBText29: TQRDBText;
    QRLabel113: TQRLabel;
    QRDBText30: TQRDBText;
    QRLabel114: TQRLabel;
    QRDBText31: TQRDBText;
    QRLabel115: TQRLabel;
    QRDBText32: TQRDBText;
    QRLabel116: TQRLabel;
    QRDBText33: TQRDBText;
    QRLabel117: TQRLabel;
    QRDBText34: TQRDBText;
    QRLabel118: TQRLabel;
    QRShape55: TQRShape;
    QRDBText35: TQRDBText;
    QRLabel119: TQRLabel;
    QRDBText36: TQRDBText;
    QRLabel120: TQRLabel;
    QRDBText37: TQRDBText;
    QRLabel121: TQRLabel;
    QRDBText38: TQRDBText;
    QRLabel122: TQRLabel;
    QRDBText39: TQRDBText;
    QRLabel123: TQRLabel;
    QRLabel124: TQRLabel;
    QRLabel125: TQRLabel;
    QRDBText40: TQRDBText;
    QRDBText41: TQRDBText;
    QRLabel126: TQRLabel;
    QRDBText42: TQRDBText;
    QRLabel127: TQRLabel;
    QRDBText43: TQRDBText;
    QRLabel128: TQRLabel;
    qryInfoRYID: TStringField;
    qryInfoBH: TStringField;
    qryInfoDWDM: TStringField;
    qryInfoDWMC: TStringField;
    qryInfoXM: TStringField;
    qryInfoXB: TStringField;
    qryInfoSHBZH: TStringField;
    qryInfoSBSJ: TDateTimeField;
    qryInfoSQYY: TStringField;
    qryInfoCSRQ: TDateTimeField;
    qryInfoCJGZSJ: TDateTimeField;
    qryInfoLTXSJ: TDateTimeField;
    qryInfoYGXS: TStringField;
    qryInfoCJBXSJ: TDateTimeField;
    qryInfoLJGZ: TFloatField;
    qryInfoSNJPJGZ: TFloatField;
    qryInfoBZBT: TFloatField;
    qryInfoTZXS: TFloatField;
    qryInfoGNGZ: TFloatField;
    qryInfoLJZS: TFloatField;
    qryInfoLJJFNX: TFloatField;
    qryInfoTYQJFNX: TFloatField;
    qryInfoSTJFNX: TFloatField;
    qryInfoTSGZYS: TFloatField;
    qryInfoJXGWGZYS: TFloatField;
    qryInfoYDYHGZYS: TFloatField;
    qryInfoTYQTSGZNX: TFloatField;
    qryInfoTQTXNX: TFloatField;
    qryInfoPJZS: TFloatField;
    qryInfoSNDSPGZ: TFloatField;
    qryInfoZSHYPJGZ: TFloatField;
    qryInfoGRZHCCE: TFloatField;
    qryInfoYCXLNJT: TFloatField;
    qryInfoBCBXYE: TFloatField;
    qryInfoJCYLJJFBL: TFloatField;
    qryInfoJCYLJ: TFloatField;
    qryInfoGDXYLJJFBL: TFloatField;
    qryInfoTJJJFBL: TFloatField;
    qryInfoTJJ: TFloatField;
    qryInfoGDXYLJ: TFloatField;
    qryInfoGRZHYLJ: TFloatField;
    qryInfoHLF: TFloatField;
    qryInfoDFBCLXDY: TFloatField;
    qryInfoHYGDXBT: TFloatField;
    qryInfoDYHJ_DF: TFloatField;
    qryInfoBZGZ: TFloatField;
    qryInfoJBLTXFBL: TFloatField;
    qryInfoJBLTXF: TFloatField;
    qryInfoJC_89: TFloatField;
    qryInfoLNTZJ: TFloatField;
    qryInfoGZBT: TFloatField;
    qryInfoDYZE_HY: TFloatField;
    qryInfoHDDY: TFloatField;
    qryInfoSPYJ: TStringField;
    qryInfoJBR: TStringField;
    qryInfoJBRQ: TDateTimeField;
    qryInfoSHR: TStringField;
    qryInfoSHRQ: TDateTimeField;
    qryInfoSJJFNX: TIntegerField;
    QRDBText44: TQRDBText;
    QRLabel129: TQRLabel;
    QRLabel130: TQRLabel;
    QRDBText45: TQRDBText;
    QRLabel131: TQRLabel;
    TSGZNX: TQRLabel;
    QRLabel133: TQRLabel;
    QRLabel134: TQRLabel;
    QRLabel135: TQRLabel;
    QRLabel138: TQRLabel;
    QRLabel139: TQRLabel;
    QRLabel140: TQRLabel;
    QRDBText28: TQRDBText;
    QRDBText46: TQRDBText;
    QRDBText47: TQRDBText;
    QRDBText48: TQRDBText;
    qryInfoTXBZF: TFloatField;
    qryInfoGJBT: TFloatField;
    QRDBText49: TQRDBText;
    QRLabel22: TQRLabel;
    QRDBText50: TQRDBText;
    QRLabel25: TQRLabel;
    QRDBText51: TQRDBText;
    QRLabel136: TQRLabel;
    QRDBText52: TQRDBText;
    QRLabel29: TQRLabel;
    QRLabel137: TQRLabel;
    QRDBText53: TQRDBText;
    QRLabel141: TQRLabel;
    today: TQRLabel;
    QRLabel51: TQRLabel;
    QRDBText54: TQRDBText;
    qryInfoKSFFSJ: TDateTimeField;
    procedure qryInfoCalcFields(DataSet: TDataSet);
    procedure QRDBText9Print(sender: TObject; var Value: string);
    procedure QRDBText10Print(sender: TObject; var Value: string);
    procedure QRDBText13Print(sender: TObject; var Value: string);
    procedure QRLabel132Print(sender: TObject; var Value: string);
    procedure TSGZNXPrint(sender: TObject; var Value: string);
    procedure JFBLPrint(sender: TObject; var Value: string);
    procedure QRDBText6Print(sender: TObject; var Value: string);
    procedure todayPrint(sender: TObject; var Value: string);
    procedure QRDBText54Print(sender: TObject; var Value: string);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmDyhd: TfrmDyhd;

implementation

uses dMain;

{$R *.DFM}

procedure TfrmDyhd.qryInfoCalcFields(DataSet: TDataSet);
begin
  TQuery(DataSet).FieldByName('SJJFNX').AsInteger :=
    TQuery(DataSet).FieldByName('LJJFNX').AsInteger -
    TQuery(DataSet).FieldByName('STJFNX').AsInteger;
end;

procedure TfrmDyhd.QRDBText9Print(sender: TObject; var Value: string);
begin
  if Value <> '' then
    Value := formatdatetime('yyyy"年"mm"月"', StrToDate(Value));
end;

procedure TfrmDyhd.QRDBText10Print(sender: TObject; var Value: string);
begin
  if Value <> '' then
    Value := formatdatetime('yyyy"年"mm"月"', StrToDate(Value));
end;

procedure TfrmDyhd.QRDBText13Print(sender: TObject; var Value: string);
begin
  if Value <> '' then
    Value := formatdatetime('yyyy"年"mm"月"', StrToDate(Value));
end;

procedure TfrmDyhd.QRLabel132Print(sender: TObject; var Value: string);
begin
//发放信息
  Value := formatdatetime('yyyy"年"mm"月"',
    IncMonth(qryInfo.FieldByName('LTXSJ').AsDateTime, 1));
end;

procedure TfrmDyhd.TSGZNXPrint(sender: TObject; var Value: string);
begin
  Value := IntToStr(qryInfo.FieldByName('TSGZYS').AsInteger +
    qryInfo.FieldByName('JXGWGZYS').AsInteger +
    qryInfo.FieldByName('YDYHGZYS').AsInteger);
end;

procedure TfrmDyhd.JFBLPrint(sender: TObject; var Value: string);
begin
  Value := FloatToStr(Round(((qryInfo.FieldByName('TYQJFNX').AsInteger *
    qryInfo.FieldByName('GDXYLJJFBL').AsFloat +
    qryInfo.FieldByName('TYQTSGZNX').AsInteger * 0.2 -
    qryInfo.FieldByName('TQTXNX').AsInteger) / 12 + 0.05) * 100)) + '%';
end;

procedure TfrmDyhd.QRDBText6Print(sender: TObject; var Value: string);
begin
  if Value <> '' then
    Value := formatdatetime('yyyy.mm.dd',
      qryInfo.FieldByName('SBSJ').AsDateTime);
end;

procedure TfrmDyhd.todayPrint(sender: TObject; var Value: string);
begin
  Value := formatdatetime('yyyy.mm.dd', now);
end;

procedure TfrmDyhd.QRDBText54Print(sender: TObject; var Value: string);
begin
  if Value <> '' then
    Value := formatdatetime('yyyy"年"mm"月"',
      qryInfo.FieldByName('KSFFSJ').AsDateTime);
end;

end.