def get(self, page=1): count = TestCase.get_count() obj = Pagination(page, count) testresults = db_session.query(TestCase).order_by( TestCase.case_crea_time.desc())[int(obj.start):(int(page)) * (12)] str_page = obj.string_pager('/testcase/') self.render('case.html', cases=testresults, str_page=str_page)
def get(self, page=1): count = BugAdmin.get_count() obj = Pagination(page, count) testresults = db_session.query(BugAdmin).order_by( BugAdmin.bugtime.desc())[int(obj.start):(int(page)) * (12)] str_page = obj.string_pager('/bug/') self.render('bugadmin.html', bugs=testresults, str_page=str_page)
def get(self, page=1): count = FilePan.get_count() obj = Pagination(page, count) testresults = db_session.query(FilePan).order_by( FilePan.creat_time.desc())[int(obj.start):(int(page)) * (12)] str_page = obj.string_pager('/filepan/') self.render('pan.html', filespans=testresults, str_page=str_page)
def post(self): user_list=db_session.query(User).all() bianhao=self.get_argument('shebeibianhao') fapiao=self.get_argument('fapiao') shebeiname=self.get_argument('shebeiname') new=Shebei.get_by_name(shebeiname) if new: self.render('addshebei.html',user_list=user_list,error_message='设备名不能重复') xitong=self.get_argument('xitong') shebeixinghao=self.get_argument('shebeixinghao') quanxian=self.get_argument('quanxian') goumaidate=self.get_argument('goumai') jiage=self.get_argument('jiage') shebeizhuangtai=self.get_argument('shebeizhuangtai') tianjia=self.get_argument('tianjia') goumaidate=datetime.datetime.strptime(goumaidate,"%Y-%m-%d") if not (shebeiname and bianhao and shebeixinghao and fapiao): self.render('addshebei.html',user_list=user_list,error_message='请准确填写信息') try: jiage=int(jiage) except Exception as e: self.render('addshebei.html',user_list=user_list,error_message='价格只能是数字') new_shebei=Shebei(shebei_id=bianhao,shebei_name=shebeiname,shebei_xitong=xitong,shebei_xinghao=shebeixinghao, shebei_jiage=jiage,shebei_fapiaobianhao=fapiao,shebei_quanxian=quanxian,gou_date=goumaidate,shebei_status=shebeizhuangtai,ruku_user=int(tianjia)) db_session.add(new_shebei) try: db_session.commit() self.redirect('/shebei') except Exception as e: db_session.rollback() self.render('addshebei.html',user_list=user_list,error_message='添加失败')
def get(self, page=1): count = BanbenWrite.get_count() obj = Pagination(page, count) testresults = db_session.query(BanbenWrite).order_by( BanbenWrite.creat_time.desc())[int(obj.start):(int(page)) * (12)] str_page = obj.string_pager('/banben/') self.render('banben.html', banbnens=testresults, str_page=str_page)
def post(self,id): user_list=db_session.query(User).all() shebei=Shebei.get_by_id(id) if not shebei: self.redirect('/shebei',error_message='设备找不到') bianhao=self.get_argument('shebeibianhao') fapiao=self.get_argument('fapiao') shebeiname=self.get_argument('shebeiname') xitong=self.get_argument('xitong') shebeixinghao=self.get_argument('shebeixinghao') quanxian=self.get_argument('quanxian') goumaidate=self.get_argument('goumai') jiage=self.get_argument('jiage') shebeizhuangtai=self.get_argument('shebeizhuangtai') tianjia=self.get_argument('tianjia') try: goumaidate=datetime.datetime.strptime(goumaidate,"%Y-%m-%d") except Exception as e: self.render('edit.html',user_list=user_list,error_message='日期格式不对,请填写例如2017-1-19',shebei=shebei) waijietime=self.get_argument('waijietime') try: waijietime=datetime.datetime.strptime(waijietime,"%Y-%m-%d") except Exception as e: self.render('edit.html',user_list=user_list,error_message='日期格式不对,请填写例如2017-1-19',shebei=shebei) waijie_user=self.get_argument('waijie') waijie_s=self.get_argument('waijie_s') if not (shebeiname and bianhao and shebeixinghao and fapiao and quanxian): self.render('edit.html',user_list=user_list,error_message='请准确填写信息',shebei=shebei) try: jiage=int(jiage) except Exception as e: self.render('edit.html',user_list=user_list,error_message='价格只能是数字',shebei=shebei) shebei.shebei_id=bianhao shebei.shebei_name=shebeiname shebei.shebei_xitong=xitong shebei.shebei_xinghao=shebeixinghao shebei.shebei_jiage=jiage shebei.shebei_fapiaobianhao=fapiao shebei.shebei_quanxian=quanxian shebei.shebei_jie=waijie_s shebei.shebei_date=waijietime shebei.shebei_user=waijie_user shebei.gou_date=goumaidate shebei.shebei_status=shebeizhuangtai shebei.ruku_user=tianjia try: db_session.commit() self.redirect('/shebei') except Exception as e: db_session.rollback() self.render('edit.html',shebei=shebei,user_list=user_list,error_message='编辑失败')
def prepare(self): self.project = db_session.query(Project).all()
def get(self,page=1): count=User.get_count() obj=Pagination(page,count) user_list=db_session.query(User).order_by(User.id)[int(obj.start):(int(page)) * (12)] str_page = obj.string_pager('/user/') self.render('user.html',user_list=user_list,str_page=str_page)
def prepare(self): self.banbenhaos = db_session.query(BanbenWrite).all() self.porjects = db_session.query(Project).all() self.users = db_session.query(User).all()
def get(self,id): user_list=db_session.query(User).all() shebei=Shebei.get_by_id(id) if not shebei: self.redirect('/shebei') self.render('edit.html',shebei=shebei,error_message=None,user_list=user_list)
def get(self): user_list=db_session.query(User).all() self.render('addshebei.html',user_list=user_list,error_message=None)
def get(self,page=1): count=Shebei.get_count() obj=Pagination(page,count) shebei_list=db_session.query(Shebei).order_by(Shebei.shebei_date.desc())[int(obj.start):(int(page)) * (12)] str_page = obj.string_pager('/shebei/') self.render('shebei.html',shebei_list=shebei_list,str_page=str_page)
def get(self): user_num=db_session.query(User).count() shebei_num=db_session.query(Shebei).count() waijie_num=db_session.query(Shebei).filter_by(shebei_jie=True).count() shebei_list=db_session.query(Shebei).order_by(Shebei.shebei_date.desc())[:5] self.render('index .html',user_num=user_num,shebei_num=shebei_num,waijie_num=waijie_num,shebei_list=shebei_list)