addxueshengxinxidlg.cpp

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

// addxueshengxinxiDlg.cpp : implementation file
//

#include "stdafx.h"
#include "pmz.h"
#include "addxueshengxinxiDlg.h"
#include "pmzDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// addxueshengxinxiDlg dialog


addxueshengxinxiDlg::addxueshengxinxiDlg(CWnd* pParent /*=NULL*/)
	: CDialog(addxueshengxinxiDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(addxueshengxinxiDlg)
	m_sno = _T("");
	m_sname = _T("");
	m_sage = _T("");
	m_splace = _T("");
	m_sclass = _T("");
	m_department_sno = _T("");
	m_smima = _T("");
	//}}AFX_DATA_INIT
	m_pdb=new CDatabase;          
	m_pdb->Open( NULL, FALSE, FALSE,mydb);
}

addxueshengxinxiDlg::~addxueshengxinxiDlg()
{
     m_pdb->Close();
	 delete m_pdb;
}
void addxueshengxinxiDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(addxueshengxinxiDlg)
	DDX_Control(pDX, IDC_COMBO1, m_ssex);
	DDX_Text(pDX, IDC_EDIT1, m_sno);
	DDX_Text(pDX, IDC_EDIT2, m_sname);
	DDX_Text(pDX, IDC_EDIT3, m_sage);
	DDX_Text(pDX, IDC_EDIT4, m_splace);
	DDX_Text(pDX, IDC_EDIT5, m_sclass);
	DDX_Text(pDX, IDC_EDIT6, m_department_sno);
	DDX_Text(pDX, IDC_EDIT7, m_smima);
	//}}AFX_DATA_MAP
	
}


BEGIN_MESSAGE_MAP(addxueshengxinxiDlg, CDialog)
	//{{AFX_MSG_MAP(addxueshengxinxiDlg)
	ON_BN_CLICKED(IDOK, Onaddxueshengxinxi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// addxueshengxinxiDlg message handlers
BOOL addxueshengxinxiDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
    
	//m_ssex.AddString("男");
	//m_ssex.AddString("女");
	//m_ssex.SetCurSel(0);
	return true;
}

void addxueshengxinxiDlg::Onaddxueshengxinxi() 
{   
	UpdateData(TRUE); 
	m_sno.TrimLeft();
	m_sno.TrimRight();
	if(m_sno.GetLength()<1)
	{
		AfxMessageBox("学生学号不能为空！");
		return;
	}
	m_sname.TrimLeft();
	m_sname.TrimRight();
	if(	m_sname.GetLength()<1) 
	{
		AfxMessageBox("学生姓名不能为空！");
		return;
	}
	
	m_sage.TrimLeft();
	m_sage.TrimRight();
	if(	m_sage.GetLength()<1) 
	{
		AfxMessageBox("学生年龄不能为空！");
		return;
	}
	m_splace.TrimLeft();
	m_splace.TrimRight();
	if(	m_splace.GetLength()<1) 
	{
		AfxMessageBox("学生地址不能为空！");
		return;
	}
	m_sclass.TrimLeft();
	m_sclass.TrimRight();
	if(	m_sclass.GetLength()<1) 
	{
		AfxMessageBox("学生班级不能为空！");
		return;
	}
    m_department_sno.TrimLeft();
	m_department_sno.TrimRight();
	if(	m_department_sno.GetLength()<1) 
	{
		AfxMessageBox("学生所在院系编号不能为空！");
		return;
	}
	m_smima.TrimLeft();
	m_smima.TrimRight();
	if(	m_smima.GetLength()<1) 
	{
		AfxMessageBox("学生初始密码不能为空！");
		return;
	}




	CString str1,str2,str3,str4,str5,str6,str7,str8,str9;
	str1=m_sno;
	str2=m_sname;
	int index=m_ssex.GetCurSel();
	m_ssex.GetLBText(index,str3);
	if(str3=="")
	{
		AfxMessageBox("请选择性别!");
		return;
	}
	str4=m_sage;
	str5=m_splace;
	str6=m_sclass;
	str7=m_department_sno;
	str8=m_smima;
	str9="insert into S_info VALUES('"+str1+"','"+str2+"','"+str3+"','"+str4+"','"+str5+"','"+str6+"','"+str7+"','"+str8+"')";
    
	CString str="SELECT * FROM S_info where S_no='"+str1+"' ";
	m_precordset=new S_infodb(m_pdb);
    m_precordset->Open(S_infodb::snapshot,str);
    if(!m_precordset->IsEOF())
	{
		AfxMessageBox("已有此学号,请重新输入学号!");
		this->GetDlgItem(IDC_EDIT1)->SetWindowText("");
		return;
	}
	CString str10="SELECT * FROM department_info where department_no='"+str7+"' ";
	m_pdeprecordset=new department_infodb(m_pdb);
    m_pdeprecordset->Open(department_infodb::snapshot,str10);
	if(m_pdeprecordset->IsEOF())
	{
		AfxMessageBox("没有此编号的院系,请重新输入院系编号!");
		this->GetDlgItem(IDC_EDIT6)->SetWindowText("");
		return;
	}
	else
	{
	   m_pdb->ExecuteSQL(str9);
	   AfxMessageBox("添加成功!");
	}
	
	this->GetDlgItem(IDC_EDIT1)->SetWindowText("");
	this->GetDlgItem(IDC_EDIT2)->SetWindowText("");
	this->GetDlgItem(IDC_EDIT3)->SetWindowText("");
    this->GetDlgItem(IDC_EDIT4)->SetWindowText(""); 
	this->GetDlgItem(IDC_EDIT5)->SetWindowText("");
	this->GetDlgItem(IDC_EDIT6)->SetWindowText("");
	this->GetDlgItem(IDC_EDIT7)->SetWindowText(""); 

	
}

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