lyfz_repos/经典版源码/lyfzInternalServer/trunk/InternalServer/Tblrenyuan.cpp

////////////////////////////////////////////////////////////////////////////////
// CTblrenyuan 实现

// 代码生成在 2014年9月24日, 17:08

#include "stdafx.h"
#include "Tblrenyuan.h"

IMPLEMENT_DYNAMIC(CTblrenyuan, CRecordset)

CTblrenyuan::CTblrenyuan(CDatabase* pdb): CRecordset(pdb)
{	
	m_id =  _T("");					
	m_rate1 =  _T("");			
	m_rate2 =  _T("");			
	m_bz2 =  _T("");					
	m_rate3 =  _T("");			
	m_rate4 =  _T("");			
	m_rate5 =  _T("");			

	m_level =  _T("");			
	m_staff_department =  _T("");			
	m_staff_name =  _T("");			
	m_staff_gender =  _T("");			
	m_staff_phone =  _T("");			
	m_staff_family_address =  _T("");			
	m_staff_base_pay =  _T("");			
	m_staff_citizen_id_number =  _T("");			
	m_staff_married =  _T("");			
	m_staff_dimission =  _T("");			
	m_staff_fingerprinted1 =  _T("");			
	m_staff_fingerprinted2 =  _T("");			
	m_staff_self_phone =  _T("");			
	m_staff_father =  _T("");			
	m_staff_mother =  _T("");			
	m_staff_father_phone =  _T("");			
	m_staff_mother_phone =  _T("");			
	m_staff_emergency_name =  _T("");			
	m_staff_emergency_phone =  _T("");			
	m_staff_emergency_relationship =  _T("");			
	m_staff_hire_date =  _T("");			
	m_staff_leave_date =  _T("");			
	m_staff_self_qq =  _T("");			
	m_staff_self_weixin =  _T("");			
	m_staff_self_email =  _T("");			
	m_staff_educational =  _T("");			
	m_staff_native_place =  _T("");			
	m_staff_birthday =  _T("");			
	m_staff_graduate_institutions =  _T("");			
	m_staff_note =  _T("");				
	m_staff_qq = _T("");
	m_staff_trial_work_date = _T("");
	m_staff_position = _T("");
	m_nFields = 40;	// 注意：image类型未生成成员变量,此处值可能不对。
	m_nDefaultType = dynaset;
	m_strSort = _T("id");
}
//#error 安全问题：连接字符串可能包含密码。
// 此连接字符串中可能包含明文密码和/或其他重要
// 信息。请在查看完此连接字符串并找到所有与安全
// 有关的问题后移除 #error。可能需要将此密码存
// 储为其他格式或使用其他的用户身份验证。
CString CTblrenyuan::GetDefaultConnect()
{
	return _T("ODBC;DSN");
}

CString CTblrenyuan::GetDefaultSQL()
{
	return _T("[dbo].[renyuan]");
}

