// PackageItemView.h : CPackageItemView 类的实现



// CPackageItemView 实现

// 代码生成在 2016年11月11日, 14:28

#include "stdafx.h"
#include "PackageItemView.h"
IMPLEMENT_DYNAMIC(CPackageItemView, CRecordset)

CPackageItemView::CPackageItemView(CDatabase* pdb)
	: CRecordset(pdb)
{
	m_StudioID = _T("");
	m_ItemType = "";
	m_ItemSubType = _T("");
	m_ItemSN = _T("");
	m_ItemName = _T("");
	m_ItemCost = 0.0;
	m_ItemSales = 0.0;
	m_ItemShelves = FALSE;
	m_ItemNote = _T("");
	m_nFields = 9;
	m_nDefaultType = dynaset;
}
//#error 安全问题: 连接字符串可能包含密码。
// 此连接字符串中可能包含明文密码和/或其他重要
// 信息。请在查看完此连接字符串并找到所有与安全
// 有关的问题后移除 #error。可能需要将此密码存
// 储为其他格式或使用其他的用户身份验证。
CString CPackageItemView::GetDefaultConnect()
{
	return _T("DSN=EasySelection;UID=sa;PWD=ly1234;APP=Microsoft\x00ae Visual Studio\x00ae 2015;WSID=IT-PC;DATABASE=EasySelection;");
}

CString CPackageItemView::GetDefaultSQL()
{
	return _T("[dbo].[PackageItemView]");
}

void CPackageItemView::DoFieldExchange(CFieldExchange* pFX)
{
	pFX->SetFieldType(CFieldExchange::outputColumn);
// RFX_Text() 和 RFX_Int() 这类宏依赖的是
// 成员变量的类型，而不是数据库字段的类型。
// ODBC 尝试自动将列值转换为所请求的类型
	RFX_Text(pFX, _T("[StudioID]"), m_StudioID);
	RFX_Text(pFX, _T("[ItemType]"), m_ItemType);
	RFX_Text(pFX, _T("[ItemSubType]"), m_ItemSubType);
	RFX_Text(pFX, _T("[ItemSN]"), m_ItemSN);
	RFX_Text(pFX, _T("[ItemName]"), m_ItemName);
	RFX_Double(pFX, _T("[ItemCost]"), m_ItemCost);
	RFX_Double(pFX, _T("[ItemSales]"), m_ItemSales);
	RFX_Bool(pFX, _T("[ItemShelves]"), m_ItemShelves);
	RFX_Text(pFX, _T("[ItemNote]"), m_ItemNote);

}
/////////////////////////////////////////////////////////////////////////////
// CPackageItemView 诊断

#ifdef _DEBUG
void CPackageItemView::AssertValid() const
{
	CRecordset::AssertValid();
}

void CPackageItemView::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG


//////////////////////////////////////////////////////////////////////////
IMPLEMENT_SERIAL(CPackageItemViewObj, CObject, 0)

CPackageItemViewObj::CPackageItemViewObj()
{
	m_StudioID = _T("");
	m_ItemType = _T("");
	m_ItemSubType = _T("");
	m_ItemSN = _T("");
	m_ItemName = _T("");
	m_ItemCost = 0.0;
	m_ItemSales = 0.0;
	m_ItemShelves = FALSE;
	m_ItemNote = _T("");
}

CPackageItemViewObj& CPackageItemViewObj::operator=(const CPackageItemViewObj& member)
{
	m_StudioID = member.m_StudioID;
	m_ItemType = member.m_ItemType;
	m_ItemSubType = member.m_ItemSubType;
	m_ItemSN = member.m_ItemSN;
	m_ItemName = member.m_ItemName;
	m_ItemCost = member.m_ItemCost;
	m_ItemSales = member.m_ItemSales;
	m_ItemShelves = member.m_ItemShelves;
	m_ItemNote = member.m_ItemNote;

	return *this;
}

void CPackageItemViewObj::Serialize(CArchive& ar)
{
	try
	{
		CObject::Serialize(ar);

		if (ar.IsStoring())
		{
			ar << m_StudioID;
			ar << m_ItemType;
			ar << m_ItemSubType;
			ar << m_ItemSN;
			ar << m_ItemName;
			ar << m_ItemCost;
			ar << m_ItemSales;
			ar << m_ItemShelves;
			ar << m_ItemNote;
		}
		else
		{
			ar >> m_StudioID;
			ar >> m_ItemType;
			ar >> m_ItemSubType;
			ar >> m_ItemSN;
			ar >> m_ItemName;
			ar >> m_ItemCost;
			ar >> m_ItemSales;
			ar >> m_ItemShelves;
			ar >> m_ItemNote;
		}
	}
	catch (CMemoryException* e)
	{
#if _DEBUG
		e->ReportError();
#endif
	}
}