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>());
}
}
