queryadmin_infodlg.cpp

是我大学事情开发的一个很经典的案例

// queryadmin_infoDlg.cpp : implementation file
//

#include "stdafx.h"
#include "pmz.h"
#include "pmzDlg.h"
#include "queryadmin_infoDlg.h"
#include "updayeadmin_infoDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// queryadmin_infoDlg dialog


queryadmin_infoDlg::queryadmin_infoDlg(CWnd* pParent /*=NULL*/)
	: CDialog(queryadmin_infoDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(queryadmin_infoDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
	m_pdb=new CDatabase;          
	m_pdb->Open( NULL, FALSE, FALSE,mydb);
}

queryadmin_infoDlg::~queryadmin_infoDlg()
{
    m_pdb->Close();
	delete m_pdb;
}
BOOL queryadmin_infoDlg::OnInitDialog()        //初始化函数  yang
{
	CDialog::OnInitDialog();
	CListCtrl* m_pList = (CListCtrl*)GetDlgItem(IDC_LIST1);
 	DWORD dwStyle= GetWindowLong(m_pList->m_hWnd, GWL_STYLE); 
    SetWindowLong( m_pList->m_hWnd, GWL_STYLE, dwStyle | LVS_REPORT);
 	
 	//设置ListCtrl可以整行选择和网格条纹
 	DWORD styles = m_pList->GetExtendedStyle();
 	m_pList->SetExtendedStyle(styles|LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
 	m_pList->SetBkColor(RGB(0xFF, 0xFF, 0xE0));
  	m_pList->SetTextBkColor(RGB(0xFF, 0xFF, 0xE0));


    //设置列的题头
	m_pList->InsertColumn(1,"管理员帐号",LVCFMT_CENTER,150);
	m_pList->InsertColumn(2,"管理员密码",LVCFMT_CENTER,200);
	m_pList->InsertColumn(3,"管理员权限",LVCFMT_CENTER,150);
	CString str2="SELECT * FROM admin_info";
	m_precordset=new admin_infodb(m_pdb);
	m_precordset->Open(admin_infodb::snapshot,str2);
	
	CString  admin_ID,admin_mima,admin_right;
	int i=0;
	
	if(m_precordset->IsEOF())
	{

	}
	else
	{
	  m_precordset->MoveFirst();
	  while(!m_precordset->IsEOF())
	  {
		
    	admin_ID=m_precordset->m_admin_ID;
		admin_mima=m_precordset->m_admin_mima;
		admin_right=m_precordset->m_admin_right;
		
		
		m_pList->InsertItem(i,admin_ID);
		m_pList->SetItemText(i,1,admin_mima);
		m_pList->SetItemText(i,2,admin_right);
		
		m_precordset->MoveNext();
		i++;
	  } 
	}

	delete m_precordset;
	return true;

}

void queryadmin_infoDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(queryadmin_infoDlg)
	DDX_Control(pDX, IDC_LIST1, m_pList);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(queryadmin_infoDlg, CDialog)
	//{{AFX_MSG_MAP(queryadmin_infoDlg)
	ON_BN_CLICKED(IDOK, Ondelete)
	ON_BN_CLICKED(IDOK2, Onupdate)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// queryadmin_infoDlg message handlers

void queryadmin_infoDlg::Ondelete() 
{
  int j;
  j=m_pList.GetSelectionMark();
  if(j<0)
  {
	  AfxMessageBox("请在列表框点击选中要删除的记录!");
	  return;
  }
  else
  {
	  if(AfxMessageBox("确实要删除此管理员吗?",MB_YESNO)==IDYES)
	  {
	  CString str;
	  str=m_pList.GetItemText(j,0);
	  CString str1="delete from admin_info where admin_ID= '"+str+"'";
      m_pdb->ExecuteSQL(str1);
	  m_pList.DeleteItem(j);
	  AfxMessageBox("删除成功!");
	  }
	  else return;
	  
  }
}

void queryadmin_infoDlg::Onupdate() 
{
  int j;
  j=m_pList.GetSelectionMark();
  if(j<0)
  {
	  AfxMessageBox("请在列表框点击选中要修改的记录!");
	  return;
  }
  else
  {
	  
      if(AfxMessageBox("确实要修改此管理员的信息吗?",MB_YESNO)==IDYES)
	  {
	  
	    updayeadmin_infoDlg  updateadmin;
	    updateadmin.admin_ID=m_pList.GetItemText(j,0);
	    updateadmin.DoModal();
		CDialog::OnOK();
	  }
	  else return;
  }	
}

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