在线等！！！急急急！！！翻译LINQ语句

2010-09-26 03:03:32 173 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

急急急平面波matlab仿真中如何用颜色表示声压级的大小-Doc1.doc 急急急平面波matlab仿真中如何用颜色表示声压级的大小-Doc1.doc 原程序是： f=125; c0=344; k=2*f*pi./c0; r=0:0.001:0.5; p=exp; P=abs; plot; xlabel'); ylabel'); 不知程序对不对请问怎么在平面波matlab仿真中如何用颜色表示声压级的大小，能不能帮忙把程序完整的表示出来立即下载

select '收入' as kemu,isnull(sum(money),0)as money
from [statistics]
where SortType =1 and SortId in (
select Id from CashflowSort where CorpMoneySign =1)

union all

select '--'+c.Title,c.Allmoney from (
select Title,isnull(SUM(money),0) Allmoney,CorpMoneySign ,a.Id
from CashflowSort a
left join [statistics]
on
SortType=1 and a.Id= SortId
group by Title,CorpMoneySign,a.Id) c
where c.corpMoneySign =1 and c.Id not in
(select distinct ParentId from CashflowSort )

翻译成LINQ

...全文

请教高手关于EXCEL行列转换的问题！谢谢!急急急！！！一般的方法行不通，可能要用到宏或者编一个程序，请帮忙！立即下载

zyglovewhj

LINQ 8,492 成员 4,736 内容

+ 关注 + 加入社区

切换为时间正序

huminghua 2010-09-27

打赏
举报

最后你要的结果：
var listID=from c in CashflowSort
where c.CorpMoneySign ==1
select c.Id;
var lList=from a in CashflowSort join s in statistics
on s.SortType==1 && a.SortId==s.SortId into ss
group ss by new
{
ss.Title,
ss.CorpMoneySign,
ss.Id
} into ssa
select new
{
Title=ssa.Title,
Allmoney=ssa.Sum(ssa=>ssa.money)==null?0:ssa.Sum(ssa=>ssa.money),
CorpMoneySign=ssa.CorpMoneySign,
ssa.Id
};

var dl=(from cf in CashflowSort select cf.ParentId).Distinct();

(from s in statistics
group s by s.money into t
where s.SortType ==1
&& listID.Contains(s.SortId)
select new
{
kemu='收入',
money=t.Sum(t=>t.money)==null?0:t.Sum(t=>t.money)
}).Contact(from c in lList where c.corpMoneySign==1 && !(dl).Contains(c.Id) select new{'--'=c.Title,c.Allmoney})

huminghua 2010-09-27

打赏
举报

select '--'+c.Title,c.Allmoney from (
select Title,isnull(SUM(money),0) Allmoney,CorpMoneySign ,a.Id
from CashflowSort a
left join [statistics]
on
SortType=1 and a.Id= SortId
group by Title,CorpMoneySign,a.Id) c
where c.corpMoneySign =1 and c.Id not in
(select distinct ParentId from CashflowSort )

翻译成LINQ
var lList=from a in CashflowSort join s in statistics
on s.SortType==1 && a.SortId==s.SortId into ss
group ss by new
{
ss.Title,
ss.CorpMoneySign,
ss.Id
} into ssa
select new {'--'=ssa.Title,ssa.Allmoney};

var dl=(from cf in CashflowSort select cf.ParentId).Distinct();

var nextQuery=from c in lList where c.corpMoneySign==1 && !(dl).Contains(c.Id)

huminghua 2010-09-27

打赏
举报

恩！楼上多说对啦！我没仔细写。。幸好你指出来！谢谢！我也是才刚学Linq想来这里学习一下！嘿嘿！楼上好仔细哦！呵呵！

q107770540 2010-09-27

打赏
举报





select '收入' as kemu,isnull(sum(money),0)as money  

from [statistics]   

where SortType =1 and SortId in (

select Id from CashflowSort where CorpMoneySign =1)



//针对上边的SQL 语句，我写了下边的LINQ

  var listID=from c in CashflowSort  

             where c.CorpMoneySign ==1

             select c.Id;



var query= from s in statistics

           group s by s.money into t

           where s.SortType ==1 

             && listID.Contains(s.SortId)

            select new 

           {

              kemu='收入',

              money=t.Sum(t=>t.money)==null?0:t.Sum(t=>t.money)

           }

q107770540 2010-09-27

打赏
举报

and 在linq中应该是 && 吧。。

q107770540 2010-09-27

打赏
举报

[Quote=引用 1 楼 huminghua 的回复:]

(from s in statistics where s.SortType=1 and (from c in CashflowSort where c.CorpMoneySign==1 select c.Id).Contains(s.SortType) select new{'收入' as s.kemu,isnull(statistics.Sum(a=> a.money),0) as s.mo……
[/Quote]
据我所知
1.linq语句中where后应该是== 吧： where s.SortType==1
select new 中应该这样写吧：



select new

{

   收入 = s.kemu,

   money= statistics.Sum(a=> a.money)==null?O:statistics.Sum(a=> a.money))

 }

哥子谭 2010-09-27

打赏
举报

问题怎么这么复杂哦

huminghua 2010-09-27

打赏
举报

谢谢楼上的啊！你不来回复我就回复不了啦！

huminghua 2010-09-27

打赏
举报

(from s in statistics
group s by s.money into t
where s.SortType ==1
&& listID.Contains(s.SortId)
select new
{
kemu='收入',
money=t.Sum(t=>t.money)==null?0:t.Sum(t=>t.money)
}).Concat
(from c in lList where c.corpMoneySign==1 && !(dl).Contains(c.Id)
select new
{
c.Title='--',
c.Allmoney
}
)
不知道是否正确！你自己试试！请高手指点一二！ //一个用户只允许连续回复3次。连续是指的多久啊！

mingming912 2010-09-27

打赏
举报

好复杂

bancxc 2010-09-26

打赏
举报

[Quote=引用 1 楼 huminghua 的回复:]
(from s in statistics where s.SortType=1 and (from c in CashflowSort where c.CorpMoneySign==1 select c.Id).Contains(s.SortType) select new{'收入' as s.kemu,isnull(statistics.Sum(a=> a.money),0) as s.mon……
[/Quote]nb.

huminghua 2010-09-26

打赏
举报

(from s in statistics where s.SortType=1 and (from c in CashflowSort where c.CorpMoneySign==1 select c.Id).Contains(s.SortType) select new{'收入' as s.kemu,isnull(statistics.Sum(a=> a.money),0) as s.money}).Contact
(后面的自己写) 貌似没有ISNUll这个，你换成=吧！呵呵~！

在线等！！！急急急！！！翻译LINQ语句

相关推荐