dep.cpp

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

// Dep.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CDep dialog


CDep::CDep(CWnd* pParent /*=NULL*/)
	: CDialog(CDep::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDep)
	//}}AFX_DATA_INIT
}


void CDep::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDep)
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid2);
	DDX_Control(pDX, IDC_ADODC1, m_adodc2);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CDep message handlers

void CDep::RefreshData()
{

	m_adodc2.SetRecordSource("select * from 部门表");
	m_adodc2.Refresh();
}

void CDep::OnButton3() 
{
	// TODO: Add your control notification handler code here
	CAdddep dlg;
	if(dlg.DoModal()==IDOK)
		RefreshData();
	else
		return;
}

void CDep::OnButton1() 
{
	// TODO: Add your control notification handler code here
	CModydep dlg;
	
	dlg.m_oldname=m_datagrid2.GetItem(1);
	dlg.m_bumenhao=(int)atof(m_datagrid2.GetItem(0));
	if(dlg.DoModal()==IDOK)
		RefreshData();
	else 
		return;

}

void CDep::OnButton2() 
{
	// TODO: Add your control notification handler code here
	ADOConn m_Adoconn;
	m_Adoconn.OnInitADOConn();
	CString sql;
	CString nname;
	nname=m_datagrid2.GetItem(1);

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