databinding.h

仓库管理系统的数据库

#ifndef DATABINDING_H
#define DATABINDING_H

class CCPRs : public CADORecordBinding
{
BEGIN_ADO_BINDING(CCPRs)
    
   //Column empid is the 1st field in the recordset   
   ADO_VARIABLE_LENGTH_ENTRY2(1, adVarChar, m_sz_no, 
         sizeof(m_sz_no), m_sts_no, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(2, adVarChar, m_sz_name, 
         sizeof(m_sz_name), m_sts_name, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(3, adVarChar, m_sz_kind, 
         sizeof(m_sz_kind), m_sts_kind, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(4, adSingle, m_f_price, 
         sizeof(m_f_price), m_sts_price, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(5, adVarChar, m_sz_detail, 
         sizeof(m_sz_detail), m_sts_detail, TRUE)


END_ADO_BINDING()

public:
   ULONG  m_sts_no;
   ULONG  m_sts_name;
   ULONG  m_sts_kind;
   ULONG  m_sts_price;
   ULONG  m_sts_detail;

   CHAR  m_sz_no[10];
   CHAR  m_sz_name[20];
   CHAR  m_sz_kind[20];
   float  m_f_price;
   CHAR  m_sz_detail[50];
public:
	void FillFieldsArray(COleSafeArray& fields, COleSafeArray& values);
};


class CZBYRs : public CADORecordBinding
{
BEGIN_ADO_BINDING(CZBYRs)
    
   //Column empid is the 1st field in the recordset   
   ADO_VARIABLE_LENGTH_ENTRY2(1, adVarChar, m_sz_name, 
         sizeof(m_sz_name), m_sts_name, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(2, adVarChar, m_sz_pswd, 
         sizeof(m_sz_pswd), m_sts_pswd, TRUE)

END_ADO_BINDING()

public:
   ULONG m_sts_name;
   ULONG m_sts_pswd;

   CHAR  m_sz_name[10];
   CHAR  m_sz_pswd[10];
public:
	void FillFieldsArray(COleSafeArray& fields, COleSafeArray& values);
};


class CKHRs : public CADORecordBinding
{
BEGIN_ADO_BINDING(CKHRs)
    
   //Column empid is the 1st field in the recordset   
   ADO_VARIABLE_LENGTH_ENTRY2(1, adVarChar, m_sz_no, 
         sizeof(m_sz_no), m_sts_no, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(2, adVarChar, m_sz_name, 
         sizeof(m_sz_name), m_sts_name, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(3, adVarChar, m_sz_gender, 
         sizeof(m_sz_gender), m_sts_gender, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(4, adSingle, m_f_year, 
         sizeof(m_f_year), m_sts_year, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(5, adVarChar, m_sz_job, 
         sizeof(m_sz_job), m_sts_job, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(6, adVarChar, m_sz_tel, 
         sizeof(m_sz_tel), m_sts_tel, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(7, adVarChar, m_sz_company, 
         sizeof(m_sz_company), m_sts_company, TRUE)

END_ADO_BINDING()

public:
   ULONG  m_sts_no;
   ULONG  m_sts_name;
   ULONG  m_sts_gender;
   ULONG  m_sts_year;
   ULONG  m_sts_job;
   ULONG  m_sts_tel;
   ULONG  m_sts_company;

   CHAR  m_sz_no[10];
   CHAR  m_sz_name[20];
   CHAR  m_sz_gender[5];
   float  m_f_year;
   CHAR  m_sz_job[20];
   CHAR  m_sz_tel[20];
   CHAR  m_sz_company[20];
public:
	void FillFieldsArray(COleSafeArray& fields, COleSafeArray& values);
};


class CDCRs : public CADORecordBinding
{
BEGIN_ADO_BINDING(CDCRs)
    
   //Column empid is the 1st field in the recordset   
   ADO_VARIABLE_LENGTH_ENTRY2(1, adVarChar, m_sz_desk, 
         sizeof(m_sz_desk), m_sts_desk, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(2, adVarChar, m_sz_no, 
         sizeof(m_sz_no), m_sts_no, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(3, adVarChar, m_sz_name, 
         sizeof(m_sz_name), m_sts_name, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(4, adSingle, m_f_number, 
         sizeof(m_f_number), m_sts_number, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(5, adVarChar, m_sz_date, 
         sizeof(m_sz_date), m_sts_date, TRUE)


END_ADO_BINDING()

public:
   ULONG  m_sts_desk;
   ULONG  m_sts_no;
   ULONG  m_sts_name;
   ULONG  m_sts_number;
   ULONG  m_sts_date;

   CHAR  m_sz_desk[20];
   CHAR  m_sz_no[10];
   CHAR  m_sz_name[20];
   float  m_f_number;
   CHAR  m_sz_date[20];
public:
	void FillFieldsArray(COleSafeArray& fields, COleSafeArray& values);
};


class CJSRs : public CADORecordBinding
{
BEGIN_ADO_BINDING(CJSRs)
    
   //Column empid is the 1st field in the recordset   
   ADO_VARIABLE_LENGTH_ENTRY2(1, adVarChar, m_sz_no, 
         sizeof(m_sz_no), m_sts_no, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(2, adVarChar, m_sz_desk, 
         sizeof(m_sz_desk), m_sts_desk, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(3, adSingle, m_f_dz, 
         sizeof(m_f_dz), m_sts_dz, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(4, adSingle, m_f_total, 
         sizeof(m_f_total), m_sts_total, TRUE)

   ADO_VARIABLE_LENGTH_ENTRY2(5, adVarChar, m_sz_date, 
         sizeof(m_sz_date), m_sts_date, TRUE)


END_ADO_BINDING()

public:
   ULONG  m_sts_no;
   ULONG  m_sts_desk;
   ULONG  m_sts_dz;
   ULONG  m_sts_total;
   ULONG  m_sts_date;

   CHAR  m_sz_no[20];
   CHAR  m_sz_desk[20];
   float  m_f_dz;
   float  m_f_total;
   CHAR  m_sz_date[20];
public:
	void FillFieldsArray(COleSafeArray& fields, COleSafeArray& values);
};

#endif