xuanke.cpp

研究生信息管理系统 基于VC++6.0 MFC 内附ACCESS数据库文件 一个完成工程文件 编译通过后可直接运行 （需装有SP5以上补丁）

		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"学位课       ");	
	}
	if(m_strXWK4!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strXWK4);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"学位课       ");	
	}
	if(m_strXXK1!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strXXK1);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"选修课       ");	
	}
	if(m_strXXK2!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strXXK2);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"选修课       ");	
	}
	if(m_strXXK3!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strXXK3);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"选修课       ");	
	}
	if(m_strXXK4!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strXXK4);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"选修课       ");	
	}
	if(m_strXXK5!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strXXK5);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"选修课       ");	
	}
	if(m_strXXK6!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strXXK6);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"选修课       ");	
	}
	if(m_strXXK7!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strXXK7);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"选修课       ");	
	}
	if(m_strXXK8!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strXXK8);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"选修课       ");	
	}
	if(m_strBBK1!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strBBK1);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"补本课       ");	
	}
	if(m_strBBK2!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strBBK2);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"补本课       ");	
	}
	if(m_strBBK3!="")
	{
		m_pRecordset_PYFA_DETAIL->AddNew();
		m_pRecordset_PYFA_DETAIL->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_PYFA_DETAIL->PutCollect("PY_CODE",(_variant_t)m_strPY_code);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_NAME2",(_variant_t)m_strBBK3);
		m_pRecordset_PYFA_DETAIL->PutCollect("LESSON_TYPE2",(_variant_t)"补本课       ");	
	}
	m_pRecordset_PYFA_DETAIL->Update();

	m_pRecordset_PYFANGAN->MoveFirst();
	while(!m_pRecordset_PYFANGAN->rsEOF)
	{
		str=m_pRecordset_PYFANGAN->GetCollect("CODE").bstrVal;
		if(0==m_strCode.CompareNoCase(str))
		{   
			m_pRecordset_PYFANGAN->PutCollect("PY_ISCHOOSE",(_variant_t)"-1"); break;
		}
		m_pRecordset_PYFANGAN->MoveNext();
	}
	m_pRecordset_PYFANGAN->Update();
	m_Commit_Ischoose=false;
	MessageBox("你的所选课程已经提交，点击毙可以查询，若修改请找相关人员");
}

void CXUANKE::OnXuankebtnModify() 
{
	// TODO: Add your control notification handler code here
	if(theApp.m_level==0)
	{
		MessageBox("你不能进行已注册课程的修改");
		return;	
	}
	else
	{
		UpdateData(true);
		if("" == m_strCode)
		{
			MessageBox("请输入修改课程同学的学号"); return;
		}
		else
		{
		
		}
	
	}
	
}

void CXUANKE::OnXuankebtnQuery() 
{
	// TODO: Add your control notification handler code here
	CString sql;
	UpdateData(true);
	if(""==m_strCode)
	{
		MessageBox("请输入你的学号","提示!");
		return;
	}
	sql.Format("select CODE,LESSON_NAME2,LESSON_TYPE2 FROM PYFA_DEDAIL WHERE CODE='"+m_strCode+"'");
	m_pRecordset_PYFA_DETAIL.CreateInstance("ADODB.Recordset");
	m_pRecordset_PYFA_DETAIL->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pconnection,true),adOpenDynamic,adLockPessimistic,adCmdText); 
	
	if(m_pRecordset_PYFA_DETAIL->GetRecordCount()!=0)
	{
		m_dgXKList.SetRefDataSource(NULL);
		m_dgXKList.SetRefDataSource((LPUNKNOWN)m_pRecordset_PYFA_DETAIL);
		m_dgXKList.SetColumnHeaders(2) ;
 
		_variant_t var;
		var = long(0);
		m_dgXKList.GetColumns().GetItem(var).SetCaption("学号");
		m_dgXKList.GetColumns().GetItem(var).SetWidth(90);
		var = long(1);
		m_dgXKList.GetColumns().GetItem(var).SetCaption("课程名");
		m_dgXKList.GetColumns().GetItem(var).SetWidth(70);
		var = long(2);
		m_dgXKList.GetColumns().GetItem(var).SetCaption("课程类别");
		m_dgXKList.GetColumns().GetItem(var).SetWidth(70);
        m_dgXKList.Refresh();
		UpdateData(false);
		return;
	}
	else
	{
		MessageBox("没有你的选课记录！"); return;
	}
		

}

void CXUANKE::OnXuankebtnQueren() 
{
	// TODO: Add your control notification handler code here
	
}

void CXUANKE::OnXuankebtnQlesson() 
{
	// TODO: Add your control notification handler code here

     	CString str,sql;

		sql.Format("select * from LESSON2");
		
		m_pRecordset_LESSON2.CreateInstance("ADODB.Recordset");
		m_pRecordset_LESSON2->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pconnection,true),adOpenDynamic,adLockPessimistic,adCmdText);      
    
		m_dgXKList.SetRefDataSource(NULL);
		m_dgXKList.SetRefDataSource((LPUNKNOWN)m_pRecordset_LESSON2);
		m_dgXKList.SetColumnHeaders(2) ;

		m_dgXKList.Refresh();
	return;
}