`
冷寒冰
  • 浏览: 243227 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

linq left join

 
阅读更多
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)实例

    LINQ to datable实现Left join right join full join VB2010源码

    LINQ to SQL语句之Join和Order By

    [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...

    LINQ_to_SQL语法及实例大全

    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...

    go-plinq:PLINQ库,支持延迟评估,可以使用通道作为源-Lazy source

    连接运算符:Join,LeftJoin,GroupJoin,LeftGroupJoin 分组运算符:GroupBy 串联运算符:Concat 聚合运算符:聚合,平均值,计数,最大值,最小值,总和 过滤操作符:跳过,跳过,获取,获取 元素运算符:Element...

    DNetORM源码 CODEDNetORM.rar

    4、DNetORM对于多表的联查进行了常规的封装支持了LEFT JOIN, INNER JOIN ,GROUP BY , ORDER BY, WHERE,对于复杂的写法,建议使用DNetORM提供的SQL查询接口,我们在开发中使用orm是为了提升开发效率,节省开发...

    lib12:lib12是通用帮助程序和扩展库,可用于任何.NET项目

    这可以通过以下三种方式扩展标准API来完成: 具有对标准类型(如string.IsNotNullAndNotEmpty , string.RemoveDiacritics , IEnumerable.LeftJoin或DateTime.GetWeek)的扩展方法通过为开发人员提供诸如...

    C#全能速查宝典

    1.4.28 Join方法——串联字符串 69 1.4.29 LastIndexOf方法——确定字符在字符串中最后索引 70 1.4.30 Matches方法——检查字符串是否有重复的词出现 71 1.4.31 MONTH函数——返回指定日期中月部分的整数 73 1.4.32 ...

Global site tag (gtag.js) - Google Analytics