linq 对Sum()函数的支持
摘要:
首先看一段SQL语句:SELECTSUM(TASKAPPR) AS APPRCOUNT,SUM(TASKLOCKED) AS LOCKEDCOUNT,SUM(TASKCHECKED) AS CHECKEDCOUNT FROM (SELECT (CASE WHEN ISAPPR =1 THEN 1 ELSE 0 END) AS TASKAPPR,(CASE WHEN ISLOCKED =1 THEN 1 ELSE 0 END) AS TASKLOCKED,(CASE WHEN ISCHECKED =1 THEN 1 ELSE 0 END) AS TASKCHECKED FROM TASK)... 阅读全文
posted @ 2014-03-28 10:12 Richard__Lee 阅读(876) 评论(0) 推荐(1) 编辑