configinfo.h

数据库开发

/**********************************************************************************/
/* FileName:				configinfo.h										  */
/* Type:					head file											  */
/* Author:					Sunset												  */
/* Create Time:				2007-11-19											  */
/* Last Modified Time:															  */
/* Comment:					head file of CConfigInfo							  */
/* Copyright (C) 2007 by KaQin Development Project Team							  */
/* All rights reserved															  */
/**********************************************************************************/
/////////////////////////////////////////////////////////////////////////////
#if !defined(MOBILE_ECG_CONFIGINFO)
#define MOBILE_ECG_CONFIGINFO
#define WORK_AS_SERVER			0
#define WORK_AS_CLIENT			1
//#include "user.h"
//#include "adam.h"
#include "Databind.h"
//#include "channelinfo.h"
#define MAX_FIVEMIN_COUNT 20
#define MAX_CHANNEL1_NUM	8
#define MAX_CHANNEL2_NUM	4
#define TOTAL_CHANNEL_NUM	(MAX_CHANNEL1_NUM + MAX_CHANNEL2_NUM)
#define POINT_PER_DAY		1440
#define MAX_SAMPLE_CACHE1	61
#define MAX_SAMPLE_CACHE2	7
typedef struct ServerInfo
{
	CString	strRemoteHost;
	int		nRemotePort;
}SERVERINFO;

class CConfigInfo{
// Construction
public:	

	void SelectListItem(bool *State);
	BOOL AddDataToTenSec(CString str,CDBTenSec *pp);
	int GetRecordCount(CString strsql);
	BOOL GetDataFromTenSec(CString str,CDBTenSec* pp,int nCurRecNum);// &temprs);
	BOOL CheckIfTableExist(CString sTable);
	BOOL CheckToSureTableExist(CString sTable, CString sTemplate);
	BOOL CConfigInfo::CreateNewTable(CString sTable, CString sTemplate);
	BOOL InitDateFromDB();
	BOOL ExitInstance();
	BOOL InitInstance();
	BOOL ADOExec(_RecordsetPtr &ADOSet, _variant_t &strSQL);
	CConfigInfo( void );
	~CConfigInfo( void ); 
//attributes
//	int				m_nLoginCount;
//	CString			m_sCurUser;
	bstr_t			m_bstrFileDSN;
	_RecordsetPtr	m_pADOSet;

	//属性
	CString			m_sCompanyName;				//公司全称
	CString			m_sPath;					//数据文件存放路径
	float			m_fVer;						//软件版本号
	CString			m_sSuperAccount;			//超级用户帐号
	CString			m_sSuperPwd;				//超级用户密码

	SERVERINFO		m_ServerInfo;
	SERVERINFO		m_InsideServerInfo;
//	CUser			m_User;						//当前登录用户


	//硬件
//	CAdam4117		m_Adam4117;
//	CCCD			m_CCD;
//	CMotor			m_Motor;
//	CGprs			m_Gprs;
//	CChannelInfo	m_ChanInfo;
/**********************************************************************************/
/*说明：																		  */
/*	以上属性均由程序初始化时，从注册表中得到，在程序运行过程中参数不发生改变修改  */
/**********************************************************************************/
//保存历史记录（月）
	int             m_nYear, m_nMonth;
	int				m_nWorkType;				//WORK_AS_SERVER:0; WORK_AS_CLIENT:1;
	
	CTime			m_dtToday;					//登录系统日期	
//	CTime			m_dtCurMonth;				//当前统计月份	


//	enum            DateType{ComType, TenSecType, FiveMinType} m_edataType;
	_ConnectionPtr	m_ADOConn;

/***********************FormView初始化状态参数*****************/

	bool m_bItemState[27];
/**************************************************************/
//methods
	void SaveEventLogToDB(CString sTime, CString sEvent);
	void SaveWarnLogToDB(CString sTime, CString sWarn);
	void SaveSampleDataToDB();
	int		StringToInt(CString s);
	float	StringToFloat(CString s);
};

/*class CSampleData		//每天记录
{
public:
	
	CSampleData();
	~CSampleData();
	CString	m_strDay;			//12字节
	float	m_fData[TOTAL_CHANNEL_NUM][POINT_PER_DAY];	//每分钟采集一个温度点
	BOOL	m_bOverWarn[TOTAL_CHANNEL_NUM];//超出设定报警
	//起始二字节 对应有效库存项目数
	//末二字节 对应分钟序数，00:00:00 -> 0
	int		m_nTime[POINT_PER_DAY]; 
	int		m_nCount;
	
	float   m_fCache1[MAX_CHANNEL1_NUM][MAX_SAMPLE_CACHE1];
	int     m_nCache1;
	float   m_fCache2[MAX_CHANNEL2_NUM][MAX_SAMPLE_CACHE2];
	int     m_nCache2;
	void	SetDay(SYSTEMTIME* pSysTime);
	

	CDBTenSec	m_DBRtData;
	CDBFiveMin	m_DBFiveMinData;
	//m_strDay, m_nCount
	//m_nTime[i], m_fData[MAX_CHANNEL1_NUM + MAX_CHANNEL2_NUM][POINT_PER_DAY];
	//末二字节 对应分钟序数，00:00:00 -> 0
	BOOL	GetCurData1(float* fData);
	BOOL	GetCurData2(float* fData);
	int		UpdateSample(int nMinPerDay);
	int     UpdateRTData();
	int     UpdateDBFiveMin();
	void	ClearCache(int nType);
//	void	NewData1Coming(float* fNewData1, CChannelInfo* pChanConfig);
//	void	NewData2Coming(float* fNewData1, CChannelInfo* pChanConfig);
	BOOL	LoadFrom10SecDB();
	BOOL	SaveTo10SecDB();
	BOOL	LoadFromMinDB();
	BOOL	SaveToMinDB();
	BOOL	LoadFrom5MinDB();
	BOOL	SaveTo5MinDB();
	BOOL	LoadFrom15MinDB();
	BOOL	SaveTo15MinDB();
	BOOL	LoadFromHourDB();
	BOOL	SaveToHourDB();
	BOOL	LoadFromDayDB();
	BOOL	SaveToDayDB();
	BOOL	LoadFromMonthDB();
	BOOL	SaveToMonthDB();
//	BOOL	SaveLastSampleToFile(TCHAR* pstrFName);
};*/

#endif //!defined(MOBILE_ECG_CONFIGINFO)