我要评论return (from merchantsinfo in base.getiqueryable(x => x.islogicdelete == false && x.fid != fid)
join useraccount in useraccountdal.getiqueryable(x => x.privilegelevel > 0)
on merchantsinfo.useraccountid equals useraccount.fid
join merchantsfrom in merchantsinfoformdal.getiqueryable(x => !x.islogicdelete)
on merchantsinfo.fid equals merchantsfrom.merchantsinfoid into data
from merchants in data.defaultifempty()
group new { merchants.merchantsinfoid } by new
{
merchantsinfo.fid,
merchantsinfo.name,
merchantsinfo.brandlabel,
merchantsinfo.mainpicture,
merchantsinfo.merchantsamountmax,
merchantsinfo.merchantsamountmin,
merchantsinfo.merchantsamounttype,
merchantsinfo.projectname,
merchantsinfo.belongindustry,
merchantsinfo.belongindustrychild,
merchantsinfo.merchantsarea,
merchantsinfo.merchantsareacity,
merchantsinfo.merchantsareacitysubset,
merchants.merchantsinfoid
} into g
select new merchantsmodel
{
fid = g.key.fid,
name = g.key.name,
brandlabel = g.key.brandlabel,
mainpicture = g.key.mainpicture,
merchantsamountmax = g.key.merchantsamountmax,
merchantsamountmin = g.key.merchantsamountmin,
merchantsamounttype = g.key.merchantsamounttype,
projectname = g.key.projectname,
belongindustry = g.key.belongindustry,
belongindustrychild = g.key.belongindustrychild,
merchantsarea = g.key.merchantsarea,
merchantsareacity = g.key.merchantsareacity,
merchantsareacitysubset = g.key.merchantsareacitysubset,
applynum = g.key.merchantsinfoid == null ? 0 : g.count()
}).take(row).tolist();
您可能感兴趣的文章:
如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！
网友评论