void CTblrenyuan::DoFieldExchange(CFieldExchange* pFX)
{
	pFX->SetFieldType(CFieldExchange::outputColumn);
	// RFX_Text() 和 RFX_Int() 这类宏依赖的是
	// 成员变量的类型，而不是数据库字段的类型。
	// ODBC 尝试自动将列值转换为所请求的类型
	RFX_Text(pFX, _T("id"), m_id);	
	RFX_Text(pFX, _T("rate1"), m_rate1);	
	RFX_Text(pFX, _T("rate2"), m_rate2);	
	RFX_Text(pFX, _T("bz2"), m_bz2);	
	RFX_Text(pFX, _T("rate3"), m_rate3);	
	RFX_Text(pFX, _T("rate4"), m_rate4);	
	RFX_Text(pFX, _T("rate5"), m_rate5);	
	RFX_Text(pFX, _T("level"), m_level);	
	RFX_Text(pFX, _T("staff_department"), m_staff_department);	
	RFX_Text(pFX, _T("staff_name"), m_staff_name);	
	RFX_Text(pFX, _T("staff_gender"), m_staff_gender);	
	RFX_Text(pFX, _T("staff_phone"), m_staff_phone);	
	RFX_Text(pFX, _T("staff_family_address"), m_staff_family_address);	
	RFX_Text(pFX, _T("staff_base_pay"), m_staff_base_pay);	
	RFX_Text(pFX, _T("staff_citizen_id_number"), m_staff_citizen_id_number);	
	RFX_Text(pFX, _T("staff_married"), m_staff_married);	
	RFX_Text(pFX, _T("staff_dimission"), m_staff_dimission);	
	RFX_Text(pFX, _T("staff_fingerprinted1"), m_staff_fingerprinted1);	
	RFX_Text(pFX, _T("staff_fingerprinted2"), m_staff_fingerprinted2);	
	RFX_Text(pFX, _T("staff_self_phone"), m_staff_self_phone);	
	RFX_Text(pFX, _T("staff_father"), m_staff_father);	
	RFX_Text(pFX, _T("staff_mother"), m_staff_mother);	
	RFX_Text(pFX, _T("staff_father_phone"), m_staff_father_phone);	
	RFX_Text(pFX, _T("staff_mother_phone"), m_staff_mother_phone);	
	RFX_Text(pFX, _T("staff_emergency_name"), m_staff_emergency_name);	
	RFX_Text(pFX, _T("staff_emergency_phone"), m_staff_emergency_phone);	
	RFX_Text(pFX, _T("staff_emergency_relationship"), m_staff_emergency_relationship);	
	RFX_Text(pFX, _T("staff_hire_date"), m_staff_hire_date);	
	RFX_Text(pFX, _T("staff_leave_date"), m_staff_leave_date);	
	RFX_Text(pFX, _T("staff_self_qq"), m_staff_self_qq);	
	RFX_Text(pFX, _T("staff_self_weixin"), m_staff_self_weixin);	
	RFX_Text(pFX, _T("staff_self_email"), m_staff_self_email);	
	RFX_Text(pFX, _T("staff_educational"), m_staff_educational);	
	RFX_Text(pFX, _T("staff_native_place"), m_staff_native_place);	
	RFX_Text(pFX, _T("staff_birthday"), m_staff_birthday);	
	RFX_Text(pFX, _T("staff_graduate_institutions"), m_staff_graduate_institutions);	
	RFX_Text(pFX, _T("staff_note"), m_staff_note);		
	RFX_Text(pFX, _T("staff_qq"), m_staff_qq);	
	RFX_Text(pFX, _T("staff_trial_work_date"), m_staff_trial_work_date);	
	RFX_Text(pFX, _T("staff_position"), m_staff_position);	
}
/////////////////////////////////////////////////////////////////////////////
// CTblrenyuan 诊断

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

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


