studan.cpp

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

					MessageBox("该编号的学生记录已存在");
					return;
				}
				
				m_pRecordset_STUD->MoveNext();
			}
			
		}
		m_pRecordset_STUD->AddNew();//记录集增加新条目
		m_pRecordset_STUD->PutCollect("CODE",(_variant_t)m_strCode);
		m_pRecordset_STUD->PutCollect("CLASS_CODE",(_variant_t)m_strClass);
		m_pRecordset_STUD->PutCollect("TEACH_CODE",(_variant_t)m_strTeach);
		m_pRecordset_STUD->PutCollect("NAME",(_variant_t)m_strSTUName);
		m_pRecordset_STUD->PutCollect("Sex",(_variant_t)m_strSex);
		m_pRecordset_STUD->PutCollect("IDENTIFY_ID",(_variant_t)m_strIdentity);
		GetDlgItemText(IDC_DATETIMEPICKER_BIRTH,str);//转换时间格式
		m_pRecordset_STUD->PutCollect("BIRTH",(_variant_t)str);
		m_pRecordset_STUD->PutCollect("FOLK",(_variant_t)m_strFolk);
		m_pRecordset_STUD->PutCollect("POLITICAL",(_variant_t)m_strPolitical);
		m_pRecordset_STUD->PutCollect("PHONE",(_variant_t)m_strPhone);
		m_pRecordset_STUD->Update();//更新数据
		MessageBox("学生信息保存完毕 ","基本信息",MB_OK);
		m_dgSTUDANList.Refresh();
		return;
	}	
}

void CSTUDAN::OnStudanbtnModify() 
{
	// TODO: Add your control notification handler code here
	CString str,sql;
	if(theApp.loginstatus != 2)
	{
		MessageBox("你没有此权限","提示"); return;
	}

	UpdateData(true);
	if("" == m_strCode)
	{
		MessageBox("请从列表框中选择预修改的学生信息");
	}
	else
	{
		sql = "select * from STUD ";
		m_pRecordset_STUD.CreateInstance("ADODB.Recordset");//建立数据集
		m_pRecordset_STUD->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pconnection,true),adOpenDynamic,adLockPessimistic,adCmdText);       	

		m_pRecordset_STUD->MoveFirst();
		while(!m_pRecordset_STUD->rsEOF)
		{
			str = m_pRecordset_STUD->GetCollect("CODE").bstrVal;
			if(0 == str.CompareNoCase(m_strCode))
			{
				m_pRecordset_STUD->PutCollect("CODE",(_variant_t)m_strCode);
				m_pRecordset_STUD->PutCollect("CLASS_CODE",(_variant_t)m_strClass);
				m_pRecordset_STUD->PutCollect("TEACH_CODE",(_variant_t)m_strTeach);
				m_pRecordset_STUD->PutCollect("NAME",(_variant_t)m_strSTUName);
				m_pRecordset_STUD->PutCollect("Sex",(_variant_t)m_strSex);
				m_pRecordset_STUD->PutCollect("IDENTIFY_ID",(_variant_t)m_strIdentity);
				GetDlgItemText(IDC_DATETIMEPICKER_BIRTH,str);//转换时间格式
				m_pRecordset_STUD->PutCollect("BIRTH",(_variant_t)str);
				m_pRecordset_STUD->PutCollect("FOLK",(_variant_t)m_strFolk);
				m_pRecordset_STUD->PutCollect("POLITICAL",(_variant_t)m_strPolitical);
				m_pRecordset_STUD->PutCollect("PHONE",(_variant_t)m_strPhone);
				m_pRecordset_STUD->Update();//更新数据
				MessageBox("学生更改保存完毕 ","基本信息",MB_OK);
				m_dgSTUDANList.Refresh();		
				
				return;
			}

			m_pRecordset_STUD->MoveNext();
		}
		
	
	
	
	
	}
	
}

