def queryFilter(self,start_time,end_time,cboPayMethod,cboPayStatus,cboCashier):
session = self.sesstionmk()
textsql = " 1=1 and orderDateTime between '"+start_time+"' and '"+end_time+"'"
if cboPayMethod!='全部':
textsql+=" and paymentType='"+cboPayMethod+"'"
if cboPayStatus!=0:
textsql += " and orderStatus=" + str(cboPayStatus)
if cboCashier!='全部':
textsql += " and cashier = '" + cboCashier+"'"
orders = session.query(Order).filter(text(textsql)).order_by(Order.orderDateTime.desc()).all()
session.close()
return orders
pass
sqlalchemy多条件查询
最新推荐文章于 2024-09-26 16:24:24 发布