paiming.cpp

是自己做的一个小的学生管理系统.希望对大家有用

// Paiming.cpp : implementation file
//

#include "stdafx.h"
#include "student2.h"
#include "Paiming.h"
#include "ScoreDel.h"
#include "ScoreAdd.h"
#include "Jsj1.h"
#include "Jsj2.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CPaiming dialog


CPaiming::CPaiming(CWnd* pParent /*=NULL*/)
	: CDialog(CPaiming::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPaiming)
	m_comboxclass = _T("");
	//}}AFX_DATA_INIT
}


void CPaiming::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPaiming)
	DDX_CBString(pDX, IDC_COMBO_CLASS, m_comboxclass);
	//}}AFX_DATA_MAP
	
}


BEGIN_MESSAGE_MAP(CPaiming, CDialog)
	//{{AFX_MSG_MAP(CPaiming)
	ON_BN_CLICKED(IDC_SCORE_DEL, OnScoreDel)
	ON_BN_CLICKED(IDC_SCORE_ADD, OnScoreAdd)
	ON_BN_CLICKED(IDC_SCORE_FIND, OnScoreFind)
	ON_BN_CLICKED(IDC_SCORE_EDIT, OnScoreEdit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPaiming message handlers


void CPaiming::OnScoreDel() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_comboxclass=="一班")
	{			
		if(MessageBox("您确信要删除你选定的学生信息吗？", "确认", 
			MB_OK | MB_YESNO | MB_ICONQUESTION) == IDYES)
		{
			CScoreDel dlg;
			dlg.DoModal();
			CString strSQL;
			
			strSQL.Format("DELETE from jsj1 WHERE 学号 = '%s'" ,dlg.m_delstuno);
			
			CDatabase db;
			db.Open(_T("studentsn"));
			db.ExecuteSQL(strSQL) ;
			db.Close();
		}
	}
	else if(m_comboxclass=="二班")
	{
		if(MessageBox("您确信要删除你选定的学生信息吗？", "确认", 
			MB_OK | MB_YESNO | MB_ICONQUESTION) == IDYES)
		{
			CScoreDel dlg;
			dlg.DoModal();
			CString strSQL;
			
			strSQL.Format("DELETE from jsj2 WHERE 学号 = '%s'" ,dlg.m_delstuno);
			
			CDatabase db;
			db.Open(_T("studentsn"));
			db.ExecuteSQL(strSQL) ;
			db.Close();
		}
	}
	else
		AfxMessageBox("请选择你的班级！");
}

void CPaiming::OnScoreAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_comboxclass=="一班")
	{			
 		CScoreAdd dlg;
			dlg.DoModal();	
			if(dlg.m_addstuno=="")
			{			
				AfxMessageBox("学号不能为空！");
			return;
			}
			CString strSQL;

			strSQL.Format("insert into jsj1 (学号,姓名,数学,物理,化学,英语,政治) values('%s','%s',%d,%d,%d,%d,%d)",dlg.m_addstuno,dlg.m_addstuname,dlg.m_addmaths,dlg.m_addphycical,dlg.m_addchmistry,dlg.m_addenglish,dlg.m_addpolitic);
			
			CDatabase db;
			db.Open(_T("studentsn"));
			db.ExecuteSQL(strSQL) ;
			db.Close();
	}
	else if(m_comboxclass=="二班")
	{
 		CScoreAdd dlg;
			dlg.DoModal();	
			CString strSQL;
				if(dlg.m_addstuno=="")
			{			
				AfxMessageBox("学号不能为空！");
			return;
			}
			strSQL.Format("insert into jsj2 (学号,姓名,数学,物理,化学,英语,政治) values('%s','%s',%d,%d,%d,%d,%d)",dlg.m_addstuno,dlg.m_addstuname,dlg.m_addmaths,dlg.m_addphycical,dlg.m_addchmistry,dlg.m_addenglish,dlg.m_addpolitic);
			
			CDatabase db;
			db.Open(_T("studentsn"));
			db.ExecuteSQL(strSQL) ;
			db.Close();
	}
	else
		AfxMessageBox("请选择你的班级！");	
}

void CPaiming::OnScoreFind() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_comboxclass=="一班")
	{
		CScoreDel dlg;
		dlg.DoModal();
		CString str;
				if(dlg.m_delstuno=="")
		{
			MessageBox("学号为空，请重新输入！");
			return;
		}
		str.Format("SELECT * FROM jsj1 WHERE 学号 = '%s'",dlg.m_delstuno);
		
		CDatabase db1;
		CJsj1 j1(&db1);
		j1.Open(AFX_DB_USE_DEFAULT_TYPE,str);
		
		int count = j1.GetRecordCount();
		CScoreAdd dlg1;
		
		j1.MoveFirst();
		CString value;
		while(!j1.IsEOF())
		{			
			j1.GetFieldValue("学号",j1.m_column2);
			dlg1.m_addstuno=j1.m_column2;
			j1.GetFieldValue("姓名",j1.m_column3);
			dlg1.m_addstuname=j1.m_column3;
			dlg1.m_addpolitic=j1.m_column8;       //(政治,j1.m_column8);
			dlg1.m_addmaths=j1.m_column4;         //("数学",j1.m_column4);
			dlg1.m_addchmistry=j1.m_column6;      //("化学",j1.m_column6);
			dlg1.m_addenglish=j1.m_column7;       //("英语",j1.m_column7);
			dlg1.m_addphycical=j1.m_column5;	  //("物理",j1.m_column5);
			j1.MoveNext();
		}
		dlg1.DoModal();
		UpdateData(false);
	}
	else if(m_comboxclass=="二班")
	{
		CScoreDel dlg;
		dlg.DoModal();
		CString str;
		if(dlg.m_delstuno=="")
		{
			MessageBox("学号为空，请重新输入！");
			return;
		}
		str.Format("SELECT * FROM jsj2 WHERE 学号 = '%s'",dlg.m_delstuno);
		
		CDatabase db2;
		CJsj2 j2(&db2);
		j2.Open(AFX_DB_USE_DEFAULT_TYPE,str);
		
		int count = j2.GetRecordCount();
		CScoreAdd dlg1;
		
		j2.MoveFirst();
		CString value;
		while(!j2.IsEOF())
		{			
			j2.GetFieldValue("学号",j2.m_column2);
			dlg1.m_addstuno=j2.m_column2;
			j2.GetFieldValue("姓名",j2.m_column3);
			dlg1.m_addstuname=j2.m_column3;
			dlg1.m_addpolitic=j2.m_column8;     //("政治",j1.m_column8);
			dlg1.m_addmaths=j2.m_column4;       //("数学",j1.m_column4);
			dlg1.m_addchmistry=j2.m_column6;    //("化学",j1.m_column6);
			dlg1.m_addenglish=j2.m_column7;     //("英语",j1.m_column7);
			dlg1.m_addphycical=j2.m_column5;	//("物理",j1.m_column5);
			j2.MoveNext();
		}
		dlg1.DoModal();
		UpdateData(false);
	}
	else AfxMessageBox("请选择你的班级！");
}

