📄 蓄电池充放电检测系统dlg.cpp
字号:
CString sExcelFile,sPath;
CString sSql;
//获取主程序所在路径,存在sPath中
GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
sPath.ReleaseBuffer ();
int nPos;
nPos=sPath.ReverseFind ('\\');
sPath=sPath.Left (nPos);
sExcelFile = sPath + "\\蓄电池充放电数据.xls"; // 要建立的Excel文件
TRY
{
// 创建进行存取的字符串
sSql.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s",sDriver, sExcelFile, sExcelFile);
// 创建数据库 (既Excel表格文件)
if( database.OpenEx(sSql,CDatabase::noOdbcDialog) )
{
// 创建表结构(姓名、年龄)
sSql = "CREATE TABLE Exceldemo (电压 NUMBER,电流 NUMBER,时间 NUMBER)";
database.ExecuteSQL(sSql);
// 插入数值
sSql = "INSERT INTO Exceldemo (电压,电流,时间) VALUES (58.8,26.53,12)";
database.ExecuteSQL(sSql);
sSql = "INSERT INTO Exceldemo (电压,电流,时间) VALUES (58.8,26.83,12)";
database.ExecuteSQL(sSql);
}
// 关闭数据库
database.Close();
AfxMessageBox("成功导出!");
}
CATCH_ALL(e)
{
TRACE1("Excel驱动没有安装: %s",sDriver);
}
END_CATCH_ALL;
}
void CMyDlg::OnCancel()
{
// TODO: Add extra cleanup here
CDialog::OnCancel();
}
void CMyDlg::OnSize(UINT nType, int cx, int cy)
{
CDialog::OnSize(nType, cx, cy);
if(winbz==true)
{
CRect rectDlg;
GetWindowRect(rectDlg);
m_scope.Invalidate();//重画刻度及曲线
}
}
void CMyDlg::OnButton1()
{
CString strFileName;
CFileDialog dlg(false, "EC", ".bmp",OFN_HIDEREADONLY|OFN_OVERWRITEPROMPT,"手机电池放电曲线图|*.bmp");
dlg.m_ofn.lpstrTitle="保存为位图";
if( dlg.DoModal() == IDCANCEL )return ;
strFileName = dlg.GetFileName();
strFileName =strFileName.Left(strFileName.GetLength()-4);//取文件名
strFileName=strFileName+"锂电池放电曲线图";
AfxGetMainWnd()->SetWindowText(strFileName);
strFileName=strFileName+".bmp";
//for(int a=0;a<100000;a++){}
CRect rect;
GetWindowRect(&rect);
HBITMAP hMap = CopyScreenToBitmap(rect);
char *szValue=(LPSTR)(LPCTSTR)strFileName;
SaveBitmapToFile(hMap,szValue);
AfxGetMainWnd()->SetWindowText("手机锂电池容量测试系统");
}
void CMyDlg::OnButton5()
{
if(m_bSerialPortOpened)
{
CString strSend;
strSend="K1200";
SendNMEAData(strSend);
}
}
void CMyDlg::OnClose()
{
CDialog::OnClose();
}
void CMyDlg::OnVScroll(UINT nSBCode, UINT nPos, CScrollBar* pScrollBar)
{
// TODO: Add your message handler code here and/or call default
CDialog::OnVScroll(nSBCode, nPos, pScrollBar);
}
void CMyDlg::OnDestroy() //关闭窗口前
{
CDialog::OnDestroy();
if(m_bSerialPortOpened)//如果串口打开
{
CString strSend;
strSend="CKD00";
SendNMEAData(strSend);
}
}
void CMyDlg::OnButton6()
{
}
void CMyDlg::OnSelchangeCombo1()
{
}
void CMyDlg::OnSelendokCombo1()
{
}
HBITMAP CMyDlg::CopyScreenToBitmap(LPRECT lpRect)
{
HDC hScrDC, hMemDC;
// 屏幕和内存设备描述表
HBITMAP hBitmap,hOldBitmap;
// 位图句柄
int nX, nY, nX2, nY2;
// 选定区域坐标
int nWidth, nHeight;
// 位图宽度和高度
int xScrn, yScrn;
// 屏幕分辨率
// 确保选定区域不为空矩形
if (IsRectEmpty(lpRect))
return NULL;
//为屏幕创建设备描述表
hScrDC = CreateDC("DISPLAY", NULL, NULL, NULL);
//为屏幕设备描述表创建兼容的内存设备描述表
hMemDC = CreateCompatibleDC(hScrDC);
// 获得选定区域坐标
nX = lpRect->left;
nY = lpRect->top;
nX2 = lpRect->right;
nY2 = lpRect->bottom;
// 获得屏幕分辨率
xScrn = GetDeviceCaps(hScrDC, HORZRES);
yScrn = GetDeviceCaps(hScrDC, VERTRES);
//确保选定区域是可见的
if (nX < 0)
nX = 0;
if (nY < 0)
nY = 0;
if (nX2 > xScrn)
nX2 = xScrn;
if (nY2 > yScrn)
nY2 = yScrn;
nWidth = nX2 - nX;
nHeight = nY2 - nY;
// 创建一个与屏幕设备描述表兼容的位图
hBitmap=CreateCompatibleBitmap(hScrDC,nWidth,nHeight);
// 把新位图选到内存设备描述表中
hOldBitmap=(HBITMAP)SelectObject(hMemDC,hBitmap);
// 把屏幕设备描述表拷贝到内存设备描述表中
BitBlt(hMemDC,0,0, nWidth,nHeight,hScrDC, nX, nY, SRCCOPY);
//得到屏幕位图的句柄
hBitmap=(HBITMAP)SelectObject(hMemDC,hOldBitmap);
//清除
DeleteDC(hScrDC);
DeleteDC(hMemDC);
// 返回位图句柄
return hBitmap;
}
int CMyDlg::SaveBitmapToFile(HBITMAP hBitmap, LPSTR lpFileName)
{
//lpFileName 为位图文件名
HDC hDC;
//设备描述表
int iBits;
//当前显示分辨率下每个像素所占字节数
WORD wBitCount;
//位图中每个像素所占字节数
//定义调色板大小, 位图中像素字节大小 , 位图文件大小 , 写入文件字节数
DWORD dwPaletteSize=0,dwBmBitsSize,dwDIBSize, dwWritten;
BITMAP Bitmap;
//位图属性结构
BITMAPFILEHEADER bmfHdr;
//位图文件头结构
BITMAPINFOHEADER bi;
//位图信息头结构
LPBITMAPINFOHEADER lpbi;
//指向位图信息头结构
HANDLE fh, hDib, hPal;
HPALETTE hOldPal=NULL;
//定义文件,分配内存句柄,调色板句柄
//计算位图文件每个像素所占字节数
hDC = CreateDC("DISPLAY",NULL,NULL,NULL);
iBits = GetDeviceCaps(hDC, BITSPIXEL) *
GetDeviceCaps(hDC, PLANES);
DeleteDC(hDC);
if (iBits <= 1)
wBitCount = 1;
else if (iBits <= 4)
wBitCount = 4;
else if (iBits <= 8)
wBitCount = 8;
else if (iBits <= 24)
wBitCount = 24;
else
wBitCount = 32;
//计算调色板大小
if (wBitCount <= 8)
dwPaletteSize=(1<<wBitCount)*sizeof(RGBQUAD);
//设置位图信息头结构
GetObject(hBitmap, sizeof(BITMAP), (LPSTR)&Bitmap);
bi.biSize = sizeof(BITMAPINFOHEADER);
bi.biWidth = Bitmap.bmWidth;
bi.biHeight = Bitmap.bmHeight;
bi.biPlanes = 1;
bi.biBitCount = wBitCount;
bi.biCompression = BI_RGB;
bi.biSizeImage = 0;
bi.biXPelsPerMeter = 0;
bi.biYPelsPerMeter = 0;
bi.biClrUsed = 0;
bi.biClrImportant = 0;
dwBmBitsSize = ((Bitmap.bmWidth*wBitCount+31)/32)*4*Bitmap.bmHeight;
//为位图内容分配内存
/*xxxxxxxx计算位图大小分解一下(解释一下上面的语句)xxxxxxxxxxxxxxxxxxxx
//每个扫描行所占的字节数应该为4的整数倍,具体算法为:
int biWidth = (Bitmap.bmWidth*wBitCount) / 32;
if((Bitmap.bmWidth*wBitCount) % 32)
biWidth++; //不是整数倍的加1
biWidth *= 4;//到这里,计算得到的为每个扫描行的字节数。
dwBmBitsSize = biWidth * Bitmap.bmHeight;//得到大小
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx*/
hDib = GlobalAlloc(GHND,dwBmBitsSize+dwPaletteSize+sizeof(BITMAPINFOHEADER));
lpbi = (LPBITMAPINFOHEADER)GlobalLock(hDib);
*lpbi = bi;
// 处理调色板
hPal = GetStockObject(DEFAULT_PALETTE);
if (hPal)
{
hDC = ::GetDC(NULL);
hOldPal=SelectPalette(hDC,(HPALETTE)hPal,FALSE);
RealizePalette(hDC);
}
// 获取该调色板下新的像素值
GetDIBits(hDC,hBitmap,0,(UINT)Bitmap.bmHeight,(LPSTR)lpbi+sizeof(BITMAPINFOHEADER)+dwPaletteSize, (BITMAPINFO *)lpbi,DIB_RGB_COLORS);
//恢复调色板
if (hOldPal)
{
SelectPalette(hDC, hOldPal, TRUE);
RealizePalette(hDC);
::ReleaseDC(NULL, hDC);
}
//创建位图文件
fh=CreateFile(lpFileName, GENERIC_WRITE,0, NULL, CREATE_ALWAYS,FILE_ATTRIBUTE_NORMAL | FILE_FLAG_SEQUENTIAL_SCAN, NULL);
if (fh==INVALID_HANDLE_VALUE)
return FALSE;
// 设置位图文件头
bmfHdr.bfType = 0x4D42; // "BM"
dwDIBSize=sizeof(BITMAPFILEHEADER)+sizeof(BITMAPINFOHEADER)+dwPaletteSize+dwBmBitsSize;
bmfHdr.bfSize = dwDIBSize;
bmfHdr.bfReserved1 = 0;
bmfHdr.bfReserved2 = 0;
bmfHdr.bfOffBits = (DWORD)sizeof(BITMAPFILEHEADER)+(DWORD)sizeof(BITMAPINFOHEADER)+dwPaletteSize;
// 写入位图文件头
WriteFile(fh, (LPSTR)&bmfHdr, sizeof(BITMAPFILEHEADER), &dwWritten, NULL);
// 写入位图文件其余内容
WriteFile(fh, (LPSTR)lpbi, sizeof(BITMAPINFOHEADER)+dwPaletteSize+dwBmBitsSize , &dwWritten, NULL);
//清除
GlobalUnlock(hDib);
GlobalFree(hDib);
CloseHandle(fh);
return TRUE;
}
BOOL CMyDlg::PreCreateWindow(CREATESTRUCT& cs)
{
// TODO: Add your specialized code here and/or call the base class
return CDialog::PreCreateWindow(cs);
}
void CMyDlg::DataProcessTemp(BYTE m_Inbuff[])
{
if(m_Inbuff[1]=='D')//如表示是接收数据
{
unsigned short int temp,jz;
CString str;
float jg,dla,dy;
int dl;
CString kk;
//时间计算
oldsecond++;
if(oldsecond>59)
{
oldsecond=0;
oldmin++;
if(oldmin>59)
{
oldhour++;
if(oldhour>99)oldhour=0;
oldmin=0;
}
}
jz=m_Inbuff[2]*0x100+m_Inbuff[3];//基准赋值
temp=m_Inbuff[4]*0x100+m_Inbuff[5];
jg=(float)((2.52*temp)/jz);
if(oldsecond%15==0&&dy>3)//15秒显示一次
m_scope.SetVale(jg-3);//送显示
if(jg<2)jg=0;
dy=jg;
str.Format("%2.2f",jg);
m_lcda.SetText(_T(str+" V"));//显示电压的文本
if(jg<3.3)//低电压停止放电
{
CString strSend;strSend="C1200";SendNMEAData(strSend);//发送停止命令
jsbz=1;//放电结束标志置位
}
temp=m_Inbuff[6]*0x100+m_Inbuff[7];
jg=(float)((2.52*temp)/jz);
dl=(int)jg/5.6*1000;
if(jg<0.5)jg=0;
str.Format("%1.3f",jg/5.6);
m_lcdv.SetText(_T(str+" A"));//显示电流的文本
if(oldhour==0&&oldmin==0&&oldsecond==0)//初始化第一个波形
{
if(dy>3)
m_scope.SetVale(dla-3);//送显示
}
if(jg>0.1)//如电流大于设定值方才计时
{
kk.Format("%02d:%02d:%02d",oldhour,oldmin,oldsecond);
m_clock.SetText(_T(kk));//显示时间文本
}
if(dl>100)
{
int miao=3600*oldhour+60*oldmin+oldsecond;
int ls=(dl*miao)/3600;
str.Format("%04d",ls);
m_lcdah.SetText(_T(str+" mAH"));//显示容量文本
}
}
else if(m_Inbuff[1]=='C')//如表示是接收命令
{
unsigned char i;
CString a;
for(i=0;i<6;i++)
a+=m_Inbuff[2+i];
if(a=="KDTXWX")
{
SetDlgItemText(IDC_BUTTON2,"开 始");
ljbz=1;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -