userdel.cpp

UG调用的动态链接数据库

// UserDel.cpp : implementation file
//

#include "stdafx.h"
#include "HiCut.h"
#include "UserDel.h"
#include "Login.h"

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

/////////////////////////////////////////////////////////////////////////////
// CUserDel dialog


CUserDel::CUserDel(CWnd* pParent /*=NULL*/)
	: CDialog(CUserDel::IDD, pParent)
{
	//{{AFX_DATA_INIT(CUserDel)
	m_pass = _T("");
	//}}AFX_DATA_INIT
}


void CUserDel::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CUserDel)
	DDX_Control(pDX, IDC_COM_USER, m_com_user);
	DDX_Text(pDX, IDC_PAS, m_pass);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CUserDel message handlers

void CUserDel::OnOK() 
{
    UpdateData(TRUE);
	CDatabase m_database;
    CLogin *m_recordset = new CLogin(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[用户表]");
	//////////////////////////////////////////////////////////////////////////
	CString m_user;
	m_com_user.GetWindowText(m_user);
	extern CString m_login_user;
	if(m_login_user==m_user)
	{
		MessageBox("用户正在使用中");
			return;
	}
	for(m_recordset->MoveFirst();!m_recordset->IsEOF();m_recordset->MoveNext())
	{
		if(m_recordset->m_column1==m_user)
		{
			if(m_pass!=m_recordset->m_column2)
			{
				MessageBox("密码错误");
				return;
			}
			else 
			m_recordset->Delete();
		}
	}
//////////////////////////////
	m_database.Close();
	CDialog::OnOK();
}

BOOL CUserDel::OnInitDialog() 
{
	CDialog::OnInitDialog();	
    ShowCombox();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void CUserDel::ShowCombox()
{
	CDatabase m_database;
    CLogin *m_recordset = new CLogin(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[用户表]");
	///////////
	m_com_user.ResetContent();
	for(m_recordset->MoveFirst();!m_recordset->IsEOF();m_recordset->MoveNext())
	{
		m_com_user.AddString(m_recordset->m_column1);
	}
	//////////////
	m_database.Close();
}