sellinfo.cpp

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

// Sellinfo.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CSellinfo

CSellinfo::CSellinfo()
{
}

CSellinfo::~CSellinfo()
{
}

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

float CSellinfo::getAlldiscount()
{
	return sellALLDISCOUNT;
}
void CSellinfo::insAlldiscount(float count)
{
	sellALLDISCOUNT=count;
}

float CSellinfo::getAllmoney()
{
	return sellALLMONEY;
}
void CSellinfo::insAllmoney(float money)
{
	sellALLMONEY=money;
}

CString CSellinfo::getDate()
{
	return sellDATE;
}
void CSellinfo::insDate(CString date)
{
	sellDATE=date;
}

float CSellinfo::getRecive()
{
	return sellRECIVE;
}
void CSellinfo::insRecive(float recive)
{
	sellRECIVE=recive;
}

float CSellinfo::getReturn()
{
	return sellRETURN;
}
void CSellinfo::insReturn(float rturn)
{
	sellRETURN=rturn;
}

CString CSellinfo::getUserid()
{
	return sellUSERID;
}
void CSellinfo::insUserid(CString id)
{
	sellUSERID=id;
}
void CSellinfo::GetData(CString n)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM sellinfo WHERE sellN='" + n + "'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CSellinfo();
	else
	{
		sellN = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("sellN");
		sellDATE = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("sellDATE");
		sellALLDISCOUNT = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("sellALLDISCOUNT"));
		sellRECIVE = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("sellRECIVE"));
		sellALLMONEY = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("sellALLMONEY"));
		sellRETURN = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("sellRETURN"));
		sellUSERID = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("userID");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void CSellinfo::sql_insert()
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	CString a,b,c,d;
	a.Format("%f", sellALLDISCOUNT);
	b.Format("%f", sellALLMONEY);
	c.Format("%f", sellRECIVE);
	d.Format("%f", sellRETURN);
	_bstr_t vSQL;
	vSQL = "INSERT INTO sellinfo VALUES('" + sellN + "',"+ a + ",'" + sellUSERID + 
		"'," + b + "," + c + "," + d + ",'" + sellDATE + "')";
	//执行INSERT语句*/
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void CSellinfo::sql_delete(CString n)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM sellinfo WHERE sellN='" + n + "'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

CString CSellinfo::LastID()
{
	int i,j;
	CString s;
	i=0;
	j=0;
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL = "SELECT * FROM sellinfo";//取得所有记录
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if(m_pRecordset->adoEOF) return "10000";
	while(!m_pRecordset->adoEOF)
	{
		j=atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("sellN"));
		if(j>i) i=j;
		m_pRecordset->MoveNext();
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
	s.Format("%d",i);
	return s;
}