/// <summary>
/// 商品统计
/// </summary>
/// <param name="productName">商品名称</param>
/// <param name="storeName">店铺名称</param>
/// <param name="categoryName">分类名称</param>
/// <param name="brandName">品牌名称</param>
/// <param name="storeId">店铺id</param>
/// <param name="cateId">分类id</param>
/// <param name="brandId">品牌id</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult ProductStat(string productName, string storeName, string categoryName, string brandName, int storeId = -1, int cateId = -1, int brandId = -1, int pageNumber = 1, int pageSize = 15)
{
string condition = AdminProducts.AdminGetProductListCondition(storeId, 0, productName, cateId, brandId, -1);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProducts.AdminGetProductCount(condition));
DataTable productList = AdminProducts.AdminGetProductList(pageModel.PageSize, pageModel.PageNumber, condition);
StringBuilder pidList = new StringBuilder();
foreach (DataRow row in productList.Rows)
{
pidList.AppendFormat("{0},", row["pid"]);
}
ProductStatModel model = new ProductStatModel()
{
PageModel = pageModel,
ProductList = pidList.Length > 0 ? AdminProducts.GetProductSummaryList(pidList.Remove(pidList.Length - 1, 1).ToString()) : new DataTable(),
ProductName = productName,
StoreId = storeId,
StoreName = string.IsNullOrWhiteSpace(storeName) ? "全部店铺" : storeName,
CateId = cateId,
CategoryName = string.IsNullOrWhiteSpace(categoryName) ? "全部分类" : categoryName,
BrandId = brandId,
BrandName = string.IsNullOrWhiteSpace(brandName) ? "全部品牌" : brandName
};
return(View(model));
}
/// <summary>
/// 下架商品列表
/// </summary>
/// <param name="storeName">店铺名称</param>
/// <param name="productName">商品名称</param>
/// <param name="categoryName">分类名称</param>
/// <param name="brandName">品牌名称</param>
/// <param name="storeId">店铺id</param>
/// <param name="cateId">分类id</param>
/// <param name="brandId">品牌id</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult OutSaleProductList(string storeName, string productName, string categoryName, string brandName, string sortColumn, string sortDirection, int storeId = -1, int cateId = -1, int brandId = -1, int pageNumber = 1, int pageSize = 15)
{
string condition = AdminProducts.AdminGetProductListCondition(storeId, 0, productName, cateId, brandId, (int)ProductState.OutSale);
string sort = AdminProducts.AdminGetProductListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProducts.AdminGetProductCount(condition));
ProductListModel model = new ProductListModel()
{
ProductList = AdminProducts.AdminGetProductList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
StoreId = storeId,
ProductName = productName,
CateId = cateId,
BrandId = brandId,
StoreName = string.IsNullOrWhiteSpace(storeName) ? "全部店铺" : storeName,
CategoryName = string.IsNullOrWhiteSpace(categoryName) ? "全部分类" : categoryName,
BrandName = string.IsNullOrWhiteSpace(brandName) ? "全部品牌" : brandName
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&storeId={5}&ProductName={6}&cateId={7}&brandId={8}&storeName={9}&categoryName={10}&brandName={11}",
Url.Action("outsaleproductlist"),
pageModel.PageNumber, pageModel.PageSize,
sortColumn, sortDirection,
storeId, productName, cateId, brandId,
storeName, categoryName, brandName));
return(View(model));
}
/// <summary>
/// 下架商品列表
/// </summary>
/// <param name="productName">商品名称</param>
/// <param name="categoryName">分类名称</param>
/// <param name="brandName">品牌名称</param>
/// <param name="cateId">分类id</param>
/// <param name="brandId">品牌id</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult OutSaleProductList(string productName, string categoryName, string brandName, int cateId = -1, int brandId = -1, int pageNumber = 1, int pageSize = 15)
{
string condition = AdminProducts.AdminGetProductListCondition(productName, cateId, brandId, (int)ProductState.OutSale);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProducts.AdminGetProductCount(condition));
ProductListModel model = new ProductListModel()
{
PageModel = pageModel,
ProductList = AdminProducts.AdminGetProductList(pageModel.PageSize, pageModel.PageNumber, condition),
CateId = cateId,
CategoryName = string.IsNullOrWhiteSpace(categoryName) ? "全部分类" : categoryName,
BrandId = brandId,
BrandName = string.IsNullOrWhiteSpace(brandName) ? "全部品牌" : brandName,
ProductName = productName
};
ShopUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&ProductName={3}&cateId={4}&brandId={5}&categoryName={6}&brandName={7}",
Url.Action("outsaleproductlist"),
pageModel.PageNumber, pageModel.PageSize,
productName,
cateId, brandId,
categoryName, brandName));
return(View(model));
}
/// <summary>
/// 商品统计
/// </summary>
/// <param name="productName">商品名称</param>
/// <param name="categoryName">分类名称</param>
/// <param name="brandName">品牌名称</param>
/// <param name="storeCid">店铺分类id</param>
/// <param name="cateId">分类id</param>
/// <param name="brandId">品牌id</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult ProductStat(string productName, string categoryName, string brandName, int storeCid = -1, int cateId = -1, int brandId = -1, int pageNumber = 1, int pageSize = 15)
{
string condition = AdminProducts.AdminGetProductListCondition(WorkContext.StoreId, storeCid, productName, cateId, brandId, -1);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProducts.AdminGetProductCount(condition));
DataTable productList = AdminProducts.AdminGetProductList(pageModel.PageSize, pageModel.PageNumber, condition);
StringBuilder pidList = new StringBuilder();
foreach (DataRow row in productList.Rows)
{
pidList.AppendFormat("{0},", row["pid"]);
}
List <SelectListItem> storeClassList = new List <SelectListItem>();
storeClassList.Add(new SelectListItem()
{
Text = "全部店铺分类", Value = "0"
});
foreach (StoreClassInfo storeClassInfo in AdminStores.GetStoreClassList(WorkContext.StoreId))
{
storeClassList.Add(new SelectListItem()
{
Text = storeClassInfo.Name, Value = storeClassInfo.StoreCid.ToString()
});
}
ProductStatModel model = new ProductStatModel()
{
PageModel = pageModel,
ProductList = pidList.Length > 0 ? AdminProducts.GetProductSummaryList(pidList.Remove(pidList.Length - 1, 1).ToString()) : new DataTable(),
ProductName = productName,
StoreCid = storeCid,
StoreClassList = storeClassList,
CateId = cateId,
CategoryName = string.IsNullOrWhiteSpace(categoryName) ? "全部分类" : categoryName,
BrandId = brandId,
BrandName = string.IsNullOrWhiteSpace(brandName) ? "全部品牌" : brandName
};
return(View(model));
}
/// <summary>
/// 下架商品列表
/// </summary>
/// <param name="productName">商品名称</param>
/// <param name="categoryName">分类名称</param>
/// <param name="brandName">品牌名称</param>
/// <param name="storeCid">店铺分类id</param>
/// <param name="cateId">分类id</param>
/// <param name="brandId">品牌id</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult OutSaleProductList(string productName, string categoryName, string brandName, int storeCid = -1, int cateId = -1, int brandId = -1, int pageNumber = 1, int pageSize = 15)
{
string condition = AdminProducts.AdminGetProductListCondition(WorkContext.StoreId, storeCid, productName, cateId, brandId, (int)ProductState.OutSale);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProducts.AdminGetProductCount(condition));
List <SelectListItem> storeClassList = new List <SelectListItem>();
storeClassList.Add(new SelectListItem()
{
Text = "全部分类", Value = "0"
});
foreach (StoreClassInfo storeClassInfo in AdminStores.GetStoreClassList(WorkContext.StoreId))
{
storeClassList.Add(new SelectListItem()
{
Text = storeClassInfo.Name, Value = storeClassInfo.StoreCid.ToString()
});
}
ProductListModel model = new ProductListModel()
{
PageModel = pageModel,
ProductList = AdminProducts.AdminGetProductList(pageModel.PageSize, pageModel.PageNumber, condition),
StoreCid = storeCid,
StoreClassList = storeClassList,
CateId = cateId,
CategoryName = string.IsNullOrWhiteSpace(categoryName) ? "全部分类" : categoryName,
BrandId = brandId,
BrandName = string.IsNullOrWhiteSpace(brandName) ? "全部品牌" : brandName,
ProductName = productName
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&storeCid={3}&productName={4}&cateId={5}&brandId={6}&categoryName={7}&brandName={8}",
Url.Action("outsaleproductlist"),
pageModel.PageNumber, pageModel.PageSize,
storeCid, productName,
cateId, brandId,
categoryName, brandName));
return(View(model));
}
/// <summary>
/// 商品选择列表
/// </summary>
/// <param name="productName">商品名称</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <param name="storeId">店铺id</param>
/// <param name="cateId">分类id</param>
/// <param name="brandId">品牌id</param>
/// <returns></returns>
public ActionResult ProductSelectList(string productName, int pageNumber = 1, int pageSize = 12, int storeId = -1, int cateId = -1, int brandId = -1)
{
string condition = AdminProducts.AdminGetProductListCondition(storeId, 0, productName, cateId, brandId, (int)ProductState.OnSale);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProducts.AdminGetProductCount(condition));
DataTable dt = AdminProducts.AdminGetProductList(pageModel.PageSize, pageModel.PageNumber, condition);
StringBuilder result = new System.Text.StringBuilder("{");
result.AppendFormat("\"totalPages\":\"{0}\",\"pageNumber\":\"{1}\",\"items\":[", pageModel.TotalPages, pageModel.PageNumber);
foreach (DataRow row in dt.Rows)
{
result.AppendFormat("{0}\"id\":\"{1}\",\"name\":\"{2}\"{3},", "{", row["pid"], row["pname"].ToString().Trim(), "}");
}
if (dt.Rows.Count > 0)
{
result.Remove(result.Length - 1, 1);
}
result.Append("]}");
return(Content(result.ToString()));
}
