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