www.pudn.com > 111.rar > SchoolManageSys_2Dlg.cpp

/****************************************/ 
/*		SchoolManageSystem			    */ 
/*设计者：全佳营						*/ 
/*时间：2004.5.9-2004-5-18				*/ 
/*Email:ghostman@tzc.edu.cn				*/ 
/****************************************/ 
 
// SchoolManageSys_2Dlg.cpp : 实现文件 
// 
 
#include "stdafx.h" 
#include "SchoolManageSys_2.h" 
#include "SchoolManageSys_2Dlg.h" 
#include ".\schoolmanagesys_2dlg.h" 
#include "DialogAboutMe.h" 
#include "DialogHelp.h" 
#include "DataGridShow.h" 
#include "Dialog_Login.h" 
#include "Dialog_Amend_users.h" 
#include "Dialog_Query.h" 
#include "DialogNew.h" 
#include "Dialog_DeleteData.h" 
#include "DialogAmendData.h" 
 
#ifdef _DEBUG 
#define new DEBUG_NEW 
#endif 
 
 
// 用于应用程序“关于”菜单项的 CAboutDlg 对话框 
 
class CAboutDlg : public CDialog 
{ 
public: 
	CAboutDlg(); 
	virtual BOOL OnInitDialog(); 
// 对话框数据 
	enum { IDD = IDD_ABOUTBOX }; 
 
	protected: 
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV 支持 
 
// 实现 
protected: 
	DECLARE_MESSAGE_MAP() 
}; 
 
CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD) 
{ 
} 
 
void CAboutDlg::DoDataExchange(CDataExchange* pDX) 
{ 
	CDialog::DoDataExchange(pDX); 
} 
 
BEGIN_MESSAGE_MAP(CAboutDlg, CDialog) 
END_MESSAGE_MAP() 
 
BOOL CAboutDlg::OnInitDialog(){ 
	CDialog::OnInitDialog(); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
	return TRUE; 
} 
// CSchoolManageSys_2Dlg 对话框 
 
 
 
CSchoolManageSys_2Dlg::CSchoolManageSys_2Dlg(CWnd* pParent /*=NULL*/) 
	: CDialog(CSchoolManageSys_2Dlg::IDD, pParent) 
{ 
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME); 
	m_bsetskin1=FALSE; 
	m_bsetskin2=FALSE; 
	m_bsetskin3=FALSE; 
	m_isstudent=FALSE; 
	ischangephoto=FALSE; 
} 
 
void CSchoolManageSys_2Dlg::DoDataExchange(CDataExchange* pDX) 
{ 
	CDialog::DoDataExchange(pDX); 
	DDX_Control(pDX, IDC_COMBO_QUERRY, m_ListQuery); 
	DDX_Control(pDX, IDC_DATAGRID_INFO, m_Datagridinfo); 
	DDX_Control(pDX, IDC_ADODC1, m_Adodc1); 
	DDX_Control(pDX, IDC_TREE_MAIN, m_Treeinfo); 
	DDX_Control(pDX, IDC_LIST_INFO, m_Listinfo); 
} 
 
