editprofile.cpp

通过VC++6.0连接数据库,实现的是一个公司设备管理系统,采购设备,借出和归还设备的详细记录,提高库存管理.

// EditProfile.cpp : implementation file
//

#include "stdafx.h"
#include "DeviceDBS.h"
#include "EditProfile.h"
#include "User.h"

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

/////////////////////////////////////////////////////////////////////////////
// CEditProfile dialog
extern User user;

CEditProfile::CEditProfile(CWnd* pParent /*=NULL*/)
	: CDialog(CEditProfile::IDD, pParent)
{
	//{{AFX_DATA_INIT(CEditProfile)
//	m_strBirth = _T("");
//	m_strGender = _T("");
//	m_strLoginID = _T("");
//	m_strName = _T("");
//	m_strPwd = _T("");
	//}}AFX_DATA_INIT
	m_strLoginID = user.getId();
	m_strName = user.getName();
	m_strPwd = user.getPwd();
	m_strGender = user.getGender();
	m_strBirth = user.getBirth();
}


void CEditProfile::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEditProfile)
	DDX_Text(pDX, IDC_Birth, m_strBirth);
	DDX_Text(pDX, IDC_Gender, m_strGender);
	DDX_Text(pDX, IDC_LoginID, m_strLoginID);
	DDX_Text(pDX, IDC_Name, m_strName);
	DDX_Text(pDX, IDC_PASSWORD, m_strPwd);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CEditProfile, CDialog)
	//{{AFX_MSG_MAP(CEditProfile)
	ON_BN_CLICKED(IDOK, OnSAVE)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CEditProfile message handlers

void CEditProfile::OnSAVE() 
{
	UpdateData(true);
	m_pDB->BeginTrans();
	CString sql;
	sql.Format("execute update_user_info '%s','%s','%s','%s','%s',"
		"'%d'", m_strLoginID,m_strPwd,m_strName,m_strBirth,m_strGender,user.getPower());
	TRACE(sql);
	//AfxMessageBox(sql);
	m_pDB->ExecuteSQL(sql);
	AfxMessageBox("更改成功!");
	m_pDB->CommitTrans();
	CRecordset rs(m_pDB);
	//更新用户信息
	sql.Format("Select * from user_info "
			"where loginID = '%s' ",m_strLoginID);
	rs.Open(CRecordset::snapshot, sql);
	if(!rs.IsEOF()) {
		//更新User
		CString id;
		rs.GetFieldValue((short)0, id);
		user.setId(id);

		CString pwd;
		rs.GetFieldValue(1,pwd);
		user.setPwd(pwd);

		CString name;
		rs.GetFieldValue(2,name);
		user.setName(name);

		CString birth;
		rs.GetFieldValue(3,birth);
			user.setBirth(birth);

		CString gender;
		rs.GetFieldValue(4,gender);
		user.setGender(gender);

		CDBVariant var;
		rs.GetFieldValue(5, var, SQL_C_SSHORT);
		if (var.m_dwType != DBVT_NULL)	
			user.setPower(var.m_iVal);
		var.Clear();
	}

}

void CEditProfile::initData()
{
	m_strLoginID = user.getId();
	m_strName = user.getName();
	m_strPwd = user.getPwd();
	m_strGender = user.getGender();
	m_strBirth = user.getBirth();
	UpdateData(false);

}

void CEditProfile::OnCancel() 
{
	
	CDialog::OnCancel();
}

BOOL CEditProfile::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here



	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}