smdlg.cpp

课程设计的简单Access学生数据库系统

		{
			AfxMessageBox("必须选择一个班级");
			return;
		}
		CClassDlg dlg(&pUnitClassTree->GetSelectClass());
		int id;
		if(id=dlg.DoModal())
			pUnitClassTree->UpdateClass(id);
	}
	catch(CException *e)
	{
		DisplayException(e);
	}
}

//##ModelId=40A481F3035D
void CSMDlg::OnEditClass() 
{
	OnViewClass();
}

//##ModelId=40A481F3036B
void CSMDlg::OnDeleteClass() 
{
	if(!pUnitClassTree->GetSelectType())//is Unit
	{
		AfxMessageBox("必须选择一个班级");
		return;
	}
	if(IDOK==AfxMessageBox("将删除所有相关的班级学生成绩记录, 慎重!", MB_OKCANCEL   ))
	{
		int id =pUnitClassTree->GetSelectClass().ID; 
		CDaoTableDef td(&theDatabase);
		td.Open(_T("class"));
		CDaoRecordset RS;
		RS.Open(&td);
		
		pUnitClassTree->GetSelectClass().Delete(&RS);
		pUnitClassTree->DeleteClass(id);
		RS.Close();
		td.Close();
	}
}

//##ModelId=40A481F3036D
void CSMDlg::OnSelchangedUnittree(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	if(pUnitClassTree->GetSelectType()==1)
	{
		m_List.SetFocus();
		pList->Load(pUnitClassTree->GetSelectClass().ID);
	}
	else
	{
		pList->Clear();
	}
	*pResult = 0;
}

//##ModelId=40A481F3038A
void CSMDlg::OnClickUnittree(NMHDR* pNMHDR, LRESULT* pResult) 
{
	*pResult = 0;
}

//##ModelId=40A481F3039A
void CSMDlg::OnDeleteStudent() 
{
	try
	{
		if(pList->IsSelected())
		{
			int id;
			if(pUnitClassTree->GetSelectType()==1)
			{
				CDaoTableDef td(&theDatabase);
				td.Open("student");
				CDaoRecordset RS;
				RS.Open(&td);
				id = pUnitClassTree->GetSelectClass().ID;
				long stu_sel = pList->GetSelected()-1;
				pList->GetSelectStudent().Delete(&RS);
				pList->Load(id);
				pList->SetSelected(stu_sel);
				RS.Close();
				td.Close();
			}
		}
	}
	catch(CException *e)
	{
		DisplayException(e);
	}
}

//##ModelId=40A481F303AA
void CSMDlg::OnNewStudent() 
{
	if(pUnitClassTree->GetSelectType()!=1)
	{
		AfxMessageBox("请选择一个班级用以添加学生记录!!");
		return;
	}
	try
	{
		long class_id = pUnitClassTree->GetSelectClass().ID, id;
		CStudentDlg dlg;
		if(id=dlg.DoModal())
		{
			pList->Load(class_id);
			pList->SetSelectStudent(id);
		}
	}
	catch(CException *e)
	{
		DisplayException(e);
	}
	
}

//##ModelId=40A481F303AC
void CSMDlg::OnViewStudent() 
{
	try
	{
		if(pList->IsSelected())
		{
			int id;
			if(pUnitClassTree->GetSelectType()==1)
				id = pUnitClassTree->GetSelectClass().ID;
			CStudentDlg dlg(&pList->GetSelectStudent());
			if(dlg.DoModal())
				pList->Load(id);
		}
	}
	catch(CException *e)
	{
		DisplayException(e);
	}
}

//##ModelId=40A481F303BA
void CSMDlg::OnEditStudent() 
{
	OnViewStudent();
}

//##ModelId=40A481F303C8
void CSMDlg::OnNewUnit() 
{
	CUnitDlg dlg(pUnitClassTree->GetSelectUnit().ID);
	try
	{
		int r = dlg.DoModal();
		if(r)
		{
			pUnitClassTree->ReLoad();
			pUnitClassTree->SetSelectUnit(r);
		}
	}
	catch(CException *e)
	{
		DisplayException(e);
	}
}

//##ModelId=40A481F303CA
void CSMDlg::OnEditUnit() 
{
	OnViewUnit();
}

//##ModelId=40A481F40000
void CSMDlg::OnFindClass() 
{
	CString s;
	CSearchDlg dlg("请输入要查找的班级: ", s);
	if(IDOK==dlg.DoModal())
	{
		CDaoTableDef td(&theDatabase);
		td.Open("class");
		CDaoRecordset rs;
		rs.Open(&td);
		rs.SetCurrentIndex("class");
		if(rs.Seek("=", &COleVariant(s, VT_BSTRT)))
		{
			pUnitClassTree->SetSelectClass(rs.GetFieldValue("id").lVal);
		}
		else
		{
			AfxMessageBox("对不起, 并无该记录!!");
		}
		rs.Close();
		td.Close();
	};
	
}

