studyq.cpp

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

// STUDYQ.cpp : implementation file
//

#include "stdafx.h"
#include "YJSYS_HD.h"
#include "STUDYQ.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CSTUDYQ dialog
extern CYJSYS_HDApp theApp;


CSTUDYQ::CSTUDYQ(CWnd* pParent /*=NULL*/)
	: CDialog(CSTUDYQ::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSTUDYQ)
	m_strCode = _T("");
	m_strMAG = _T("");
	m_strTXT = _T("");
	m_strType = _T("");
	m_strName = _T("");
	//}}AFX_DATA_INIT
}


void CSTUDYQ::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSTUDYQ)
	DDX_Text(pDX, IDC_STUDY1EDIT_CODE, m_strCode);
	DDX_Text(pDX, IDC_STUDY1EDIT_MAG, m_strMAG);
	DDX_Text(pDX, IDC_STUDY1EDIT_TXT, m_strTXT);
	DDX_Text(pDX, IDC_STUDY1EDIT_CHGTYPE, m_strType);
	DDX_Text(pDX, IDC_STUDY1EDIT_CHGNAME, m_strName);
	DDX_Control(pDX, IDC_DATAGRID_STUDYQ, m_dgSTUDYQList);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSTUDYQ, CDialog)
	//{{AFX_MSG_MAP(CSTUDYQ)
	ON_BN_CLICKED(IDC_STUDYQBTN_QUERY, OnStudyqbtnQuery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSTUDYQ message handlers

void CSTUDYQ::OnStudyqbtnQuery() 
{
	// TODO: Add your control notification handler code here
	CString str,sql;
	UpdateData(true);
	if("" == m_strCode)
	{
		MessageBox("请输入你的学号");	
	}
	else
	{
		sql.Format("select * from CHG_BELONG where CODE = '"+m_strCode+"'");
		
		m_pRecordset_CHG.CreateInstance("ADODB.Recordset");
		m_pRecordset_CHG->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pconnection,true),adOpenDynamic,adLockPessimistic,adCmdText);      
    
		m_dgSTUDYQList.SetRefDataSource(NULL);
		m_dgSTUDYQList.SetRefDataSource((LPUNKNOWN)m_pRecordset_CHG);
		m_dgSTUDYQList.SetColumnHeaders(2) ;

		m_dgSTUDYQList.Refresh();
		UpdateData(false);
	}
	
}

BEGIN_EVENTSINK_MAP(CSTUDYQ, CDialog)
    //{{AFX_EVENTSINK_MAP(CSTUDYQ)
	ON_EVENT(CSTUDYQ, IDC_DATAGRID_STUDYQ, 221 /* SelChange */, OnSelChangeDatagridStudyq, VTS_PI2)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CSTUDYQ::OnSelChangeDatagridStudyq(short FAR* Cancel) 
{
	// TODO: Add your control notification handler code here
	CString str,sql;

	str = m_dgSTUDYQList.GetText();
	sql.Format("select * from STUTY_CHGUO where CHGUO_ID = '"+str+"'");

    m_pRecordset_CHG.CreateInstance("ADODB.Recordset");
	m_pRecordset_CHG->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pconnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
	
	m_strName = m_pRecordset_CHG->GetCollect("CHGUO_NAME").bstrVal;
	m_strMAG = m_pRecordset_CHG->GetCollect("MAGZINE_NAME").bstrVal;
	m_strType = m_pRecordset_CHG->GetCollect("CHGUO_TYPE").bstrVal;
	m_strTXT = m_pRecordset_CHG->GetCollect("CHGUO_TEXT").bstrVal;
	UpdateData(false);

	return;
	
}