dlgemployee.cpp

连接SQL数据库的系统源码,对于初学者十分有参考价值哦

// DlgEmployee.cpp : implementation file
//

#include "stdafx.h"
#include "MerchandiseStore.h"
#include "DlgEmployee.h"

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

#include "Database.h"
//-------------global 
extern CDatabase m_hDatabase ;
//------------end

/////////////////////////////////////////////////////////////////////////////
// CDlgEmployee dialog


CDlgEmployee::CDlgEmployee(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgEmployee::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgEmployee)
	//}}AFX_DATA_INIT
}


void CDlgEmployee::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgEmployee)
	DDX_Control(pDX, IDC_CMB_DEPARTMENT, m_hCmbDepartment);
	DDX_Control(pDX, IDC_TAB_EMPLOYEE, m_hTabEmployee);
	DDX_Control(pDX, IDC_LIST_EMPLOYEE, m_hListEmployee);
	DDX_Control(pDX, IDC_EDIT_SEX, m_hEditSex);
	DDX_Control(pDX, IDC_EDIT_PHONE, m_hEditPhone);
	DDX_Control(pDX, IDC_EDIT_NATIONALITY, m_hEditNationality);
	DDX_Control(pDX, IDC_EDIT_NAME, m_hEditName);
	DDX_Control(pDX, IDC_EDIT_KNOWLEDGE, m_hEditKnowledge);
	DDX_Control(pDX, IDC_EDIT_EMPLOYEEID, m_hEditEmployeeID);
	DDX_Control(pDX, IDC_EDIT_AGE, m_hEditAge);
	DDX_Control(pDX, IDC_EDIT_ADDRESS, m_hEditAddress);
	DDX_Control(pDX, IDC_EDIT_ACADEMY, m_hEditAcademy);
	DDX_Control(pDX, IDOK, m_hBtnOk);
	DDX_Control(pDX, IDD_BTN_SAVE, m_hBtnSave);
	DDX_Control(pDX, IDD_BTN_MOD, m_hBtnMod);
	DDX_Control(pDX, IDD_BTN_DEL, m_hBtnDel);
	DDX_Control(pDX, IDD_BTN_ADD, m_hBtnAdd);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgEmployee, CDialog)
	//{{AFX_MSG_MAP(CDlgEmployee)
	ON_NOTIFY(NM_CLICK, IDC_LIST_EMPLOYEE, OnClickListEmployee)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST_EMPLOYEE, OnDblclkListEmployee)
	ON_NOTIFY(TCN_SELCHANGE, IDC_TAB_EMPLOYEE, OnSelchangeTabEmployee)
	ON_BN_CLICKED(IDD_BTN_ADD, OnBtnAdd)
	ON_BN_CLICKED(IDD_BTN_DEL, OnBtnDel)
	ON_BN_CLICKED(IDD_BTN_MOD, OnBtnMod)
	ON_BN_CLICKED(IDD_BTN_SAVE, OnBtnSave)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgEmployee message handlers

BOOL CDlgEmployee::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	InitCtrlData() ;
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDlgEmployee::OnClickListEmployee(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	char m_szEmployeeID[30+1] ;
	m_hListEmployee.GetItemText(m_hListEmployee.GetSelectionMark(), 0, m_szEmployeeID, sizeof(m_szEmployeeID)) ;

	m_hDatabase.EditEmployeeToCtrl(m_szEmployeeID, &m_hEditSex,&m_hEditPhone,&m_hEditNationality,&m_hEditName,&m_hEditKnowledge,&m_hEditEmployeeID,&m_hCmbDepartment,&m_hEditAge,&m_hEditAddress,&m_hEditAcademy) ;
	
	*pResult = 0;
}

void CDlgEmployee::OnDblclkListEmployee(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	TabCtrlOfSelect(0) ;
	
	*pResult = 0;
}

void CDlgEmployee::OnSelchangeTabEmployee(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	switch(m_hTabEmployee.GetCurSel())
	{
	case 0:
			TabCtrlOfSelect(0) ;
		break ;
	case 1:
			TabCtrlOfSelect(1) ;
		break ;
	}	
	*pResult = 0;
}

