chaxunjiaoshixinxidlg.cpp

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

// chaxunjiaoshixinxiDlg.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// chaxunjiaoshixinxiDlg dialog


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


void chaxunjiaoshixinxiDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(chaxunjiaoshixinxiDlg)
	DDX_Control(pDX, IDC_LIST1, m_pList);
	//}}AFX_DATA_MAP
}
chaxunjiaoshixinxiDlg::~chaxunjiaoshixinxiDlg()   //yang
{
	m_pdb->Close();                               //yang
	delete m_pdb;                                 //yang
}

BEGIN_MESSAGE_MAP(chaxunjiaoshixinxiDlg, CDialog)
	//{{AFX_MSG_MAP(chaxunjiaoshixinxiDlg)
	ON_BN_CLICKED(IDOK, Onshanchujiaoshixinxi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// chaxunjiaoshixinxiDlg message handlers
BOOL chaxunjiaoshixinxiDlg::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,80);
	m_pList->InsertColumn(2,"教师姓名",LVCFMT_CENTER,80);
	m_pList->InsertColumn(3,"教师学历",LVCFMT_CENTER,80);
	m_pList->InsertColumn(4,"教师职称",LVCFMT_CENTER,80);
	m_pList->InsertColumn(5,"办公电话",LVCFMT_CENTER,120);
	m_pList->InsertColumn(6,"移动电话",LVCFMT_CENTER,120);
	m_pList->InsertColumn(7,"所在院系编号",LVCFMT_CENTER,120);
	


	

	CString str1="SELECT * FROM T_info ",T_no,T_name,T_xueli,T_title,T_officetel,T_mobile,department_no;
    m_pList->DeleteAllItems();
	m_precordset=new T_infodb(m_pdb);
	m_precordset->Open(T_infodb::snapshot,str1);
    int i=0;
	if(m_precordset->IsEOF())
	{
      return true;
	}
	else
	{
	  m_precordset->MoveFirst();
	  while(!m_precordset->IsEOF())
	  {
		
    	T_no=m_precordset->m_T_no;
		T_name=m_precordset->m_T_name;
		T_xueli=m_precordset->m_T_xueli;
		T_title=m_precordset->m_T_title;
		T_officetel=m_precordset->m_T_officetel;
		T_mobile=m_precordset->m_T_mobile;
		department_no=m_precordset->m_department_no;
		
		m_pList->InsertItem(i,T_no);
		m_pList->SetItemText(i,1,T_name);
		m_pList->SetItemText(i,2,T_xueli);
		m_pList->SetItemText(i,3,T_title);
		m_pList->SetItemText(i,4,T_officetel);
		m_pList->SetItemText(i,5,T_mobile);
		m_pList->SetItemText(i,6,department_no);
		
		m_precordset->MoveNext();
		i++;
	  } 
	}

	delete m_precordset;
	return true;
}


void chaxunjiaoshixinxiDlg::Onshanchujiaoshixinxi()    //删除按钮的函数  yang
{
   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 T_info where T_no= '"+str+"'";
       m_pdb->ExecuteSQL(str1);
	   m_pList.DeleteItem(j);
	   AfxMessageBox("删除成功!");
	  }
	  else return;
	  
   }
}

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