/**
*查询同一个会议室的IP是否有重
*/
int FacilityService::SelectFacilityExist(string id, string ip, string mr_id) {
string sql = "select facility_id from facility where facility_id=" + Utils::AddSingleQuoteMark(id);
string sql1 = "select meetroom_id from facility where facility_ip=" + Utils::AddSingleQuoteMark(ip);
DBConn db;
string facility_id = db.Query_mysql(sql);
db.Close_mysql();
if (ip.empty() || mr_id.empty()) {//用户增加一个设备仅填写ID的情况
if (facility_id.empty()) {
return 300;
} else {
return 301; //ID已存在
}
} else {
if (facility_id.empty()) {
DBConn db;
string meetroom_id = db.Query_mysql(sql1);
db.Close_mysql();
if (meetroom_id == mr_id) {
return 302; //IP重复
} else {
return 300;
}
} else {
return 301; //ID已存在
}
}
/*
string sql="select facility_id from facility where facility_id="+Utils::AddSingleQuoteMark(id);
cout<<"check sql:"<<sql<<endl;
string sql1="select meetroom_id from facility where facility_ip="+Utils::AddSingleQuoteMark(ip);
cout<<"check sql:"<<sql1<<endl;
DBConn db;
string facility_id=db.Query_mysql(sql);
string res_id=db.Query_mysql(sql1);
db.Close_mysql();
if(facility_id.empty()){
if(res_id!=mr_id){
return 500;//同一个会议室内无重复IP，可以插入
}else{
return 501;//IP 重复
}
}else{
return 502;//ID被用
}*/
}
int MeetroomService::SelectMeetroomExist(string mr_id){
DBConn db;
string sql=SELECT_MR_ID_SQL+Utils::AddSingleQuoteMark(mr_id);
string res=db.Query_mysql(sql);
if(res.empty()==true){
return 0;
}
return -1;
}
int FacilityService::SelectFacilityExist(string id, string ip) {
string sql = "select facility_name from facility where facility_id=" + Utils::AddSingleQuoteMark(id);
string sql1 = "select facility_id from facility where facility_ip=" + Utils::AddSingleQuoteMark(ip);
DBConn db;
string res_name = db.Query_mysql(sql);
string res_id = db.Query_mysql(sql1);
db.Close_mysql();
if (res_id.empty()) { //查看该IP是否被占用
if (res_name.empty()) { //查看该ID是否存在
return 300; //可以添加
} else {
return 302; //该ID已存在
}
} else {
return 301; //IP被占用
}
}
int UserService::SelectUserExist(string u_id){
DBConn db;
string sql="select u_name from user where u_id='"+u_id+"'";
string res=db.Query_mysql(sql);
if(res.empty()==true){
cout<<"无重复，可插入！"<<endl;
return 0;
}
cout<<"重复，不可插入！"<<endl;
return -1;
}
/**
* return 100;//登录成功
* return 101;//登录失败 ：密码错误
* return 102;//登录失败：ID不存在
*/
int AdminService::LoginSys(string a_id,string a_psd){
DBConn db;
string sql="select a_psd from admin where a_id="+Utils::AddSingleQuoteMark(a_id);
string res=db.Query_mysql(sql);
if(res.empty()==true){
return 102;
}else if(res==a_psd){
return 100;
}else{
return 101;
}
}
/*检查是否已有此id的admin
*@return 0:无重复 -1：重复
*
* */
int AdminService::SelectAdminExist(string a_id){
DBConn db;
string sql = "select a_id from admin where a_id='"+a_id+"'";
cout<<"i'm in the AdminService::SelectAdminExist, sql="<<sql<<endl;
string res = db.Query_mysql(sql);
cout<<"i'm in the AdminService::SelectAdminExist, res="<<res<<endl;
if(res.empty()==true){
cout<<"无重复，可插入!"<<endl;
return 0;
}
cout<<"重复，不可插入!"<<endl;
return -1;
}
/**
* return 100;//登录成功
* return 101;//登录失败 ：密码错误
* return 102;//登录失败：ID不存在
*/
int AdminService::LoginSys(string a_id,string a_psd){
DBConn db;
string sql="select a_psd from admin where a_id="+Utils::AddSingleQuoteMark(a_id);
string sql1="update admin set a_loginState='1' where a_id='"+a_id+"'";
string res=db.Query_mysql(sql);
db.Close_mysql();
if(res.empty()==true){
return 102;
}else if(res==a_psd){
cout<<"AdminServcie::LoginSys-------- i'm before db.Execute_mysql"<<endl;
DBConn db;
db.Execute_mysql(sql1); //如果登录成功，就把loginState设为“1”
cout<<"AdminServcie::LoginSys-------- i'm after db.Execute_mysql"<<endl;
db.Close_mysql();
return 100;
}else{
return 101;
}
}