public int GetProductDetailCount(ProductDetailSearchCondition condition)
{
var query = _productdetailRepository.Table;
try
{
if (condition.AddTimeBegin.HasValue)
{
query = query.Where(q => q.AddTime >= condition.AddTimeBegin.Value);
}
if (condition.AddTimeEnd.HasValue)
{
query = query.Where(q => q.AddTime < condition.AddTimeEnd.Value);
}
if (condition.UpdTimeBegin.HasValue)
{
query = query.Where(q => q.UpdTime >= condition.UpdTimeBegin.Value);
}
if (condition.UpdTimeEnd.HasValue)
{
query = query.Where(q => q.UpdTime < condition.UpdTimeEnd.Value);
}
if (condition.AddUser.HasValue)
{
query = query.Where(q => q.AddUser == condition.AddUser.Value);
}
if (condition.UpdUser.HasValue)
{
query = query.Where(q => q.UpdUser == condition.UpdUser.Value);
}
if (!string.IsNullOrEmpty(condition.Name))
{
query = query.Where(q => q.Name.Contains(condition.Name));
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
return(query.Count());
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(-1);
}
}
public int GetProductDetailCount(ProductDetailSearchCondition condition)
{
var query = _productdetailRepository.Table;
try
{
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
return(query.Count());
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(-1);
}
}
public HttpResponseMessage Get(ProductDetailSearchCondition condition)
{
var model = _ProductDetailService.GetProductDetailsByCondition(condition).Select(c => new ProductDetailModel
{
Id = c.Id,
Detail = c.Detail,
ImgUrl1 = c.ImgUrl1,
ImgUrl2 = c.ImgUrl2,
ImgUrl3 = c.ImgUrl3,
ImgUrl4 = c.ImgUrl4,
ImgUrl5 = c.ImgUrl5,
// Product = c.Product,
}).ToList();
return(PageHelper.toJson(new { List = model }));
}
public IQueryable <ProductDetailEntity> GetProductDetailsByCondition(ProductDetailSearchCondition condition)
{
var query = _productdetailRepository.Table;
try
{
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
if (condition.OrderBy.HasValue)
{
switch (condition.OrderBy.Value)
{
case EnumProductDetailSearchOrderBy.OrderById:
query = condition.IsDescending?query.OrderByDescending(q => q.Id):query.OrderBy(q => q.Id);
break;
}
}
else
{
query = query.OrderBy(q => q.Id);
}
if (condition.Page.HasValue && condition.PageCount.HasValue)
{
query = query.Skip((condition.Page.Value - 1) * condition.PageCount.Value).Take(condition.PageCount.Value);
}
return(query);
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(null);
}
}
public List <ProductDetailModel> Get(ProductDetailSearchCondition condition)
{
var model = _productDetailService.GetProductDetailsByCondition(condition).Select(c => new ProductDetailModel
{
Id = c.Id,
Name = c.Name,
Detail = c.Detail,
Img = c.Img,
Img1 = c.Img1,
Img2 = c.Img2,
Img3 = c.Img3,
Img4 = c.Img4,
SericeInstruction = c.SericeInstruction,
AddUser = c.AddUser,
AddTime = c.AddTime,
UpdUser = c.UpdUser,
UpdTime = c.UpdTime,
Ad1 = c.Ad1,
Ad2 = c.Ad2,
Ad3 = c.Ad3,
}).ToList();
return(model);
}
public IQueryable <ProductDetailEntity> GetProductDetailsByCondition(ProductDetailSearchCondition condition)
{
var query = _productdetailRepository.Table;
try
{
if (condition.AddtimeBegin.HasValue)
{
query = query.Where(q => q.Addtime >= condition.AddtimeBegin.Value);
}
if (condition.AddtimeEnd.HasValue)
{
query = query.Where(q => q.Addtime < condition.AddtimeEnd.Value);
}
if (condition.UpdtimeBegin.HasValue)
{
query = query.Where(q => q.Updtime >= condition.UpdtimeBegin.Value);
}
if (condition.UpdtimeEnd.HasValue)
{
query = query.Where(q => q.Updtime < condition.UpdtimeEnd.Value);
}
if (!string.IsNullOrEmpty(condition.Productname))
{
query = query.Where(q => q.Productname.Contains(condition.Productname));
}
if (!string.IsNullOrEmpty(condition.Productdetail))
{
query = query.Where(q => q.Productdetail.Contains(condition.Productdetail));
}
if (!string.IsNullOrEmpty(condition.Productimg))
{
query = query.Where(q => q.Productimg.Contains(condition.Productimg));
}
if (!string.IsNullOrEmpty(condition.Productimg1))
{
query = query.Where(q => q.Productimg1.Contains(condition.Productimg1));
}
if (!string.IsNullOrEmpty(condition.Productimg2))
{
query = query.Where(q => q.Productimg2.Contains(condition.Productimg2));
}
if (!string.IsNullOrEmpty(condition.Productimg3))
{
query = query.Where(q => q.Productimg3.Contains(condition.Productimg3));
}
if (!string.IsNullOrEmpty(condition.Productimg4))
{
query = query.Where(q => q.Productimg4.Contains(condition.Productimg4));
}
if (!string.IsNullOrEmpty(condition.Sericeinstruction))
{
query = query.Where(q => q.Sericeinstruction.Contains(condition.Sericeinstruction));
}
if (!string.IsNullOrEmpty(condition.Adduser))
{
query = query.Where(q => q.Adduser.Contains(condition.Adduser));
}
if (!string.IsNullOrEmpty(condition.Upduser))
{
query = query.Where(q => q.Upduser.Contains(condition.Upduser));
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
if (condition.OrderBy.HasValue)
{
switch (condition.OrderBy.Value)
{
case EnumProductDetailSearchOrderBy.OrderById:
query = condition.IsDescending?query.OrderByDescending(q => q.Id):query.OrderBy(q => q.Id);
break;
}
}
else
{
query = query.OrderBy(q => q.Id);
}
if (condition.Page.HasValue && condition.PageCount.HasValue)
{
query = query.Skip((condition.Page.Value - 1) * condition.PageCount.Value).Take(condition.PageCount.Value);
}
return(query);
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(null);
}
}
public int GetProductDetailCount(ProductDetailSearchCondition condition)
{
var query = _productdetailRepository.Table;
try
{
if (condition.AddtimeBegin.HasValue)
{
query = query.Where(q => q.Addtime >= condition.AddtimeBegin.Value);
}
if (condition.AddtimeEnd.HasValue)
{
query = query.Where(q => q.Addtime < condition.AddtimeEnd.Value);
}
if (condition.UpdtimeBegin.HasValue)
{
query = query.Where(q => q.Updtime >= condition.UpdtimeBegin.Value);
}
if (condition.UpdtimeEnd.HasValue)
{
query = query.Where(q => q.Updtime < condition.UpdtimeEnd.Value);
}
if (!string.IsNullOrEmpty(condition.Productname))
{
query = query.Where(q => q.Productname.Contains(condition.Productname));
}
if (!string.IsNullOrEmpty(condition.Productdetail))
{
query = query.Where(q => q.Productdetail.Contains(condition.Productdetail));
}
if (!string.IsNullOrEmpty(condition.Productimg))
{
query = query.Where(q => q.Productimg.Contains(condition.Productimg));
}
if (!string.IsNullOrEmpty(condition.Productimg1))
{
query = query.Where(q => q.Productimg1.Contains(condition.Productimg1));
}
if (!string.IsNullOrEmpty(condition.Productimg2))
{
query = query.Where(q => q.Productimg2.Contains(condition.Productimg2));
}
if (!string.IsNullOrEmpty(condition.Productimg3))
{
query = query.Where(q => q.Productimg3.Contains(condition.Productimg3));
}
if (!string.IsNullOrEmpty(condition.Productimg4))
{
query = query.Where(q => q.Productimg4.Contains(condition.Productimg4));
}
if (!string.IsNullOrEmpty(condition.Sericeinstruction))
{
query = query.Where(q => q.Sericeinstruction.Contains(condition.Sericeinstruction));
}
if (!string.IsNullOrEmpty(condition.Adduser))
{
query = query.Where(q => q.Adduser.Contains(condition.Adduser));
}
if (!string.IsNullOrEmpty(condition.Upduser))
{
query = query.Where(q => q.Upduser.Contains(condition.Upduser));
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
return(query.Count());
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(-1);
}
}
