rsgrid1.cpp

利用OLEDB以数据库的方式打开Excell文件

BOOL CRsGrid::DeleteRow(long lStartLine, long lLineNum)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x69, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lStartLine, lLineNum);
	return result;
}

BOOL CRsGrid::SwapRow(long lRow1, long lRow2)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x6a, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lRow1, lRow2);
	return result;
}

BOOL CRsGrid::InsertColumn(long lColAfter, long lInsertCount)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x6b, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lColAfter, lInsertCount);
	return result;
}

BOOL CRsGrid::DeleteColumn(long lStartColumn, long lColumnCount)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x6c, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lStartColumn, lColumnCount);
	return result;
}

BOOL CRsGrid::SwapColumn(long lColumn1, long lColumn2)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x6d, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lColumn1, lColumn2);
	return result;
}

BOOL CRsGrid::InsertRow(long lRowAfter, long lInsertCount)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x6e, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lRowAfter, lInsertCount);
	return result;
}

BOOL CRsGrid::CopyRowToRow(long lRowTo, long lRowFrom)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x6f, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lRowTo, lRowFrom);
	return result;
}

BOOL CRsGrid::CopyColToCol(long lColTo, long lColFrom)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x70, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lColTo, lColFrom);
	return result;
}

BOOL CRsGrid::OrderByColumn(long lColumn, BOOL bAsString, BOOL bInc)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_BOOL VTS_BOOL;
	InvokeHelper(0x71, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lColumn, bAsString, bInc);
	return result;
}

BOOL CRsGrid::UserDefinedSort(LPUNKNOWN pfnSortFunction, BOOL bSortByRow)
{
	BOOL result;
	static BYTE parms[] =
		VTS_UNKNOWN VTS_BOOL;
	InvokeHelper(0x72, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		pfnSortFunction, bSortByRow);
	return result;
}

BOOL CRsGrid::SetFieldFloatPrecision(long lFieldIndex, short siPrecision)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I2;
	InvokeHelper(0x73, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lFieldIndex, siPrecision);
	return result;
}

double CRsGrid::SumOfColumn(long lColumn, long lStartRow, long lRowCount)
{
	double result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0x74, DISPATCH_METHOD, VT_R8, (void*)&result, parms,
		lColumn, lStartRow, lRowCount);
	return result;
}

BOOL CRsGrid::SetFieldDateFormat(long lField, BOOL UseNow, BOOL Is24, long dwType)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_BOOL VTS_BOOL VTS_I4;
	InvokeHelper(0x75, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lField, UseNow, Is24, dwType);
	return result;
}

BOOL CRsGrid::SetBoolIconHandle(long hIconTrue, long hIconFalse)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x76, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		hIconTrue, hIconFalse);
	return result;
}

BOOL CRsGrid::GetBoolIconHandle(long* phIconTrue, long* phIconFalse)
{
	BOOL result;
	static BYTE parms[] =
		VTS_PI4 VTS_PI4;
	InvokeHelper(0x77, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		phIconTrue, phIconFalse);
	return result;
}

BOOL CRsGrid::GetCellFromPos(long xPos, long yPos, long* pRow, long* pCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_PI4 VTS_PI4;
	InvokeHelper(0x78, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		xPos, yPos, pRow, pCol);
	return result;
}

short CRsGrid::GetFieldType(long lColumn)
{
	short result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x79, DISPATCH_METHOD, VT_I2, (void*)&result, parms,
		lColumn);
	return result;
}

BOOL CRsGrid::SetRowBackColor(long lRow, unsigned long crColor)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x7a, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lRow, crColor);
	return result;
}

BOOL CRsGrid::SelectRow(long lRow, BOOL bAddSel)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_BOOL;
	InvokeHelper(0x7b, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lRow, bAddSel);
	return result;
}

BOOL CRsGrid::SetFocusToCell(long lRow, long lCol)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x7c, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lRow, lCol);
	return result;
}

BOOL CRsGrid::OrderByColumnEx(LPCTSTR lpszOrderDesc, BOOL bAsString, BOOL bInc)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BOOL VTS_BOOL;
	InvokeHelper(0x7d, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszOrderDesc, bAsString, bInc);
	return result;
}

long CRsGrid::SetRowData(long lRow, long dwRowData)
{
	long result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x7e, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lRow, dwRowData);
	return result;
}

long CRsGrid::GetRowData(long lRow)
{
	long result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x7f, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
		lRow);
	return result;
}

CString CRsGrid::GetCellDisString(long lRow, long lCol)
{
	CString result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x80, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		lRow, lCol);
	return result;
}

BOOL CRsGrid::SetEventCode(LPCTSTR lpszEvent, LPCTSTR lpszCode)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR;
	InvokeHelper(0x81, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszEvent, lpszCode);
	return result;
}

CString CRsGrid::GetEventCode(LPCTSTR lpszEventName)
{
	CString result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x82, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
		lpszEventName);
	return result;
}

BOOL CRsGrid::WriteResToFile(LPCTSTR lpszFileNmae)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x83, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszFileNmae);
	return result;
}

BOOL CRsGrid::LoadFromResFile(LPCTSTR lpszResFile)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x84, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszResFile);
	return result;
}

long CRsGrid::WriteResToBlob()
{
	long result;
	InvokeHelper(0x85, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

BOOL CRsGrid::LoadResFromBlob(long hRes)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x86, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		hRes);
	return result;
}

double CRsGrid::GetCellNumber(long lRow, long lCol)
{
	double result;
	static BYTE parms[] =
		VTS_I4 VTS_I4;
	InvokeHelper(0x87, DISPATCH_METHOD, VT_R8, (void*)&result, parms,
		lRow, lCol);
	return result;
}

BOOL CRsGrid::SetCellNumber(long lRow, long lCol, double dblValue)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4 VTS_I4 VTS_R8;
	InvokeHelper(0x88, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lRow, lCol, dblValue);
	return result;
}

LPUNKNOWN CRsGrid::GetGridFootCellByName(LPCTSTR lpszName)
{
	LPUNKNOWN result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x89, DISPATCH_METHOD, VT_UNKNOWN, (void*)&result, parms,
		lpszName);
	return result;
}

BOOL CRsGrid::AddGridFootCell(LPCTSTR lpszName, long lLeft, long lTop, long lRight, long lBottom)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_I4;
	InvokeHelper(0x8a, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszName, lLeft, lTop, lRight, lBottom);
	return result;
}

void CRsGrid::SetPrintPageLineNum(long lNum)
{
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x8b, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 lNum);
}

void CRsGrid::SetOpFocus(BOOL bAtHead)
{
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0x8c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 bAtHead);
}

BOOL CRsGrid::LoadGridFootFromFile(LPCTSTR lpszFileName)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x8d, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszFileName);
	return result;
}

BOOL CRsGrid::LoadGridTitleFromFile(LPCTSTR lpszFileName)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x8e, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszFileName);
	return result;
}

BOOL CRsGrid::LoadReportTemplateFromFile(LPCTSTR lpszFileName)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x8f, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lpszFileName);
	return result;
}

void CRsGrid::SetBoolDisString(LPCTSTR lpszTrue, LPCTSTR lpszFalse)
{
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR;
	InvokeHelper(0x90, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 lpszTrue, lpszFalse);
}

void CRsGrid::SetPrintPreviewPageFormat(LPCTSTR lpszFormat)
{
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0x91, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 lpszFormat);
}

long CRsGrid::GetRowHeight()
{
	long result;
	InvokeHelper(0x92, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

void CRsGrid::SetGridTitleData(long hTitleData)
{
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x93, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 hTitleData);
}

void CRsGrid::SetGridFootData(long hFootData)
{
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x94, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 hFootData);
}

void CRsGrid::SetGridData(long hGridData)
{
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x95, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 hGridData);
}

long CRsGrid::GetGridTitleData()
{
	long result;
	InvokeHelper(0x96, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

long CRsGrid::GetGridFootData()
{
	long result;
	InvokeHelper(0x97, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

long CRsGrid::GetGridData()
{
	long result;
	InvokeHelper(0x98, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

long CRsGrid::GetReportTemplateData()
{
	long result;
	InvokeHelper(0x99, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

long CRsGrid::GetResData()
{
	long result;
	InvokeHelper(0x9a, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

void CRsGrid::SetResData(long nNewValue)
{
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x9b, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 nNewValue);
}

long CRsGrid::GetEventCodes()
{
	long result;
	InvokeHelper(0x9c, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

void CRsGrid::SetEventCodes(long nNewValue)
{
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x9d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 nNewValue);
}

long CRsGrid::GetPictureData()
{
	long result;
	InvokeHelper(0x9e, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
	return result;
}

void CRsGrid::SetPictureData(long nNewValue)
{
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0x9f, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 nNewValue);
}

void CRsGrid::SetPreviewWndCaption(LPCTSTR lpszCaption)
{
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0xa0, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 lpszCaption);
}

BOOL CRsGrid::IsRowSelected(long lRow)
{
	BOOL result;
	static BYTE parms[] =
		VTS_I4;
	InvokeHelper(0xa1, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		lRow);
	return result;
}

BOOL CRsGrid::SetPrintParam(BOOL bTextWrap, BOOL bWrapAcrossPage, BOOL bPrintPageNo)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BOOL VTS_BOOL VTS_BOOL;
	InvokeHelper(0xa2, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		bTextWrap, bWrapAcrossPage, bPrintPageNo);
	return result;
}

void CRsGrid::SetPaperSize(short iPaperIdex, short iPaperLength, short iPaperWidth)
{
	static BYTE parms[] =
		VTS_I2 VTS_I2 VTS_I2;
	InvokeHelper(0xa3, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 iPaperIdex, iPaperLength, iPaperWidth);
}

BOOL CRsGrid::OpenDatabase(LPCTSTR bstrServerName, LPCTSTR bstrDatabaseName, LPCTSTR bstrUserName, LPCTSTR bstrPassword, LPCTSTR bstrOptions)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR VTS_BSTR VTS_BSTR VTS_BSTR;
	InvokeHelper(0xa4, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		bstrServerName, bstrDatabaseName, bstrUserName, bstrPassword, bstrOptions);
	return result;
}

BOOL CRsGrid::ExecSQL(LPCTSTR bstrSQL)
{
	BOOL result;
	static BYTE parms[] =
		VTS_BSTR;
	InvokeHelper(0xa5, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
		bstrSQL);
	return result;
}

void CRsGrid::SetDBGridMode(BOOL bIsDBGrid)
{
	static BYTE parms[] =
		VTS_BOOL;
	InvokeHelper(0xa6, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 bIsDBGrid);
}

void CRsGrid::DBAddField(LPCTSTR strFieldName, LPCTSTR strFieldDisName)
{
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR;
	InvokeHelper(0xab, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 strFieldName, strFieldDisName);
}

void CRsGrid::DBAddPrimaryKey(LPCTSTR strPkName, LPCTSTR strPkDisName)
{
	static BYTE parms[] =
		VTS_BSTR VTS_BSTR;
	InvokeHelper(0xac, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
		 strPkName, strPkDisName);
}