linq left join
var list = from SCR in db.SO_ChangeRec
join SMU in db.SP_Material on SCR.UpMaterialNo equals SMU.MaterialNo into temp
from tt in temp.DefaultIfEmpty()
join PR in db.SP_SPReservation on SCR.SOID equals PR.SOID
join SMD in db.SP_Material on SCR.DownMaterialNo equals SMD.MaterialNo
where SCR.DownPartsSN == DownPartsSN
&& SCR.BranchID == BranchID
&& SCR.Status == ESDStaticClass.OverStatus.NotReturned
&& PR.PRStatus == ESDStaticClass.PRStatus.Over
orderby SCR.CreateTime
select new SparePartsChanageExt
{
ChangeRecID = SCR.ChangeRecID,
SOID = SCR.SOID,
DownPartsSN = SCR.DownPartsSN,
DownMaterialNo = SCR.DownMaterialNo,
DownMaterialNoDesc = SMD.MaterialName,
DownYakuan = SMD.YakuanPrice,
RequirementType = ESDStaticClass.RequirementCategory.Borrow,
DownSPMark = SCR.DownSPMark,
UpPartsSN = SCR.UpPartsSN,
UpMaterialNo = SCR.UpMaterialNo,
UpYakuan = tt.YakuanPrice,
PRCode = PR.PRCode,
UpMaterialNoDesc = tt.MaterialName,
StoreAreaType = ESDStaticClass.StoreAreaType.BadStoreArea
};
分享到:
相关推荐
LINQ to datable实现Left join right join full join VB2010源码
[t0].[Discontinued] FROM [dbo].[Products] AS [t0] LEFT OUTER JOIN [dbo].[Suppliers] AS [t1] ON [t1].[SupplierID] = [t0].[SupplierID] WHERE ([t1].[Country] = @p0) AND ([t0].[UnitsInStock] = @p1) -- @p0...
3.左外部联接(Left Outer Join): 17 4.投影的Let赋值(Projected let assignment): 17 5.组合键(Composite Key): 18 6.可为null/不可为null的键关系 (Nullable/Nonnullable Key Relationship): 19 LINQ to SQL...
连接运算符:Join,LeftJoin,GroupJoin,LeftGroupJoin 分组运算符:GroupBy 串联运算符:Concat 聚合运算符:聚合,平均值,计数,最大值,最小值,总和 过滤操作符:跳过,跳过,获取,获取 元素运算符:Element...
4、DNetORM对于多表的联查进行了常规的封装支持了LEFT JOIN, INNER JOIN ,GROUP BY , ORDER BY, WHERE,对于复杂的写法,建议使用DNetORM提供的SQL查询接口,我们在开发中使用orm是为了提升开发效率,节省开发...
这可以通过以下三种方式扩展标准API来完成: 具有对标准类型(如string.IsNotNullAndNotEmpty , string.RemoveDiacritics , IEnumerable.LeftJoin或DateTime.GetWeek)的扩展方法通过为开发人员提供诸如...
1.4.28 Join方法——串联字符串 69 1.4.29 LastIndexOf方法——确定字符在字符串中最后索引 70 1.4.30 Matches方法——检查字符串是否有重复的词出现 71 1.4.31 MONTH函数——返回指定日期中月部分的整数 73 1.4.32 ...