editware.cpp

一个空调安装工工资计算

// EditWare.cpp : implementation file
//

#include "stdafx.h"
#include "工资管理系统.h"
#include "EditWare.h"
#define  WM_REFRESH

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CEditWare dialog


CEditWare::CEditWare(CWnd* pParent /*=NULL*/)
	: CDialog(CEditWare::IDD, pParent)
{
	//{{AFX_DATA_INIT(CEditWare)
	m_beizhu = _T("");
	m_name = _T("");
	m_tele = _T("");
	m_sex = -1;
	//}}AFX_DATA_INIT
}


void CEditWare::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEditWare)
	DDX_Text(pDX, IDC_EDIT_BEIZHU, m_beizhu);
	DDX_Text(pDX, IDC_EDIT_NAME, m_name);
	DDX_Text(pDX, IDC_EDIT_TELE, m_tele);
	DDX_Radio(pDX, IDC_RADIO_SEX, m_sex);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CEditWare, CDialog)
	//{{AFX_MSG_MAP(CEditWare)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CEditWare message handlers


/***********保存按钮***********/
void CEditWare::OnOK() 
{

  CString s,sSQL,sId,sName,sSex,sTele,sBeizhu;
  sId.Format("%d",GetRecordsetCount()+1);
  rst->MoveLast();
  
  UpdateData(TRUE);
  sName=m_name;
  if(m_sex==0)
	  sSex="男";
  else
	  sSex="女";
  sTele=m_tele;
  sBeizhu=m_beizhu;
  if(Enable)//Enable为bool型变量，表明当前操作：TRUE为添加数据,FALSE为修改数据
  {
  //此处为数据插入,注意表中编号不会自动产生,此处须将编号一同写入数据表
  sSQL.Format("INSERT INTO 员工信息表 VALUES (%s,'%s','%s','%s','%s')",sId,sName,sSex,sTele,sBeizhu);
  rst=cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
  AfxMessageBox("恭喜您！新数据已经成功添加！");
  }
  else
  {
    sSQL.Format("UPDATE 员工信息表 SET 姓名='%s',性别='%s',联系电话=%s,备注='%s' WHERE 编号=%s",sName,sSex,sTele,sBeizhu,m_ID);
	rst=cnn->Execute((_bstr_t)sSQL,NULL,adCmdText);
	AfxMessageBox("恭喜您！数据已被成功修改！");
  }
  CDialog::OnOK();
}


/*************对话框初始化***************/
BOOL CEditWare::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	CString str;
	m_StatusBar.EnableAutomation();
	m_StatusBar.Create(WS_CHILD|WS_VISIBLE,CRect(0,0,0,0),this,ID_STATUSBAR);
	int width[]={145,320};
	m_StatusBar.SetParts(2, &width[0]);
	m_StatusBar.SetText(str,0,0);
	m_StatusBar.SetText("程序设计：吴晓宁",0,0);
	m_StatusBar.SetText("欢迎使用工资管理系统 V1.2版",0,1);
	
    rst.CreateInstance(__uuidof(Recordset));
    rst=cnn->Execute("员工信息表",NULL,adCmdTable);

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

int CEditWare::GetRecordsetCount()
{
   int nCount = 0;
   try{
       rst->MoveFirst();
   }
   catch(...)
   {
	   return 0;
   }
   if(rst->_EOF)
	   return 0;
   while(!rst->_EOF)
   {
	   rst->MoveNext();
	   nCount=nCount+1;
   }
   rst->MoveFirst();
   return nCount;
}