public List<CarBuyInfo> GetBuys(string email) { using (var content = new FxCarContext()) { return content.CarBuyInfos .Where(r => r.IsDelete == false && r.UserAccount == email) .ToList(); } }
/// <summary> /// 管理员获取所有的车辆求购信息 /// </summary> /// <param name="page">页码</param> /// <returns></returns> public List<CarBuyInfo> GetAdminBuys(int page = 0) { using (var content = new FxCarContext()) { return content.CarBuyInfos .OrderByDescending(r => r.CarBuyInfoId) .Where(r => r.IsDelete == false && r.IsPublish == true) .Skip(page * 100).Take(100) .ToList(); } }
public List<CarTransferInfo> GetAdminTransfers(int page = 0) { using (var content = new FxCarContext()) { return content.CarTransferInfos .OrderByDescending(r => r.CarTransferInfoId) //.Include(r => r.UserAccount) .Where(r => r.IsDelete == false && r.IsPublish == true) .Skip(page * 100).Take(100) .ToList(); } }
/// <summary> /// 按关键字查询 (标题) /// </summary> /// <param name="key">关键字</param> /// <param name="page">页码</param> /// <param name="take">获取数据的数量</param> /// <param name="area">地区</param> /// <param name="city">城市</param> /// <param name="clc">帖子对应的二级或者三级频道Id</param> /// <returns></returns> public List <CarBuyInfo> SearchByKey(string key, int area = 0, int city = 0, int page = 0, int take = 10, int clc = 0) { int start = 1 + page * 10; int end = page * 10 + take; var where = CreateWhereExpress(key, area, city, clc); string sql = " SELECT [CarBuyInfoId] FROM " + " ( SELECT ROW_NUMBER() OVER ( ORDER BY [CarBuyInfoId] ) " + " AS RowNumber,[CarBuyInfoId],CreatedTime " + " FROM [FxCar].[Car].[CarBuyInfo] " + where.ToString() + " ) " + " AS A1 WHERE RowNumber BETWEEN " + start + " AND " + end; var dt = GetDataTable(sql, key); var ids = new List <int>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { ids.Add(Convert.ToInt32(dt.Rows[i][0])); } } if (ids.Count > 0) { using (var context = new FxCarContext()) { return(context.CarBuyInfos .Where(r => ids.Contains(r.CarBuyInfoId)).ToList()); } } else { return(new List <CarBuyInfo>()); } }