xmcbfxrep.dfm

来自「日昌餐饮管理系统是用Delphi7+SQL写的管理系统」· DFM 代码 · 共 1,784 行 · 第 1/4 页

DFM
1,784
字号
          Width = 40
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            2283.35416666667
            13.2291666666667
            105.833333333333)
          Alignment = taRightJustify
          AlignToBand = False
          AutoSize = True
          AutoStretch = False
          Color = clWhite
          DataSet = ADODataSet1
          DataField = #24635#20154#25968
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRDBText16: TQRDBText
          Left = 908
          Top = 5
          Width = 42
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            2402.41666666667
            13.2291666666667
            111.125)
          Alignment = taRightJustify
          AlignToBand = False
          AutoSize = False
          AutoStretch = False
          Color = clWhite
          DataSet = ADODataSet1
          DataField = #20154#22343#20132#26131#39069
          Mask = '#.0'
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRDBText17: TQRDBText
          Left = 953
          Top = 5
          Width = 33
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            2521.47916666667
            13.2291666666667
            87.3125)
          Alignment = taRightJustify
          AlignToBand = False
          AutoSize = False
          AutoStretch = False
          Color = clWhite
          DataSet = ADODataSet1
          DataField = #39033#30446#21024#38500#31508#25968
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRDBText18: TQRDBText
          Left = 989
          Top = 5
          Width = 42
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            2616.72916666667
            13.2291666666667
            111.125)
          Alignment = taRightJustify
          AlignToBand = False
          AutoSize = False
          AutoStretch = False
          Color = clWhite
          DataSet = ADODataSet1
          DataField = #39033#30446#21024#38500#37329#39069
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRDBText19: TQRDBText
          Left = 1034
          Top = 5
          Width = 30
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            2735.79166666667
            13.2291666666667
            79.375)
          Alignment = taRightJustify
          AlignToBand = False
          AutoSize = False
          AutoStretch = False
          Color = clWhite
          DataSet = ADODataSet1
          DataField = #20132#26131#21024#38500#31508#25968
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRDBText20: TQRDBText
          Left = 1067
          Top = 5
          Width = 44
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            2823.10416666667
            13.2291666666667
            116.416666666667)
          Alignment = taRightJustify
          AlignToBand = False
          AutoSize = False
          AutoStretch = False
          Color = clWhite
          DataSet = ADODataSet1
          DataField = #20132#26131#21024#38500#37329#39069
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
      end
      object SummaryBand1: TQRBand
        Left = 4
        Top = 172
        Width = 1115
        Height = 133
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        AlignToBottom = False
        Color = clWhite
        ForceNewColumn = False
        ForceNewPage = False
        Size.Values = (
          351.895833333333
          2950.10416666667)
        BandType = rbSummary
        object QRLabel19: TQRLabel
          Left = 8
          Top = 14
          Width = 67
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            21.1666666666667
            37.0416666666667
            177.270833333333)
          Alignment = taLeftJustify
          AlignToBand = False
          AutoSize = True
          AutoStretch = False
          Caption = #24635#35745'('#37329#39069')'
          Color = clWhite
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRLabel20: TQRLabel
          Left = 15
          Top = 40
          Width = 190
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            39.6875
            105.833333333333
            502.708333333333)
          Alignment = taLeftJustify
          AlignToBand = False
          AutoSize = True
          AutoStretch = False
          Caption = #35828#26126#65306#26399#21021#32467#23384'='#19978#26399#26411#23454#38469#30424#23384
          Color = clWhite
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRLabel21: TQRLabel
          Left = 54
          Top = 62
          Width = 294
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            142.875
            164.041666666667
            777.875)
          Alignment = taLeftJustify
          AlignToBand = False
          AutoSize = True
          AutoStretch = False
          Caption = #36827#36135#12289#35843#25320#20837#12289#35843#25320#20986'='#30001#20154#24037#27599#26085#26681#25454#25910#36135#21333#24405#20837
          Color = clWhite
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRLabel22: TQRLabel
          Left = 400
          Top = 41
          Width = 322
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            1058.33333333333
            108.479166666667
            851.958333333333)
          Alignment = taLeftJustify
          AlignToBand = False
          AutoSize = True
          AutoStretch = False
          Caption = #23454#38469#29992#37327'='#65288#26399#21021#32467#23384'+'#36827#36135'+'#35843#25320#20837#65289'-'#35843#25320#20986'-'#23454#38469#30424#23384
          Color = clWhite
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRLabel23: TQRLabel
          Left = 400
          Top = 60
          Width = 255
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            1058.33333333333
            158.75
            674.6875)
          Alignment = taLeftJustify
          AlignToBand = False
          AutoSize = True
          AutoStretch = False
          Caption = #23454#38469#30424#23384'='#30001#20154#24037#25353#35268#23450#26102#27573#26681#25454#30424#28857#34920#24405#20837
          Color = clWhite
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRLabel24: TQRLabel
          Left = 54
          Top = 82
          Width = 262
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            142.875
            216.958333333333
            693.208333333333)
          Alignment = taLeftJustify
          AlignToBand = False
          AutoSize = True
          AutoStretch = False
          Caption = #29702#35770#29992#37327'='#31995#32479#20869#22522#30784#29702#35770#25104#26412#25968#25454'*'#38144#21806#25968#37327
          Color = clWhite
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRLabel27: TQRLabel
          Left = 401
          Top = 82
          Width = 145
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            1060.97916666667
            216.958333333333
            383.645833333333)
          Alignment = taLeftJustify
          AlignToBand = False
          AutoSize = True
          AutoStretch = False
          Caption = #24046#24322'='#23454#38469#30424#23384'-'#29702#35770#32467#23384
          Color = clWhite
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRLabel28: TQRLabel
          Left = 54
          Top = 103
          Width = 322
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            142.875
            272.520833333333
            851.958333333333)
          Alignment = taLeftJustify
          AlignToBand = False
          AutoSize = True
          AutoStretch = False
          Caption = #29702#35770#32467#23384'='#65288#26399#21021#32467#23384'+'#36827#36135'+'#35843#25320#20837#65289'-'#35843#25320#20986'-'#29702#35770#29992#37327
          Color = clWhite
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
        object QRLabel30: TQRLabel
          Left = 401
          Top = 103
          Width = 132
          Height = 14
          Frame.Color = clBlack
          Frame.DrawTop = False
          Frame.DrawBottom = False
          Frame.DrawLeft = False
          Frame.DrawRight = False
          Size.Values = (
            37.0416666666667
            1060.97916666667
            272.520833333333
            349.25)
          Alignment = taLeftJustify
          AlignToBand = False
          AutoSize = True
          AutoStretch = False
          Caption = #24223#24323'/'#25253#25439'='#30001#20154#24037#24405#20837
          Color = clWhite
          Transparent = False
          WordWrap = True
          FontSize = 10
        end
      end
    end
  end
  object DataSource1: TDataSource
    DataSet = ADODataSet1
    Left = 384
    Top = 96
  end
  object ADODataSet1: TADODataSet
    Connection = mainForm.RJSADO
    CursorType = ctStatic
    CommandText = 
      'select th,sum(je) as "'#27880#20876#38144#21806'",'#13#10'"'#20928#38144#21806'"        =(Select sum(je) from' +
      ' dcd where th=a.th and  zfbz=0 and fkbz=1),'#13#10#13#10'"'#26089#29677#27880#20876'"    =(Selec' +
      't sum(je) from dcd where th=a.th and bc='#39'1'#39' and zfbz=0),'#13#10'"'#26089#29677#20928#38144#21806 +
      '"=(Select sum(je) from dcd where th=a.th and bc='#39'1'#39' and zfbz=0 a' +
      'nd fkbz=1),'#13#10'"'#26089#29677#20132#26131#25968'"=(Select count(djh) from dcd where th=a.th a' +
      'nd bc='#39'1'#39'),'#13#10'"'#26089#29677#23458#20154#25968'"=(Select count(distinct djh) from dcd where ' +
      'th=a.th and bc='#39'1'#39'),'#13#10#13#10'"'#26202#29677#27880#20876'"    =(Select sum(je) from dcd wher' +
      'e th=a.th and bc='#39'2'#39' and zfbz=0),'#13#10'"'#26202#29677#20928#38144#21806'"=(Select sum(je) from ' +
      'dcd where th=a.th and bc='#39'2'#39' and zfbz=0 and fkbz=1),'#13#10'"'#26202#29677#20132#26131#25968'"=(S' +
      'elect count(djh) from dcd where th=a.th and bc='#39'2'#39'),'#13#10'"'#26202#29677#23458#20154#25968'"=(S' +
      'elect count(distinct djh) from dcd where th=a.th and bc='#39'2'#39'),'#13#10#13 +
      #10'"'#37202#21543#27880#20876'"=0,'#13#10'"'#37202#21543#20928#38144#21806'"=0,'#13#10'"'#37202#21543#20132#26131#25968'"=0,'#13#10'"'#37202#21543#23458#20154#20154#25968'"=0,'#13#10'"'#37202#21543#20154#22343#28040#36153#39069'"=0'#13#10#13#10 +
      'from dcd a'#13#10'where th is not Null and rq between :cs1 and :cs2'#13#10'g' +
      'roup by th'#13#10#13#10#13#10#13#10#13#10' '
    Parameters = <
      item
        Name = 'cs1'
        Attributes = [paNullable]
        DataType = ftDateTime
        Precision = 16
        Size = 16
        Value = Null
      end
      item
        Name = 'cs2'
        Attributes = [paNullable]
        DataType = ftDateTime
        Precision = 16
        Size = 16
        Value = Null
      end>
    Left = 344
    Top = 96
  end
end

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?