thir_dialog.cpp

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

// thir_dialog.cpp : implementation file
//

#include "stdafx.h"
#include "医药管理系统.h"
#include "thir_dialog.h"
//#include "ten_dialog.h"

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

/////////////////////////////////////////////////////////////////////////////
// thir_dialog dialog


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


void thir_dialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(thir_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_EDIT5, m_JoberWorkTime);
	DDX_Text(pDX, IDC_EDIT6, m_JoberClass);
	DDX_Text(pDX, IDC_EDIT7, m_JoberTel);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(thir_dialog, CDialog)
	//{{AFX_MSG_MAP(thir_dialog)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// thir_dialog message handlers

void thir_dialog::OnButton1() 
{
	// TODO: Add your control notification handler code here
::CoInitialize(NULL); 
_bstr_t bstrSQL;
 UpdateData(true);
 //ten_dialog dlg;
// for(int i=1;i<8;i++)
//	 dlg.grm_Grid.DeleteColumn(i);
 //  m_Grid.DeleteAllItems();

	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());
	}
	//m_JoberNum+"','"+m_JoberName+"','"+m_JoberSex+"','"+m_JoberAge+"','"+m_JoberWorkYear+"','"+m_JoberClass+"','"+m_JoberTel
	bstrSQL="update Jober_info set 工作员姓名='"+m_JoberName+"',工作员性别='"+m_JoberSex+"',工作员年龄='"+m_JoberAge+"',从何年开始工作='"+m_JoberWorkTime+"',工作类型='"+m_JoberClass+"',联系方式='"+m_JoberTel+"'where 工作员代号='"+m_JoberNum+"'";
    m_pRecordset.CreateInstance(__uuidof(Recordset));
	m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	AfxMessageBox("修改成功!");
	UpdateData(false);
}

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