udyhd_lcx.~pas

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

unit uDyhd_LCX;

interface

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

type
  TfrmDyhd_LCX = class(TForm)
    QuickRep1: TQuickRep;
    he: TQRBand;
    QRShape1: TQRShape;
    QRShape2: TQRShape;
    QRShape3: TQRShape;
    QRShape11: 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;
    QRShape23: TQRShape;
    QRLabel5: TQRLabel;
    QRLabel11: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRLabel16: TQRLabel;
    QRLabel17: TQRLabel;
    QRLabel18: TQRLabel;
    QRLabel19: TQRLabel;
    QRShape41: TQRShape;
    QRShape43: TQRShape;
    QRShape46: TQRShape;
    QRShape47: TQRShape;
    QRShape53: TQRShape;
    QRLabel32: TQRLabel;
    QRLabel46: 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;
    QRLabel77: TQRLabel;
    QRLabel78: TQRLabel;
    QRLabel79: TQRLabel;
    QRLabel80: TQRLabel;
    QRLabel87: TQRLabel;
    QRLabel88: TQRLabel;
    qryInfo: TQuery;
    QRLabel90: TQRLabel;
    QRLabel91: TQRLabel;
    QRLabel92: TQRLabel;
    QRLabel93: TQRLabel;
    QRLabel94: TQRLabel;
    QRLabel95: TQRLabel;
    QRLabel96: 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;
    QRDBText12: TQRDBText;
    QRDBText13: TQRDBText;
    QRDBText14: TQRDBText;
    QRLabel102: TQRLabel;
    QRDBText15: TQRDBText;
    QRDBText16: TQRDBText;
    QRDBText18: TQRDBText;
    QRDBText20: TQRDBText;
    QRDBText21: TQRDBText;
    QRLabel104: TQRLabel;
    QRLabel106: TQRLabel;
    QRDBText26: TQRDBText;
    QRLabel110: TQRLabel;
    QRDBText30: TQRDBText;
    QRLabel114: TQRLabel;
    QRDBText42: TQRDBText;
    QRLabel127: TQRLabel;
    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;
    QRLabel130: TQRLabel;
    QRLabel133: TQRLabel;
    QRLabel140: TQRLabel;
    qryInfoTXBZF: TFloatField;
    qryInfoGJBT: TFloatField;
    QRShape55: TQRShape;
    QRLabel20: TQRLabel;
    QRLabel21: TQRLabel;
    QRDBText28: TQRDBText;
    QRLabel22: TQRLabel;
    QRDBText31: TQRDBText;
    QRLabel23: TQRLabel;
    QRDBText32: TQRDBText;
    QRLabel24: TQRLabel;
    QRDBText22: TQRDBText;
    QRLabel25: TQRLabel;
    QRLabel6: TQRLabel;
    QRDBText17: TQRDBText;
    QRLabel7: TQRLabel;
    QRShape4: TQRShape;
    QRLabel8: TQRLabel;
    QRLabel10: TQRLabel;
    QRLabel12: TQRLabel;
    QRShape5: TQRShape;
    QRLabel13: TQRLabel;
    QRLabel26: TQRLabel;
    QRShape6: TQRShape;
    QRShape7: TQRShape;
    QRShape8: TQRShape;
    QRShape9: TQRShape;
    QRLabel27: TQRLabel;
    QRLabel28: TQRLabel;
    QRLabel29: TQRLabel;
    QRLabel30: TQRLabel;
    QRLabel31: TQRLabel;
    QRLabel33: TQRLabel;
    QRLabel34: TQRLabel;
    QRLabel35: TQRLabel;
    QRLabel36: TQRLabel;
    QRDBText11: TQRDBText;
    QRLabel37: TQRLabel;
    QRDBText19: TQRDBText;
    QRLabel38: TQRLabel;
    today: TQRLabel;
    QRLabel39: TQRLabel;
    QRLabel132: TQRLabel;
    qryInfoGRJFZE: TFloatField;
    qryInfoGRJFLX: TFloatField;
    qryInfoDWHBZE: TFloatField;
    qryInfoDWHBLX: TFloatField;
    grzhbj: TQRLabel;
    grzhlx: TQRLabel;
    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 grzhbjPrint(sender: TObject; var Value: string);
    procedure grzhlxPrint(sender: TObject; var Value: string);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmDyhd_LCX: TfrmDyhd_LCX;

implementation

{$R *.DFM}

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

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

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

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

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

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

procedure TfrmDyhd_LCX.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_LCX.QRDBText6Print(sender: TObject; var Value: string);
begin
  if Value <> '' then
    Value := formatdatetime('yyyy.mm.dd', StrToDate(Value));

end;

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

procedure TfrmDyhd_LCX.grzhbjPrint(sender: TObject; var Value: string);
begin
  Value := FloatToStr(
    qryInfo.FieldByName('GRJFZE').AsFloat +
    qryInfo.FieldByName('DWHBZE').AsFloat);
end;

procedure TfrmDyhd_LCX.grzhlxPrint(sender: TObject; var Value: string);
begin
  Value := FloatToStr(
    qryInfo.FieldByName('GRJFLX').AsFloat +
    qryInfo.FieldByName('DWHBLX').AsFloat);
end;

end.