INT CTblrenyuan::GetTbl_renyuanRecordSet(IN CDatabase *pDb, IN CString strFilters, OUT vector<Tblrenyuan>& vtResult)
{
	if ( pDb == NULL )
		return -1;

	CRecordset myset(pDb);
	CString	strSQL = _T("Select Count(*) as cot from renyuan");
	if (!strFilters.IsEmpty())
		strSQL.Format(_T("Select Count(*) as cot from renyuan where %s"), strFilters);
	myset.Open(CRecordset::forwardOnly, strSQL);
	myset.GetFieldValue(_T("cot"), strSQL);
	myset.Close();

	INT nCount = _ttol(strSQL);
	if ( nCount == 0 )
		return 0;

	try
	{
		CTblrenyuan rst(pDb);
		if (!strFilters.IsEmpty())
			rst.m_strFilter = strFilters;

		if ( rst.Open() )
		{
			while( !rst.IsEOF() )
			{
				Tblrenyuan tagVal;
				tagVal._id = rst.m_id;
				tagVal._rate1 = rst.m_rate1;
				tagVal._rate2 = rst.m_rate2;
				tagVal._bz2 = rst.m_bz2;
				tagVal._rate3 = rst.m_rate3;
				tagVal._rate4 = rst.m_rate4;
				tagVal._rate5 = rst.m_rate5;
				//tagVal._photo = rst.m_photo;
				tagVal._level = rst.m_level;
				tagVal._staff_department = rst.m_staff_department;
				tagVal._staff_name = rst.m_staff_name;
				tagVal._staff_gender = rst.m_staff_gender;
				tagVal._staff_phone = rst.m_staff_phone;
				tagVal._staff_family_address = rst.m_staff_family_address;
				tagVal._staff_base_pay = rst.m_staff_base_pay;
				tagVal._staff_citizen_id_number = rst.m_staff_citizen_id_number;
				tagVal._staff_married = rst.m_staff_married;
				tagVal._staff_dimission = rst.m_staff_dimission;
				tagVal._staff_fingerprinted1 = rst.m_staff_fingerprinted1;
				tagVal._staff_fingerprinted2 = rst.m_staff_fingerprinted2;
				tagVal._staff_self_phone = rst.m_staff_self_phone;
				tagVal._staff_father = rst.m_staff_father;
				tagVal._staff_mother = rst.m_staff_mother;
				tagVal._staff_father_phone = rst.m_staff_father_phone;
				tagVal._staff_mother_phone = rst.m_staff_mother_phone;
				tagVal._staff_emergency_name = rst.m_staff_emergency_name;
				tagVal._staff_emergency_phone = rst.m_staff_emergency_phone;
				tagVal._staff_emergency_relationship = rst.m_staff_emergency_relationship;
				tagVal._staff_hire_date = rst.m_staff_hire_date;
				tagVal._staff_leave_date = rst.m_staff_leave_date;
				tagVal._staff_self_qq = rst.m_staff_self_qq;
				tagVal._staff_self_weixin = rst.m_staff_self_weixin;
				tagVal._staff_self_email = rst.m_staff_self_email;
				tagVal._staff_educational = rst.m_staff_educational;
				tagVal._staff_native_place = rst.m_staff_native_place;
				tagVal._staff_birthday = rst.m_staff_birthday;
				tagVal._staff_graduate_institutions = rst.m_staff_graduate_institutions;
				tagVal._staff_note = rst.m_staff_note;
				//tagVal._staff_qq = rst.m_staff_qq;
				//tagVal._staff_trial_work_date= rst.m_staff_trial_work_date;
				vtResult.push_back(tagVal);
				rst.MoveNext();
			}

			rst.Close();
		}
	}
	catch(CDBException *e)
	{
#ifdef _DEBUG
		WriteTextLog(_T("文件：%s,函数：%s, 错误信息：%s, 条件：%s"), __FILE__, __FUNCTION__, e->m_strError, strFilters);
		e->Delete();
#endif
	}

	return nCount;
}

