modykaoqing.cpp

来自「员工管理系统,基本的数据库操作,数据库类的设计,基本的查询等」· C++ 代码 · 共 90 行

// Modykaoqing.cpp : implementation file
//

#include "stdafx.h"
#include "数据库.h"
#include "Modykaoqing.h"
#include "ADOConn.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CModykaoqing dialog


CModykaoqing::CModykaoqing(CWnd* pParent /*=NULL*/)
	: CDialog(CModykaoqing::IDD, pParent)
{
	//{{AFX_DATA_INIT(CModykaoqing)
	m_name = _T("");
	m_chidao = 0;
	m_zaotui = 0;
	m_kanggong = 0;
	m_id = 0;
	m_month = 0;
	//}}AFX_DATA_INIT
}


void CModykaoqing::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CModykaoqing)
	DDX_Text(pDX, IDC_EDIT1, m_name);
	DDX_Text(pDX, IDC_EDIT2, m_chidao);
	DDX_Text(pDX, IDC_EDIT3, m_zaotui);
	DDX_Text(pDX, IDC_EDIT4, m_kanggong);
	DDX_Text(pDX, IDC_EDIT5, m_id);
	DDX_Text(pDX, IDC_EDIT6, m_month);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CModykaoqing message handlers

void CModykaoqing::OnOK() 
{
	// TODO: Add extra validation here
	ADOConn m_Adoconn;
	m_Adoconn.OnInitADOConn();

	
    CString sql;
	
	UpdateData(true);
	sql.Format("update 考勤表 set 姓名='%s', \
			月份=%d, \
			迟到次数=%d, \
			早退次数=%d, \
			旷工天数=%d \
			where ID=%d", \
			m_name,m_month,m_chidao,m_zaotui,m_kanggong,m_id
			);
	
	_bstr_t vsql;
	vsql=(_bstr_t)sql;
	
	m_Adoconn.ExecuteSQL(vsql);
	m_Adoconn.ExitConnect();
	CDialog::OnOK();
}

BOOL CModykaoqing::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	UpdateData(false);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}