自学教程：C++ storedProcErrorLookup函数代码示例

void freightClasses::sDelete(){  XSqlQuery freightDelete;  freightDelete.prepare("SELECT deleteFreightClass(:freightclass_id) AS result;");  freightDelete.bindValue(":freightclass_id", _freightClass->id());  freightDelete.exec();  if (freightDelete.first())  {    int result = freightDelete.value("result").toInt();    if (result < 0)    {      systemError(this, storedProcErrorLookup("deleteFreightClass", result),                  __FILE__, __LINE__);      return;    }  }  else if (freightDelete.lastError().type() != QSqlError::NoError)  {    systemError(this, freightDelete.lastError().databaseText(), __FILE__, __LINE__);    return;  }  sFillList(-1);}

void dspUnbalancedQOHByClassCode::sBalance(){  XSqlQuery dspBalance;  dspBalance.prepare("SELECT balanceItemsite(:itemsite_id) AS result;");  dspBalance.bindValue(":itemsite_id", list()->id());  dspBalance.exec();  if (dspBalance.first())  {    int result = dspBalance.value("result").toInt();    if (result < 0)    {      systemError(this, storedProcErrorLookup("balanceItemsite", result),                  __FILE__, __LINE__);      return;    }  }  else if (dspBalance.lastError().type() != QSqlError::NoError)  {    systemError(this, dspBalance.lastError().databaseText(), __FILE__, __LINE__);    return;  }  sFillList();}

void maintainShipping::sReturnAllStock(){  XSqlQuery maintainReturnAllStock;  XSqlQuery rollback;  rollback.prepare("ROLLBACK;");  maintainReturnAllStock.exec("BEGIN");  maintainReturnAllStock.prepare("SELECT returnShipmentTransaction(:ship_id) AS result;");  maintainReturnAllStock.bindValue(":ship_id", _ship->altId());  maintainReturnAllStock.exec();  if (maintainReturnAllStock.first())  {    int result = maintainReturnAllStock.value("result").toInt();    if (maintainReturnAllStock.value("result").toInt() < 0)    {      rollback.exec();      systemError(this,		  storedProcErrorLookup("returnShipmentTransaction", result),		  __FILE__, __LINE__);      return;    }    else if (distributeInventory::SeriesAdjust(result, this) == XDialog::Rejected)    {      rollback.exec();      QMessageBox::information( this, tr("Issue to Shipping"), tr("Return Canceled") );      return;    }        maintainReturnAllStock.exec("COMMIT;");     sFillList();  }  else if (maintainReturnAllStock.lastError().type() != QSqlError::NoError)  {    rollback.exec();    systemError(this, maintainReturnAllStock.lastError().databaseText(), __FILE__, __LINE__);    return;  }}

