20028324view.cpp

关于学生信息管理系统的一个小程序,适合用与应付实习,供大家使用!

	}
	m_Lset.Close(); 

}

void CMy20028324View::OnMenuAddstudent() 
{
	// TODO: Add your command handler code here
	CStdDlg dlg;
	if(dlg.DoModal()==IDOK)
	{
		if(dlg.m_number<20020000&&dlg.m_number>20029999)
		{
			MessageBox("学号必须在20020000和20029999之间！");
			return;
		}
		if(dlg.m_name=="")
		{
			MessageBox("姓名不能为空！");
			return;
		}
		if (!m_Sset.IsOpen())
		{
			m_Sset.Open();
		}
		m_Sset.AddNew();
		m_Sset.m_column1=dlg.m_number;
		m_Sset.m_column2=dlg.m_name;
		m_Sset.m_column3=dlg.m_sex;
		m_Sset.m_column4=dlg.m_age;
		m_Sset.m_column5=dlg.m_major;
		m_Sset.m_column6=dlg.m_phone;
		m_Sset.Update();
		m_Sset.Requery();
		m_Sset.Close();
	}
}

void CMy20028324View::OnMenuAddclass() 
{
	// TODO: Add your command handler code here
	CClassDlg dlg;
	int flag=1;
	if(dlg.DoModal()==IDOK)
	{
		//判断学号输入是否正确
		if (!m_Sset.IsOpen())
		{
			m_Sset.Open();
		}
		m_Sset.MoveFirst();
		while (!m_Sset.IsEOF())
		{
			if (m_Sset.m_column1==dlg.m_number)
			{
				flag=0;
				break;
			}
			m_Sset.MoveNext();
		}
		if(flag)
		{
			MessageBox("无此学号！");
			return;
		}
		m_Sset.Close();
		//课程号输入是否有误
		flag=1;
		if (!m_Lset.IsOpen())
		{
			m_Lset.Open();
		}
		m_Lset.MoveFirst();
		while (!m_Lset.IsEOF())
		{
			if (m_Lset.m_column1==dlg.m_lesson)
			{
				flag=0;
				break;
			}
			m_Lset.MoveNext();
		}
		if(flag)
		{
			MessageBox("无此课程！");
			return;
		}
		m_Lset.Close();
		if (!m_Cset.IsOpen())
		{
			m_Cset.Open();
		}
		m_Cset.AddNew();
		m_Cset.m_column1=dlg.m_number;
		m_Cset.m_column2=dlg.m_lesson;
		m_Cset.m_column3=dlg.m_chengji;
		m_Cset.m_column4=dlg.m_xueqi;
		m_Cset.Update();
		m_Cset.Requery();
		m_Cset.Close();
	}
}

void CMy20028324View::OnMenuAddlesson() 
{
	// TODO: Add your command handler code here
	CLsDlg dlg;
	if(dlg.DoModal()==IDOK)
	{
		if(dlg.m_lsnum<00&&dlg.m_lsnum>999)
		{
			MessageBox("课程号必须在00和999之间！");
			return;
		}
		if(dlg.m_lesson=="")
		{
			MessageBox("课程名不能为空！");
			return;
		}
		if (!m_Lset.IsOpen())
		{
			m_Lset.Open();
		}
		m_Lset.AddNew();
		m_Lset.m_column1=dlg.m_lsnum;
		m_Lset.m_column2=dlg.m_lesson;
		m_Lset.m_column3=dlg.m_xuefen;
		m_Lset.Update();
		m_Lset.Requery();
		m_Lset.Close();
	}
}

void CMy20028324View::OnMenuDellesson() 
{
	// TODO: Add your command handler code here
	CDelDlg dlg;
	int flag=1;
	if(dlg.DoModal()==IDOK)
	{
		if (!m_Lset.IsOpen())
		{
			m_Lset.Open();
		}
		m_Lset.MoveFirst();
		while (!m_Lset.IsEOF())
		{
			if (m_Lset.m_column1==dlg.m_lesson)
			{
				flag=0;
				break;
			}
			m_Lset.MoveNext();
		}
		if(flag)
		{
			MessageBox("无此课程号！");
			return;
		}
		if (dlg.m_lesson!=dlg.m_lesson2)
		{
			MessageBox("两次课程号输入不一致！");
			return;
		}
		m_Lset.Delete();	
		m_Lset.Close();
		//删除Class表中对应的记录
		if (!m_Cset.IsOpen())
		{
			m_Cset.Open();
		}
		m_Cset.MoveFirst();
		while (!m_Cset.IsEOF())
		{
			if(m_Cset.m_column2==dlg.m_lesson2)
			{
				m_Cset.Delete();
			}
			m_Cset.MoveNext();
		}
		m_Cset.Close();
	}
}

