ydls.cpp

ado封装类,adoconn,用法有具体实例,包括查询数据库,列表显示等

// YDLS.cpp : implementation file
//

#include "stdafx.h"
#include "MKJC.h"
#include "YDLS.h"
#include "ADOConn.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CYDLS dialog


CYDLS::CYDLS(CWnd* pParent /*=NULL*/)
	: CDialog(CYDLS::IDD, pParent)
{
	//{{AFX_DATA_INIT(CYDLS)
	m_time = 0;
	m_time1 = 0;
	//}}AFX_DATA_INIT
}


void CYDLS::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CYDLS)
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_time);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER2, m_time1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CYDLS, CDialog)
	//{{AFX_MSG_MAP(CYDLS)
	ON_BN_CLICKED(IDC_ChaXun, OnChaXun)
	ON_BN_CLICKED(IDC_Cancel, OnCancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()



/////////////////////////////////////////////////////////////////////////////
// CYDLS message handlers

BOOL CYDLS::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_list.SetExtendedStyle(LVS_EX_FLATSB|LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_list.InsertColumn(0,"ID",LVCFMT_LEFT,60,0);
	m_list.InsertColumn(1,"姓名",LVCFMT_LEFT,80,1);
	m_list.InsertColumn(2,"体温",LVCFMT_LEFT,60,2);
	m_list.InsertColumn(3,"脉搏",LVCFMT_LEFT,60,3);
	m_list.InsertColumn(4,"位置",LVCFMT_LEFT,80,6);
	m_list.InsertColumn(5,"x坐标",LVCFMT_LEFT,60,7);
	m_list.InsertColumn(6,"y坐标",LVCFMT_LEFT,60,8);
	m_list.InsertColumn(7,"时间",LVCFMT_LEFT,150,9);
    ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString sql;
	sql.Format("select* from YDJD order by YDSJ desc");
	m_AdoConn.GetRecordSet((_bstr_t)sql);
	while(m_AdoConn.m_pRecordset->adoEOF==0)
	{
		m_list.InsertItem(0,"");
		m_list.SetItemText(0,0,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDID"));
		m_list.SetItemText(0,1,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDXM"));
		m_list.SetItemText(0,2,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDTW"));
		m_list.SetItemText(0,3,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDMB"));
		m_list.SetItemText(0,4,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDWZ"));
		m_list.SetItemText(0,5,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDWZ_X"));
		m_list.SetItemText(0,6,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDWZ_Y"));
		m_list.SetItemText(0,7,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDSJ"));

		m_AdoConn.m_pRecordset->MoveNext();
	}
	m_AdoConn.ExitConnect();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CYDLS::OnChaXun() 
{
	// TODO: Add your control notification handler code here
	 UpdateData(true);
	m_list.DeleteAllItems();
	int y;
	int m;
	int d;
	y=m_time.GetYear();
	CString stry;
	stry.Format("%d",y);
	CString strm;
	m=m_time.GetMonth();
	strm.Format("%d",m);
	CString strd;
	d=m_time.GetDay();
	strd.Format("%d",d);

	int yy;
	int mm;
	int dd;
	yy=m_time1.GetYear();
	CString stryy;
	stryy.Format("%d",yy);
	CString strmm;
	mm=m_time1.GetMonth();
	strmm.Format("%d",mm);
	CString strdd;
	dd=m_time1.GetDay();
	strdd.Format("%d",dd);

	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString sql;
	CString id;
	CEdit* pEdit=(CEdit*)GetDlgItem(IDC_EDIT1);
	pEdit->GetWindowText(id);
	sql.Format("select* from YDJD where YDID='%s' and year(YDSJ)>="+stry+" and year(YDSJ)<="+stryy+" and month(YDSJ)>="+strm+" and month(YDSJ)<="+strmm+" and day(YDSJ)>="+strd+" and day(YDSJ)<="+strdd+" order by YDSJ desc",id);
	m_AdoConn.GetRecordSet((_bstr_t)sql);
	while(m_AdoConn.m_pRecordset->adoEOF==0)
	{
		m_list.InsertItem(0,"");
		m_list.SetItemText(0,0,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDID"));
		m_list.SetItemText(0,1,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDXM"));
		m_list.SetItemText(0,2,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDTW"));
		m_list.SetItemText(0,3,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDMB"));
		m_list.SetItemText(0,4,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDWZ"));
		m_list.SetItemText(0,5,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDWZ_X"));
		m_list.SetItemText(0,6,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDWZ_Y"));
		m_list.SetItemText(0,7,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("YDSJ"));

		m_AdoConn.m_pRecordset->MoveNext();
	}

	m_AdoConn.ExitConnect();
	UpdateData(false);

}

void CYDLS::OnCancel() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();
}