examinfo_submarkdlg.cpp

用VC++做的学生管理系统

// Examinfo_submarkdlg.cpp : implementation file
//

#include "stdafx.h"
#include "mystudentsys.h"
#include "Examinfo_submarkdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CExaminfo_submarkdlg dialog


CExaminfo_submarkdlg::CExaminfo_submarkdlg(CWnd* pParent /*=NULL*/)
	: CDialog(CExaminfo_submarkdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CExaminfo_submarkdlg)
	m_studentid = _T("");
	m_submark = 0.0f;
	m_examsubject = _T("");
	m_examkind = _T("");
	m_examdate = 0;
	//}}AFX_DATA_INIT
}


void CExaminfo_submarkdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CExaminfo_submarkdlg)
	DDX_Text(pDX, IDC_sutentid, m_studentid);
	DDX_Text(pDX, IDC_submarks, m_submark);
	DDX_Text(pDX, IDC_examsubject, m_examsubject);
	DDX_Text(pDX, IDC_examkind, m_examkind);
	DDX_DateTimeCtrl(pDX, IDC_examdate_picker, m_examdate);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CExaminfo_submarkdlg, CDialog)
	//{{AFX_MSG_MAP(CExaminfo_submarkdlg)
	ON_BN_CLICKED(IDC_inputsave_marks, Oninputsavemarks)
	ON_WM_CLOSE()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CExaminfo_submarkdlg message handlers

void CExaminfo_submarkdlg::Oninputsavemarks() 
{

	UpdateData(true);//读入输入的资料
	if(m_studentid.IsEmpty()||m_examsubject.IsEmpty()||m_examkind.IsEmpty())
	{//如果名字是空就提示错误
		AfxMessageBox("请输入相应的数据!");
		return;
	}

	CString sqlStr_findid;
	sqlStr_findid="SELECT * FROM tb_studentinfo WHERE tb_studentinfo.studentid='";////在tb_studentinfo数据表里面查询
	sqlStr_findid+=m_studentid;
	sqlStr_findid+="'";
	if(myfindset_id.IsOpen())
	{
	myfindset_id.Close();
	}
	if(myfindset_id.IsOpen())
	{
	myfindset_id.Close();
	}    	
	if(!myfindset_id.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr_findid))
	{
		AfxMessageBox("tb_studentinfo表打开失败!");
	}
	if(myfindset_id.GetRecordCount()==0)
	{
		AfxMessageBox("没有此学生,请确认学号后再输入!");
    	
		if(myfindset_id.IsOpen())
		{
		myfindset_id.Close();
		}
		return;
	}

	CString sql;
	CString year,month,day;

	year = m_examdate.Format("%Y");
	month = m_examdate.Format("%m");
	day = m_examdate.Format("%d");
	sql.Format("SELECT * FROM tb_examinfo_sub WHERE tb_examinfo_sub.studentid = '%s' and code = '%s' and kind = '%s' and  year(examdate) = '%s' and month(examdate) = '%s' and day(examdate) = '%s'",m_studentid,m_examsubject,m_examkind,year,month,day);

	if(myexamsubmarkset_findsame.IsOpen())
	{
	    myexamsubmarkset_findsame.Close();
	}

	if(!myexamsubmarkset_findsame.Open(AFX_DB_USE_DEFAULT_TYPE,sql))
	{
		AfxMessageBox("tb_examinfo_sub表打开失败!");
	}
	if(myexamsubmarkset_findsame.GetRecordCount()!=0)
	{
		AfxMessageBox("已经有此记录,不能重复输入!");
    	
		if(myexamsubmarkset_findsame.IsOpen())
		{
	    	myexamsubmarkset_findsame.Close();
		}
		return;
	}

//如果是添加记录，就调用添加记录的函数处理
		myexamsubmarkset.AddNew();


//	else 
//	{//否则调用编辑函数处理
//		bkSet.Edit();
//	}

//	CTime tDate;
//	m_examdate.GetCurrentTime(tDate);
	myexamsubmarkset.m_studentid=m_studentid;//对应变量更新
	myexamsubmarkset.m_code=m_examsubject;
    myexamsubmarkset.m_grade=m_submark;
    myexamsubmarkset.m_kind=m_examkind;
    
	myexamsubmarkset.m_examdate=m_examdate;

	myexamsubmarkset.Update();
	myexamsubmarkset.Requery();

	DisplayRecord();//更新显示
}
bool CExaminfo_submarkdlg::DisplayRecord()
{
	if(myexamsubmarkset.IsEOF()&&myexamsubmarkset.IsBOF())//判断是否移动到了开头和结尾
	{
		m_studentid ="";
	    m_submark = 0.0f;
	    m_examsubject ="";
	    m_examkind="";
	   		
	}
	else
	{
		if(myexamsubmarkset.IsBOF())//移动到了开头,就向后移动
		{
			myexamsubmarkset.MoveNext();
		}
		else//否则前移
		{
			if(myexamsubmarkset.IsEOF())
			{
				myexamsubmarkset.MovePrev();
			}
		}
	}
	
	
   
    GetCurrentTime(m_examdate);
	m_studentid ="";
	m_submark = 0.0f;
	m_examsubject ="";
	m_examkind="";
    
	UpdateData(false);//显示更新
	return true;

}

BOOL CExaminfo_submarkdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CString sqlStr;
	sqlStr="SELECT * FROM tb_examinfo_sub";//在tb_examinfo_sub数据表里面查询
	if(!myexamsubmarkset.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))//打开数据表
	{
		AfxMessageBox("tb_examinfo_sub表打开失败!");
	}
	m_examdate = CTime::GetCurrentTime();
	UpdateData(false);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CExaminfo_submarkdlg::OnClose() 
{
	// TODO: Add your message handler code here and/or call default
	
	if(myexamsubmarkset.IsOpen())
	{
		myexamsubmarkset.Close();
	}

	CDialog::OnClose();
}

void CExaminfo_submarkdlg::OnOK()
{

}