www.pudn.com > StuMis.rar > NewInputDlg.cpp

// NewInputDlg.cpp : implementation file 
// 
 
#include "stdafx.h" 
#include "StuMis.h" 
#include "NewInputDlg.h" 
#include "ado2.h" 
 
#ifdef _DEBUG 
#define new DEBUG_NEW 
#undef THIS_FILE 
static char THIS_FILE[] = __FILE__; 
#endif 
extern CStuMisApp theApp; 
///////////////////////////////////////////////////////////////////////////// 
// CNewInputDlg property page 
 
IMPLEMENT_DYNCREATE(CNewInputDlg, CPropertyPage) 
 
CNewInputDlg::CNewInputDlg() : CPropertyPage(CNewInputDlg::IDD) 
{ 
	//{{AFX_DATA_INIT(CNewInputDlg) 
	m_stuid = _T(""); 
	m_sex = -1; 
	m_nativeplace = _T(""); 
	m_name = _T(""); 
	m_department = _T(""); 
	m_class = _T(""); 
	m_birthday = COleDateTime::GetCurrentTime(); 
	//}}AFX_DATA_INIT 
} 
 
CNewInputDlg::~CNewInputDlg() 
{ 
} 
 
void CNewInputDlg::DoDataExchange(CDataExchange* pDX) 
{ 
	CPropertyPage::DoDataExchange(pDX); 
	//{{AFX_DATA_MAP(CNewInputDlg) 
	DDX_Text(pDX, IDC_SID, m_stuid); 
	DDX_CBIndex(pDX, IDC_SEX, m_sex); 
	DDX_Text(pDX, IDC_NATIVE_PLACE, m_nativeplace); 
	DDX_Text(pDX, IDC_NAME, m_name); 
	DDX_Text(pDX, IDC_DEPARTMENT, m_department); 
	DDX_Text(pDX, IDC_CLASS, m_class); 
	DDX_DateTimeCtrl(pDX, IDC_BIRTHDAY, m_birthday); 
	//}}AFX_DATA_MAP 
} 
 
 
BEGIN_MESSAGE_MAP(CNewInputDlg, CPropertyPage) 
	//{{AFX_MSG_MAP(CNewInputDlg) 
	ON_BN_CLICKED(IDC_ADD, OnAdd) 
	//}}AFX_MSG_MAP 
END_MESSAGE_MAP() 
 
///////////////////////////////////////////////////////////////////////////// 
// CNewInputDlg message handlers 
 
BOOL CNewInputDlg::OnInitDialog()  
{ 
	CPropertyPage::OnInitDialog(); 
	 
	// TODO: Add extra initialization here 
  
	return TRUE;  // return TRUE unless you set the focus to a control 
	              // EXCEPTION: OCX Property Pages should return FALSE 
} 
 
void CNewInputDlg::OnAdd()  
{ 
	 
	// TODO: Add your control notification handler code here 
	UpdateData(); 
//	CStuMisApp *app=AfxGetApp(); 
	CString addstr,strTime; 
//	strTime.Format("%s",m_birthday.Format("%Y-%m-%d")); 
 
 
//	addstr.Format("insert into STUDENT (ID,NAME,SEX,CLASS,DEPARTMENT,NATIVE_PLACE,BIRTHDAY) values ('%s','%s',%d,'%s','%s','%s',%s)",m_stuid,m_name,m_sex,m_class,m_department,m_nativeplace,strTime);  
//	addstr.Format("insert into STUDENT (ID,NAME,SEX,NATIVE_PLACE) values ('%s','%s',%d,'%s')",m_stuid,m_name,m_sex,m_nativeplace);  
//	app->db.Execute(addstr); 
 //  m_pRecordset->AddNew();    
	theApp.m_pRs.Open(_T("SELECT * FROM STUDENT"),CADORecordset::openUnknown); 
 
	theApp.m_pRs.AddNew(); 
	theApp.m_pRs.SetFieldValue("ID",m_stuid); 
	theApp.m_pRs.SetFieldValue("NAME",m_name); 
	theApp.m_pRs.SetFieldValue("SEX",m_sex); 
	theApp.m_pRs.SetFieldValue("CLASS",m_class); 
	theApp.m_pRs.SetFieldValue("DEPARTMENT",m_department); 
	theApp.m_pRs.SetFieldValue("NATIVE_PLACE",m_nativeplace); 
	theApp.m_pRs.SetFieldValue("BIRTHDAY",m_birthday); 
	if(theApp.m_pRs.Update())AfxMessageBox("填加成功！！！"); 
	else AfxMessageBox("填加失败！！！"); 
	theApp.m_pRs.Close(); 
//	theApp.m_pRs.Requery(); 
 
//	if(theApp.db.Execute(addstr))AfxMessageBox("填加成功"); 
//	else AfxMessageBox("填加失败"); 
}