ywydatasave.cpp

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

// YwyDataSave1.cpp: implementation of the CYwyDataSave class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "medicalmanage.h"
#include "YwyDataSave.h"

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

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

CYwyDataSave::CYwyDataSave()
{
	ywyName = _T("");
	sex = _T("");
	department = _T("");
	duty = _T("");
	address = _T("");
	telphone = 0;

}

CYwyDataSave::~CYwyDataSave()
{

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

		ar << ywyName; 
		ar << sex;
		ar << department;
		ar << duty;
		ar << address; 
		ar << telphone;
	}
	else
	{	// loading code
		ar >> nVersion;
		if (nVersion == 1000)
		{
			ar >> ywyName; 
			ar >> sex;
			ar >> department;
			ar >> duty;
			ar >> address; 
			ar >> telphone;
		}
	}
}
void CYwyDataSave::ReadData()
{
	CADOConn ado;
	ado.OnInitADOConn(_T("MedicalManage"));
	CString strSql;
	strSql = "select * from 业务员信息";
	_RecordsetPtr m_Recordset;
	m_Recordset = ado.GetRecordset(strSql,_T("MedicalManage"));

	theApp.m_YwyDSArray.RemoveAll();
	
	while(!m_Recordset->adoEOF)
	{
		CYwyDataSave * pData = new CYwyDataSave();
		ASSERT(pData);

		FieldsPtr pFields = m_Recordset->Fields;
		FieldPtr pField = pFields->GetItem(0L);
		if(pField->Value.vt != VT_NULL)
		{
			pData->ywyName = (char*)(_bstr_t)pField->Value;
			pData->ywyName.TrimRight();
		}
		pField = pFields->GetItem(1L);
		if(pField->Value.vt != VT_NULL)
		{
			pData->sex = (char*)(_bstr_t)pField->Value;
			pData->sex.TrimRight();
		}
		pField = pFields->GetItem(2L);
		if(pField->Value.vt != VT_NULL)
		{
			pData->department = (char*)(_bstr_t)pField->Value;
			pData->department.TrimRight();
		}
		pField = pFields->GetItem(3L);
		if(pField->Value.vt != VT_NULL)
		{
			pData->duty = (char*)(_bstr_t)pField->Value;
			pData->duty.TrimRight();
		}
		pField = pFields->GetItem(4L);
		if(pField->Value.vt != VT_NULL)
		{
			pData->address = (char*)(_bstr_t)pField->Value;
			pData->address.TrimRight();
		}
		pField = pFields->GetItem(5L);
		CString Tel;
		if(pField->Value.vt != VT_NULL)
		{
			Tel = (char*)(_bstr_t)pField->Value;
			Tel.TrimRight();
		}
		pData->telphone = atoi(Tel);
		
		theApp.m_YwyDSArray.Add(pData);
		
		m_Recordset->MoveNext();
	}
	ado.ExitConnect();
}