dialogamenddata.cpp

学生信息管理系统,后台用了SQL.主要功能： 查询

//
/****************************************/
/*		SchoolManageSystem			    */
/*设计者：全佳营						*/
/*时间：2004.5.9-2004-5.18				*/
/*Email:[e-mail]				*/
/****************************************/
// DialogAmendData.cpp : 实现文件
//

#include "stdafx.h"
#include "SchoolManageSys_2.h"
#include "DialogAmendData.h"
#include ".\dialogamenddata.h"
#include "SchoolManageSys_2Dlg.h"

// CDialogAmendData 对话框

IMPLEMENT_DYNAMIC(CDialogAmendData, CDialog)
CDialogAmendData::CDialogAmendData(CWnd* pParent /*=NULL*/)
	: CDialog(CDialogAmendData::IDD, pParent)
{
}

CDialogAmendData::~CDialogAmendData()
{
}

void CDialogAmendData::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_DATAGRID1, m_amendinfo);
	DDX_Control(pDX, IDC_COMBO_AMENDCHIOCE, m_choice);
	DDX_Control(pDX, IDC_COMBO_ID, m_amendid);
}


BEGIN_MESSAGE_MAP(CDialogAmendData, CDialog)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
	ON_CBN_SELCHANGE(IDC_COMBO_AMENDCHIOCE, OnCbnSelchangeComboAmendchioce)
	ON_CBN_SELCHANGE(IDC_COMBO_ID, OnCbnSelchangeComboId)
	ON_BN_CLICKED(IDC_BUTTON_BACKAMEND, OnBnClickedButtonBackamend)
END_MESSAGE_MAP()


// CDialogAmendData 消息处理程序
BOOL CDialogAmendData::OnInitDialog(){
	CDialog::OnInitDialog();
	theApp.m_pSkin->ApplySkin((long)m_hWnd);

	m_choice.AddString("学院");
	m_choice.AddString("系");
	m_choice.AddString("班级");
	m_choice.AddString("社团");
	m_choice.AddString("学生");
	m_choice.AddString("教师");
	m_choice.AddString("课程");
	m_choice.SetCurSel(0);
	CWnd *m_pWnd=CWnd::FindWindow(NULL,"校人事信息管理系统");
	m_adoconnection=((CSchoolManageSys_2Dlg*) m_pWnd)->m_AdoConnection;

	return TRUE;
}
void CDialogAmendData::OnBnClickedOk()
{
	// TODO: 在此添加控件通知处理程序代码
	
	if(!m_adoconnection.CommitTrans())
	{
		AfxMessageBox("修改失败");
		return;
	}
	OnOK();
}

void CDialogAmendData::OnCbnSelchangeComboAmendchioce()
{
	// TODO: 在此添加控件通知处理程序代码
	UpdateData();
	CString sqlstr;
	m_choice.GetLBText(m_choice.GetCurSel(),m_select1);
	if(m_select1=="学院"){
		sqlstr="collegerecord";
		m_pid="collegeid";
	}else if(m_select1=="系"){
		sqlstr="departmentrecord";
		m_pid="departmentid";
	}else if(m_select1=="班级"){
		sqlstr="classrecord";
		m_pid="classid";
	}else if(m_select1=="社团"){
		sqlstr="consortiumrecord";
		m_pid="consortiumid";
	}else if(m_select1=="学生"){
		sqlstr="studentrecord";
		m_pid="studynum";
	}else if(m_select1=="教师"){
		sqlstr="teacherrecord";
		m_pid="teachernum";
	}else if(m_select1=="课程"){
		sqlstr="lessonrecord";
		m_pid="lessonid";
	}
	if(m_adoconnection.IsOpen()){
		m_adorecordset.SetAdoConnection(&m_adoconnection);
		m_adorecordset.SetCursorLocation();
		m_adorecordset.Open(sqlstr,adCmdTable);
	}
	if(!m_adorecordset.IsBOF())
		m_adorecordset.MoveFirst();
	int nrecord=m_adorecordset.GetRecordCount();
	CString tmpid,tmp;
	int tmpid1;
	while(!m_adorecordset.IsEOF()){
		if(m_pid=="studynum"||m_pid=="teachernum"){
			m_adorecordset.GetCollect(m_pid,tmpid);
			tmp.Format("%s",tmpid);
		}else {
			m_adorecordset.GetCollect(m_pid,tmpid1);
			tmp.Format("%d",tmpid1);
		}
		m_amendid.AddString(tmp);
		m_adorecordset.MoveNext();
	}
	m_amendid.SetCurSel(0);
}

void CDialogAmendData::OnCbnSelchangeComboId()
{
	// TODO: 在此添加控件通知处理程序代码
	UpdateData();
	CString m_tmpid,tmp;
	m_amendid.GetLBText(m_amendid.GetCurSel(),m_tmpid);
	if(m_pid=="studynum"||m_pid=="teachernum"){
		tmp.Format("%s=\'%s\'",m_pid,m_tmpid);
	}else {
		tmp.Format("%s=%s",m_pid,m_tmpid);
	}
	m_adorecordset.SetFilter(tmp);
	if(m_adorecordset.IsEOF()){
		AfxMessageBox("没有相关信息");
		return;
	}
	m_amendinfo.putref_DataSource(NULL);
	m_amendinfo.putref_DataSource((LPUNKNOWN)m_adorecordset.GetRecordset());
	m_amendinfo.put_AllowAddNew(TRUE);
	m_amendinfo.put_AllowDelete(TRUE);
	m_amendinfo.put_AllowUpdate(TRUE);
}

void CDialogAmendData::OnBnClickedButtonBackamend()
{
	// TODO: 在此添加控件通知处理程序代码
	if(!m_adoconnection.RollbackTrans()){
		AfxMessageBox("撤消失败");
	}
}