/**
* return 103;//管理员添加成功
* return 104;//管理员添加失败
* return 105;//管理员添加失败：ID重复
*/
int AdminService::addAdmin(Admin admin){
string sql="insert into admin(a_id,a_name,a_psd,a_priority)values('"+admin.getId()+"','"
+admin.getName()+"','"+admin.getPsd()+"','"+admin.getPriority()+"')";
string sql1="update admin set a_loginState='0' where a_id='"+admin.getId()+"'";
cout<<"insert admin sql:"<<sql<<endl;
int tmp = this->SelectAdminExist(admin.getId());
if(tmp==0){
DBConn db;
if(db.Execute_mysql(sql)==0){
db.Execute_mysql(sql1); //添加成功一个admin，默认登录状况为未登录把loginState设置为“0”
db.Close_mysql();
return 103; //添加成功
}
db.Close_mysql();
return 104; //添加失败
}else{
return 105; //添加失败：ID重复
}
}
/**
* return 108;//管理员更新成功
* return 109;//管理员更新失败
*/
int AdminService::updateAdmin(Admin admin){
string sql = "update admin set a_name='"+ admin.getName() + "',a_psd='" + admin.getPsd() + "',a_priority='"+ admin.getPriority() +"' where u_id='"+admin.getId()+"'";
cout<<"AdminService::updateAdmin ---- update sql="<<sql<<endl;
DBConn db;
if(db.Execute_mysql(sql)==0){
db.Close_mysql();
return 108;
}else{
db.Close_mysql();
return 109;
}
}
int AdminService::AddAdmin(Admin admin){
string sql="insert into admin(a_id,a_name,a_psd,a_priority)values('"+admin.getId()+"','"+admin.getName()+"','"+admin.getPsd()+"','"+admin.getPriority()+"')";
}
