def get_all_user_page(self,_page,_limit): _users = Sysuser.objects.all().order_by('id')[(int(_page)-1)*int(_limit):int(_page)*int(_limit)] _count = Sysuser.objects.all().count() # 将查询集里的model遍历 将model属性和属性值转成字典 _dict_users = tools.queryset_to_json(_users) _data_page_json = {} _data_page_json['Rows']=_dict_users _data_page_json['Total']=_count return json.dumps(_data_page_json,ensure_ascii=False)
def get_roles_page(self,_page,_limit): _roles = SysRole.objects.all()[(int(_page)-1)*int(_limit):int(_page)*int(_limit)] _count = SysRole.objects.all().count() # 将查询集里的model遍历 将model属性和属性值转成字典 _dict_roles = tools.queryset_to_json(_roles) _data_page_json = {} _data_page_json['Rows']=_dict_roles _data_page_json['Total']=_count return json.dumps(_data_page_json,ensure_ascii=False)
def get__user_by_role_page(self,_page,_limit,_role_id): # 取字段values_list flat=True为单个显示 去掉为元祖显示 _user_ids = SysUserRole.objects.all().filter(roleid=_role_id).values_list("userid", flat=True) _count = SysUserRole.objects.all().filter(roleid=_role_id).count() # __in 条件的值 _users = Sysuser.objects.filter(id__in=_user_ids)[(int(_page)-1)*int(_limit):int(_page)*int(_limit)] _dict_users = tools.queryset_to_json(_users) _data_page_json = {} _data_page_json['Rows']=_dict_users _data_page_json['Total']=_count return json.dumps(_data_page_json,ensure_ascii=False)