BEGIN_MESSAGE_MAP(CSchoolManageSys_2Dlg, CDialog) 
	ON_WM_SYSCOMMAND() 
	ON_WM_PAINT() 
	ON_WM_QUERYDRAGICON() 
	//}}AFX_MSG_MAP 
	ON_COMMAND(ID_ABOUT, OnAbout) 
	ON_COMMAND(ID_HELP_FILE, OnHelpFile) 
	ON_BN_CLICKED(IDC_BUTTON_EXIT, OnBnClickedButtonExit) 
	ON_COMMAND(ID_EXIT, OnExit) 
	ON_BN_CLICKED(IDC_BUTTON_OK, OnBnClickedButtonOk) 
	ON_COMMAND(ID_ABOUTME, OnAboutme) 
	ON_CBN_SELCHANGE(IDC_COMBO_QUERRY, OnCbnSelchangeComboQuerry) 
	ON_COMMAND(ID_DISPLAY_DATAGRID, OnDisplayDatagrid) 
	ON_UPDATE_COMMAND_UI(ID_Menu, OnUpdateMenu) 
	ON_COMMAND(ID_Menu, OnMenu) 
	ON_COMMAND(ID_CHIZH, OnChizh) 
	ON_UPDATE_COMMAND_UI(ID_CHIZH, OnUpdateChizh) 
	ON_COMMAND(ID_DEFAULT, OnDefault) 
	ON_UPDATE_COMMAND_UI(ID_DEFAULT, OnUpdateDefault) 
	ON_COMMAND(ID_B, OnB) 
	ON_UPDATE_COMMAND_UI(ID_B, OnUpdateB) 
	ON_COMMAND(ID_GALAXY, OnGalaxy) 
	ON_UPDATE_COMMAND_UI(ID_GALAXY, OnUpdateGalaxy) 
	ON_COMMAND(ID_MAC, OnMac) 
	ON_UPDATE_COMMAND_UI(ID_MAC, OnUpdateMac) 
	ON_COMMAND(ID_MEDIA, OnMedia) 
	ON_UPDATE_COMMAND_UI(ID_MEDIA, OnUpdateMedia) 
	ON_COMMAND(ID_METALLIC, OnMetallic) 
	ON_UPDATE_COMMAND_UI(ID_METALLIC, OnUpdateMetallic) 
	ON_COMMAND(ID_PAPER, OnPaper) 
	ON_UPDATE_COMMAND_UI(ID_PAPER, OnUpdatePaper) 
	ON_COMMAND(ID_PASOMOD, OnPasomod) 
	ON_UPDATE_COMMAND_UI(ID_PASOMOD, OnUpdatePasomod) 
	ON_COMMAND(ID_GREEN, OnGreen) 
	ON_UPDATE_COMMAND_UI(ID_GREEN, OnUpdateGreen) 
	ON_COMMAND(ID_TOPSECRET, OnTopsecret) 
	ON_UPDATE_COMMAND_UI(ID_TOPSECRET, OnUpdateTopsecret) 
	ON_COMMAND(ID_WEB, OnWeb) 
	ON_UPDATE_COMMAND_UI(ID_WEB, OnUpdateWeb) 
	ON_COMMAND(ID_CONNECTION, OnConnection) 
	ON_COMMAND(ID_DISCONNECTION, OnDisconnection) 
	ON_COMMAND(ID_SET_LOGIN, OnSetLogin) 
	ON_NOTIFY(TVN_SELCHANGED, IDC_TREE_MAIN, OnTvnSelchangedTreeMain) 
	ON_NOTIFY(NM_RCLICK, IDC_TREE_MAIN, OnNMRclickTreeMain) 
	ON_NOTIFY(LVN_ITEMACTIVATE, IDC_LIST_INFO, OnLvnItemActivateListInfo) 
	ON_BN_CLICKED(IDC_BUTTON_CHANAGE_PHOTO, OnBnClickedButtonChanagePhoto) 
	ON_BN_CLICKED(IDC_BUTTON_FLUSHNEW, OnBnClickedButtonFlushnew) 
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnBnClickedButtonQuery) 
	ON_COMMAND(ID_DISPLAYSELECTED, OnDisplayselected) 
	ON_WM_CONTEXTMENU() 
	ON_BN_CLICKED(IDC_BUTTON_CHE, OnBnClickedButtonChe) 
	ON_BN_CLICKED(IDC_BUTTON_HUI, OnBnClickedButtonHui) 
	ON_COMMAND(ID_QUERY, OnQuery) 
	ON_COMMAND(ID_NEWCLASS, OnNewclass) 
	ON_COMMAND(ID_NEWSTUDENT, OnNewstudent) 
	ON_COMMAND(ID_NEWTEACHER, OnNewteacher) 
	ON_COMMAND(ID_NEWDEPARTMENT, OnNewdepartment) 
	ON_COMMAND(ID_NEWCONSORTIUM, OnNewconsortium) 
	ON_COMMAND(ID_NEWCOLLEGE, OnNewcollege) 
	ON_COMMAND(ID_DELETE, OnDelete) 
	ON_COMMAND(ID_AMEND, OnAmend) 
END_MESSAGE_MAP() 
 
 
// CSchoolManageSys_2Dlg 消息处理程序 
 