void CTblrenyuan::Insertrenyuan(IN CDatabase* pDb, IN vector<Tblrenyuan> &vtValues)
{	
	if ( pDb == NULL )
		return;
	CString strInsert = _T("");
	for ( vector<Tblrenyuan>::iterator it = vtValues.begin(); it != vtValues.end(); it++ )
	{
		strInsert.Format(INSERT_renyuan,	 
			it->_id.c_str(), 
			it->_bz.c_str(), 
			it->_rate1.c_str(), 
			it->_rate2.c_str(), 
			it->_bz2.c_str(), 
			it->_address2.c_str(), 
			it->_rate3.c_str(), 
			it->_rate4.c_str(), 
			it->_rate5.c_str(), 
			it->_level.c_str(), 
			it->_staff_department.c_str(), 
			it->_staff_name.c_str(), 
			it->_staff_gender.c_str(), 
			it->_staff_phone.c_str(), 
			it->_staff_family_address.c_str(), 
			it->_staff_base_pay.c_str(), 
			it->_staff_citizen_id_number.c_str(), 
			it->_staff_married.c_str(), 
			it->_staff_dimission.c_str(), 
			it->_staff_fingerprinted1.c_str(), 
			it->_staff_fingerprinted2.c_str(), 
			it->_staff_self_phone.c_str(), 
			it->_staff_father.c_str(), 
			it->_staff_mother.c_str(), 
			it->_staff_father_phone.c_str(), 
			it->_staff_mother_phone.c_str(), 
			it->_staff_emergency_name.c_str(), 
			it->_staff_emergency_phone.c_str(), 
			it->_staff_emergency_relationship.c_str(), 
			it->_staff_hire_date.c_str(), 
			it->_staff_leave_date.c_str(), 
			it->_staff_self_qq.c_str(), 
			it->_staff_self_weixin.c_str(), 
			it->_staff_self_email.c_str(), 
			it->_staff_educational.c_str(), 
			it->_staff_native_place.c_str(), 
			it->_staff_birthday.c_str(), 
			it->_staff_graduate_institutions.c_str(), 
			it->_staff_note.c_str() 
			//it->_staff_qq.c_str(),
			//it->_staff_trial_work_date.c_str()
			);

		try{
			pDb->ExecuteSQL(strInsert);
		}
		catch(CDBException *e)
		{
#ifdef _DEBUG
			WriteTextLog(_T("文件：%s,函数：%s, 错误信息：%s, 条件：%s"), __FILE__, __FUNCTION__, e->m_strError, strInsert);
			e->Delete();
#endif
		}
	}
}

void CTblrenyuan::GetReturnValue(IN CArray<CStringArray, CStringArray>& AryValue, IN CDatabase* pDatabase, IN CString strFilter)
{
	CRecordset tagSet(pDatabase);
	CString strTemp = _T("select count(*) as cot from [renyuan]");
	if ( !strFilter.IsEmpty() )
		strTemp += _T(" where ") + strFilter;

	tagSet.Open(CRecordset::forwardOnly, strTemp);
	tagSet.GetFieldValue(_T("cot"), strTemp);
	tagSet.Close();

	// 2.查询指定条件记录;
	DWORD dwCount = atol(strTemp);
	DWORD dwOldSize = AryValue.GetSize();
	AryValue.SetSize(dwOldSize + dwCount, 1);
	DWORD dwIndex = dwOldSize == 0 ? 0 : dwOldSize - 1;

	CTblrenyuan tagRst(pDatabase);
	if ( !strFilter.IsEmpty() )
		tagRst.m_strFilter = strFilter;
	tagRst.Open();
	while( !tagRst.IsEOF() )
	{
		AryValue.ElementAt(dwIndex).RemoveAll();

		AryValue.ElementAt(dwIndex).Add(tagRst.m_id);							// 0.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_note);					// 1.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_rate1);						// 2.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_rate2);						// 3.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_bz2);							// 4.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_native_place);			// 5.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_rate3);						// 6.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_rate4);						// 7.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_rate5);						// 8.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_level);						// 9.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_department);				// 10.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_name);					// 11.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_gender);					// 12.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_phone);					// 13.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_family_address);			// 14.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_base_pay);				// 15.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_citizen_id_number);		// 16.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_married);				// 17.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_dimission);				// 18.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_fingerprinted1);			// 19.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_fingerprinted2);			// 20.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_self_phone);				// 21.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_father);					// 22.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_mother);					// 23.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_father_phone);			// 24.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_mother_phone);			// 25.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_emergency_name);			// 26.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_emergency_phone);		// 27.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_emergency_relationship);	// 28.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_hire_date);				// 29.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_leave_date);				// 30.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_self_qq);				// 31.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_self_weixin);			// 32.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_self_email);				// 33.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_educational);			// 34.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_birthday);				// 35.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_graduate_institutions);	// 36.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_qq);						// 37.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_trial_work_date);		// 38.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_staff_position);				// 39.注释;
		dwIndex++;
		if ( AryValue.GetSize() <= dwIndex )
			break;
		tagRst.MoveNext();
	}
	AryValue.SetSize(dwIndex,1);
	tagRst.Close();
}