Пример #1
0
def user():
    userDao = UserDao()
    paramDict = {}
    if request.method == "POST":
        opr = request.form.get('opr')
        if opr == "add":
            userName = request.form.get('userName')
            phoneno = request.form.get('phoneno')
            email = request.form.get('email')
            params = [userName, '123456', '', 0, phoneno, email]
            result = userDao.createUser(params)
            userDao.commit()
        elif opr == "update":
            id = request.form.get('id')
            phoneno = request.form.get('phoneno')
            email = request.form.get('email')
            params = [phoneno, email]
            result = userDao.updateUser(params, id)
            userDao.commit()
            pass
        elif opr == "search":
            searhName = request.form.get('searchName')
            pageSize = request.form.get('pageSize')
            currentPage = request.form.get('currentPage')
            paramDict['searchName'] = searhName
            paramDict['pageSize'] = int(pageSize)
            paramDict['currentPage'] = int(currentPage)
            pass
    else:
        opr = request.args.get("opr")
        if opr == "disable":
            id = request.args.get('id')
            userDao.disableUserByUserId(id)
            userDao.commit()
            pass
        pass
    if paramDict.get('pageSize') == None or paramDict.get(
            'currentPage') == None:
        paramDict['pageSize'] = 10
        paramDict['currentPage'] = 1
        pass

    if not paramDict.get('searchName'):
        paramDict['searchName'] = ""
        pass
    userList = userDao.getUserListPage(paramDict)
    counts = userDao.getUserCounts(paramDict).get("counts")
    # 计算总共有多少页
    totalPage = int(
        counts // paramDict.get('pageSize')) if counts % paramDict.get(
            'pageSize') == 0 else int(counts // paramDict.get('pageSize')) + 1

    paramDict['totalPage'] = totalPage
    paramDict['counts'] = counts
    return render_template('sys/user.html',
                           userList=userList,
                           paramDict=paramDict)