usermanager.cpp

自己弄得一个学生管理系统

// Usermanager.cpp : implementation file
//

#include "stdafx.h"
#include "StuChgManager.h"
#include "Usermanager.h"

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

extern CStuChgManagerApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CUsermanager dialog


CUsermanager::CUsermanager(CWnd* pParent /*=NULL*/)
	: CDialog(CUsermanager::IDD, pParent)
{
	//{{AFX_DATA_INIT(CUsermanager)
	m_usermaname = _T("");
	m_usermacode = _T("");
	//}}AFX_DATA_INIT
}


void CUsermanager::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CUsermanager)
	DDX_Control(pDX, IDC_USERMAcode, m_ctrlusermacode);
	DDX_Control(pDX, IDC_USERMAname, m_ctrlusermaname);
	DDX_Text(pDX, IDC_USERMAname, m_usermaname);
	DDX_Text(pDX, IDC_USERMAcode, m_usermacode);
	DDX_Control(pDX, IDC_DATAGRID1, m_usermagrid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CUsermanager, CDialog)
	//{{AFX_MSG_MAP(CUsermanager)
	ON_BN_CLICKED(IDC_USERMAENQUIRE, OnUsermaenquire)
	ON_BN_CLICKED(IDC_USERMAINSERT, OnUsermainsert)
	ON_BN_CLICKED(IDC_USERMAMODIFY, OnUsermamodify)
	ON_BN_CLICKED(IDC_USERMADELETE, OnUsermadelete)
	ON_BN_CLICKED(IDC_USERMASUBMIT, OnUsermasubmit)
	ON_BN_CLICKED(IDC_USERMANEW, OnUsermanew)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CUsermanager message handlers

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

BOOL CUsermanager::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	deleteItem = false; //初始操作失效
	insertItem = false;
	modifyItem = false;
    queryItem = false;

	m_ctrlusermaname.EnableWindow(false); //编辑框实效
	m_ctrlusermacode.EnableWindow(false);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CUsermanager::OnUsermaenquire() 
{
	// TODO: Add your control notification handler code here
	deleteItem = false; //查询有效
	insertItem = false;
	modifyItem = false;
    queryItem = true;

	m_ctrlusermaname.EnableWindow(true);
	m_ctrlusermacode.EnableWindow(false);
	m_ctrlusermaname.SetFocus();
}

void CUsermanager::OnUsermainsert() 
{
	// TODO: Add your control notification handler code here
	deleteItem = false; //插入有效
	insertItem = true;
	modifyItem = false;
    queryItem = false;

	m_ctrlusermaname.EnableWindow(true);
	m_ctrlusermacode.EnableWindow(true);
	m_ctrlusermaname.SetFocus();
}

void CUsermanager::OnUsermamodify() 
{
	// TODO: Add your control notification handler code here
	deleteItem = false; //修改有效
	insertItem = false;
	modifyItem = true;
    queryItem = false;

	m_ctrlusermaname.EnableWindow(true);
	m_ctrlusermacode.EnableWindow(true);
	m_ctrlusermaname.SetFocus();
}

