void GetAllVisiter(int64 ParentID, vector<int64>& VisiterList,int64 NotIncludeChildID/*=0*/){
char TableName[30];
int64toa(ParentID,TableName);
if(!GetWorldDB().tableExists(TableName)){
return ;
}
CppSQLite3Buffer SQL;
SQL.format("select %s from \"%s\" where %s>%d",
ITEM_ID,
TableName,
ITEM_TYPE,
OBJECT_SPACE
);
CppSQLite3Query Result = GetWorldDB().execQuery(SQL);
if(Result.eof())return ;
while(!Result.eof()){
int64 ChildID = Result.getInt64Field(0);
if (ChildID != NotIncludeChildID)
{
VisiterList.push_back(ChildID);
}
Result.nextRow();
}
}
bool CWizIndexBase::SQLToDocumentAttachmentDataArray(const CString& strSQL,
CWizDocumentAttachmentDataArray& arrayAttachment)
{
try
{
CppSQLite3Query query = m_db.execQuery(strSQL);
while (!query.eof())
{
WIZDOCUMENTATTACHMENTDATA data;
data.strKbGUID = kbGUID();
data.strGUID = query.getStringField(documentattachmentATTACHMENT_GUID);
data.strDocumentGUID = query.getStringField(documentattachmentDOCUMENT_GUID);
data.strName = query.getStringField(documentattachmentATTACHMENT_NAME);
data.strURL = query.getStringField(documentattachmentATTACHMENT_URL);
data.strDescription = query.getStringField(documentattachmentATTACHMENT_DESCRIPTION);
data.tInfoModified = query.getTimeField(documentattachmentDT_INFO_MODIFIED);
data.strInfoMD5 = query.getStringField(documentattachmentATTACHMENT_INFO_MD5);
data.tDataModified = query.getTimeField(documentattachmentDT_DATA_MODIFIED);
data.strDataMD5 = query.getStringField(documentattachmentATTACHMENT_DATA_MD5);
data.nVersion = query.getInt64Field(documentattachmentVersion);
arrayAttachment.push_back(data);
query.nextRow();
}
std::sort(arrayAttachment.begin(), arrayAttachment.end());
return true;
}
catch (const CppSQLite3Exception& e)
{
return LogSQLException(e, strSQL);
}
}
//##ModelId=474D307602CF
bool CClip_ImportExport::ImportFromSqliteDB(CppSQLite3DB &db, bool bAddToDB, bool bPutOnClipboard)
{
bool bRet = false;
CStringA csCF_TEXT;
CStringW csCF_UNICODETEXT;
try
{
CppSQLite3Query q = db.execQuery(_T("Select * from Main"));
while(q.eof() == false)
{
Clear();
int nVersion = q.getIntField(_T("lVersion"));
if(nVersion == 1)
{
if(ImportFromSqliteV1(db, q))
{
if(bAddToDB)
{
MakeLatestTime();
AddToDB(true);
bRet = true;
}
else if(bPutOnClipboard)
{
bRet = true;
}
}
}
m_lImportCount++;
//If putting on the clipboard and there are multiple
//then append cf_text and cf_unicodetext
if(bPutOnClipboard)
{
Append_CF_TEXT_AND_CF_UNICODETEXT(csCF_TEXT, csCF_UNICODETEXT);
}
q.nextRow();
}
if(bRet && bAddToDB)
{
theApp.RefreshView();
}
else if(bRet && m_lImportCount == 1 && bPutOnClipboard)
{
PlaceFormatsOnclipboard();
}
else if(bRet && bPutOnClipboard)
{
PlaceCF_TEXT_AND_CF_UNICODETEXT_OnClipboard(csCF_TEXT, csCF_UNICODETEXT);
}
}
CATCH_SQLITE_EXCEPTION_AND_RETURN(false)
return bRet;
}
// Allocates a new CClipTypes
CClipTypes* CCP_MainApp::LoadTypesFromDB()
{
CClipTypes* pTypes = new CClipTypes;
try
{
CppSQLite3Query q = theApp.m_db.execQuery(_T("SELECT TypeText FROM Types"));
while(q.eof() == false)
{
pTypes->Add(GetFormatID(q.getStringField(_T("TypeText"))));
q.nextRow();
}
}
CATCH_SQLITE_EXCEPTION
if(pTypes->GetSize() <= 0)
{
pTypes->Add(CF_TEXT);
pTypes->Add(RegisterClipboardFormat(CF_RTF));
pTypes->Add(CF_UNICODETEXT);
pTypes->Add(CF_HDROP);
if(g_Opt.m_bU3 == false)
{
pTypes->Add(CF_DIB);
}
}
return pTypes;
}
vector<lip> limitIP::GetIPList()
{
vector<lip> lips;
__try
{
CppSQLite3Query query = m_pDB.execQuery(_T("SELECT IP,Remark FROM IPfliter"));
while (!query.eof())
{
lip l;
l.szIP = query.getStringField(_T("IP"));
l.remark = query.getStringField(_T("Remark"));
lips.push_back(l);
query.nextRow();
}
return lips;
}
__except (Global::MyUnhandledExceptionFilter(GetExceptionInformation()))
{
return lips;
}
}
/*
int32 CBrainMemory::GetAllMeaning(int64 ID, map<int64,int64>
&MeaningList){
CppSQLite3Buffer SQL;
CppSQLite3Query Result;
char a[30];
char b[30];
MeaningList.clear();
// if(!RBrainHasTable(ID))return 0;
ToRBrain(ID);
SQL.format("select %s, %s from \"%s\" where %s=\"%s\" ;",
RB_SPACE_ID,
RB_SPACE_VALUE,
_i64toa(ID,a,10),
RB_SPACE_TYPE,
_i64toa(MEMORY_TYPE_MEANING,b,10)
);
Result = BrainDB.execQuery(SQL);
while(!Result.eof())
{
MeaningList[Result.getInt64Field(1)] = Result.getInt64Field(0);
Result.nextRow();
}
return MeaningList.size();
}
*/
int32 CBrainMemory::GetAllMeaningRoomID(int64 ID, deque<int64>& MeaningRoomIDList){
CppSQLite3Buffer SQL;
CppSQLite3Query Result;
char a[30],b[30];
MeaningRoomIDList.clear();
// if(!RBrainHasTable(ID))return 0;
ToRBrain(ID);
int64toa(ID,a);
int64toa(MEMORY_BODY,b);
SQL.format("select %s from \"%s\" where %s > \"%s\";",
RB_SPACE_ID,
a,
RB_SPACE_TYPE,
b
);
Result = BrainDB.execQuery(SQL);
while(!Result.eof())
{
MeaningRoomIDList.push_back(Result.getInt64Field(0));
Result.nextRow();
}
return MeaningRoomIDList.size();
}
bool CWizIndexBase::SQLToStyleDataArray(const CString& strSQL, CWizStyleDataArray& arrayStyle)
{
try
{
CppSQLite3Query query = m_db.execQuery(strSQL);
while (!query.eof())
{
WIZSTYLEDATA data;
data.strKbGUID = kbGUID();
data.strGUID = query.getStringField(styleSTYLE_GUID);
data.strName = query.getStringField(styleSTYLE_NAME);
data.strDescription = query.getStringField(styleSTYLE_DESCRIPTION);
data.crTextColor = query.getColorField(styleSTYLE_TEXT_COLOR);
data.crBackColor = query.getColorField(styleSTYLE_BACK_COLOR);
data.bTextBold = query.getBoolField(styleSTYLE_TEXT_BOLD);
data.nFlagIndex = query.getIntField(styleSTYLE_FLAG_INDEX);
data.tModified = query.getTimeField(styleDT_MODIFIED);
data.nVersion = query.getInt64Field(styleVersion);
arrayStyle.push_back(data);
query.nextRow();
}
std::sort(arrayStyle.begin(), arrayStyle.end());
return true;
}
catch (const CppSQLite3Exception& e)
{
return LogSQLException(e, strSQL);
}
}
bool CWizIndexBase::SQLToBizUserDataArray(const QString& strSQL,
CWizBizUserDataArray& arrayUser)
{
try
{
CppSQLite3Query query = m_db.execQuery(strSQL);
while (!query.eof())
{
WIZBIZUSER data;
data.bizGUID = query.getStringField(userBIZ_GUID);
data.userId = query.getStringField(userUSER_ID);
data.userGUID = query.getStringField(userUSER_GUID);
data.alias = query.getStringField(userUSER_ALIAS);
data.pinyin = query.getStringField(userUSER_PINYIN);
arrayUser.push_back(data);
query.nextRow();
}
return true;
}
catch (const CppSQLite3Exception& e)
{
return LogSQLException(e, strSQL);
}
}
void UNotifySummaryList::loadDataSource()
{
CppSQLite3Query src;
UNotifySummaryDataSource::queryData(src);
while(!src.eof()){
UNotifySummaryDataField dest;
UNotifySummaryDataSource::parseDataField(src, dest);
UNotifySummary* info = new UNotifySummary;
quint8 type = dest.notifyType;
Mi::NotifyCategory notifyType = (Mi::NotifyCategory)type;
info->setNotifyType(notifyType);
info->setNotifyID(dest.notifyID);
info->setNotifyName(dest.notifyName);
info->setNotifyContent(dest.notifyContent);
info->setNotifyTime(dest.notifyTime);
info->setUnreadCount(dest.unreadCount);
info->setNotifyImg(dest.portraitPath);
this->insertList(info);
src.nextRow();
}
}
//Método que monta as tab do Tab Control
void CRcGen::GetGrupos(WPARAM wParam, CStringArray& arrayGrp)
{
CStringA sQuery;
sQuery.Format("select distinct res.grupo, resgrupo.descricao from res, resgrupo where res.grupo = resgrupo.grupo and res.pagina between %d and %d", LOWORD(wParam), HIWORD(wParam));
try
{
CppSQLite3Query q = CppSQLite3DB::getInstance()->execQuery(sQuery);
if(!q.eof())
{
m_nGrupo = q.getIntField(0);
m_nGrupoInicial = m_nGrupo;
}
while(!q.eof())
{
arrayGrp.Add(CString(q.getStringField(1)));
q.nextRow();
}
}
catch(CppSQLite3Exception e)
{
}
}
//private
void RPGMapItemsMenuLayer::loadItemsData()
{
//道具数据
this->m_itemsList->removeAllObjects();
CppSQLite3Query query = this->m_db->execQuery(ITEMS_EXISTING_QUERY);
while(!query.eof())
{
RPGExistingItems *itemsData = RPGExistingItems::create();
itemsData->m_dataId = query.getIntField("id");
itemsData->m_name = query.getStringField("name_cns");
itemsData->m_buy = query.getIntField("buy");
itemsData->m_sell = query.getIntField("sell");
itemsData->m_type = query.getIntField("type");
itemsData->m_attack = query.getFloatField("attack");
itemsData->m_defense = query.getFloatField("defense");
itemsData->m_speed = query.getFloatField("speed");
itemsData->m_skillAttack = query.getFloatField("skill_attack");
itemsData->m_skillDefense = query.getFloatField("skill_defense");
itemsData->m_total = query.getIntField("total");
this->m_itemsList->addObject(itemsData);
query.nextRow();
}
query.finalize();
CCTableView *tableView = (CCTableView*)this->getChildByTag(kRPGMapItemsMenuLayerTagItemListTable);
tableView->reloadData();
}
BOOL CStaticDataMgr::ProcessDBFile( std::string strDbFile )
{
try
{
m_DBConnection.open(strDbFile.c_str());
}
catch(CppSQLite3Exception& e)
{
printf("%s",e.errorMessage());
return FALSE;
}
CppSQLite3Query TableNames = m_DBConnection.execQuery("SELECT name FROM sqlite_master WHERE type='table' ORDER BY name");
while(!TableNames.eof())
{
std::string strSql ="SELECT * from ";
std::string strTbName = TableNames.getStringField("name", NULL);
strSql += strTbName;
CppSQLite3Query Tabledatas = m_DBConnection.execQuery(strSql.c_str());
ProcessTable(strTbName, Tabledatas);
TableNames.nextRow();
}
m_DBConnection.close();
return TRUE;
}
BOOL FireFox3PlugIn::ExportFavoriteData( PFAVORITELINEDATA* ppData, int32& nDataNum )
{
memset(ppData,0x0, nDataNum*sizeof(PFAVORITELINEDATA));
if (ppData == NULL || *ppData == NULL || nDataNum == 0)
{
return FALSE;
}
string strSql = "select marks.* from moz_bookmarks as marks where marks.id in (2,3,4,5)";
CppSQLite3Query Query = m_pSqliteDatabase->execQuery(strSql.c_str());
// 当前插入的位置
int nCurrentIndex = 0;
while(!Query.eof())
{
int nId = Query.getIntField("id", 0);
ExportFavoriteData(nId,ppData,nCurrentIndex);
Query.nextRow();
}
nDataNum = nCurrentIndex;
return TRUE;
}
bool CWizIndexBase::SQLToTagDataArray(const CString& strSQL, CWizTagDataArray& arrayTag)
{
try
{
CppSQLite3Query query = m_db.execQuery(strSQL);
while (!query.eof())
{
WIZTAGDATA data;
data.strKbGUID = kbGUID();
data.strGUID = query.getStringField(tagTAG_GUID);
data.strParentGUID = query.getStringField(tagTAG_GROUP_GUID);
data.strName = query.getStringField(tagTAG_NAME);
data.strDescription = query.getStringField(tagTAG_DESCRIPTION);
data.tModified = query.getTimeField(tagDT_MODIFIED);
data.nVersion = query.getInt64Field(tagVersion);
arrayTag.push_back(data);
query.nextRow();
}
std::sort(arrayTag.begin(), arrayTag.end());
return true;
}
catch (const CppSQLite3Exception& e)
{
return LogSQLException(e, strSQL);
}
}
bool mtn_cms_page_builder::getcache(const std::string& page, mtn_cms_cache_item* cache_item)
{
std::string _q = "SELECT * FROM `page_cache` WHERE page = \'" + page + "\';";
try
{
CppSQLite3Query q = _db->execQuery(_q.c_str());
while (!q.eof())
{
int len;
cache_item->data = q.getStringField("data");
cache_item->created = q.getIntField("created");
cache_item->ttl = q.getIntField("ttl");
cache_item->valid = true;
q.nextRow();
}
}
catch (CppSQLite3Exception ex)
{
cache_item->valid = false;
}
return cache_item->valid;
}
bool CWizIndexBase::SQLToDocumentDataArray(const CString& strSQL, CWizDocumentDataArray& arrayDocument)
{
try
{
CppSQLite3Query query = m_db.execQuery(strSQL);
CWizStdStringArray arrayGUID;
std::map<CString, int> mapDocumentIndex;
while (!query.eof())
{
WIZDOCUMENTDATA data;
data.strKbGUID = kbGUID();
data.strGUID = query.getStringField(documentDOCUMENT_GUID);
data.strTitle = query.getStringField(documentDOCUMENT_TITLE);
data.strLocation = query.getStringField(documentDOCUMENT_LOCATION);
data.strName = query.getStringField(documentDOCUMENT_NAME);
data.strSEO = query.getStringField(documentDOCUMENT_SEO);
data.strURL = query.getStringField(documentDOCUMENT_URL);
data.strAuthor = query.getStringField(documentDOCUMENT_AUTHOR);
data.strKeywords = query.getStringField(documentDOCUMENT_KEYWORDS);
data.strType = query.getStringField(documentDOCUMENT_TYPE);
data.strOwner = query.getStringField(documentDOCUMENT_OWNER);
data.strFileType = query.getStringField(documentDOCUMENT_FILE_TYPE);
data.strStyleGUID = query.getStringField(documentSTYLE_GUID);
data.tCreated = query.getTimeField(documentDT_CREATED);
data.tModified = query.getTimeField(documentDT_MODIFIED);
data.tAccessed = query.getTimeField(documentDT_ACCESSED);
data.nIconIndex = query.getIntField(documentDOCUMENT_ICON_INDEX);
data.nSync = query.getIntField(documentDOCUMENT_SYNC);
data.nProtected = query.getIntField(documentDOCUMENT_PROTECT);
data.nReadCount = query.getIntField(documentDOCUMENT_READ_COUNT);
data.nAttachmentCount = query.getIntField(documentDOCUMENT_ATTACHEMENT_COUNT);
data.nIndexed = query.getIntField(documentDOCUMENT_INDEXED);
data.tInfoModified = query.getTimeField(documentDT_INFO_MODIFIED);
data.strInfoMD5 = query.getStringField(documentDOCUMENT_INFO_MD5);
data.tDataModified = query.getTimeField(documentDT_DATA_MODIFIED);
data.strDataMD5 = query.getStringField(documentDOCUMENT_DATA_MD5);
data.tParamModified = query.getTimeField(documentDT_PARAM_MODIFIED);
data.strParamMD5 = query.getStringField(documentDOCUMENT_PARAM_MD5);
data.nVersion = query.getInt64Field(documentVersion);
arrayGUID.push_back(data.strGUID);
arrayDocument.push_back(data);
mapDocumentIndex[data.strGUID] = int(arrayDocument.size() - 1);
query.nextRow();
}
if (!arrayGUID.empty()) {
InitDocumentExFields(arrayDocument, arrayGUID, mapDocumentIndex);
}
return true;
}
catch (const CppSQLite3Exception& e)
{
return LogSQLException(e, strSQL);
}
}
BOOL CDlgMemoAdd::OnInitDialog()
{
CDialogEx::OnInitDialog();
// TODO: 在此添加额外的初始化
//SetBackgroundColor(DialogSubBackgroundColor,TRUE);
m_DateTime_ctlTime.SetFormat(_T("yyyy-MM-dd HH:mm"));
SetBackgroundColor(DialogSubBackgroundColor,TRUE);
m_Button_ctlSave.LoadStdImage(IDB_PNG_SAVE, _T("PNG"));
m_Button_ctlCancel.LoadStdImage(IDB_PNG_CANCEL, _T("PNG"));
m_Static_ctl1.SetBackgroundColor(DialogSubBackgroundColor,TRUE);
//m_Static_ctl1.SetTextColor(StaticCaptionColor,TRUE);
m_Static_ctl2.SetBackgroundColor(DialogSubBackgroundColor,TRUE);
//m_Static_ctl2.SetTextColor(StaticCaptionColor,TRUE);
m_Static_ctl3.SetBackgroundColor(DialogSubBackgroundColor,TRUE);
//m_Static_ctl3.SetTextColor(StaticCaptionColor,TRUE);
m_Static_ctl4.SetBackgroundColor(DialogSubBackgroundColor,TRUE);
//m_Static_ctl4.SetTextColor(StaticCaptionColor,TRUE);*/
/*m_Static_ctl5.SetBackgroundColor(DialogSubBackgroundColor,TRUE);
m_Static_ctl5.SetTextColor(StaticCaptionColor,TRUE);*/
try{
CppSQLite3DB db;
db.open(CBoBoDingApp::g_strDatabasePath);
CString strSQL=_T("select distinct * from CategoryMemo order by ID asc;");
CppSQLite3Query q = db.execQuery(strSQL);
CString strCategoryName;
while(!q.eof())
{
strCategoryName=(q.fieldValue(_T("CategoryName")));
if (strCategoryName.Compare(_T("+"))!=0)
{
m_Combo_ctlCategory.AddString(strCategoryName);
}
q.nextRow();
}
}
catch (CppSQLite3Exception& e)
{
//AfxMessageBox(e.errorMessage());
}
m_Combo_ctlCategory.SetCurSel(0);
return TRUE; // return TRUE unless you set the focus to a control
// 异常: OCX 属性页应返回 FALSE
}
void BudgetWindow::RefreshBudgetGrid(void)
{
fIncomeGrid.MakeEmpty();
fSpendingGrid.MakeEmpty();
CppSQLite3Query query = gDatabase.DBQuery("select category,amount,period from "
"budgetlist order by category",
"BudgetWindow::RefreshCategories");
while(!query.eof())
{
BString cat = DeescapeIllegalCharacters(query.getStringField(0));
Fixed amount;
amount.SetPremultiplied(query.getInt64Field(1));
BudgetPeriod period = (BudgetPeriod)query.getIntField(2);
ReportGrid *grid = (amount.IsPositive()) ? &fIncomeGrid : &fSpendingGrid;
int32 index = grid->CountItems();
grid->AddItem();
grid->SetRowTitle(index, cat.String());
Fixed f(amount.AbsoluteValue());
switch(period)
{
case BUDGET_QUARTERLY:
{
f /= 3;
Fixed qamt(amount);
qamt *= 4;
grid->SetValue(12,index,qamt);
break;
}
case BUDGET_ANNUALLY:
{
f /=12;
grid->SetValue(12,index,amount);
break;
}
default:
{
Fixed mamt(f);
mamt *= 12;
grid->SetValue(12,index,mamt);
break;
}
}
for(int32 i=0; i<12; i++)
grid->SetValue(i,index,f);
query.nextRow();
}
}
int CPersistencManager::LoadClientInfo(CI_VECTOR &client_list){
if(m_useLevelDB)
{
return 0;
}
int ret = 0;
int type = 0;
CppSQLite3Query query = m_SQLite3DB.execQuery("select * from Client");
while (!query.eof())
{
CClientInfo *pCI = new CClientInfo();
if (!pCI){
CLog::Log(LOG_LEVEL_ERROR,"Alloc object CClientInfo Error\n");
return -1;
}
type = query.getIntField("type");
if (type == COMPUTE_TYPE_CLIENT){
((CCompClient*)pCI)->m_gputhreads = query.getIntField("gpu");
((CCompClient*)pCI)->m_cputhreads = query.getIntField("cpu");
}
pCI->m_type = type;
memset(pCI->m_ip,0,sizeof(pCI->m_ip));
memset(pCI->m_guid,0,sizeof(pCI->m_guid));
memset(pCI->m_hostname,0,sizeof(pCI->m_hostname));
memset(pCI->m_osinfo,0,sizeof(pCI->m_osinfo));
memcpy(pCI->m_ip,query.fieldValue("ip"),strlen(query.fieldValue("ip")));
memcpy(pCI->m_hostname,query.fieldValue("hostname"),strlen(query.fieldValue("hostname")));
memcpy(pCI->m_osinfo,query.fieldValue("osinfo"),strlen(query.fieldValue("osinfo")));
//keeplive time and logintime
client_list.push_back(pCI);
query.nextRow();
}
return ret;
}
EXPORT_C gint32 CContactDb::GetRecentContacts(GPtrArray ** pContacts)
{
char sql[64] = {0};
char times[20] = {0};
// time_t t;
// time(&t);
*pContacts = NULL;
*pContacts = g_ptr_array_new();
if (*pContacts == NULL)
{
return ERROR(ESide_Client, EModule_Db, ECode_No_Memory);
}
OpenDatabase();
strcpy(sql, "select * from recent_contact;");
CppSQLite3Query query = m_dbBeluga.execQuery(sql);
while (!query.eof())
{
stRecentContact * recentContact = (stRecentContact*)g_malloc0(sizeof(stRecentContact));
if (recentContact == NULL)
{
CloseDatabase();
return ERROR(ESide_Client, EModule_Db, ECode_No_Memory);
}
recentContact->nContactId = query.getIntField(1);
recentContact->event = (EContactEvent)query.getIntField(2);
strcpy(recentContact->eventCommInfo, query.getStringField(3));
strcpy(times, query.getStringField(4)); /* exp: 2009-6-30 21:51:23 */
//recentContact->time = localtime(&t);
GetLocalTime(&recentContact->time);
char * tmp = strrchr(times, '-');
recentContact->time.tm_mon = atoi(tmp+1);
tmp = strrchr(tmp, '-');
recentContact->time.tm_mday = atoi(tmp+1);
tmp = strrchr(tmp, ' ');
recentContact->time.tm_hour = atoi(tmp+1);
tmp = strrchr(tmp, ':');
recentContact->time.tm_min = atoi(tmp+1);
tmp = strrchr(tmp, ':');
recentContact->time.tm_sec = atoi(tmp+1);
g_ptr_array_add(*pContacts, recentContact);
query.nextRow();
}
CloseDatabase();
return 0;
}
int UNotifySummaryList::getTotalUnreadCount()
{
CppSQLite3Query src;
UNotifySummaryDataSource::queryData(src);
curTotalUnreadMsg = 0;
while(!src.eof()){
UNotifySummaryDataField dest;
UNotifySummaryDataSource::parseDataField(src, dest);
curTotalUnreadMsg += dest.unreadCount;
src.nextRow();
}
return curTotalUnreadMsg;
}
int32 FireFox3PlugIn::GetFavoriteCount()
{
int nTotalNumber = 0;
CppSQLite3Query Query = m_pSqliteDatabase->execQuery("select * from moz_bookmarks where id in(2,3,4,5)");
while(!Query.eof() )
{
int nId = Query.getIntField("id", 0);
nTotalNumber += GetFavoriteCount(nId);
Query.nextRow();
}
return nTotalNumber;
}
SpaceAddress FindSpace(ePipeline& Path){
SpaceAddress Addr;
if (Path.Size()==0)
{
Addr.ParentID = ROOT_SPACE;
Addr.ChildID = LOCAL_SPACEID;
return Addr;
}
CppSQLite3Buffer SQL;
int64 ParentID = 0;
int64 ChildID = ROOT_SPACE;
char ParentName[30];
while (Path.Size())
{
tstring Name = Path.PopString();
AnsiString AnsiName = WStoUTF8(Name);
ParentID = ChildID;
ChildID = 0;
int64toa(ParentID,ParentName);
SQL.format("select %s from \"%s\" where %s=\"%s\"",
ITEM_ID,
ParentName,
ITEM_NAME,
AnsiName.c_str()
);
CppSQLite3Query Result = GetWorldDB().execQuery(SQL);
if(!Result.eof()){
ChildID = Result.getInt64Field(0);
Result.nextRow();
}else{
return Addr;
}
}
assert(Path.Size()==0);
Addr.ParentID = ParentID;
Addr.ChildID = ChildID;
return Addr;
}
void BudgetWindow::RefreshCategories(void)
{
fCategoryList->Clear();
fIncomeRow = new BRow();
fCategoryList->AddRow(fIncomeRow);
fSpendingRow = new BRow();
fCategoryList->AddRow(fSpendingRow);
fIncomeRow->SetField(new BStringField(TRANSLATE("Income")),0);
fSpendingRow->SetField(new BStringField(TRANSLATE("Spending")),0);
CppSQLite3Query query = gDatabase.DBQuery("select category,amount,period,isexpense from "
"budgetlist order by category",
"BudgetWindow::RefreshCategories");
float maxwidth=fCategoryList->StringWidth("Category");
while(!query.eof())
{
BString cat = DeescapeIllegalCharacters(query.getStringField(0));
Fixed amount;
amount.SetPremultiplied(query.getInt64Field(1));
BudgetPeriod period = (BudgetPeriod)query.getIntField(2);
BRow *row = new BRow();
if(query.getIntField(3)==0)
fCategoryList->AddRow(row,fIncomeRow);
else
fCategoryList->AddRow(row,fSpendingRow);
row->SetField(new BStringField(cat.String()),0);
BString amountstr;
gDefaultLocale.CurrencyToString(amount.AbsoluteValue(),amountstr);
amountstr.Truncate(amountstr.FindFirst(gDefaultLocale.CurrencyDecimal()));
amountstr.RemoveFirst(gDefaultLocale.CurrencySymbol());
row->SetField(new BStringField(amountstr.String()),1);
float tempwidth = fCategoryList->StringWidth(cat.String());
maxwidth = MAX(tempwidth,maxwidth);
row->SetField(new BStringField(BudgetPeriodToString(period).String()),2);
query.nextRow();
}
fCategoryList->ColumnAt(0)->SetWidth(maxwidth+30);
fCategoryList->ExpandOrCollapse(fIncomeRow,true);
fCategoryList->ExpandOrCollapse(fSpendingRow,true);
}
int32 GetAllChildList(int64 ParentID, ePipeline& ChildList,int64 NotIncludeChildID /*=0*/){
assert(ParentID >0);
ChildList.Clear();
char TableName[30];
int64toa(ParentID,TableName);
if(!GetWorldDB().tableExists(TableName)){
return 0;
}
//ChildList.SetID(ParentID);
CppSQLite3Buffer SQL;
SQL.format("select %s,%s,%s,%s from \"%s\"",
ITEM_ID,
ITEM_NAME,
ITEM_TYPE,
ITEM_FINGERPRINT,
TableName
);
CppSQLite3Query Result = GetWorldDB().execQuery(SQL);
while(!Result.eof()){
int64 ChildID = Result.getInt64Field(0);
if (ChildID !=NotIncludeChildID)
{
AnsiString s = Result.getStringField(1,"");
tstring Name = UTF8toWS(s);
Name = GetFileNoPathName(Name);
Name = GetFileName(Name);
int32 Type = Result.getIntField(2);
AnsiString FingerPrint = Result.getStringField(3,"");
//ChildList.PushInt64(ChildID);
ChildList.PushString(Name);
ChildList.PushInt(Type);
ChildList.PushString(FingerPrint);
}
Result.nextRow();
}
return ChildList.Size()/3;
}
void CCP_MainApp::LoadGlobalClips()
{
try
{
{
CppSQLite3Query q = m_db.execQuery(_T("SELECT lID, lShortCut, mText FROM Main WHERE lShortCut > 0 AND globalShortCut = 1"));
while(q.eof() == false)
{
int id = q.getIntField(_T("lID"));
int shortcut = q.getIntField(_T("lShortCut"));
CString desc = q.getStringField(_T("mText"));
//Constructor will add to a global list and free
CHotKey* globalHotKey = new CHotKey(desc, shortcut, true, CHotKey::PASTE_OPEN_CLIP);
if(globalHotKey != NULL)
{
globalHotKey->m_clipId = id;
}
q.nextRow();
}
}
{
CppSQLite3Query q2 = m_db.execQuery(_T("SELECT lID, MoveToGroupShortCut, mText FROM Main WHERE MoveToGroupShortCut > 0 AND GlobalMoveToGroupShortCut = 1"));
while(q2.eof() == false)
{
int id = q2.getIntField(_T("lID"));
int shortcut = q2.getIntField(_T("MoveToGroupShortCut"));
CString desc = q2.getStringField(_T("mText"));
//Constructor will add to a global list and free
CHotKey* globalHotKey = new CHotKey(desc, shortcut, true, CHotKey::MOVE_TO_GROUP);
if(globalHotKey != NULL)
{
globalHotKey->m_clipId = id;
}
q2.nextRow();
}
}
}
CATCH_SQLITE_EXCEPTION
}
void CVoxSQLite::GetProfile( const char* username, Profile& rProfile )
{
CppSQLite3Buffer buf;
buf.format( "SELECT * from Profile WHERE username = %Q;", username );
try
{
CppSQLite3Statement stmt = m_db.compileStatement( (const char*)buf );
int nProfileId = 0;
CppSQLite3Query q = stmt.execQuery();
//Process record set.
while (!q.eof())
{
nProfileId = q.getIntField(0);
rProfile.setFirstName ( q.getStringField(2) );
rProfile.setLastName ( q.getStringField(3) );
rProfile.setAlias ( q.getStringField(4) );
rProfile.setSmsSignature( q.getStringField(5) );
rProfile.setCompany ( q.getStringField(6) );
rProfile.setSex ( (EnumSex::Sex)q.getIntField(7) );
rProfile.setNotes ( q.getStringField(10) );
// rProfile.setBirthday( q.getStringField(8) );
// photo (filename)
//TODO rProfile.setPhoto( q.getBlobField(9) );
//Address, email, phone numbers, and URLs will be in separate tables to allow for easy
GetStreetAddresses( nProfileId, rProfile.getStreetAddresses() );
GetEmailAddresses ( nProfileId, rProfile.getEmailAddresses() );
GetTelephones ( nProfileId, rProfile.getTelephones() );
GetUrls ( nProfileId, rProfile.getUrls() );
q.nextRow();
}
stmt.reset();
}
catch (CppSQLite3Exception& e)
{
e.errorCode();
}
}
void CDlgEventList::ShowPage(int nPageIndex)
{
CString str;
int i = 0;
int nStartIndex = 0;
int nOffset = 0;
CppSQLite3DB db;
db.open(PATH_SQLITE_DB_808); //打开数据库
//查询记录总数量
m_nRecordCount = db.execScalar("SELECT count(*) FROM event_info;");
//计算总页数
if(m_nRecordCount > 0)
m_nPageCount = (m_nRecordCount-1)/elist_count+1;
else
m_nPageCount = 1;
//在数据库中查询第nPageIndex页的elist_count条数据
char szSqlBuffer[512];
sprintf(szSqlBuffer, "SELECT * FROM event_info ORDER BY event_ID DESC LIMIT %d, %d;", nPageIndex*elist_count, elist_count);
CppSQLite3Query q = db.execQuery(szSqlBuffer);
for( i = 0; i < elist_count; i++ )
{
if ( !q.eof() ) //数据行
{
m_nEvent_ID[i] = q.getIntField("event_ID");
m_list[i].chChar = q.fieldValue("event_content");
m_list[i].nState = BTN_STATE_NORMAL;
q.nextRow();
}
else //空白行
{
m_ItemState[i] = 0;
m_list[i].chChar = _T("");
m_list[i].nState = BTN_STATE_DISABLE;
}
}
//释放statement
q.finalize();
db.close(); //关闭数据库
return;
}
BOOL CTerminateNewLocationDialog::OnInitDialog()
{
CDialog::OnInitDialog();
CppSQLite3DB* pDB = &((CTrainOpsApp*)AfxGetApp())->m_pDB;
CppSQLite3Query q = pDB->execQuery("SELECT id,name FROM Locations;");
//
while (!q.eof())
{
int nIndex = m_ctlLocationList.AddString(q.getStringField("name"));
m_ctlLocationList.SetItemData(nIndex,q.getIntField("id"));
q.nextRow();
}
q.finalize();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
BOOL DatabaseModule_Impl::sqlGetAllGroupInfo(OUT std::vector<module::GroupInfoEntity>& groupList)
{
try
{
CppSQLite3Statement stmt;
stmt = m_pSqliteDB->compileStatement(getAllGroupInfoSql.c_str());
CppSQLite3Query query = stmt.execQuery();
while (!query.eof())
{
module::GroupInfoEntity groupInfo;
groupInfo.gId = query.getStringField(1);
groupInfo.csName = util::stringToCString(query.getStringField(2));
groupInfo.desc = util::stringToCString(query.getStringField(3));
groupInfo.avatarUrl = query.getStringField(4);
groupInfo.creatorId = query.getStringField(5);
groupInfo.type = query.getIntField(6);
groupInfo.version = query.getIntField(7);
groupInfo.groupUpdated = query.getIntField(8);
groupInfo.shieldStatus = query.getIntField(9);
_parseJsonForGroupMembers(query.getStringField(10), groupInfo.groupMemeberList);
groupList.push_back(groupInfo);
query.nextRow();
}
}
catch (CppSQLite3Exception& sqliteException)
{
#ifdef _DEBUG
MessageBoxA(0, sqliteException.errorMessage(), "BD ERROR", MB_OK | MB_ICONHAND);
#endif
CString csErrMsg = util::stringToCString(sqliteException.errorMessage(), CP_UTF8);
LOG__(ERR, _T("select failed,error msg:%s"),
csErrMsg);
return FALSE;
}
catch (...)
{
LOG__(ERR, _T("db unknown exception"));
return FALSE;
}
return TRUE;
}
