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
