empmody.cpp

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

// EmpMody.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CEmpMody dialog


CEmpMody::CEmpMody(CWnd* pParent /*=NULL*/)
	: CDialog(CEmpMody::IDD, pParent)
{
	//{{AFX_DATA_INIT(CEmpMody)
	m_name11 = _T("");
	m_sex11 = _T("");
	m_address11 = _T("");
	m_tel11 = _T("");
	m_id11 = 0;
	m_bumenhao = 0;
	//}}AFX_DATA_INIT
}


void CEmpMody::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEmpMody)
	DDX_Text(pDX, IDC_EDIT1, m_name11);
	DDX_Text(pDX, IDC_EDIT2, m_sex11);
	DDX_Text(pDX, IDC_EDIT3, m_address11);
	DDX_Text(pDX, IDC_EDIT4, m_tel11);
	DDX_Text(pDX, IDC_EDIT5, m_id11);
	DDX_Text(pDX, IDC_EDIT6, m_bumenhao);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CEmpMody, CDialog)
	//{{AFX_MSG_MAP(CEmpMody)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CEmpMody message handlers

void CEmpMody::OnButton1() 
{
	// TODO: Add your control notification handler code here
	ADOConn m_Adoconn;
	m_Adoconn.OnInitADOConn();

	
    CString sql,sql1,sql2,sql3,sql4,sql5,str1,str2;
    _bstr_t vsql1,vsql2,vsql3,vsql4,vsql5,bSQL,bSQL2;
	int i;
	_variant_t var;
	_RecordsetPtr pRecord,pRecord2;
     m_name11.TrimLeft();
	m_name11.TrimRight();
		sql.Format("select * from 考勤表 where 姓名='%s'",m_name11);
		 bSQL=(_bstr_t)sql;
		pRecord=m_Adoconn.GetRecordSet(bSQL);
        sql1.Format("select * from 工资表 where 姓名='%s'",m_name11);
         bSQL2=(_bstr_t)sql1;
		pRecord2=m_Adoconn.GetRecordSet(bSQL2);
	//////////////////////
	UpdateData(true);
    sql4.Format("insert into 员工表(姓名,性别,地址,联系电话,部门号) values (\'%s'\, \'%s'\, \'%s'\, \'%s'\,%d)",m_name11,m_sex11,m_address11,m_tel11,m_bumenhao);
	vsql4=(_bstr_t)sql4;
    m_Adoconn.ExecuteSQL(vsql4);
	m_name11.TrimLeft();
	m_name11.TrimRight();
	/////////////////////////////////////////
	if(!pRecord->adoEOF)
	{  pRecord->MoveFirst();
	   while(!pRecord->adoEOF)
	   {
	  pRecord->get_Collect(_variant_t("ID"),(_variant_t*)(&var));
		 if(var.vt!=VT_NULL)
		 {
			i=var.iVal;
			
		 }
		 sql2.Format("update 考勤表 set 姓名='%s'\
						where ID=%d", \
			 m_name11,i
			);
	  vsql2=(_bstr_t)sql2;
	  m_Adoconn.ExecuteSQL(vsql2);
 	  pRecord->MoveNext();
	   }
	}
	if(!pRecord2->adoEOF)
	{  pRecord2->MoveFirst();
	   while(!pRecord2->adoEOF)
	   {
	  pRecord2->get_Collect(_variant_t("ID"),(_variant_t*)(&var));
	   
		 if(var.vt!=VT_NULL)
		 {
			i=var.iVal;
			
		 }
		 sql2.Format("update 工资表 set 姓名='%s'\
						where ID=%d", \
			 m_name11,i
			);
	  vsql2=(_bstr_t)sql2;
	  m_Adoconn.ExecuteSQL(vsql2);
 	  pRecord2->MoveNext();
	   }
	}
	m_Adoconn.ExitConnect();
	CDialog::OnOK();
}

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