sells.cpp

一个简易超市系统,有进货,销售.等功能 对学习有C++数据库操作有一定的帮助

// Sells.cpp : implementation file
//

#include "stdafx.h"
#include "PosClient.h"
#include "Sells.h"
#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSells

CSells::CSells()
{
}

CSells::~CSells()
{
}

int  CSells::getId()
{
	return id;
}
void CSells::iId(int i)
{
	id=i;
}

float CSells::getDiscount()
{
	return sellDISCOUNT;
}
void CSells::insDiscount(float count)
{
	sellDISCOUNT=count;
}

CString CSells::getID()
{
	return sellID;
}
void CSells::insId(CString ID)
{
	sellID=ID;
}

CString CSells::getN()
{
	return sellN;
}
void CSells::insN(CString num)
{
	sellN=num;
}

int CSells::getNum()
{
	return sellNUM;
}
void CSells::insNum(int num)
{
	sellNUM=num;
}

void CSells::GetData(CString n)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM sells WHERE id=" + n;
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CSells();
	else
	{
		id=atoi(n);
		sellN = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("sellN");
		sellID = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("goodsID");
		sellNUM = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("sellNUM"));
		sellDISCOUNT = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("sellDISCOUNT"));
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void CSells::sql_insert()
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	CString a,b,c;
	a.Format("%d", id);
	b.Format("%d", sellNUM);
	c.Format("%f", sellDISCOUNT);
	_bstr_t vSQL;
	vSQL = "INSERT INTO sells VALUES(" + a + ",'" + sellID + "'," + b + "," 
		+ c + ",'" + sellN + "')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void CSells::sql_delete(CString n)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM sells WHERE id=" + n;
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

int CSells::LastID()
{
	int i,j;
	i=0;
	j=0;
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL = "SELECT * FROM sells ORDER BY id";
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	while(!m_pRecordset->adoEOF)
	{
		j=atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("id"));
		if(j>i) i=j;
		m_pRecordset->MoveNext();
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
	return i;
}

void CSells::sqldel(CString N)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM sells WHERE sellN='" + N +"'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}