【VC开源代码栏目提醒】:网学会员VC开源代码为您提供DIALOG_BOOK.cpp参考,解决您在DIALOG_BOOK.cpp学习中工作中的难题,参考学习。
// DIALOG_BOOK.cpp : implementation file
//
#include "stdafx.h"
#include "train.h"
#include "DIALOG_BOOK.h"
#include "BookInfo.h"
#include "BookSet.h"
#include "TrainPlanSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CDIALOG_BOOK dialog
CDIALOG_BOOK::CDIALOG_BOOK(CWnd* pParent /*=NULL*/)
: CDialog(CDIALOG_BOOK::IDD, pParent)
{
//{{AFX_DATA_INIT(CDIALOG_BOOK)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
course_id = 0;
}
void CDIALOG_BOOK::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CDIALOG_BOOK)
DDX_Control(pDX, IDC_LIST2, m_content2);
DDX_Control(pDX, IDC_LIST1, m_content1);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CDIALOG_BOOK, CDialog)
//{{AFX_MSG_MAP(CDIALOG_BOOK)
ON_BN_CLICKED(IDC_BUTTONADD, OnButtonadd)
ON_BN_CLICKED(IDC_BUTTONDEL, OnButtondel)
ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CDIALOG_BOOK message handlers
void CDIALOG_BOOK::OnButtonadd()
{
// TODO: Add your control notification handler code here
m_database.Close();
CBookInfo m_bookinfo;
m_bookinfo.m_database.Open(_T("train"));
m_bookinfo.DoModal();
RefreshData();
}
void CDIALOG_BOOK::RefreshData()
{
if(!m_database.IsOpen()){
m_database.Open(_T("train"));
}
m_content1.DeleteAllItems();
m_content2.DeleteAllItems();
CBookSet m_recordset1(&m_database);
CString strSQL;
strSQL.Format("select * from BOOK");
m_recordset1.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
CDBVariant varValue;
if(m_recordset1.GetRecordCount()!=0)
m_recordset1.MoveFirst();
char buf[20];
int i=0;
CString strTemp;
TRY{
while(!m_recordset1.IsEOF())
{
int temp=0;
m_recordset1.GetFieldValue(temp,varValue);
sprintf(buf,"%d",varValue.m_iVal); m_content1.InsertItem(i,buf);
m_recordset1.GetFieldValue(1,strTemp);
m_content1.SetItemText(i,1,strTemp);
m_recordset1.GetFieldValue(2,strTemp);
m_content1.SetItemText(i,2,strTemp);
m_recordset1.GetFieldValue(3,varValue);
sprintf(buf,"%d",varValue.m_chVal); m_content1.SetItemText(i,3,buf);
m_recordset1.GetFieldValue(4,varValue);
sprintf(buf,"%d",varValue.m_iVal); m_content1.SetItemText(i,4,buf);
m_recordset1.GetFieldValue(5,varValue);
sprintf(buf,"%d",varValue.m_iVal); m_content1.SetItemText(i,5,buf);
m_recordset1.GetFieldValue(6,varValue);
sprintf(buf,"%f",varValue.m_dblVal);
m_content1.SetItemText(i,6,buf);
m_recordset1.MoveNext();
i++;
}
//m_recordset1.close();
if(!m_database.IsOpen()){
m_database.Open(_T("train"));
}
// m_database.Close();
// m_database.Open(_T("train"));
CTrainPlanSet m_recordset2(&m_database);
CString strSQL2;
//strSQL2.Format("select * from COURSE_AVAILABLE where COURSE_ID= %d ",course_id);
strSQL2.Format("select * from COURSE_AVAILABLE");
m_recordset2.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL2);
if(m_recordset2.GetRecordCount()!=0)
m_recordset2.MoveFirst();
i=0;
while(!m_recordset2.IsEOF())
{
int temp=0;
m_recordset2.GetFieldValue(temp,varValue);
sprintf(buf,"%d",varValue.m_iVal); m_content2.InsertItem(i,buf);
m_recordset2.GetFieldValue(4,varValue);
sprintf(buf,"%d",varValue.m_iVal); m_cont
上一篇:
DIALOG_APPISE.cpp
下一篇:
无进程无端口DLL木马