void CMy20028324View::OnMenuDelstudent() 
{
	// TODO: Add your command handler code here
	CDelStdDlg dlg;
	int flag=1;
	if(dlg.DoModal()==IDOK)
	{
		if (!m_Sset.IsOpen())
		{
			m_Sset.Open();
		}
		m_Sset.MoveFirst();
		while (!m_Sset.IsEOF())
		{
			if (m_Sset.m_column1==dlg.m_number)
			{
				flag=0;
				break;
			}
			m_Sset.MoveNext();
		}
		if(flag)
		{
			MessageBox("无此学号！");
			return;
		}
		if (dlg.m_number!=dlg.m_number2)
		{
			MessageBox("两次课程号输入不一致！");
			return;
		}
		m_Sset.Delete();	
		m_Sset.Close();
		//删除Class表中对应的记录
		if (!m_Cset.IsOpen())
		{
			m_Cset.Open();
		}
		m_Cset.MoveFirst();
		while (!m_Cset.IsEOF())
		{
			if(m_Cset.m_column1==dlg.m_number2)
			{
				m_Cset.Delete();
			}
			m_Cset.MoveNext();
		}
		m_Cset.Close();
	}
}

void CMy20028324View::OnDblclkList2(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	this->UpdateData();
	if (m_check1)
	{
		POSITION iPos = m_list2.GetFirstSelectedItemPosition();
		int nItem = m_list2.GetNextSelectedItem(iPos);
		if(nItem == -1)	
			return;
		CString num=m_list2.GetItemText(nItem,0);
		CString lesson=m_list2.GetItemText(nItem,1);
		if (!m_Cset.IsOpen())
		{
			m_Cset.Open();
		}
		while (!m_Cset.IsEOF())
		{
			CString a,b;
			a.Format("%d",m_Cset.m_column1);
			b.Format("%d",m_Cset.m_column2);
			if (num==a&&lesson==b)
			{
				m_Cset.Delete();
				break;
			}
			m_Cset.MoveNext();
		}
		m_Cset.Requery();

		m_list2.SetItemText(nItem,0,"");
		m_list2.SetItemText(nItem,1,"");
		m_list2.SetItemText(nItem,2,"");
		m_list2.SetItemText(nItem,3,"");
		m_Cset.Close(); 
	}
	*pResult = 0;
}

void CMy20028324View::OnUpdateMenuAddclass(CCmdUI* pCmdUI) 
{
	// TODO: Add your command update UI handler code here
	pCmdUI->Enable(IsSuper);
}

void CMy20028324View::OnUpdateMenuAddlesson(CCmdUI* pCmdUI) 
{
	// TODO: Add your command update UI handler code here
	pCmdUI->Enable(IsSuper);
}

void CMy20028324View::OnUpdateMenuAddstudent(CCmdUI* pCmdUI) 
{
	// TODO: Add your command update UI handler code here
	pCmdUI->Enable(IsSuper);
}

void CMy20028324View::OnUpdateMenuDellesson(CCmdUI* pCmdUI) 
{
	// TODO: Add your command update UI handler code here
	pCmdUI->Enable(IsSuper);
}

void CMy20028324View::OnUpdateMenuDelstudent(CCmdUI* pCmdUI) 
{
	// TODO: Add your command update UI handler code here
	pCmdUI->Enable(IsSuper);
}

void CMy20028324View::OnLes() 
{
	// TODO: Add your command handler code here
	CLsDlg cDlg;
	if (cDlg.DoModal() == IDOK)
	{
		if (m_Lset.IsOpen())
			m_Lset.Close();
		m_Lset.Open();
		UpdateData();
		m_Lset.Edit();
		m_Lset.m_column1 = cDlg.m_lsnum;
		m_Lset.m_column2 = cDlg.m_lesson;
		m_Lset.m_column3 = cDlg.m_xuefen;
		m_Lset.Update();
	}
}