⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 adors.cpp

📁 Soul的源代码,类似于劲舞团之类的游戏
💻 CPP
📖 第 1 页 / 共 5 页
字号:
🔍
12345 

	VARIANT	v_ItemDate, v_ItemSN, v_ItemNo, v_OwnChar, v_ItemCount, v_ItemLevel,
		v_ItemCurSp, v_CurDurability, v_SpFtOption, v_SpScOption, v_SpTrOption, v_SpFrOption,
		v_NmFtOption, v_NmScOption, v_NmTrOption;

	v_ItemDate.vt = VT_INT;
	v_ItemDate.intVal = pData->Item[0].iItemDate;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@IDt", adInteger, adParamInput, 4, v_ItemDate));

	v_ItemSN.vt = VT_I4;
	v_ItemSN.iVal = pData->Item[0].wItemSN;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@ITSN", adSmallInt, adParamInput, 2, v_ItemSN));
	
	v_ItemNo.vt = VT_I4;
	v_ItemNo.iVal = pData->Item[0].wItemNo;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@ITNo", adSmallInt, adParamInput, 2, v_ItemNo));

	v_OwnChar.vt = VT_BSTR;
	v_OwnChar.bstrVal = name;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@OChar", adVarChar, adParamInput, 16, v_OwnChar));

	v_ItemCount.vt = VT_INT;
	v_ItemCount.intVal = pData->Item[0].dwItemCount;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@ITCT", adInteger, adParamInput, 4, v_ItemCount));

	v_ItemLevel.vt = adTinyInt;	
	v_ItemNo.iVal = pData->Item[0].bItemLevel;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@ITLV", adTinyInt, adParamInput, 1, v_ItemLevel));

	v_ItemCurSp.vt = VT_INT;	
	v_ItemCurSp.intVal = pData->Item[0].dwItemCurSp;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@ITCS", adInteger, adParamInput, 4, v_ItemCurSp));

	v_CurDurability.vt = VT_I4;
	v_CurDurability.intVal = pData->Item[0].wCurDurability;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@CD", adSmallInt, adParamInput, 2, v_CurDurability));

	v_SpFtOption.vt = adTinyInt;	
	v_SpFtOption.bVal = pData->Item[0].bSpFtOption;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@SpFtO", adTinyInt, adParamInput, 1, v_SpFtOption));

	v_SpScOption.vt = adTinyInt;	
	v_SpScOption.bVal = pData->Item[0].bSpScOption;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@SpScO", adTinyInt, adParamInput, 1, v_SpScOption));

	v_SpTrOption.vt = adTinyInt;	
	v_SpTrOption.bVal = pData->Item[0].bSpTrOption;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@SpTrO", adTinyInt, adParamInput, 1, v_SpTrOption));
	
	v_SpFrOption.vt = adTinyInt;	
	v_SpFrOption.bVal = pData->Item[0].bSpFrOption;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@SpFrO", adTinyInt, adParamInput, 1, v_SpFrOption));

	v_NmFtOption.vt = adTinyInt;	
	v_NmFtOption.bVal = pData->Item[0].bNmFtOption;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@NmFtO", adTinyInt, adParamInput, 1, v_NmFtOption));

	v_NmScOption.vt = adTinyInt;	
	v_NmScOption.bVal = pData->Item[0].bNmScOption;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@NmScO", adTinyInt, adParamInput, 1, v_NmScOption));

	v_NmTrOption.vt = adTinyInt;	
	v_NmTrOption.bVal = pData->Item[0].bNmTrOption;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@NMTrO", adTinyInt, adParamInput, 1, v_NmTrOption));

	m_pCmdPtr->Execute(NULL, NULL, adCmdStoredProc );

	for( int i = 1; i < 150; i++ )
	{
		m_pCmdPtr->GetParameters()->GetItem("@IDt")->PutValue(pData->Item[i].iItemDate);
		m_pCmdPtr->GetParameters()->GetItem("@ITSN")->PutValue(pData->Item[i].wItemSN);
		m_pCmdPtr->GetParameters()->GetItem("@ITNo")->PutValue(pData->Item[i].wItemNo);
		m_pCmdPtr->GetParameters()->GetItem("@ITCT")->PutValue(pData->Item[i].dwItemCount);
		m_pCmdPtr->GetParameters()->GetItem("@ITLV")->PutValue(pData->Item[i].bItemLevel);
		m_pCmdPtr->GetParameters()->GetItem("@ITCS")->PutValue(pData->Item[i].dwItemCurSp);
		m_pCmdPtr->GetParameters()->GetItem("@CD")->PutValue(pData->Item[i].wCurDurability);
		m_pCmdPtr->GetParameters()->GetItem("@SpFtO")->PutValue(pData->Item[i].bSpFtOption);
		m_pCmdPtr->GetParameters()->GetItem("@SpScO")->PutValue(pData->Item[i].bSpScOption);
		m_pCmdPtr->GetParameters()->GetItem("@SpTrO")->PutValue(pData->Item[i].bSpTrOption);
		m_pCmdPtr->GetParameters()->GetItem("@SpFrO")->PutValue(pData->Item[i].bSpFrOption);
		m_pCmdPtr->GetParameters()->GetItem("@NmFtO")->PutValue(pData->Item[i].bNmFtOption);
		m_pCmdPtr->GetParameters()->GetItem("@NmScO")->PutValue(pData->Item[i].bNmScOption);
		m_pCmdPtr->GetParameters()->GetItem("@NMTrO")->PutValue(pData->Item[i].bNmTrOption);
		m_pCmdPtr->Execute(NULL, NULL, adCmdStoredProc );
	}
	SysFreeString(v_OwnChar.bstrVal);
}
//------------------------------------------------------------------------------
void ADORs::AddNewItem1Data(_ConnectionPtr pConn, _bstr_t name)
{// 150俺甫 Insert
	m_pCmdPtr->ActiveConnection = pConn;
	m_pCmdPtr->CommandText = "sp_itemIn";
	m_pCmdPtr->CommandTimeout = 15;

	VARIANT	v_szname;
	v_szname.vt = VT_BSTR;
	v_szname.bstrVal = name;
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@OChar", adVarChar, adParamInput, 16, v_szname));

	for( int i = 0; i < 150; i++ )
	{
		m_pCmdPtr->Execute(NULL, NULL, adCmdStoredProc );
	}
	SysFreeString(v_szname.bstrVal);
}
//------------------------------------------------------------------------------
// 2. item 抛捞喉 + index 抛胶飘 
//------------------------------------------------------------------------------
void ADORs::UpdateItem2Data(_ConnectionPtr pConn, _bstr_t name, INVEN_STRT *pData, int si)
{// 150俺 Update
// update狼 版快 Item1 抛捞喉俊 Index甫 棱酒 初栏搁 鞍篮瓤苞甫 尘荐 乐促.
}
//------------------------------------------------------------------------------
// 150俺甫 Insert Char1 俊 1疙 Insert 饶 酒捞袍 150俺 Insert 饶 char1狼 Inven 俊 Item狼 Index甸阑 update 秦具茄促.
void ADORs::AddNewItem2Data(_ConnectionPtr pConn, _bstr_t name)
{

}
//------------------------------------------------------------------------------
void ADORs::AddNewChar1Data(_ConnectionPtr pConn, _bstr_t name)
{
	m_pCmdPtr->ActiveConnection = pConn;
	m_pCmdPtr->CommandText = "sp_charIn";
	m_pCmdPtr->CommandTimeout = 15;

	VARIANT	v_szname;
	v_szname.vt = VT_BSTR;
	v_szname.bstrVal = name;

	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@AID", adVarChar, adParamInput, 16, v_szname));

	m_pCmdPtr->Execute(NULL, NULL, adCmdStoredProc );
	SysFreeString(v_szname.bstrVal);
}
//------------------------------------------------------------------------------
bool ADORs::OpenItem2Data(_bstr_t name, _ConnectionPtr pConn, INDEX_STRT *pIndex)
{
	m_pCmdPtr->ActiveConnection = pConn;
	m_pCmdPtr->CommandText = "sp_itemSe2";
	m_pCmdPtr->CommandTimeout = 15;

	VARIANT	v_szname;
	v_szname.vt = VT_BSTR;
	v_szname.bstrVal = name;

	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@oname", adVarChar, adParamInput, 16, v_szname));
	m_pRs = m_pCmdPtr->Execute(NULL, NULL, adCmdStoredProc );

	m_pRs->QueryInterface( __uuidof(IADORecordBinding),(LPVOID*)&m_picRs);
	SysFreeString(v_szname.bstrVal);
	if( m_pRs->BOF )
	{
		m_pRs->Close();
		return false;
	}
	else
	{
		for( int i = 0; i < 150; i ++ )
		{
			m_picRs->BindToRecordset(&m_BindIndex);
			pIndex->dwIndex[i] = m_BindIndex.m_i_index1;
			m_pRs->MoveNext();
		}
		m_pRs->Close();
		return true;
	}	
}
//------------------------------------------------------------------------------
void ADORs::UpdateChar1Data(_ConnectionPtr pConn, _bstr_t name, INDEX_STRT *pIndex)
{
	m_pCmdPtr->ActiveConnection = pConn;
	m_pCmdPtr->CommandText = "sp_charUp";
	m_pCmdPtr->CommandTimeout = 15;

	VARIANT	v_szname;
	v_szname.vt = VT_BSTR;
	v_szname.bstrVal = name;

	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@AID", adVarChar, adParamInput, 16, v_szname));

	VARIANT v_index1,v_index2,v_index3,v_index4,v_index5,v_index6,v_index7,v_index8,v_index9,v_index10,
		v_index11,v_index12,v_index13,v_index14,v_index15,v_index16,v_index17,v_index18,v_index19,v_index20,
		v_index21,v_index22,v_index23,v_index24,v_index25,v_index26,v_index27,v_index28,v_index29,v_index30,
		v_index31,v_index32,v_index33,v_index34,v_index35,v_index36,v_index37,v_index38,v_index39,v_index40,
		v_index41,v_index42,v_index43,v_index44,v_index45,v_index46,v_index47,v_index48,v_index49,v_index50,
		v_index51,v_index52,v_index53,v_index54,v_index55,v_index56,v_index57,v_index58,v_index59,v_index60,
		v_index61,v_index62,v_index63,v_index64,v_index65,v_index66,v_index67,v_index68,v_index69,v_index70,
		v_index71,v_index72,v_index73,v_index74,v_index75,v_index76,v_index77,v_index78,v_index79,v_index80,
		v_index81,v_index82,v_index83,v_index84,v_index85,v_index86,v_index87,v_index88,v_index89,v_index90,
		v_index91,v_index92,v_index93,v_index94,v_index95,v_index96,v_index97,v_index98,v_index99,v_index100,
		v_index101,v_index102,v_index103,v_index104,v_index105,v_index106,v_index107,v_index108,v_index109,v_index110,
		v_index111,v_index112,v_index113,v_index114,v_index115,v_index116,v_index117,v_index118,v_index119,v_index120,
		v_index121,v_index122,v_index123,v_index124,v_index125,v_index126,v_index127,v_index128,v_index129,v_index130,
		v_index131,v_index132,v_index133,v_index134,v_index135,v_index136,v_index137,v_index138,v_index139,v_index140,
		v_index141,v_index142,v_index143,v_index144,v_index145,v_index146,v_index147,v_index148,v_index149,v_index150;

	v_index1.vt = VT_INT;
	v_index1.intVal = pIndex->dwIndex[0];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index1", adInteger, adParamInput, 4, v_index1));
	v_index2.vt = VT_INT;
	v_index2.intVal = pIndex->dwIndex[1];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index2", adInteger, adParamInput, 4, v_index2));
	v_index3.vt = VT_INT;
	v_index3.intVal = pIndex->dwIndex[2];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index3", adInteger, adParamInput, 4, v_index3));
	v_index4.vt = VT_INT;
	v_index4.intVal = pIndex->dwIndex[3];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index4", adInteger, adParamInput, 4, v_index4));
	v_index5.vt = VT_INT;
	v_index5.intVal = pIndex->dwIndex[4];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index5", adInteger, adParamInput, 4, v_index5));
	v_index6.vt = VT_INT;
	v_index6.intVal = pIndex->dwIndex[5];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index6", adInteger, adParamInput, 4, v_index6));
	v_index7.vt = VT_INT;
	v_index7.intVal = pIndex->dwIndex[6];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index7", adInteger, adParamInput, 4, v_index7));
	v_index8.vt = VT_INT;
	v_index8.intVal = pIndex->dwIndex[7];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index8", adInteger, adParamInput, 4, v_index8));
	v_index9.vt = VT_INT;
	v_index9.intVal = pIndex->dwIndex[8];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index9", adInteger, adParamInput, 4, v_index9));
	v_index10.vt = VT_INT;
	v_index10.intVal = pIndex->dwIndex[9];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index10", adInteger, adParamInput, 4, v_index10));

	v_index11.vt = VT_INT;
	v_index11.intVal = pIndex->dwIndex[10];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index11", adInteger, adParamInput, 4, v_index11));
	v_index12.vt = VT_INT;
	v_index12.intVal = pIndex->dwIndex[11];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index12", adInteger, adParamInput, 4, v_index12));
	v_index13.vt = VT_INT;
	v_index13.intVal = pIndex->dwIndex[12];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index13", adInteger, adParamInput, 4, v_index13));
	v_index14.vt = VT_INT;
	v_index14.intVal = pIndex->dwIndex[13];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index14", adInteger, adParamInput, 4, v_index14));
	v_index15.vt = VT_INT;
	v_index15.intVal = pIndex->dwIndex[14];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index15", adInteger, adParamInput, 4, v_index15));
	v_index16.vt = VT_INT;
	v_index16.intVal = pIndex->dwIndex[15];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index16", adInteger, adParamInput, 4, v_index16));
	v_index17.vt = VT_INT;
	v_index17.intVal = pIndex->dwIndex[16];
	m_pCmdPtr->Parameters->Append(m_pCmdPtr->CreateParameter("@index17", adInteger, adParamInput, 4, v_index17));
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -