uwlzxqtj.dfm

工廠採購管理系統

        D7D7D75E5EE8E8E8E8E8E881E8E8E8E8E8E8E88181E8E8E8E8E8E85E5E5E5E5E
        5E5E5E5EE8E8E8E8E8E8E8818181818181818181E8E8E8E8E8E8E8E8E8E8E8E8
        E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8}
      NumGlyphs = 2
    end
    object RzBitBtn4: TRzBitBtn
      Left = 224
      Top = 8
      Width = 73
      Caption = #20851#38381
      TabOrder = 3
      OnClick = RzBitBtn4Click
      Glyph.Data = {
        36060000424D3606000000000000360400002800000020000000100000000100
        08000000000000020000330B0000330B00000001000000000000000000003300
        00006600000099000000CC000000FF0000000033000033330000663300009933
        0000CC330000FF33000000660000336600006666000099660000CC660000FF66
        000000990000339900006699000099990000CC990000FF99000000CC000033CC
        000066CC000099CC0000CCCC0000FFCC000000FF000033FF000066FF000099FF
        0000CCFF0000FFFF000000003300330033006600330099003300CC003300FF00
        330000333300333333006633330099333300CC333300FF333300006633003366
        33006666330099663300CC663300FF6633000099330033993300669933009999
        3300CC993300FF99330000CC330033CC330066CC330099CC3300CCCC3300FFCC
        330000FF330033FF330066FF330099FF3300CCFF3300FFFF3300000066003300
        66006600660099006600CC006600FF0066000033660033336600663366009933
        6600CC336600FF33660000666600336666006666660099666600CC666600FF66
        660000996600339966006699660099996600CC996600FF99660000CC660033CC
        660066CC660099CC6600CCCC6600FFCC660000FF660033FF660066FF660099FF
        6600CCFF6600FFFF660000009900330099006600990099009900CC009900FF00
        990000339900333399006633990099339900CC339900FF339900006699003366
        99006666990099669900CC669900FF6699000099990033999900669999009999
        9900CC999900FF99990000CC990033CC990066CC990099CC9900CCCC9900FFCC
        990000FF990033FF990066FF990099FF9900CCFF9900FFFF99000000CC003300
        CC006600CC009900CC00CC00CC00FF00CC000033CC003333CC006633CC009933
        CC00CC33CC00FF33CC000066CC003366CC006666CC009966CC00CC66CC00FF66
        CC000099CC003399CC006699CC009999CC00CC99CC00FF99CC0000CCCC0033CC
        CC0066CCCC0099CCCC00CCCCCC00FFCCCC0000FFCC0033FFCC0066FFCC0099FF
        CC00CCFFCC00FFFFCC000000FF003300FF006600FF009900FF00CC00FF00FF00
        FF000033FF003333FF006633FF009933FF00CC33FF00FF33FF000066FF003366
        FF006666FF009966FF00CC66FF00FF66FF000099FF003399FF006699FF009999
        FF00CC99FF00FF99FF0000CCFF0033CCFF0066CCFF0099CCFF00CCCCFF00FFCC
        FF0000FFFF0033FFFF0066FFFF0099FFFF00CCFFFF00FFFFFF00000080000080
        000000808000800000008000800080800000C0C0C00080808000191919004C4C
        4C00B2B2B200E5E5E500C8AC2800E0CC6600F2EABF00B59B2400D8E9EC009933
        6600D075A300ECC6D900646F710099A8AC00E2EFF10000000000000000000000
        0000000000000000000000000000000000000000000000000000000000000000
        0000000000000000000000000000000000000000000000000000E8E8E8E8E8E8
        E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8
        E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8
        E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E809090909E8
        E8E8E8E809090909E8E8E881818181E8E8E8E8E881818181E8E8E80910101009
        E8E8E80910101009E8E8E881ACACAC81E8E8E881ACACAC81E8E8E8E809101010
        09E80910101009E8E8E8E8E881ACACAC81E881ACACAC81E8E8E8E8E8E8091010
        100910101009E8E8E8E8E8E8E881ACACAC81ACACAC81E8E8E8E8E8E8E8E80910
        1010101009E8E8E8E8E8E8E8E8E881ACACACACAC81E8E8E8E8E8E8E8E8E8E809
        10101009E8E8E8E8E8E8E8E8E8E8E881ACACAC81E8E8E8E8E8E8E8E8E8E80910
        1010101009E8E8E8E8E8E8E8E8E881ACACACACAC81E8E8E8E8E8E8E8E8091010
        100910101009E8E8E8E8E8E8E881ACACAC81ACACAC81E8E8E8E8E8E809101010
        09E80910101009E8E8E8E8E881ACACAC81E881ACACAC81E8E8E8E80910101009
        E8E8E80910101009E8E8E881ACACAC81E8E8E881ACACAC81E8E8E809090909E8
        E8E8E8E809090909E8E8E881818181E8E8E8E8E881818181E8E8E8E8E8E8E8E8
        E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8
        E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8E8}
      NumGlyphs = 2
    end
    object dtp1: TRzDateTimePicker
      Left = 312
      Top = 8
      Width = 97
      Height = 24
      Date = 38813.675378981480000000
      Time = 38813.675378981480000000
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
      TabOrder = 4
      OnExit = dtp1Exit
    end
    object dtp2: TRzDateTimePicker
      Left = 440
      Top = 8
      Width = 97
      Height = 24
      Date = 38813.675460578710000000
      Time = 38813.675460578710000000
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
      TabOrder = 5
      OnExit = dtp2Exit
    end
    object Edit1: TEdit
      Left = 616
      Top = 8
      Width = 177
      Height = 24
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
      TabOrder = 6
      OnChange = Edit1Change
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 41
    Width = 869
    Height = 403
    Align = alClient
    BevelOuter = bvNone
    TabOrder = 1
    object DBGrid1: TDBGrid
      Left = 0
      Top = 0
      Width = 869
      Height = 403
      Align = alClient
      DataSource = DataSource1
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
      ReadOnly = True
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -13
      TitleFont.Name = 'MS Sans Serif'
      TitleFont.Style = []
      OnDrawColumnCell = DBGrid1DrawColumnCell
      OnTitleClick = DBGrid1TitleClick
      Columns = <
        item
          Expanded = False
          FieldName = #29289#26009#20195#30721
          Width = 68
          Visible = True
        end
        item
          Expanded = False
          FieldName = #29289#26009#21517#31216
          Width = 251
          Visible = True
        end
        item
          Expanded = False
          FieldName = #39068#33394
          Width = 67
          Visible = True
        end
        item
          Expanded = False
          FieldName = #33394#21495
          Width = 51
          Visible = True
        end
        item
          Expanded = False
          FieldName = #21333#20301
          Visible = True
        end
        item
          Expanded = False
          FieldName = #38656#27714#37327
          Width = 77
          Visible = True
        end
        item
          Expanded = False
          FieldName = #29992#24211#23384#37327
          Width = 70
          Visible = True
        end
        item
          Expanded = False
          FieldName = #35745#21010#37319#36141#37327
          Width = 76
          Visible = True
        end>
    end
  end
  object ADOQuery1: TADOQuery
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'SELECT  '
      '      cgwl.wldm AS '#29289#26009#20195#30721', wldmk.wlmc AS '#29289#26009#21517#31216', '
      '      wldmk.wlys AS '#39068#33394', wldmk.wlsh AS '#33394#21495', wldmk.dw AS '#21333#20301', '
      '      SUM(cgwl.xql) AS '#38656#27714#37327', '
      
        '      SUM(cgwl.ykcl) AS '#29992#24211#23384#37327', SUM(cgwl.jhcgl) as '#35745#21010#37319#36141#37327',PYM AS '#21161#35760 +
        #30721
      'FROM cgwl,wldmk where cgwl.wldm=wldmk.wldm'
      'GROUP BY cgwl.wldm, wldmk.wlmc, wldmk.wlys, wldmk.wlsh, '
      '      wldmk.dw,pym'
      'ORDER BY pym')
    Left = 424
    Top = 224
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 320
    Top = 208
  end
end