www.pudn.com > jxc001.rar > DEjxc.Dsr


VERSION 5.00 
Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DEjxc  
   ClientHeight    =   7815 
   ClientLeft      =   0 
   ClientTop       =   0 
   ClientWidth     =   7815 
   _ExtentX        =   13785 
   _ExtentY        =   13785 
   FolderFlags     =   5 
   TypeLibGuid     =   "{CB5C55EE-3459-473C-81BD-C3D8CA15C61B}" 
   TypeInfoGuid    =   "{24AF3DBE-A8A8-45FE-95FF-9FCE07229456}" 
   TypeInfoCookie  =   0 
   Version         =   4 
   NumConnections  =   1 
   BeginProperty Connection1  
      ConnectionName  =   "Conjxc" 
      ConnDispId      =   1001 
      SourceOfData    =   3 
      ConnectionSource=   "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\newmis\data\db_jxc.mdb;Persist Security Info=False" 
      Expanded        =   -1  'True 
      QuoteChar       =   96 
      SeparatorChar   =   46 
   EndProperty 
   NumRecordsets   =   21 
   BeginProperty Recordset1  
      CommandName     =   "ComUsers" 
      CommDispId      =   1002 
      RsDispId        =   1005 
      CommandText     =   "SELECT * FROM users " 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   2 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "user_name" 
         Caption         =   "user_name" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   10 
         Scale           =   0 
         Type            =   200 
         Name            =   "user_pass" 
         Caption         =   "user_pass" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset2  
      CommandName     =   "ComDepartment" 
      CommDispId      =   1006 
      RsDispId        =   1009 
      CommandText     =   "select * from department order by department_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   2 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   3 
         Scale           =   0 
         Type            =   200 
         Name            =   "department_id" 
         Caption         =   "department_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   20 
         Scale           =   0 
         Type            =   200 
         Name            =   "department_name" 
         Caption         =   "department_name" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset3  
      CommandName     =   "ComEmployee" 
      CommDispId      =   1010 
      RsDispId        =   1014 
      CommandText     =   "SELECT * FROM employee ORDER BY employee_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   3 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   4 
         Scale           =   0 
         Type            =   200 
         Name            =   "employee_id" 
         Caption         =   "employee_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   3 
         Scale           =   0 
         Type            =   200 
         Name            =   "employee_depid" 
         Caption         =   "employee_depid" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "employee_name" 
         Caption         =   "employee_name" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset4  
      CommandName     =   "ComProType" 
      CommDispId      =   1015 
      RsDispId        =   1020 
      CommandText     =   "select * from product_type order by type_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   2 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   2 
         Scale           =   0 
         Type            =   200 
         Name            =   "type_id" 
         Caption         =   "type_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   20 
         Scale           =   0 
         Type            =   200 
         Name            =   "type_name" 
         Caption         =   "type_name" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset5  
      CommandName     =   "ComProduct" 
      CommDispId      =   1016 
      RsDispId        =   1023 
      CommandText     =   "select * from product order by p_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   5 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "p_id" 
         Caption         =   "p_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   30 
         Scale           =   0 
         Type            =   200 
         Name            =   "product_name" 
         Caption         =   "product_name" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   0 
         Size            =   18 
         Scale           =   0 
         Type            =   200 
         Name            =   "product_model" 
         Caption         =   "product_model" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   0 
         Size            =   2 
         Scale           =   0 
         Type            =   200 
         Name            =   "type_id" 
         Caption         =   "type_id" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   0 
         Size            =   4 
         Scale           =   0 
         Type            =   200 
         Name            =   "unit" 
         Caption         =   "unit" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset6  
      CommandName     =   "ComSupplier" 
      CommDispId      =   1017 
      RsDispId        =   1026 
      CommandText     =   "select * from supplier order by supplier_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   2 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "supplier_id" 
         Caption         =   "supplier_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   30 
         Scale           =   0 
         Type            =   200 
         Name            =   "supplier_name" 
         Caption         =   "supplier_name" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset7  
      CommandName     =   "ComPsHA" 
      CommDispId      =   1027 
      RsDispId        =   1030 
      CommandText     =   "select * from ps_head_a order by ps_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   6 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   9 
         Scale           =   0 
         Type            =   200 
         Name            =   "ps_id" 
         Caption         =   "ps_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   7 
         Name            =   "ps_date" 
         Caption         =   "ps_date" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "ps_rid" 
         Caption         =   "ps_rid" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "ps_maker" 
         Caption         =   "ps_maker" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   0 
         Size            =   12 
         Scale           =   0 
         Type            =   200 
         Name            =   "ps_car" 
         Caption         =   "ps_car" 
      EndProperty 
      BeginProperty Field6  
         Precision       =   0 
         Size            =   1073741824 
         Scale           =   0 
         Type            =   201 
         Name            =   "ps_demo" 
         Caption         =   "ps_demo" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset8  
      CommandName     =   "ComOrdDA" 
      CommDispId      =   1031 
      RsDispId        =   1034 
      CommandText     =   "select * from order_detail_a order by order_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   5 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   9 
         Scale           =   0 
         Type            =   200 
         Name            =   "order_id" 
         Caption         =   "order_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "p_id" 
         Caption         =   "p_id" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   7 
         Size            =   4 
         Scale           =   0 
         Type            =   4 
         Name            =   "qty" 
         Caption         =   "qty" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "unit_price" 
         Caption         =   "unit_price" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "price" 
         Caption         =   "price" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset9  
      CommandName     =   "ComMatHead" 
      CommDispId      =   1035 
      RsDispId        =   1038 
      CommandText     =   "select * from mat_head order by p_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   3 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "p_id" 
         Caption         =   "p_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   7 
         Size            =   4 
         Scale           =   0 
         Type            =   4 
         Name            =   "qty" 
         Caption         =   "qty" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "price" 
         Caption         =   "price" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset10  
      CommandName     =   "ComOtHA" 
      CommDispId      =   1040 
      RsDispId        =   1043 
      CommandText     =   "select * from other_head_a order by other_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   7 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   9 
         Scale           =   0 
         Type            =   200 
         Name            =   "other_id" 
         Caption         =   "other_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   7 
         Name            =   "other_date" 
         Caption         =   "other_date" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   0 
         Size            =   2 
         Scale           =   0 
         Type            =   200 
         Name            =   "other_type_id" 
         Caption         =   "other_type_id" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "other_rid" 
         Caption         =   "other_rid" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "other_maker" 
         Caption         =   "other_maker" 
      EndProperty 
      BeginProperty Field6  
         Precision       =   0 
         Size            =   12 
         Scale           =   0 
         Type            =   200 
         Name            =   "other_car" 
         Caption         =   "other_car" 
      EndProperty 
      BeginProperty Field7  
         Precision       =   0 
         Size            =   1073741824 
         Scale           =   0 
         Type            =   201 
         Name            =   "other_demo" 
         Caption         =   "other_demo" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset11  
      CommandName     =   "ComOrderType" 
      CommDispId      =   1044 
      RsDispId        =   1049 
      CommandText     =   "select * from order_type order by type_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   2 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   2 
         Scale           =   0 
         Type            =   200 
         Name            =   "type_id" 
         Caption         =   "type_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   18 
         Scale           =   0 
         Type            =   200 
         Name            =   "type_name" 
         Caption         =   "type_name" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset12  
      CommandName     =   "ComSaleType" 
      CommDispId      =   1050 
      RsDispId        =   1051 
      CommandText     =   "select * from sale_type order by type_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   2 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   2 
         Scale           =   0 
         Type            =   200 
         Name            =   "type_id" 
         Caption         =   "type_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   18 
         Scale           =   0 
         Type            =   200 
         Name            =   "type_name" 
         Caption         =   "type_name" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset13  
      CommandName     =   "ComSaleHA" 
      CommDispId      =   1052 
      RsDispId        =   1053 
      CommandText     =   "select * from sale_head_a order by sale_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   8 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   9 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_id" 
         Caption         =   "sale_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   7 
         Name            =   "sale_date" 
         Caption         =   "sale_date" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   0 
         Size            =   2 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_type_id" 
         Caption         =   "sale_type_id" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_rid" 
         Caption         =   "sale_rid" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_user" 
         Caption         =   "sale_user" 
      EndProperty 
      BeginProperty Field6  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_maker" 
         Caption         =   "sale_maker" 
      EndProperty 
      BeginProperty Field7  
         Precision       =   0 
         Size            =   12 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_car" 
         Caption         =   "sale_car" 
      EndProperty 
      BeginProperty Field8  
         Precision       =   0 
         Size            =   1073741824 
         Scale           =   0 
         Type            =   201 
         Name            =   "sale_demo" 
         Caption         =   "sale_demo" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset14  
      CommandName     =   "ComSaleDA" 
      CommDispId      =   1054 
      RsDispId        =   1055 
      CommandText     =   "select * from sale_detail_a order by sale_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   5 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   9 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_id" 
         Caption         =   "sale_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "p_id" 
         Caption         =   "p_id" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "unit_price" 
         Caption         =   "unit_price" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   7 
         Size            =   4 
         Scale           =   0 
         Type            =   4 
         Name            =   "qty" 
         Caption         =   "qty" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "price" 
         Caption         =   "price" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset15  
      CommandName     =   "ComMatDetail" 
      CommDispId      =   1056 
      RsDispId        =   1057 
      CommandText     =   "select * from mat_detail order by p_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   3 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "p_id" 
         Caption         =   "p_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   7 
         Size            =   4 
         Scale           =   0 
         Type            =   4 
         Name            =   "qty" 
         Caption         =   "qty" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "unit_price" 
         Caption         =   "unit_price" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset16  
      CommandName     =   "ComPsHB" 
      CommDispId      =   1058 
      RsDispId        =   1059 
      CommandText     =   "select * from ps_head_b order by ps_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   6 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   9 
         Scale           =   0 
         Type            =   200 
         Name            =   "ps_id" 
         Caption         =   "ps_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   7 
         Name            =   "ps_date" 
         Caption         =   "ps_date" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "ps_rid" 
         Caption         =   "ps_rid" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "ps_maker" 
         Caption         =   "ps_maker" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   0 
         Size            =   12 
         Scale           =   0 
         Type            =   200 
         Name            =   "ps_car" 
         Caption         =   "ps_car" 
      EndProperty 
      BeginProperty Field6  
         Precision       =   0 
         Size            =   1073741824 
         Scale           =   0 
         Type            =   201 
         Name            =   "ps_demo" 
         Caption         =   "ps_demo" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset17  
      CommandName     =   "ComOrdDB" 
      CommDispId      =   1060 
      RsDispId        =   1061 
      CommandText     =   "select * from order_detail_b order by order_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   5 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   9 
         Scale           =   0 
         Type            =   200 
         Name            =   "order_id" 
         Caption         =   "order_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "p_id" 
         Caption         =   "p_id" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   7 
         Size            =   4 
         Scale           =   0 
         Type            =   4 
         Name            =   "qty" 
         Caption         =   "qty" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "unit_price" 
         Caption         =   "unit_price" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "price" 
         Caption         =   "price" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset18  
      CommandName     =   "ComOtHB" 
      CommDispId      =   1062 
      RsDispId        =   1063 
      CommandText     =   "select * from other_head_b order by other_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   7 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   9 
         Scale           =   0 
         Type            =   200 
         Name            =   "other_id" 
         Caption         =   "other_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   7 
         Name            =   "other_date" 
         Caption         =   "other_date" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   0 
         Size            =   2 
         Scale           =   0 
         Type            =   200 
         Name            =   "other_type_id" 
         Caption         =   "other_type_id" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "other_rid" 
         Caption         =   "other_rid" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "other_maker" 
         Caption         =   "other_maker" 
      EndProperty 
      BeginProperty Field6  
         Precision       =   0 
         Size            =   12 
         Scale           =   0 
         Type            =   200 
         Name            =   "other_car" 
         Caption         =   "other_car" 
      EndProperty 
      BeginProperty Field7  
         Precision       =   0 
         Size            =   1073741824 
         Scale           =   0 
         Type            =   201 
         Name            =   "other_demo" 
         Caption         =   "other_demo" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset19  
      CommandName     =   "ComSaleHB" 
      CommDispId      =   1064 
      RsDispId        =   1065 
      CommandText     =   "select * from sale_head_b order by sale_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   8 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   9 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_id" 
         Caption         =   "sale_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   7 
         Name            =   "sale_date" 
         Caption         =   "sale_date" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   0 
         Size            =   2 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_type_id" 
         Caption         =   "sale_type_id" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_rid" 
         Caption         =   "sale_rid" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   0 
         Size            =   4 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_user" 
         Caption         =   "sale_user" 
      EndProperty 
      BeginProperty Field6  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_maker" 
         Caption         =   "sale_maker" 
      EndProperty 
      BeginProperty Field7  
         Precision       =   0 
         Size            =   12 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_car" 
         Caption         =   "sale_car" 
      EndProperty 
      BeginProperty Field8  
         Precision       =   0 
         Size            =   1073741824 
         Scale           =   0 
         Type            =   201 
         Name            =   "sale_demo" 
         Caption         =   "sale_demo" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset20  
      CommandName     =   "ComSaleDB" 
      CommDispId      =   1066 
      RsDispId        =   1067 
      CommandText     =   "select * from sale_detail_b order by sale_id" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   5 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   9 
         Scale           =   0 
         Type            =   200 
         Name            =   "sale_id" 
         Caption         =   "sale_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   200 
         Name            =   "p_id" 
         Caption         =   "p_id" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "unit_price" 
         Caption         =   "unit_price" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   7 
         Size            =   4 
         Scale           =   0 
         Type            =   4 
         Name            =   "qty" 
         Caption         =   "qty" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "price" 
         Caption         =   "price" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
   BeginProperty Recordset21  
      CommandName     =   "ComRptMat" 
      CommDispId      =   1068 
      RsDispId        =   1071 
      CommandText     =   "select * from rpt_mat" 
      ActiveConnectionName=   "Conjxc" 
      CommandType     =   1 
      Locktype        =   4 
      IsRSReturning   =   -1  'True 
      NumFields       =   13 
      BeginProperty Field1  
         Precision       =   0 
         Size            =   8 
         Scale           =   0 
         Type            =   202 
         Name            =   "p_id" 
         Caption         =   "p_id" 
      EndProperty 
      BeginProperty Field2  
         Precision       =   0 
         Size            =   30 
         Scale           =   0 
         Type            =   202 
         Name            =   "product_name" 
         Caption         =   "product_name" 
      EndProperty 
      BeginProperty Field3  
         Precision       =   0 
         Size            =   18 
         Scale           =   0 
         Type            =   202 
         Name            =   "product_model" 
         Caption         =   "product_model" 
      EndProperty 
      BeginProperty Field4  
         Precision       =   0 
         Size            =   4 
         Scale           =   0 
         Type            =   202 
         Name            =   "unit" 
         Caption         =   "unit" 
      EndProperty 
      BeginProperty Field5  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "unit_price" 
         Caption         =   "unit_price" 
      EndProperty 
      BeginProperty Field6  
         Precision       =   7 
         Size            =   4 
         Scale           =   0 
         Type            =   4 
         Name            =   "matbegqty" 
         Caption         =   "matbegqty" 
      EndProperty 
      BeginProperty Field7  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "matbegprice" 
         Caption         =   "matbegprice" 
      EndProperty 
      BeginProperty Field8  
         Precision       =   7 
         Size            =   4 
         Scale           =   0 
         Type            =   4 
         Name            =   "orderqty" 
         Caption         =   "orderqty" 
      EndProperty 
      BeginProperty Field9  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "orderprice" 
         Caption         =   "orderprice" 
      EndProperty 
      BeginProperty Field10  
         Precision       =   7 
         Size            =   4 
         Scale           =   0 
         Type            =   4 
         Name            =   "saleqty" 
         Caption         =   "saleqty" 
      EndProperty 
      BeginProperty Field11  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "saleprice" 
         Caption         =   "saleprice" 
      EndProperty 
      BeginProperty Field12  
         Precision       =   7 
         Size            =   4 
         Scale           =   0 
         Type            =   4 
         Name            =   "matendqty" 
         Caption         =   "matendqty" 
      EndProperty 
      BeginProperty Field13  
         Precision       =   19 
         Size            =   8 
         Scale           =   0 
         Type            =   6 
         Name            =   "matendprice" 
         Caption         =   "matendprice" 
      EndProperty 
      NumGroups       =   0 
      ParamCount      =   0 
      RelationCount   =   0 
      AggregateCount  =   0 
   EndProperty 
End 
Attribute VB_Name = "DEjxc" 
Attribute VB_GlobalNameSpace = False 
Attribute VB_Creatable = True 
Attribute VB_PredeclaredId = True 
Attribute VB_Exposed = False 
Option Explicit 
 
Private Sub DataEnvironment_Initialize() 
    strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Persist " & _ 
    "Security Info=False;Data Source=" & App.Path & "\data\db_jxc.mdb" 
    Conjxc.ConnectionString = strConnect 
End Sub