addyuanxixinxidlg.cpp

是我大学事情开发的一个很经典的案例

// addyuanxixinxiDlg.cpp : implementation file
//

#include "stdafx.h"
#include "pmz.h"
#include "addyuanxixinxiDlg.h"
#include "pmzDlg.h"     //yang
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// addyuanxixinxiDlg dialog


addyuanxixinxiDlg::addyuanxixinxiDlg(CWnd* pParent /*=NULL*/)
	: CPmzDlg(pParent)
{
	//{{AFX_DATA_INIT(addyuanxixinxiDlg)
	m_department_no = _T("");
	m_department_name = _T("");
	m_department_tel = _T("");
	m_dean_name = _T("");
	//}}AFX_DATA_INIT
	m_pdb=new CDatabase;          
	m_pdb->Open( NULL, FALSE, FALSE,mydb);
}

addyuanxixinxiDlg::~addyuanxixinxiDlg()
{
   m_pdb->Close();
	delete m_pdb;
}
void addyuanxixinxiDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(addyuanxixinxiDlg)
	DDX_Text(pDX, IDC_EDIT1, m_department_no);
	DDX_Text(pDX, IDC_EDIT2, m_department_name);
	DDX_Text(pDX, IDC_EDIT3, m_department_tel);
	DDX_Text(pDX, IDC_EDIT4, m_dean_name);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(addyuanxixinxiDlg, CDialog)
	//{{AFX_MSG_MAP(addyuanxixinxiDlg)
	ON_BN_CLICKED(IDOK, OnaddyuanxixinxiOK)
	ON_WM_NCLBUTTONDOWN()
	ON_WM_NCMOUSEMOVE()
	ON_WM_SYSCOMMAND()
	ON_WM_SIZE()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// addyuanxixinxiDlg message handlers

void addyuanxixinxiDlg::OnaddyuanxixinxiOK() 
{

	
	UpdateData(TRUE); 
	m_department_no.TrimLeft();
	m_department_no.TrimRight();
	if(	m_department_no.GetLength()<1)
	{
		AfxMessageBox("院系编号不能为空！");
		return;
	}
	m_department_name.TrimLeft();
	m_department_name.TrimRight();
	if(	m_department_name.GetLength()<1) 
	{
		AfxMessageBox("院系名称不能为空！");
		return;
	}
	m_department_tel.TrimLeft();
	m_department_tel.TrimRight();
	if(	m_department_tel.GetLength()<1) 
	{
		AfxMessageBox("院系电话号码不能为空！");
		return;
	}
	m_dean_name.TrimLeft();
	m_dean_name.TrimRight();
	if(	m_dean_name.GetLength()<1) 
	{
		AfxMessageBox("系主任姓名不能为空！");
		return;
	}

	CString str1,str2,str3,str4,str5;
	str1=m_department_no;
	str2=m_department_name;
	str3=m_department_tel;
	str4=m_dean_name;
	str5="insert into department_info VALUES('"+str1+"','"+str2+"','"+str3+"','"+str4+"')";
    
	CString str="SELECT * FROM department_info where department_no='"+str1+"' ";
	m_precordset=new department_infodb(m_pdb);
    m_precordset->Open(department_infodb::snapshot,str);
    if(!m_precordset->IsEOF())
	{
		AfxMessageBox("已有此编号的院系,请重新输入院系编号!");
		this->GetDlgItem(IDC_EDIT1)->SetWindowText("");
		return;
	}
	else
	{
	   m_pdb->ExecuteSQL(str5);
	   AfxMessageBox("添加成功!");
	}
	
	this->GetDlgItem(IDC_EDIT1)->SetWindowText("");
	this->GetDlgItem(IDC_EDIT2)->SetWindowText("");
	this->GetDlgItem(IDC_EDIT3)->SetWindowText("");
    this->GetDlgItem(IDC_EDIT4)->SetWindowText(""); 
}

void addyuanxixinxiDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}

void addyuanxixinxiDlg::OnNcLButtonDown(UINT nHitTest, CPoint point)
{
	CPmzDlg::OnNcLButtonDown(nHitTest, point);
}

void addyuanxixinxiDlg::OnNcMouseMove(UINT nHitTest, CPoint point) 
{
	CPmzDlg::OnNcMouseMove(nHitTest, point); 
}

void addyuanxixinxiDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	CPmzDlg::OnSysCommand(nID, lParam);
}

void addyuanxixinxiDlg::OnSize(UINT nType, int cx, int cy) 
{
	CDialog::OnSize(nType, cx, cy);
	
	// TODO: Add your message handler code here
	
}