?? schoolmanagesys_2dlg.cpp

?? 軟件介紹：編程環(huán)境: windows2003 +visual stdio c++ .net Ado + SQL2000 /##################################
?? 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("尚未與數(shù)據(jù)庫連接");
		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);
}

// //顯示數(shù)據(jù)在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("已經(jīng)連接到數(shù)據(jù)庫");
	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下的數(shù)據(jù)
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()
?? 文件大小 3486 K
?? 上傳用戶 hushanlyn
?? 所屬分類數(shù)據(jù)庫系統(tǒng)
??? 相關標簽

#windows #visual #stdio #2003
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? schoolmanagesys_2dlg.cpp

?? 快捷鍵說明
