userinfodlg.cpp

用Visual C++ 开发的项目管理系统

// UserInfoDlg.cpp : implementation file
//

#include "stdafx.h"
#include "FileMaSys.h"
#include "UserInfoDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CFileMaSysApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CUserInfoDlg dialog


CUserInfoDlg::CUserInfoDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CUserInfoDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CUserInfoDlg)
	m_cWork = _T("");
	m_cSex = _T("");
	//}}AFX_DATA_INIT
	m_bExist=FALSE;
}


void CUserInfoDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CUserInfoDlg)
	DDX_Control(pDX, IDC_BTN_MODIFY, m_ModifyControl);
	DDX_Control(pDX, IDC_BTN_ADD, m_AddControl);
	DDX_Control(pDX, IDC_COMBO_NAME, m_NameControl);
	DDX_Text(pDX, IDC_EDIT_WORK, m_cWork);
	DDX_Text(pDX, IDC_EDIT_SEX, m_cSex);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CUserInfoDlg, CDialog)
	//{{AFX_MSG_MAP(CUserInfoDlg)
	ON_CBN_SELCHANGE(IDC_COMBO_NAME, OnSelchangeComboName)
	ON_CBN_KILLFOCUS(IDC_COMBO_NAME, OnKillfocusComboName)
	ON_BN_CLICKED(IDC_BTN_ADD, OnBtnAdd)
	ON_BN_CLICKED(IDC_BTN_MODIFY, OnBtnModify)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CUserInfoDlg message handlers

BOOL CUserInfoDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_RecordUserInfo.CreateInstance("ADODB.Recordset");
	CString sql;
	sql="Select * From WorkerName";
	m_RecordUserInfo->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),
		                   adOpenDynamic,adLockPessimistic,adCmdText);
	while (!m_RecordUserInfo->adEOF)
	{
		CString str=m_RecordUserInfo->GetCollect("Name").bstrVal;
        m_NameControl.AddString(str);
		m_RecordUserInfo->MoveNext();
	}
	//设置添加按钮不使能
	m_AddControl.EnableWindow(FALSE);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CUserInfoDlg::OnSelchangeComboName() 
{
	// TODO: Add your control notification handler code here
	m_AddControl.EnableWindow(FALSE);
	long i=m_NameControl.GetCurSel();
	m_RecordUserInfo->MoveFirst();
	m_RecordUserInfo->Move(i);
	m_cWork=m_RecordUserInfo->GetCollect("Party").bstrVal;
	m_cSex=m_RecordUserInfo->GetCollect("Sex").bstrVal;
	UpdateData(FALSE);
}

//DEL void CUserInfoDlg::OnEditchangeComboName() 
//DEL {
//DEL 	// TODO: Add your control notification handler code here
//DEL 	
//DEL 
//DEL }
//输入名字以后判断是否激活添加按钮
void CUserInfoDlg::OnKillfocusComboName() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_NameControl.GetWindowText(m_cName);
	if (m_cName.IsEmpty())
	{
		m_AddControl.EnableWindow(FALSE);
	}
	else
	{
		m_RecordUserInfo->MoveFirst();
		while (!m_RecordUserInfo->adEOF)
		{
			CString str=m_RecordUserInfo->GetCollect("Name").bstrVal;
			if (str==m_cName)
			{
				m_bExist=TRUE;
				m_AddControl.EnableWindow(FALSE);
				break;
			}
			m_RecordUserInfo->MoveNext();
		}
	}
	if (!m_bExist)
	{
		m_AddControl.EnableWindow(TRUE);
		m_cWork.Empty();
	    m_cSex.Empty();
		
	}
	
	UpdateData(FALSE);
	m_bExist=FALSE;
}
//添加人员信息
void CUserInfoDlg::OnBtnAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_RecordUserInfo->AddNew();
	m_RecordUserInfo->PutCollect("Name",_variant_t(m_cName));
	m_RecordUserInfo->PutCollect("Party",_variant_t(m_cWork));
	m_RecordUserInfo->PutCollect("Sex",_variant_t(m_cSex));
	m_RecordUserInfo->Update();
	m_AddControl.EnableWindow(FALSE);
}

void CUserInfoDlg::OnBtnModify() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	m_RecordUserInfo->MoveFirst();
	while (!m_RecordUserInfo->adEOF)
	{
		CString str=m_RecordUserInfo->GetCollect("Name").bstrVal;
		if (str==m_cName)
		{
			m_RecordUserInfo->PutCollect("Party",_variant_t(m_cWork));
			m_RecordUserInfo->PutCollect("Sex",_variant_t(m_cSex));
			m_RecordUserInfo->Update();
			MessageBox("修改成功");
			return ;
		} 
		m_RecordUserInfo->MoveNext();
	}
	MessageBox("数据库中不存在记录,无法修改");
}