kaoqing.cpp

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

// Kaoqing.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CKaoqing dialog


CKaoqing::CKaoqing(CWnd* pParent /*=NULL*/)
	: CDialog(CKaoqing::IDD, pParent)
{
	//{{AFX_DATA_INIT(CKaoqing)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CKaoqing::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CKaoqing)
	DDX_Control(pDX, IDC_ADODC1, m_adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrit);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CKaoqing, CDialog)
	//{{AFX_MSG_MAP(CKaoqing)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKaoqing message handlers

void CKaoqing::OnButton1() 
{
	// TODO: Add your control notification handler code here
	CAddkaoqing dlg;
	if(dlg.DoModal()==IDOK)
		RefreshData();
}

void CKaoqing::RefreshData()
{

	m_adodc.SetRecordSource("select * from 考勤表");
	m_adodc.Refresh();
	_variant_t vindex;
	
	vindex=long(0);
	m_datagrit.GetColumns().GetItem(vindex).SetWidth(60);
	vindex=long(1);
	m_datagrit.GetColumns().GetItem(vindex).SetWidth(50);
    vindex=long(2);
	m_datagrit.GetColumns().GetItem(vindex).SetWidth(50);
	vindex=long(3);
	m_datagrit.GetColumns().GetItem(vindex).SetWidth(80);
    vindex=long(4);
	m_datagrit.GetColumns().GetItem(vindex).SetWidth(60);
	vindex=long(5);
	m_datagrit.GetColumns().GetItem(vindex).SetWidth(0);

}

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

void CKaoqing::OnButton2() 
{
	// TODO: Add your control notification handler code here
	CModykaoqing dlg;
	
	dlg.m_name=m_datagrit.GetItem(0);
	dlg.m_month=(int)atof(m_datagrit.GetItem(1));
	dlg.m_chidao=(int)atof(m_datagrit.GetItem(2));
	dlg.m_zaotui=(int)atof(m_datagrit.GetItem(3));
	dlg.m_kanggong=(int)atof(m_datagrit.GetItem(4));
    dlg.m_id=(int)atof(m_datagrit.GetItem(5));

	
	
	if(dlg.DoModal()==IDOK)
		RefreshData();
}

void CKaoqing::OnButton3() 
{
	// TODO: Add your control notification handler code here
	ADOConn m_Adoconn;
	m_Adoconn.OnInitADOConn();
	CString sql;
	CString nname;
	int month;
	nname=m_datagrit.GetItem(0);
	month=(int)atof(m_datagrit.GetItem(1));
    sql.Format("delete from 考勤表 where 姓名=\'%s\' and 月份=%d",nname,month);
	_bstr_t vsql;
	vsql=(_bstr_t)sql;
	
	
	m_Adoconn.ExecuteSQL(vsql);
	m_Adoconn.ExitConnect();
	RefreshData();
}

void CKaoqing::OnButton4() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();
}