void CUsermanager::OnUsermadelete() 
{
	// TODO: Add your control notification handler code here
	deleteItem = true; //删除有效
	insertItem = false;
	modifyItem = false;
    queryItem = false;

	m_ctrlusermaname.EnableWindow(true);
	m_ctrlusermacode.EnableWindow(false);
	m_ctrlusermaname.SetFocus();
}
bool CUsermanager::notExist(CString str)
{
	CString sql;//查询信息
	sql.Format("select * from users where username = \'%s\'",str);
  
	theApp.record1->raw_Close();   //关闭当前数据集they are the one
	theApp.record1->CursorLocation = adUseClient; 

	theApp.record1->Open((_bstr_t)sql,theApp.connection.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
	if(theApp.record1->RecordCount == 0)
		return true;
	return false;
}
void CUsermanager::RefreshInfo()
{
	m_ctrlusermaname.SetWindowText(""); //清空Edit框
	m_ctrlusermacode.SetWindowText("");

	m_usermagrid.SetRefDataSource(NULL);

	CString sql;
	sql = "select * from users";

	theApp.record->raw_Close();          //关闭当前的数据集
	theApp.record->CursorLocation = adUseClient;
		
	try   //捕捉异常
	{
		theApp.record->Open((_bstr_t)sql,theApp.connection.GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);
		
	}
	catch(_com_error & e)
	{
		AfxMessageBox(e.Description());
		return;                          //捕捉到异常后就不在继续执行
	}

	if(theApp.record->RecordCount > 0)   //非空集合
	{
		m_usermagrid.SetRefDataSource((LPUNKNOWN)theApp.record->DataSource);    //将查询结果显示到DataGrid控件
		m_usermagrid.Refresh();
	}
}
void CUsermanager::OnUsermasubmit() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);

	if(queryItem) //查询
	{
		if(m_usermaname.GetLength() == 0)
		{
			MessageBox("用户名不能为空！");
			m_ctrlusermaname.SetFocus();
			return;
		}
		if(notExist(m_usermaname))
		{
			MessageBox("用户不存在！");
			m_ctrlusermaname.SetFocus();
			return;
		}
		CString sql;//查询
		sql.Format("select * from users where username =\'%s\'",m_usermaname); 

		theApp.record->raw_Close();
		theApp.record->CursorLocation = adUseClient; 

		try   //捕捉异常
		{
			theApp.record->Open((_bstr_t)sql,theApp.connection.GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);		
		}
		catch(_com_error & e)
		{
			AfxMessageBox(e.Description());
			return;                          //捕捉到异常后就不在继续执行
		}
		if(theApp.record->RecordCount > 0)   //非空集合
		{ 
			m_usermagrid.SetRefDataSource((LPUNKNOWN)theApp.record->DataSource);    //将查询结果显示到DataGrid控件
			m_usermagrid.Refresh();
		} 
		m_ctrlusermaname.SetFocus();
	}
	if(deleteItem)//删除
	{
		if(m_usermaname.GetLength() == 0)
		{
			MessageBox("用户名不能为空！");
			m_ctrlusermaname.SetFocus();
			return;
		}
		if(notExist(m_usermaname))
		{
			MessageBox("用户不存在！");
			m_ctrlusermaname.SetFocus();
			return;
		}

		CString sql; //删除记录
		sql.Format("delete users where username = '%s'",m_usermaname);

		theApp.record->raw_Close();
		theApp.record->CursorLocation = adUseClient; 

		try   //捕捉异常
		{ 
		    theApp.record->Open((_bstr_t)sql,theApp.connection.GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);		
		} 
		catch(_com_error & e)
		{
			AfxMessageBox(e.Description());
			return;                          //捕捉到异常后就不在继续执行
		}
		RefreshInfo(); //刷新
		MessageBox("成功删除！");
		m_ctrlusermaname.SetFocus();
	}
	if(modifyItem) //修改
	{
		if(m_usermaname.GetLength() == 0)
		{
			MessageBox("用户名不能为空！");
			m_ctrlusermaname.SetFocus();
			return;
		}
		if(notExist(m_usermaname))
		{
			MessageBox("用户不存在！");
			m_ctrlusermaname.SetFocus();
			return;
		}
		if(m_usermacode.GetLength() == 0)
		{
			MessageBox("用户密码不能为空！");
			m_ctrlusermacode.SetFocus();
			return;
		}
		CString sql; //修改记录
		sql.Format("Update users set userpassword = '%s' where username = '%s'",m_usermacode,m_usermaname);
	
        theApp.record->raw_Close();
		theApp.record->CursorLocation = adUseClient; 

		try   //捕捉异常
		{ 
		    theApp.record->Open((_bstr_t)sql,theApp.connection.GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);		
		} 
		catch(_com_error & e)
		{
			AfxMessageBox(e.Description());
			return;                          //捕捉到异常后就不在继续执行
		}
		RefreshInfo(); //刷新
		MessageBox("修改成功！");
        m_ctrlusermaname.SetFocus();
	} 
	if(insertItem) //插入
	{
		if(m_usermaname.GetLength() == 0)
		{
			MessageBox("用户名不能为空！");
			m_ctrlusermaname.SetFocus();
			return;
		}
		if(!notExist(m_usermaname))
		{
			MessageBox("用户已存在！");
			m_ctrlusermaname.SetFocus();
			return;
		}
		if(m_usermacode.GetLength() == 0)
		{
			MessageBox("用户密码不能为空！");
			m_ctrlusermacode.SetFocus();
			return;
		}
		CString sql; //插入记录
		sql.Format("insert into users values ('%s','%s',%d)",m_usermaname,m_usermacode,1);

		theApp.record->raw_Close();
		theApp.record->CursorLocation = adUseClient; 

		try   //捕捉异常
		{ 
		    theApp.record->Open((_bstr_t)sql,theApp.connection.GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);		
		} 
		catch(_com_error & e)
		{
			AfxMessageBox(e.Description());
			return;                          //捕捉到异常后就不在继续执行
		}
		RefreshInfo(); //刷新
		MessageBox("成功插入数据！");
        m_ctrlusermaname.SetFocus();
	}
}

void CUsermanager::OnOK() 
{
	// TODO: Add extra validation here
	
	CDialog::OnOK();
}

void CUsermanager::OnUsermanew() 
{
	// TODO: Add your control notification handler code here
	this->RefreshInfo(); //刷新
}