摘要: List<CoupleBackList> CoupleBackList_at = new List<CoupleBackList>(); var retData = RetDataList.AsEnumerable().Select(t => new { Id = t.Field<Guid>("Id 阅读全文
posted @ 2020-06-28 12:13 点滴一言 阅读(2390) 评论(2) 推荐(0)
摘要: 1.从大到小(DESC) list_Subject_set = list_Subject.OrderByDescending(p => p.ManagerName).ToList(); 2.从小到大(ASC) list_Subject_set = list_Subject.OrderBy(p => 阅读全文
posted @ 2020-06-28 12:04 点滴一言 阅读(1118) 评论(0) 推荐(0)
摘要: var list_Subject_set = list_Subject.Skip(iPageSize * iPageIndex).Take(iPageSize).ToList(); iPageSize:一页显示多少行; iPageIndex:页数 阅读全文
posted @ 2020-06-28 11:58 点滴一言 阅读(472) 评论(0) 推荐(0)
摘要: 1.简单的分组统计; var DetailList = DetailLisAST.GroupBy(a => a.ProjId).Select(a => new { a.Key , Count = a.Count() }).ToList(); 2.根据多个字段分组统计; var DetailList_ 阅读全文
posted @ 2020-06-28 11:54 点滴一言 阅读(575) 评论(0) 推荐(0)
摘要: 1.IN的使用; (1)当多项查询的是Guid类型时; #region 将string数组转化Guid数组 string[] ProjIdList = ProjIdset.Trim().Split(','); Guid[] guid_ProjId = new Guid[ProjIdList.Leng 阅读全文
posted @ 2020-06-28 11:44 点滴一言 阅读(1744) 评论(0) 推荐(0)
摘要: (1)精准查询; list_Subject_at =list_Subject_at.Where(p => p.WareID == WareID_set).ToList(); (2)模糊查询; list_Subject_at = list_Subject_at.Where(p => p.ProjTmN 阅读全文
posted @ 2020-06-28 11:18 点滴一言 阅读(879) 评论(0) 推荐(0)