checkeditdlg.cpp

C++应用编程20例,各种小程序原代码都有

// CheckEditDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Classsystem.h"
#include "CheckEditDlg.h"
#include "Grade.h"
#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCheckEditDlg dialog


CCheckEditDlg::CCheckEditDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCheckEditDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCheckEditDlg)
	m_xuehao = _T("");
	m_name = _T("");
	m_grade = 0;
	m_course = _T("");
	//}}AFX_DATA_INIT
}


void CCheckEditDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCheckEditDlg)
	DDX_Text(pDX, IDC_ID_EDIT, m_xuehao);
	DDV_MaxChars(pDX, m_xuehao, 6);
	DDX_Text(pDX, IDC_NAME_EDIT, m_name);
	DDV_MaxChars(pDX, m_name, 8);
	DDX_Text(pDX, IDC_GRADE_EDIT, m_grade);
	DDX_Text(pDX, IDC_COURSE_EDIT, m_course);
	DDV_MaxChars(pDX, m_course, 3);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCheckEditDlg, CDialog)
	//{{AFX_MSG_MAP(CCheckEditDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCheckEditDlg message handlers

void CCheckEditDlg::OnOK() 
{
	// TODO: Add extra validation here
	CGrade emp;
	UpdateData(true);
	if(m_xuehao=="")
	{
		MessageBox("请你输入学生学号");
		return;
	}
	if(m_name=="")
	{
		MessageBox("请你输入学生姓名");
		return;
	}
	if(m_course!="101" && m_course!="102" && m_course!="206" && m_course!="208" && m_course!="209"
		&& m_course!="210" && m_course!="212" && m_course!="301" && m_course!="302")
	{
		MessageBox("没有这门课程！");
		return;
	}
	if(m_grade<0 || m_grade>100)
	{
		MessageBox("请你输入成绩有误！0~100");
		return;
	}
	if(orif==1)
	{

	//m_sex.GetLBText(m_sex.GetCurSel(),strsex);
	emp.setxuehao(m_xuehao);
	emp.setcourse(m_course);
	emp.setgrade(m_grade);
	//CString xname=(m_name);
	if(HaveName(m_xuehao,m_name)==1)
	{
		if(havered(m_xuehao,m_course)==1)
		{
			MessageBox("该学生的此门课已有纪录！");
			return;
		}
		else
			emp.g_insert();
	}
	else
	{
		MessageBox("没有此学生！");
		return;
	}
	}
	else
	{
		emp.setxuehao(m_xuehao);
		emp.setcourse(m_course);
		emp.setgrade(m_grade);
		//MessageBox("haha");
		emp.g_update(m_xuehao,m_course);

	}
	//	
	CDialog::OnOK();
}
int CCheckEditDlg::HaveName(CString cxuehao,CString cname)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "select * from xs where 学号='" + cxuehao + "' and 姓名='" + cname + "'" ;
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
int CCheckEditDlg::havered(CString cxuehao,CString ccourse)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "select * from xs_kc where 学号='" + cxuehao + "' and 课程号='" + ccourse + "'" ;
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

BOOL CCheckEditDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//orif=0;
	if(orif==0)
	{
	GetDlgItem(IDC_ID_EDIT)->EnableWindow(FALSE);
	GetDlgItem(IDC_NAME_EDIT)->EnableWindow(FALSE);
	GetDlgItem(IDC_COURSE_EDIT)->EnableWindow(FALSE);
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}