deluser.cpp

VC＋＋开发的一个电话录音程序

// DelUser.cpp : implementation file
//

#include "stdafx.h"
#include "phonerec.h"
#include "DelUser.h"

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


extern CDatabase g_dbCust;	

static char	g_szaUserListTitle[user_max][16] = 
{
	"用户名",
	"+用户",
	"-用户",
	"浏览",
	"改权",
	"启/退",
	"系设",
	"删录",
	"录设"
};

static int	g_izUserListWidth[user_max] = { 65, 50, 50, 50, 50, 50, 50, 50,50 };

/////////////////////////////////////////////////////////////////////////////
// CDelUser dialog


CDelUser::CDelUser(CWnd* pParent /*=NULL*/)
	: CDialog(CDelUser::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDelUser)
	//}}AFX_DATA_INIT
}


void CDelUser::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDelUser)
	DDX_Control(pDX, IDCANCEL, m_btnExit);
	DDX_Control(pDX, IDC_BUTTON_DEL_USER, m_btnDelUser);
	DDX_Control(pDX, IDC_LIST_DEL_USER, m_ListDelUser);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDelUser, CDialog)
	//{{AFX_MSG_MAP(CDelUser)
	ON_BN_CLICKED(IDC_BUTTON_DEL_USER, OnButtonDelUser)
	ON_WM_CLOSE()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDelUser message handlers

BOOL CDelUser::OnInitDialog() 
{
	CDialog::OnInitDialog();

	for( int i = 0; i < user_max; i++ )
	{
		m_ListDelUser.InsertColumn(i,	g_szaUserListTitle[i],	LVCFMT_CENTER, g_izUserListWidth[i] );
	}
	m_ListDelUser.SetExtendedStyle( LVS_EX_GRIDLINES |  LVS_EX_CHECKBOXES | LVS_EX_FULLROWSELECT );
	m_btnDelUser.SetIcon( IDR_DEL );
	m_btnExit.SetIcon( IDR_EXIT );
//	m_ListDelUser.SetExtendedStyle( LVS_EX_CHECKBOXES );

	InitListCtrl();

	
	return TRUE;  
}

void CDelUser::InitListCtrl()
{
	m_ListDelUser.DeleteAllItems();
		
	CRecordset rs( &g_dbCust );
	CString strUserName;
	CString bAddUser;
	CString bDelUser;
	CString bBrowseUser;
	CString bModifyUser;
	CString bStartExit;
	CString bSetSys;
	CString bDelRecord;
	CString bEableRecord;

	m_iUserCount = 0;
	
	BOOL bOpen = rs.Open( CRecordset::dynaset,
		_T( "Select *  from Users ") );
	while( !rs.IsEOF( ) )
	{
		rs.GetFieldValue( "Name", strUserName );
		rs.GetFieldValue( "AddUser", bAddUser );
		rs.GetFieldValue( "DelUser", bDelUser );
		rs.GetFieldValue( "BrosweUser", bBrowseUser );
		rs.GetFieldValue( "ModifyPopedom", bModifyUser );
		rs.GetFieldValue( "StartExit", bStartExit );
		rs.GetFieldValue( "SetSys", bSetSys );
		rs.GetFieldValue( "DelReData", bDelRecord );
		rs.GetFieldValue( "EableRecord", bEableRecord );

		if( strUserName.Compare("super") )
		{
			char buffer[8];
			sprintf(buffer,"%d",m_iUserCount);
			m_ListDelUser.InsertItem(m_iUserCount,buffer);
			
			m_ListDelUser.SetItem(m_iUserCount, 0,LVIF_TEXT, strUserName, -1,0,0,0);
			m_ListDelUser.SetItem(m_iUserCount, 1,LVIF_TEXT, CovertIntToCString( bAddUser ), -1,0,0,0);
			m_ListDelUser.SetItem(m_iUserCount, 2,LVIF_TEXT, CovertIntToCString( bDelUser ), -1,0,0,0);
			m_ListDelUser.SetItem(m_iUserCount, 3,LVIF_TEXT, CovertIntToCString( bBrowseUser ), -1,0,0,0);
			m_ListDelUser.SetItem(m_iUserCount, 4,LVIF_TEXT, CovertIntToCString( bModifyUser ), -1,0,0,0);
			m_ListDelUser.SetItem(m_iUserCount, 5,LVIF_TEXT, CovertIntToCString( bStartExit ), -1,0,0,0);
			m_ListDelUser.SetItem(m_iUserCount, 6,LVIF_TEXT, CovertIntToCString( bSetSys ), -1,0,0,0);
			m_ListDelUser.SetItem(m_iUserCount, 7,LVIF_TEXT, CovertIntToCString( bDelRecord ), -1,0,0,0);
			m_ListDelUser.SetItem(m_iUserCount, 8,LVIF_TEXT, CovertIntToCString( bEableRecord ), -1,0,0,0);
			
			m_iUserCount++;
		}
		rs.MoveNext();	
	}
	rs.Close();
}
void CDelUser::OnButtonDelUser() 
{
	UpdateData();
	
	CString strUserName;
	for ( int i = m_ListDelUser.GetItemCount() - 1; i >= 0; i-- )
	{
		if ( m_ListDelUser.GetCheck( i ) )
		{			
			strUserName = m_ListDelUser.GetItemText( i , 0 );
			CString strSQLDel = "delete from Users Where Name = '"+ strUserName + "'";
			g_dbCust.ExecuteSQL( strSQLDel);
			m_ListDelUser.DeleteItem( i );
		}
	}
}
void CDelUser::OnClose() 
{
 	CDialog::OnClose();
}

CString CDelUser::CovertIntToCString(CString str)
{
	if( !str.Compare( "1" ))
	{
		return "√";
	}
	else
	{
		return "";
	}
}