def update_status( id, status, user): lockTime = None if status != state.statusUserActive: lockTime = str_helper.get_now_datetimestr() yz = (status, user, lockTime, id) result = mysql.insert_or_update_or_delete(_update_status_sql, yz) return 0 == result
def update( id, realName, departmentID, parentID, mobile, tel, email, status, beginDate, endDate, remark, user): u = query_one_by_email(email) #判断用户邮箱是否已存在 if None != u and str(u['id']) != str(id): raise error.RightError(code = 103001) isdelete = state.Boole['false'] lockTime = None if status != state.statusUserActive: lockTime = str_helper.get_now_datetimestr() yz = (realName, departmentID, parentID, mobile, tel, email, status, beginDate, endDate + ' 23:59:59', remark, user, lockTime, id) result = mysql.insert_or_update_or_delete(_update_sql, yz) return 0 == result