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();
}
}
void CTerminateNewLocationDialog::OnSelchangeLocationlist()
{
int iLocationID = m_ctlLocationList.GetItemData(m_ctlLocationList.GetCurSel());
CString sSQL;
sSQL.Format("SELECT Industries.id,Industries.name FROM Industries,Sidings WHERE Industries.Sidings_FK=Sidings.id AND Sidings.Locations_FK=%d",iLocationID);
TRACE(sSQL);
//
CppSQLite3DB* pDB = &((CTrainOpsApp*)AfxGetApp())->m_pDB;
CppSQLite3Query q = pDB->execQuery(sSQL);
//
while( m_ctlIndustryList.GetCount() > 0 )
m_ctlIndustryList.DeleteString(0);
//
while (!q.eof())
{
int nIndex = m_ctlIndustryList.AddString(q.getStringField("name"));
m_ctlIndustryList.SetItemData(nIndex,q.getIntField("id"));
q.nextRow();
}
//
sSQL.Format("SELECT id,name FROM Sidings WHERE Locations_FK=%d;",iLocationID);
q = pDB->execQuery(sSQL);
//
while( m_ctlSidingList.GetCount() > 0 )
m_ctlSidingList.DeleteString(0);
//
while (!q.eof())
{
int nIndex = m_ctlSidingList.AddString(q.getStringField("name"));
m_ctlSidingList.SetItemData(nIndex,q.getIntField("id"));
q.nextRow();
}
q.finalize();
}
//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)
{
}
}
long CDittoRulerRichEditCtrl::GetTypeFlags(long lID)
{
long lRet = stNONE;
try
{
CLIPFORMAT cfType = CF_TEXT;
CppSQLite3Query q = theApp.m_db.execQueryEx(_T("SELECT lID FROM Data WHERE lParentID = %d AND strClipboardFormat = '%s'"), lID, GetFormatName(cfType));
if(q.eof() == false)
{
lRet |= stCF_TEXT;
}
cfType = CF_UNICODETEXT;
q = theApp.m_db.execQueryEx(_T("SELECT lID FROM Data WHERE lParentID = %d AND strClipboardFormat = '%s'"), lID, GetFormatName(cfType));
if(q.eof() == false)
{
lRet |= stCF_UNICODETEXT;
}
cfType = RegisterClipboardFormat(_T("Rich Text Format"));
q = theApp.m_db.execQueryEx(_T("SELECT lID FROM Data WHERE lParentID = %d AND strClipboardFormat = '%s'"), lID, GetFormatName(cfType));
if(q.eof() == false)
{
lRet |= stRTF;
}
}
CATCH_SQLITE_EXCEPTION
return lRet;
}
void CCarTypesDetailDialog::OnOK()
{
// TODO: Add extra validation here
UpdateData();
//
CppSQLite3DB* pDB = &((CTrainOpsApp*)AfxGetApp())->m_pDB;
CString sSQL;
//
// add?
//
if( m_iCarTypeFK == -1 )
{
sSQL.Format("SELECT 1 FROM CarTypes WHERE type_id=\"%s\"",m_sCarTypeID);
CppSQLite3Query q = pDB->execQuery((LPCTSTR)sSQL);
//
if(!q.eof())
{
MessageBox("Duplcate Type ID!","LSC TrainOps Error",MB_ICONSTOP|MB_OK);
return;
}
sSQL.Format("INSERT INTO CarTypes (id,type_id,description,active,passenger) VALUES (NULL,\"%s\",\"%s\",1,%d)",m_sCarTypeID,m_sCarTypeDescription,m_bPassenger?1:0);
}
else
{
sSQL.Format("UPDATE CarTypes SET type_id=\"%s\",description=\"%s\",passenger=%d WHERE id=%d",m_sCarTypeID,m_sCarTypeDescription,m_bPassenger?1:0,m_iCarTypeFK);
}
pDB->execDML((LPCTSTR)sSQL);
CDialog::OnOK();
}
bool CDittoCopyBuffer::PutClipOnDittoCopyBuffer(long lClipId, long lBuffer)
{
try
{
//enclose in brackets so the query closes before we update below
{
CppSQLite3Query q = theApp.m_db.execQueryEx(_T("SELECT lID FROM CopyBuffers WHERE lCopyBuffer = %d"), lBuffer);
if(q.eof())
{
theApp.m_db.execDMLEx(_T("INSERT INTO CopyBuffers VALUES(NULL, -1, %d);"), lBuffer);
}
}
theApp.m_db.execDMLEx(_T("UPDATE CopyBuffers SET lClipID = %d WHERE lCopyBuffer = %d"), lClipId, lBuffer);
CCopyBufferItem Item;
g_Opt.GetCopyBufferItem(lBuffer, Item);
if(Item.m_bPlaySoundOnCopy)
{
PlaySound(_T("ding.wav"), NULL, SND_FILENAME|SND_ASYNC);
}
return true;
}
CATCH_SQLITE_EXCEPTION
return false;
}
void CVoxSQLite::GetMergedContacts( const char* parent_username, MergedContacts& rList )
{
CppSQLite3Buffer buf;
buf.format( "SELECT * from [MergedContact] WHERE [parent_username] = %Q;", parent_username );
try
{
CppSQLite3Statement stmt = m_db.compileStatement( (const char*)buf );
int nContactId = 0;
std::string type = "";
CppSQLite3Query q = stmt.execQuery();
MergedContact mc;
//Process record set.
while (!q.eof())
{
mc.setParentUsername( q.getStringField( 0 ) );
mc.setUsername ( q.getStringField( 1 ) );
rList.Add( &mc );
q.nextRow();
}
stmt.reset();
}
catch (CppSQLite3Exception& e)
{
e.errorCode();
}
}
BOOL CCP_MainApp::GetClipData(long lID, CClipFormat &Clip)
{
BOOL bRet = FALSE;
try
{
CppSQLite3Query q = theApp.m_db.execQueryEx(_T("SELECT ooData FROM Data WHERE lParentID = %d AND strClipboardFormat = '%s'"), lID, GetFormatName(Clip.m_cfType));
if(q.eof() == false)
{
int nDataLen = 0;
const unsigned char *cData = q.getBlobField(_T("ooData"), nDataLen);
if(cData != NULL)
{
Clip.m_hgData = NewGlobal(nDataLen);
::CopyToGlobalHP(Clip.m_hgData, (LPVOID)cData, nDataLen);
bRet = TRUE;
}
}
}
CATCH_SQLITE_EXCEPTION
return bRet;
}
char* CreateInfoByid(int id)
{
static char buffer[1024]={0};
static char querybuf[1024]={0};
char* str = "%s 体力%s 武力%s 智力%s 魅力%s 年龄%s 类型 %s";
memset(querybuf,0,1024);
try
{ db.open("database/infodata.db");
sprintf(querybuf,"select heroinfo.name,ti,wu,zhi,mei,age,herotype.name from "
" heroinfo,herotype where heroinfo.id=%d and heroinfo.type=herotype.id;",id);
CppSQLite3Query q = db.execQuery(querybuf);
//nge_charsets_utf8_to_gbk((uint8*)str, (uint8*)querybuf, strlen(str), 1024);
if (!q.eof())
{
sprintf(buffer,str, q.fieldValue(0),q.fieldValue(1),q.fieldValue(2),q.fieldValue(3),
q.fieldValue(4),q.fieldValue(5),q.fieldValue(6));
}
db.close();
}catch (CppSQLite3Exception& e){
printf("%s\n",e.errorMessage());
}
return buffer;
}
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;
}
//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 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);
}
}
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);
}
}
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::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;
}
EXPORT_C gint32 CContactDb::GetEntityById(guint32 nId, CDbEntity** ppEntity)
{
char sql[128] = {0};
*ppEntity = NULL;
OpenDatabase();
sprintf(sql, "select * from contact where cid = %d;", nId);
CppSQLite3Query query = m_dbBeluga.execQuery(sql);
if (query.eof())
{
CloseDatabase();
return ERROR(ESide_Client, EModule_Db, ECode_Not_Exist);
}
if (ContactType_Phone == query.getIntField(ContactField_Type))
*ppEntity = new CPhoneContact(this, FALSE);
else
*ppEntity = new CIMContact(this);
if (NULL == *ppEntity)
{
CloseDatabase();
return ERROR(ESide_Client, EModule_Db, ECode_No_Memory);
}
for (int i=0; i<query.numFields(); i++)
{
GString * fieldValue = g_string_new(query.fieldValue(i));
(*ppEntity)->SetFieldValue(i, fieldValue);
g_string_free(fieldValue, TRUE);
}
CloseDatabase();
return 0;
}
bool CThumbIndex::AbstractIsExist(const CString& guid, const CString& type)
{
if(!m_dbThumb.IsOpened())
return false;
CString sql = CString("select ") + "ABSTRACT_GUID" + " from " +TABLE_NAME_ABSTRACT+" where ABSTRACT_GUID='"
+guid+ ("' AND ABSTRACT_TYPE=")
+STR2SQL(type)
+(";");
try {
CppSQLite3Query query = m_dbThumb.execQuery(sql);
while (!query.eof()) {
return true;
}
return false;
}
catch (const CppSQLite3Exception& e)
{
TOLOG(e.errorMessage());
TOLOG(sql);
return false;
}
catch (...) {
TOLOG("Unknown exception while close DB");
return false;
}
}
bool DBSetting::GetValue(long lKey,std::string &strValue)
{
//打开数据库
CppSQLite3DB dbTask;
dbTask.open(m_strDB.c_str());
CheckCreateSettingTable(dbTask);
CppSQLite3Buffer strSql;
try{
strSql.format("select value from T_Setting where key=%d;",lKey);
CppSQLite3Query q = dbTask.execQuery(strSql);
if (q.eof())
{
return false;
}
strValue = q.getStringField(0);
}
catch(CppSQLite3Exception &exp)
{
exp;
ATLTRACE("error:%s\n",exp.errorMessage());
ATLASSERT(FALSE);
return false;
}
return true;
}
int CDBObject::getFirstFile(char* name)
{
try
{
if(name != NULL)
{
char szSql[]= {"SELECT * from Record"};
CppSQLite3DB database;
database.open(g_szFile);
CppSQLite3Query query = database.execQuery(szSql);
if(!query.eof())
{
string path = query.getStringField(8);
string file= query.getStringField(7);
sprintf(name, "%s\\%s", UTF_82ASCII(path).c_str(), UTF_82ASCII(file).c_str());
return query.getIntField(0);
}
}
}
catch(...)
{
g_pLog->WriteLog("数据库查询异常 getFirstFile\n");
}
return -1;
}
BOOL CLocationDetailDialog::OnInitDialog()
{
CDialog::OnInitDialog();
if( m_iLocationID == -1 )
m_ctlOK.EnableWindow(FALSE);
else
{
CString sSQL;
sSQL.Format("SELECT name,notes FROM Locations WHERE id=%d;",m_iLocationID);
CppSQLite3DB* pDB = &((CTrainOpsApp*)AfxGetApp())->m_pDB;
CppSQLite3Query q = pDB->execQuery(sSQL);
//
if (!q.eof())
{
m_sLocationName = q.getStringField("name");
m_sLocalInstructions = q.getStringField("notes");
}
q.finalize();
UpdateData(FALSE);
}
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
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;
}
// 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;
}
bool CDittoCopyBuffer::PastCopyBuffer(long lCopyBuffer)
{
//Can't paste while another is still active
if(WaitForSingleObject(m_Pasting, 1) == WAIT_TIMEOUT)
{
Log(_T("Copy Buffer pasted to fast"));
return false;
}
m_RestoreTimer.ResetEvent();
m_Pasting.ResetEvent();
bool bRet = false;
Log(StrF(_T("Start - PastCopyBuffer buffer = %d"), m_lCurrentDittoBuffer));
try
{
CppSQLite3Query q = theApp.m_db.execQueryEx(_T("SELECT Main.lID FROM Main ")
_T("INNER JOIN CopyBuffers ON CopyBuffers.lClipID = Main.lID ")
_T("WHERE CopyBuffers.lCopyBuffer = %d"), lCopyBuffer);
if(q.eof() == false)
{
m_pClipboard = new CClipboardSaveRestoreCopyBuffer;
if(m_pClipboard)
{
//Save the clipboard,
//then put the new data on the clipboard
//then send a paste
//then wait a little and restore the original clipboard data
if(m_pClipboard->Save())
{
CProcessPaste paste;
paste.m_bSendPaste = true;
paste.m_bActivateTarget = false;
paste.GetClipIDs().Add(q.getIntField(_T("lID")));
paste.DoPaste();
m_pClipboard->m_lRestoreDelay = g_Opt.GetDittoRestoreClipboardDelay();
Log(StrF(_T("PastCopyBuffer sent paste, starting thread to restore clipboard, Delay = %d"), m_pClipboard->m_lRestoreDelay));
AfxBeginThread(CDittoCopyBuffer::DelayRestoreClipboard, (LPVOID)this, THREAD_PRIORITY_LOWEST);
bRet = true;
}
else
{
Log(_T("PastCopyBuffer failed to save clipboard"));
}
}
}
}
CATCH_SQLITE_EXCEPTION
if(bRet == false)
m_Pasting.SetEvent();
return bRet;
}
void CVoxSQLite::GetGroups( const char* username, Groups& rList )
{
CppSQLite3Buffer buf;
buf.format( "SELECT * from [Group] WHERE [username] = %Q;", username );
try
{
CppSQLite3Statement stmt = m_db.compileStatement( (const char*)buf );
int nContactId = 0;
std::string type = "";
CppSQLite3Query q = stmt.execQuery();
Group grp;
//Process record set.
while (!q.eof())
{
grp.setUsername( q.getStringField( 0 ) );
grp.setName ( q.getStringField( 1 ) );
rList.Add( &grp );
q.nextRow();
}
stmt.reset();
}
catch (CppSQLite3Exception& e)
{
e.errorCode();
}
}
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();
}
}
BOOL CCarTypesDetailDialog::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
if( m_iCarTypeFK != -1 )
{
CppSQLite3DB* pDB = &((CTrainOpsApp*)AfxGetApp())->m_pDB;
CString sSQL;
sSQL.Format("SELECT * FROM CarTypes WHERE id=%d",m_iCarTypeFK);
CppSQLite3Query q = pDB->execQuery((LPCTSTR)sSQL);
if( !q.eof() )
{
m_sCarTypeDescription = q.getStringField("description");
m_sCarTypeID = q.getStringField("type_id");
m_bPassenger = q.getIntField("passenger")==1?TRUE:FALSE;
}
q.finalize();
}
UpdateData(FALSE);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CUserAcessSetDlg::InserSingleSetConfig()
{
CppSQLite3Table table;
CppSQLite3Query q;
CppSQLite3DB SqliteDBBuilding;
SqliteDBBuilding.open((UTF8MBSTR)g_strCurBuildingDatabasefilePath);
CString strSql;
strSql.Format(_T("select * from UserLevelSingleSet where MainBuilding_Name='%s' and Building_Name='%s' and username='******'"),m_strMainBuilding,m_strSubNetName,m_strUserName);
q = SqliteDBBuilding.execQuery((UTF8MBSTR)strSql);
_variant_t temp_variant;
BOOL b_useLogin=false;
try
{
if(q.eof())
{
strSql.Format(_T("insert into UserLevelSingleSet values('%s','%s','%s',%i,%i)"),m_strMainBuilding,m_strSubNetName,m_strUserName,0,0);
SqliteDBBuilding.execDML((UTF8MBSTR)strSql);
}
SqliteDBBuilding.closedb();
}
catch(_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
}
void DeviceTransNotifyList::loadDataSource()
{
CppSQLite3Query src;
DeviceTransNotifyDataSource::queryData(src);
while(!src.eof()){
DeviceTransNotifyDataField dest;
DeviceTransNotifyDataSource::parseDataField(src, dest);
DeviceTransNotify* info = new DeviceTransNotify;
info->setTransUserID(dest.srcUserID);
info->setTransUserName(dest.srcUserName);
info->setSrcClusterID(dest.srcClusterID);
info->setSrcClusterName(dest.srcClusterName);
info->setDestClusterID(dest.destClusterID);
info->setDestClusterName(dest.destClusterName);
info->setNotifyContent(dest.notifyContent);
info->setNotifyVerify(dest.notifyVerify);
info->setNotifyTime(dest.notifyTime);
int reStatus = dest.status;
Mi::MsgStatus status = (Mi::MsgStatus)reStatus;
info->setReviewStatus(status);
this->insertList(info);
src.nextRow();
}
}
//必须在加载任务列表之后
int CPersistencManager::LoadReadyTaskQueue(CT_DEQUE &ready_list,const CT_MAP& task_map){
if(m_useLevelDB)
{
string value;
leveldb::ReadOptions ro;
leveldb::Status s;
int ready_count = 0;
s = m_LevelDB->Get(ro, TASK_RUN_COUNT, &value);
if(s.ok())
ready_count = *(int*)value.data();
CLog::Log(LOG_LEVEL_DEBUG, "LoadReadyTaskQueue: count=%d\n", ready_count);
for(int i = 0; i < ready_count; i++)
{
s = m_LevelDB->Get(ro, TASK_IDX(TASK_RUN_KEY, i), &value);
if(s.ok())
{
if(task_map.find((char*)value.c_str()) == task_map.end()){
CLog::Log(LOG_LEVEL_WARNING, "Task List and Ready Task List is not Matched\n");
continue;
}
ready_list.push_back(value);
CLog::Log(LOG_LEVEL_DEBUG, "Ready task %d:%s\n", i, value.c_str());
}
}
return 0;
}
int ret = 0;
CT_MAP::const_iterator cur_iter ;
CT_MAP::const_iterator end_iter = task_map.end();
CppSQLite3Query query = m_SQLite3DB.execQuery("select * from ReadyTask");
while (!query.eof())
{
cur_iter = task_map.find((char *)query.fieldValue("taskid"));
if (cur_iter == end_iter){
CLog::Log(LOG_LEVEL_ERROR,"Task List and Ready Task List is not Matched\n");
query.nextRow();
continue;
}
ready_list.push_back(cur_iter->first);
query.nextRow();
}
return ret;
}