from admin.dboper import *

#用户登录业务
def admin_login(username, password):
    sql = "select username, truename, rolename from userInfo where username='%s' and UPassword='%s'" % (username, password)
    #print(sql)
    results = mySQL_Query(sql)
    return results

#查询所有用户
def loadalluser():
    sql = "select UserID,UserName,TrueName,UPassword, RoleName, Telephone,UStatus from userinfo"
    results = mySQL_Query(sql)
    return results

#添加一个用户
def add_user(user):
    #username, truename, upassword, rolename, telephone,ustatus
    sql = "insert into userinfo values (NULL, '%s', '%s', '%s', '%s', '%s',1) " % (user[0], user[1], user[2], user[3], user[4])
    i, msg = mySQL_Execute(sql)
    return i, msg

#删除一个用户
def del_user(userid):
    sql = "delete from userinfo where userid =%s" % userid
    i, msg = mySQL_Execute(sql)
    return i, msg


#根据用户ID查询一个用户
def getUserByID(userid):
    sql = "select username, truename, rolename, telephone, ustatus from userInfo where userid=%s" % (userid)
    results = mySQL_Query(sql)
    return results

#修改一个用户信息
def update_userinfo(data, userid):
    sql = "update userinfo set username='%s', truename='%s', RoleName='%s', telephone='%s',  ustatus=%s  where USerID=%s;" % (
    data[0], data[1], data[2], data[3], data[4], userid)
    i, msg = mySQL_Execute(sql)
    return i, msg

#查询用户密码
def checkoldpassword(userid, oldpassword):
    sql = "select UserID, UPassword from userinfo where UserID=%s and UPassword='%s';" % (userid, oldpassword)
    results = mySQL_Query(sql)
    return results

#修改用户密码
def change_Password(userid, newpassword):
    sql = "update userinfo set UPassword='%s' where UserID=%s;" % (newpassword, userid)
    i, msg = mySQL_Execute(sql)
    return i, msg