📄 schoolmanagesys_2dlg.cpp

📁 学校管理系统
💻 CPP
📖 第 1 页 / 共 3 页
字号:
	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()
💿 文件大小 579 K
👤 上传用户 z3021440
📂 所属分类教育系统应用
🏷️ 相关标签

#管理系统
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -