user.cpp

员工管理系统,基本的数据库操作,数据库类的设计,基本的查询等

// User.cpp : implementation file
//

#include "stdafx.h"
#include "数据库.h"
#include "User.h"
#include "ADOConn.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CUser dialog


CUser::CUser(CWnd* pParent /*=NULL*/)
	: CDialog(CUser::IDD, pParent)
{
	//{{AFX_DATA_INIT(CUser)
	m_name = _T("");
	m_pws = _T("");
	//}}AFX_DATA_INIT
}


void CUser::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CUser)
	DDX_Text(pDX, IDC_EDIT1, m_name);
	DDX_Text(pDX, IDC_EDIT2, m_pws);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CUser, CDialog)
	//{{AFX_MSG_MAP(CUser)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CUser message handlers

void CUser::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	m_name.TrimLeft();
	m_name.TrimRight();

	if(m_name=="")
	{
		MessageBox("请输入用户名");
		return;
	}
	if(m_pws=="")
	{
		MessageBox("请输入密码");
		return;
	}
	ADOConn m_Adoconn;
	m_Adoconn.OnInitADOConn();
    CString sql;
	sql.Format("select * from 用户表 where 用户名='%s' and 密码='%s'",m_name,m_pws);
	_bstr_t vsql;
	vsql=(_bstr_t)sql;
	_RecordsetPtr Recordset;
     Recordset=m_Adoconn.GetRecordSet(vsql);
	 if(Recordset->adoEOF)
	 {
		 MessageBox("用户名或密码错误");
		 return;
	 }
    _variant_t var;
	//int j;
	 Recordset->get_Collect(variant_t("用户类型"),(_variant_t*)(&var));
	 if(var.vt!=VT_NULL)
	 {
	   j=var.iVal;
	 }
	 m_Adoconn.ExitConnect();

	CDialog::OnOK();
}

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

int CUser::getj()
{
return j;
}