def out_bill(self, room_id, user_id, time):
self.outime = time
dbm = db.DBMapper()
_, total_cost = dbm.query_details(room_id, self.intime, self.outime)
self.total_cost = total_cost
dbm.insert_bill(self.room_id, self.user_id, self.intime, self.outime,
self.total_cost)
def insert_data(self): # 向数据库中插入表单数据
dbm = db.DBMapper()
self.air_on_times, self.air_off_times, self.use_time = dbm.query_air_switch(
self.room_id, self.b_time, self.e_time)
self.change_tem_times = dbm.query_air_tem(self.room_id, self.b_time,
self.e_time)
self.change_wind_times, self.schedule_times = dbm.query_air_wind(
self.room_id, self.b_time, self.e_time)
self.details_number, self.cost_all = dbm.query_details(
self.room_id, self.b_time, self.e_time)
dbm.insert_form(self.form_id, self.room_id, self.b_time, self.e_time,
self.air_on_times, self.air_off_times, self.use_time,
self.schedule_times, self.change_tem_times,
self.change_wind_times, self.details_number,
self.cost_all)
return self.air_on_times, self.air_off_times, self.use_time, self.schedule_times, self.change_tem_times, self.change_wind_times, self.details_number, self.cost_all
def insert_data(self, table_name, data): #向数据库插入数据
dbmapper = db.DBMapper() # 创建DBMapper
# 根据表名确定属性列表
if (table_name == 'switch_air'): #开关机表
attributes_list = ["room_id", "now_time", "on_off"]
elif (table_name == 'change_temperature'): #调温表
attributes_list = ["room_id", "now_time", "tem_change", "if_reach"]
elif (table_name == "change_windmode"): #改变风速表
attributes_list = ["room_id", "now_time", "wind_change"]
elif (table_name == "schedule"): #调度表
attributes_list = [
"room_id", "now_time", "if_schedule", "wind_mode"
]
#拼接表名，属性列表，data生成sql语句
sql = "insert into " + table_name + "(" + ",".join(
attributes_list) + ") values(" + ",".join(data) + ")"
# sql语句传入持久化层
dbmapper.insert_air(sql)
return True
def check_form_item(self): # 获得报表表项信息
dbm = db.DBMapper()
result = dbm.query_form(self.form_id) #查询报表
return result
def __init__(self, user_id, room_id):
self.user_id = user_id
self.room_id = room_id
self.dbs = db.DBMapper()
def __init__(self, user_id, room_id):
self.user_id = user_id # 账单编号
self.room_id = room_id # 空调送风房间数
self.dbs = db.DBMapper()