本文整理汇总了C++中Transaction::addQuery方法的典型用法代码示例。如果您正苦于以下问题:C++ Transaction::addQuery方法的具体用法?C++ Transaction::addQuery怎么用?C++ Transaction::addQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Transaction
的用法示例。
在下文中一共展示了Transaction::addQuery方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C++代码示例。
示例1: applyMoney
//=============================================================================
//handles the financial side
//
void EntertainerManager::applyMoney(PlayerObject* customer,PlayerObject* designer,int32 amount)
{
int32 amountcash;
int32 amountbank;
int8 sql[1024];
amountcash = amount;
amountbank = 0;
Inventory* inventory = dynamic_cast<Inventory*>(customer->getEquipManager()->getEquippedObject(CreatureEquipSlot_Inventory));
if(inventory && inventory->getCredits() < amount)
{
// cash alone isnt sufficient
amountcash = inventory->getCredits();
amountbank = (amount - amountcash);
}
EntertainerManagerAsyncContainer* asyncContainer = new EntertainerManagerAsyncContainer(EMQuery_IDFinances,0);
Transaction* mTransaction = mDatabase->startTransaction(this,asyncContainer);
asyncContainer->customer = customer;
asyncContainer->performer = designer;
asyncContainer->amountcash = amountcash;
asyncContainer->amountbank = amountbank;
sprintf(sql,"UPDATE inventories SET credits=credits-%i WHERE id=%"PRIu64"",amountcash, customer->getId()+1);
mTransaction->addQuery(sql);
sprintf(sql,"UPDATE banks SET credits=credits-%i WHERE id=%"PRIu64"",amountbank, customer->getId()+4);
mTransaction->addQuery(sql);
sprintf(sql,"UPDATE banks SET credits=credits+%i WHERE id=%"PRIu64"",amount, designer->getId()+4);
mTransaction->addQuery(sql);
mTransaction->execute();
}