BOOL CSchoolManageSys_2Dlg::OnInitDialog() 
{ 
	CDialog::OnInitDialog(); 
 
	// 将\“关于...\”菜单项添加到系统菜单中。 
 
	// IDM_ABOUTBOX 必须在系统命令范围内。 
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX); 
	ASSERT(IDM_ABOUTBOX < 0xF000); 
 
	CMenu* pSysMenu = GetSystemMenu(FALSE); 
	if (pSysMenu != NULL) 
	{ 
		CString strAboutMenu; 
		strAboutMenu.LoadString(IDS_ABOUTBOX); 
		if (!strAboutMenu.IsEmpty()) 
		{ 
			pSysMenu->AppendMenu(MF_SEPARATOR); 
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu); 
		} 
	} 
	 
	//设置右键弹出菜单 
	popmenu=new CMenu; 
	BOOL bSuccess =popmenu->LoadMenu(IDR_MENU_POPUP); 
	// 设置此对话框的图标。当应用程序主窗口不是对话框时，框架将自动 
	//  执行此操作 
	SetIcon(m_hIcon, TRUE);			// 设置大图标 
	SetIcon(m_hIcon, FALSE);		// 设置小图标 
 
	// TODO: 在此添加额外的初始化代码 
	theApp.m_pSkin = GetDlgItem(IDC_SKIN21)->GetControlUnknown(); 
	theApp.m_pSkin->LoadSkin(L"winaqua.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
	 
	//连接数据库，身份验证 
	CDialog_Login *dlg1 =new CDialog_Login; 
	INT_PTR nResponse1=dlg1->DoModal(); 
	if(nResponse1==IDOK){ 
 
	}else { 
		CDialog::OnCancel(); 
	} 
	//Tree控件 
 
	 
	m_imagelist=new CImageList; 
	m_imagelist->Create(IDB_BITMAP_1,0,0,RGB(0,0,0)); 
	 
	bm.LoadBitmap(IDB_BITMAP_2); 
	m_imagelist->Add(&bm,RGB(0,0,0)); 
	/* 
	bm.DeleteObject(); 
	bm.LoadBitmap(IDB_BITMAP1); 
	m_imagelist->Add(&bm,RGB(0,0,0)); 
	bm.DeleteObject(); 
	bm.LoadBitmap(IDB_BITMAP2);*/ 
	 
	m_imagelist->Add(&bm,RGB(0,0,0)); 
	/* 
	int count(0); 
	CString tmp; 
	count=m_imagelist->GetImageCount(); 
	tmp.Format("%d",count); 
	AfxMessageBox(tmp);*/ 
 
	tvInsert.hParent = NULL; 
	tvInsert.hInsertAfter = NULL; 
	tvInsert.item.mask = TVIF_TEXT; 
	tvInsert.item.pszText=_T("台州学院信息管理"); 
 
	m_Treeinfo.SetImageList(m_imagelist,TVSIL_NORMAL); 
 
	h1=m_Treeinfo.InsertItem(&tvInsert); 
	h2=m_Treeinfo.InsertItem("相关信息",0,1,h1,TVI_SORT); 
	h3=m_Treeinfo.InsertItem("相关信息1",0,1,h1,TVI_SORT); 
	m_Treeinfo.SetTextColor(RGB(128,0,200)); 
	//m_Treeinfo.SetItemImage(h1,0,1); 
 
	/*样式 
	long lStyle= 
		::GetWindowLong(m_Treeinfo.GetSafeHwnd(),GWL_STYLE); 
	lStyle |=TVS_EDITLABELS; 
	::SetWindowLong(m_Treeinfo.GetSafeHwnd(), 
		GWL_STYLE, 
		lStyle);*/ 
 
	//**List控件 
	 
	DWORD dwExStyle = LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | /*LVS_EX_SUBITEMIMAGES |*/ 
	m_Listinfo.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);						LVS_EX_HEADERDRAGDROP | LVS_EX_TRACKSELECT; 
	LV_COLUMN lvColumn; 
	lvColumn.mask = LVCF_FMT | LVCF_WIDTH | LVCF_TEXT | LVCF_SUBITEM; 
	lvColumn.fmt = LVCFMT_LEFT;	lvColumn.cx = 67; 
	 
	CString temp ="初始化"; 
	int len=temp.GetLength();  
	TCHAR* szBuffer = new TCHAR[len + 1]; 
	strcpy(szBuffer, temp.GetBuffer(len)); 
	temp.ReleaseBuffer(); 
	lvColumn.pszText = szBuffer; 
	m_Listinfo.InsertColumn(0,&lvColumn); 
	//**Datagrid控件 
	 
	//**连接SQL数据库 
	 
	if(m_AdoConnection.IsOpen()){ 
		//学院记录集 
		m_AdoRecordSet_Collegeinfo.SetAdoConnection(&m_AdoConnection); 
		m_AdoRecordSet_Collegeinfo.SetCursorLocation(); 
		m_AdoRecordSet_Collegeinfo.Open("collegerecord",adCmdTable); 
		//系记录集 
		m_AdoRecordSet_Departmentinfo.SetAdoConnection(&m_AdoConnection); 
		m_AdoRecordSet_Departmentinfo.SetCursorLocation(); 
		m_AdoRecordSet_Departmentinfo.Open("departmentrecord",adCmdTable); 
		//班级记录集 
		m_AdoRecordSet_Classinfo.SetAdoConnection(&m_AdoConnection); 
		m_AdoRecordSet_Classinfo.SetCursorLocation(); 
		m_AdoRecordSet_Classinfo.Open("classrecord",adCmdTable); 
		//学生记录集 
		m_AdoRecordSet_Studentinfo.SetAdoConnection(&m_AdoConnection); 
		m_AdoRecordSet_Studentinfo.SetCursorLocation(); 
	//	m_AdoRecordSet_Studentinfo.Open("studentrecord",adCmdTable); 
		//打开课程集 
		m_AdoRecordSet_Lessoninfo.SetAdoConnection(&m_AdoConnection); 
		m_AdoRecordSet_Lessoninfo.SetCursorLocation(); 
	//	m_AdoRecordSet_Lessoninfo.Open("lessonrecord",adCmdTable); 
		 
	} 
	classnum=m_AdoRecordSet_Classinfo.GetRecordCount(); 
	//**列出查询项目 
	m_ListQuery.AddString("学院分类"); 
	m_ListQuery.AddString("系别分类"); 
	m_ListQuery.SetCurSel(0); 
 
	return TRUE;  // 除非设置了控件的焦点，否则返回 TRUE 
} 
 
void CSchoolManageSys_2Dlg::OnSysCommand(UINT nID, LPARAM lParam) 
{ 
	if ((nID & 0xFFF0) == IDM_ABOUTBOX) 
	{ 
		CAboutDlg dlgAbout; 
		dlgAbout.DoModal(); 
	} 
	else 
	{ 
		CDialog::OnSysCommand(nID, lParam); 
	} 
} 
 
