usermange.cpp

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

// Usermange.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CUsermange dialog


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


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


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

/////////////////////////////////////////////////////////////////////////////
// CUsermange message handlers

BOOL CUsermange::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 CUsermange::RefreshData()
{

	m_adodc.SetRecordSource("select * from 用户表");
	m_adodc.Refresh();
	_variant_t vindex;
	
	vindex=long(0);
	m_datagrid.GetColumns().GetItem(vindex).SetWidth(90);
	vindex=long(1);
	m_datagrid.GetColumns().GetItem(vindex).SetWidth(0);

	vindex=long(2);
	m_datagrid.GetColumns().GetItem(vindex).SetWidth(70);
    

}

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

void CUsermange::OnButton3() 
{
	// TODO: Add your control notification handler code here
	CModyuser dlg;
	dlg.m_name=m_datagrid.GetItem(0);
	dlg.m_mima=m_datagrid.GetItem(1);
	dlg.m_lever=(int)atof(m_datagrid.GetItem(2));
	
    //dlg.m_id11=(int)atof(m_datagrid1.GetItem(4));
	if(dlg.DoModal()==IDOK)
		RefreshData();
}

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

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

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