www.pudn.com > 111.rar > DialogAmendData.cpp

// 
/****************************************/ 
/*		SchoolManageSystem			    */ 
/*设计者：全佳营						*/ 
/*时间：2004.5.9-2004-5.18				*/ 
/*Email:ghostman@tzc.edu.cn				*/ 
/****************************************/ 
// 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("撤消失败"); 
	} 
}