databind.h

来自「数据库开发」· C头文件 代码 · 共 543 行 · 第 1/2 页

H
543
字号
#ifndef DATABINDING_H
#define DATABINDING_H
_COM_SMARTPTR_TYPEDEF(IADORecordBinding,__uuidof(IADORecordBinding));

class CDBDevice : public CADORecordBinding
{
	BEGIN_ADO_BINDING(CDBDevice)
    
	   //Column empid is the 1st field in the recordset   
		ADO_VARIABLE_LENGTH_ENTRY2(1, adInteger, m_nID, 
			 sizeof(m_nID), m_sts_nID, TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(2, adVarChar, m_sCom, 
			 sizeof(m_sCom), m_sts_sCom, TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(3, adInteger, m_nBt, 
			 sizeof(m_nBt), m_sts_nBt, TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(4, adVarChar, m_sCommand[0], 
			 sizeof(m_sCommand[0]), m_sts_sCommand[0], TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(5, adVarChar, m_sCommand[1], 
			 sizeof(m_sCommand[1]), m_sts_sCommand[1], TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(6, adVarChar, m_sCommand[2], 
			 sizeof(m_sCommand[2]), m_sts_sCommand[2], TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(7, adVarChar, m_sCommand[3], 
			 sizeof(m_sCommand[3]), m_sts_sCommand[3], TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(8, adVarChar, m_sCommand[4], 
			 sizeof(m_sCommand[4]), m_sts_sCommand[4], TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(9, adVarChar, m_sCommand[5], 
			 sizeof(m_sCommand[5]), m_sts_sCommand[5], TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(10, adVarChar, m_sCommand[6], 
			 sizeof(m_sCommand[6]), m_sts_sCommand[6], TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(11, adVarChar, m_sCommand[7], 
			 sizeof(m_sCommand[7]), m_sts_sCommand[7], TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(12, adVarChar, m_sCommand[8], 
			 sizeof(m_sCommand[8]), m_sts_sCommand[8], TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(13, adVarChar, m_sCommand[9], 
			 sizeof(m_sCommand[9]), m_sts_sCommand[9], TRUE)

		ADO_VARIABLE_LENGTH_ENTRY2(14, adInteger, m_nMaxSec, 
			 sizeof(m_nMaxSec), m_sts_nMaxSec, TRUE)
	END_ADO_BINDING()

public:
	ULONG  m_sts_nID;
	ULONG  m_sts_sCom;
	ULONG  m_sts_nBt;
	ULONG  m_sts_sCommand[10],m_sts_nMaxSec;

    int    m_nID;
	int    m_nBt,m_nMaxSec;
    CHAR   m_sCom[6];
	CHAR   m_sCommand[10][10];
public:
	//int GetRowCount();
	void FillFieldsArray(COleSafeArray& fields, COleSafeArray& values);
};

class CDBCount : public CADORecordBinding
{
	BEGIN_ADO_BINDING(CDBCount)
    
	   //Column empid is the 1st field in the recordset   
		ADO_VARIABLE_LENGTH_ENTRY2(1, adInteger, m_nCount, 
			 sizeof(m_nCount), m_sts_nCount, TRUE)
	END_ADO_BINDING()

public:
	ULONG  m_sts_nCount;
	
    int    m_nCount;
	public:
	//int GetRowCount();
	void FillFieldsArray(COleSafeArray& fields, COleSafeArray& values);
};


class CDBEventLog : public CADORecordBinding
{
	BEGIN_ADO_BINDING(CDBEventLog)
    
	//Column empid is the 1st field in the recordset   
	ADO_VARIABLE_LENGTH_ENTRY2(1,  adInteger, m_nID,		sizeof(m_nID),			m_sts_nID,			TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(2,  adVarChar, m_sTable,		sizeof(m_sTable),	    m_sts_sTable,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(3,  adInteger, m_nRowCount,	sizeof(m_nRowCount),	m_sts_nRowCount,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(4,  adVarChar, m_sTime,		sizeof(m_sTime),		m_sts_sTime,		TRUE)
	END_ADO_BINDING()

public:
	ULONG  m_sts_nID;
	ULONG  m_sts_sTable;
	ULONG  m_sts_nRowCount;
	ULONG  m_sts_sTime;
	
    int    m_nID;
	CHAR   m_sTable[12];
	int    m_nRowCount;
    CHAR   m_sTime[20];
	
public:
	//int GetRowCount();
	void FillFieldsArray(COleSafeArray& fields, COleSafeArray& values);
};

class CDBTenSec : public CADORecordBinding
{
	BEGIN_ADO_BINDING(CDBTenSec)
    
	//Column empid is the 1st field in the recordset   
	ADO_VARIABLE_LENGTH_ENTRY2(1,  adInteger, m_nTenS_nID,		sizeof(m_nTenS_nID),	m_sts_TenS_nID,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(2,  adVarChar, m_sIndex,			sizeof(m_sIndex),	    m_sts_sIndex,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(3,  adVarChar, m_sPaiWuHao,		sizeof(m_sPaiWuHao),	m_sts_sPaiWuHao,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(4,  adVarChar, m_sShibieMa,		sizeof(m_sShibieMa),	m_sts_sShibieMa,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(5,  adVarChar, m_sLiushuiMa,		sizeof(m_sLiushuiMa),	m_sts_sLiushuiMa,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(6,  adVarChar, m_sYanchenZS,		sizeof(m_sYanchenZS),	m_sts_sYanchenZS,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(7,  adVarChar, m_sYanchenSC,		sizeof(m_sYanchenSC),	m_sts_sYanchenSC,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(8,  adVarChar, m_sYanchenBJ,		sizeof(m_sYanchenBJ),	m_sts_sYanchenBJ,	TRUE)

	ADO_VARIABLE_LENGTH_ENTRY2(9,   adVarChar, m_sSO2ZS,		sizeof(m_sSO2ZS),	    m_sts_sSO2ZS,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(10,  adVarChar, m_sSO2SC,		sizeof(m_sSO2SC),	    m_sts_sSO2SC,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(11,  adVarChar, m_sSO2BJ,		sizeof(m_sSO2BJ),		m_sts_sSO2BJ,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(12,  adVarChar, m_sYanqiLS,		sizeof(m_sYanqiLS),		m_sts_sYanqiLS,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(13,  adVarChar, m_sYanqiLSBJ,	sizeof(m_sYanqiLSBJ),	m_sts_sYanqiLSBJ,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(14,  adVarChar, m_sYanqiWD,		sizeof(m_sYanqiWD),	    m_sts_sYanqiWD,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(15,  adVarChar, m_sYanqiWDBJ,	sizeof(m_sYanqiWDBJ),	m_sts_sYanqiWDBJ,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(16,  adVarChar, m_sYanqiYL,		sizeof(m_sYanqiYL),		m_sts_sYanqiYL,		TRUE)

	ADO_VARIABLE_LENGTH_ENTRY2(17,  adVarChar, m_sYanqiYLBJ,	sizeof(m_sYanqiYLBJ),	m_sts_sYanqiYLBJ,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(18,  adVarChar, m_sYanqiSD,		sizeof(m_sYanqiSD),	    m_sts_sYanqiSD,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(19,  adVarChar, m_sYanqiSDBJ,	sizeof(m_sYanqiSDBJ),	m_sts_sYanqiSDBJ,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(20,  adVarChar, m_sYanqiHY,		sizeof(m_sYanqiHY),		m_sts_sYanqiHY,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(21,  adVarChar, m_sYanqiHYBJ,	sizeof(m_sYanqiHYBJ),	m_sts_sYanqiHYBJ,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(22,  adVarChar, m_sNOxZS,		sizeof(m_sNOxZS),	    m_sts_sNOxZS,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(23,  adVarChar, m_sNOxSC,		sizeof(m_sNOxSC),		m_sts_sNOxSC,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(24,  adVarChar, m_sNOxBJ,		sizeof(m_sNOxBJ),		m_sts_sNOxBJ,		TRUE)

	ADO_VARIABLE_LENGTH_ENTRY2(25,  adVarChar, m_sCOZS,			sizeof(m_sCOZS),		m_sts_sCOZS,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(26,  adVarChar, m_sCOSC,			sizeof(m_sCOSC),	    m_sts_sCOSC,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(27,  adVarChar, m_sCOBJ,			sizeof(m_sCOBJ),		m_sts_sCOBJ,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(28,  adVarChar, m_sBeiYong24,	sizeof(m_sBeiYong24),	m_sts_sBeiYong24,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(29,  adVarChar, m_sBeiYong25,	sizeof(m_sBeiYong25),	m_sts_sBeiYong25,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(30,  adVarChar, m_sBeiYong26,	sizeof(m_sBeiYong26),	m_sts_sBeiYong26,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(31,  adVarChar, m_sBeiYong27,	sizeof(m_sBeiYong27),	m_sts_sBeiYong27,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(32,  adVarChar, m_sBeiYong24,	sizeof(m_sBeiYong28),	m_sts_sBeiYong28,	TRUE)
	
	/*2008-1-4am added*/
	ADO_VARIABLE_LENGTH_ENTRY2(33,  adVarChar, m_sFuhe,			sizeof(m_sFuhe),		m_sts_sFuhe,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(34,  adVarChar, m_sNOZS,			sizeof(m_sNOZS),		m_sts_sNOZS,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(35,  adVarChar, m_sNOSC,			sizeof(m_sNOSC),		m_sts_sNOSC,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(36,  adVarChar, m_sNO2ZS,		sizeof(m_sNO2ZS),		m_sts_sNO2ZS,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(37,  adVarChar, m_sNO2SC,		sizeof(m_sNO2SC),		m_sts_sNO2SC,		TRUE)



	END_ADO_BINDING()

public:
	ULONG  m_sts_TenS_nID;
	ULONG  m_sts_sIndex;
	ULONG  m_sts_sPaiWuHao;
	ULONG  m_sts_sShibieMa;
	ULONG  m_sts_sLiushuiMa;
	ULONG  m_sts_sYanchenZS;
	ULONG  m_sts_sYanchenSC;
	ULONG  m_sts_sYanchenBJ;
	ULONG  m_sts_sSO2ZS;
	ULONG  m_sts_sSO2SC;
	ULONG  m_sts_sSO2BJ;
	ULONG  m_sts_sYanqiLS;
	ULONG  m_sts_sYanqiLSBJ;
	ULONG  m_sts_sYanqiWD;
	ULONG  m_sts_sYanqiWDBJ;
	ULONG  m_sts_sYanqiYL;
	ULONG  m_sts_sYanqiYLBJ;
	ULONG  m_sts_sYanqiSD;
	ULONG  m_sts_sYanqiSDBJ;
	ULONG  m_sts_sYanqiHY;
	ULONG  m_sts_sYanqiHYBJ;
	ULONG  m_sts_sNOxZS;
	ULONG  m_sts_sNOxSC;
	ULONG  m_sts_sNOxBJ;
	ULONG  m_sts_sCOZS;
	ULONG  m_sts_sCOSC;
	ULONG  m_sts_sCOBJ;
	ULONG  m_sts_sBeiYong24;
	ULONG  m_sts_sBeiYong25;
	ULONG  m_sts_sBeiYong26;
	ULONG  m_sts_sBeiYong27;
	ULONG  m_sts_sBeiYong28;
	/*2008-1-4am added*/
	ULONG  m_sts_sFuhe;
	ULONG  m_sts_sNOZS;
	ULONG  m_sts_sNOSC;
	ULONG  m_sts_sNO2ZS;
	ULONG  m_sts_sNO2SC;


    int    m_nTenS_nID;
	CHAR   m_sIndex[20];
    CHAR   m_sPaiWuHao[20];
    CHAR   m_sShibieMa[20];
	CHAR   m_sLiushuiMa[20];
	CHAR   m_sYanchenZS[20];
    CHAR   m_sYanchenSC[20];
	CHAR   m_sYanchenBJ[20];
    CHAR   m_sSO2ZS[20];
    CHAR   m_sSO2SC[20];
	CHAR   m_sSO2BJ[20];
    CHAR   m_sYanqiLS[20];
    CHAR   m_sYanqiLSBJ[20];
	CHAR   m_sYanqiWD[20];
    CHAR   m_sYanqiWDBJ[20];
    CHAR   m_sYanqiYL[20];	
	CHAR   m_sYanqiYLBJ[20];
    CHAR   m_sYanqiSD[20];
    CHAR   m_sYanqiSDBJ[20];
	CHAR   m_sYanqiHY[20];
    CHAR   m_sYanqiHYBJ[20];
    CHAR   m_sNOxZS[20];
	CHAR   m_sNOxSC[20];
    CHAR   m_sNOxBJ[20];
    CHAR   m_sCOZS[20];
	CHAR   m_sCOSC[20];
    CHAR   m_sCOBJ[20];
    CHAR   m_sBeiYong24[20];
	CHAR   m_sBeiYong25[20];
	CHAR   m_sBeiYong26[20];  
	CHAR   m_sBeiYong27[20];
	CHAR   m_sBeiYong28[20];
	/*2008-1-4am added*/
	CHAR   m_sFuhe[20];
	CHAR   m_sNOZS[20];
	CHAR   m_sNOSC[20];  
	CHAR   m_sNO2ZS[20];
	CHAR   m_sNO2SC[20];
	
public:
	//int GetRowCount();
	void FillFieldsArray(COleSafeArray& fields, COleSafeArray& values);

};

class CDBFiveMin : public CADORecordBinding
{
	BEGIN_ADO_BINDING(CDBFiveMin)
    
	//Column empid is the 1st field in the recordset   
	ADO_VARIABLE_LENGTH_ENTRY2(1,  adInteger, m_nFiveM_nID,				sizeof(m_nFiveM_nID),			m_sts_FiveM_nID,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(2,  adVarChar, m_sIndex,					sizeof(m_sIndex),				m_sts_sIndex,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(3,  adVarChar, m_sPaiWuHao,				sizeof(m_sPaiWuHao),			m_sts_sPaiWuHao,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(4,  adVarChar, m_sShibieMa,				sizeof(m_sShibieMa),			m_sts_sShibieMa,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(5,  adVarChar, m_sLiushuiMa,				sizeof(m_sLiushuiMa),			m_sts_sLiushuiMa,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(6,  adVarChar, m_sRiQi,					sizeof(m_sRiQi),				m_sts_sRiQi,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(7,  adVarChar, m_sShiJian,				sizeof(m_sShiJian),				m_sts_sShiJian,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(8,  adVarChar, m_sYanchenZS_aver,		sizeof(m_sYanchenZS_aver),		m_sts_sYanchenZS_aver,	TRUE)

	ADO_VARIABLE_LENGTH_ENTRY2(9,   adVarChar, m_sYanchenZS_max,		sizeof(m_sYanchenZS_max),		m_sts_sYanchenZS_max,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(10,  adVarChar, m_sYanchenZS_min,		sizeof(m_sYanchenZS_min),	    m_sts_sYanchenZS_min,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(11,  adVarChar, m_sYanchen_CBtime,		sizeof(m_sYanchen_CBtime),		m_sts_sYanchen_CBtime,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(12,  adVarChar, m_sYanchenSC_aver,		sizeof(m_sYanchenSC_aver),		m_sts_sYanchenSC_aver,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(13,  adVarChar, m_sYanchen_5S,			sizeof(m_sYanchen_5S),			m_sts_sYanchen_5S,	TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(14,  adVarChar, m_sYanchen_ALL,			sizeof(m_sYanchen_ALL),			m_sts_sYanchen_ALL,		TRUE)
	ADO_VARIABLE_LENGTH_ENTRY2(15,  adVarChar, m_sYanchen_Xielv,		sizeof(m_sYanchen_Xielv),		m_sts_sYanchen_Xielv,	TRUE)

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?