def GetListByDepartment(userInfo, departmentId, containChildren): """ 得到指定组织包含的用户列表 Args: departmentId (string): 组织机构主键 containChildren (string): 是否包含子部门 Returns: returnValue (List[Dic[Piuser]]): 用户列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_GetListByDepartment, departmentId + '/' + containChildren) sqlQuery = " SELECT " + Piuser._meta.db_table + ".* FROM " + Piuser._meta.db_table \ + " WHERE (" + Piuser._meta.db_table + ".deletemark = 0 " \ + " AND " + Piuser._meta.db_table + ".enabled = 1 ) " if departmentId: sqlQuery = sqlQuery + " AND ((" + Piuser._meta.db_table + ".departmentid = '" + departmentId + "') " sqlQuery = sqlQuery + " OR id IN (" \ + " SELECT userid" \ + " FROM " + Piuserorganize._meta.db_table \ + " WHERE (" + Piuserorganize._meta.db_table + ".deletemark = 0 ) " \ + " AND (" + Piuserorganize._meta.db_table + ".departmentid = '" + departmentId + "'))) " \ returnValue = DbCommonLibaray.executeQuery(None, sqlQuery) return returnValue
def Add(userInfo, itemsEntity): """ 新增数据 Args: entity (Ciitemdetails): 字典实体 Returns: returnValue (int): statusMessage (stirng): 状态信息 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ItemsService, sys._getframe().f_code.co_name, FrameworkMessage.ItemsService_Add, itemsEntity.id) returnValue = 0 statusMessage = '' if len(Ciitems.objects.filter(Q(id=itemsEntity.id) & Q(deletemark=0))) > 0: returnValue = 0 statusMessage = "已存在相同的明细项!" else: try: itemsEntity.save() returnValue = 1 statusMessage = "成功新增数据!" return returnValue, statusMessage except: returnValue = 0 statusMessage = "操作异常!" return returnValue, statusMessage
def GetDepartmentUsers(userInfo, departmentId, containChildren): """ 得到指定部门包含的用户列表 Args: departmentId (string): 部门主键 containChildren (string): 是否包含子部门 Returns: returnValue (List[Dic[Piuser]]): 用户列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_GetDepartmentUsers, departmentId + '/' + containChildren) returnValue = [] if not departmentId: returnValue = Piuser.objects.filter( Q(deletemark=0)).order_by('sortcode') elif containChildren: organizeIds = OrganizeService.GetChildrensIdByCode( None, Piorganize.objects.get(id=departmentId).code) returnValue = UserSerivce.GetDTByOrganizes(None, organizeIds) else: returnValue = UserSerivce.GetDataTableByDepartment( None, departmentId) return returnValue
def Add(userInfo, entity): """ 新增数据 Args: entity (Ciitemdetails): 字典实体 Returns: returnValue (int): statusMessage (stirng): 状态信息 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ItemDetailsService, sys._getframe().f_code.co_name, FrameworkMessage.ItemDetailsService_Add, entity.id) returnValue = 0 statusMessage = '' if len( ItemDetailsService.GetDTByValues({ 'itemid': entity.itemid, 'itemname': entity.itemname, 'deletemark': 0 })) > 0: returnValue = 0 statusMessage = "已存在相同的明细项!" else: try: entity.save() returnValue = 1 statusMessage = "成功新增数据!" return returnValue, statusMessage except: returnValue = 0 statusMessage = "操作异常!" return returnValue, statusMessage
def SetStaffUser(userInfo, staffId, userId): """ 员工关联用户 Args: staffId (string): 员工主键 userId (string): 用户主键 Returns: returnValue (bool): 关联结果 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.StaffService, sys._getframe().f_code.co_name, FrameworkMessage.StaffService_GetDTByOrganize, staffId + '/' + userId) try: if not userId: with transaction.atomic(): pistaff = Pistaff.objects.get(id=staffId) pistaff.userid = userId pistaff.save() return True else: staffids = Pistaff.objects.filter(userid=userId) if len(staffids) == 0: with transaction.atomic(): pistaff = Pistaff.objects.get(id=staffId) pistaff.userid = userId username = UserSerivce.GetEntity(None, userId).username pistaff.username = username pistaff.save() return True else: return False except: return False
def AddUser(userInfo, userEntity): """ 添加用户 Args: userEntity (Piuser): 用户实体 Returns: returnValue: 用户主键 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_AddUser, userEntity.id) try: userEntity.save() returnCode = StatusCode.statusCodeDic['OKAdd'] returnMessage = FrameworkMessage.MSG0009 returnValue = userEntity.id return returnCode, returnMessage, returnValue except DatabaseError as e: print(e) returnCode = StatusCode.statusCodeDic['DbError'] returnMessage = FrameworkMessage.MSG0001 returnValue = None return returnCode, returnMessage, returnValue except TransactionManagementError as e: print(e) returnCode = StatusCode.statusCodeDic['DbError'] returnMessage = FrameworkMessage.MSG0001 returnValue = None return returnCode, returnMessage, returnValue
def Add(userInfo, entity): """ 用户名是否重复 Args: entity (Pirole): Returns: returnValue(bool): 新增结果 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.RoleService, sys._getframe().f_code.co_name, FrameworkMessage.RoleService_Add, entity.id) try: entity.save() returnCode = StatusCode.statusCodeDic['OKAdd'] returnMessage = FrameworkMessage.MSG0009 returnValue = entity.id return returnCode, returnMessage, returnValue except DatabaseError as e: print(e) returnCode = StatusCode.statusCodeDic['DbError'] returnMessage = FrameworkMessage.MSG0001 returnValue = None return returnCode, returnMessage, returnValue except TransactionManagementError as e: print(e) returnCode = StatusCode.statusCodeDic['DbError'] returnMessage = FrameworkMessage.MSG0001 returnValue = None return returnCode, returnMessage, returnValue pass
def SearchByPage(self, userInfo, permissionScopeCode, search, roleIds, enabled, auditStates, departmentId, pageIndex=0, pageSize=20, order=None): LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_SearchByPage, '') whereConditional = UserSerivce.GetSearchConditional( None, userInfo, permissionScopeCode, search, roleIds, enabled, auditStates, departmentId) #countSqlQuery = ' SELECT * FROM ' + Piuser._meta.db_table + ' WHERE ' countSqlQuery = 'SELECT * FROM (SELECT PIUSER.*, PIUSERLOGON.FIRSTVISIT, PIUSERLOGON.PREVIOUSVISIT, PIUSERLOGON.LASTVISIT, PIUSERLOGON.IPADDRESS, PIUSERLOGON.MACADDRESS, PIUSERLOGON.LOGONCOUNT, PIUSERLOGON.USERONLINE, PIUSERLOGON.CHECKIPADDRESS, PIUSERLOGON.MULTIUSERLOGIN FROM PIUSER LEFT OUTER JOIN PIUSERLOGON ON PIUSER.ID = PIUSERLOGON.ID WHERE PIUSER.DELETEMARK = 0 AND PIUSER.ISVISIBLE = 1 AND (PIUSER.ENABLED = 1) ORDER BY PIUSER.SORTCODE) PIUSER WHERE ' countSqlQuery = countSqlQuery + ' ' + whereConditional userList = DbCommonLibaray.executeQuery(self, countSqlQuery) pageValue = Paginator(userList, pageSize) page = pageValue.page(pageIndex) return pageValue.count, page
def GetDtByPage(userInfo, pageSize=20, whereConditional="", order=""): """ 取得角色列表 Args: whereConditional (string): 查询字段 pageSize (int): 每页显示 order (string): 排序 Returns: recordCount (int): 角色数 returnValue (List): 角色分页列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.RoleService, sys._getframe().f_code.co_name, FrameworkMessage.RoleService_GetDTByPage, '') if not whereConditional: if not order: whereConditional = 'SELECT * FROM ' + Pirole._meta.db_table + ' WHERE deletemark = 0' else: whereConditional = 'SELECT * FROM ' + Pirole._meta.db_table + ' WHERE deletemark = 0 ORDER BY ' + order else: if not order: 'SELECT * FROM ' + Pirole._meta.db_table + ' WHERE ' + whereConditional + ' AND deletemark = 0' else: whereConditional = 'SELECT * FROM ' + Pirole._meta.db_table + ' WHERE ' + whereConditional + ' AND deletemark = 0 ORDER BY ' + order staffList = DbCommonLibaray.executeQuery(None, whereConditional) returnValue = Paginator(staffList, pageSize) return returnValue
def GetDTByOrganize(userInfo, organizeId, showUser=True): """ 按组织机构获取角色列表 Args: organizeId (string) : 组织机构主键 showUser (bool) : 显示用户 Returns: returnValue (Pirole[]): 角色列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.RoleService, sys._getframe().f_code.co_name, FrameworkMessage.RoleService_GetDTByOrganize, organizeId) dtRole = Pirole.objects.filter( Q(organizeid=organizeId) & Q(deletemark=0)).order_by('sortcode') if showUser: username = '' dataTableUser = UserSerivce.GetDT(None) for role in dtRole: userIds = UserSerivce.GetUserIdsInRole(None, role.id) if userIds: for userid in userIds: username = username + Piuser.objects.get( id=userid).realname + ', ' if username: role.users = username[:-2] username = "" return dtRole
def GetUserIdsByOrganizeIdsAndRoleIds(userInfo, receiverIds, organizeIds, roleIds): LogService.WriteLog( userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_GetUserIdsByOrganizeIdsAndRoleIds, '') companyUsers = Piuser.objects.filter( Q(deletemark=0) & Q(enabled=1) & Q(workgroupid__in=organizeIds) & Q(departmentid__in=organizeIds) & Q(subcompanyid__in=organizeIds) & Q(companyid__in=organizeIds) | Q(id__in=Piuserorganize.objects.filter( Q(deletemark=0) & (Q(departmentid__in=organizeIds) | Q(subdepartmentid__in=organizeIds) | Q(companyid__in=organizeIds))))).order_by( 'sortcode').values_list('id', flat=True) roleUsers = Piuserrole.objects.filter( Q(roleid__in=roleIds) & Q(userid__in=Piuser.objects.filter(Q( deletemark=0)).values_list('id', flat=True))) users = companyUsers.union(roleUsers) returnValue = [] for id in users: returnValue.append(id) receiverIds.extend(returnValue) return receiverIds
def Add(userInfo, sequenceEntity): """ 添加序列 Args: sequenceEntity (Cisequence): Returns: returnCode(string): 状态码 returnMessage(string): 状态信息 returnValue(string): 主键 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.SequenceService, sys._getframe().f_code.co_name, FrameworkMessage.SequenceService_Add, id) try: sequenceEntity.save() returnCode = StatusCode.statusCodeDic['OKAdd'] returnMessage = FrameworkMessage.MSG0009 returnValue = sequenceEntity.id return returnCode, returnMessage, returnValue except DatabaseError as e: print(e) returnCode = StatusCode.statusCodeDic['DbError'] returnMessage = FrameworkMessage.MSG0001 returnValue = None return returnCode, returnMessage, returnValue except TransactionManagementError as e: print(e) returnCode = StatusCode.statusCodeDic['DbError'] returnMessage = FrameworkMessage.MSG0001 returnValue = None return returnCode, returnMessage, returnValue pass
def GetUserDTByRole(userInfo, roleId): """ 按角色获取用户列表 Args: roleId (string): 角色主键 Returns: returnValue (List): 用户实体列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_GetUserDTByRole, roleId) sqlQuery = " SELECT " + 'piuser' + ".* " \ + "," + 'piuserlogon' + "." + 'useronline' \ + " FROM PIUSER LEFT OUTER JOIN PIUSERLOGON ON PIUSER.ID = PIUSERLOGON.ID " sqlQuery = sqlQuery + " WHERE (" + 'piuser' + "." + 'deletemark' + " = 0 " + " AND " + 'piuser' + "." + 'enabled' + " = 1 " + " AND " + 'piuser' + "." + 'isvisible' + " = 1 ) " if roleId: sqlQuery = sqlQuery + " AND (" + 'piuser' + "." + 'roleid' + " = '" + roleId + "') " sqlQuery += " OR " + 'piuser' + "." + 'id' + " IN (" \ + " SELECT " + 'userid' \ + " FROM " + 'piuserrole' \ + " WHERE " + 'piuserrole' + "." + 'deletemark' + " = 0 " \ + " AND " + 'piuserrole' + "." + 'enabled' + " = 1 " \ + " AND " + 'piuserrole' + "." + 'roleid' + " = '" + roleId + "') " sqlQuery += " ORDER BY " + 'piuser' + "." + 'sortcode' dataTable = DbCommonLibaray.executeQuery(None, sqlQuery) return dataTable
def GetDTByPage(userInfo, searchValue, pageSize=50, order=None): """ 分页查询 Args: searchValue (string): 查询字段 pageSize (int): 每页显示 order (string): 排序 Returns: staffCount (int): 所有员工数 returnValue (Paginator): 员工分页列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.StaffService, sys._getframe().f_code.co_name, FrameworkMessage.StaffService_GetDTByPage, '') if not searchValue: if not order: whereConditional = 'SELECT * FROM ' + Pistaff._meta.db_table + ' WHERE deletemark = 0' else: whereConditional = 'SELECT * FROM ' + Pistaff._meta.db_table + ' WHERE deletemark = 0 ORDER BY ' + order else: if not order: 'SELECT * FROM ' + Pistaff._meta.db_table + ' WHERE ' + searchValue + ' AND deletemark = 0' else: whereConditional = 'SELECT * FROM ' + Pistaff._meta.db_table + ' WHERE ' + searchValue + ' AND deletemark = 0 ORDER BY ' + order staffList = DbCommonLibaray.executeQuery(None, whereConditional) returnValue = Paginator(staffList, pageSize) staffCount = returnValue.count return staffCount,returnValue
def BatchDelete(userInfo, ids): """ 单个删除用户 Args: ids (string[]): 用户主键列表 Returns: returnValue (True or False): 删除结果 """ # 已删除用户Piuser表中的DELETEMARK设置为1 LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_BatchDelete, str(ids)) try: user = Piuser.objects.filter(id__in=ids) if len(user) == 0: return False user.update(deletemark=1) except Exception as e: return False # 用户已经被删除的员工的UserId设置为Null Pistaff.objects.filter(userid__in=Piuser.objects.filter( id__in=ids)).update(userid=None) # 清除用户的操作权限 for id in ids: UserPermission.ClearUserPermissionByUserId(None, id) return True
def GetDTByOrganize(userInfo, organizeId, containChildren): """ 按组织结构获取员工列表 Args: organizeId (string): 组织结构id containChildren (bool): 组织结构是否包含子机构 Returns: returnValue (List): 员工列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.StaffService, sys._getframe().f_code.co_name, FrameworkMessage.StaffService_GetDTByOrganize, organizeId) if containChildren: organizeIds = OrganizeService.GetChildrensById(None, organizeId) staffIds = [] for staff in Pistafforganize.objects.filter(Q(organizeid__in=organizeIds) & Q(deletemark=0)): staffIds.append(staff.staffid) returnValue = Pistaff.objects.filter(Q(id__in=staffIds) & Q(deletemark=0)).order_by('sortcode') return returnValue else: starffIds = [] for staff in Pistafforganize.objects.filter(Q(organizeid=organizeId) & Q(deletemark=0)): starffIds.append(staff.staffid) returnValue = Pistaff.objects.filter(Q(id__in=starffIds) & Q(deletemark=0)).order_by('sortcode') return returnValue
def Delete(userInfo, id): """ 单个删除用户 Args: id (string): 主键 Returns: returnValue (True or False): 删除结果 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_Delete, id) try: #已删除用户Piuser表中的DELETEMARK设置为1 try: user = Piuser.objects.get(id=id) except Piuser.DoesNotExist as e: return False user.deletemark = 1 user.save() #用户已经被删除的员工的UserId设置为Null Pistaff.objects.filter(userid__in=Piuser.objects.filter( deletemark=1)).update(userid=None) # 清除用户的操作权限 UserPermission.ClearUserPermissionByUserId(None, id) return True except Exception as e: return False
def GetSearchConditional(userInfo, permissionScopeCode, search, roleIds, enabled, auditStates, departmentId): """ 获取SQL查询串 Args: permissionScopeCode (string): 权限码 search (string): 查询字段 roleIds (string[]): 用户角色ID字典 enabled (string): 启用标志 auditStates (string): 审核状态 departmentId (string): 组织机构ID Returns: returnValue (int): SQL组合查询串 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_UpdateUser, '') #easyui search whereConditional = 'piuser.DELETEMARK = 0 AND piuser.ISVISIBLE = 1 ' if enabled: whereConditional = whereConditional + ' AND ( piuser.ENABLED = 1 ) ' if search: whereConditional = whereConditional + ' AND ( piuser.USERNAME LIKE \'' + search + '\'' \ + ' OR piuser.CODE LIKE \'' + search + '\'' \ + ' OR piuser.REALNAME LIKE \'' + search + '\'' \ + ' OR piuser.QUICKQUERY LIKE \'' + search + '\'' \ + ' OR piuser.DEPARTMENTNAME LIKE \'' + search + '\'' \ + ' OR piuser.DESCRIPTION LIKE \'' + search + '\')' if departmentId: organizeIds = OrganizeService.GetChildrensById(None, departmentId) if len(organizeIds) > 0: whereConditional = whereConditional + ' AND (piuser.COMPANYID IN (' + StringHelper.ArrayToList(None, organizeIds, '\'') + ')' \ + ' OR piuser.COMPANYID IN (' + StringHelper.ArrayToList(None, organizeIds, '\'') + ')' \ + ' OR piuser.DEPARTMENTID IN (' + StringHelper.ArrayToList(None, organizeIds, '\'') + ')' \ + ' OR piuser.SUBDEPARTMENTID IN (' + StringHelper.ArrayToList(None, organizeIds, '\'') + ')' \ + ' OR piuser.WORKGROUPID IN (' + StringHelper.ArrayToList(None, organizeIds, '\'') + '))' whereConditional = whereConditional + ' OR piuser.ID IN (' \ + ' SELECT ID' \ + ' FROM piuser' \ + ' WHERE (piuserorganize.DELETEMARK = 0)' \ + ' AND (' \ + ' piuserorganize.COMPANYID=' + departmentId + '\' OR ' \ + ' piuserorganize.SUBCOMPANYID=' + departmentId + '\' OR ' \ + ' piuserorganize.DEPARTMENTID=' + departmentId + '\' OR ' \ + ' piuserorganize.SUBDEPARTMENTID=' + departmentId + '\' OR ' \ + ' piuserorganize.WORKGROUPID=' + departmentId + '\'))' if auditStates: whereConditional = whereConditional + ' AND (piuser.AUDITSTATUS=\'' + auditStates + '\')' if roleIds: roles = StringHelper.ArrayToList(None, roleIds, '\'') whereConditional = whereConditional + ' AND (piuser.ID IN ( SELECT USERID FROM piuserrole WHERE ROLEID IN (' + roles + ')))' return whereConditional
def Add(userInfo, parameterEntity): """ 添加模块菜单 Args: parameterEntity (Ciparameter): 参数实体 Returns: returnCode: 状态码 returnMessage: 状态信息 returnValue: 主键 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ParameterService, sys._getframe().f_code.co_name, FrameworkMessage.ParameterService_Add, parameterEntity.id) try: parameterEntity.save() returnCode = StatusCode.statusCodeDic['OKAdd'] returnMessage = FrameworkMessage.MSG0009 returnValue = parameterEntity.id return returnCode, returnMessage, returnValue except DatabaseError as e: print(e) returnCode = StatusCode.statusCodeDic['DbError'] returnMessage = FrameworkMessage.MSG0001 returnValue = None return returnCode, returnMessage, returnValue except TransactionManagementError as e: print(e) returnCode = StatusCode.statusCodeDic['DbError'] returnMessage = FrameworkMessage.MSG0001 returnValue = None return returnCode, returnMessage, returnValue
def GetDTByPage(userInfo, searchValue, departmentId, roleId, pageSize=50, order=None): """ 分页查询 Args: searchValue (string): 查询字段 departmentId (string): 部门主键 roleId (string): 角色主键 pageSize (int): 每页显示 order (string): 排序 Returns: returnValue (Paginator): 用户分页列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_GetDTByPage, '') #countSqlQuery =' SELECT * FROM ' + Piuser._meta.db_table + ' WHERE ' countSqlQuery = 'SELECT PIUSER.* ,PIUSERLOGON.FIRSTVISIT,PIUSERLOGON.PREVIOUSVISIT,PIUSERLOGON.LASTVISIT,PIUSERLOGON.IPADDRESS,PIUSERLOGON.MACADDRESS,PIUSERLOGON.LOGONCOUNT,PIUSERLOGON.USERONLINE FROM PIUSER LEFT OUTER JOIN PIUSERLOGON ON PIUSER.ID = PIUSERLOGON.ID WHERE ' whereConditional = Piuser._meta.db_table + '.DELETEMARK' + ' = 0 ' \ + " AND " + Piuser._meta.db_table + '.ENABLED' + ' = 1 ' \ + " AND " + Piuser._meta.db_table + '.ISVISIBLE' + ' = 1 ' if departmentId: organizeIds = OrganizeService.GetChildrensById(None, departmentId) if len(organizeIds) != 0: whereConditional = whereConditional + " AND (" + Piuser._meta.db_table + '.COMPANYID IN (' + StringHelper.ArrayToList(None,organizeIds,"\'") + ')' \ + " OR " + Piuser._meta.db_table + '.SUBCOMPANYID IN (' + StringHelper.ArrayToList(None,organizeIds,"\'") + ')' \ + " OR " + Piuser._meta.db_table + '.DEPARTMENTID IN (' + StringHelper.ArrayToList(None,organizeIds,"\'") + ')' \ + " OR " + Piuser._meta.db_table + '.SUBDEPARTMENTID IN (' + StringHelper.ArrayToList(None,organizeIds,"\'") + ')' \ + " OR " + Piuser._meta.db_table + '.WORKGROUPID IN (' + StringHelper.ArrayToList(None,organizeIds,"\'") + '))' if roleId: whereConditional = whereConditional + ' AND ( ' + Piuser._meta.db_table + '.ID IN' \ + ' (SELECT USERID FROM ' + Piuserrole._meta.db_table \ + ' WHERE ROLEID = \'' + roleId + '\'' \ + ' AND ENABLED = 1' \ + ' AND DELETEMARK = 0 ))' if searchValue: whereConditional = whereConditional + " AND (" + searchValue + ')' if order: whereConditional = whereConditional + " ORDER BY " + order countSqlQuery = countSqlQuery + ' ' + whereConditional userList = DbCommonLibaray.executeQuery(None, countSqlQuery) returnValue = Paginator(userList, pageSize) return returnValue
def GetDTNotOrganize(userInfo): """ 得到未设置组织机构的员工列表 Args: Returns: returnValue (List): 员工列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.StaffService, sys._getframe().f_code.co_name, FrameworkMessage.StaffService_GetDTByOrganize, '') returnValue = Pistaff.objects.filter(Q(deletemark=0) & ~Q(id__in=Pistafforganize.objects.filter(Q(deletemark=0) & Q(enabled=1)).values_list('staffid', flat=True))) return returnValue
def SetDeleted(userInfo, id): """ 逻辑删除 Args: id (string): 参数项主键 Returns: returnValue (int): 影响行数 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ParameterService, sys._getframe().f_code.co_name, FrameworkMessage.ParameterService_SetDeleted, id) returnValue = Ciparameter.objects.filter(id=id).update(deletemark=1) return returnValue
def Delete(userInfo, id): """ 删除参数 Args: id (string): 参数键值 Returns: returnValue (int): 影响行数 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ParameterService, sys._getframe().f_code.co_name, FrameworkMessage.ParameterService_Add, id) returnValue = Ciparameter.objects.filter(id=id).delete() return returnValue
def SetDeleted(userInfo, ids): """ 设置删除标志 Args: ids (string[]): 主键列表 Returns: returnValue (): 返回值 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ItemsService, sys._getframe().f_code.co_name, FrameworkMessage.ItemsService_SetDeleted, str(ids)) returnValue = Ciitems.objects.filter(Q(id__in=ids)).update(deletemark=1) return returnValue
def GetDTByParameter(userInfo, categoryKey, parameterId): """ 获取记录 Args: categoryKey (string): 类别主键 parameterId (string): 标志主键 Returns: returnValue (Ciparameter[]): 数据表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ParameterService, sys._getframe().f_code.co_name, FrameworkMessage.ParameterService_GetDTByParameter, parameterId) returnValue = Ciparameter.objects.filter(Q(categorykey=categoryKey) & Q(parameterid=parameterId) & Q(deletemark=0)) return returnValue
def SetDeleted(userInfo, ids): """ 批量逻辑删除消息 Args: userInfo (string): 用户 ids (List[string]): 主键数组 Returns: returnValue (Cimessage[]): 数据表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.MessageService, sys._getframe().f_code.co_name, FrameworkMessage.MessageService_SetDeleted, str(ids)) returnValue = Cimessage.objects.filter(id__in=ids).update(deletemark=1) return returnValue
def GetServiceConfig(userInfo, key): """ 获取服务器上的配置信息 Args: key (string): 配置项主键 Returns: returnValue (string): 配置内容 """ if userInfo: LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ParameterService, sys._getframe().f_code.co_name, FrameworkMessage.ParameterService_GetServiceConfig, id) BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__))) config = ConfigObj(BASE_DIR + r'\..\..\utilities\config\Config.ini', encoding='UTF8') return config['appSettings'][key]
def SetParameter(userInfo, categoryKey, parameterId, parameterCode, parameterContent, allowEdit=0, allowDelete=0): """ 设置参数值 Args: categoryKey (string): 分类键值 parameterId (string): 参数主键 parameterCode (string): 参数编号 parameterContent (string): 参数内容 allowEdit (int): 允许编辑 allowDelete (int): 允许删除 Returns: returnValue (int): 影响行数 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ParameterService, sys._getframe().f_code.co_name, FrameworkMessage.ParameterService_SetParameter, id) returnValue = 0 if not parameterContent: returnValue = Ciparameter.objects.filter( Q(categorykey=categoryKey) & Q(parameterid=parameterId) & Q(parametercode=parameterCode) & Q(deletemark=0)).delete() else: returnValue = Ciparameter.objects.filter( Q(categorykey=categoryKey) & Q(parameterid=parameterId) & Q(parametercode=parameterCode) & Q(deletemark=0)).update(parametercontent=parameterContent) if returnValue == 0: parameterEntity = Ciparameter() parameterEntity.categorykey = categoryKey parameterEntity.parameterid = parameterId parameterEntity.parametercode = parameterCode parameterEntity.parametercontent = parameterContent parameterEntity.allowdelete = allowDelete parameterEntity.allowedit = allowEdit parameterEntity.createon = datetime.datetime.now() parameterEntity.modifiedon = parameterEntity.createon parameterEntity.enabled = 1 parameterEntity.worked = 0 parameterEntity.deletemark = 0 parameterEntity.save() returnValue = 1 return returnValue
def BatchDelete(userInfo, ids): """ 批量删除 Args: id (string): 参数项主键 Returns: returnValue (int): 影响行数 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.SequenceService, sys._getframe().f_code.co_name, FrameworkMessage.SequenceService_Delete, id) returnValue = Cisequence.objects.filter(id__in=ids).delete() return returnValue
def GetId(userInfo, valueDic): """ 获取主键 Args: valueDic (Dic{key:value}): 参数对 Returns: returnValue (string[]): ID列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.StaffService, sys._getframe().f_code.co_name, FrameworkMessage.StaffService_GetId, '') q = Q() for i in valueDic: q.add(Q(**{i: valueDic[i]}), Q.AND) returnValue = Pistaff.objects.filter(q).values_list('id', flat=True) return returnValue