dataenvironment1.dsr

来自「学生管理系统,用VB开发的,若需要可提供相关论文」· DSR 代码 · 共 530 行 · 第 1/2 页

         Precision       =   0
         Size            =   10
         Scale           =   0
         Type            =   129
         Name            =   "c2"
         Caption         =   "c2"
      EndProperty
      BeginProperty Field3 
         Precision       =   0
         Size            =   10
         Scale           =   0
         Type            =   129
         Name            =   "c3"
         Caption         =   "c3"
      EndProperty
      BeginProperty Field4 
         Precision       =   23
         Size            =   16
         Scale           =   3
         Type            =   135
         Name            =   "c4"
         Caption         =   "c4"
      EndProperty
      BeginProperty Field5 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   200
         Name            =   "c5"
         Caption         =   "c5"
      EndProperty
      BeginProperty Field6 
         Precision       =   0
         Size            =   10
         Scale           =   0
         Type            =   129
         Name            =   "c6"
         Caption         =   "c6"
      EndProperty
      BeginProperty Field7 
         Precision       =   0
         Size            =   100
         Scale           =   0
         Type            =   200
         Name            =   "c7"
         Caption         =   "c7"
      EndProperty
      BeginProperty Field8 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   200
         Name            =   "c8"
         Caption         =   "c8"
      EndProperty
      NumGroups       =   0
      ParamCount      =   0
      RelationCount   =   0
      AggregateCount  =   0
   EndProperty
   BeginProperty Recordset4 
      CommandName     =   "学历统计表"
      CommDispId      =   1033
      RsDispId        =   1040
      CommandText     =   "select    a3 ,a11, count (a11)  as  学历人数  from  pcl group by a11,a3"
      ActiveConnectionName=   "人事档案管理"
      CommandType     =   1
      IsRSReturning   =   -1  'True
      NumFields       =   3
      BeginProperty Field1 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   200
         Name            =   "a3"
         Caption         =   "a3"
      EndProperty
      BeginProperty Field2 
         Precision       =   0
         Size            =   10
         Scale           =   0
         Type            =   129
         Name            =   "a11"
         Caption         =   "a11"
      EndProperty
      BeginProperty Field3 
         Precision       =   10
         Size            =   4
         Scale           =   0
         Type            =   3
         Name            =   "学历人数"
         Caption         =   "学历人数"
      EndProperty
      NumGroups       =   0
      ParamCount      =   0
      RelationCount   =   0
      AggregateCount  =   0
   EndProperty
   BeginProperty Recordset5 
      CommandName     =   "职称统计表"
      CommDispId      =   1041
      RsDispId        =   1046
      CommandText     =   "select    a3 ,a12, count (a12)  as  人数  from  pcl group by a12,a3"
      ActiveConnectionName=   "人事档案管理"
      CommandType     =   1
      IsRSReturning   =   -1  'True
      NumFields       =   3
      BeginProperty Field1 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   200
         Name            =   "a3"
         Caption         =   "a3"
      EndProperty
      BeginProperty Field2 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   200
         Name            =   "a12"
         Caption         =   "a12"
      EndProperty
      BeginProperty Field3 
         Precision       =   10
         Size            =   4
         Scale           =   0
         Type            =   3
         Name            =   "人数"
         Caption         =   "人数"
      EndProperty
      NumGroups       =   0
      ParamCount      =   0
      RelationCount   =   0
      AggregateCount  =   0
   EndProperty
   BeginProperty Recordset6 
      CommandName     =   "民族统计表"
      CommDispId      =   1047
      RsDispId        =   1052
      CommandText     =   "select    a3 ,a5, count (a5)  as  人数  from  pcl group by a5,a3"
      ActiveConnectionName=   "人事档案管理"
      CommandType     =   1
      IsRSReturning   =   -1  'True
      NumFields       =   3
      BeginProperty Field1 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   200
         Name            =   "a3"
         Caption         =   "a3"
      EndProperty
      BeginProperty Field2 
         Precision       =   0
         Size            =   10
         Scale           =   0
         Type            =   129
         Name            =   "a5"
         Caption         =   "a5"
      EndProperty
      BeginProperty Field3 
         Precision       =   10
         Size            =   4
         Scale           =   0
         Type            =   3
         Name            =   "人数"
         Caption         =   "人数"
      EndProperty
      NumGroups       =   0
      ParamCount      =   0
      RelationCount   =   0
      AggregateCount  =   0
   EndProperty
   BeginProperty Recordset7 
      CommandName     =   "政治面貌统计表"
      CommDispId      =   1053
      RsDispId        =   1058
      CommandText     =   "select    a3 ,a6, count (a6)  as  人数  from  pcl group by a6,a3"
      ActiveConnectionName=   "人事档案管理"
      CommandType     =   1
      IsRSReturning   =   -1  'True
      NumFields       =   3
      BeginProperty Field1 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   200
         Name            =   "a3"
         Caption         =   "a3"
      EndProperty
      BeginProperty Field2 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   200
         Name            =   "a6"
         Caption         =   "a6"
      EndProperty
      BeginProperty Field3 
         Precision       =   10
         Size            =   4
         Scale           =   0
         Type            =   3
         Name            =   "人数"
         Caption         =   "人数"
      EndProperty
      NumGroups       =   0
      ParamCount      =   0
      RelationCount   =   0
      AggregateCount  =   0
   EndProperty
   BeginProperty Recordset8 
      CommandName     =   "退休人员统计表"
      CommDispId      =   1059
      RsDispId        =   1069
      CommandText     =   $"DataEnvironment1.dsx":0000
      ActiveConnectionName=   "人事档案管理"
      CommandType     =   1
      IsRSReturning   =   -1  'True
      NumFields       =   4
      BeginProperty Field1 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   200
         Name            =   "a3"
         Caption         =   "a3"
      EndProperty
      BeginProperty Field2 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   200
         Name            =   "a1"
         Caption         =   "a1"
      EndProperty
      BeginProperty Field3 
         Precision       =   0
         Size            =   50
         Scale           =   0
         Type            =   200
         Name            =   "a2"
         Caption         =   "a2"
      EndProperty
      BeginProperty Field4 
         Precision       =   23
         Size            =   16
         Scale           =   3
         Type            =   135
         Name            =   "a7"
         Caption         =   "a7"
      EndProperty
      NumGroups       =   0
      ParamCount      =   0
      RelationCount   =   0
      AggregateCount  =   0
   EndProperty
End
Attribute VB_Name = "DataEnvironment1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False