databind.h
来自「数据库开发」· C头文件 代码 · 共 452 行 · 第 1/2 页
H
452 行
#ifndef DATABINDING_H
#define DATABINDING_H
_COM_SMARTPTR_TYPEDEF(IADORecordBinding,__uuidof(IADORecordBinding));
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 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, adInteger, m_nIndex, sizeof(m_nIndex), m_sts_nIndex, 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_nIndex;
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;
int m_nIndex;
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)
ADO_VARIABLE_LENGTH_ENTRY2(16, adVarChar, m_sYanchen_Jieju, sizeof(m_sYanchen_Jieju), m_sts_sYanchen_Jieju, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(17, adVarChar, m_sYanchenCLBJ, sizeof(m_sYanchenCLBJ), m_sts_sYanchenCLBJ, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(18, adVarChar, m_sSO2ZS_aver, sizeof(m_sSO2ZS_aver), m_sts_sSO2ZS_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(19, adVarChar, m_sSO2ZS_max, sizeof(m_sSO2ZS_max), m_sts_sSO2ZS_max, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(20, adVarChar, m_sSO2ZS_min, sizeof(m_sSO2ZS_min), m_sts_sSO2ZS_min, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(21, adVarChar, m_sSO2_CBtime, sizeof(m_sSO2_CBtime), m_sts_sSO2_CBtime, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(22, adVarChar, m_sSO2SC_aver, sizeof(m_sSO2SC_aver), m_sts_sSO2SC_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(23, adVarChar, m_sSO2_5S, sizeof(m_sSO2_5S), m_sts_sSO2_5S, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(24, adVarChar, m_sSO2_ALL, sizeof(m_sSO2_ALL), m_sts_sSO2_ALL, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(25, adVarChar, m_sSO2CLBJ, sizeof(m_sSO2CLBJ), m_sts_sSO2CLBJ, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(26, adVarChar, m_sYanQiLS_aver, sizeof(m_sYanQiLS_aver), m_sts_sYanQiLS_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(27, adVarChar, m_sYanQiLS_max, sizeof(m_sYanQiLS_max), m_sts_sYanQiLS_max, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(28, adVarChar, m_sYanQiLS_min, sizeof(m_sYanQiLS_min), m_sts_sYanQiLS_min, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(29, adVarChar, m_sYanQiLL_aver, sizeof(m_sYanQiLL_aver), m_sts_sYanQiLL_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(30, adVarChar, m_sYanQi_5S, sizeof(m_sYanQi_5S), m_sts_sYanQi_5S, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(31, adVarChar, m_sYanQi_ALL, sizeof(m_sYanQi_ALL), m_sts_sYanQi_ALL, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(32, adVarChar, m_sYanQiLL_XS, sizeof(m_sYanQiLL_XS), m_sts_sYanQiLL_XS, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(33, adVarChar, m_sYanQiLLBJ, sizeof(m_sYanQiLLBJ), m_sts_sYanQiLLBJ, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(34, adVarChar, m_sYanQiWD_aver, sizeof(m_sYanQiWD_aver), m_sts_sYanQiWD_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(35, adVarChar, m_sYanQiWDBJ, sizeof(m_sYanQiWDBJ), m_sts_sYanQiWDBJ, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(36, adVarChar, m_sYanQiYL_aver, sizeof(m_sYanQiYL_aver), m_sts_sYanQiYL_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(37, adVarChar, m_sYanQiYLBJ, sizeof(m_sYanQiYLBJ), m_sts_sYanQiYLBJ, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(38, adVarChar, m_sYanQiSD_aver, sizeof(m_sYanQiSD_aver), m_sts_sYanQiSD_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(39, adVarChar, m_sYanQiSDBJ, sizeof(m_sYanQiSDBJ), m_sts_sYanQiSDBJ, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(40, adVarChar, m_sYanQiHY_aver, sizeof(m_sYanQiHY_aver), m_sts_sYanQiHY_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(41, adVarChar, m_sYanQiHYBJ, sizeof(m_sYanQiHYBJ), m_sts_sYanQiHYBJ, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(42, adVarChar, m_sNOxZS_aver, sizeof(m_sNOxZS_aver), m_sts_sNOxZS_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(43, adVarChar, m_sNOxZS_max, sizeof(m_sNOxZS_max), m_sts_sNOxZS_max, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(44, adVarChar, m_sNOxZS_min, sizeof(m_sNOxZS_min), m_sts_sNOxZS_min, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(45, adVarChar, m_sNOxCB_time, sizeof(m_sNOxCB_time), m_sts_sNOxCB_time, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(46, adVarChar, m_sNOxSC_aver, sizeof(m_sNOxSC_aver), m_sts_sNOxSC_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(47, adVarChar, m_sNOx_5S, sizeof(m_sNOx_5S), m_sts_sNOx_5S, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(48, adVarChar, m_sNOx_ALL, sizeof(m_sNOx_ALL), m_sts_sNOx_ALL, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(49, adVarChar, m_sNOxBJ, sizeof(m_sNOxBJ), m_sts_sNOxBJ, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(50, adVarChar, m_sCOZS_aver, sizeof(m_sCOZS_aver), m_sts_sCOZS_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(51, adVarChar, m_sCOZS_max, sizeof(m_sCOZS_max), m_sts_sCOZS_max, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(52, adVarChar, m_sCOZS_min, sizeof(m_sCOZS_min), m_sts_sCOZS_min, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(53, adVarChar, m_sCOCB_time, sizeof(m_sCOCB_time), m_sts_sCOCB_time, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(54, adVarChar, m_sCOSC_aver, sizeof(m_sCOSC_aver), m_sts_sCOSC_aver, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(55, adVarChar, m_sCO_5S, sizeof(m_sCO_5S), m_sts_sCO_5S, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(56, adVarChar, m_sCO_ALL, sizeof(m_sCO_ALL), m_sts_sCO_ALL, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(57, adVarChar, m_sCOBJ, sizeof(m_sCOBJ), m_sts_sCOBJ, TRUE)
ADO_VARIABLE_LENGTH_ENTRY2(58, adVarChar, m_sBeiYong54, sizeof(m_sBeiYong54), m_sts_sBeiYong54, TRUE)
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?