employees.cpp

员工管理系统,基本的数据库操作,数据库类的设计,基本的查询等

// Employees.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CEmployees dialog


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


void CEmployees::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEmployees)
	DDX_Control(pDX, IDC_ADODC1, m_adodc1);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CEmployees, CDialog)
	//{{AFX_MSG_MAP(CEmployees)
	ON_BN_CLICKED(IDC_ADD1, OnAdd1)
	ON_BN_CLICKED(IDC_MODY1, OnMody1)
	ON_BN_CLICKED(IDC_DEL3, OnDel3)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CEmployees message handlers

void CEmployees::OnAdd1() 
{
	// TODO: Add your control notification handler code here
	CEmpAdd dlg;
	if(dlg.DoModal()==IDOK)
		RefreshData();
}

void CEmployees::RefreshData()
{
	m_adodc1.SetRecordSource("select * from 员工表");
	m_adodc1.Refresh();
	_variant_t vindex;
	vindex=long(0);
	m_datagrid1.GetColumns().GetItem(vindex).SetWidth(60);
	vindex=long(1);
	m_datagrid1.GetColumns().GetItem(vindex).SetWidth(50);

	vindex=long(2);
	m_datagrid1.GetColumns().GetItem(vindex).SetWidth(80);
    vindex=long(3);
	m_datagrid1.GetColumns().GetItem(vindex).SetWidth(60);
	vindex=long(4);
	m_datagrid1.GetColumns().GetItem(vindex).SetWidth(60);
	vindex=long(5);
	m_datagrid1.GetColumns().GetItem(vindex).SetWidth(0);

}

BOOL CEmployees::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 CEmployees::OnMody1() 
{
	// TODO: Add your control notification handler code here
	CEmpMody dlg;
	ADOConn m_Adoconn;
	m_Adoconn.OnInitADOConn();
	dlg.m_name11=m_datagrid1.GetItem(0);
	dlg.m_sex11=m_datagrid1.GetItem(1);
	dlg.m_address11=m_datagrid1.GetItem(2);
	dlg.m_tel11=m_datagrid1.GetItem(3);
    dlg.m_id11=(int)atof(m_datagrid1.GetItem(5));
    dlg.m_bumenhao=(int)atof(m_datagrid1.GetItem(4));
    CString str,sql;
	str=dlg.m_name11;
	
	UpdateData(false);
	if(dlg.DoModal()==IDOK)
	{
       sql.Format("delete from 员工表 where 姓名=\'%s\'",str);
	   _bstr_t vsql;
	   vsql=(_bstr_t)sql;
	   m_Adoconn.ExecuteSQL(vsql);
		RefreshData();
	}

}

void CEmployees::OnDel3() 
{
	// TODO: Add your control notification handler code here
	ADOConn m_Adoconn;
	m_Adoconn.OnInitADOConn();
	CString sql,sql2,sql3;
	CString nname;
	nname=m_datagrid1.GetItem(0);

	sql2.Format("delete from 考勤表 where 姓名=\'%s\'",nname);
	_bstr_t vsql2;
	vsql2=(_bstr_t)sql2;
    m_Adoconn.ExecuteSQL(vsql2);

	sql3.Format("delete from 工资表 where 姓名=\'%s\'",nname);
	_bstr_t vsql3;
	vsql3=(_bstr_t)sql3;
    m_Adoconn.ExecuteSQL(vsql3);

    sql.Format("delete from 员工表 where 姓名=\'%s\'",nname);
	_bstr_t vsql;
	vsql=(_bstr_t)sql;
	
	
	
	m_Adoconn.ExecuteSQL(vsql);
	m_Adoconn.ExitConnect();
	RefreshData();
}

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