def importLogLogin():
myRes = MyResponse()
try:
###添加注入清单信息
f = request.files['Ffile']
uploadFile = UploadFile(f)
uploadFile.import_file()
xlrdReader = XlrdReader(
os.path.join(uploadFile.filepath, uploadFile.filename))
xlrdReader.readSheetToList()
reader_data = xlrdReader.datas
reader_titles = xlrdReader.titles
for index_row, row in enumerate(reader_data):
sysLog = LogLogin()
sysLog.FuserId = row[0]
sysLog.FcreateTime = getSysDateTime()
sysLog.Ffunc = row[1]
sysLog.FipAddress = row[2]
sysLog.Fremark = row[5]
db_session.add(sysLog)
db_session.commit()
myRes.code = ResState.HTTP_SUCCESS
except ExcelError as ex:
mylog.error(ex)
abort(404, "读取excel错误")
except SQLAlchemyError as ex:
db_session.rollback()
mylog.error(ex)
abort(404, sys.exc_info()[1])
finally:
pass
return myRes.to_json()
def login_logger(oper_descript=""):
logLogin = LogLogin()
logLogin.USER_KEY = g.FuserId
logLogin.IP_ADDRESS = request.remote_addr
logLogin.TIME_CREATE = getSysDateTime()
logLogin.DESCRIPT = oper_descript
try:
MySqlalchemy.comAdd(logLogin)
except SQLAlchemyError as ex:
mylog.error(ex)
def add():
myRes = MyResponse()
ROLE_NAME = MyRequest.get_verify_empty("ROLE_NAME")
DESCRIPT = MyRequest.get("DESCRIPT")
try:
role = RoleInfo()
role.ROLE_NAME = ROLE_NAME
role.DESCRIPT = DESCRIPT
role.TIME_CREATE = getSysDateTime()
role.TIME_MODIFY = getSysDateTime()
MySqlalchemy.comAdd(role)
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except MyError as ex:
myRes.msg = ex
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = ResState.ERROR_DB
return myRes.to_json()
def add():
myRes = MyResponse()
user = UserInfo()
user.LOGIN_NAME = MyRequest.get_verify_empty("LOGIN_NAME",
errmsg="用户名不能为空")
user.USER_NAME = MyRequest.get_verify_empty("USER_NAME", errmsg="姓名不能为空")
user.USER_SEX = MyRequest.get("USER_SEX", type=int)
user.DPT_KEY = MyRequest.get_verify_empty("DPT_KEY", errmsg="DPT_KEY不能为空")
user.set_password("123456")
user.USER_POSITION = MyRequest.get("USER_POSITION", type=str)
user.PHONE = MyRequest.get("PHONE", type=str)
user.TIME_CREATE = getSysDateTime()
user.TIME_MODIFY = getSysDateTime()
try:
MySqlalchemy.comAdd(user)
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = ResState.ERROR_DB
return myRes.to_json()
def update():
myRes = MyResponse()
ROLE_KEY = MyRequest.get("ROLE_KEY", type=int)
role_attrs = {}
role_attrs["ROLE_NAME"] = MyRequest.get_verify_empty("ROLE_NAME")
role_attrs["DESCRIPT"] = MyRequest.get("DESCRIPT")
role_attrs["TIME_MODIFY"] = getSysDateTime()
try:
MySqlalchemy.comUpdate(RoleInfo, [RoleInfo.ROLE_KEY == ROLE_KEY],
role_attrs)
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def update():
myRes = MyResponse()
USER_KEY = MyRequest.get("USER_KEY", type=int)
upd_attr = {}
upd_attr["USER_NAME"] = MyRequest.get_verify_empty("USER_NAME",
errmsg="姓名不能为空")
upd_attr["USER_SEX"] = MyRequest.get("USER_SEX", type=int, default=1)
upd_attr["DPT_KEY"] = MyRequest.get_verify_empty("DPT_KEY",
errmsg="部门ID不能为空")
upd_attr["USER_POSITION"] = MyRequest.get("USER_POSITION", type=str)
upd_attr["PHONE"] = MyRequest.get("PHONE", type=str)
upd_attr["TIME_MODIFY"] = getSysDateTime()
try:
MySqlalchemy.comUpdate(UserInfo, [UserInfo.USER_KEY == USER_KEY],
upd_attr)
myRes.code = ResState.HTTP_SUCCESS
myRes.msg = "操作成功"
except SQLAlchemyError as ex:
mylog.error(ex)
myRes.msg = str(ex)
return myRes.to_json()
def wrapper(*args, **kargs):
responseInfo = func()
###操作成功后，记录操作日志
if json.loads(responseInfo.data)["code"] == ResState.HTTP_SUCCESS:
try:
logOper = LogOper()
logOper.USER_KEY = g.USER_KEY
logOper.IP_ADDRESS = request.remote_addr
logOper.LOGO_FUNC = "function(name=%s,args=%s,kargs=%s)" % (
func.__name__, args, kargs)
logOper.LOGO_REQ_PARAMS = json.dumps(MyRequest.getAll())
logOper.TIME_CREATE = getSysDateTime()
logOper.DESCRIPT = oper_descript
try:
MySqlalchemy.comAdd(logOper)
except SQLAlchemyError as ex:
mylog.error(ex)
except:
print(sys.exc_info())
pass
return responseInfo