void CPaiming::OnScoreEdit() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_comboxclass=="一班")
	{
		CScoreDel dlg;
		dlg.DoModal();
		if(dlg.m_delstuno=="")
		{
			MessageBox("学号为空，请重新输入！");
			return;
		}
		CString str;
		str.Format("SELECT * FROM jsj1 WHERE 学号 = '%s'",dlg.m_delstuno);
		
		CDatabase db1;
		CJsj1 j1(&db1);
		j1.Open(AFX_DB_USE_DEFAULT_TYPE,str);
		
		int count = j1.GetRecordCount();
		CScoreAdd dlg1;
		
		j1.MoveFirst();
		CString value;
		while(!j1.IsEOF())
		{			
			j1.GetFieldValue("学号",j1.m_column2);
			dlg1.m_addstuno=j1.m_column2;
			j1.GetFieldValue("姓名",j1.m_column3);
			dlg1.m_addstuname=j1.m_column3;
			dlg1.m_addpolitic=j1.m_column8;       //(政治,j1.m_column8);
			dlg1.m_addmaths=j1.m_column4;         //("数学",j1.m_column4);
			dlg1.m_addchmistry=j1.m_column6;      //("化学",j1.m_column6);
			dlg1.m_addenglish=j1.m_column7;       //("英语",j1.m_column7);
			dlg1.m_addphycical=j1.m_column5;	  //("物理",j1.m_column5);
			j1.MoveNext();
		}
		dlg1.DoModal();
		UpdateData(false);
		CString strSQL;
		UpdateData();
		strSQL.Format("update jsj1 set 学号='%s',姓名='%s',数学=%f,物理=%f,化学=%f,英语=%f,政治=%f where 学号='%s'",dlg1.m_addstuno,dlg1.m_addstuname,dlg1.m_addmaths,dlg1.m_addphycical,dlg1.m_addchmistry,dlg1.m_addenglish,dlg1.m_addpolitic,dlg1.m_addstuno);
		
		CDatabase db;
		db.Open(_T("studentsn"));
		db.ExecuteSQL(strSQL) ;
	}
	else if(m_comboxclass=="二班")
	{
		CScoreDel dlg;
		dlg.DoModal();
		CString str;
		if(dlg.m_delstuno=="")
		{
			MessageBox("学号为空，请重新输入！");
			return;
		}
		str.Format("SELECT * FROM jsj2 WHERE 学号 = '%s'",dlg.m_delstuno);
		
		CDatabase db2;
		CJsj2 j2(&db2);
		j2.Open(AFX_DB_USE_DEFAULT_TYPE,str);
		
		int count = j2.GetRecordCount();
		CScoreAdd dlg1;
		
		j2.MoveFirst();
		CString value;
		while(!j2.IsEOF())
		{			
			j2.GetFieldValue("学号",j2.m_column2);
			dlg1.m_addstuno=j2.m_column2;
			j2.GetFieldValue("姓名",j2.m_column3);
			dlg1.m_addstuname=j2.m_column3;
			dlg1.m_addpolitic=j2.m_column8;   //("政治",j2.m_column8);
			dlg1.m_addmaths=j2.m_column4;     //("数学",j2.m_column4);
			dlg1.m_addchmistry=j2.m_column6;   //("化学",j2.m_column6);
			dlg1.m_addenglish=j2.m_column7;    //("英语",j2.m_column7);
			dlg1.m_addphycical=j2.m_column5;	//("物理",j2.m_column5);
			j2.MoveNext();
		}
		dlg1.DoModal();
		UpdateData(false);
		CString strSQL;
		UpdateData();
		strSQL.Format("update jsj1 set 学号='%s',姓名='%s',数学=%f,物理=%f,化学=%f,英语=%f,政治=%f where 学号='%s'",dlg1.m_addstuno,dlg1.m_addstuname,dlg1.m_addmaths,dlg1.m_addphycical,dlg1.m_addchmistry,dlg1.m_addenglish,dlg1.m_addpolitic,dlg1.m_addstuno);
		
		CDatabase db;
		db.Open(_T("studentsn"));
		db.ExecuteSQL(strSQL) ;
	}
	else AfxMessageBox("请选择你的班级！");
}