// 如果向对话框添加最小化按钮，则需要下面的代码 
//  来绘制该图标。对于使用文档/视图模型的 MFC 应用程序， 
//  这将由框架自动完成。 
 
void CSchoolManageSys_2Dlg::OnPaint()  
{ 
	CPaintDC dc(this); 
	if (IsIconic()) 
	{ 
		 // 用于绘制的设备上下文 
 
		SendMessage(WM_ICONERASEBKGND, reinterpret_cast(dc.GetSafeHdc()), 0); 
 
		// 使图标在工作矩形中居中 
		int cxIcon = GetSystemMetrics(SM_CXICON); 
		int cyIcon = GetSystemMetrics(SM_CYICON); 
		CRect rect; 
		GetClientRect(&rect); 
		int x = (rect.Width() - cxIcon + 1) / 2; 
		int y = (rect.Height() - cyIcon + 1) / 2; 
 
		// 绘制图标 
		dc.DrawIcon(x, y, m_hIcon); 
	} 
	else 
	{ 
		CDialog::OnPaint(); 
	} 
	if(m_bitmap.GetSafeHandle()!=NULL){ 
		CDC memDC; 
		BITMAP bm; 
		m_bitmap.GetBitmap(&bm); 
		memDC.CreateCompatibleDC(&dc); 
		CBitmap *oldbitmap = memDC.SelectObject(&m_bitmap); 
		 
		dc.BitBlt(712, 297, 152, 145, &memDC, 0, 0, SRCCOPY); 
		memDC.SelectObject(oldbitmap); 
	} 
} 
 
void CSchoolManageSys_2Dlg::OnOK(){ 
	if(MessageBox("退出系统？","确定退出",MB_OKCANCEL|MB_ICONQUESTION)==IDOK){ 
		if(!m_AdoConnection.CommitTrans()){ 
			AfxMessageBox("执行操作失败"); 
			return; 
		} 
		//CDialog::OnOK(); 
	} 
} 
 
void CSchoolManageSys_2Dlg::OnCancel(){	 
	if(MessageBox("退出系统？","确定退出",MB_OKCANCEL|MB_ICONQUESTION)==IDOK){ 
		CDialog::OnCancel(); 
	} 
} 
//当用户拖动最小化窗口时系统调用此函数取得光标显示。 
HCURSOR CSchoolManageSys_2Dlg::OnQueryDragIcon() 
{ 
	return static_cast(m_hIcon); 
} 
 
void CSchoolManageSys_2Dlg::OnAbout() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CAboutDlg *dlg=new CAboutDlg; 
	ASSERT(dlg); 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnHelpFile() 
{ 
	CDialogHelp *dlg=new CDialogHelp; 
	ASSERT(dlg); 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnBnClickedButtonExit() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	OnCancel(); 
} 
 
void CSchoolManageSys_2Dlg::OnExit() 
{ 
	// TODO: 在此添加命令处理程序代码 
	OnCancel(); 
} 
 
void CSchoolManageSys_2Dlg::OnBnClickedButtonOk() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	OnOK(); 
} 
 
void CSchoolManageSys_2Dlg::OnAboutme() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDialogAboutMe *dlg=new CDialogAboutMe; 
	ASSERT(dlg); 
	dlg->DoModal(); 
} 
 
 
void CSchoolManageSys_2Dlg::OnCbnSelchangeComboQuerry() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	if(!m_AdoConnection.IsOpen()){ 
		AfxMessageBox("尚未与数据库连接"); 
		return; 
	} 
 
	UpdateData(); 
	CString m_selection; 
	m_ListQuery.GetLBText(m_ListQuery.GetCurSel(),m_selection); 
	DisplayDataOnTree(m_selection); 
} 
 
void CSchoolManageSys_2Dlg::OnDisplayDatagrid() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDataGridShow *dlg=new CDataGridShow; 
	ASSERT(dlg); 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdateMenu(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin1); 
} 
 
