datafreq.cpp

项目的研究内容是对硅微谐振式加速度计的数据采集电路开展研究工作。硅微谐振式加速度计敏感结构输出的是两路差分的频率信号

// DataFreq.cpp: implementation of the CDataFreq class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "item4.h"
#include "DataFreq.h"


#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CDataFreq::CDataFreq()
{

}

CDataFreq::~CDataFreq()
{

}

void CDataFreq::SetAll(long num,char a[18])
{
	this->mID=num;
	int k=0;
	CString strtemp;
	for(;k<8;k++)
		strtemp+=a[k];
	this->mAFreq=(float)atof(strtemp);
	strtemp.Empty();
	for(k=9;k<17;k++)
		strtemp+=a[k];
	this->mBFreq=(float)atof(strtemp);
	this->mFreq=this->mAFreq-this->mBFreq;
	this->mAcc=10*this->mFreq;
	SYSTEMTIME SysTime;
	CString StrCurTime;
	::GetLocalTime(&SysTime);
	StrCurTime.Format("%d.%d",SysTime.wSecond,SysTime.wMilliseconds);
	this->mTime=(float)atof(StrCurTime);
}

void CDataFreq::WriteTable(CString name)
{
	_ConnectionPtr m_pConnection;
	m_pConnection.CreateInstance("ADODB.Connection");
	m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\频率测量数据库.mdb","","",adModeUnknown);
			
	_RecordsetPtr m_pRecordset;
	m_pRecordset.CreateInstance("ADODB.Recordset");
	CString strSQL="SELECT * FROM "+name;
	m_pRecordset->Open((_variant_t)strSQL,_variant_t((IDispatch *)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);

	m_pRecordset->AddNew();
	m_pRecordset->PutCollect("序号",(_variant_t)this->mID);
	m_pRecordset->PutCollect("a路频率Hz",(_variant_t)this->mAFreq);
	m_pRecordset->PutCollect("b路频率Hz",(_variant_t)this->mBFreq);
	m_pRecordset->PutCollect("两路频率差Hz",(_variant_t)this->mFreq);
	m_pRecordset->PutCollect("加速度mg",(_variant_t)this->mAcc);
	m_pRecordset->PutCollect("间隔时间s",(_variant_t)this->mTime);
	m_pRecordset->Update();
}

long CDataFreq::GetmID()
{
	return this->mID;
}

float CDataFreq::GetmAFreq()
{
	return this->mAFreq;
}

CString CDataFreq::GetmAfreqCString()
{
	CString temp;
	temp.Format("%.2f",mAFreq);
	return temp;
}

CString CDataFreq::GetmIDCString()
{
	CString temp;
	temp.Format("%d",(int)mID);
	return temp;

}

CString CDataFreq::GetmBFreqCString()
{
	CString temp;
	temp.Format("%.2f",mBFreq);
	return temp;
}

CString CDataFreq::GetmFreqCString()
{
	CString temp;
	temp.Format("%.2f",mFreq);
	return temp;
}

CString CDataFreq::GetmAccCString()
{
	CString temp;
	temp.Format("%.1f",mAcc);
	return temp;
}

CString CDataFreq::GetmTimeCString()
{
	CString temp;
	temp.Format("%.3f",mTime);
	return temp;
}

void CDataFreq::SetAll(CString data[6])
{
	this->mID=atoi(data[0]);
	this->mAFreq=(float)atof(data[1]);
	this->mBFreq=(float)atof(data[2]);
	this->mFreq=(float)atof(data[3]);
	this->mAcc=(float)atof(data[4]);
	this->mTime=(float)atof(data[5]);
}