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)
def getUserList(request): # 获取查询条件 userName = request.POST.get('userName', '') userPhone = request.POST.get('userPhone', '') userState = request.POST.get('userState', '') userId = request.POST.get('userId', '') opr = request.POST.get('opr', '') pageSize = request.POST.get('pageSize', 0) currentPage = request.POST.get('currentPage', 0) if pageSize == 0 or pageSize == "": pageSize = 10 pass if currentPage == 0 or currentPage == "": currentPage = 1 pass userDao = UserDao() params = {'userName': userName, 'userPhone': userPhone, 'userState': userState, 'pageSize': int(pageSize), 'currentPage': int(currentPage) } if opr == 'delUser': result = userDao.removeUser([userId]) params['result'] = result pass # 查询用户的个人信息 if opr == 'update': uUser = userDao.findUserByUserId([userId]) return render(request, 'admin/sysmgr/updateuser.html', {'params': params, 'uUser': uUser}) pass # 提交修改用户的个人信息 if opr == 'submitUpdate': userIntro = request.POST.get('userIntro', '') userPicPath = "" # 文件上传 if request.POST: fileObj = request.FILES.get('userPic', None) # 将文件保存到本地 if fileObj: userPicPath = '/static/upload/' + fileObj.name filePath = os.path.join(os.getcwd(), 'static/upload/' + fileObj.name) with open(filePath, 'wb+') as fp: for chunk in fileObj.chunks(): fp.write(chunk) pass pass pass pass result = userDao.updateUser([userPhone, userPicPath, userIntro, userId]) pass counts = userDao.findUserCounts(params) totalPage = counts // int(pageSize) if counts % int(pageSize) == 0 else counts // int(pageSize) + 1 params['counts'] = counts params['totalPage'] = totalPage # 计算两个值:startRow startRow = (int(currentPage) - 1) * int(pageSize) params['startRow'] = startRow userList = userDao.findPageUserList(params) userDao.close() return render(request, 'admin/sysmgr/userinfo.html', {'userList': userList, 'params': params}) pass