求助！Sql语句使用linq写出来

Question

SELECT
'类型' GoodsType,
SUM(CASE WHEN GoodsType=1 AND Status=1 THEN 1 ELSE 0 END) jiaji,
(SELECT SUM(ReturnTotal) FROM GoodsInfo WHERE GoodsType=1 AND Goo ds Type=4) AS returntotal
FROM GoodsInfo WHERE Goodsform='A'

Answer 1

from k in GoodsInfo where (k.Field("Goodsform") == "A")
select new {
GoodsType = "类型",
jiaji = k.Field("GoodsType") == 1&&k.Field("Status")==1?1:0,
returnTotal = (from r in GoodsInfo
where(r.Field("GoodsType")==1&&r.Field("GoodsType")==4 )
select new {returnTotal = r.Feild("ReturnTotal")}).Sum(a.ReturnTotal)
}

GoodsInfo 是DataTable类型