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)