Epos.zip_epos_linux

#include "actionterminalmger.h" /*************************************************************************** * 方法名称：actionTerminalMger::actionTerminalMger() * 功能：构造函数，打开数据库 * 参数：无 * 返回值：无 **************************************************************************/ actionTerminalMger::actionTerminalMger() { terminal_db = DbAccess::getInstance("./mydb.dat"); } /*************************************************************************** * 方法名称：bool actionTerminalMger::IdToBoTeInfo(boTerminalInfo* terminalInfo) * 功能：根据终端ID把终端所有的信息存入终端类中 * 参数：terminalInfo 终端信息 * 返回值：true 成功 false 失败 **************************************************************************/ bool actionTerminalMger::IdToBoTeInfo(boTerminalInfo* terminalInfo) { int row,col; char** result; char buf[400]; sprintf(buf,"select * from terminal_tbl where terminal_id='%s'",terminalInfo->rtId().c_str()); if(terminal_db->query(buf,&result,&row,&col)>0) { terminalInfo->getPlace(string(result[col+1])); terminalInfo->getType(string(result[col+2])); terminalInfo->getPsamId(string(result[col+3])); terminalInfo->getSimId(string(result[col+4])); terminalInfo->getConnectPattern(string(result[col+5])); terminalInfo->getState(string(result[col+6])); terminalInfo->getGrantTime(string(result[col+7])); terminalInfo->getSoftId(string(result[col+8])); terminalInfo->getHardId(string(result[col+9])); terminalInfo->getRemark(string(result[col+10])); return true; } else return false; } /*************************************************************************** * 方法名称：bool actionTerminalMger::ctrTermState(boTerminalInfo &terminalInfo) * 功能：控制终端状态 * 参数：terminalInfo 终端信息 * 返回值：true 成功 false 失败 **************************************************************************/ bool actionTerminalMger::ctrTermState(boTerminalInfo &terminalInfo) { char buf[1000]; sprintf(buf,"update terminal_tbl set terminal_state ='%s' where terminal_id='%s'",terminalInfo.rtState().c_str(), terminalInfo.rtId().c_str()); //puts(buf); if(terminal_db->exec(buf)==true) return true; else return false; } /*************************************************************************** * 方法名称：bool actionTerminalMger::getTerminalRslt(boDbRslt &dbRslt) * 功能：获得终端结果 * 参数： dbRslt 终端结果 * 返回值：true 成功 false 失败 **************************************************************************/ bool actionTerminalMger::getTerminalRslt(boDbRslt &dbRslt) { int row=0,col=0; char** result = NULL; if(terminal_db->query("select * from terminal_tbl",&result,&row,&col)>0) { dbRslt.getDbRow(row); dbRslt.getDbCol(col); dbRslt.getDbResult(result); return true; } else return false; } /*************************************************************************** * 方法名称：bool actionTerminalMger::IdIsExist(string id) * 功能：判断终端ID是否存在 * 参数： id 终端ID号 * 返回值：true 成功 false 失败 **************************************************************************/ bool actionTerminalMger::IdIsExist(string id) { char buf[100]; int row,col; char **pcResult; sprintf(buf,"select * from terminal_tbl where terminal_id='%s'",id.c_str()); if(terminal_db->query(buf,&pcResult,&row,&col)>0) return true; else return false; } /*************************************************************************** * 方法名称：bool actionTerminalMger::query(boTerminalInfo &queryInfo,boDbRslt& queryDbRslt) * 功能：查询按钮的实现 * 参数： queryInfo 查询信息 queryDbRslt 查询结果集 * 返回值：true 成功 false 失败 **************************************************************************/ bool actionTerminalMger::query(boTerminalInfo &queryInfo,boDbRslt& queryDbRslt) { char buf[500]; char** pcResult; int row,col; if(queryInfo.rtPlace()=="不限"&&queryInfo.rtState()=="不限"&&queryInfo.rtSimId()==""&&queryInfo.rtId()=="") sprintf(buf,"select * from terminal_tbl"); if(queryInfo.rtPlace()!="不限"&&queryInfo.rtState()=="不限"&&queryInfo.rtSimId()==""&&queryInfo.rtId()=="") sprintf(buf,"select * from terminal_tbl where terminal_place='%s'",queryInfo.rtPlace().c_str()); if(queryInfo.rtPlace()=="不限"&&queryInfo.rtState()!="不限"&&queryInfo.rtSimId()==""&&queryInfo.rtId()=="") sprintf(buf,"select * from terminal_tbl where terminal_state='%s'",queryInfo.rtState().c_str()); if(queryInfo.rtPlace()=="不限"&&queryInfo.rtState()=="不限"&&queryInfo.rtSimId()!=""&&queryInfo.rtId()=="") sprintf(buf,"select * from terminal_tbl where terminal_id='%s'",queryInfo.rtSimId().c_str()); if(queryInfo.rtPlace()=="不限"&&queryInfo.rtState()=="不限"&&queryInfo.rtSimId()==""&&queryInfo.rtId()!="") sprintf(buf,"select * from terminal_tbl where terminal_id='%s'",queryInfo.rtId().c_str()); if(queryInfo.rtPlace()!="不限"&&queryInfo.rtState()!="不限"&&queryInfo.rtSimId()==""&&queryInfo.rtId()=="") sprintf(buf,"select * from terminal_tbl where terminal_place='%s' and terminal_state='%s'",queryInfo.rtPlace().c_str(),queryInfo.rtState().c_str()); if(queryInfo.rtPlace()!="不限"&&queryInfo.rtState()=="不限"&&queryInfo.rtSimId()!=""&&queryInfo.rtId()=="") sprintf(buf,"select * from terminal_tbl where terminal_place='%s' and terminal_sim_id='%s'",queryInfo.rtPlace().c_str(),queryInfo.rtSimId().c_str()); if(queryInfo.rtPlace()!="不限"&&queryInfo.rtState()=="不限"&&queryInfo.rtSimId()==""&&queryInfo.rtId()!="") sprintf(buf,"select * from terminal_tbl where terminal_place='%s' and terminal_id='%s'",queryInfo.rtPlace().c_str(),queryInfo.rtId().c_str()); if(queryInfo.rtPlace()=="不限"&&queryInfo.rtState()!="不限"&&queryInfo.rtSimId()!=""&&queryInfo.rtId()=="") sprintf(buf,"select * from terminal_tbl where terminal_state='%s' and terminal_sim_id='%s'",queryInfo.rtState().c_str(),queryInfo.rtSimId().c_str()); if(queryInfo.rtPlace()=="不限"&&queryInfo.rtState()!="不限"&&queryInfo.rtSimId()==""&&queryInfo.rtId()!="") sprintf(buf,"select * from terminal_tbl where terminal_state='%s' and terminal_id='%s'",queryInfo.rtState().c_str(),queryInfo.rtId().c_str()); if(queryInfo.rtPlace()=="不限"&&queryInfo.rtState()=="不限"&&queryInfo.rtSimId()!=""&&queryInfo.rtId()!="") sprintf(buf,"select * from terminal_tbl where terminal_sim_id='%s' and terminal_id='%s'",queryInfo.rtSimId().c_str(),queryInfo.rtId().c_str()); if(queryInfo.rtPlace()!="不限"&&queryInfo.rtState()!="不限"&&queryInfo.rtSimId()!=""&&queryInfo.rtId()=="") sprintf(buf,"select * from terminal_tbl where terminal_place='%s' and terminal_state='%s' and terminal_sim_id='%s'",queryInfo.rtPlace().c_str(),queryInfo.rtState().c_str(),queryInfo.rtSimId().c_str()); if(queryInfo.rtPlace()!="不限"&&queryInfo.rtState()!="不限"&&queryInfo.rtSimId()==""&&queryInfo.rtId()!="") sprintf(buf,"select * from terminal_tbl where terminal_place='%s' and terminal_state='%s' and terminal_id='%s'",queryInfo.rtPlace().c_str(),queryInfo.rtState().c_str(),queryInfo.rtId().c_str()); if(queryInfo.rtPlace()!="不限"&&queryInfo.rtState()=="不限"&&queryInfo.rtSimId()!=""&&queryInfo.rtId()!="") sprintf(buf,"select * from terminal_tbl where terminal_place='%s' and terminal_sim_id='%s' and terminal_id='%s'",queryInfo.rtPlace().c_str(),queryInfo.rtSimId().c_str(),queryInfo.rtId().c_str()); if(queryInfo.rtPlace()=="不限"&&queryInfo.rtState()!="不限"&&queryInfo.rtSimId()!=""