帆软数据集参数用法：

2023-10-22 19:43:04

一般用法：SELECT * FROM [用户密码] where 密码='${password}'
加密用法：SELECT * FROM [用户密码] where 密码='${password+"123"}'
一般复选框：${if(len(xm_lx)=0,""," and xm_lx in ("+CONCATENATE("'",replace(xm_lx,",","','"),"'")+") ")}
一般模糊查询：${if(len(yg)=0,""," and c_yg like '%"+yg+"%'")}
高级用法：1：一般公司划分逻辑，${if(zb=="总部",if(len(gsmc)==0,""," and c_gsmc='"+gsmc+"'"),if(js==3||js==1," and c_gsmc='"+gsmc+"'",
if(js==4," and c_gsmc='"+gsmc+"' and xm_gs in("+CONCATENATE("'",replace(city,",","','"),"'")+")"," and c_gsmc='"+gsmc+"' and c_fzr='"+tbr+"'")))；2：时间划分逻辑，${if(yf=="01"," and ((nf='"+nf+"' and yf='"+yf+"') or ( nf='"+sum(nf,-1)+"' and yf='1s2'))"," and ((nf='"+nf+"' and yf='"+yf+"') or (nf='"+nf+"' and yf='"+mid(sum(concatenate("1",yf),-1),2,2)+"'))")}；3：权限划分逻辑，${if(zb=="总部","",if(sql("zsk","select count(*) from T_USER_ROLE t left join t_user t1 on t.C_USERID=t1.C_USERID left join T_ROLE t2 on t.C_ROLEID=t2.C_ROLEID where t1.C_USERNAME='"+mmduser()+"' and t2.C_ROLENAME in ('DYY_XMFZR','DYY_BM_PYR','gt_dyy_zb_fzr')",1,1)!=0,""," and xm_id in(select xm_id from dyy_power where xm_tbr_id='"+mmduser()+"')"))}

码农公寓