patdayfeedtl.dfm

某大型医院护士站

          444.5
          15.875
          171.979166666667)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Color = clWhite
        DataSet = qryPatDayfeeDtl
        DataField = 'ITEMNAME'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -15
        Font.Name = '宋体'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        FontSize = 11
      end
      object QRDBText7: TQRDBText
        Left = 360
        Top = 6
        Width = 33
        Height = 18
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          47.625
          952.5
          15.875
          87.3125)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Color = clWhite
        DataSet = qryPatDayfeeDtl
        DataField = 'SPEC'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -15
        Font.Name = '宋体'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        FontSize = 11
      end
      object QRDBText8: TQRDBText
        Left = 488
        Top = 6
        Width = 65
        Height = 18
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          47.625
          1291.16666666667
          15.875
          171.979166666667)
        Alignment = taRightJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Color = clWhite
        DataSet = qryPatDayfeeDtl
        DataField = 'TOTALQTY'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -15
        Font.Name = '宋体'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        FontSize = 11
      end
      object QRDBText9: TQRDBText
        Left = 560
        Top = 6
        Width = 57
        Height = 18
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          47.625
          1481.66666666667
          15.875
          150.8125)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Color = clWhite
        DataSet = qryPatDayfeeDtl
        DataField = 'USEUNIT'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -15
        Font.Name = '宋体'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        FontSize = 11
      end
      object QRDBText10: TQRDBText
        Left = 686
        Top = 6
        Width = 65
        Height = 18
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          47.625
          1815.04166666667
          15.875
          171.979166666667)
        Alignment = taRightJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Color = clWhite
        DataSet = qryPatDayfeeDtl
        DataField = 'TOTALFEE'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -15
        Font.Name = '宋体'
        Font.Style = []
        Mask = '#0.0000'
        ParentFont = False
        Transparent = False
        WordWrap = True
        FontSize = 11
      end
    end
    object QRBand2: TQRBand
      Left = 19
      Top = 168
      Width = 778
      Height = 27
      Frame.Color = clBlack
      Frame.DrawTop = True
      Frame.DrawBottom = False
      Frame.DrawLeft = True
      Frame.DrawRight = True
      AlignToBottom = False
      Color = clWhite
      ForceNewColumn = False
      ForceNewPage = False
      Size.Values = (
        71.4375
        2058.45833333333)
      BandType = rbGroupFooter
      object QRLabel4: TQRLabel
        Left = 553
        Top = 5
        Width = 54
        Height = 18
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          47.625
          1463.14583333333
          13.2291666666667
          142.875)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = False
        AutoStretch = False
        Caption = '小计：'
        Color = clWhite
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -15
        Font.Name = '宋体'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        FontSize = 11
      end
      object QRExpr1: TQRExpr
        Left = 609
        Top = 4
        Width = 141
        Height = 20
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          52.9166666666667
          1611.3125
          10.5833333333333
          373.0625)
        Alignment = taRightJustify
        AlignToBand = False
        AutoSize = False
        AutoStretch = False
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -19
        Font.Name = '宋体'
        Font.Style = [fsBold]
        Color = clWhite
        ParentFont = False
        ResetAfterPrint = True
        Transparent = False
        WordWrap = True
        Expression = 'SUM(qryPatDayfeeDtl.TOTALFEE)'
        Mask = '#0.0000'
        FontSize = 14
      end
    end
    object QRBand1: TQRBand
      Left = 19
      Top = 195
      Width = 778
      Height = 40
      Frame.Color = clBlack
      Frame.DrawTop = True
      Frame.DrawBottom = False
      Frame.DrawLeft = False
      Frame.DrawRight = False
      AlignToBottom = False
      Color = clWhite
      ForceNewColumn = False
      ForceNewPage = False
      Size.Values = (
        105.833333333333
        2058.45833333333)
      BandType = rbGroupFooter
      object QRLabel7: TQRLabel
        Left = 531
        Top = 7
        Width = 76
        Height = 16
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          42.3333333333333
          1404.9375
          18.5208333333333
          201.083333333333)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Caption = '费用总计：'
        Color = clWhite
        Transparent = False
        WordWrap = True
        FontSize = 11
      end
      object QRLabel8: TQRLabel
        Left = 659
        Top = 3
        Width = 90
        Height = 20
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          52.9166666666667
          1743.60416666667
          7.9375
          238.125)
        Alignment = taRightJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Caption = 'QRLabel8'
        Color = clWhite
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -19
        Font.Name = '宋体'
        Font.Style = [fsBold]
        OnPrint = QRLabel8Print
        ParentFont = False
        Transparent = False
        WordWrap = True
        FontSize = 14
      end
    end
  end
  object qryPatDayfeeDtl: TwwQuery
    DatabaseName = 'PRJLCLDATA'
    SQL.Strings = (
      'SELECT * FROM DAYFEEDTL'
      'ORDER BY INID ,TIMES ,SQID ,ICLASS ,ITEMID')
    LookupFields.Strings = (
      'PATNAME;PRJLCLDATA;PATIENTSUB.DB;PATDESC;;INID;TIMES;SQID;Y'
      'SEXNAME;PRJLCLDATA;PATIENTSUB.DB;SEXNAME;;INID;TIMES;SQID;Y'
      'ITEMNAME;PROJHISLOCAL;ORDERCOST.DB;CNAME;;COSTID;Y'
      'SPEC;PROJHISLOCAL;ORDERCOST.DB;SPEC;;COSTID;Y'
      'USEUNIT;PROJHISLOCAL;ORDERCOST.DB;USEUNIT;;COSTID;Y'
      'INVITEMNAME;PROJHISLOCAL;INVITEM.DB;INVITEMNAME;;ICLASS;Y'
      'BEDID;PRJLCLDATA;PATIENTSUB.DB;BEDID;;INID;TIMES;SQID;Y')
    LookupLinks.Strings = (
      'INID;INID;TIMES;TIMES;SQID;SQID'
      'INID;INID;TIMES;TIMES;SQID;SQID'
      'ITEMID;COSTID'
      'ITEMID;COSTID'
      'ITEMID;COSTID'
      'ICLASS;ICLASS'
      'INID;INID;TIMES;TIMES;SQID;SQID')
    ValidateWithMask = True
    Left = 40
    Top = 8
    object qryPatDayfeeDtlINID: TIntegerField
      DisplayWidth = 10
      FieldName = 'INID'
      Origin = 'PRJLCLDATA."DAYFEEDTL.DB".INID'
    end
    object qryPatDayfeeDtlTIMES: TSmallintField
      DisplayWidth = 10
      FieldName = 'TIMES'
      Origin = 'PRJLCLDATA."DAYFEEDTL.DB".TIMES'
    end
    object qryPatDayfeeDtlSQID: TSmallintField
      DisplayWidth = 10
      FieldName = 'SQID'
      Origin = 'PRJLCLDATA."DAYFEEDTL.DB".SQID'
    end
    object qryPatDayfeeDtlICLASS: TStringField
      DisplayWidth = 4
      FieldName = 'ICLASS'
      Origin = 'PRJLCLDATA."DAYFEEDTL.DB".ICLASS'
      Size = 4
    end
    object qryPatDayfeeDtlITEMID: TStringField
      DisplayWidth = 6
      FieldName = 'ITEMID'
      Origin = 'PRJLCLDATA."DAYFEEDTL.DB".ITEMID'
      Size = 6
    end
    object qryPatDayfeeDtlTOTALQTY: TFloatField
      DisplayWidth = 10
      FieldName = 'TOTALQTY'
      Origin = 'PRJLCLDATA."DAYFEEDTL.DB".TOTALQTY'
    end
    object qryPatDayfeeDtlTOTALFEE: TFloatField
      DisplayWidth = 10
      FieldName = 'TOTALFEE'
      Origin = 'PRJLCLDATA."DAYFEEDTL.DB".TOTALFEE'
    end
    object qryPatDayfeeDtlPATNAME: TStringField
      DisplayWidth = 12
      FieldKind = fkCalculated
      FieldName = 'PATNAME'
      Size = 12
      Calculated = True
    end
    object qryPatDayfeeDtlSEXNAME: TStringField
      DisplayWidth = 4
      FieldKind = fkCalculated
      FieldName = 'SEXNAME'
      Size = 4
      Calculated = True
    end
    object qryPatDayfeeDtlITEMNAME: TStringField
      DisplayWidth = 18
      FieldKind = fkCalculated
      FieldName = 'ITEMNAME'
      Size = 18
      Calculated = True
    end
    object qryPatDayfeeDtlSPEC: TStringField
      DisplayWidth = 16
      FieldKind = fkCalculated
      FieldName = 'SPEC'
      Size = 16
      Calculated = True
    end
    object qryPatDayfeeDtlUSEUNIT: TStringField
      DisplayWidth = 4
      FieldKind = fkCalculated
      FieldName = 'USEUNIT'
      Size = 4
      Calculated = True
    end
    object qryPatDayfeeDtlINVITEMNAME: TStringField
      DisplayWidth = 10
      FieldKind = fkCalculated
      FieldName = 'INVITEMNAME'
      Size = 10
      Calculated = True
    end
    object qryPatDayfeeDtlBEDID: TStringField
      DisplayWidth = 6
      FieldKind = fkCalculated
      FieldName = 'BEDID'
      Size = 6
      Calculated = True
    end
  end
  object qryInidTotalSum: TwwQuery
    DatabaseName = 'PRJLCLDATA'
    SQL.Strings = (
      'SELECT SUM(TOTALFEE) AS INIDTOTALFEE'
      '  FROM DAYFEEDTL'
      ' WHERE INID = :I_INID'
      '   AND TIMES= :I_TIMES'
      '   AND SQID = :I_SQID')
    ValidateWithMask = True
    Left = 96
    Top = 8
    ParamData = <
      item
        DataType = ftInteger
        Name = 'I_INID'
        ParamType = ptInput
      end
      item
        DataType = ftSmallint
        Name = 'I_TIMES'
        ParamType = ptInput
      end
      item
        DataType = ftSmallint
        Name = 'I_SQID'
        ParamType = ptInput
      end>
    object qryInidTotalSumINIDTOTALFEE: TFloatField
      FieldName = 'INIDTOTALFEE'
      Origin = 'PRJLCLDATA."DAYFEEDTL.DB".TOTALFEE'
      DisplayFormat = '#0.0000'
    end
  end
end