adminmanagedlg.cpp

ACCESS数据库+MFC编写的学生数据库管理系统

// AdminmanageDlg.cpp : implementation file
//

#include "stdafx.h"
#include "学籍管理系统.h"
#include "AdminmanageDlg.h"
#include "LoginRecordSet.h"
#include "AddadminDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAdminmanageDlg dialog


CAdminmanageDlg::CAdminmanageDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAdminmanageDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAdminmanageDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CAdminmanageDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAdminmanageDlg)
	DDX_Control(pDX, IDC_LIST_ADMIN, m_adminlist);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAdminmanageDlg, CDialog)
	//{{AFX_MSG_MAP(CAdminmanageDlg)
	ON_BN_CLICKED(ID_ADMIN_ADD, OnAdminAdd)
	ON_BN_CLICKED(ID_ADMIN_DEL, OnAdminDel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAdminmanageDlg message handlers

BOOL CAdminmanageDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_adminlist.SetExtendedStyle   (LVS_EX_FULLROWSELECT   |LVS_EX_GRIDLINES   |LVS_EX_INFOTIP);
	m_adminlist.InsertColumn(0,"用户名",LVCFMT_LEFT,100);
	m_adminlist.InsertColumn(1,"密码",LVCFMT_LEFT,100);	
	m_adminlist.InsertColumn(2,"备注",LVCFMT_LEFT,124);	
	Update();

	return TRUE;  
}





void CAdminmanageDlg::OnAdminAdd() 
{
	// TODO: Add your control notification handler code here
	CAddadminDlg dlg;
	dlg.DoModal();
	Update();
	
}

void CAdminmanageDlg::OnAdminDel() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	int nItem=GetSelect();
	if (nItem==-2)
	{
		AfxMessageBox("请选择要删除的用户");
		return;
	}
	CString name=m_adminlist.GetItemText(nItem,0);
	CString sqlstr;
	if (AfxMessageBox("确认删除用户"+name+"吗?",MB_YESNO)==IDNO)
	{
		return;
	}
	else
	{
		sqlstr.Format("delete from admin where admin='%s'",name);
		RunSql(sqlstr);
		Update();
		MessageBox("删除成功!");
		
	}


	
}

void CAdminmanageDlg::Update()
{
	m_adminlist.DeleteAllItems();
	CLoginRecordSet rs;
	if(rs.IsOpen())
		rs.Close();
	rs.Open(CRecordset::dynaset,NULL,CRecordset::none);	
	
	while(!rs.IsEOF())
	{
		m_adminlist.InsertItem(0,rs.m_admin);
		m_adminlist.SetItemText(0, 1 ,"******");
		rs.MoveNext();

	}
	rs.Close();
}

int CAdminmanageDlg::GetSelect()
{
	// TODO: Add your control notification handler code here

      for(int i=0; i<m_adminlist.GetItemCount(); i++)
      {
           if( m_adminlist.GetItemState(i, LVIS_SELECTED) == LVIS_SELECTED )
           {
				return i;//当有一行被选中,返回行号
           }
      }
	  return -2;//如果未选中任何一行则返回-2
	

}
void CAdminmanageDlg::RunSql(CString sql)
{
		CDatabase db;
		CLoginRecordSet delnum;
		db.Open(delnum.GetDefaultConnect());
		db.ExecuteSQL(sql);
	

}