1.txt

一个信息管理系统C代码 不完全

#include "school.h" 
#include "ChangeDegradeDlg.h" 
#include "ChangeDegradeInfoDlg.h" 
 
#ifdef _DEBUG 
#define new DEBUG_NEW 
#undef THIS_FILE 
static char THIS_FILE[] = __FILE__; 
#endif 
 
///////////////////////////////////////////////////////////////////////////// 
// CChangeDegradeDlg dialog 
 
 
CChangeDegradeDlg::CChangeDegradeDlg(CWnd* pParent /*=NULL*/) 
	: CDialog(CChangeDegradeDlg::IDD, pParent) 
{ 
	//{{AFX_DATA_INIT(CChangeDegradeDlg) 
		// NOTE: the ClassWizard will add member initialization here 
	//}}AFX_DATA_INIT 
} 
 
 
void CChangeDegradeDlg::DoDataExchange(CDataExchange* pDX) 
{ 
	CDialog::DoDataExchange(pDX); 
	//{{AFX_DATA_MAP(CChangeDegradeDlg) 
	DDX_Control(pDX, IDC_LIST1, m_ctrList); 
	//}}AFX_DATA_MAP 
} 
 
 
BEGIN_MESSAGE_MAP(CChangeDegradeDlg, CDialog) 
	//{{AFX_MSG_MAP(CChangeDegradeDlg) 
	ON_BN_CLICKED(IDC_BUTTON_NEW, OnButtonNew) 
	ON_BN_CLICKED(IDC_BUTTON_MODIFY, OnButtonModify) 
	ON_BN_CLICKED(IDC_BUTTON_DELETE, OnButtonDelete) 
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1) 
	//}}AFX_MSG_MAP 
END_MESSAGE_MAP() 
 
///////////////////////////////////////////////////////////////////////////// 
// CChangeDegradeDlg message handlers 
 
BOOL CChangeDegradeDlg::OnInitDialog()  
{ 
	CDialog::OnInitDialog(); 
	 
	m_ctrList.InsertColumn(0,"编号"); 
	m_ctrList.InsertColumn(1,"留级人"); 
	m_ctrList.InsertColumn(2,"原属班级"); 
	m_ctrList.InsertColumn(3,"留级班级"); 
	m_ctrList.InsertColumn(4,"留级日期"); 
	m_ctrList.InsertColumn(5,"留级原因"); 
 
	m_ctrList.SetColumnWidth(0,80); 
	m_ctrList.SetColumnWidth(1,80); 
	m_ctrList.SetColumnWidth(2,80); 
	m_ctrList.SetColumnWidth(3,80); 
	m_ctrList.SetColumnWidth(4,80); 
	m_ctrList.SetColumnWidth(5,120); 
	m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES); 
	RefreshData(); 
	 
	return TRUE;  // return TRUE unless you set the focus to a control 
	              // EXCEPTION: OCX Property Pages should return FALSE 
} 
 
 
void CChangeDegradeDlg::RefreshData() 
{ 
 
	m_ctrList.DeleteAllItems(); 
	m_ctrList.SetRedraw(FALSE); 
 
	UpdateData(TRUE); 
	CString strSQL; 
	strSQL="select * from degrade"; 
	if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)) 
	{ 
		MessageBox("打开数据库失败!","数据库错误",MB_OK); 
		return ; 
	}	 
	int i=0; 
	while(!m_recordset.IsEOF()) 
	{ 
		 
		m_ctrList.InsertItem(i,m_recordset.m_code); 
		m_ctrList.SetItemText(i,1,m_recordset.m_name); 
		m_ctrList.SetItemText(i,2,m_recordset.m_class_past); 
		m_ctrList.SetItemText(i,3,m_recordset.m_class_now); 
		m_ctrList.SetItemText(i,4,m_recordset.m_date); 
		m_ctrList.SetItemText(i,5,m_recordset.m_reason); 
 
		i++; 
		m_recordset.MoveNext(); 
	} 
	m_recordset.Close(); 
	m_ctrList.SetRedraw(TRUE); 
	 
} 
 
void CChangeDegradeDlg::OnButtonNew()  
{ 
	// TODO: Add your control notification handler code here 
	CString strSQL; 
	CChangeDegradeInfoDlg   Dlg; 
	while(1) 
	{ 
		if(IDOK==Dlg.DoModal()) 
		{ 
			strSQL.Format("select * from degrade where code = '%s'",Dlg.m_strCode); 
			if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)) 
			{ 
				AfxMessageBox("打开数据库失败!"); 
				return ; 
			} 
			if(m_recordset.GetRecordCount()!=0) 
			{ 
				AfxMessageBox("该编号已经存在！请重新输入！"); 
				m_recordset.Close(); 
				continue; 
			} 
			 
			m_recordset.AddNew(); 
			m_recordset.m_name		=	Dlg.m_strName		; 
			m_recordset.m_reason	=	Dlg.m_strBrief		; 
			m_recordset.m_date		=   Dlg.m_strDate		; 
			m_recordset.m_class_past=	Dlg.m_strOldClass	; 
			m_recordset.m_code		=	Dlg.m_strCode		; 
			m_recordset.m_class_now	=	Dlg.m_strNewClass	; 
			m_recordset.Update(); 
			m_recordset.Close(); 
			RefreshData(); 
		} 
		break; 
	}			 
} 
 
