/// <summary>
/// 导出商品分销明细
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ActionResult ProductsExportToExcel(DistributionProductQuery query)
{
query.ShopId = CurrentSellerManager.ShopId;
var results = DistributionApplication.GetProductsAll(query);
return(ExcelView("ProductsExport", "商家商品分销明细", results));
}
public JsonResult GetProductList(string skey, int rows, int page, long categoryId = 0)
{
//查询条件
DistributionProductQuery query = new DistributionProductQuery();
query.ProductName = skey;
query.PageSize = rows;
query.PageNo = page;
query.Status = DistributionProductStatus.Normal;
query.ShopId = curshopid;
if (categoryId != 0)
{
query.CategoryId = categoryId;
}
query.isShopCategory = true;
var data = DistributionApplication.GetProducts(query);
var datalist = new List <DistributionProductListModel>();
if (data.Models != null)
{
var products = ProductManagerApplication.GetProductsByIds(data.Models.Select(p => p.ProductId).ToList());
var categories = CategoryApplication.GetCategories();
foreach (var item in data.Models)
{
var product = products.FirstOrDefault(p => p.Id == item.ProductId);
var categorie = categories.FirstOrDefault(p => p.Id == product.Id);
datalist.Add(new DistributionProductListModel
{
BrokerageId = item.Id,
ProductId = item.ProductId,
ProductName = product.ProductName,
CategoryId = product.CategoryId,
CategoryName = GetProductShopCategorieName(product.Id),
ShopId = item.ShopId,
BrokerageRate1 = item.BrokerageRate1,
BrokerageRate2 = item.BrokerageRate2,
BrokerageRate3 = item.BrokerageRate3,
MaxBrokerage = item.MaxBrokerage,
MaxSalePrice = item.MaxSalePrice,
MinSalePrice = item.MinSalePrice,
NoSettlementAmount = item.NoSettlementAmount,
ProductStatus = item.ProductStatus,
SaleAmount = item.SaleAmount,
SaleCount = item.SaleCount,
SettlementAmount = item.SettlementAmount,
ShopName = item.ShopName
});
}
}
var result = new { rows = datalist, total = data.Total };
return(Json(result));
}
/// <summary>
/// 分销商品(忽略分页)
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static List <DistributionProduct> GetProductsAll(DistributionProductQuery query)
{
if (query.CategoryId.HasValue)
{
var categories = GetService <ICategoryService>().GetAllCategoryByParent(query.CategoryId.Value);
query.Categories = categories.Select(p => p.Id).ToList();
query.Categories.Add(query.CategoryId.Value);
}
var result = _iDistributionService.GetProductsAll(query);
return(result);
}
public ActionResult Products(DistributionProductQuery query)
{
query.ShopId = CurrentShop.Id;
var data = DistributionApplication.GetProducts(query);
var list = data.Models.Select(item => new
{
item.ProductId,
item.ProductName,
Status = item.ProductStatus.ToDescription(),
Quantity = item.SaleCount,
Amount = item.SaleAmount.ToString("F2"),
Settlement = item.SettlementAmount.ToString("F2"),
NoSettlement = item.NoSettlementAmount.ToString("F2")
});
return(Json(new { rows = list, total = data.Total }, true));
}
/// <summary>
/// 获取分销商品集
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static QueryPageModel <DistributionProduct> GetProducts(DistributionProductQuery query)
{
if (query.CategoryId.HasValue)
{
var categories = GetService <ICategoryService>().GetAllCategoryByParent(query.CategoryId.Value);
query.Categories = categories.Select(p => p.Id).ToList();
query.Categories.Add(query.CategoryId.Value);
}
var result = _iDistributionService.GetProducts(query);
foreach (var item in result.Models)
{
item.DefaultImage = MallIO.GetProductSizeImage(item.ImagePath, 1, (int)ImageSize.Size_500);
item.NoSettlementAmount = Math.Round(item.NoSettlementAmount, 2, MidpointRounding.AwayFromZero);
}
return(result);
}
public JsonResult GetProductList(string productName, string shopname, int rows, int page, DistributionProductStatus?status = null, string Sort = "", bool IsAsc = false)
{
//查询条件
DistributionProductQuery query = new DistributionProductQuery();
query.ProductName = productName;
query.ShopName = shopname;
query.Status = status;
query.PageSize = rows;
query.PageNo = page;
query.Sort = Sort;
query.IsAsc = IsAsc;
var data = DistributionApplication.GetProducts(query);
var result = new { rows = data.Models, total = data.Total };
return(Json(result));
}
/// <summary>
/// 获取分销商品
/// </summary>
/// <returns></returns>
public JsonResult <Result <dynamic> > GetProductList(string productName = null, long?categoryId = null, int pageSize = 10, int pageNo = 1)
{
CheckUserLogin();
//查询条件
DistributionProductQuery query = new DistributionProductQuery();
query.ProductName = productName;
query.CategoryId = categoryId;
query.Status = DistributionProductStatus.Normal;
query.PageSize = pageSize;
query.PageNo = pageNo;
query.Sort = "SaleCount";
query.IsAsc = false;
var data = DistributionApplication.GetProducts(query);
foreach (var item in data.Models)
{
item.DefaultImage = HimallIO.GetRomoteImagePath(item.DefaultImage);
}
var result = new { rows = data.Models, total = data.Total };
return(JsonResult <dynamic>(result));
}
/// <summary>
/// 导出分销商品
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ActionResult ExportToExcel(DistributionProductQuery query)
{
var results = DistributionApplication.GetProductsAll(query);
return(ExcelView("ExportDistributionProduct", "平台分销商品", results));
}