Category

Development Platform
Home > SourceCode/Document > Windows Develop > ADO-ODBC > View Code
deletebumen.cpp
Package: salarysystem.rar　[view]
Upload User: xz12345
Upload Date: 2007-09-12
Package Size: 7437k
Code Size: 2k
Category:

ADO-ODBC

Development Platform:

Visual C++

deletebumen.cpp：Code Content
  1. // deletebumen.cpp : implementation file
  2. //
  4. #include "stdafx.h"
  5. #include "工资.h"
  6. #include "deletebumen.h"
  7. #include "bumenxinxi.h"
  9. #ifdef _DEBUG
  10. #define new DEBUG_NEW
  11. #undef THIS_FILE
  12. static char THIS_FILE[] = __FILE__;
  13. #endif
  15. /////////////////////////////////////////////////////////////////////////////
  16. // deletebumen dialog
  19. deletebumen::deletebumen(CWnd* pParent /*=NULL*/)
  20. : CDialog(deletebumen::IDD, pParent)
  21. {
  22. //{{AFX_DATA_INIT(deletebumen)
  23. m_bmid = _T("");
  24. //}}AFX_DATA_INIT
  25. }
  28. void deletebumen::DoDataExchange(CDataExchange* pDX)
  29. {
  30. CDialog::DoDataExchange(pDX);
  31. //{{AFX_DATA_MAP(deletebumen)
  32. DDX_Text(pDX, IDC_EDIT1, m_bmid);
  33. //}}AFX_DATA_MAP
  34. }
  37. BEGIN_MESSAGE_MAP(deletebumen, CDialog)
  38. //{{AFX_MSG_MAP(deletebumen)
  39. ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
  40. ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
  41. //}}AFX_MSG_MAP
  42. END_MESSAGE_MAP()
  44. /////////////////////////////////////////////////////////////////////////////
  45. // deletebumen message handlers
  47. void deletebumen::OnButton1() 
  48. { 
  49.  UpdateData(TRUE);
  50.     bumenxinxi box;
  51.     box.bmid=m_bmid;
  53.  ADOConn m_AdoConn;
  54.  _bstr_t vSQL;
  55.      vSQL="select empid from  yuangongxinxi where yuangongxinxi.depid='"+m_bmid+"'";  
  56.  m_AdoConn.OnInitADOConn();
  58.  _RecordsetPtr m_pRecordset;
  59. m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
  60. if (m_pRecordset->adoEOF)
  61. {box.sql_delete();
  62. CDialog::OnOK();}
  63. else
  64.        MessageBox("sorry,you must delete the empolyee that blong to this department first!");     
  66. //执行INSERT语句
  67.  m_AdoConn.ExecuteSQL(vSQL);
  70. //断开与数据库的连接
  71. // m_AdoConn.ExitConnect();
  72.    
  73.    
  74. // TODO: Add your control notification handler code here
  76. }
  78. void deletebumen::OnButton2() 
  79. {
  80. CDialog::OnCancel();
  81. // TODO: Add your control notification handler code here
  83. }