void CDlgEmployee::InitCtrlData()
{
///INIT BUTTON CTRL
	m_hBtnOk.SetIcon(IDI_ICON_CLOSE);
	m_hBtnOk.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, shBtnColor);
	m_hBtnOk.SetColor(CButtonST::BTNST_COLOR_FG_IN, RGB(0, 128, 0));

	m_hBtnSave.SetIcon(IDI_ICON_OK);
	m_hBtnSave.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, shBtnColor);
	m_hBtnSave.SetColor(CButtonST::BTNST_COLOR_FG_IN, RGB(0, 128, 0));
	m_hBtnSave.EnableWindow(FALSE) ;

	m_hBtnDel.SetIcon(IDI_ICON_DEL);
	m_hBtnDel.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, shBtnColor);
	m_hBtnDel.SetColor(CButtonST::BTNST_COLOR_FG_IN, RGB(0, 128, 0));

	m_hBtnAdd.SetIcon(IDI_ICON_ADD);
	m_hBtnAdd.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, shBtnColor);
	m_hBtnAdd.SetColor(CButtonST::BTNST_COLOR_FG_IN, RGB(0, 128, 0));

	m_hBtnMod.SetIcon(IDI_ICON_MOD);
	m_hBtnMod.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, shBtnColor);
	m_hBtnMod.SetColor(CButtonST::BTNST_COLOR_FG_IN, RGB(0, 128, 0));

//Init tab ctrl 
	m_hTabEmployee.InsertItem(0, "员工基本信息") ;
	m_hTabEmployee.InsertItem(1, "员工信息列表") ;
	m_hTabEmployee.ShowWindow(TRUE) ;

	m_hListEmployee.InsertColumn(0, "员工编号", LVCFMT_CENTER, 80) ;
	m_hListEmployee.InsertColumn(1, "员工姓名", LVCFMT_CENTER, 50) ;
	m_hListEmployee.InsertColumn(2, "性别", LVCFMT_CENTER, 50) ;
	m_hListEmployee.InsertColumn(3, "年龄", LVCFMT_CENTER, 60) ;
	m_hListEmployee.InsertColumn(4, "学历", LVCFMT_CENTER, 100) ;
	m_hListEmployee.InsertColumn(5, "民族", LVCFMT_CENTER, 120) ;
	m_hListEmployee.InsertColumn(6, "毕业学院", LVCFMT_CENTER, 100) ;
	m_hListEmployee.InsertColumn(7, "联系方式", LVCFMT_CENTER, 100) ;
	m_hListEmployee.InsertColumn(8, "家庭住址", LVCFMT_CENTER, 100) ;
	m_hListEmployee.InsertColumn(9, "部门", LVCFMT_CENTER, 100) ;
	m_hListEmployee.SetExtendedStyle(m_hListEmployee.GetStyle() | LVS_EX_FULLROWSELECT);
//
	TabCtrlOfSelect(1) ;
	m_hDatabase.InitEmployeeData(&m_hCmbDepartment) ;
}

void CDlgEmployee::TabCtrlOfSelect(int m_nSelected)
{
	switch(m_nSelected)
	{
	case 0:
		{
			m_hTabEmployee.SetCurSel(0) ;
		//---
			m_hEditEmployeeID.ShowWindow(TRUE) ;
			m_hEditSex.ShowWindow(TRUE) ;
			m_hEditPhone.ShowWindow(TRUE) ;
			m_hEditNationality.ShowWindow(TRUE) ;
			m_hEditName.ShowWindow(TRUE) ;
			m_hCmbDepartment.ShowWindow(TRUE) ;
			m_hEditAge.ShowWindow(TRUE) ;
			m_hEditAddress.ShowWindow(TRUE) ;
			m_hEditAcademy.ShowWindow(TRUE) ;
			m_hEditKnowledge.ShowWindow(TRUE) ;
			
			m_hListEmployee.ShowWindow(FALSE) ;
			m_hEditEmployeeID.SetFocus() ;
			break ;
		}
	case 1:
		{
			m_hTabEmployee.SetCurSel(1) ;
			//-----
			m_hEditEmployeeID.ShowWindow(FALSE) ;
			m_hEditSex.ShowWindow(FALSE) ;
			m_hEditPhone.ShowWindow(FALSE) ;
			m_hEditNationality.ShowWindow(FALSE) ;
			m_hEditName.ShowWindow(FALSE) ;
			m_hCmbDepartment.ShowWindow(FALSE) ;
			m_hEditAge.ShowWindow(FALSE) ;
			m_hEditAddress.ShowWindow(FALSE) ;
			m_hEditAcademy.ShowWindow(FALSE) ;
			m_hEditKnowledge.ShowWindow(FALSE) ;
			
			m_hListEmployee.ShowWindow(TRUE) ;
			break ;
		}
	}
	m_hDatabase.ListEmployeeToCtrl(&m_hListEmployee) ;
}