void CSchoolManageSys_2Dlg::OnMenu() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin1=!m_bsetskin1; 
	theApp.m_pSkin->LoadSkin(L"winaqua.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnChizh() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin2=!m_bsetskin2; 
	theApp.m_pSkin->LoadSkin(L"chizh.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdateChizh(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin2); 
	UpdateData(FALSE); 
} 
 
void CSchoolManageSys_2Dlg::OnDefault() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin3=!m_bsetskin3; 
	theApp.m_pSkin->LoadSkin(L"zhelezo.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdateDefault(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin3); 
} 
 
void CSchoolManageSys_2Dlg::OnB() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin4=!m_bsetskin4; 
	theApp.m_pSkin->LoadSkin(L"B-Studio.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdateB(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin4); 
} 
 
void CSchoolManageSys_2Dlg::OnGalaxy() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin5=!m_bsetskin5; 
	theApp.m_pSkin->LoadSkin(L"galaxy.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdateGalaxy(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin5); 
} 
 
void CSchoolManageSys_2Dlg::OnMac() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin6=!m_bsetskin6; 
	theApp.m_pSkin->LoadSkin(L"Mac.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdateMac(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin6); 
} 
 
void CSchoolManageSys_2Dlg::OnMedia() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin7=!m_bsetskin7; 
	theApp.m_pSkin->LoadSkin(L"Media.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdateMedia(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin7); 
} 
 
void CSchoolManageSys_2Dlg::OnMetallic() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin8=!m_bsetskin8; 
	theApp.m_pSkin->LoadSkin(L"metallic.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdateMetallic(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin8); 
} 
 
void CSchoolManageSys_2Dlg::OnPaper() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin9=!m_bsetskin9; 
	theApp.m_pSkin->LoadSkin(L"Paper.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdatePaper(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin9); 
} 
 
void CSchoolManageSys_2Dlg::OnPasomod() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin10=!m_bsetskin10; 
	theApp.m_pSkin->LoadSkin(L"plasmoid.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdatePasomod(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin10); 
} 
 
void CSchoolManageSys_2Dlg::OnGreen() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin11=!m_bsetskin11; 
	theApp.m_pSkin->LoadSkin(L"green.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdateGreen(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin11); 
} 
 
void CSchoolManageSys_2Dlg::OnTopsecret() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin12=!m_bsetskin12; 
	theApp.m_pSkin->LoadSkin(L"Topsecret.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
} 
 
void CSchoolManageSys_2Dlg::OnUpdateTopsecret(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin12); 
} 
 
void CSchoolManageSys_2Dlg::OnWeb() 
{ 
	// TODO: 在此添加命令处理程序代码 
	m_bsetskin13=!m_bsetskin13; 
	theApp.m_pSkin->LoadSkin(L"Web-II.skn"); 
	theApp.m_pSkin->ApplySkin((int)m_hWnd); 
	 
} 
 
void CSchoolManageSys_2Dlg::OnUpdateWeb(CCmdUI *pCmdUI) 
{ 
	// TODO: 在此添加命令更新用户界面处理程序代码 
	pCmdUI->SetCheck(m_bsetskin13); 
} 
 
// //显示数据在tree控件里 
BOOL CSchoolManageSys_2Dlg::DisplayDataOnTree(CString bType) 
{ 
	 
	if(!m_AdoRecordSet_Collegeinfo.IsOpen()||!m_AdoRecordSet_Departmentinfo.IsOpen()){ 
		AfxMessageBox("记录集尚未打开，请重新登陆"); 
		return FALSE; 
	} 
 
	CString tmp; 
	HTREEITEM h_tmp; 
	m_Treeinfo.DeleteAllItems(); 
	h1=m_Treeinfo.InsertItem(&tvInsert); 
	if(bType=="学院分类"){ 
		//m_Treeinfo.DeleteAllItems(); 
		//h1=m_Treeinfo.InsertItem(&tvInsert); 
		if(!m_AdoRecordSet_Collegeinfo.IsBOF()) 
			m_AdoRecordSet_Collegeinfo.MoveFirst(); 
		while(!m_AdoRecordSet_Collegeinfo.IsEOF()){ 
			m_AdoRecordSet_Collegeinfo.GetCollect("collegename",tmp); 
			h_tmp=m_Treeinfo.InsertItem(tmp,0,1,h1,TVI_SORT); 
			int collegeidtmp; 
			m_AdoRecordSet_Collegeinfo.GetCollect("collegeid",collegeidtmp); 
			this->DisplayTreeNext(h_tmp,collegeidtmp); 
			m_AdoRecordSet_Collegeinfo.MoveNext(); 
		} 
 
	} 
	else if(bType=="系别分类"){ 
		//m_Treeinfo.DeleteAllItems(); 
		//h1=m_Treeinfo.InsertItem(&tvInsert); 
		if(!m_AdoRecordSet_Departmentinfo.IsBOF()){ 
			m_AdoRecordSet_Departmentinfo.MoveFirst(); 
		} 
		while(!m_AdoRecordSet_Departmentinfo.IsEOF()){ 
			m_AdoRecordSet_Departmentinfo.GetCollect("departmentname",tmp); 
			h_tmp=m_Treeinfo.InsertItem(tmp,1,0,h1,TVI_SORT); 
			int dpmentid; 
			m_AdoRecordSet_Departmentinfo.GetCollect("departmentid",dpmentid); 
			this->DisplayTreeNextN(h_tmp,dpmentid); 
			m_AdoRecordSet_Departmentinfo.MoveNext(); 
		} 
	} 
	else if(bType=="查询条件"){ 
		//m_Treeinfo.DeleteAllItems(); 
		//h1=m_Treeinfo.InsertItem(&tvInsert); 
		AfxMessageBox("请选择一个条件"); 
		h2=m_Treeinfo.InsertItem("相关信息",0,1,h1,TVI_SORT); 
		h3=m_Treeinfo.InsertItem("相关信息1",0,1,h1,TVI_SORT); 
	} 
	UpdateData(FALSE); 
	return TRUE; 
} 
 
