?? listdialog.cpp
字號:
// ListDialog.cpp : implementation file
//
#include "stdafx.h"
#include "TestChart.h"
#include "ListDialog.h"
#include "TestChartView.h"
#include "ChartCtrl.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
static unsigned char auchCRCHi[]={
0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0,
0x80, 0x41, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41,
0x00, 0xC1, 0x81, 0x40, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0,
0x80, 0x41, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40,
0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1,
0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41,
0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1,
0x81, 0x40, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41,
0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0,
0x80, 0x41, 0x00, 0xC1, 0x81, 0x40, 0x00, 0xC1, 0x81, 0x40,
0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1,
0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40,
0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0,
0x80, 0x41, 0x00, 0xC1, 0x81, 0x40, 0x00, 0xC1, 0x81, 0x40,
0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0,
0x80, 0x41, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40,
0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0,
0x80, 0x41, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41,
0x00, 0xC1, 0x81, 0x40, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0,
0x80, 0x41, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41,
0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0,
0x80, 0x41, 0x00, 0xC1, 0x81, 0x40, 0x00, 0xC1, 0x81, 0x40,
0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1,
0x81, 0x40, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41,
0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0,
0x80, 0x41, 0x00, 0xC1, 0x81, 0x40
};
/* Table of CRC values for low-order byte */
static unsigned char auchCRCLo[]={
0x00, 0xC0, 0xC1, 0x01, 0xC3, 0x03, 0x02, 0xC2, 0xC6, 0x06,
0x07, 0xC7, 0x05, 0xC5, 0xC4, 0x04, 0xCC, 0x0C, 0x0D, 0xCD,
0x0F, 0xCF, 0xCE, 0x0E, 0x0A, 0xCA, 0xCB, 0x0B, 0xC9, 0x09, 0x08, 0xC8, 0xD8, 0x18, 0x19, 0xD9, 0x1B, 0xDB, 0xDA, 0x1A,
0x1E, 0xDE, 0xDF, 0x1F, 0xDD, 0x1D, 0x1C, 0xDC, 0x14, 0xD4,
0xD5, 0x15, 0xD7, 0x17, 0x16, 0xD6, 0xD2, 0x12, 0x13, 0xD3,
0x11, 0xD1, 0xD0, 0x10, 0xF0, 0x30, 0x31, 0xF1, 0x33, 0xF3,
0xF2, 0x32, 0x36, 0xF6, 0xF7, 0x37, 0xF5, 0x35, 0x34, 0xF4,
0x3C, 0xFC, 0xFD, 0x3D, 0xFF, 0x3F, 0x3E, 0xFE, 0xFA, 0x3A,
0x3B, 0xFB, 0x39, 0xF9, 0xF8, 0x38, 0x28, 0xE8, 0xE9, 0x29,
0xEB, 0x2B, 0x2A, 0xEA, 0xEE, 0x2E, 0x2F, 0xEF, 0x2D, 0xED, 0xEC, 0x2C, 0xE4, 0x24, 0x25, 0xE5, 0x27, 0xE7, 0xE6, 0x26,
0x22, 0xE2, 0xE3, 0x23, 0xE1, 0x21, 0x20, 0xE0, 0xA0, 0x60,
0x61, 0xA1, 0x63, 0xA3, 0xA2, 0x62, 0x66, 0xA6, 0xA7, 0x67,
0xA5, 0x65, 0x64, 0xA4, 0x6C, 0xAC, 0xAD, 0x6D, 0xAF, 0x6F, 0x6E, 0xAE, 0xAA, 0x6A, 0x6B, 0xAB, 0x69, 0xA9, 0xA8, 0x68, 0x78, 0xB8, 0xB9, 0x79, 0xBB, 0x7B, 0x7A, 0xBA, 0xBE, 0x7E,
0x7F, 0xBF, 0x7D, 0xBD, 0xBC, 0x7C, 0xB4, 0x74, 0x75, 0xB5,
0x77, 0xB7, 0xB6, 0x76, 0x72, 0xB2, 0xB3, 0x73, 0xB1, 0x71,
0x70, 0xB0, 0x50, 0x90, 0x91, 0x51, 0x93, 0x53, 0x52, 0x92,
0x96, 0x56, 0x57, 0x97, 0x55, 0x95, 0x94, 0x54, 0x9C, 0x5C,
0x5D, 0x9D, 0x5F, 0x9F, 0x9E, 0x5E, 0x5A, 0x9A, 0x9B, 0x5B,
0x99, 0x59, 0x58, 0x98, 0x88, 0x48, 0x49, 0x89, 0x4B, 0x8B,
0x8A, 0x4A, 0x4E, 0x8E, 0x8F, 0x4F, 0x8D, 0x4D, 0x4C, 0x8C,
0x44, 0x84, 0x85, 0x45, 0x87, 0x47, 0x46, 0x86, 0x82, 0x42,
0x43, 0x83, 0x41, 0x81, 0x80, 0x40
};
double g_van;
/////////////////////////////////////////////////////////////////////////////
// CListDialog
IMPLEMENT_DYNCREATE(CListDialog, CFormView)
CListDialog::CListDialog()
: CFormView(CListDialog::IDD)
{
//{{AFX_DATA_INIT(CListDialog)
n_id = 0;
//}}AFX_DATA_INIT
// m_pView=this;
}
CListDialog::~CListDialog()
{
}
void CListDialog::DoDataExchange(CDataExchange* pDX)
{
CFormView::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CListDialog)
DDX_Control(pDX, IDC_DATA_LIST, m_datalist);
DDX_Text(pDX, IDC_MACHINEID, n_id);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CListDialog, CFormView)
//{{AFX_MSG_MAP(CListDialog)
ON_MESSAGE(WM_COMM_RXCHAR, OnCommunication)
ON_WM_TIMER()
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CListDialog diagnostics
#ifdef _DEBUG
void CListDialog::AssertValid() const
{
CFormView::AssertValid();
}
void CListDialog::Dump(CDumpContext& dc) const
{
CFormView::Dump(dc);
}
#endif //_DEBUG
/////////////////////////////////////////////////////////////////////////////
// CListDialog message handlers
BOOL CListDialog::OnInitComPort()
{
if(m_Port.InitPort(this,1,9600))
{
m_Port.StartMonitoring();
SetTimer(2, 5000, NULL);//一分采樣一次
return 1;
}
return 0;
}
void CListDialog::OnInitialUpdate()
{
CFormView::OnInitialUpdate();
// TODO: Add your specialized code here and/or call the base class
OnInitialList();
memset(&nSendChar,0x00,sizeof(BYTE));
memset(&chRec,0x00,sizeof(BYTE));
//發(fā)送命令字
nSendChar[0]=0x06;
nSendChar[1]=0x04;
nSendChar[2]=0x00;
nSendChar[3]=0x00;
nSendChar[4]=0x00;
nSendChar[5]=0x24;
// unsigned short aa=CRC16(nSendChar,6);
nSendChar[6]=0xF1;
nSendChar[7]=0xA6;
//接收命令字個數(shù)
nRecnum=37;
n_rec_already=0;
n_ave=0;
ConnectDB();
if(!OnInitComPort())
AfxMessageBox("COM口沒有發(fā)現(xiàn)，或被其它設(shè)備占用");
// SetTimer(3,60000*15,NULL);//15分求一次平均數(shù)
}
LONG CListDialog::OnCommunication(WPARAM ch, LPARAM port)
{
if(port == 1)
{
chRec[n_rec_already]=(BYTE)(char *)ch;
n_rec_already++;
if(n_rec_already == 77)
{
DataProcessTemp(chRec);//完成寫數(shù)據(jù)庫和更新顯示的功能
n_rec_already = 0;
ResetBuffVal();//重新清零
}
}
return 0;
}
void CListDialog::OnTimer(UINT nIDEvent)
{
if(nIDEvent==2)
{
m_Port.WriteToPort(nSendChar,8);
}
CFormView::OnTimer(nIDEvent);
}
void CListDialog::OnInitialList()
{
m_datalist.InsertColumn(0, "時間", LVCFMT_LEFT,60);
m_datalist.InsertColumn(1, "CT", LVCFMT_LEFT,40);
m_datalist.InsertColumn(2, "PT", LVCFMT_LEFT,40);
m_datalist.InsertColumn(3, "A相電流", LVCFMT_LEFT,80);
m_datalist.InsertColumn(4, "B相電流", LVCFMT_LEFT,80);
m_datalist.InsertColumn(5, "C相電流", LVCFMT_LEFT,80);
m_datalist.InsertColumn(6, "中相電流", LVCFMT_LEFT,80);
m_datalist.InsertColumn(7, "AB線電壓", LVCFMT_LEFT,80);
m_datalist.InsertColumn(8, "BC線電壓", LVCFMT_LEFT,80);
m_datalist.InsertColumn(9, "CA線電壓", LVCFMT_LEFT,80);
m_datalist.InsertColumn(10, "AB線電壓", LVCFMT_LEFT,80);
m_datalist.InsertColumn(11, "BC線電壓", LVCFMT_LEFT,80);
m_datalist.InsertColumn(12, "CA線電壓", LVCFMT_LEFT,80);
m_datalist.InsertColumn(13, "有功功率", LVCFMT_LEFT,80);
m_datalist.InsertColumn(14, "無功功率", LVCFMT_LEFT,80);
m_datalist.InsertColumn(15, "電度數(shù)", LVCFMT_LEFT,80);
m_datalist.InsertColumn(16, "無功電度", LVCFMT_LEFT,80);
m_datalist.InsertColumn(17, "視在功率", LVCFMT_LEFT,80);
m_datalist.InsertColumn(18, "功率因數(shù)", LVCFMT_LEFT,80);
m_datalist.InsertColumn(19, "頻率", LVCFMT_LEFT,80);
ListView_SetExtendedListViewStyleEx(m_datalist.m_hWnd,
LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_INFOTIP,
LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_INFOTIP);
// m_datalist.InsertItem(0, "0123456789");
// m_datalist.SetItemText(0,1,"111");
// m_datalist.SetItemText(0,2,"222");
}
void CListDialog::ConnectDB()
{
//清空
try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("SELECT * FROM LastTime",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
_variant_t t1=m_pRecordset->GetCollect("oldday");
OldDay=t1.intVal;
CTime t=CTime::GetCurrentTime();
NewDay=t.GetYear()*10000+t.GetMonth()*100+t.GetDay();
CString SqlCmd;
CString table_name=t.Format("%Y%m%d");
if(NewDay!=OldDay)
{
//創(chuàng)建數(shù)據(jù)庫
//寫入最新日期
m_pRecordset->Delete(adAffectCurrent);
OldDay=NewDay;
SqlCmd.Format("INSERT INTO LastTime(oldday) VALUES ('%d')",NewDay);
theApp.m_pConnection->Execute(_bstr_t(SqlCmd),NULL,adCmdText);
SqlCmd.Format("CREATE TABLE %s(H_Time Datetime ,CT INTEGER,PT INTEGER,IA double,IB double,IC double,INN double,VAB double,VBC double,VCA double,VAN double,VBN double,VCN double,KW double,KVAR double,KWH double,KVARH double,KV double,PF double,HZ double)",table_name);
theApp.m_pConnection->Execute(_bstr_t(SqlCmd),NULL,adCmdText);
}
m_pRecordset->Close();
SqlCmd.Format("select * from %s",table_name);
m_pRecordset->Open(_variant_t(SqlCmd),_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
while(!m_pRecordset->adoEOF)
{
m_time = m_pRecordset->GetCollect("H_Time");
CT = m_pRecordset->GetCollect("CT");
PT = m_pRecordset->GetCollect("PT");
IA = m_pRecordset->GetCollect("IA");
IB = m_pRecordset->GetCollect("IB");
IC = m_pRecordset->GetCollect("IC");
INN= m_pRecordset->GetCollect("INN");
VAB = m_pRecordset->GetCollect("VAB");
VBC = m_pRecordset->GetCollect("VBC");
VCA = m_pRecordset->GetCollect("VCA");
VAN = m_pRecordset->GetCollect("VAN");
VBN = m_pRecordset->GetCollect("VBN");
VCN = m_pRecordset->GetCollect("VCN");
KW = m_pRecordset->GetCollect("KW");
KVAR = m_pRecordset->GetCollect("KVAR");
KWH = m_pRecordset->GetCollect("KWH");
KVARH = m_pRecordset->GetCollect("KVARH");
KV = m_pRecordset->GetCollect("KV");
PF = m_pRecordset->GetCollect("VAN");
HZ = m_pRecordset->GetCollect("VAN");
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -