小木屋(提问者) select requestid ,bumen as \"制单部门\",djbh as \"单据编号\",wdbh as \"文档编号\", zdr as \"制单人\" ,zdrq as \"制单日期\" ,fsbm as \"发生部门\" ,wllb as \"物料类别\" ,zeren as \"不合格责任\", wlly as \"物料来源\" ,scrq as \"进货/生产日期\",pihao as \"批号\",gysll as \"供应商编号\" ,gys as \"供应商名称\", wlbhll as \"物料编号\",wlmc as \"物料名称\",wlsl as \"物料数量\" ,ddh as \"订单号\",jjdh as \"交检单号\", miaoshu as \"不合格描述\",bilv as \"不良品比率\", gcsyjms as \"工程师意见描述\",cgbyj as \"采购部意见\",cgbyjms as \"采购部意见描述\",sftzyw as \"是否通知业务负责人\",ywyjms as \"业务负责人意见描述\", scbyj as \"生产部意见\",scbyjms as \"生产部意见描述\",jsbyj as \"技术部意见\",jsbyjms as \"技术部意见描述\", zlbyj as \"质量部意见\",zlbyjms as \"质量部意见描述\",zjlyj as \"总经理批准意见\",fxyjms as \"返修意见描述\", sqe1 as \"SQE来料零部件\",sqe2 as \"SQE库存零部件\",sqe3 as \"SQE供方处零部件\",sqe4 as \"SQE其他\",cg3 as \"采购-物料处理意见\",cg5 as \"采购其他意见\",zl1 as \"质量来料零部件\",zl2 as \"质量库存零部件\",zl3 as \"质量供应方处理意见\",zl4 as \"质量其他意见\",zzcljl as \"最终结论处理意见\",yf1 as \"研发对成品影响度\",yf2 as \"研发客户使用风险\",yf3 as \"研发物料处置\",yf5 as \"研发其他描述\", wlbhwb as \"物料编号文本\",gysbhwb as \"供应商编号文本\" from formtable_main_6 where 1=1 and requestid in (select requestid from workflow_requestbase where workflowid in(141,3202,3162,3842,6621) ) ${if(len(ksrq)==0,\"\",\" and zdrq>=\'\"+ksrq+\"\'\" ) } ${if(len(jsrq)==0,\"\",\" and zdrq<=\'\"+jsrq+\"\'\" ) } ${if(len(value2)==0,\"\", value2) } ${if(len(value1)==0,\"\", value1) } ${if(len(value1_c)==0,\"\", value1_c) } ${if(len(value2_c)==0,\"\", value2_c) } order by id desc

回复

2020-04-23 16:28 

取消 回复

cherry团子 回复 小木屋(提问者) ...

回复

2020-04-23 16:28 

取消 回复

cherry团子 回复 小木屋(提问者) where 1=1 ${if()} ${if()} and requestid in..... 这样改下格式试试

回复

2020-04-23 16:34 

取消 回复

