sheet1.h

参数化车间设备资源绘制程序

// Sheet1.h : CSheet1 的声明

#pragma once

// 代码生成在 2008年1月3日, 17:04

class CSheet1Accessor
{
public:
	TCHAR m_column0[256];
	TCHAR m_F2[256];
	TCHAR m_F3[256];
	TCHAR m_F4[256];
	TCHAR m_F5[256];
	TCHAR m_F6[256];
	TCHAR m_F7[256];
	TCHAR m_F8[256];
	TCHAR m_F9[256];
	TCHAR m_F10[256];
	TCHAR m_F11[256];
	TCHAR m_F12[256];
	TCHAR m_F13[256];
	TCHAR m_F14[256];
	TCHAR m_F15[256];
	TCHAR m_F16[256];
	TCHAR m_F17[256];
	TCHAR m_F18[256];
	TCHAR m_F19[256];

	// 以下向导生成的数据成员包含
	//列映射中相应字段的状态值。
	// 可以使用这些值保存数据库返回的 NULL 值或在编译器返回
	// 错误时保存错误信息。有关如何使用
	//这些字段的详细信息，
	// 请参见 Visual C++ 文档中的
	//“向导生成的访问器中的字段状态数据成员”。
	// 注意: 在设置/插入数据前必须初始化这些字段!

	DBSTATUS m_dwcolumn0Status;
	DBSTATUS m_dwF2Status;
	DBSTATUS m_dwF3Status;
	DBSTATUS m_dwF4Status;
	DBSTATUS m_dwF5Status;
	DBSTATUS m_dwF6Status;
	DBSTATUS m_dwF7Status;
	DBSTATUS m_dwF8Status;
	DBSTATUS m_dwF9Status;
	DBSTATUS m_dwF10Status;
	DBSTATUS m_dwF11Status;
	DBSTATUS m_dwF12Status;
	DBSTATUS m_dwF13Status;
	DBSTATUS m_dwF14Status;
	DBSTATUS m_dwF15Status;
	DBSTATUS m_dwF16Status;
	DBSTATUS m_dwF17Status;
	DBSTATUS m_dwF18Status;
	DBSTATUS m_dwF19Status;

	// 以下向导生成的数据成员包含
	//列映射中相应字段的长度值。
	// 注意: 对变长列，必须在设置/插入
	//       数据前初始化这些字段!

	DBLENGTH m_dwcolumn0Length;
	DBLENGTH m_dwF2Length;
	DBLENGTH m_dwF3Length;
	DBLENGTH m_dwF4Length;
	DBLENGTH m_dwF5Length;
	DBLENGTH m_dwF6Length;
	DBLENGTH m_dwF7Length;
	DBLENGTH m_dwF8Length;
	DBLENGTH m_dwF9Length;
	DBLENGTH m_dwF10Length;
	DBLENGTH m_dwF11Length;
	DBLENGTH m_dwF12Length;
	DBLENGTH m_dwF13Length;
	DBLENGTH m_dwF14Length;
	DBLENGTH m_dwF15Length;
	DBLENGTH m_dwF16Length;
	DBLENGTH m_dwF17Length;
	DBLENGTH m_dwF18Length;
	DBLENGTH m_dwF19Length;


