【VC开源代码栏目提醒】:网学会员VC开源代码为您提供Examinfo_submarkdlg.cpp参考,解决您在Examinfo_submarkdlg.cpp学习中工作中的难题,参考学习。
// 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 ex