//##ModelId=40A481F4000F
void CSMDlg::OnFindStudent() 
{
	CString s;
	CSearchDlg dlg("请输入要查找的学生: ", s);
	if(IDOK==dlg.DoModal())
	{
		CDaoTableDef td(&theDatabase);
		td.Open("student");
		CDaoRecordset rs;
		rs.Open(&td);
		rs.SetCurrentIndex("name");
		if(rs.Seek("=", &COleVariant(s, VT_BSTRT )))
		{
			pUnitClassTree->SetSelectClass(rs.GetFieldValue("class_id").lVal);
		//	pList->Load(rs.GetFieldValue("class_id").lVal);
			pList->SetSelected(pList->Find(1, CString(V_BSTRT(&rs.GetFieldValue("name")))));
		}
		else
		{
			AfxMessageBox("对不起, 并无该记录!!");
		}
		rs.Close();
		td.Close();
	};
	
}

//##ModelId=40A481F40011
void CSMDlg::OnFindUnit() 
{
	CString s;
	CSearchDlg dlg("请输入要查找的单位: ", s);
	if(IDOK==dlg.DoModal())
	{
		CDaoTableDef td(&theDatabase);
		td.Open("unit");
		CDaoRecordset rs;
		rs.Open(&td);
		rs.SetCurrentIndex("unit");
		if(rs.Seek("=", &COleVariant(s, VT_BSTRT)))
		{
			pUnitClassTree->SetSelectUnit(rs.GetFieldValue("id").lVal);
		}
		else
		{
			AfxMessageBox("对不起, 并无该记录!!");
		}
		rs.Close();
		td.Close();
	};
	
}

//##ModelId=40A481F4001F
void CSMDlg::OnExit() 
{
	CDialog::OnOK();
}

//##ModelId=40A481F40021
void CSMDlg::OnSubject() 
{
	try
	{
		CSubjectListDlg dlg;
		dlg.DoModal();	
	}
	catch(CException *e)
	{
		DisplayException(e);
	}
	
}

//##ModelId=40A481F4002E
void CSMDlg::OnTeacher() 
{
	try
	{
		CTeacherListDlg dlg;
		dlg.DoModal();	
	}
	catch(CException *e)
	{
		DisplayException(e);
	}
}

//##ModelId=40A481F40030
void CSMDlg::OnTeaching() 
{
	CTeachingDlg dlg;
	dlg.DoModal();
}

//##ModelId=40A481F4003E
void CSMDlg::OnUpdown() 
{
	CUpDownDlg dlg;
	dlg.DoModal();
}

//##ModelId=40A481F40040
void CSMDlg::OnAbout() 
{
	CAboutDlg dlgAbout;
	dlgAbout.DoModal();
}

//##ModelId=40A481F4004F
void CSMDlg::OnAccount() 
{
	CAccountDlg dlg;
	dlg.DoModal();
}

//##ModelId=40A481F40051
void CSMDlg::OnAvgClass() 
{
	CCountClassAvgDlg dlg;
	dlg.DoModal();
}

//##ModelId=40A481F4005E
void CSMDlg::OnAvgSubject() 
{
	CAvgSubjectDlg dlg;
	dlg.DoModal();
}

//##ModelId=40A481F4006D
void CSMDlg::OnLogout() 
{
	ShowWindow(SW_HIDE);
	CLogDlg dlg;
	dlg.DoModal();
	ShowWindow(SW_SHOW);
}

//##ModelId=40A481F4006F
void CSMDlg::OnLogin() 
{
	ShowWindow(SW_HIDE);
	CLogDlg dlg;
	dlg.DoModal();
	ShowWindow(SW_SHOW);
}

//##ModelId=40A481F4007D
void CSMDlg::OnScore() 
{
	CScoreDlg dlg;
	dlg.DoModal();
}

//##ModelId=40A481F4007F
void CSMDlg::OnPrintScore() 
{
	CScoreQuery dlg;
	dlg.DoModal();
}

//##ModelId=40A481F4008C
void CSMDlg::OnRclickUnittree(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
//	UnitMenu.TrackPopupMenu(TPM_LEFTBUTTON ,);
	*pResult = 0;
}

//##ModelId=40A481F302B1
void CSMDlg::PreSubclassWindow() 
{
	// TODO: Add your specialized code here and/or call the base class
	
	CDialog::PreSubclassWindow();
}

//##ModelId=40A481F4009D
void CSMDlg::OnShowWindow(BOOL bShow, UINT nStatus) 
{
	CDialog::OnShowWindow(bShow, nStatus);
	
	// TODO: Add your message handler code here
	
}