-
-
13691265784 初学数据Lv2
发表于2018-11-12 15:12
悬赏20
已解决
楼主
本帖最后由 13691265784 于 2018-11-13 21:00 编辑
若@calss值为空，则不执行，怎么控制
最近看过此主题的会员
17个回答
-
13691265784 初学数据Lv2
14#
本帖最后由 13691265784 于 2018-11-12 17:36 编辑
13691265784 发表于 2018-11-12 17:29
不支持txt,截图可以吗
select
lqxx.lqr as getUserName,
lqxx.lqdh as getNumber,
lqxx.bm_name as depName,
lqxx.lqsj as getTime,
zd_fl.name as className,
zd_mc.name as goodName,
yp.dw as unit,
yp.gg as standardName,
lq.lqsl as getCount
from hq_lqxx as lqxx
left join hq_lq as lq on lq.hq_lqxx_id = lqxx.id
left join hq_bgyp as yp on yp.id = lq.hq_bgyp_id
left join sjzd_lx_zi as zd_fl on zd_fl.id=yp.sjzd_hq_ypfl_id
left join sjzd_lx_zi as zd_mc on zd_mc.id=yp.sjzd_ypmc_id
where lqxx.lqsj > '<#=@bdq_s#>' and lqxx.lqsj < '<#=@bdq_e#>'
and
<#=if(@dep='','1=1','lqxx.bm_name like '^@dep)#>
and
<#=if(@uname='','1=1','lqxx.lqr like '^@uname)#>
and
<#=if(@good_name='','1=1','zd_mc.name like "%'^@good_name^'%"')#>
and
<#=if(@class='','1=1','zd_fl.id = '^@class)#>
-
13691265784 初学数据Lv2
17#
<#=if(@good_name='','1=1','zd_mc.name like '^"'%"^@good_name ^"%'")#> 最终解决方法