void CChangeDegradeDlg::OnButtonModify()  
{ 
	// TODO: Add your control notification handler code here 
	CChangeDegradeInfoDlg  Dlg; 
	UpdateData(); 
	int i = m_ctrList.GetSelectionMark(); 
	if(0>i) 
	{ 
		AfxMessageBox("请选择一条记录进行修改！"); 
		return; 
	} 
 
	 
	Dlg.m_strName			=	m_ctrList.GetItemText(i,1); 
	Dlg.m_strBrief			=	m_ctrList.GetItemText(i,5); 
	Dlg.m_strDate			=	m_ctrList.GetItemText(i,4); 
	Dlg.m_strOldClass		=	m_ctrList.GetItemText(i,2); 
	Dlg.m_strCode			=	m_ctrList.GetItemText(i,0); 
	Dlg.m_strNewClass		=	m_ctrList.GetItemText(i,3); 
 
	if(IDOK==Dlg.DoModal()) 
	{//修改记录 
		CString strSQL; 
		strSQL.Format("select * from degrade where code = '%s'",m_ctrList.GetItemText(i,0)); 
		if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)) 
		{ 
			AfxMessageBox("打开数据库失败!"); 
			return ; 
		} 
		m_recordset.Edit(); 
		m_recordset.m_name		=	Dlg.m_strName		; 
		m_recordset.m_reason	=	Dlg.m_strBrief		; 
		m_recordset.m_date		=   Dlg.m_strDate		; 
		m_recordset.m_class_past=	Dlg.m_strOldClass	; 
		m_recordset.m_code		=	Dlg.m_strCode		; 
		m_recordset.m_class_now	=	Dlg.m_strNewClass	; 
		m_recordset.Update(); 
		m_recordset.Close(); 
		RefreshData(); 
	}					 
} 
 
void CChangeDegradeDlg::OnButtonDelete()  
{ 
	// TODO: Add your control notification handler code here 
	int i = m_ctrList.GetSelectionMark(); 
	if(0>i) 
	{ 
		AfxMessageBox("请选择一条记录进行查看！"); 
		return; 
	} 
	CString strSQL; 
	strSQL.Format("select * from degrade where code = '%s' ",m_ctrList.GetItemText(i,0)); 
	if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)) 
	{ 
		AfxMessageBox("打开数据库失败!"); 
		return ; 
	} 
	m_recordset.Delete(); 
	m_recordset.Close(); 
	RefreshData();				 
} 
 
void CChangeDegradeDlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult)  
{ 
	// TODO: Add your control notification handler code here 
	CChangeDegradeInfoDlg  Dlg; 
	UpdateData(); 
	int i = m_ctrList.GetSelectionMark(); 
	if(0>i) 
	{ 
		AfxMessageBox("请选择一条记录进行修改！"); 
		return; 
	} 
 
	 
	Dlg.m_strName			=	m_ctrList.GetItemText(i,1); 
	Dlg.m_strBrief			=	m_ctrList.GetItemText(i,5); 
	Dlg.m_strDate			=	m_ctrList.GetItemText(i,4); 
	Dlg.m_strOldClass		=	m_ctrList.GetItemText(i,2); 
	Dlg.m_strCode			=	m_ctrList.GetItemText(i,0); 
	Dlg.m_strNewClass		=	m_ctrList.GetItemText(i,3); 
 
	if(IDOK==Dlg.DoModal()) 
	{//修改记录 
		CString strSQL; 
		strSQL.Format("select * from degrade where code = '%s'",m_ctrList.GetItemText(i,0)); 
		if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)) 
		{ 
			AfxMessageBox("打开数据库失败!"); 
			return ; 
		} 
		m_recordset.Edit(); 
		m_recordset.m_name		=	Dlg.m_strName		; 
		m_recordset.m_reason	=	Dlg.m_strBrief		; 
		m_recordset.m_date		=   Dlg.m_strDate		; 
		m_recordset.m_class_past=	Dlg.m_strOldClass	; 
		m_recordset.m_code		=	Dlg.m_strCode		; 
		m_recordset.m_class_now	=	Dlg.m_strNewClass	; 
		m_recordset.Update(); 
		m_recordset.Close(); 
		RefreshData(); 
	}					 
	*pResult = 0; 
}