string FacilityService::SelectSignle(string id) {
string sql = "select * from facility where facility_id="
+ Utils::AddSingleQuoteMark(id);
DBConn db;
string res = db.Query_single_mysql(sql);
return res;
}
string UserService::SelectSignle(string u_id){
DBConn db;
string sql=SELECT_SINGLE_USER_SQL+Utils::AddSingleQuoteMark(u_id);
string res=db.Query_single_mysql(sql);
db.Close_mysql();
return res;
}
/*按id查询单个管理员*/
string AdminService::selectSingleAdmin(string a_id){
cout<<"AdminService::slelectSingleAdmin ---------i'm here"<<endl;
DBConn db;
string sql = SELECT_SINGLE_ADMIN_SQL+Utils::AddSingleQuoteMark(a_id);
cout<<"select single sql= "<<sql<<endl;
string res = db.Query_single_mysql(sql);
cout<<"AdminService::selectSingleAdmin(), res="<<res<<endl;
db.Close_mysql();
return res;
}
/*按id查询管理员权限*/
string AdminService::GetAdminPriority(string a_id){
Json::Value value;
Json::Reader reader;
string reVal;
DBConn db;
string sql = "select a_priority from admin where a_id='"+a_id+"'";
cout<<"AdminService::GetAdminPriority-----sql="<<sql<<endl;
if (reader.parse(db.Query_single_mysql(sql),value)) {
reVal = value["a_priority"].asString();
}
cout<<"AdminService::GetAdminPriority-----res="<<reVal<<endl;
return reVal;
}