	void GetRowsetProperties(CDBPropSet* pPropSet)
	{
		pPropSet->AddProperty(DBPROP_CANFETCHBACKWARDS, true, DBPROPOPTIONS_OPTIONAL);
		pPropSet->AddProperty(DBPROP_CANSCROLLBACKWARDS, true, DBPROPOPTIONS_OPTIONAL);
		pPropSet->AddProperty(DBPROP_IRowsetChange, true, DBPROPOPTIONS_OPTIONAL);
		pPropSet->AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE);
	}

	HRESULT OpenDataSource()
	{
		CDataSource _db;
		HRESULT hr;
#error Security Issue: The connection string may contain a password
// 此连接字符串中可能包含明文密码和/或其他重要
// 信息。请在查看完此连接字符串并找到所有与安全
// 有关的问题后移除 #error。可能需要将此密码存
// 储为其他格式或使用其他的用户身份验证。
		hr = _db.OpenFromInitializationString(L"Provider=MSDASQL.1;Persist Security Info=False;User ID=hjhj;Data Source=Gongyi;Extended Properties=\"DSN=Gongyi;DBQ=C:\\Documents and Settings\\duan\\My Documents\\Book1.xls;DefaultDir=C:\\Documents and Settings\\duan\\My Documents;DriverId=790;FIL=excel 8.0;MaxBufferSize=2048;PageTimeout=5;UID=admin;\"");
		if (FAILED(hr))
		{
#ifdef _DEBUG
			AtlTraceErrorRecords(hr);
#endif
			return hr;
		}
		return m_session.Open(_db);
	}

	void CloseDataSource()
	{
		m_session.Close();
	}

	operator const CSession&()
	{
		return m_session;
	}

	CSession m_session;

	DEFINE_COMMAND_EX(CSheet1Accessor, L" \
	SELECT \
		`\x8868     \x673a\x68b0\x52a0\x5de5\x5de5\x827a\x8fc7\x7a0b\x5361\x7247`, \
		F2, \
		F3, \
		F4, \
		F5, \
		F6, \
		F7, \
		F8, \
		F9, \
		F10, \
		F11, \
		F12, \
		F13, \
		F14, \
		F15, \
		F16, \
		F17, \
		F18, \
		F19 \
		FROM `Sheet1$`")


	// 为解决某些提供程序的若干问题，以下代码可能以
	// 不同于提供程序所报告的顺序来绑定列

	BEGIN_COLUMN_MAP(CSheet1Accessor)
		COLUMN_ENTRY_LENGTH_STATUS(1, m_column0, m_dwcolumn0Length, m_dwcolumn0Status)
		COLUMN_ENTRY_LENGTH_STATUS(2, m_F2, m_dwF2Length, m_dwF2Status)
		COLUMN_ENTRY_LENGTH_STATUS(3, m_F3, m_dwF3Length, m_dwF3Status)
		COLUMN_ENTRY_LENGTH_STATUS(4, m_F4, m_dwF4Length, m_dwF4Status)
		COLUMN_ENTRY_LENGTH_STATUS(5, m_F5, m_dwF5Length, m_dwF5Status)
		COLUMN_ENTRY_LENGTH_STATUS(6, m_F6, m_dwF6Length, m_dwF6Status)
		COLUMN_ENTRY_LENGTH_STATUS(7, m_F7, m_dwF7Length, m_dwF7Status)
		COLUMN_ENTRY_LENGTH_STATUS(8, m_F8, m_dwF8Length, m_dwF8Status)
		COLUMN_ENTRY_LENGTH_STATUS(9, m_F9, m_dwF9Length, m_dwF9Status)
		COLUMN_ENTRY_LENGTH_STATUS(10, m_F10, m_dwF10Length, m_dwF10Status)
		COLUMN_ENTRY_LENGTH_STATUS(11, m_F11, m_dwF11Length, m_dwF11Status)
		COLUMN_ENTRY_LENGTH_STATUS(12, m_F12, m_dwF12Length, m_dwF12Status)
		COLUMN_ENTRY_LENGTH_STATUS(13, m_F13, m_dwF13Length, m_dwF13Status)
		COLUMN_ENTRY_LENGTH_STATUS(14, m_F14, m_dwF14Length, m_dwF14Status)
		COLUMN_ENTRY_LENGTH_STATUS(15, m_F15, m_dwF15Length, m_dwF15Status)
		COLUMN_ENTRY_LENGTH_STATUS(16, m_F16, m_dwF16Length, m_dwF16Status)
		COLUMN_ENTRY_LENGTH_STATUS(17, m_F17, m_dwF17Length, m_dwF17Status)
		COLUMN_ENTRY_LENGTH_STATUS(18, m_F18, m_dwF18Length, m_dwF18Status)
		COLUMN_ENTRY_LENGTH_STATUS(19, m_F19, m_dwF19Length, m_dwF19Status)
	END_COLUMN_MAP()
};

class CSheet1 : public CCommand<CAccessor<CSheet1Accessor> >
{
public:
	HRESULT OpenAll()
	{
		HRESULT hr;
		hr = OpenDataSource();
		if (FAILED(hr))
			return hr;
		__if_exists(GetRowsetProperties)
		{
			CDBPropSet propset(DBPROPSET_ROWSET);
			__if_exists(HasBookmark)
			{
				if( HasBookmark() )
					propset.AddProperty(DBPROP_IRowsetLocate, true);
			}
			GetRowsetProperties(&propset);
			return OpenRowset(&propset);
		}
		__if_not_exists(GetRowsetProperties)
		{
			__if_exists(HasBookmark)
			{
				if( HasBookmark() )
				{
					CDBPropSet propset(DBPROPSET_ROWSET);
					propset.AddProperty(DBPROP_IRowsetLocate, true);
					return OpenRowset(&propset);
				}
			}
		}
		return OpenRowset();
	}

	HRESULT OpenRowset(DBPROPSET *pPropSet = NULL)
	{
		HRESULT hr = Open(m_session, NULL, pPropSet);
#ifdef _DEBUG
		if(FAILED(hr))
			AtlTraceErrorRecords(hr);
#endif
		return hr;
	}

	void CloseAll()
	{
		Close();
		ReleaseCommand();
		CloseDataSource();
	}
};