void customerTypes::sDelete(){  XSqlQuery customerDelete;  customerDelete.prepare("SELECT deleteCustomerType(:custtype_id) AS result;");  customerDelete.bindValue(":custtype_id", _custtype->id());  customerDelete.exec();  if (customerDelete.first())  {    int result = customerDelete.value("result").toInt();    if (result < 0)    {      ErrorReporter::error(QtCriticalMsg, this, tr("Error Deleting Customer Type"),                             storedProcErrorLookup("deleteCustomerType", result),                             __FILE__, __LINE__);      return;    }  }  else if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Deleting Customer Type"),                                customerDelete, __FILE__, __LINE__))  {    return;  }  sFillList();}

void user::sRevokeAll(){    XSqlQuery privq;    privq.prepare("SELECT revokeAllModulePriv(:username, :module) AS result;");    privq.bindValue(":username", _cUsername);    privq.bindValue(":module", _module->currentText());    privq.exec();    if (privq.first())    {        int result = privq.value("result").toInt();        if (result < 0)        {            ErrorReporter::error(QtCriticalMsg, this, tr("Revoking Privileges"),                                 storedProcErrorLookup("revokeAllModulePriv", result),                                 __FILE__, __LINE__);            return;        }    }    else if (ErrorReporter::error(QtCriticalMsg, this, tr("Revoking Privileges"),                                  privq, __FILE__, __LINE__))        return;    sModuleSelected(_module->currentText());}

void selectOrderForBilling::sSelectBalance(){  XSqlQuery selectSelectBalance;  selectSelectBalance.prepare("SELECT selectBalanceForBilling(:sohead_id) AS result;");  selectSelectBalance.bindValue(":sohead_id", _so->id());  selectSelectBalance.exec();  if (selectSelectBalance.first())  {    int result = selectSelectBalance.value("result").toInt();    if (result < 0)    {      systemError(this, storedProcErrorLookup("selectBalanceForBilling", result),		  __FILE__, __LINE__);      return;    }  }  else if (selectSelectBalance.lastError().type() != QSqlError::NoError)  {    systemError(this, selectSelectBalance.lastError().databaseText(), __FILE__, __LINE__);    return;  }  sFillList();}

void bankAdjustmentEditList::sPost(){  XSqlQuery bankPost;  bankPost.prepare("SELECT postBankAdjustment(:bankadjid) AS result;");  bankPost.bindValue(":bankadjid", _adjustments->id());  bankPost.exec();  if (bankPost.first())  {    int result = bankPost.value("result").toInt();    if (result < 0)    {      ErrorReporter::error(QtCriticalMsg, this, tr("Error Posting Bank Adjustment"),                           storedProcErrorLookup("postBankAdjustment", result),                           __FILE__, __LINE__);      return;    }    sFillList();  }  else if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Posting Bank Adjustment"),                                bankPost, __FILE__, __LINE__))  {    return;  }}

void dspUnbalancedQOHByClassCode::sBalance(){  XSqlQuery dspBalance;  dspBalance.prepare("SELECT balanceItemsite(:itemsite_id) AS result;");  dspBalance.bindValue(":itemsite_id", list()->id());  dspBalance.exec();  if (dspBalance.first())  {    int result = dspBalance.value("result").toInt();    if (result < 0)    {      ErrorReporter::error(QtCriticalMsg, this, tr("Error Retrieving Item Information"),                             storedProcErrorLookup("balanceItemsite", result),                             __FILE__, __LINE__);      return;    }  }  else if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Retrieving Item Information"),                                dspBalance, __FILE__, __LINE__))  {    return;  }  sFillList();}

void empGroups::sDelete(){  XSqlQuery empDelete;  empDelete.prepare( "SELECT deleteEmpgrp(:grpid) AS result;");  empDelete.bindValue(":grpid", _empgrp->id());  empDelete.exec();  if (empDelete.first())  {    int result = empDelete.value("result").toInt();    if (result < 0)    {      systemError(this, storedProcErrorLookup("deleteEmpgrp", result),                  __FILE__, __LINE__);      return;    }  }  else if (empDelete.lastError().type() != QSqlError::NoError)  {    systemError(this, empDelete.lastError().databaseText(), __FILE__, __LINE__);    return;  }  sFillList();}

void budgets::sDelete(){  XSqlQuery budgetsDelete;  budgetsDelete.prepare( "SELECT deleteBudget(:budghead_id) AS result;");  budgetsDelete.bindValue(":budghead_id", _budget->id());  budgetsDelete.exec();  if (budgetsDelete.first())  {    int result = budgetsDelete.value("result").toInt();    if (result < 0)    {      systemError(this, storedProcErrorLookup("deleteBudget", result),                  __FILE__, __LINE__);      return;    }  }  else if (budgetsDelete.lastError().type() != QSqlError::NoError)  {    systemError(this, budgetsDelete.lastError().databaseText(), __FILE__, __LINE__);    return;  }  sFillList();}

void applyAPCreditMemo::sApplyBalance(){  XSqlQuery applyApplyBalance;  applyApplyBalance.prepare("SELECT applyAPCreditMemoToBalance(:apopen_id) AS result;");  applyApplyBalance.bindValue(":apopen_id", _apopenid);  applyApplyBalance.exec();  if (applyApplyBalance.first())  {    int result = applyApplyBalance.value("result").toInt();    if (result < 0)    {      systemError(this, storedProcErrorLookup("applyAPCreditMemoToBalance",                                              result), __FILE__, __LINE__);      return;    }  }  else if (applyApplyBalance.lastError().type() != QSqlError::NoError)  {    systemError(this, applyApplyBalance.lastError().databaseText(), __FILE__, __LINE__);    return;  }  populate();}

void characteristics::sDelete(){  q.prepare("SELECT deleteCharacteristic(:char_id) AS result;");  q.bindValue(":char_id", _char->id());  q.exec();  if (q.first())  {    int returnVal = q.value("result").toInt();    if (returnVal < 0)    {      QMessageBox::critical( this, tr("Cannot Delete Characteristic"),                             storedProcErrorLookup("deleteCharacteristic",						   returnVal));      return;    }    sFillList();  }  else if (q.lastError().type() != QSqlError::NoError)  {    systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);    return;  }}

void dspCheckRegister::sVoidPosted(){  XSqlQuery dspVoidPosted;  ParameterList params;  XDateInputDialog newdlg(this, "", true);  params.append("label", tr("On what date did you void this check?"));  newdlg.set(params);  int returnVal = newdlg.exec();  if (returnVal == XDialog::Accepted)  {    QDate voidDate = newdlg.getDate();    dspVoidPosted.prepare("SELECT voidPostedCheck(:check_id, fetchJournalNumber('AP-CK'),"	      "                         DATE :voidDate) AS result;");    dspVoidPosted.bindValue(":check_id", _check->id());    dspVoidPosted.bindValue(":voidDate", voidDate);    dspVoidPosted.exec();    if (dspVoidPosted.first())    {      int result = dspVoidPosted.value("result").toInt();      if (result < 0)      {        ErrorReporter::error(QtCriticalMsg, this, tr("Error Voiding Posted Check"),                               storedProcErrorLookup("voidPostedCheck", result),                               __FILE__, __LINE__);        return;      }    }    else if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Voiding Posted Check"),                                  dspVoidPosted, __FILE__, __LINE__))    {      return;    }  }  sFillList();}

void profitCenters::sDelete(){  XSqlQuery profitDelete;  profitDelete.prepare( "SELECT deleteProfitCenter(:id) AS result;" );  profitDelete.bindValue(":id", _prftcntr->id());  profitDelete.exec();  if (profitDelete.first())  {    int result = profitDelete.value("result").toInt();    if (result < 0)    {      systemError(this, storedProcErrorLookup("deleteProfitCenter", result),                  __FILE__, __LINE__);      return;    }  }  else if (profitDelete.lastError().type() != QSqlError::NoError)  {    systemError(this, profitDelete.lastError().databaseText(), __FILE__, __LINE__);    return;  }  sFillList();}