// //显示下一层的treeitem 
BOOL CSchoolManageSys_2Dlg::DisplayTreeNext(HTREEITEM tType,int cid) 
{ 
	CString dpm_name; 
	CString strfind; 
	HTREEITEM h_tmp; 
	strfind.Format("collegeid=%d",cid); 
	if(!m_AdoRecordSet_Departmentinfo.IsBOF()) 
		m_AdoRecordSet_Departmentinfo.MoveFirst(); 
	while(!m_AdoRecordSet_Departmentinfo.IsEOF()){ 
		m_AdoRecordSet_Departmentinfo.Find(strfind); 
		m_AdoRecordSet_Departmentinfo.GetCollect("departmentname",dpm_name); 
		h_tmp=m_Treeinfo.InsertItem(dpm_name,1,0,tType,TVI_SORT); 
		int dpmentid; 
		m_AdoRecordSet_Departmentinfo.GetCollect("departmentid",dpmentid); 
		this->DisplayTreeNextN(h_tmp,dpmentid); 
		m_AdoRecordSet_Departmentinfo.FindNext(); 
	} 
	return TRUE; 
} 
 
 
void CSchoolManageSys_2Dlg::OnConnection() 
{ 
	// TODO: 在此添加命令处理程序代码 
	if(m_AdoConnection.IsOpen()) 
		AfxMessageBox("已经连接到数据库"); 
	else { 
		CDialog_Login *dlg=new CDialog_Login; 
		ASSERT(dlg); 
		if(dlg->DoModal()==IDOK){ 
			if(m_AdoConnection.IsOpen()){ 
			//学院记录集 
				m_AdoRecordSet_Collegeinfo.SetAdoConnection(&m_AdoConnection); 
				m_AdoRecordSet_Collegeinfo.SetCursorLocation(); 
				m_AdoRecordSet_Collegeinfo.Open("collegerecord",adCmdTable); 
			//系记录集 
				m_AdoRecordSet_Departmentinfo.SetAdoConnection(&m_AdoConnection); 
				m_AdoRecordSet_Departmentinfo.SetCursorLocation(); 
				m_AdoRecordSet_Departmentinfo.Open("departmentrecord",adCmdTable); 
				//班级记录集 
				m_AdoRecordSet_Classinfo.SetAdoConnection(&m_AdoConnection); 
				m_AdoRecordSet_Classinfo.SetCursorLocation(); 
				m_AdoRecordSet_Classinfo.Open("classrecord",adCmdTable); 
				//学生记录集 
				m_AdoRecordSet_Studentinfo.SetAdoConnection(&m_AdoConnection); 
				m_AdoRecordSet_Studentinfo.SetCursorLocation(); 
 
			} 
			classnum=m_AdoRecordSet_Classinfo.GetRecordCount(); 
		} 
		else return; 
	} 
} 
 
void CSchoolManageSys_2Dlg::OnDisconnection() 
{ 
	// TODO: 在此添加命令处理程序代码 
	if(m_AdoRecordSet_Collegeinfo.IsOpen()) 
		m_AdoRecordSet_Collegeinfo.Close(); 
	if(m_AdoRecordSet_Departmentinfo.IsOpen()) 
		m_AdoRecordSet_Departmentinfo.Close(); 
	if(m_AdoConnection.IsOpen()) 
		m_AdoConnection.Close(); 
	else AfxMessageBox("已断开连接"); 
} 
 
// //显示department下的数据 
BOOL CSchoolManageSys_2Dlg::DisplayTreeNextN(HTREEITEM m_treeitem, int m_departmentid) 
{ 
	CString classname; 
	CString strtmp; 
	strtmp.Format("departmentid=%d",m_departmentid); 
	if(!m_AdoRecordSet_Classinfo.IsBOF()) 
		m_AdoRecordSet_Classinfo.MoveFirst(); 
	while(!m_AdoRecordSet_Classinfo.IsEOF()){ 
		m_AdoRecordSet_Classinfo.Find(strtmp); 
		m_AdoRecordSet_Classinfo.GetCollect("classname",classname); 
		m_Treeinfo.InsertItem(classname,0,1,m_treeitem,TVI_SORT); 
		m_AdoRecordSet_Classinfo.FindNext(); 
	} 
	return TRUE; 
} 
 
void CSchoolManageSys_2Dlg::OnSetLogin() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CAdoConnection* tmp; 
	tmp=&m_AdoConnection; 
	CDialog_Amend_users *dlg=new CDialog_Amend_users(NULL,tmp); 
	ASSERT(dlg); 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnTvnSelchangedTreeMain(NMHDR *pNMHDR, LRESULT *pResult) 
{ 
	LPNMTREEVIEW pNMTreeView = reinterpret_cast(pNMHDR); 
	// TODO: 在此添加控件通知处理程序代码 
	//取当前项 
	m_isstudent=TRUE; 
	h_current=m_Treeinfo.GetSelectedItem(); 
	h_parent=m_Treeinfo.GetParentItem(h_current); 
	if(m_Treeinfo.GetChildItem(h_current)==NULL){ 
		CString tmp; 
		tmp=m_Treeinfo.GetItemText(h_current); 
		this->ShowBaseinfo(tmp); 
		 
	}else { 
		 
	} 
	*pResult = 0; 
} 
 
