dfm_smonth.dfm

仓库管理系统 仓库管理系统

object dfmsmonth: Tdfmsmonth
  Left = 64
  Top = 105
  Width = 677
  Height = 426
  Caption = #38144#21806#26376#20998#26512
  Color = clBtnFace
  Font.Charset = GB2312_CHARSET
  Font.Color = clWindowText
  Font.Height = -12
  Font.Name = #23435#20307
  Font.Style = []
  FormStyle = fsMDIChild
  OldCreateOrder = False
  Position = poScreenCenter
  Visible = True
  OnClose = FormClose
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 12
  object StatusBar1: TStatusBar
    Left = 0
    Top = 380
    Width = 669
    Height = 19
    Panels = <>
    SimplePanel = False
  end
  object Panel2: TPanel
    Left = 0
    Top = 302
    Width = 669
    Height = 78
    Align = alBottom
    BevelInner = bvLowered
    TabOrder = 1
    object quitbtn: TBitBtn
      Left = 480
      Top = 26
      Width = 77
      Height = 25
      Caption = #26597#35810
      TabOrder = 0
      OnClick = quitbtnClick
      Glyph.Data = {
        DE010000424DDE01000000000000760000002800000024000000120000000100
        0400000000006801000000000000000000001000000000000000000000000000
        80000080000000808000800000008000800080800000C0C0C000808080000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00388888888877
        F7F787F8888888888333333F00004444400888FFF444448888888888F333FF8F
        000033334D5007FFF4333388888888883338888F0000333345D50FFFF4333333
        338F888F3338F33F000033334D5D0FFFF43333333388788F3338F33F00003333
        45D50FEFE4333333338F878F3338F33F000033334D5D0FFFF43333333388788F
        3338F33F0000333345D50FEFE4333333338F878F3338F33F000033334D5D0FFF
        F43333333388788F3338F33F0000333345D50FEFE4333333338F878F3338F33F
        000033334D5D0EFEF43333333388788F3338F33F0000333345D50FEFE4333333
        338F878F3338F33F000033334D5D0EFEF43333333388788F3338F33F00003333
        4444444444333333338F8F8FFFF8F33F00003333333333333333333333888888
        8888333F00003333330000003333333333333FFFFFF3333F00003333330AAAA0
        333333333333888888F3333F00003333330000003333333333338FFFF8F3333F
        0000}
      NumGlyphs = 2
    end
    object GroupBox1: TGroupBox
      Left = 8
      Top = 3
      Width = 425
      Height = 68
      Caption = #26597#35810#26465#20214
      TabOrder = 1
      object Label1: TLabel
        Left = 8
        Top = 24
        Width = 36
        Height = 12
        Caption = #26085#26399#65306
      end
      object Label2: TLabel
        Left = 152
        Top = 24
        Width = 12
        Height = 12
        Caption = #33267
      end
      object Label4: TLabel
        Left = 286
        Top = 24
        Width = 24
        Height = 12
        Caption = #37096#38376
      end
      object Label3: TLabel
        Left = 153
        Top = 46
        Width = 36
        Height = 12
        Caption = #27454#24335#30721
      end
      object Label5: TLabel
        Left = 10
        Top = 46
        Width = 24
        Height = 12
        Caption = #21697#29260
      end
      object DateTimePicker1: TDateTimePicker
        Left = 48
        Top = 20
        Width = 97
        Height = 20
        CalAlignment = dtaLeft
        Date = 37323.7144625579
        Time = 37323.7144625579
        DateFormat = dfShort
        DateMode = dmComboBox
        Kind = dtkDate
        ParseInput = False
        TabOrder = 0
      end
      object DateTimePicker2: TDateTimePicker
        Left = 170
        Top = 20
        Width = 97
        Height = 20
        CalAlignment = dtaLeft
        Date = 37323.7144625579
        Time = 37323.7144625579
        DateFormat = dfShort
        DateMode = dmComboBox
        Kind = dtkDate
        ParseInput = False
        TabOrder = 1
      end
      object Edit1: TEdit
        Left = 193
        Top = 42
        Width = 81
        Height = 20
        TabOrder = 2
      end
      object Edit3: TEdit
        Left = 47
        Top = 42
        Width = 81
        Height = 20
        TabOrder = 3
      end
      object ComboBox1: TComboBox
        Left = 317
        Top = 20
        Width = 89
        Height = 20
        ItemHeight = 12
        TabOrder = 4
      end
    end
  end
  object Panel3: TPanel
    Left = 0
    Top = 0
    Width = 217
    Height = 302
    Align = alLeft
    Caption = 'Panel3'
    TabOrder = 2
    object DBGrid1: TDBGrid
      Left = 1
      Top = 1
      Width = 215
      Height = 300
      Align = alClient
      DataSource = DataSource1
      TabOrder = 0
      TitleFont.Charset = GB2312_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -12
      TitleFont.Name = #23435#20307
      TitleFont.Style = []
      OnDrawColumnCell = DBGrid1DrawColumnCell
      OnExit = DBGrid1Exit
      OnTitleClick = DBGrid1TitleClick
      Columns = <
        item
          Expanded = False
          Title.Alignment = taCenter
          Title.Caption = #25490#21517
          Width = 31
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'edate'
          Title.Alignment = taCenter
          Width = 60
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'esl'
          Title.Alignment = taCenter
          Width = 41
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'esjje'
          Title.Alignment = taCenter
          Width = 50
          Visible = True
        end>
    end
  end
  object DBChart2: TDBChart
    Left = 217
    Top = 0
    Width = 452
    Height = 302
    BackWall.Brush.Color = clWhite
    BackWall.Brush.Style = bsClear
    Title.Text.Strings = (
      #26376#38144#21806#20998#26512)
    BottomAxis.Title.Caption = #26376#20221
    LeftAxis.Title.Caption = #38144#21806#39069
    Legend.TextStyle = ltsRightValue
    View3D = False
    Align = alClient
    TabOrder = 3
    object Series2: TBarSeries
      ColorEachPoint = True
      Marks.ArrowLength = 8
      Marks.Style = smsValue
      Marks.Visible = True
      DataSource = ADOQuery1
      SeriesColor = clRed
      XLabelsSource = 'edate'
      BarStyle = bsRectGradient
      XValues.DateTime = False
      XValues.Name = 'X'
      XValues.Multiplier = 1
      XValues.Order = loAscending
      YValues.DateTime = False
      YValues.Name = 'Bar'
      YValues.Multiplier = 1
      YValues.Order = loNone
      YValues.ValueSource = 'esjje'
    end
  end
  object ADOQuery1: TADOQuery
    Connection = dmRainbowMIS.adopos
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'SELECT trim(str(year(t_saledet.rq)))+'#39'-'#39'+IIf(Len(trim(Str(Month(' +
        't_saledet.rq))))<2,"0"+trim(Str(Month(t_saledet.rq))),trim(Str(M' +
        'onth(t_saledet.rq)))) AS edate, sum([t_saledet].[sl]) AS esl, su' +
        'm([t_saledet].[sjje]) AS esjje'
      'FROM t_saledet,t_ware'
      'where t_saledet.spbh=t_ware.spbh'
      
        'GROUP BY trim(str(year(t_saledet.rq)))+'#39'-'#39'+IIf(Len(trim(Str(Mont' +
        'h(t_saledet.rq))))<2,"0"+trim(Str(Month(t_saledet.rq))),trim(Str' +
        '(Month(t_saledet.rq))))')
    Left = 128
    Top = 40
    object ADOQuery1edate: TWideStringField
      DisplayLabel = #26376#20221
      FieldName = 'edate'
      Size = 255
    end
    object ADOQuery1esl: TFloatField
      DisplayLabel = #25968#37327
      FieldName = 'esl'
    end
    object ADOQuery1esjje: TFloatField
      DisplayLabel = #37329#39069
      FieldName = 'esjje'
    end
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 88
    Top = 40
  end
  object atblbranch: TADOTable
    Connection = dmRainbowMIS.adopos
    TableName = 't_branch'
    Left = 128
    Top = 80
  end
  object atblslpara: TADOTable
    Connection = dmRainbowMIS.adopos
    TableName = 't_salepara'
    Left = 128
    Top = 112
  end
end