// MaterialInfoDataSet.cpp: implementation of the CMaterialInfoDataSet class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "WhMgr.h"
#include "MaterialInfoDataSet.h"

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

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

CMaterialInfoDataSet::CMaterialInfoDataSet()
{

}

CMaterialInfoDataSet::~CMaterialInfoDataSet()
{

}

BOOL CMaterialInfoDataSet::LoadData()
{
	return Open("Select * From tblMaterialInfo");
}

BOOL CMaterialInfoDataSet::LoadDataByNum(CString Num)
{
	return Open("Select * From tblMaterialInfo Where MaterialNum = " + Num);
}

CString CMaterialInfoDataSet::GetUnit()
{
	return GetAsString("Unit");
}

CString CMaterialInfoDataSet::GetMaterialName()
{
	return GetAsString("MaterialName");
}

CString CMaterialInfoDataSet::GetMaxCount()
{
	return GetAsString("MaxCount");
}

CString CMaterialInfoDataSet::GetMaterialNum()
{
	return GetAsString("MaterialNum");
}

CString CMaterialInfoDataSet::GetCount()
{
	return GetAsString("Count");
}

void CMaterialInfoDataSet::SetUnit(CString Value)
{
	SetAsString("Unit", Value);
}

void CMaterialInfoDataSet::SetMaterialName(CString Value)
{
	SetAsString("MaterialName", Value);
}

void CMaterialInfoDataSet::SetMaxCount(CString Value)
{
	SetAsString("MaxCount", Value);
}

void CMaterialInfoDataSet::SetMaterialNum(CString Value)
{
	SetAsString("MaterialNum", Value);
}

void CMaterialInfoDataSet::SetCount(CString Value)
{
	SetAsString("Count", Value);
}