public HttpResponseMessage GetCount(
int?categoryId = null,
decimal?priceBegin = null,
decimal?priceEnd = null,
bool isDescending = false,
string name = "",
string spec = "",
int pageCount = 10,
int page = 1,
string ids = "",
EnumProductSearchOrderBy orderBy = EnumProductSearchOrderBy.OrderById)
{
var condition = new ProductSearchCondition
{
CategoryId = categoryId,
IsDescending = isDescending,
Name = name,
OrderBy = orderBy,
Page = page,
PageCount = pageCount,
PriceBegin = priceBegin,
PriceEnd = priceEnd,
Spec = spec,
Ids = string.IsNullOrEmpty(ids) ? null : ids.Split(',').Select(int.Parse).ToArray()
};
var count = _productService.GetProductCount(condition);
return(PageHelper.toJson(new { TotalCount = count, Condition = condition }));
}
public HttpResponseMessage GetByCondition(
int?categoryId = null,
decimal?priceBegin = null,
decimal?priceEnd = null,
bool isDescending = false,
string name = "",
string spec = "",
int pageCount = 10,
int page = 1,
string ids = "",
EnumProductSearchOrderBy orderBy = EnumProductSearchOrderBy.OrderById)
{
var condition = new ProductSearchCondition
{
CategoryId = categoryId,
IsDescending = isDescending,
Name = name,
OrderBy = orderBy,
Page = page,
PageCount = pageCount,
PriceBegin = priceBegin,
PriceEnd = priceEnd,
Spec = spec,
Ids = string.IsNullOrEmpty(ids) ? null : ids.Split(',').Select(int.Parse).ToArray()
};
var model = _productService.GetProductsByCondition(condition).Select(c => new ProductModel
{
Id = c.Id,
Name = c.Name,
Spec = c.Spec,
Price = c.Price,
Adduser = new UserModel {
Id = c.Adduser.Id, UserName = c.Adduser.UserName
},
Addtime = c.Addtime,
Upduser = new UserModel {
Id = c.Upduser.Id, UserName = c.Upduser.UserName
},
Updtime = c.Updtime,
Unit = c.Unit,
Image = c.Image,
// Detail = c.Detail,
// Category = c.Category,
Status = c.Status,
// PropertyValues = c.PropertyValues,
}).ToList();
return(PageHelper.toJson(new { List = model }));
//return model;
}
public HttpResponseMessage GetCount(
int? categoryId = null,
decimal? priceBegin = null,
decimal? priceEnd = null,
bool isDescending = false,
string name = "",
string spec = "",
int pageCount = 10,
int page = 1,
string ids = "",
EnumProductSearchOrderBy orderBy = EnumProductSearchOrderBy.OrderById)
{
var condition = new ProductSearchCondition
{
CategoryId = categoryId,
IsDescending = isDescending,
Name = name,
OrderBy = orderBy,
Page = page,
PageCount = pageCount,
PriceBegin = priceBegin,
PriceEnd = priceEnd,
Spec = spec,
Ids = string.IsNullOrEmpty(ids) ? null : ids.Split(',').Select(int.Parse).ToArray()
};
var count = _productService.GetProductCount(condition);
return PageHelper.toJson(new { TotalCount = count, Condition = condition });
}
public HttpResponseMessage GetByCondition(
int? categoryId = null,
decimal? priceBegin = null,
decimal? priceEnd = null,
bool isDescending = false,
string name = "",
string spec = "",
int pageCount = 10,
int page = 1,
string ids = "",
EnumProductSearchOrderBy orderBy = EnumProductSearchOrderBy.OrderById)
{
var condition = new ProductSearchCondition
{
CategoryId = categoryId,
IsDescending = isDescending,
Name = name,
OrderBy = orderBy,
Page = page,
PageCount = pageCount,
PriceBegin = priceBegin,
PriceEnd = priceEnd,
Spec = spec,
Ids = string.IsNullOrEmpty(ids) ? null : ids.Split(',').Select(int.Parse).ToArray()
};
var model = _productService.GetProductsByCondition(condition).Select(c => new ProductModel
{
Id = c.Id,
Name = c.Name,
Spec = c.Spec,
Price = c.Price,
Adduser = new UserModel { Id = c.Adduser.Id, UserName = c.Adduser.UserName },
Addtime = c.Addtime,
Upduser = new UserModel { Id = c.Upduser.Id, UserName = c.Upduser.UserName },
Updtime = c.Updtime,
Unit = c.Unit,
Image = c.Image,
// Detail = c.Detail,
// Category = c.Category,
Status = c.Status,
// PropertyValues = c.PropertyValues,
}).ToList();
return PageHelper.toJson(new { List = model });
//return model;
}
public HttpResponseMessage GetAllProduct(int page = 1, int pageSize = 10, bool isDes = true, EnumProductSearchOrderBy orderByAll = EnumProductSearchOrderBy.OrderByAddtime)
{
ProductSearchCondition PSC = new ProductSearchCondition()
{
Page = page,
PageCount = pageSize,
IsDescending = isDes,
OrderBy = orderByAll
};
var productList = _productService.GetProductsByCondition(PSC).Select(a => new ProductDetail
{
Id = a.Id,
Productname = a.Productname,
Productimg = a.Productimg,
Price = a.Price,
RecCommission = a.RecCommission,
Commission = a.Commission,
Dealcommission = a.Dealcommission,
ClassifyName = a.Classify.Name,
Addtime = a.Addtime,
Phone = a.ContactPhone,
SubTitle = a.SubTitle,
ProductDetailed = a.ProductDetail.Productdetail,
StockRule = a.Stockrule,
Advertisement = a.ProductDetail.Ad1,
Acreage = a.ProductParameter.FirstOrDefault(pp => pp.Parameter.Name == "面积").ParameterValue.Parametervalue.ToString(),
Type = a.ProductParameter.FirstOrDefault(p => p.Parameter.Name == "户型").ParameterValue.Parametervalue.ToString()
}).ToList().Select(b => new
{
b.Id,
b.Productname,
b.Productimg,
b.Price,
b.RecCommission,
b.Commission,
b.Dealcommission,
b.ClassifyName,
b.Addtime,
b.Phone,
b.SubTitle,
b.ProductDetailed,
b.StockRule,
b.Acreage,
b.Type,
b.Advertisement
});
var totalCount = _productService.GetProductCount(PSC);
return(PageHelper.toJson(new { List = productList, Condition = PSC, TotalCount = totalCount }));
//return PageHelper.toJson(_productService.GetProductsByCondition(PSC).ToList());
}
public HttpResponseMessage GetAllProduct(int page = 1, int pageSize = 10, bool isDes = true, EnumProductSearchOrderBy orderByAll = EnumProductSearchOrderBy.OrderByAddtime)
{
ProductSearchCondition PSC = new ProductSearchCondition()
{
Page = page,
PageCount = pageSize,
IsDescending = isDes,
OrderBy = orderByAll
};
var productList = _productService.GetProductsByCondition(PSC).Select(a => new ProductDetail
{
Id = a.Id,
Productname = a.Productname,
Productimg = a.Productimg,
Price = a.Price,
RecCommission = a.RecCommission,
Commission = a.Commission,
Dealcommission = a.Dealcommission,
ClassifyName = a.Classify.Name,
Addtime = a.Addtime,
Phone=a.ContactPhone,
SubTitle = a.SubTitle,
ProductDetailed = a.ProductDetail.Productdetail,
StockRule = a.Stockrule,
Advertisement = a.ProductDetail.Ad1,
Acreage = a.ProductParameter.FirstOrDefault(pp => pp.Parameter.Name == "面积").ParameterValue.Parametervalue.ToString(),
Type = a.ProductParameter.FirstOrDefault(p => p.Parameter.Name == "户型").ParameterValue.Parametervalue.ToString()
}).ToList().Select(b => new
{
b.Id,
b.Productname,
b.Productimg,
b.Price,
b.RecCommission,
b.Commission,
b.Dealcommission,
b.ClassifyName,
b.Addtime,
b.Phone,
b.SubTitle,
b.ProductDetailed,
b.StockRule,
b.Acreage,
b.Type,
b.Advertisement
});
var totalCount = _productService.GetProductCount(PSC);
return PageHelper.toJson(new { List = productList, Condition = PSC, TotalCount = totalCount });
//return PageHelper.toJson(_productService.GetProductsByCondition(PSC).ToList());
}