void CSTUDAN::OnStudanbtnQuery() 
{// TODO: Add your control notification handler code here
	CString sql;
	UpdateData(true);
	if(""==m_strCodeQuery && ""==m_strClassQuery)
	{
		MessageBox("请选择查询方式");
	}
	else
	{
		if(m_nQueryContent == 1)
		{
			if("" != m_strCodeQuery)
			{	
				sql.Format("select * FROM STUD WHERE CODE='"+m_strCodeQuery+"'");
				m_pRecordset_STUD.CreateInstance("ADODB.Recordset");
			}
			else
			{
				sql.Format("select * FROM STUD WHERE CLASS_CODE='"+m_strClassQuery+"' ");
				m_pRecordset_STUD.CreateInstance("ADODB.Recordset");
			}
			m_pRecordset_STUD->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pconnection,true),adOpenDynamic,adLockPessimistic,adCmdText); 
			if(m_pRecordset_STUD->GetRecordCount != 0)
			{
				m_dgSTUDANList.SetRefDataSource(NULL);
				m_dgSTUDANList.SetRefDataSource((LPUNKNOWN)m_pRecordset_STUD);
				m_dgSTUDANList.SetColumnHeaders(2) ;

				_variant_t var;
				var = long(0);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("学号");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(90);
				var = long(1);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("班级号");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(50);
				var = long(2);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("导师代号");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(60);
				var = long(3);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("姓名");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(40);
				var = long(4);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("性别");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(30);
				var = long(5);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("身份证号");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(100);
				var = long(6);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("出生日期");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(60);
				var = long(7);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("民族");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(35);
				var = long(8);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("政治面貌");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(50);
				var = long(9);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("联系方式");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(80);
				UpdateData(false);
				return;
			}
			else
			{
				MessageBox("你尚未注册学籍","提示"); return;
			}
		}
		else
		{
			if("" != m_strClassQuery)
			{
				sql.Format("select * FROM CLASS WHERE CLASS_CODE='"+m_strClassQuery+"'");
				m_pRecordset_CLASS.CreateInstance("ADODB.Recordset");
				m_pRecordset_CLASS->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pconnection,true),adOpenDynamic,adLockPessimistic,adCmdText); 
			
				m_dgSTUDANList.SetRefDataSource(NULL);
				m_dgSTUDANList.SetRefDataSource((LPUNKNOWN)m_pRecordset_CLASS);
				m_dgSTUDANList.SetColumnHeaders(2) ;

				_variant_t var;
				var = long(0);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("班级代号");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(60);
				var = long(1);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("班级名称");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(70);
				var = long(2);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("人数");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(40);
				var = long(3);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("专业");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(60);
				var = long(4);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("学院");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(100);
				var = long(5);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("备注");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(60);
				var = long(6);
				m_dgSTUDANList.GetColumns().GetItem(var).SetCaption("班长");
				m_dgSTUDANList.GetColumns().GetItem(var).SetWidth(50);
				UpdateData(false);
				return;
			}
		
		
		}
	}

	
}

BEGIN_EVENTSINK_MAP(CSTUDAN, CDialog)
    //{{AFX_EVENTSINK_MAP(CSTUDAN)
	ON_EVENT(CSTUDAN, IDC_DATAGRID_STUDANList, 221 /* SelChange */, OnSelChangeDATAGRIDSTUDANList, VTS_PI2)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CSTUDAN::OnSelChangeDATAGRIDSTUDANList(short FAR* Cancel) 
{
	// TODO: Add your control notification handler code here
	CString sql;
	CString str,str2;
	str = m_dgSTUDANList.GetText();
	sql.Format("select * from STUD where CODE='"+str+"'");
	m_pRecordset_STUD.CreateInstance("ADODB.Recordset");
	m_pRecordset_STUD->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pconnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
	
	m_strCode = m_pRecordset_STUD->GetCollect("CODE").bstrVal;
	m_strClass = m_pRecordset_STUD->GetCollect("CLASS_CODE").bstrVal;
	m_strTeach = m_pRecordset_STUD->GetCollect("TEACH_CODE").bstrVal;
	m_strSTUName = m_pRecordset_STUD->GetCollect("NAME").bstrVal;
	m_strSex = m_pRecordset_STUD->GetCollect("SEX").bstrVal;
	m_strIdentity = m_pRecordset_STUD->GetCollect("IDENTIFY_ID").bstrVal;
	str2 = m_pRecordset_STUD->GetCollect("Birth").bstrVal;
	m_dtCtrlBirth.SetFormat(str2);
	m_strFolk = m_pRecordset_STUD->GetCollect("FOLK").bstrVal;
	m_strPolitical = m_pRecordset_STUD->GetCollect("POLITICAL").bstrVal;
	m_strPhone = m_pRecordset_STUD->GetCollect("PHONE").bstrVal;
	UpdateData(FALSE);
	
	return;

}