dlgoperator.cpp

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

// DlgOperator.cpp : implementation file
//

#include "stdafx.h"
#include "MerchandiseStore.h"
#include "DlgOperator.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

/////////////////////////////////////////////////////////////////////////////
// CDlgOperator dialog


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


void CDlgOperator::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgOperator)
	DDX_Control(pDX, IDD_BTN_ADD111, m_hBtnAdd);
	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, IDC_EDIT_PASSWORD, m_hEditPassword);
	DDX_Control(pDX, IDC_EDIT_NAME, m_hEditName);
	DDX_Control(pDX, IDC_CMB_ROLE, m_hCmbRole);
	DDX_Control(pDX, IDC_EDIT_ID, m_hEditID);
	DDX_Control(pDX, IDC_TAB_OPERATOR, m_hTabOperator);
	DDX_Control(pDX, IDC_LIST_OPERATOR, m_hListOperator);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgOperator, CDialog)
	//{{AFX_MSG_MAP(CDlgOperator)
	ON_NOTIFY(NM_CLICK, IDC_LIST_OPERATOR, OnClickListOperator)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST_OPERATOR, OnDblclkListOperator)
	ON_NOTIFY(TCN_SELCHANGE, IDC_TAB_OPERATOR, OnSelchangeTabOperator)
	ON_BN_CLICKED(IDD_BTN_DEL, OnBtnDel)
	ON_BN_CLICKED(IDD_BTN_MOD, OnBtnMod)
	ON_BN_CLICKED(IDD_BTN_SAVE, OnBtnSave)
	ON_BN_CLICKED(IDD_BTN_ADD111, OnBtnAdd111)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgOperator message handlers

BOOL CDlgOperator::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 CDlgOperator::OnClickListOperator(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	char m_szID[30+1] ;
	m_hListOperator.GetItemText(m_hListOperator.GetSelectionMark(), 0, m_szID, sizeof(m_szID)) ;

	m_hDatabase.EditOperatorToCtrl(m_szID, &m_hEditID,&m_hEditName,&m_hEditPassword,&m_hCmbRole) ;
	
	*pResult = 0;
}

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

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

void CDlgOperator::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));

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

	m_hListOperator.InsertColumn(0, "编号", LVCFMT_CENTER, 50) ;
	m_hListOperator.InsertColumn(1, "姓名", LVCFMT_CENTER, 80) ;
	m_hListOperator.InsertColumn(2, "密码", LVCFMT_CENTER, 80) ;
	m_hListOperator.InsertColumn(3, "角色", LVCFMT_CENTER, 80) ;;
	m_hListOperator.SetExtendedStyle(m_hListOperator.GetStyle() | LVS_EX_FULLROWSELECT);
//
	TabCtrlOfSelect(1) ;
	m_hDatabase.InitOperatorData(&m_hCmbRole) ;
}

void CDlgOperator::TabCtrlOfSelect(int m_nSelected)
{
	switch(m_nSelected)
	{
	case 0:
		{
			m_hTabOperator.SetCurSel(0) ;
		//---
			m_hEditID.ShowWindow(TRUE) ;
			m_hEditName.ShowWindow(TRUE) ;
			m_hEditPassword.ShowWindow(TRUE) ;
			m_hCmbRole.ShowWindow(TRUE) ;
			
			m_hListOperator.ShowWindow(FALSE) ;
			m_hEditID.SetFocus() ;
			break ;
		}
	case 1:
		{
			m_hTabOperator.SetCurSel(1) ;
			//-----
			m_hEditID.ShowWindow(FALSE) ;
			m_hEditName.ShowWindow(FALSE) ;
			m_hEditPassword.ShowWindow(FALSE) ;
			m_hCmbRole.ShowWindow(FALSE) ;
			
			m_hListOperator.ShowWindow(TRUE) ;
			break ;
		}
	}
	m_hDatabase.ListOperatorToCtrl(&m_hListOperator) ;
}

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

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

void CDlgOperator::OnBtnSave() 
{
	// TODO: Add your control notification handler code here
	char m_szID[30+1], m_szName[30+1], m_szPassword[30+1], m_szRole[30+1] ;

	m_hEditID.GetWindowText(m_szID, sizeof(m_szID)) ;
	m_hEditName.GetWindowText(m_szName, sizeof(m_szName)) ;
	m_hEditPassword.GetWindowText(m_szPassword, sizeof(m_szPassword)) ;
	m_hCmbRole.GetWindowText(m_szRole, sizeof(m_szRole)) ;

	//保存修改,更新数据库
	m_hDatabase.UpdateOperatorData(m_szID,m_szName,m_szPassword,m_szRole) ;

	m_hBtnSave.EnableWindow(FALSE) ;	
}

BOOL CDlgOperator::PreTranslateMessage(MSG* pMsg) 
{
	
	return CDialog::PreTranslateMessage(pMsg);
}

void CDlgOperator::OnBtnAdd111() 
{
	switch(m_hTabOperator.GetCurSel())
	{
	case 0:
		{
			break ;
		}
	case 1:
		{
			TabCtrlOfSelect(0) ;
			break ;
		}
	}
	m_hEditID.SetWindowText("") ;
	m_hEditName.SetWindowText("") ;
	m_hEditPassword.SetWindowText("") ;
	m_hCmbRole.SetWindowText("") ;

	m_hBtnSave.EnableWindow() ;	
}