dataunit.dfm

人事管理系统 人事管理系统

object dataform: Tdataform
  OldCreateOrder = False
  OnCreate = DataModuleCreate
  Left = 890
  Top = 250
  Height = 448
  Width = 128
  object conn: TADOConnection
    KeepConnection = False
    LoginPrompt = False
    Mode = cmShareDenyNone
    Provider = 'Microsoft.Jet.OLEDB.4.0'
    Left = 16
  end
  object ZZquy: TADOQuery
    Connection = conn
    CursorType = ctStatic
    BeforeScroll = ZZquyBeforeScroll
    AfterScroll = ZZquyAfterScroll
    Parameters = <>
    SQL.Strings = (
      'select '
      
        'main.main_id,main.name,main.sex,main.mz,main.born,main.jobdate,m' +
        'ain.cgdate,main.hunyin,main.dw_id,'
      
        'dw.bm,dw.dw,main.gw,main.xueli,main.zc,main.zm,main.zm_date,main' +
        '.LianXi,main.address,main.idcard,'
      
        'main.dangan,main.diannao,main.yiliaocard,main.yibaocard,main.jl,' +
        'main.jnpay,main.gw94,main.gw96,'
      
        'main.gw2003,main.gsbt,main.jtqk,main.worklb,main.yonggong,main.z' +
        't,main.photo'
      'from main,dw'
      'where (main.dw_id=dw.dw_id) and (main.zt='#39'zz'#39')'
      'order by main.dw_id')
    Left = 16
    Top = 48
  end
  object zzdata: TDataSource
    DataSet = ZZquy
    Left = 72
    Top = 48
  end
  object NTquy: TADOQuery
    Connection = conn
    CursorType = ctStatic
    BeforeScroll = ZZquyBeforeScroll
    AfterScroll = NTquyAfterScroll
    Parameters = <>
    SQL.Strings = (
      
        'select main.main_id,main.name,main.sex,main.mz,main.born,main.jo' +
        'bdate,main.cgdate,main.hunyin,'
      
        '       main.dw_id,dw.bm,dw.dw,main.gw,main.xueli,main.zc,main.zm' +
        ',main.zm_date,main.LianXi,'
      
        '       main.address,main.idcard,main.dangan,main.diannao,main.yi' +
        'liaocard,main.yibaocard,'
      
        '       main.jl,main.jnpay,main.gw94,main.gw96,main.gw2003,main.g' +
        'sbt,main.jtqk,'
      '       main.worklb,main.yonggong,main.zt,main.photo,'
      '       main.lgdate,main.bl,main.tolpay'
      'from main,dw'
      'where (main.dw_id=dw.dw_id) and main.zt='#39'nt'#39
      'order by main.dw_id')
    Left = 16
    Top = 104
  end
  object TYquy: TADOQuery
    Connection = conn
    CursorType = ctStatic
    BeforeScroll = ZZquyBeforeScroll
    AfterScroll = TYquyAfterScroll
    Parameters = <>
    SQL.Strings = (
      
        'select main.main_id,main.name,main.sex,main.mz,main.born,main.jo' +
        'bdate,main.cgdate,main.hunyin,'
      
        '       main.dw_id,dw.bm,dw.dw,main.gw,main.xueli,main.zc,main.zm' +
        ',main.zm_date,main.LianXi,'
      
        '       main.address,main.idcard,main.dangan,main.diannao,main.yi' +
        'liaocard,main.yibaocard,'
      
        '       main.jl,main.jnpay,main.gw94,main.gw96,main.gw2003,main.g' +
        'sbt,main.jtqk,'
      '       main.worklb,main.yonggong,main.zt,main.photo,'
      
        '       main.lgdate,main.bl,main.starpay,main.ztsd,main.ztny,main' +
        '.tolpay'
      'from main,dw'
      'where (main.dw_id=dw.dw_id) and main.zt='#39'ty'#39
      'order by main.dw_id')
    Left = 16
    Top = 160
  end
  object JSquy: TADOQuery
    Connection = conn
    CursorType = ctStatic
    BeforeScroll = ZZquyBeforeScroll
    AfterScroll = JSquyAfterScroll
    Parameters = <>
    SQL.Strings = (
      
        'select main.main_id,main.name,main.sex,main.mz,main.born,main.jo' +
        'bdate,main.cgdate,main.hunyin,'
      
        '       main.dw_id,dw.bm,dw.dw,main.gw,main.xueli,main.zc,main.zm' +
        ',main.zm_date,main.LianXi,'
      
        '       main.address,main.idcard,main.dangan,main.diannao,main.yi' +
        'liaocard,main.yibaocard,'
      
        '       main.jl,main.jtqk,main.jnpay,main.gw94,main.gw96,main.gw2' +
        '003,main.gsbt,'
      '       main.worklb,main.yonggong,main.zt,main.photo,'
      '       main.txdate,main.tingxindate,main.jswhy'
      'from main,dw'
      'where (main.dw_id=dw.dw_id) and main.zt='#39'js'#39
      'order by main.dw_id'
      '')
    Left = 16
    Top = 216
  end
  object NTdata: TDataSource
    DataSet = NTquy
    Left = 72
    Top = 104
  end
  object TYdata: TDataSource
    DataSet = TYquy
    Left = 72
    Top = 160
  end
  object JSdata: TDataSource
    DataSet = JSquy
    Left = 72
    Top = 216
  end
  object CMD: TADOCommand
    Connection = conn
    Parameters = <>
    Left = 72
  end
  object TXquy: TADOQuery
    Connection = conn
    CursorType = ctStatic
    BeforeScroll = ZZquyBeforeScroll
    AfterScroll = TXquyAfterScroll
    Parameters = <>
    SQL.Strings = (
      
        'select main.main_id,main.name,main.sex,main.mz,main.born,main.jo' +
        'bdate,main.cgdate,main.hunyin,'
      
        '       main.dw_id,dw.bm,dw.dw,main.gw,main.xueli,main.zc,main.zm' +
        ',main.zm_date,main.LianXi,'
      
        '       main.address,main.idcard,main.dangan,main.diannao,main.yi' +
        'liaocard,main.yibaocard,'
      
        '       main.jl,main.jnpay,main.gw94,main.gw96,main.gw2003,main.g' +
        'sbt,main.jtqk,'
      '       main.worklb,main.yonggong,main.zt,main.photo,'
      
        '       main.lgdate,main.txdate,main.bl,main.starpay,main.addpay,' +
        'main.ztsd,main.ztny,main.tolpay'
      'from main,dw'
      'where (main.dw_id=dw.dw_id) and main.zt='#39'tx'#39
      'order by main.dw_id')
    Left = 16
    Top = 264
  end
  object TXdata: TDataSource
    DataSet = TXquy
    Left = 72
    Top = 264
  end
  object selquy: TADOQuery
    Connection = conn
    AfterScroll = selquyAfterScroll
    Parameters = <>
    Left = 16
    Top = 312
  end
  object seldata: TDataSource
    DataSet = selquy
    Left = 72
    Top = 312
  end
  object SearchData: TDataSource
    DataSet = SearchQuy
    Left = 72
    Top = 360
  end
  object SearchQuy: TADOQuery
    Connection = conn
    Parameters = <>
    Left = 16
    Top = 360
  end
end