twel_dialog.cpp

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

// twel_dialog.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// twel_dialog dialog


twel_dialog::twel_dialog(CWnd* pParent /*=NULL*/)
	: CDialog(twel_dialog::IDD, pParent)
{
	//{{AFX_DATA_INIT(twel_dialog)
	m_JoberNum = _T("");
	m_JoberName = _T("");
	m_JoberSex = _T("");
	m_JoberAge = _T("");
	m_JoberClass = _T("");
	m_JoberTel = _T("");
	m_JoberWorkYear = _T("");
	//}}AFX_DATA_INIT
}


void twel_dialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(twel_dialog)
	DDX_Text(pDX, IDC_EDIT1, m_JoberNum);
	DDX_Text(pDX, IDC_EDIT2, m_JoberName);
	DDX_Text(pDX, IDC_EDIT3, m_JoberSex);
	DDX_Text(pDX, IDC_EDIT4, m_JoberAge);
	DDX_Text(pDX, IDC_EDIT6, m_JoberClass);
	DDX_Text(pDX, IDC_EDIT7, m_JoberTel);
	DDX_Text(pDX, IDC_EDIT5, m_JoberWorkYear);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// twel_dialog message handlers

void twel_dialog::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}

void twel_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="insert into  Jober_info values ('"+m_JoberNum+"','"+m_JoberName+"','"+m_JoberSex+"','"+m_JoberAge+"','"+m_JoberWorkYear+"','"+m_JoberClass+"','"+m_JoberTel+"')";
    m_pRecordset.CreateInstance(__uuidof(Recordset));
	m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	AfxMessageBox("增加成功!");
	UpdateData(false);

}