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

// remote_services.h : CViewRemote_Services 类的实现



// CViewRemote_Services 实现

// 代码生成在 2017年09月30日, 15:15

#include "stdafx.h"
#include "remote_services.h"
IMPLEMENT_DYNAMIC(CViewRemote_Services, CRecordset)

CViewRemote_Services::CViewRemote_Services(CDatabase* pdb)
	: CRecordset(pdb)
{
	m_name1 = _T("");
	m_name2 = _T("");
	m_phone1 = _T("");
	m_ren = _T("");
	m_addr1 = _T("");
	m_qq1 = _T("");
	m_pinyin1 = _T("");
	m_pinyin2 = _T("");
	m_order = _T("");
	m_service_id = _T("");
	m_remote_date = _T("");
	m_remote_submit_staff = _T("");
	m_remote_service_staff = _T("");
	m_remote_service_commodity = _T("");
	m_remote_service_problem = _T("");
	m_remote_service_status = _T("");
	m_remote_service_result = _T("");
	m_remote_service_describe = _T("");
	m_remote_customer_contact = _T("");
	m_remote_customer_qq = _T("");
	m_remote_customer_phone = _T("");
	m_return_visit_status = _T("");
	m_return_visit_date = _T("");
	m_return_visit_staff = _T("");
	m_return_visit_result = _T("");
	m_return_visit_remark = _T("");
	m_nFields = 26;
	m_nDefaultType = dynaset;
}
// #error 安全问题：连接字符串可能包含密码。
// 此连接字符串中可能包含明文密码和/或其他重要
// 信息。请在查看完此连接字符串并找到所有与安全
// 有关的问题后移除 #error。可能需要将此密码存
// 储为其他格式或使用其他的用户身份验证。
CString CViewRemote_Services::GetDefaultConnect()
{
	return _T("DSN=internal;Trusted_Connection=Yes;APP=Microsoft\x00ae Visual Studio\x00ae 2008;WSID=DESKTOP-5ILISFF;DATABASE=Internal;");
}

CString CViewRemote_Services::GetDefaultSQL()
{
	return _T("[dbo].[remote_services]");
}

void CViewRemote_Services::DoFieldExchange(CFieldExchange* pFX)
{
	pFX->SetFieldType(CFieldExchange::outputColumn);
// RFX_Text() 和 RFX_Int() 这类宏依赖的是
// 成员变量的类型，而不是数据库字段的类型。
// ODBC 尝试自动将列值转换为所请求的类型
	RFX_Text(pFX, _T("[name1]"), m_name1);
	RFX_Text(pFX, _T("[name2]"), m_name2);
	RFX_Text(pFX, _T("[phone1]"), m_phone1);
	RFX_Text(pFX, _T("[ren]"), m_ren);
	RFX_Text(pFX, _T("[addr1]"), m_addr1);
	RFX_Text(pFX, _T("[qq1]"), m_qq1);
	RFX_Text(pFX, _T("[pinyin1]"), m_pinyin1);
	RFX_Text(pFX, _T("[pinyin2]"), m_pinyin2);
	RFX_Text(pFX, _T("[order]"), m_order);
	RFX_Text(pFX, _T("[service_id]"), m_service_id);
	RFX_Text(pFX, _T("[remote_date]"), m_remote_date);
	RFX_Text(pFX, _T("[remote_submit_staff]"), m_remote_submit_staff);
	RFX_Text(pFX, _T("[remote_service_staff]"), m_remote_service_staff);
	RFX_Text(pFX, _T("[remote_service_commodity]"), m_remote_service_commodity);
	RFX_Text(pFX, _T("[remote_service_problem]"), m_remote_service_problem);
	RFX_Text(pFX, _T("[remote_service_status]"), m_remote_service_status);
	RFX_Text(pFX, _T("[remote_service_result]"), m_remote_service_result);
	RFX_Text(pFX, _T("[remote_service_describe]"), m_remote_service_describe);
	RFX_Text(pFX, _T("[remote_customer_contact]"), m_remote_customer_contact);
	RFX_Text(pFX, _T("[remote_customer_qq]"), m_remote_customer_qq);
	RFX_Text(pFX, _T("[remote_customer_phone]"), m_remote_customer_phone);
	RFX_Text(pFX, _T("[return_visit_status]"), m_return_visit_status);
	RFX_Text(pFX, _T("[return_visit_date]"), m_return_visit_date);
	RFX_Text(pFX, _T("[return_visit_staff]"), m_return_visit_staff);
	RFX_Text(pFX, _T("[return_visit_result]"), m_return_visit_result);
	RFX_Text(pFX, _T("[return_visit_remark]"), m_return_visit_remark);

}
/////////////////////////////////////////////////////////////////////////////
// CViewRemote_Services 诊断

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

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

/************************************************************************/
/*  函数：[10/5/2017 IT];
/*  描述：;
/*  参数：;
/*  	[IN] ：;
/*  	[OUT] ：;
/*  	[IN/OUT] ：;
/*  返回：void;
/*  注意：;
/*  示例：;
/*
/*  修改：;
/*  日期：;
/*  内容：;
/************************************************************************/
void CViewRemote_Services::GetReturnValue(IN CArray<CStringArray, CStringArray>& AryValue, IN CDatabase* pDatabase, IN CString strFilter)
{
	CRecordset tagSet(pDatabase);
	CString strTemp = _T("select count(*) as cot from [remote_services]");
	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;

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

		AryValue.ElementAt(dwIndex).Add(tagRst.m_name1);						// 0.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_name2);						// 1.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_phone1);						// 2.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_ren);							// 3.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_addr1);						// 4.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_qq1);							// 5.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_pinyin1);						// 6.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_pinyin2);						// 7.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_order);						// 8.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_remote_date);					// 9.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_remote_submit_staff);			// 10.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_remote_service_staff);			// 11.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_remote_service_commodity);		// 12.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_remote_service_problem);		// 13.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_remote_service_status);		// 14.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_remote_service_result);		// 15.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_remote_service_describe);		// 16.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_remote_customer_contact);		// 17.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_remote_customer_qq);			// 18.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_remote_customer_phone);		// 19.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_return_visit_status);			// 20.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_return_visit_date);			// 21.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_return_visit_staff);			// 22.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_return_visit_result);			// 23.注释;
		AryValue.ElementAt(dwIndex).Add(tagRst.m_return_visit_remark);			// 24.注释;
		dwIndex++;
		if ( AryValue.GetSize() <= dwIndex )
			break;
		tagRst.MoveNext();
	}
	AryValue.SetSize(dwIndex,1);
	tagRst.Close();
}