sqlalchemy多条件查询

    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