日期:2014-05-19 浏览次数:20644 次
String sql = "select c.objname objname,c.objdesc objdesc,b.objname m,a.field006 field006,a.field008 field008,a.field009 field009,a.field007 field007,a.id id," + "datediff(mi,convert(datetime,field007),convert(datetime,field009))/60 alltime,n.field003 field003 " + "from ufd0i2m81332293713953 a left join project c " + "on a.field010 = c.id left join humres b " + "on a.field001 = b.id left join ufx7g8o01332829391541 n " + "on b.id = n.field001 where c.objname like '%"+all.getProject().getObjname()+"%' " + "order by b.objname desc";