insert.cpp

人事管理系统.SQL的数据库．所用密码和用户名均是５３１

// Insert.cpp : implementation file
//

#include "stdafx.h"
#include "people2.h"
#include "Insert.h"
#include "MODIPeople.h" 
#include "people.h"

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

/////////////////////////////////////////////////////////////////////////////
// Insert dialog


Insert::Insert(CWnd* pParent /*=NULL*/)
	: CDialog(Insert::IDD, pParent)
{
	//{{AFX_DATA_INIT(Insert)
	m_Department = _T("");
	m_Edulevel = _T("");
	m_Email = _T("");
	m_Job = _T("");
	m_Name = _T("");
	m_Remark = _T("");
	m_Age = _T("");
	m_Phone = _T("");
	m_Number = _T("");
	m_Departnum = _T("");
	//}}AFX_DATA_INIT
}


void Insert::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Insert)
	DDX_Control(pDX, IDC_Insert_COMBO, m_Sex);
	DDX_Text(pDX, IDC_Department_EDIT, m_Department);
	DDX_Text(pDX, IDC_Edulevel_EDIT, m_Edulevel);
	DDX_Text(pDX, IDC_Email_EDIT, m_Email);
	DDX_Text(pDX, IDC_Job_EDIT, m_Job);
	DDX_Text(pDX, IDC_Name_EDIT, m_Name);
	DDX_Text(pDX, IDC_Remark_EDIT, m_Remark);
	DDX_Text(pDX, IDC_Age_EDIT, m_Age);
	DDV_MaxChars(pDX, m_Age, 2);
	DDX_Text(pDX, IDC_Phone_EDIT, m_Phone);
	DDX_Text(pDX, IDC_Number_EDIT, m_Number);
	DDV_MaxChars(pDX, m_Number, 4);
	DDX_Text(pDX, IDC_Departnum_EDIT, m_Departnum);
	DDV_MaxChars(pDX, m_Departnum, 3);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Insert, CDialog)
	//{{AFX_MSG_MAP(Insert)
	ON_BN_CLICKED(IDC_OK, OnOk)
	ON_BN_CLICKED(IDC_CANCLE, OnCancle)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Insert message handlers

BOOL Insert::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	if(strSex="男")
		m_Sex.SetCurSel(0);
	else
		m_Sex.SetCurSel(1);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void Insert::OnOk() 
{
	// TODO: Add your control notification handler code here
	Cpeople emp;
	UpdateData();
	//检查数据有效性
		Cpeople Num;
	if(m_Number=="")
	{
	MessageBox("请输入员工编号！");
		return;
	}
		//判断部门编号是否存在
	else if(Num.HaveNumber(m_Number)==1)
	{
		MessageBox("员工编号已存在,请重新输入！");
		return;
	}
	
	//对MODIPeople对象赋值
	m_Sex.GetLBText(m_Sex.GetCurSel(),strSex);
	emp.SetName(m_Name);
	emp.SetSex(strSex);
	emp.SetAge(m_Age);
	emp.SetDepartment(m_Department);
	emp.SetJob(m_Job);
	emp.SetPhone(m_Phone);
	emp.SetEmail(m_Email);
	emp.SetEdulevel(m_Edulevel);
	emp.SetDepartnum(m_Departnum);
	emp.SetRemark(m_Remark);
	emp.SetNumber(m_Number);
	//根据成员cNumber变量的值,决定是插入数据,还是修改数据
	if(vNumber=="")//插入数据  
		emp.sql_insert();
	else 
	emp.sql_update(vNumber);
	CDialog::OnOK();
}

void Insert::OnCancle() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();
}