// 显示基本信息在List控件中 
BOOL CSchoolManageSys_2Dlg::ShowBaseinfo(CString m_info) 
{ 
	CString tmp; 
	int cid; 
	//CAdoRecordSet m_AdoRecordSet_Studentinfo; 
	if(m_info=="") return FALSE; 
	tmp.Format("classname=\'%s\'",m_info); 
	if(!m_AdoRecordSet_Classinfo.IsBOF()) 
		m_AdoRecordSet_Classinfo.MoveFirst(); 
	m_AdoRecordSet_Classinfo.Find(tmp); 
	if(!m_AdoRecordSet_Classinfo.IsEOF()){ 
		m_AdoRecordSet_Classinfo.GetCollect("classid",cid); 
		tmp.Format("SELECT *from studentrecord WHERE classid=%d",cid); 
		//tmp.Format("classid=%d",cid); 
		//打开学生记录集 
		//m_AdoRecordSet_Studentinfo.SetAdoConnection(&m_AdoConnection); 
		//m_AdoRecordSet_Studentinfo.SetCursorLocation(); 
		 
		if(m_AdoRecordSet_Studentinfo.IsOpen()){ 
			m_AdoRecordSet_Studentinfo.Requery(); 
			m_AdoRecordSet_Studentinfo.Close(); 
		} 
		m_AdoRecordSet_Studentinfo.Open(tmp,adCmdText); 
	 
		if(!m_AdoRecordSet_Studentinfo.IsEOF()){ 
			m_AdoRecordSet_Studentinfo.MoveFirst(); 
			//显示数据在List控件里 
			//清除List控件里的数据 
			int nField=m_AdoRecordSet_Studentinfo.GetFieldsCount(); 
			if(nField){ 
				for(int i=0;iGetSubMenu(0); 
	psubmenu->TrackPopupMenu(TPM_LEFTALIGN| 
		TPM_RIGHTBUTTON, 
		point.x-230, 
		point.y-215, 
		AfxGetMainWnd()); 
} 
 
 
void CSchoolManageSys_2Dlg::OnLvnItemActivateListInfo(NMHDR *pNMHDR, LRESULT *pResult) 
{ 
	LPNMITEMACTIVATE pNMIA = reinterpret_cast(pNMHDR); 
	*pResult = 0; 
	// TODO: 在此添加控件通知处理程序代码 
	ischangephoto=TRUE; 
	int i=m_Listinfo.GetNextItem(-1,LVNI_SELECTED); 
	m_bitmap.DeleteObject(); 
	CString tmp,str; 
	tmp=m_Listinfo.GetItemText(i,1); 
	str.Format("studynum=\'%s\'",tmp); 
	if(!m_AdoRecordSet_Studentinfo.IsBOF()) 
		m_AdoRecordSet_Studentinfo.MoveFirst(); 
	m_AdoRecordSet_Studentinfo.Find(str); 
	str.Format("SELECT *FROM lessonrecord WHERE studynum=\'%s\'",tmp); 
	if(m_AdoRecordSet_Lessoninfo.IsOpen()) 
		m_AdoRecordSet_Lessoninfo.Close(); 
	if(!m_AdoRecordSet_Lessoninfo.IsOpen()) 
		m_AdoRecordSet_Lessoninfo.Open(str,adCmdText); 
		 
	if(!m_AdoRecordSet_Studentinfo.IsEOF()){ 
		m_AdoRecordSet_Studentinfo.GetChunk("photo",m_bitmap); 
		CRect rect(370, 100, 500, 260); 
		InvalidateRect(rect); 
		CString tmpname; 
		m_AdoRecordSet_Studentinfo.GetCollect("姓名",tmpname); 
		str.Format("%s 的课程信息",tmpname); 
		if(!m_AdoRecordSet_Lessoninfo.IsEOF()) 
		{ 
			m_Datagridinfo.put_Caption(str); 
			m_Datagridinfo.putref_DataSource(NULL); 
			m_Datagridinfo.putref_DataSource((LPUNKNOWN)m_AdoRecordSet_Lessoninfo.GetRecordset()); 
			m_Datagridinfo.put_AllowAddNew(TRUE); 
			m_Datagridinfo.put_AllowDelete(TRUE); 
			m_Datagridinfo.put_AllowUpdate(TRUE); 
			m_Datagridinfo.Refresh(); 
		} 
		else { 
			AfxMessageBox("没有相关课程信息"); 
			return; 
		} 
	}else { 
		AfxMessageBox("没有相关信息"); 
		return ; 
	} 
	UpdateData(FALSE); 
	 
} 
 
void CSchoolManageSys_2Dlg::OnBnClickedButtonChanagePhoto() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	if(!ischangephoto){ 
		AfxMessageBox("请选择一个人进行编辑"); 
		return; 
	} 
	if(m_isstudent){ 
		if(m_AdoRecordSet_Studentinfo.GetRecordCount()<1) return ; 
		static char BASED_CODE szFilter[] = "BMP Files (*.bmp)|*.bmp|All Files (*.*)|*.*||"; 
		CFileDialog dlg(TRUE,"BMP",NULL,  OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT,szFilter); 
		if(dlg.DoModal()==IDOK){ 
			strpathname=dlg.GetPathName(); 
			if(strpathname!=""){ 
				if(m_AdoRecordSet_Studentinfo.AppendChunk("photo",LPCTSTR(strpathname))){ 
					CFile file; 
					if (file.Open(LPCTSTR(strpathname), CFile::modeRead)) 
					{ 
						long length = (long)file.GetLength(); 
						char *pdata = new char[length + 1]; 
						if (file.Read(pdata, length) == (DWORD)length) 
						{ 
							BITMAPFILEHEADER	bmfHeader; 
							DWORD bmfHeaderLen = sizeof(bmfHeader); 
							strncpy((LPSTR)&bmfHeader, (LPSTR)pdata, bmfHeaderLen); 
							if (bmfHeader.bfType == (*(WORD*)"BM") ) 
							{ 
								LPSTR lpDIB = pdata + bmfHeaderLen; 
								BITMAPINFOHEADER &bmiHeader = *(LPBITMAPINFOHEADER)lpDIB; 
								BITMAPINFO &bmInfo = *(LPBITMAPINFO)lpDIB; 
 
								LPVOID lpDIBBits = pdata + ((BITMAPFILEHEADER *)pdata)->bfOffBits; 
								CWindowDC dc(this); 
								HBITMAP hBmp = CreateDIBitmap(dc.m_hDC, &bmiHeader, CBM_INIT, lpDIBBits, &bmInfo, DIB_RGB_COLORS); 
								if (m_bitmap.GetSafeHandle() != NULL) m_bitmap.DeleteObject(); 
								m_bitmap.Attach(hBmp); 
								Invalidate(); 
							} 
						} 
						delete[] pdata; 
						pdata = NULL; 
					} 
				} 
			} 
		} 
	} 
	Invalidate(); 
	UpdateData(FALSE); 
} 
 
void CSchoolManageSys_2Dlg::OnBnClickedButtonFlushnew() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	if(UpdateData(FALSE)){ 
		strpathname=""; 
		if(!m_AdoRecordSet_Bookinfo.Update()){ 
			AfxMessageBox("刷新失败!"); 
		} 
	} 
} 
 
void CSchoolManageSys_2Dlg::OnBnClickedButtonQuery() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	CDialog_Query *dlg=new CDialog_Query; 
	ASSERT(dlg); 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnDisplayselected() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDataGridShow *dlg=new CDataGridShow; 
	ASSERT(dlg); 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnContextMenu(CWnd* /*pWnd*/, CPoint point) 
{ 
	// TODO: 在此处添加消息处理程序代码 
	SetFocus(); 
	ClientToScreen(&point); 
	CMenu * psubmenu=popmenu->GetSubMenu(1); 
	psubmenu->TrackPopupMenu(TPM_LEFTALIGN| 
		TPM_RIGHTBUTTON, 
		point.x-230, 
		point.y-215, 
		this); 
} 
 
void CSchoolManageSys_2Dlg::OnBnClickedButtonChe() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	if(!m_AdoConnection.RollbackTrans()){ 
		AfxMessageBox("操作失败"); 
		return; 
	} 
	 
} 
 
void CSchoolManageSys_2Dlg::OnBnClickedButtonHui() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	if(!m_AdoConnection.CommitTrans()){ 
		AfxMessageBox("操作失败"); 
		return ; 
	} 
} 
 
 
void CSchoolManageSys_2Dlg::OnQuery() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDialog_Query *dlg=new CDialog_Query; 
	ASSERT(dlg); 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnNewclass() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDialogNew *dlg=new CDialogNew; 
	ASSERT(dlg); 
	dlg->m_select=1; 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnNewstudent() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDialogNew *dlg=new CDialogNew; 
	ASSERT(dlg); 
	dlg->m_select=0; 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnNewteacher() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDialogNew *dlg=new CDialogNew; 
	ASSERT(dlg); 
	dlg->m_select=3; 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnNewdepartment() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDialogNew *dlg=new CDialogNew; 
	ASSERT(dlg); 
	dlg->m_select=2; 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnNewconsortium() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDialogNew *dlg=new CDialogNew; 
	ASSERT(dlg); 
	dlg->m_select=4; 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnNewcollege() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDialogNew *dlg=new CDialogNew; 
	ASSERT(dlg); 
	dlg->m_select=5; 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnDelete() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDialog_DeleteData *dlg=new CDialog_DeleteData; 
	ASSERT(dlg); 
	dlg->DoModal(); 
} 
 
void CSchoolManageSys_2Dlg::OnAmend() 
{ 
	// TODO: 在此添加命令处理程序代码 
	CDialogAmendData *dlg=new CDialogAmendData; 
	ASSERT(dlg); 
	dlg->DoModal(); 
}