ele_dialog.cpp

来自「对医院的药品进行管理」· C++ 代码 · 共 71 行

// ele_dialog.cpp : implementation file
//

#include "stdafx.h"
#include "医药管理系统.h"
#include "ele_dialog.h"

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

/////////////////////////////////////////////////////////////////////////////
// ele_dialog dialog


ele_dialog::ele_dialog(CWnd* pParent /*=NULL*/)
	: CDialog(ele_dialog::IDD, pParent)
{
	//{{AFX_DATA_INIT(ele_dialog)
	m_JoberNum = _T("");
	//}}AFX_DATA_INIT
}


void ele_dialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(ele_dialog)
	DDX_Text(pDX, IDC_EDIT1, m_JoberNum);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// ele_dialog message handlers

void ele_dialog::OnOK() 
{
	// TODO: Add extra validation here
CDialog::OnOK();
::CoInitialize(NULL); 
_bstr_t bstrSQL;
 UpdateData(true);

	CString strname;
	try
	{
		strname.Format("Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=YPGL;Initial Catalog=YPGL");
		m_pConnection.CreateInstance("ADODB.Connection");
		_bstr_t strConnect=strname;
		m_pConnection->Open(strConnect,"","",adModeUnknown);
	}
	catch(_com_error e)
	{
		AfxMessageBox(e.Description());
	}
	bstrSQL="delete from Jober_info where 工作员代号='"+m_JoberNum+"'";
    m_pRecordset.CreateInstance(__uuidof(Recordset));
	m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	AfxMessageBox("修改成功!");
	UpdateData(false);

}