def AddUserInfoSimple(self, name, parentId):
"""
只添加用户的名称和父节点,不会添加登录账号,没提交事务
:param name: 用户名
:param parentId:父ID
"""
parentEnt = FaUserInfo.query.filter(FaUserInfo.ID == parentId).first()
if parentEnt is None:
return None, AppReturnDTO(False, "父ID有问题")
userInfoEnt = FaUserInfo()
userInfoEnt.ID = Fun.GetSeqId(FaUser)
userInfoEnt.NAME = name
userInfoEnt.FATHER_ID = parentId
userInfoEnt.DISTRICT_ID = parentEnt.DISTRICT_ID
userInfoEnt.IS_LOCKED = 0
userInfoEnt.CREATE_TIME = datetime.datetime.now()
userInfoEnt.LEVEL_ID = 1
userInfoEnt.STATUS = '正常'
userInfoEnt.CREATE_USER_NAME = '自动'
userInfoEnt.CREATE_USER_ID = '1'
userInfoEnt.UPDATE_TIME = datetime.datetime.now()
userInfoEnt.UPDATE_USER_NAME = 'admin'
db.session.add(userInfoEnt)
return userInfoEnt, AppReturnDTO(True)
def UpdateCode(self, loginName, verifyCode):
'更新短验证码，如果号码不存在，则添加新有号码,并发送短信'
msg = "成功"
if not send_verify_code(loginName, verifyCode):
msg = verifyCode
# return AppReturnDTO(False, "短信发送失败")
loginEnt = FaLogin.query.filter(
FaLogin.LOGIN_NAME == loginName).first()
if loginEnt is None:
loginEnt = self
loginEnt.LOGIN_NAME = loginName
loginEnt.VERIFY_CODE = verifyCode
loginEnt.ID = Fun.GetSeqId(self)
loginEnt.FAIL_COUNT = 0
loginEnt.VERIFY_TIME = datetime.datetime.now()
db.session.add(loginEnt)
else:
loginEnt.VERIFY_CODE = verifyCode
loginEnt.FAIL_COUNT = 0
loginEnt.VERIFY_TIME = datetime.datetime.now()
db.session.commit()
db.session.close()
return AppReturnDTO(True, msg)
def AddUserInfoAndLogin(self, parentId, loginName, password, name,
level_id, sex, YEARS_TYPE, BIRTHDAY_TIME,
birthday_place, ICON_FILES_ID, ALIAS, AUTHORITY):
'完善用户的基本资料以及登录账号'
parentEnt = FaUserInfo.query.filter(FaUserInfo.ID == parentId).first()
if parentEnt is None:
return None, AppReturnDTO(False, "父ID有问题")
# <- 获取添加成功后的Login实体
loginDal = LoginDal()
loginDal.LOGIN_NAME = loginName
loginDal.PASSWORD = password
loginDal.PHONE_NO = loginName
loginEng, msg = loginDal.AddLoginName()
if not msg.IsSuccess:
return msg
# ->
# <- 更新用户信息
userInfoEnt = FaUserInfo()
userInfoEnt.ID = Fun.GetSeqId(FaUser)
userInfoEnt.FATHER_ID = parentId
userInfoEnt.LOGIN_NAME = loginDal.LOGIN_NAME
userInfoEnt.UPDATE_TIME = datetime.datetime.now()
userInfoEnt.NAME = name
userInfoEnt.LEVEL_ID = level_id
userInfoEnt.SEX = sex
userInfoEnt.YEARS_TYPE = YEARS_TYPE
if not Fun.IsNullOrEmpty(BIRTHDAY_TIME):
userInfoEnt.BIRTHDAY_TIME = datetime.datetime.strptime(
BIRTHDAY_TIME, '%Y-%m-%dT%H:%M:%SZ')
userInfoEnt.BIRTHDAY_PLACE = birthday_place
userInfoEnt.DIED_TIME = None
userInfoEnt.DIED_PLACE = None
userInfoEnt.DISTRICT_ID = parentEnt.DISTRICT_ID
userInfoEnt.IS_LOCKED = 0
userInfoEnt.CREATE_TIME = datetime.datetime.now()
userInfoEnt.LEVEL_ID = 1
userInfoEnt.STATUS = '正常'
userInfoEnt.CREATE_USER_NAME = name
userInfoEnt.CREATE_USER_ID = userInfoEnt.ID
userInfoEnt.UPDATE_TIME = datetime.datetime.now()
userInfoEnt.UPDATE_USER_NAME = name
userInfoEnt.ICON_FILES_ID = ICON_FILES_ID
userInfoEnt.ALIAS = ALIAS
userInfoEnt.AUTHORITY = AUTHORITY
db.session.add(userInfoEnt)
return userInfoEnt, AppReturnDTO(True)
def AddLoginName(self):
'''添加账号'''
if self.LOGIN_NAME == None or self.LOGIN_NAME == "":
return None, AppReturnDTO(False, "账号不能为空")
if self.PASSWORD == None or self.PASSWORD == "":
return None, AppReturnDTO(False, "密码不能为空")
db_ent = FaLogin.query.filter(
FaLogin.LOGIN_NAME == self.LOGIN_NAME).first()
if db_ent is not None:
if db_ent.PASSWORD is not None:
return db_ent, AppReturnDTO(True, "该登录名已经存在")
db_ent.IS_LOCKED = 0
db_ent.REGION = 0
db_ent.FAIL_COUNT = 0
db_ent.PASSWORD = Fun.md5(self.PASSWORD)
return self, AppReturnDTO(True)
self.IS_LOCKED = 0
self.ID = Fun.GetSeqId(self)
self.REGION = 0
self.FAIL_COUNT = 0
self.PASSWORD = Fun.md5(self.PASSWORD)
db.session.add(self)
return self, AppReturnDTO(True)