小木屋(提问者) 回复 cherry团子 select requestid ,bumen as \"制单部门\",djbh as \"单据编号\",wdbh as \"文档编号\", zdr as \"制单人\" ,zdrq as \"制单日期\" ,fsbm as \"发生部门\" ,wllb as \"物料类别\" ,zeren as \"不合格责任\", wlly as \"物料来源\" ,scrq as \"进货/生产日期\",pihao as \"批号\",gysll as \"供应商编号\" ,gys as \"供应商名称\", wlbhll as \"物料编号\",wlmc as \"物料名称\",wlsl as \"物料数量\" ,ddh as \"订单号\",jjdh as \"交检单号\", miaoshu as \"不合格描述\",bilv as \"不良品比率\", gcsyjms as \"工程师意见描述\",cgbyj as \"采购部意见\",cgbyjms as \"采购部意见描述\",sftzyw as \"是否通知业务负责人\",ywyjms as \"业务负责人意见描述\", scbyj as \"生产部意见\",scbyjms as \"生产部意见描述\",jsbyj as \"技术部意见\",jsbyjms as \"技术部意见描述\", zlbyj as \"质量部意见\",zlbyjms as \"质量部意见描述\",zjlyj as \"总经理批准意见\",fxyjms as \"返修意见描述\", sqe1 as \"SQE来料零部件\",sqe2 as \"SQE库存零部件\",sqe3 as \"SQE供方处零部件\",sqe4 as \"SQE其他\",cg3 as \"采购-物料处理意见\",cg5 as \"采购其他意见\",zl1 as \"质量来料零部件\",zl2 as \"质量库存零部件\",zl3 as \"质量供应方处理意见\",zl4 as \"质量其他意见\",zzcljl as \"最终结论处理意见\",yf1 as \"研发对成品影响度\",yf2 as \"研发客户使用风险\",yf3 as \"研发物料处置\",yf5 as \"研发其他描述\", wlbhwb as \"物料编号文本\",gysbhwb as \"供应商编号文本\" from formtable_main_6 where 1=1 ${if(len(ksrq)==0,\"\",\" and zdrq>=\'\"+ksrq+\"\'\" ) } ${if(len(jsrq)==0,\"\",\" and zdrq<=\'\"+jsrq+\"\'\" ) } ${if(len(value2)==0,\"\", value2) } ${if(len(value1)==0,\"\", value1) } ${if(len(value1_c)==0,\"\", value1_c) } ${if(len(value2_c)==0,\"\", value2_c) } order by id desc 改成了这样结果也是一样的

回复

2020-04-23 16:38 

取消 回复

小木屋(提问者) select requestid ,bumen as \"制单部门\",djbh as \"单据编号\",wdbh as \"文档编号\", zdr as \"制单人\" ,zdrq as \"制单日期\" ,fsbm as \"发生部门\" ,wllb as \"物料类别\" ,zeren as \"不合格责任\", wlly as \"物料来源\" ,scrq as \"进货/生产日期\",pihao as \"批号\",gysll as \"供应商编号\" ,gys as \"供应商名称\", wlbhll as \"物料编号\",wlmc as \"物料名称\",wlsl as \"物料数量\" ,ddh as \"订单号\",jjdh as \"交检单号\", miaoshu as \"不合格描述\",bilv as \"不良品比率\", gcsyjms as \"工程师意见描述\",cgbyj as \"采购部意见\",cgbyjms as \"采购部意见描述\",sftzyw as \"是否通知业务负责人\",ywyjms as \"业务负责人意见描述\", scbyj as \"生产部意见\",scbyjms as \"生产部意见描述\",jsbyj as \"技术部意见\",jsbyjms as \"技术部意见描述\", zlbyj as \"质量部意见\",zlbyjms as \"质量部意见描述\",zjlyj as \"总经理批准意见\",fxyjms as \"返修意见描述\", sqe1 as \"SQE来料零部件\",sqe2 as \"SQE库存零部件\",sqe3 as \"SQE供方处零部件\",sqe4 as \"SQE其他\",cg3 as \"采购-物料处理意见\",cg5 as \"采购其他意见\",zl1 as \"质量来料零部件\",zl2 as \"质量库存零部件\",zl3 as \"质量供应方处理意见\",zl4 as \"质量其他意见\",zzcljl as \"最终结论处理意见\",yf1 as \"研发对成品影响度\",yf2 as \"研发客户使用风险\",yf3 as \"研发物料处置\",yf5 as \"研发其他描述\", wlbhwb as \"物料编号文本\",gysbhwb as \"供应商编号文本\" from formtable_main_6 where 1=1 ${if(len(ksrq)==0,\"\",\" and zdrq>=\'\"+ksrq+\"\'\" ) } ${if(len(jsrq)==0,\"\",\" and zdrq<=\'\"+jsrq+\"\'\" ) } ${if(len(value2)==0,\"\", value2) } ${if(len(value1)==0,\"\", value1) } ${if(len(value1_c)==0,\"\", value1_c) } ${if(len(value2_c)==0,\"\", value2_c) } order by id desc 改成了这样结果也是没变

回复

2020-04-23 16:39 

取消 回复