unit_compmana.dfm

delphi开发的中国移动大客户管理系统,后台数据库为oracle

          NumGlyphs = 2
          TabOrder = 18
          OnClick = FlatButton2Click
        end
        object FlatMemoIdeaContent: TFlatMemo
          Tag = 1
          Left = 359
          Top = 227
          Width = 291
          Height = 134
          ColorFlat = clBtnFace
          ParentColor = True
          MaxLength = 60
          TabOrder = 3
        end
        object FlatComboBoxModiContentT: TFlatComboBox
          Tag = 1
          Left = 264
          Top = 107
          Width = 41
          Height = 22
          Color = clWindow
          ItemHeight = 14
          TabOrder = 19
          Visible = False
          ItemIndex = -1
        end
        object FlatEditReg_Date: TFlatEdit
          Tag = 1
          Left = 361
          Top = 169
          Width = 127
          Height = 20
          Hint = '时间格式为:YYYY-MM-DD'
          ColorFlat = clBtnFace
          ParentColor = True
          MaxLength = 10
          ParentShowHint = False
          ShowHint = True
          TabOrder = 20
          OnExit = FlatEditReg_DateExit
        end
        object FlatEditWk_No: TFlatEdit
          Tag = 1
          Left = 546
          Top = 169
          Width = 103
          Height = 20
          ColorFlat = clBtnFace
          ParentColor = True
          Enabled = False
          MaxLength = 9
          TabOrder = 21
          OnExit = FlatEditBeginDateExit
        end
        object FlatComboBoxModiContentQ5T: TFlatComboBox
          Left = 245
          Top = 74
          Width = 60
          Height = 22
          Color = clWindow
          ItemHeight = 14
          TabOrder = 22
          Visible = False
          ItemIndex = -1
          OnChange = FlatEditCompName4QChange
        end
      end
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 401
    Width = 673
    Height = 41
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 1
    object FlatButtonInsert: TFlatButton
      Tag = 1
      Left = 57
      Top = 10
      Width = 81
      Height = 25
      Caption = '新增'
      Glyph.Data = {
        76010000424D7601000000000000760000002800000020000000100000000100
        0400000000000001000000000000000000001000000010000000000000000000
        800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
        33333333FF33333333FF333993333333300033377F3333333777333993333333
        300033F77FFF3333377739999993333333333777777F3333333F399999933333
        33003777777333333377333993333333330033377F3333333377333993333333
        3333333773333333333F333333333333330033333333F33333773333333C3333
        330033333337FF3333773333333CC333333333FFFFF77FFF3FF33CCCCCCCCCC3
        993337777777777F77F33CCCCCCCCCC3993337777777777377333333333CC333
        333333333337733333FF3333333C333330003333333733333777333333333333
        3000333333333333377733333333333333333333333333333333}
      Layout = blGlyphLeft
      NumGlyphs = 2
      TabOrder = 0
      OnClick = FlatButtonInsertClick
    end
    object FlatButtonUpdate: TFlatButton
      Tag = 2
      Left = 147
      Top = 10
      Width = 81
      Height = 25
      Caption = '修改'
      Glyph.Data = {
        76010000424D7601000000000000760000002800000020000000100000000100
        0400000000000001000000000000000000001000000010000000000000000000
        800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333000000
        000033333377777777773333330FFFFFFFF03FF3FF7FF33F3FF700300000FF0F
        00F077F777773F737737E00BFBFB0FFFFFF07773333F7F3333F7E0BFBF000FFF
        F0F077F3337773F3F737E0FBFBFBF0F00FF077F3333FF7F77F37E0BFBF00000B
        0FF077F3337777737337E0FBFBFBFBF0FFF077F33FFFFFF73337E0BF0000000F
        FFF077FF777777733FF7000BFB00B0FF00F07773FF77373377373330000B0FFF
        FFF03337777373333FF7333330B0FFFF00003333373733FF777733330B0FF00F
        0FF03333737F37737F373330B00FFFFF0F033337F77F33337F733309030FFFFF
        00333377737FFFFF773333303300000003333337337777777333}
      Layout = blGlyphLeft
      NumGlyphs = 2
      TabOrder = 2
      OnClick = FlatButtonUpdateClick
    end
    object FlatButtonDelete: TFlatButton
      Tag = 3
      Left = 239
      Top = 10
      Width = 81
      Height = 25
      Caption = '删除'
      Glyph.Data = {
        76010000424D7601000000000000760000002800000020000000100000000100
        0400000000000001000000000000000000001000000010000000000000000000
        800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
        333333333333333333FF33333333333330003333333333333777333333333333
        300033FFFFFF3333377739999993333333333777777F3333333F399999933333
        3300377777733333337733333333333333003333333333333377333333333333
        3333333333333333333F333333333333330033333F33333333773333C3333333
        330033337F3333333377333CC3333333333333F77FFFFFFF3FF33CCCCCCCCCC3
        993337777777777F77F33CCCCCCCCCC399333777777777737733333CC3333333
        333333377F33333333FF3333C333333330003333733333333777333333333333
        3000333333333333377733333333333333333333333333333333}
      Layout = blGlyphLeft
      NumGlyphs = 2
      TabOrder = 3
      OnClick = FlatButtonDeleteClick
    end
    object FlatButtonSave: TFlatButton
      Tag = 4
      Left = 330
      Top = 10
      Width = 95
      Height = 25
      Caption = '保存'
      Glyph.Data = {
        76010000424D7601000000000000760000002800000020000000100000000100
        04000000000000010000120B0000120B00001000000000000000000000000000
        800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
        333333FFFFFFFFFFFFF33000077777770033377777777777773F000007888888
        00037F3337F3FF37F37F00000780088800037F3337F77F37F37F000007800888
        00037F3337F77FF7F37F00000788888800037F3337777777337F000000000000
        00037F3FFFFFFFFFFF7F00000000000000037F77777777777F7F000FFFFFFFFF
        00037F7F333333337F7F000FFFFFFFFF00037F7F333333337F7F000FFFFFFFFF
        00037F7F333333337F7F000FFFFFFFFF00037F7F333333337F7F000FFFFFFFFF
        00037F7F333333337F7F000FFFFFFFFF07037F7F33333333777F000FFFFFFFFF
        0003737FFFFFFFFF7F7330099999999900333777777777777733}
      Layout = blGlyphLeft
      NumGlyphs = 2
      TabOrder = 1
      OnClick = FlatButtonSaveClick
    end
    object FlatButtonCancel: TFlatButton
      Tag = 5
      Left = 432
      Top = 10
      Width = 81
      Height = 25
      Caption = '取消'
      Glyph.Data = {
        76010000424D7601000000000000760000002800000020000000100000000100
        04000000000000010000130B0000130B00001000000000000000000000000000
        800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
        3333333333FFFFF3333333333999993333333333F77777FFF333333999999999
        3333333777333777FF33339993707399933333773337F3777FF3399933000339
        9933377333777F3377F3399333707333993337733337333337FF993333333333
        399377F33333F333377F993333303333399377F33337FF333373993333707333
        333377F333777F333333993333101333333377F333777F3FFFFF993333000399
        999377FF33777F77777F3993330003399993373FF3777F37777F399933000333
        99933773FF777F3F777F339993707399999333773F373F77777F333999999999
        3393333777333777337333333999993333333333377777333333}
      Layout = blGlyphLeft
      NumGlyphs = 2
      TabOrder = 4
      OnClick = FlatButtonCancelClick
    end
    object FlatButtonClose: TFlatButton
      Left = 520
      Top = 10
      Width = 81
      Height = 25
      Caption = '关闭'
      Glyph.Data = {
        DE010000424DDE01000000000000760000002800000024000000120000000100
        0400000000006801000000000000000000001000000010000000000000000000
        80000080000000808000800000008000800080800000C0C0C000808080000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00388888888877
        F7F787F8888888888333333F00004444400888FFF444448888888888F333FF8F
        000033334D5007FFF4333388888888883338888F0000333345D50FFFF4333333
        338F888F3338F33F000033334D5D0FFFF43333333388788F3338F33F00003333
        45D50FEFE4333333338F878F3338F33F000033334D5D0FFFF43333333388788F
        3338F33F0000333345D50FEFE4333333338F878F3338F33F000033334D5D0FFF
        F43333333388788F3338F33F0000333345D50FEFE4333333338F878F3338F33F
        000033334D5D0EFEF43333333388788F3338F33F0000333345D50FEFE4333333
        338F878F3338F33F000033334D5D0EFEF43333333388788F3338F33F00003333
        4444444444333333338F8F8FFFF8F33F00003333333333333333333333888888
        8888333F00003333330000003333333333333FFFFFF3333F00003333330AAAA0
        333333333333888888F3333F00003333330000003333333333338FFFF8F3333F
        0000}
      Layout = blGlyphLeft
      NumGlyphs = 2
      TabOrder = 5
      OnClick = FlatButtonCloseClick
    end
  end
  object QuerySequ: TQuery
    DatabaseName = 'db_vipdl'
    Left = 302
    Top = 291
  end
  object QueryCompetitor: TQuery
    DatabaseName = 'db_vipdl'
    SQL.Strings = (
      'Select C.CompCode As CompCode,A.CityName As 地市,'
      'B.Home_Name As 局向,C.CompName As 对手名称,C.Remark as 备注 '
      ' From T_D_City A,T_D_County B,T_F_Competitor C'
      
        'Where A.CityNo=B.CityNo And C.Off_No_Home=B.Off_No_Home And C.Ci' +
        'tyNo=A.CityNo '
      'And C.CityNo=:PS_CityNo And C.Off_No_Home=:PS_CountyNo'
      'Order by CompCode Asc')
    Left = 118
    Top = 108
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'PS_CityNo'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'PS_CountyNo'
        ParamType = ptUnknown
      end>
  end
  object DataSourceCompetitor: TDataSource
    DataSet = QueryCompetitor
    OnDataChange = DataSourceCompetitorDataChange
    Left = 202
    Top = 129
  end
  object QueryCompName: TQuery
    DatabaseName = 'db_vipdl'
    SQL.Strings = (
      'Select CompCode,CompName From T_F_Competitor C'
      'Where C.CityNo=:PS_CityNo And C.Off_No_Home=:PS_CountyNo'
      'Order by CompCode Asc')
    Left = 462
    Top = 241
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'PS_CityNo'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'PS_CountyNo'
        ParamType = ptUnknown
      end>
  end
  object QueryCompPolicy: TQuery
    DatabaseName = 'db_vipdl'
    SQL.Strings = (
      
        'Select P.PolicyCode As POLICYCODE,C.CompName As 对手名称,P.Polic' +
        'y As 营销策略标题,P.Begindate As 开始时间,P.EndDate As 结束时间,' +
        'P.Remark As 经营策略内容'
      'From T_F_CompetitorPolicy P,T_F_Competitor C '
      
        'Where P.CompCode=C.CompCode And P.CityNo=:PS_CityNo And P.Off_No' +
        '_Home=:PS_CountyNo')
    Left = 48
    Top = 182
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'PS_CityNo'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'PS_CountyNo'
        ParamType = ptUnknown
      end>
  end
  object DataSourceCompPolicy: TDataSource
    DataSet = QueryCompPolicy
    OnDataChange = DataSourceCompPolicyDataChange
    Left = 173
    Top = 193
  end
  object QueryIdeaModif: TQuery
    DatabaseName = 'db_vipdl'
    SQL.Strings = (
      
        'Select I.MotifCode As MotifCode,A.CityName As 地市,B.Home_Name A' +
        's 局向,I.MotifContent As 主题内容,I.Remark As 备注 '
      'From T_D_City A,T_D_County B,T_F_IdeaMotif I'
      
        'Where A.CityNo=B.CityNo And I.Off_No_Home=B.Off_No_Home And I.Ci' +
        'tyNo=A.CityNo '
      'And I.CityNo=:PS_CityNo And I.Off_No_Home=:PS_CountyNo'
      'Order by I.MotifCode Asc')
    Left = 369
    Top = 107
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'PS_CityNo'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'PS_CountyNo'
        ParamType = ptUnknown
      end>
  end
  object DataSourceIdeaModif: TDataSource
    DataSet = QueryIdeaModif
    OnDataChange = DataSourceIdeaModifDataChange
    Left = 292
    Top = 178
  end
  object QueryCompetitorUser: TQuery
    DatabaseName = 'db_vipdl'
    SQL.Strings = (
      'Select U.USERCODE As USERCODE,C.CompName As 对手名称,U.SID '
      
        'As 电话号码,U.Name As 用户姓名,U.Addr As 联系地址,U.Phone As 联' +
        '系电话,'
      
        'U.Email As 电子邮件,U.Job As 工作单位,U.mobilPhone As 移动手机号' +
        '码,U.Remark As 备注,U.WK_NO As 工号,U.Reg_Date As 登记时间'
      'From T_F_CompetitorUser U,T_F_Competitor C '
      
        'Where U.CompCode=C.CompCode And U.CityNo=:PS_CityNo And U.Off_No' +
        '_Home=:PS_CountyNo')
    Left = 56
    Top = 236
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'PS_CityNo'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'PS_CountyNo'
        ParamType = ptUnknown
      end>
  end
  object DataSourceCompetitorUser: TDataSource
    DataSet = QueryCompetitorUser
    OnDataChange = DataSourceCompetitorUserDataChange
    Left = 218
    Top = 246
  end
  object QueryCompIdea: TQuery
    DatabaseName = 'db_vipdl'
    SQL.Strings = (
      'Select C.IdeaCode As IDEACODE,C.Reg_Date As 登记时间,U.SID '
      
        'As 用户号码,I.MotifContent As 意见主题,C.IdeaContent As 建议内容' +
        ',U.Name As 用户姓名,U.Addr As 联系地址,U.Phone As 联系电话,'
      
        'U.Email As 电子邮件,U.Job As 工作单位,U.MobilPhone As 移动手机号' +
        '码,U.Wk_No As 工号'
      'From T_F_CompetitorUser U,T_F_CompIdea C,T_F_IdeaMotif I '
      'Where C.SID=U.SID(+) And C.MotifCode=I.MotifCode(+)'
      '')
    Left = 114
    Top = 282
  end
  object DataSourceCompIdea: TDataSource
    DataSet = QueryCompIdea
    OnDataChange = DataSourceCompIdeaDataChange
    Left = 205
    Top = 315
  end
  object QueryIdeaModif6: TQuery
    DatabaseName = 'db_vipdl'
    SQL.Strings = (
      'Select * From T_F_IdeaMotif I'
      'Where I.CityNo=:PS_CityNo And I.Off_No_Home=:PS_CountyNo'
      'Order by MotifCode Asc ')
    Left = 337
    Top = 321
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'PS_CityNo'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'PS_CountyNo'
        ParamType = ptUnknown
      end>
  end
  object QueryRedup: TQuery
    DatabaseName = 'db_vipdl'
    Left = 402
    Top = 229
  end
  object QuerySID: TQuery
    DatabaseName = 'db_vipdl'
    Left = 452
    Top = 284
  end
end