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 SetDeleted(userInfo, id): """ 逻辑删除 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=id).update(deletemark=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 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 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 GetEntity(userInfo, id): """ 获取实体 Args: id (string): 主键 Returns: returnValue (Ciparameter): 配置实体 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ParameterService, sys._getframe().f_code.co_name, FrameworkMessage.ParameterService_GetEntity, id) try: returnValue = Ciparameter.objects.get(id=id) return returnValue except Ciparameter.DoesNotExist: return None
def SetDeleted(userInfo, ids): """ 批量逻辑删除角色 Args: ids (string[]): 主键列表 Returns: returnValue (True or False): 删除结果 """ #TODO:此处还应该把角色相应的权限,所拥有的用户等也做统一处理。 LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.RoleService, sys._getframe().f_code.co_name, FrameworkMessage.RoleService_SetDeleted, str(ids)) returnValue = Pirole.objects.filter(Q(id__in=ids)).update(deletemark=1) return returnValue
def GetEntity(userInfo, id): """ 获取员工实体 Args: id (string): 员工主键 Returns: returnValue (Staff or None): 员工实体 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.StaffService, sys._getframe().f_code.co_name, FrameworkMessage.StaffService_GetEntity, id) try: staff = Pistaff.objects.get(id=id) return staff except Pistaff.DoesNotExist: return None
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
def GetEntity(userInfo, id): """ 获取实体 Args: id (stirng): 主键 Returns: returnValue (Ciitems): """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ItemsService, sys._getframe().f_code.co_name, FrameworkMessage.ItemsService_GetEntity, id) try: returnValue = Ciitems.objects.get(id=id) return returnValue except: return None
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 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 GetCompanyUser(userInfo, user): """ 得到当前用户所在公司的用户列表 Args: user (Piuser): 当前用户 Returns: returnValue (Piuser[]): 用户列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_GetCompanyUser, user) returnValue = Piuser.objects.filter( Q(companyname=user.companyname) & Q(deletemark=0) & Q(enabled=1) & Q(isvisible=1)).order_by('sortcode') return returnValue
def GridPageListJson(request): page = None rows = None sort = None order = None filter = None try: page = request.POST['page'] except: page = 1 try: rows = request.POST['rows'] except: rows = 50 try: sort = request.POST['sort'] except: sort = 'createon' try: order = request.POST['order'] except: order = 'desc' try: filter = request.POST['filter'] except: filter = '' response = HttpResponse() recordCount = 0 recordCount, dtLog = LogService.GetDTByPage( page, rows, SearchFilter.TransfromFilterToSql(filter, False), sort + " " + order) logTmp = '' for log in dtLog: logTmp = logTmp + ', ' + json.dumps(log, cls=DateEncoder) logTmp = logTmp.strip(',') returnValue = '{"total": ' + str( recordCount) + ', "rows":[' + logTmp + ']}' response.content = returnValue return response
def GetEntity(userInfo, id): """ 获取实体 Args: id (string): 主键 Returns: returnValue (Staff or None): 实体 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.SequenceService, sys._getframe().f_code.co_name, FrameworkMessage.SequenceService_GetEntity, id) try: sequence = Cisequence.objects.get(id=id) return sequence except Cisequence.DoesNotExist: return None
def GetParameter(userInfo, categoryKey, parameterId, parameterCode): """ 获取参数值 Args: categoryKey (string): 分类键值 parameterId (string): 参数主键 parameterCode (string): 参数编号 Returns: returnValue (string): 参数值 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ParameterService, sys._getframe().f_code.co_name, FrameworkMessage.ParameterService_GetParameter, id) try: returnValue = Ciparameter.objects.get(Q(categorykey=categoryKey) & Q(parameterid=parameterId) & Q(parametercode=parameterCode) & Q(deletemark=0)).parametercontent except Ciparameter.DoesNotExist as e: returnValue = None return returnValue
def GetEntity(userInfo, id): """ 获取角色实体 Args: id (string): 角色主键 Returns: returnValue (Pirole or None): 员工实体 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.RoleService, sys._getframe().f_code.co_name, FrameworkMessage.RoleService_GetDTByPage, id) try: role = Pirole.objects.get(id=id) return role except Pirole.DoesNotExist: return None
def GetEntity(userInfo, id): """ 获取用户实体 Args: id (string): 用户主键 Returns: returnValue (Piuser or None): 用户实体 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_GetEntity, id) try: user = Piuser.objects.get(id=id) return user except Piuser.DoesNotExist: return None
def GetEntityByUserName(userInfo, userName): """ 根据用户名获取用户实体 Args: userName (string): 用户名称 Returns: returnValue (Piuser or None): 用户实体 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_GetEntityByUserName, userName) try: user = Piuser.objects.get(username=userName) return user except Piuser.DoesNotExist: return None
def Search(userInfo, searchValue, auditStatus, roleIds): """ 查询用户 Args: searchValue (string): 查询字段 auditStatus (string): 审核状态 roleIds (string[]): 用户角色ID字典 Returns: returnValue (int): 影响行数 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_Search, '') #returnValue = UserSerivce.Searchs(userInfo, '', searchValue, roleIds, None, auditStatus, '') returnValue = UserSerivce.Searchs(userInfo, None, searchValue, None, None, auditStatus, None) return returnValue
def GetDTByIds(userInfo, ids): """ 按主键获取员工列表 Args: ids (List[string]): 主键数组 Returns: returnValue (List): 用户列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.StaffService, sys._getframe().f_code.co_name, FrameworkMessage.StaffService_UpdateStaff, str(ids)) returnValue = [] for id in ids: try: user = Pistaff.objects.get(id=id) returnValue.append(user) except Pistaff.DoesNotExist: continue 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 Delete(userInfo, ids): """ 删除异常 Args: id (string): 主键 Returns: returnValue (int): 受影响行数 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ExceptionService, sys._getframe().f_code.co_name, FrameworkMessage.ExceptionService_Delete, '') returnValue, v = Ciexception.objects.filter(id__in=ids).delete() # returnValue = 0 # for id in ids: # returnValue = returnValue + Ciexception.objects.filter(id=id).delete() return returnValue
def GetDT(userInfo): """ 获取员工列表 Args: Returns: returnValue (List): 员工列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.StaffService, sys._getframe().f_code.co_name, FrameworkMessage.StaffService_GetDT, '') returnValue = [] try: for staff in Pistaff.objects.all(): returnValue.append(staff) return returnValue except DatabaseError as e: return returnValue except TransactionManagementError as e: return returnValue
def BatchMoveTo(userInfo, ids, organizeId): """ 批量移动员工数据到指定组织机构 Args: ids (string[]): 员工主键 organizeId (string): 组织机构主键 Returns: returnValue (bool): 移动结果 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.StaffService, sys._getframe().f_code.co_name, FrameworkMessage.StaffService_MoveTo, str(ids) + '/' + organizeId) try: staff = Pistafforganize.objects.filter(staffid__in=ids).update(organizeid=organizeId) return True except Pistafforganize.DoesNotExist as e: print(e) return False pass
def MoveTo(userInfo, id, organizeId): """ 移动员工数据到指定组织机构 Args: id (string): 员工主键 organizeId (string): 组织机构主键 Returns: returnValue (bool): 移动结果 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.StaffService, sys._getframe().f_code.co_name, FrameworkMessage.StaffService_MoveTo, id + '/' + organizeId) try: staff = Pistafforganize.objects.get(staffid=id) staff.organizeid = organizeId staff.save() return True except Pistafforganize.DoesNotExist as e: print(e) return False
def Add(userInfo, entity, organizeId=""): """ 添加员工 Args: entity (Pistaff[]): 员工实体 Returns: returnValue: 用户主键 """ try: entity.save() staffId = entity.id staffOrganize = Pistafforganize() staffOrganize.id = uuid.uuid4() staffOrganize.staffid = staffId staffOrganize.organizeid = organizeId staffOrganize.enabled = 1 staffOrganize.deletemark = 0 staffOrganize.createon = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") staffOrganize.modifiedon = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") staffOrganize.save() returnCode = StatusCode.statusCodeDic['OKAdd'] returnMessage = FrameworkMessage.MSG0009 returnValue = staffId LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.StaffService, sys._getframe().f_code.co_name, FrameworkMessage.StaffService_AddStaff, 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
def GetList(userInfo): """ 获取用户列表 Args: Returns: returnValue (List): 用户列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.UserService, sys._getframe().f_code.co_name, FrameworkMessage.UserService_GetList, '') returnValue = [] try: for user in Piuser.objects.all(): returnValue.append(user) return returnValue except DatabaseError as e: return returnValue except TransactionManagementError as e: return returnValue
def GetList(userInfo): """ 取得角色列表 Args: Returns: returnValue (List): 角色列表 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.RoleService, sys._getframe().f_code.co_name, FrameworkMessage.RoleService_GetDT, '') returnValue = [] try: for role in Pirole.objects.all(): returnValue.append(role) return returnValue except DatabaseError as e: return returnValue except TransactionManagementError as e: return returnValue
def Update(userInfo, parameterEntity): """ 更新模块菜单 Args: parameterEntity (Ciparameter): 模块实体 Returns: returnCode: 状态码 returnValue: 主键 """ LogService.WriteLog(userInfo, __class__.__name__, FrameworkMessage.ParameterService, sys._getframe().f_code.co_name, FrameworkMessage.ParameterService_Update, parameterEntity.id) try: parameterEntity.save() returnCode = StatusCode.statusCodeDic['OKUpdate'] returnMessage = FrameworkMessage.MSG0010 return returnCode, returnMessage except: returnCode = StatusCode.statusCodeDic['OKUpdate'] returnMessage = FrameworkMessage.MSG0010 return returnCode, returnMessage