datamanage.cpp

小型自选商场商品管理系统 要求：能对小型自选商场的商品进货、销售、库存等环节进行管理。主要有： 1）能记录每一笔进货

// DataManage.cpp: implementation of the CDataManage class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ShopManage.h"
#include "DataManage.h"
extern  _RecordsetPtr Record1;
extern	_ConnectionPtr DataConn;
extern	_RecordsetPtr DataRecord;
extern	_CommandPtr Com;
#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif
/*extern _ConnectionPtr DataConn;
extern _RecordsetPtr DataRecord;
extern _CommandPtr Com;*/
//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CDataManage::CDataManage()
{
	DataConn.CreateInstance(_uuidof(Connection));
	DataRecord.CreateInstance(_uuidof(Recordset));
	Record1.CreateInstance(_uuidof(Recordset));
}

CDataManage::~CDataManage()
{
	//DataConn->Release();
	//DataRecord->Release();
	//Record1->Release();
}

_ConnectionPtr CDataManage::GetConn()
{
	return DataConn;
}

_RecordsetPtr CDataManage::GetRecordset()
{
	return (DataRecord);
}

bool CDataManage::ConnectDataBase()
{
	try
	{		
		::CoInitialize(NULL);
		
		CString strAdoConn =_T("Driver={SQL Server};server=320-7C48350C9E6;database=DB");
		DataConn.CreateInstance(_uuidof(Connection));
		DataConn->ConnectionString = (_bstr_t)strAdoConn;
		DataConn->Open("","","",NULL);
	
		DataRecord.CreateInstance(_uuidof(Recordset));
		Com.CreateInstance("ADODB.Command");	
		Record1.CreateInstance(_uuidof(Recordset));
		return true;
	}
	catch(_com_error)
	{		
		MessageBox(0,"请检查系统配置信息", "数据库连接失败",MB_OK);		
		return false;
	}
	catch(...)
	{	
		AfxMessageBox("SYS Error");
		return false;
	}
}

bool CDataManage::ExecSQL(CString sql)
{
	_variant_t RecordsAffected;
	_bstr_t sqltext = sql;
	try
	{
		DataConn->Execute(sqltext,&RecordsAffected,adCmdText);
	}
	catch(_com_error& e)
	{
		AfxMessageBox(e.ErrorMessage(),0,0);
		return false;
	}
	return true;
}