// ProType.cpp: implementation of the CProType class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Stock.h"
#include "ProType.h"
#include "ADOConn.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CProType::CProType()
{
	TypeId = 0;
	TypeName = "";
	UpperId = 0;
}

CProType::~CProType()
{

}

//讀取和設(shè)置成員變量
int CProType::GetTypeId()
{
	return TypeId;
}

void CProType::SetTypeId(int iTypeId)
{
	TypeId = iTypeId;
}

CString CProType::GetTypeName()
{
	return TypeName;
}

void CProType::SetTypeName(CString cTypeName)
{
	TypeName = cTypeName;
}

int CProType::GetUpperId()
{
	return UpperId;
}

void CProType::SetUpperId(int iUpperId)
{
	UpperId = iUpperId;
}


//數(shù)據(jù)庫(kù)操作
int CProType::HaveName(CString cTypeName)
{
	//連接數(shù)據(jù)庫(kù)
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設(shè)置SELECT語(yǔ)句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM ProType WHERE TypeName='" + cTypeName + "'";
	//執(zhí)行SELETE語(yǔ)句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//斷開(kāi)與數(shù)據(jù)庫(kù)的連接
	m_AdoConn.ExitConnect();
}

int CProType::HaveSon(CString cTypeId)
{
	//連接數(shù)據(jù)庫(kù)
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設(shè)置SELECT語(yǔ)句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM ProType WHERE UpperId=" + cTypeId;
	//執(zhí)行SELETE語(yǔ)句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//斷開(kāi)與數(shù)據(jù)庫(kù)的連接
	m_AdoConn.ExitConnect();
}

void CProType::sql_insert()
{
	//連接數(shù)據(jù)庫(kù)
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設(shè)置INSERT語(yǔ)句
	CString strId;
	strId.Format("%d", UpperId);
	_bstr_t vSQL;
	vSQL = "INSERT INTO ProType (TypeName, UpperId) VALUES('" + TypeName + "'," + strId + ")";
	
	//執(zhí)行INSERT語(yǔ)句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開(kāi)與數(shù)據(jù)庫(kù)的連接
	m_AdoConn.ExitConnect();
}
	
void CProType::sql_update(CString cTypeId)
{
	//連接數(shù)據(jù)庫(kù)
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設(shè)置UPDATE語(yǔ)句
	CString strId;
	strId.Format("%d", UpperId);
	_bstr_t vSQL;
	vSQL = "UPDATE ProType SET TypeName='" + TypeName + "', UpperId=" + strId 
		+ " WHERE TypeId=" + cTypeId;
	
	//執(zhí)行UPDATE語(yǔ)句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開(kāi)與數(shù)據(jù)庫(kù)的連接
	m_AdoConn.ExitConnect();
}	

void CProType::sql_delete(CString cTypeId)
{
	//連接數(shù)據(jù)庫(kù)
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設(shè)置DELETE語(yǔ)句
	_bstr_t vSQL;
	vSQL = "DELETE FROM ProType WHERE TypeId=" + cTypeId;
	//執(zhí)行DELETE語(yǔ)句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開(kāi)與數(shù)據(jù)庫(kù)的連接
	m_AdoConn.ExitConnect();
}

//根據(jù)客戶(hù)編號(hào)讀取所有字段值
void CProType::GetData(CString cTypeId)
{
	//連接數(shù)據(jù)庫(kù)
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設(shè)置SELECT語(yǔ)句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM ProType WHERE TypeId=" + cTypeId;
	//執(zhí)行SELETE語(yǔ)句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CProType();
	else
	{
		TypeId = atoi(cTypeId);
		TypeName = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("TypeName");
		UpperId = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("UpperId"));
	}
	//斷開(kāi)與數(shù)據(jù)庫(kù)的連接
	m_AdoConn.ExitConnect();
}