var f=from p in RemoteTakeQuota
where p.DEP_CODE==null
select new(){
p.Kind,
week=(WeekEnum)(p.OverDate),
p.Remain_Person
};

var result=from k in BatchCLIENT2KIND
where k.IS_RESERVE<>'1' AND k.DISTINCT<>'all' AND k.DISTINCT<>'a1'
join b in BatchCLIENT2KIND
where b.kind <> 'all'
on b.kind equals k.kind
join p in f
on p.Kind equals k.kind
select new (){
Kind=k.DISTINCT,
serno=int.prase(Substr(b.kind,2,length(b.kind)-1)),
p.week,
p.Remain_Person};
result=result.orderby(r=>r.serno);
剩下的，想办法把p.week, p.Remain_Person展开吧。

没经过具体测试，但是大概差不多，有可能有的需要先转文内存LIST，再进行操作