try {
sqlstr="select a.order_no as order_no,b.name as name,a.staff_id as staff_id,-a.charge/100 as charge,a.created_date"
+" from prepay_used a,(select distinct type_id,name from explain_type where flag='O' ) b "
+" where a.oper_type=b.type_id and to_char(a.created_date,'yyyy-mm-dd') between ? and ? "
+" and "+sql_opertype+" and a.staff_id=?"
+" order by a.order_no ";