def data_handle(self):
# 获取请求参数
objInput = web.input()
try:
nHotelID = objInput.get('nHotelID')
if is_null(nHotelID):
return FuncResult(fail='参数：nHotelID不能为空')
nVerifyUserIDMust = objInput.get('nVerifyUserIDMust')
if is_null(nVerifyUserIDMust):
return FuncResult(fail='参数：nVerifyUserIDMust不能为空')
sVerifyUserCodeMust = objInput.get('sVerifyUserNameMust')
if is_null(sVerifyUserCodeMust):
return FuncResult(fail='参数：sVerifyUserCodeMust不能为空')
sVerifyDateTimeMust = objInput.get('sVerifyDateTimeMust')
if is_null(sVerifyDateTimeMust):
return FuncResult(fail='参数：sVerifyDateTimeMust不能为空')
nAuditState = objInput.get('nAuditState')
if is_null(nAuditState):
return FuncResult(fail='参数：nAuditState不能为空')
sRemark = objInput.get('sRemark')
except Exception, ce:
# 异常处理
return FuncResult(fail='参数有误!')
def data_handle(self):
objInput = web.input()
try:
objCondition = json_to_obj(objInput.get('objCondition'))
objPageInfo = json_to_obj(objInput.get('objPageInfo'))
if is_null(objCondition['nSearchUserIDMust']):
return FuncResult(fail='参数\'nSearchUserIDMust\'不能为空')
elif is_null(objCondition['sSearchUserNameMust']):
return FuncResult(fail='参数\'sSearchUserCodeMust\'不能为空')
elif is_null(objCondition):
return FuncResult(msg='参数\'objCondition\'不能为空')
except Exception, ce:
print ce
return FuncResult(fail='参数有误!')
def update_role(self, nUserID, strRoleList, strUserDataRoleList):
# 新增数据
objUser = User().query.filter(User.UserID == nUserID) \
.first()
if objUser:
if not is_null(nUserID):
objUser.UserID = nUserID
if not is_null(strRoleList):
objUser.RoleList = strRoleList
if not is_null(strUserDataRoleList):
objUser.UserDataRoleList = strUserDataRoleList
# 保存更改到数据库
objUser.save()
return FuncResult(success=True, msg='操作成功！', data='')
def data_handle(self):
'''
获取请求参数
'''
objInput = web.input()
try:
nUserID = objInput.get('nUserID')
sNewPassword = objInput.get('sNewPassword')
sOldPassword = objInput.get('sOldPassword')
if is_null(nUserID):
return nUserID(fail='参数\'nUserID\'不能为空')
elif is_null(sNewPassword):
return FuncResult(fail='参数\'sNewPassword\'不能为空')
elif is_null(sOldPassword):
return FuncResult(fail='参数\'sOldPassword\'不能为空')
except Exception, ce:
# 异常处理
return FuncResult(fail='参数有误！')
def update_user(self, nUserID, sTel, sWorkCode, sUserName, sPost, sRemark):
# 新增数据
objUser = User().query.filter(User.UserID == nUserID) \
.first()
if not is_null(sTel):
objUser.Tel = sTel
if not is_null(sWorkCode):
objUser.WorkCode = sWorkCode
if not is_null(sUserName):
objUser.UserName = sUserName
if not is_null(sPost):
objUser.Post = sPost
if not is_null(sRemark):
objUser.Remark = sRemark
# 保存更改到数据库
objUser.save()
return FuncResult(success=True, msg='资料修改成功！')
def add_hotel(self, nHotelID, nVerifyUserIDMust, sVerifyUserCodeMust, sVerifyDateTimeMust, nAuditState, sRemark):
# 查找对应HotelID的酒店数据
objHotel = Hotel().query.filter(Hotel.HotelID == nHotelID).first()
# 赋值
if not is_null(nVerifyUserIDMust):
objHotel.AuditUserID = nVerifyUserIDMust
if not is_null(sVerifyUserCodeMust):
objHotel.AuditUserCode = sVerifyUserCodeMust
if not is_null(sVerifyDateTimeMust):
objHotel.AuditTime = sVerifyDateTimeMust
if not is_null(nAuditState):
objHotel.AuditState = nAuditState
if not is_null(sRemark):
objHotel.HotelTel = sRemark
# 保存到数据库
objHotel.save()
return FuncResult(success=True, msg='擦作成功!')
def data_handle(self):
# 获取请求参数
objInput = web.input()
try:
Param = web.input().get('Param')
if Param == None:
return FuncResult(fail='Have no Param!')
Log().logging('AddGuestCheckIn', Param)
jsonParam = json.loads(Param)
print "---------------------------------------------------------------------------"
print " get PMS params :"
print jsonParam
print "---------------------------------------------------------------------------"
CheckInInfo = jsonParam['CheckInInfo']
GuestInfoSet = jsonParam['GuestInfoSet']
if is_null(CheckInInfo):
return FuncResult(fail='参数：CheckInInfo不能为空')
if is_null(GuestInfoSet):
return FuncResult(fail='参数：GuestInfoSet不能为空')
except Exception, ce:
# 异常处理
return FuncResult(fail='参数有误!')
def data_handle(self):
'''
获取请求参数
'''
objInput = web.input()
try:
nRemoveUserIDMust = objInput.get('nRemoveUserIDMust')
sRemoveUserNameMust = objInput.get('sRemoveUserNameMust')
nUserID = objInput.get('nUserID')
sRemark = objInput.get('sRemark')
if is_null(nRemoveUserIDMust):
return FuncResult(fail='参数\'nRemoveUserIDMust\'不能为空')
elif is_null(sRemoveUserNameMust):
return FuncResult(fail='参数\'sRemoveUserNameMust\'不能为空')
elif is_null(nUserID):
return FuncResult(fail='参数\'nUserID\'不能为空')
elif is_null(sRemark):
return FuncResult(fail='参数\'sRemark\'不能为空')
except Exception, ce:
# 异常处理
return FuncResult(fail='参数有误！')
def data_handle(self):
objInput = web.input()
try:
nHotelIDMust = objInput.get('nHotelIDMust')
if is_null(nHotelIDMust):
return FuncResult(fail='参数：nHotelIDMust不能为空')
nOffLineUserIDMust = objInput.get('nOffLineUserIDMust')
if is_null(nOffLineUserIDMust):
return FuncResult(fail='参数：nOffLineUserIDMust不能为空')
sOffLineUserNameMust = objInput.get('sOffLineUserNameMust')
if is_null(sOffLineUserNameMust):
return FuncResult(fail='参数：sOffLineUserNameMust不能为空')
sOffLineDateTimeMust = objInput.get('sOffLineDateTimeMust')
if is_null(sOffLineDateTimeMust):
return FuncResult(fail='参数：sOffLineDateTimeMust不能为空')
sRemark = objInput.get('sRemark')
except Exception, ce:
return FuncResult(fail='参数有误!')
def data_handle(self):
'''
获取请求参数
'''
objInput = web.input()
try:
nUpdateUserIDMust = objInput.get('nUpdateUserIDMust')
sUpdateUserNameMust = objInput.get('sUpdateUserNameMust')
nUserID = objInput.get('nUserID')
sTel = objInput.get('sTel')
sWorkCode = objInput.get('sWorkCode')
sUserName = objInput.get('sUserName')
sPost = objInput.get('sPost')
sRemark = objInput.get('sRemark')
if is_null(nUpdateUserIDMust):
return FuncResult(fail='参数\'nUpdateUserIDMust\'不能为空')
elif is_null(sUpdateUserNameMust):
return FuncResult(fail='参数\'sUpdateUserNameMust\'不能为空')
elif is_null(nUserID):
return FuncResult(fail='参数\'nUserID\'不能为空')
except Exception, ce:
# 异常处理
return FuncResult(fail='参数有误!')
def add_user(self, nAddUserIDMust, sAddUserNameMust, sUserCode, sPassword,
sTel, sWorkCode, sUserName, sPost, sRemark):
# 新增数据
objUser = User()
objUser.UserCode = sUserCode
objUser.Password = sPassword
# objUser.Password = aes_encrypt(sPassword)
# 3为关闭，1为正常，2为已禁用
objUser.State = 1
if not is_null(sTel):
objUser.Tel = sTel
if not is_null(sWorkCode):
objUser.WorkCode = sWorkCode
if not is_null(sUserName):
objUser.UserName = sUserName
if not is_null(sPost):
objUser.Post = sPost
if not is_null(sRemark):
objUser.Remark = sRemark
objUser.CreateTime = datetime.datetime.now()
# 保存更改到数据库
objUser.save()
return FuncResult(success=True, msg='操作成功！')
def update_hotel(self, nHotelIDMust, nUpdateUserIDMust, sUpdateUserNameMust, sHotelCode,
sHotelName, sHotelAddr,sHotelTel, sLegalTel, sLegalPerson, sLegalDocNo,
str_coordinate, nProvinceID, nCityID, nDistrictID,nHotelType, sResponPersonTel,
sResponPerson, nRoomCount, nBedCount, sBusLicenseCode, sBusLicenseName,
sRemark, sRegStartTime):
# 查找酒店
obj_hotel = Hotel().query.filter(Hotel.HotelID == nHotelIDMust).first()
if not is_null(nHotelType):
obj_hotel.HotelCode = sHotelCode
if not is_null(sHotelName):
obj_hotel.HotelName = sHotelName
if not is_null(sHotelAddr):
obj_hotel.HotelAddr = sHotelAddr
if not is_null(sHotelTel):
obj_hotel.HotelTel = sHotelTel
if not is_null(sLegalTel):
obj_hotel.LegalTel = sLegalTel
if not is_null(sLegalPerson):
obj_hotel.LegalPerson = sLegalPerson
if not is_null(sLegalDocNo):
obj_hotel.LegalDocNo = sLegalDocNo
if not is_null(str_coordinate):
obj_hotel.Coordinate = str_coordinate
if not is_null(nProvinceID):
obj_hotel.ProvinceID = nProvinceID
if not is_null(nCityID):
obj_hotel.CityID = nCityID
if not is_null(nDistrictID):
obj_hotel.DistrictID = nDistrictID
if not is_null(nHotelType):
obj_hotel.HotelType = nHotelType
if not is_null(sResponPersonTel):
obj_hotel.ResponPersonTel = sResponPersonTel
if not is_null(sResponPerson):
obj_hotel.ResponPerson = sResponPerson
if not is_null(nRoomCount):
obj_hotel.RoomCount = nRoomCount
if not is_null(nBedCount):
obj_hotel.BedCount = nBedCount
if not is_null(sBusLicenseCode):
obj_hotel.BusLicenseCode = sBusLicenseCode
if not is_null(sBusLicenseName):
obj_hotel.BusLicenseName = sBusLicenseName
if not is_null(sRemark):
obj_hotel.Remark = sRemark
if not is_null(sRegStartTime):
obj_hotel.RegStartTime = to_datetime(sRegStartTime)
# 保存到数据库
obj_hotel.save()
return FuncResult(success=True, msg='酒店资料修改成功!')
def data_handle(self):
# 获取请求参数
objInput = web.input()
try:
nAddUserIDMust = objInput.get('nAddUserIDMust')
if is_null(nAddUserIDMust):
return FuncResult(fail='参数：nAdduserIDmust不能为空')
sAddUserNameMust = objInput.get('sAddUserNameMust')
if is_null(sAddUserNameMust):
return FuncResult(fail='参数：sAddUserNameMust不能为空')
sHotelCode = objInput.get('sHotelCode')
if is_null(sHotelCode):
return FuncResult(fail='参数：sHotelCode不能为空')
sHotelName = objInput.get('sHotelName')
if is_null(sHotelName):
return FuncResult(fail='参数：sHotelName不能为空')
sHotelAddr = objInput.get('sHotelAddr')
if is_null(sHotelAddr):
return FuncResult(fail='参数：sHotelAddr不能为空')
sHotelTel = objInput.get('sHotelTel')
if is_null(sHotelTel):
return FuncResult(fail='参数：sHotelTel不能为空')
sLegalTel = objInput.get('sLegalTel')
if is_null(sLegalTel):
return FuncResult(fail='参数：sLegalTel不能为空')
sLegalPerson = objInput.get('sLegalPerson')
if is_null(sLegalPerson):
return FuncResult(fail='参数：sLegalPerson不能为空')
sLegalDocNo = objInput.get('sLegalDocNo')
if is_null(sLegalDocNo):
return FuncResult(fail='参数：sLegalDocNo不能为空')
sCoordinate = objInput.get('sCoordinate')
nProvinceID = objInput.get('nProvinceID')
if is_null(nProvinceID):
return FuncResult(fail='参数：nProvinceID不能为空')
nCityID = objInput.get('nCityID')
if is_null(nCityID):
return FuncResult(fail='参数：nCityID不能为空')
nDistrictID = objInput.get('nDistrictID')
if is_null(nDistrictID):
return FuncResult(fail='参数：nDistrictID不能为空')
nHotelType = objInput.get('nHotelType')
if is_null(nHotelType):
return FuncResult(fail='参数：nHotelType不能为空')
nCreatUserID = objInput.get('nCreatUserID')
if is_null(nCreatUserID):
return FuncResult(fail='参数：nCreatUserID不能为空')
sCreatUserCode = objInput.get('sCreatUserCode')
if is_null(sCreatUserCode):
return FuncResult(fail='参数：sCreatUserCode不能为空')
sResponPersonTel = objInput.get('sResponPersonTel')
if is_null(sResponPersonTel):
return FuncResult(fail='参数：sResponPersonTel不能为空')
sResponPerson = objInput.get('sResponPerson')
if is_null(sResponPerson):
return FuncResult(fail='参数：sResponPerson不能为空')
nRoomCount = objInput.get('nRoomCount')
if is_null(nRoomCount):
return FuncResult(fail='参数：nRoomCount不能为空')
nBedCount = objInput.get('nBedCount')
if is_null(nBedCount):
return FuncResult(fail='参数：nBedCount能为空')
sBusLicenseCode = objInput.get('sBusLicenseCode')
if is_null(sBusLicenseCode):
return FuncResult(fail='参数：sBusLicenseCode不能为空')
sBusLicenseName = objInput.get('sBusLicenseName')
if is_null(sBusLicenseName):
return FuncResult(fail='参数：sBusLicenseName不能为空')
sRegStartTime = objInput.get('sRegStartTime')
if is_null(sRegStartTime):
return FuncResult(fail='参数：sRegStartTime不能为空')
sRemark = objInput.get('sRemark')
except Exception, ce:
# 异常处理
return FuncResult(fail='参数有误!')
def add_hotel(self, sHotelCode, sHotelName, sHotelAddr, sHotelTel,
sLegalTel, sLegalPerson, sLegalDocNo, sCoordinate,
nProvinceID, nCityID, nDistrictID, nHotelType, nCreatUserID,
sCreatUserCode, sResponPersonTel, sResponPerson, nRoomCount,
nBedCount, sBusLicenseCode, sBusLicenseName, sRegStartTime,
sRemark):
try:
# 实例化一个Hotel类
objHotel = Hotel()
# 赋值
if not is_null(sHotelCode):
objHotel.HotelCode = sHotelCode
if not is_null(sHotelName):
objHotel.HotelName = sHotelName
if not is_null(sHotelAddr):
objHotel.HotelAddr = sHotelAddr
if not is_null(sHotelTel):
objHotel.HotelTel = sHotelTel
if not is_null(sLegalTel):
objHotel.LegalTel = sLegalTel
if not is_null(sLegalPerson):
objHotel.LegalPerson = sLegalPerson
if not is_null(sLegalDocNo):
objHotel.LegalDocNo = sLegalDocNo
if not is_null(sCoordinate):
objHotel.Coordinate = sCoordinate
if not is_null(nProvinceID):
objHotel.ProvinceID = nProvinceID
if not is_null(nCityID):
objHotel.CityID = nCityID
if not is_null(nDistrictID):
objHotel.DistrictID = nDistrictID
if not is_null(nHotelType):
objHotel.HotelType = nHotelType
if not is_null(nCreatUserID):
objHotel.CreateUserID = nCreatUserID
if not is_null(sCreatUserCode):
objHotel.CreateUserName = sCreatUserCode
if not is_null(sResponPersonTel):
objHotel.ResponPersonTel = sResponPersonTel
if not is_null(sResponPerson):
objHotel.ResponPerson = sResponPerson
if not is_null(nRoomCount):
objHotel.RoomCount = nRoomCount
if not is_null(nBedCount):
objHotel.BedCount = nBedCount
if not is_null(sBusLicenseCode):
objHotel.BusLicenseCode = sBusLicenseCode
if not is_null(sBusLicenseName):
objHotel.BusLicenseName = sBusLicenseName
if not is_null(sRegStartTime):
objHotel.RegStartTime = to_datetime(sRegStartTime)
if not is_null(sRemark):
objHotel.Remark = sRemark
# 0：待审核，1：已审核，2：审核不通过
objHotel.AuditState = 6
objHotel.ApplyTime = datetime.datetime.now()
objHotel.CreateTime = datetime.datetime.now()
# 保存到数据库
objHotel.save()
except Exception, ce:
pass
