3、统计补卡人在补卡日期的年月的补卡次数。
doFieldSQL(" select count(distinct a.bkrq) from formtable_main_34 a left join formtable_main_34_dt1 b on a.id = b.mainid left join workflow_requestbase c on a.requestId=c.requestid where a.bkr = $main.bkr$ and CONVERT(varchar(7), a.bkrq, 23) = CONVERT(varchar(7), '$main.bkrq$', 23) and c.currentnodetype!=0 ")
currentnodetype!=0 代表已经提交的流程