客户要求下拉菜单可以多选,于是就写了这样的SQL select pm_ from v_yjhpshzqkb2_hbjt 品名下拉复选框的数据源是从上面的语句中取。 kk 2019-02-27 12-33-54.mp4
这个附件是我刚才录的操作视频,请大神们帮忙看下到底是哪里出了问题。
另外一个数据源是用来查出所有数据,需要根据下拉复选框取得的值进行过滤 select xm_ as 项目,clmc_ as 材料名称,jhyf_ as 计划月份, bm_ as 部门,jhsl_ as 计划数量,jhzl_ as 计划重量,pssl_ as 配送数量,pszl_ as 配送重量, qssl_ as 签收数量,qszl_ as 签收重量 from v_yjhpshzqkb3_hbjt WHERE 1=1 and pm_ in ('${品名}') ${if(len(查询月份) == 0,"","and jhyf_= '" + 查询月份 + "'")} ${if(len(项目) == 0,"","and xm_ like '%" + 项目 + "%'")} ${if(len(部门) == 0,"","and bm_ like '%" + 部门 + "%'")} ${if(len(大类) == 0,"","and dl_ like '%" + 大类 + "%'")} ${if(len(规格) == 0,"","and gg_ like '%" + 规格 + "%'")} 但是网页预览时选择要选的品名的值后,复选框栏里面值是空的。
|