2015-12-01 08:56:14 正常:SQL: SELECT t_rm_saleflow.branch_no , -- '门店', count(distinct t_rm_saleflow.flow_no) flow_no, sum(t_rm_saleflow.sale_qnty ) sale_qnty,-- '销售数量', sum( t_rm_saleflow.sale_money ) sale_money, CONVERT(varchar(11) , t_rm_payflow.oper_date , 20 ) pay_date FROM t_rm_saleflow, t_rm_payflow WHERE ( t_rm_saleflow.flow_no = t_rm_payflow.flow_no ) and ( t_rm_payflow.branch_no = t_rm_saleflow.branch_no ) and ( t_rm_payflow.oper_id = t_rm_saleflow.oper_id ) and ( t_rm_payflow.flow_id=1 and t_rm_payflow.pay_way <> 'MOY') and t_rm_saleflow.sell_way='B' --as sale_price sell_way B:退货 A:销售 and t_rm_payflow.oper_date>'' ---参数 and t_rm_payflow.oper_date<'' ---参数 group by t_rm_saleflow.branch_no, t_rm_payflow.oper_date 2015-12-01 08:57:53 正常:SELECT id,parent,name,reportletPath,description,isView,transmitParameters,sortindex,mobileDeviceConfig,parentDeviceConfig,mobileCoverId FROM fr_reportletentry WHERE reportletPath=? 2015-12-01 08:57:53 正常:开始计算报表 2015-12-01 08:57:53 正常:SQL: SELECT t_rm_saleflow.branch_no , -- '门店', count(distinct t_rm_saleflow.flow_no) flow_no, sum(t_rm_saleflow.sale_qnty ) sale_qnty,-- '销售数量', sum( t_rm_saleflow.sale_money ) sale_money, CONVERT(varchar(11) , t_rm_payflow.oper_date , 20 ) pay_date FROM t_rm_saleflow, t_rm_payflow WHERE ( t_rm_saleflow.flow_no = t_rm_payflow.flow_no ) and ( t_rm_payflow.branch_no = t_rm_saleflow.branch_no ) and ( t_rm_payflow.oper_id = t_rm_saleflow.oper_id ) and ( t_rm_payflow.flow_id=1 and t_rm_payflow.pay_way <> 'MOY') and t_rm_saleflow.sell_way='A' --as sale_price sell_way B:退货 A:销售 and t_rm_payflow.oper_date>'' ---参数 and t_rm_payflow.oper_date<'' ---参数 group by t_rm_saleflow.branch_no, t_rm_payflow.oper_date 2015-12-01 08:57:53 正常:SQL: SELECT t_rm_saleflow.branch_no , -- '门店', count(distinct t_rm_saleflow.flow_no) flow_no, sum(t_rm_saleflow.sale_qnty ) sale_qnty,-- '销售数量', sum( t_rm_saleflow.sale_money ) sale_money, CONVERT(varchar(11) , t_rm_payflow.oper_date , 20 ) pay_date FROM t_rm_saleflow, t_rm_payflow WHERE ( t_rm_saleflow.flow_no = t_rm_payflow.flow_no ) and ( t_rm_payflow.branch_no = t_rm_saleflow.branch_no ) and ( t_rm_payflow.oper_id = t_rm_saleflow.oper_id ) and ( t_rm_payflow.flow_id=1 and t_rm_payflow.pay_way <> 'MOY') and t_rm_saleflow.sell_way='B' --as sale_price sell_way B:退货 A:销售 and t_rm_payflow.oper_date>'2015-11-29' ---参数 and t_rm_payflow.oper_date<'2015-11-30' ---参数 group by t_rm_saleflow.branch_no, t_rm_payflow.oper_date 这是执行log，为什么一段SQL要执行多次，第一次参数没有值，第二次参数才有值。 |
最佳回答 |
||||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
