salefhdatasave.cpp

用于医疗器械产品的购销存管理

// SaleFHDataSave.cpp: implementation of the CSaleFHDataSave class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "medicalmanage.h"
#include "SaleFHDataSave.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif
IMPLEMENT_SERIAL(CSaleFHDataSave, CObject, 1)

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

CSaleFHDataSave::CSaleFHDataSave()
{
	FHDNum = _T("");
	FPNum = _T("");
	CliName = _T("");  
	FHDatetime = _T("");
	InsNumber = _T("");
	ProdName = _T("");
	ProSpec = _T("");
	ProUnit = _T("");
	count = 0;
	probox = _T("");
	ProPrice = 0.00;
	Sum = 0.00;
	invalidate = _T("");
	ProNum = _T("");    
	KDPerson = _T("");  
}

CSaleFHDataSave::~CSaleFHDataSave()
{

}
void CSaleFHDataSave::Serialize(CArchive& ar)
{
	int nVersion = 1000;
	
	if (ar.IsStoring())
	{	// storing code
		ar << nVersion;

		ar << FHDNum; 
		ar << FPNum;
		ar << CliName;
		ar << FHDatetime;
		ar << InsNumber; 
		ar << ProdName;
		ar << ProSpec;
		ar << ProUnit;
		ar << count;
		ar << probox;
		ar << ProPrice;
		ar << Sum;
		ar << invalidate;
		ar << ProNum;
		ar << KDPerson;
	}
	else
	{	// loading code
		ar >> nVersion;
		if (nVersion == 1000)
		{
			ar >> FHDNum;  
			ar >> FPNum;
			ar >> CliName;
			ar >> FHDatetime;
			ar >> InsNumber; 
			ar >> ProdName;
			ar >> ProSpec;
			ar >> ProUnit;
			ar >> count;
			ar >> probox;
			ar >> ProPrice;
			ar >> Sum;
			ar >> invalidate;
			ar >> ProNum;
			ar >> KDPerson;
		}
	}
}

void CSaleFHDataSave::ReadData()
{
	CADOConn ado;
	ado.OnInitADOConn(_T("MedicalManage"));
	CString strSql;
	strSql = "select * from 销售发货";
	_RecordsetPtr m_Recordset;
	m_Recordset = ado.GetRecordset(strSql,_T("MedicalManage"));

	theApp.m_SalefhDSArray.RemoveAll();
	
	while(!m_Recordset->adoEOF)
	{
		CSaleFHDataSave * pCData = new CSaleFHDataSave();
		ASSERT(pCData);

		FieldsPtr pFields = m_Recordset->Fields;
		FieldPtr pField = pFields->GetItem(0L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->FHDNum = (char*)(_bstr_t)pField->Value;
			pCData->FHDNum.TrimRight();
		}
		pField = pFields->GetItem(1L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->FPNum = (char*)(_bstr_t)pField->Value;
			pCData->FPNum.TrimRight();
		}
		pField = pFields->GetItem(2L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->CliName = (char*)(_bstr_t)pField->Value;
			pCData->CliName.TrimRight();
		}
		pField = pFields->GetItem(3L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->FHDatetime = (char*)(_bstr_t)pField->Value;
			pCData->FHDatetime.TrimRight();
		}
		pField = pFields->GetItem(4L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->InsNumber = (char*)(_bstr_t)pField->Value;
			pCData->InsNumber.TrimRight();
		}
		pField = pFields->GetItem(5L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->ProdName = (char*)(_bstr_t)pField->Value;
			pCData->ProdName.TrimRight();
		}
		pField = pFields->GetItem(6L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->ProSpec = (char*)(_bstr_t)pField->Value;
			pCData->ProSpec.TrimRight();
		}
		pField = pFields->GetItem(7L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->ProUnit = (char*)(_bstr_t)pField->Value;
			pCData->ProUnit.TrimRight();
		}
		pField = pFields->GetItem(8L);
		CString Count;
		if(pField->Value.vt != VT_NULL)
		{
			Count = (char*)(_bstr_t)pField->Value;
			Count.TrimRight();
		}
		pCData->count = atoi(Count);
		pField = pFields->GetItem(9L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->probox = (char*)(_bstr_t)pField->Value;
			pCData->probox.TrimRight();
		}

		pField = pFields->GetItem(10L);
		CString propri;
		if(pField->Value.vt != VT_NULL)
		{
			propri = (char*)(_bstr_t)pField->Value;
			propri.TrimRight();
		}
		pCData->ProPrice = atof(propri);
		pField = pFields->GetItem(11L);
		CString sum;
		if(pField->Value.vt != VT_NULL)
		{
			sum = (char*)(_bstr_t)pField->Value;
			sum.TrimRight();
		}
		pCData->Sum = atof(sum);
		pField = pFields->GetItem(12L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->invalidate = (char*)(_bstr_t)pField->Value;
			pCData->invalidate.TrimRight();
		}
		pField = pFields->GetItem(13L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->ProNum = (char*)(_bstr_t)pField->Value;
			pCData->ProNum.TrimRight();
		}
		pField = pFields->GetItem(14L);
		if(pField->Value.vt != VT_NULL)
		{
			pCData->KDPerson = (char*)(_bstr_t)pField->Value;
			pCData->KDPerson.TrimRight();
		}

		theApp.m_SalefhDSArray.Add(pCData);
		
		m_Recordset->MoveNext();
	}
	ado.ExitConnect();
}