addjiaoshixinxidlg.cpp

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

// addjiaoshixinxiDlg.cpp : implementation file
//

#include "stdafx.h"
#include "pmz.h"
#include "pmzDlg.h"
//#include "loginDlg.h"
#include "addjiaoshixinxiDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// addjiaoshixinxiDlg dialog


addjiaoshixinxiDlg::addjiaoshixinxiDlg(CWnd* pParent /*=NULL*/)
	: CDialog(addjiaoshixinxiDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(addjiaoshixinxiDlg)
	m_teacher_no = _T("");
	m_teacher_name = _T("");
	m_toffice_tel = _T("");
	m_teacher_depno = _T("");
	m_teacher_mobil = _T("");
	m_teacher_mima = _T("");
	m_strCombo = _T("");
	//}}AFX_DATA_INIT
	m_pdb=new CDatabase;          
	m_pdb->Open( NULL, FALSE, FALSE,mydb);
}
addjiaoshixinxiDlg::~addjiaoshixinxiDlg()
{
     m_pdb->Close();
	 delete m_pdb;
}

void addjiaoshixinxiDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(addjiaoshixinxiDlg)
	DDX_Control(pDX, IDC_COMBO2, m_teacher_title);
	DDX_Control(pDX, IDC_COMBO1, m_teacher_xueli);
	DDX_Text(pDX, IDC_EDIT1, m_teacher_no);
	DDX_Text(pDX, IDC_EDIT2, m_teacher_name);
	DDX_Text(pDX, IDC_EDIT3, m_toffice_tel);
	DDX_Text(pDX, IDC_EDIT5, m_teacher_depno);
	DDX_Text(pDX, IDC_EDIT4, m_teacher_mobil);
	DDX_Text(pDX, IDC_EDIT6, m_teacher_mima);
	DDX_CBString(pDX, IDC_COMBO1, m_strCombo);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(addjiaoshixinxiDlg, CDialog)
	//{{AFX_MSG_MAP(addjiaoshixinxiDlg)
	ON_BN_CLICKED(IDOK, Onaddjiaoshixinxi)
	ON_CBN_KILLFOCUS(IDC_COMBO1, OnKillfocusCombo1)
	ON_CBN_KILLFOCUS(IDC_COMBO2, OnKillfocusCombo2)
	ON_EN_KILLFOCUS(IDC_EDIT1, OnKillfocusEdit1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// addjiaoshixinxiDlg message handlers
BOOL addjiaoshixinxiDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
    
	m_teacher_xueli.AddString("本科");
	m_teacher_xueli.AddString("硕士");
	m_teacher_xueli.AddString("博士");
	//m_teacher_xueli.SetCurSel(0);

	m_teacher_title.AddString("助教");
	m_teacher_title.AddString("讲师");
	m_teacher_title.AddString("副教授");
	m_teacher_title.AddString("教授");
	m_teacher_title.AddString("硕士生导师");
	m_teacher_title.AddString("博士生导师");
	m_teacher_title.AddString("博士后");
	//m_teacher_title.SetCurSel(0);
	return true;
}

void addjiaoshixinxiDlg::Onaddjiaoshixinxi() 
{
    UpdateData(TRUE); 
	m_teacher_no.TrimLeft();
	m_teacher_no.TrimRight();
	if(	m_teacher_no.GetLength()<1)
	{
		AfxMessageBox("教师编号不能为空！");
		return;
	}
	m_teacher_name.TrimLeft();
	m_teacher_name.TrimRight();
	if(	m_teacher_name.GetLength()<1) 
	{
		AfxMessageBox("教师名称不能为空！");
		return;
	}
	
	m_toffice_tel.TrimLeft();
	m_toffice_tel.TrimRight();
	if(	m_toffice_tel.GetLength()<1) 
	{
		AfxMessageBox("教师电话号码不能为空！");
		return;
	}
	m_teacher_mobil.TrimLeft();
	m_teacher_mobil.TrimRight();
	if(	m_teacher_mobil.GetLength()<1) 
	{
		AfxMessageBox("教师手机号码不能为空！");
		return;
	}
	m_teacher_depno.TrimLeft();
	m_teacher_depno.TrimRight();
	if(	m_teacher_depno.GetLength()<1) 
	{
		AfxMessageBox("教师所在院系编号不能为空！");
		return;
	}
	m_teacher_mima.TrimLeft();
	m_teacher_mima.TrimRight();
	if(	m_teacher_mima.GetLength()<1) 
	{
		AfxMessageBox("教师的初始密码不能为空！");
		return;
	}

	CString str1,str2,str3,str4,str5,str6,str7,str8,str9;
	str1=m_teacher_no;
	str2=m_teacher_name;
	int index=m_teacher_xueli.GetCurSel();
	m_teacher_xueli.GetLBText(index,str3);
	if(str3=="")
	{
		AfxMessageBox("请选择教师学历!");
		return;
	}
	index=m_teacher_title.GetCurSel();
	m_teacher_title.GetLBText(index,str4);
	if(str4=="")
	{
		AfxMessageBox("请选择教师职称!");
		return;
	}
	str5=m_toffice_tel;
	str6=m_teacher_mobil;
	str7=m_teacher_depno;
	str8=m_teacher_mima;
	str9="insert into T_info VALUES('"+str1+"','"+str2+"','"+str3+"','"+str4+"','"+str5+"','"+str6+"','"+str7+"','"+str8+"')";
    
	CString str="SELECT * FROM T_info where T_no='"+str1+"' ";
	m_precordset=new T_infodb(m_pdb);
    m_precordset->Open(T_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_EDIT5)->SetWindowText("");
		return;
	}
	else
	{
	   m_pdb->ExecuteSQL(str9);
	   AfxMessageBox("恭喜你!"+m_teacher_name+"教师添加成功!");
	}
	
	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(""); 	
}


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



void addjiaoshixinxiDlg::OnKillfocusCombo1() 
{
	// TODO: Add your control notification handler code here
	CComboBox* m_strCombo1=(CComboBox*)GetDlgItem(IDC_COMBO1);
 	m_strCombo1->SetWindowText("");
}

void addjiaoshixinxiDlg::OnKillfocusCombo2() 
{
	// TODO: Add your control notification handler code here
	CComboBox* m_strCombo2=(CComboBox*)GetDlgItem(IDC_COMBO2);
 	m_strCombo2->SetWindowText("");
}

void addjiaoshixinxiDlg::OnKillfocusEdit1() 
{
	// TODO: Add your control notification handler code here
	
}