sjwfset.cpp

只须作点改动就可支持打印各种证件打印

// SJWFSet.cpp : implementation of the CSJWFSet class
//

#include "stdafx.h"
#include "SJWF.h"
#include "SJWFSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSJWFSet implementation

IMPLEMENT_DYNAMIC(CSJWFSet, CRecordset)

CSJWFSet::CSJWFSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CSJWFSet)
	m_mc = _T("");
	m_dz = _T("");
	m_fzr = _T("");
	m_bxlx = _T("");
	m_pzwh = _T("");
	m_yxq = _T("");
	m_fzrq = _T("");
	m_jszh = _T("");
	m_hb = _T("");
	m_nFields = 9;
	//}}AFX_FIELD_INIT
	m_nDefaultType = dynaset;
}

CString CSJWFSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=SCRECORD");
}

CString CSJWFSet::GetDefaultSQL()
{
	return _T("[bxxk]");
}

void CSJWFSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CSJWFSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[mc]"), m_mc);
	RFX_Text(pFX, _T("[dz]"), m_dz);
	RFX_Text(pFX, _T("[fzr]"), m_fzr);
	RFX_Text(pFX, _T("[bxlx]"), m_bxlx);
	RFX_Text(pFX, _T("[pzwh]"), m_pzwh);
	RFX_Text(pFX, _T("[yxq]"), m_yxq);
	RFX_Text(pFX, _T("[fzrq]"), m_fzrq);
	RFX_Text(pFX, _T("[jszh]"), m_jszh);
	RFX_Text(pFX, _T("[hb]"), m_hb);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CSJWFSet diagnostics

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

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

BOOL CSJWFSet::AddRecord(CString Jszh, CString Mc, CString Dz, CString Fzr, CString Bxlx, CString Pzwh, CString Yxq, int Hlhb)
{
	CTime time=CTime::GetCurrentTime();//得到当前时间 
	CString s=time.Format("%y-%m-%d");//转换时间格式 
	CString a="要求得到合理回报";
	CString b="不要求得到合理回报";
	try
	{
		if(!IsOpen())
			Open();
	}
	catch (CDBException *e)
	{
		AfxMessageBox(e->m_strError);
		return false;
	}
	try{
	this->AddNew();
	this->m_jszh=Jszh;
	this->m_mc=Mc;
	this->m_dz=Dz;
	this->m_fzr=Fzr;
	this->m_bxlx=Bxlx;
	this->m_pzwh=Pzwh;
	this->m_yxq=Yxq;
	this->m_fzrq=s;
	if(Hlhb==1)
	{
		this->m_hb=b;
	}
	else
		this->m_hb=a;
	
	if(this->CanUpdate())
	{
		this->Update();
	}
	if(!this->IsEOF())
	{
		this->MoveLast();
	}
	this->Requery();
	}
	catch (CDBException*e)
	{
		AfxMessageBox(e->m_strError);
		return false;
	}
	return true;
}

int CSJWFSet::MyGetRecordCount(CRecordset *pSet)
{
	int nScout;
	if(!pSet->IsBOF())
		pSet->MoveFirst();
	while (!pSet->IsEOF())
	{
		pSet->MoveNext();
	}
	nScout=pSet->GetRecordCount();
	return nScout;
}

void CSJWFSet::OnRecordDelete()
{
	CRecordset*pSet;

	try
	{
		pSet->Delete();
	}
	catch (CDBException*e)
	{
		AfxMessageBox(e->m_strError,MB_OK);
	}
}