/// <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="sortOptions">排序</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, string sortColumn, string sortDirection, int cateId = -1, int brandId = -1, int pageNumber = 1, int pageSize = 15) { string condition = AdminProducts.AdminGetProductListCondition(0, 0, productName, cateId, brandId, -1); string sort = AdminProducts.AdminGetProductListSort(sortColumn, sortDirection); PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProducts.AdminGetProductCount(condition)); DataTable productList = AdminProducts.AdminGetProductList(pageModel.PageSize, pageModel.PageNumber, condition, sort); StringBuilder pidList = new StringBuilder(); foreach (DataRow row in productList.Rows) { pidList.AppendFormat("{0},", row["pid"]); } ProductStatModel model = new ProductStatModel() { ProductList = pidList.Length > 0 ? AdminProducts.GetProductSummaryList(pidList.Remove(pidList.Length - 1, 1).ToString()) : new DataTable(), PageModel = pageModel, SortColumn = sortColumn, SortDirection = sortDirection, ProductName = productName, CateId = cateId, BrandId = brandId, CategoryName = string.IsNullOrWhiteSpace(categoryName) ? "全部分类" : categoryName, BrandName = string.IsNullOrWhiteSpace(brandName) ? "全部品牌" : 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); string sort = AdminProducts.AdminGetProductListSort("", ""); PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProducts.AdminGetProductCount(condition)); DataTable dt = AdminProducts.AdminGetProductList(pageModel.PageSize, pageModel.PageNumber, condition, sort); 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())); }