void CDlgEmployee::OnBtnAdd() 
{
	// TODO: Add your control notification handler code here
	switch(m_hTabEmployee.GetCurSel())
	{
	case 0:
		{
			break ;
		}
	case 1:
		{
			TabCtrlOfSelect(0) ;
			break ;
		}
	}
	m_hEditEmployeeID.SetWindowText("") ;
	m_hEditSex.SetWindowText("") ;
	m_hEditPhone.SetWindowText("") ;
	m_hEditNationality.SetWindowText("") ;
	m_hEditName.SetWindowText("") ;
	m_hCmbDepartment.SetWindowText("") ;
	m_hEditAge.SetWindowText("") ;
	m_hEditAddress.SetWindowText("") ;
	m_hEditAcademy.SetWindowText("") ;
	m_hEditKnowledge.SetWindowText("") ;

	m_hBtnSave.EnableWindow() ;
}

void CDlgEmployee::OnBtnDel() 
{
	// TODO: Add your control notification handler code here
	if(m_hListEmployee.GetSelectionMark() == -1)
	{//未被选中
		MessageBox("请选择欲删除条目!") ;
		return ;
	}
	char m_szEmployeeID[30+1] ;
	m_hListEmployee.GetItemText(m_hListEmployee.GetSelectionMark(), 0, m_szEmployeeID, sizeof(m_szEmployeeID)) ;
	m_hDatabase.DeleteDataWhere(EMPE, m_szEmployeeID) ;
	m_hDatabase.ListEmployeeToCtrl(&m_hListEmployee) ;
}

void CDlgEmployee::OnBtnMod() 
{
	// TODO: Add your control notification handler code here
	switch(m_hTabEmployee.GetCurSel())
	{
	case 0:
		{
			break ;
		}
	case 1:
		{
			if(m_hListEmployee.GetSelectionMark() == -1)
			{//未被选中
				MessageBox("请选择欲修改条目!") ;
				return ;
			}
			break ;
		}
	}
	TabCtrlOfSelect(0) ;
	m_hBtnSave.EnableWindow() ;
	m_hEditEmployeeID.SetFocus() ;
}

void CDlgEmployee::OnBtnSave() 
{
	// TODO: Add your control notification handler code here
	char m_szEditEmployeeID[30+1], m_szName[30+1], m_szSex[10+1], m_szAge[5+1], 
		m_szKnowledge[30+1], m_szNationality[10+1], m_szAcademy[30+1],
		m_szPhone[30+1],m_szAddress[50+1],m_szDepartment[30+1] ;

	m_hEditEmployeeID.GetWindowText(m_szEditEmployeeID, sizeof(m_szEditEmployeeID)) ;
	m_hEditSex.GetWindowText(m_szSex, sizeof(m_szSex)) ;
	m_hEditPhone.GetWindowText(m_szPhone, sizeof(m_szPhone)) ;
	m_hEditNationality.GetWindowText(m_szNationality, sizeof(m_szNationality)) ;
	m_hEditName.GetWindowText(m_szName, sizeof(m_szName)) ;
	m_hCmbDepartment.GetWindowText(m_szDepartment, sizeof(m_szDepartment)) ;
	m_hEditAge.GetWindowText(m_szAge, sizeof(m_szAge)) ;
	m_hEditAddress.GetWindowText(m_szAddress, sizeof(m_szAddress)) ;
	m_hEditAcademy.GetWindowText(m_szAcademy, sizeof(m_szAcademy)) ;
	m_hEditKnowledge.GetWindowText(m_szKnowledge, sizeof(m_szKnowledge)) ;
	//保存修改,更新数据库
	m_hDatabase.UpdateEmployeeData(m_szEditEmployeeID,m_szName,m_szSex,m_szAge,m_szKnowledge,m_szNationality,
		m_szAcademy,m_szPhone,m_szAddress,m_szDepartment) ;

	m_hBtnSave.EnableWindow(FALSE) ;
}