📄 mgrbaseclient.cpp
字号:
}
return 0;
}
BOOL MGRBaseClient::IndexIsRequireSync(LPCSTR dbname,LPCSTR tblname,LPCSTR idxname)
{
NetDataTuple arg,res;
arg.AddItems(3);
arg.SetItemString(0,dbname);
arg.SetItemString(1,tblname);
arg.SetItemString(2,idxname);
if(Call("mgrbaseif_IndexIsRequireSync",NULL,&arg,&res))
{
return res.GetItemLong(0);
}
return FALSE;
}
BOOL MGRBaseClient::IndexQueryData(LPCSTR dbname,LPCSTR tblname,LPCSTR idxname,MFTKEY &key,superint_ut start,int num,LPCSTR cols,NetTable *data)
{
NetDataTuple arg,res;
arg.AddItems(7);
arg.SetItemString(0,dbname);
arg.SetItemString(1,tblname);
arg.SetItemString(2,idxname);
arg.SetItemMFTKEY(3,key);
arg.SetItemSuperLong(4,start);
arg.SetItemLong(5,num);
arg.SetItemString(6,cols);
if(Call("mgrbaseif_IndexQueryData",NULL,&arg,&res))
{
if(res.GetItemLong(0))
{
res.GetItemNetTable(1)->CopyTo(data);
return TRUE;
}
}
return FALSE;
}
BOOL MGRBaseClient::IndexQueryDataDirect(LPCSTR dbname,LPCSTR idxname,MFTKEY &key,superint_ut start,int num,LPCSTR cols,NetTable *data)
{
NetDataTuple arg,res;
arg.AddItems(6);
arg.SetItemString(0,dbname);
arg.SetItemString(1,idxname);
arg.SetItemMFTKEY(2,key);
arg.SetItemSuperLong(3,start);
arg.SetItemLong(4,num);
arg.SetItemString(5,cols);
if(Call("mgrbaseif_IndexQueryDataDirect",NULL,&arg,&res))
{
if(res.GetItemLong(0))
{
res.GetItemNetTable(1)->CopyTo(data);
return TRUE;
}
}
return FALSE;
}
BOOL MGRBaseClient::IndexQueryDataEx(LPCSTR dbname,LPCSTR tblname,LPCSTR idxname,NetTable &keyparam,LPCSTR cols,NetTable *data)
{
NetDataTuple arg,res;
arg.AddItems(5);
arg.SetItemString(0,dbname);
arg.SetItemString(1,tblname);
arg.SetItemString(2,idxname);
arg.SetItemNetTable(3,&keyparam,FALSE);
arg.SetItemString(4,cols);
if(Call("mgrbaseif_IndexQueryDataEx",NULL,&arg,&res))
{
if(res.GetItemLong(0))
{
res.GetItemNetTable(1)->CopyTo(data);
return TRUE;
}
}
return FALSE;
}
BOOL MGRBaseClient::IndexDeleteData(LPCSTR dbname,LPCSTR tblname,LPCSTR idxname,MFTKEY &key)
{
NetDataTuple arg,res;
arg.AddItems(4);
arg.SetItemString(0,dbname);
arg.SetItemString(1,tblname);
arg.SetItemString(2,idxname);
arg.SetItemMFTKEY(3,key);
if(Call("mgrbaseif_IndexDeleteData",NULL,&arg,&res))
{
if(res.GetItemLong(0))
{
return TRUE;
}
}
return FALSE;
}
superint_ut MGRBaseClient::IndexCountDistinctKey(LPCSTR dbname,LPCSTR idxname,LPCSTR fields)
{
NetDataTuple arg,res;
arg.AddItems(3);
arg.SetItemString(0,dbname);
arg.SetItemString(1,idxname);
arg.SetItemString(2,fields);
if(Call("mgrbaseif_IndexCountDistinctKey",NULL,&arg,&res))
{
return res.GetItemSuperLong(0);
}
return 0;
}
BOOL MGRBaseClient::IndexFetchDistinctKey(LPCSTR dbname,LPCSTR idxname,LPCSTR fields,superint_ut start,int num,NetTable *key)
{
NetDataTuple arg,res;
NetTable *p;
key->Clear();
arg.AddItems(5);
arg.SetItemString(0,dbname);
arg.SetItemString(1,idxname);
arg.SetItemString(2,fields);
arg.SetItemSuperLong(3,start);
arg.SetItemLong(4,num);
if(Call("mgrbaseif_IndexFetchDistinctKey",NULL,&arg,&res))
{
if( res.GetItemLong(0))
{
p=res.GetItemNetTable(1);
p->CopyTo(key);
}
return TRUE;
}
return FALSE;
}
//////////////////////////////////////////////////////////////////////////////////////////////////////
//
void MGRBaseClient::FlushEnable(BOOL bEnable)
{
NetDataTuple arg,res;
arg.SetItemCount(1);
arg.SetItemLong(0,bEnable);
Call("mgrbaseif_FlushEnable",NULL,&arg,&res);
}
///////////////////////////////////////////////////////////////////////////////////////////////////////
BOOL MGRBaseClient::SortCreate(LPCSTR dbname,LPCSTR sortname,BOOL bunique,LPCSTR keydef,int datasize)
{
NetDataTuple arg,res;
arg.AddItems(5);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemLong(2,bunique);
arg.SetItemString(3,keydef);
arg.SetItemLong(4,datasize);
if(Call("mgrbaseif_SortCreate",NULL,&arg,&res))
{
return res.GetItemLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortCreate(LPCSTR dbname,LPCSTR sortname,BOOL bunique,MFTKEY &key,int datasize)
{
NetDataTuple arg,res;
arg.AddItems(5);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemLong(2,bunique);
arg.SetItemMFTKEY(3,key);
arg.SetItemLong(4,datasize);
if(Call("mgrbaseif_SortCreateEx",NULL,&arg,&res))
{
return res.GetItemLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortDrop(LPCSTR dbname,LPCSTR sortname)
{
NetDataTuple arg,res;
arg.AddItems(2);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
if(Call("mgrbaseif_SortDrop",NULL,&arg,&res))
{
return res.GetItemLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortIsExist(LPCSTR dbname,LPCSTR sortname)
{
NetDataTuple arg,res;
arg.AddItems(2);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
if(Call("mgrbaseif_SortIsExist",NULL,&arg,&res))
{
return res.GetItemLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortList(LPCSTR dbname,NetTable *sortlist)
{
NetDataTuple arg,res;
NetTable *p;
arg.AddItems(1);
arg.SetItemString(0,dbname);
if(Call("mgrbaseif_SortList",NULL,&arg,&res))
{
if( res.GetItemLong(0))
{
p=res.GetItemNetTable(1);
p->CopyTo(sortlist);
return TRUE;
}
}
return FALSE;
}
BOOL MGRBaseClient::SortGetDef(LPCSTR dbname,LPCSTR sortname,BOOL *bunique,MFTKEY *def,int *datasize)
{
NetDataTuple arg,res;
arg.AddItems(2);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
if(Call("mgrbaseif_SortGetDef",NULL,&arg,&res))
{
if( res.GetItemLong(0))
{
*bunique=res.GetItemLong(1);
res.GetItemMFTKEY(2,def);
*datasize=res.GetItemLong(3);
return TRUE;
}
}
return FALSE;
}
BOOL MGRBaseClient::SortCheck(LPCSTR dbname,LPCSTR sortname,BOOL bfix)
{
NetDataTuple arg,res;
arg.AddItems(3);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemLong(2,bfix);
if(Call("mgrbaseif_SortCheck",NULL,&arg,&res))
{
return res.GetItemLong(0);
}
return FALSE;
}
BOOL MGRBaseClient::SortRename(LPCSTR dbname,LPCSTR oldsortname,LPCSTR newsortname)
{
NetDataTuple arg,res;
arg.AddItems(3);
arg.SetItemString(0,dbname);
arg.SetItemString(1,oldsortname);
arg.SetItemString(2,newsortname);
if(Call("mgrbaseif_SortRename",NULL,&arg,&res))
{
return res.GetItemLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortSetColName(LPCSTR dbname,LPCSTR sortname,LPCSTR oldcolname,LPCSTR newcolname)
{
NetDataTuple arg,res;
arg.AddItems(4);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemString(2,oldcolname);
arg.SetItemString(3,newcolname);
if(Call("mgrbaseif_SortSetColName",NULL,&arg,&res))
{
return res.GetItemLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortExpandCol(LPCSTR dbname,LPCSTR sortname,LPCSTR colname,int newlength)
{
NetDataTuple arg,res;
arg.AddItems(4);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemString(2,colname);
arg.SetItemLong(3,newlength);
if(Call("mgrbaseif_SortExpandCol",NULL,&arg,&res))
{
return res.GetItemLong(0);
}
return 0;
}
int MGRBaseClient::SortInsert(LPCSTR dbname,LPCSTR sortname,NetTable ¶m)
{
NetDataTuple arg,res;
arg.AddItems(3);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemNetTable(2,¶m,FALSE);
if(Call("mgrbaseif_SortInsert",NULL,&arg,&res))
{
return res.GetItemLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortDelete(LPCSTR dbname,LPCSTR sortname,NetTable ¶m)
{
NetDataTuple arg,res;
arg.AddItems(3);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemNetTable(2,¶m,FALSE);
if(Call("mgrbaseif_SortDelete",NULL,&arg,&res))
{
return res.GetItemLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortFetch(LPCSTR dbname,LPCSTR sortname,superint_ut start,int num,NetTable *data)
{
NetDataTuple arg,res;
NetTable *p;
arg.AddItems(4);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemSuperLong(2,start);
arg.SetItemLong(3,num);
if(Call("mgrbaseif_SortFetch",NULL,&arg,&res))
{
if( res.GetItemLong(0))
{
p=res.GetItemNetTable(1);
p->CopyTo(data);
return TRUE;
}
}
return FALSE;
}
BOOL MGRBaseClient::SortFetchNext(LPCSTR dbname,LPCSTR sortname,MFTKEY &key,int num,NetTable *data)
{
NetDataTuple arg,res;
NetTable *p;
arg.AddItems(4);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemMFTKEY(2,key);
arg.SetItemLong(3,num);
if(Call("mgrbaseif_SortFetchNext",NULL,&arg,&res))
{
if( res.GetItemLong(0))
{
p=res.GetItemNetTable(1);
p->CopyTo(data);
return TRUE;
}
}
return FALSE;
}
superint_ut MGRBaseClient::SortCountRow(LPCSTR dbname,LPCSTR sortname)
{
NetDataTuple arg,res;
arg.AddItems(2);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
if(Call("mgrbaseif_SortCountRow",NULL,&arg,&res))
{
return res.GetItemSuperLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortQuery(LPCSTR dbname,LPCSTR sortname,MFTKEY &key,superint_ut start,int num,NetTable *data)
{
NetDataTuple arg,res;
NetTable *p;
arg.AddItems(5);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemMFTKEY(2,key);
arg.SetItemSuperLong(3,start);
arg.SetItemLong(4,num);
if(Call("mgrbaseif_SortQuery",NULL,&arg,&res))
{
if( res.GetItemLong(0))
{
p=res.GetItemNetTable(1);
p->CopyTo(data);
return TRUE;
}
}
return FALSE;
}
superint_ut MGRBaseClient::SortCountKey(LPCSTR dbname,LPCSTR sortname,MFTKEY &key)
{
NetDataTuple arg,res;
arg.AddItems(3);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemMFTKEY(3,key);
if(Call("mgrbaseif_SortCountKey",NULL,&arg,&res))
{
return res.GetItemSuperLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortFilter(LPCSTR dbname,LPCSTR sortname,NetTable ¶m,NetTable *out,NetTable *exclude)
{
NetDataTuple arg,res;
NetTable *p;
arg.AddItems(3);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemNetTable(2,¶m,FALSE);
if(Call("mgrbaseif_SortFilter",NULL,&arg,&res))
{
if( res.GetItemLong(0))
{
p=res.GetItemNetTable(1);
p->CopyTo(out);
p=res.GetItemNetTable(2);
p->CopyTo(exclude);
return TRUE;
}
}
return FALSE;
}
BOOL MGRBaseClient::SortQueryEx(LPCSTR dbname,LPCSTR sortname,NetTable ¶m,NetTable *data)
{
NetDataTuple arg,res;
NetTable *p;
arg.AddItems(3);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemNetTable(2,¶m,FALSE);
if(Call("mgrbaseif_SortQueryEx",NULL,&arg,&res))
{
if( res.GetItemLong(0))
{
p=res.GetItemNetTable(1);
p->CopyTo(data);
return TRUE;
}
}
return FALSE;
}
BOOL MGRBaseClient::SortQueryBetween(LPCSTR dbname,LPCSTR sortname,MFTKEY &begin,MFTKEY &end,superint_ut start,int num,NetTable *data)
{
NetDataTuple arg,res;
NetTable *p;
arg.AddItems(6);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemMFTKEY(2,begin);
arg.SetItemMFTKEY(3,end);
arg.SetItemSuperLong(4,start);
arg.SetItemLong(5,num);
if(Call("mgrbaseif_SortQueryBetween",NULL,&arg,&res))
{
if( res.GetItemLong(0))
{
p=res.GetItemNetTable(1);
p->CopyTo(data);
return TRUE;
}
}
return FALSE;
}
superint_ut MGRBaseClient::SortCountBetween(LPCSTR dbname,LPCSTR sortname,MFTKEY &begin,MFTKEY &end)
{
NetDataTuple arg,res;
arg.AddItems(4);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemMFTKEY(2,begin);
arg.SetItemMFTKEY(3,end);
if(Call("mgrbaseif_SortCountBetween",NULL,&arg,&res))
{
return res.GetItemSuperLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortQueryUpper(LPCSTR dbname,LPCSTR sortname, MFTKEY &key,superint_ut start,int num,NetTable *data)
{
NetDataTuple arg,res;
NetTable *p;
arg.AddItems(5);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemMFTKEY(2,key);
arg.SetItemSuperLong(3,start);
arg.SetItemLong(4,num);
if(Call("mgrbaseif_SortQueryUpper",NULL,&arg,&res))
{
if( res.GetItemLong(0))
{
p=res.GetItemNetTable(1);
p->CopyTo(data);
return TRUE;
}
}
return FALSE;
}
superint_ut MGRBaseClient::SortCountUpper(LPCSTR dbname,LPCSTR sortname ,MFTKEY &key)
{
NetDataTuple arg,res;
arg.AddItems(3);
arg.SetItemString(0,dbname);
arg.SetItemString(1,sortname);
arg.SetItemMFTKEY(2,key);
if(Call("mgrbaseif_SortCountUpper",NULL,&arg,&res))
{
return res.GetItemSuperLong(0);
}
return 0;
}
BOOL MGRBaseClient::SortQueryBelow(LPCSTR dbname,LPCSTR sortname, MFTKEY &key,superint_ut start,int num,NetTable *data)
{
NetDataTuple arg,res;
NetTable *p;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -