public ActionResult ExportProductInfoList(string startTime, string endTime, string spu, string sku, string productName, int supplierId = 0, int productStatus = -1, int salesTerritory = -1, int inventoryStatus = -1, int isOnSales = -1, int fstCagegoryId = 0, int sndCagegoryId = 0, int trdCagegoryId = 0) { var queryInfo = new ProductAuditingQuyModel(); if (string.IsNullOrEmpty(startTime) || string.IsNullOrEmpty(endTime)) { queryInfo.CreateTimeStart = DateTime.Now.AddMonths(-3); queryInfo.CreateTimeEnd = DateTime.Now; } else { queryInfo.CreateTimeStart = DateTime.Parse(startTime); queryInfo.CreateTimeEnd = DateTime.Parse(endTime); } queryInfo.Spu = spu; queryInfo.Sku = sku; queryInfo.ProductName = productName; queryInfo.ProductStatus = productStatus; queryInfo.InventoryStatus = inventoryStatus; queryInfo.SupplierId = supplierId; queryInfo.IsOnSales = isOnSales; queryInfo.SalesTerritory = salesTerritory; queryInfo.FstCagegoryId = fstCagegoryId; queryInfo.SndCagegoryId = sndCagegoryId; queryInfo.TrdCagegoryId = trdCagegoryId; try { PageOf <ProductAuditingListModel> dataList = productBll.GetProductList(queryInfo, LanguageEnum.TraditionalChinese, new PagingModel() { PageIndex = PageNo, PageSize = int.MaxValue }); Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=ProductInfoList" + System.DateTime.Now.ToString("yyyyMMdd") + ".xls"); Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); //设置输出流为简体中文 Response.ContentType = "application/ms-excel"; //设置输出文件类型为excel文件。 ProductInfotoExcel(dataList.Items); Response.End(); } catch (Exception ext) { LogHelper.Error(ext); } return(View()); }
public ActionResult AuditingProduct(string spu) { var dtNow = DateTime.Now; var pqm = new ProductAuditingQuyModel() { EditType = Request["EditType"] == null ? 0 : Convert.ToInt32(Request["EditType"].ToString()), ProductName = Request["ProductName"] == null ? "" : Request["ProductName"].ToString(), CreateTimeEnd = Request["EndTime"] == null ? dtNow : Convert.ToDateTime(Request["EndTime"].ToString()), CreateTimeStart = Request["StartTime"] == null?dtNow.AddMonths(-6) : Convert.ToDateTime(Request["StartTime"].ToString()), ReportStatus = Request["ReportStatus"] == null ? 0 : Convert.ToInt32(Request["ReportStatus"].ToString()), SalesTerritory = Request["SalesTerritory"] == null ? 0 : Convert.ToInt32(Request["SalesTerritory"].ToString()), Sku = Request["Sku"] == null ? "" : Request["Sku"].ToString(), Spu = Request["SpuNo"] == null ? "" : Request["SpuNo"].ToString(), SupplierId = Request["SupplierId"] == null ? 0 : Convert.ToInt32(Request["SupplierId"].ToString()) }; ViewBag.PageNo = Request["PageNo"] == null ? 1 : Convert.ToInt32(Request["PageNo"].ToString()); ViewBag.PageSize = Request["PageSize"] == null ? 50 : Convert.ToInt32(Request["PageSize"].ToString()); ViewBag.QueryParas = pqm; ProductAuditingViewModel result = new ProductAuditingViewModel(); ViewBag.SpuId = spu; try { ViewBag.KeyNames = CommonBLL.GetDicsInfoByKey("ProductAttributes"); result = productBll.GetProductAndCustomInfo(spu); if (result == null || result.SpuBaseInfo == null) { result.PackingInfo = new ProductPackingModel(); result.ProductAttrsInfos = new Dictionary <Models.Enums.LanguageEnum, Dictionary <string, string> >(); result.ProductCustomInfos = new List <ProductSkuCustomInfoModel>(); result.ProductImgs = new List <ProductImgInfoModel>(); result.SpuBaseInfo = new Dictionary <Models.Enums.LanguageEnum, ProductBaseInfoModel>(); result.SysInfo = new ProductSysPropertyModel(); } } catch (Exception ext) { LogHelper.Error(ext); } return(View(result)); }
public ActionResult ProductAuditingList(ProductAuditingQuyModel queryModel) { PageOf <ProductAuditingListModel> list = null; try { //2繁体 //list = productBll.GetAuditingProductList(this.PageSize, this.PageNo, 2, queryModel); //1简体 list = productBll.GetAuditingProductList(this.PageSize, this.PageNo, 1, queryModel); } catch (Exception ext) { LogHelper.Error(ext); } return(View(list)); }
public ActionResult ExcportProductAuditingList(DateTime startTime, DateTime endTime, string spu, string sku, string productName, int editType, int reportStatus, int supplierid, int salesTerritory) { var dtNow = DateTime.Now; ProductAuditingQuyModel qm = new ProductAuditingQuyModel() { Spu = spu, Sku = sku, CreateTimeEnd = endTime, CreateTimeStart = startTime, EditType = editType, ReportStatus = reportStatus, SupplierId = supplierid, SalesTerritory = salesTerritory }; PageOf <ProductExportModel> list = null; try { list = productBll.AuditingProductsExport(1, qm); Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=declare_customs" + System.DateTime.Now.ToString("yyyyMMdd") + ".xls"); Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); //设置输出流为简体中文 Response.ContentType = "application/ms-excel"; //设置输出文件类型为excel文件。 ProductAuditingListToExcel(list.Items); Response.End(); } catch (Exception ext) { LogHelper.Error(ext); } return(View()); }
//ProductBll bll = new ProductBll(); // // GET: /Product/ public ActionResult ProductAuditingIndex() { var dtNow = DateTime.Now; var pqm = new ProductAuditingQuyModel() { EditType = Request["EditType"] == null ? 0 : Convert.ToInt32(Request["EditType"].ToString()), ProductName = Request["ProductName"] == null ? "" : Request["ProductName"].ToString(), CreateTimeEnd = Request["EndTime"] == null ? dtNow : Convert.ToDateTime(Request["EndTime"].ToString()), CreateTimeStart = Request["StartTime"] == null?dtNow.AddMonths(-6) : Convert.ToDateTime(Request["StartTime"].ToString()), ReportStatus = Request["ReportStatus"] == null ? -2 : Convert.ToInt32(Request["ReportStatus"].ToString()), SalesTerritory = Request["SalesTerritory"] == null ? 0 : Convert.ToInt32(Request["SalesTerritory"].ToString()), Sku = Request["Sku"] == null ? "" : Request["Sku"].ToString(), Spu = Request["Spu"] == null ? "" : Request["Spu"].ToString(), SupplierId = Request["SupplierId"] == null ? 0 : Convert.ToInt32(Request["SupplierId"].ToString()) }; ViewBag.PageNo = Request["PageNo"] == null ? 1 : Convert.ToInt32(Request["PageNo"].ToString()); ViewBag.PageSize = Request["PageSize"] == null ? 50 : Convert.ToInt32(Request["PageSize"].ToString()); ViewBag.SupplierNames = supplierBLL.GetSupplierNames(); return(View(pqm)); }
public PageOf <ProductAuditingListModel> GetProductList(ProductAuditingQuyModel queryInfo, LanguageEnum languageEnum, Models.PagingModel page) { return(productDAL.GetProductList(queryInfo, languageEnum, page)); }
public PageOf <ProductExportModel> AuditingProductsExport(int languageVersion, ProductAuditingQuyModel queryModel) { return(productDAL.AuditingProductsExport(languageVersion, queryModel)); }
public PageOf <ProductAuditingListModel> GetAuditingProductList(int pageSize, int pageIndex, int languageVersion, ProductAuditingQuyModel queryModel) { return(productDAL.GetAuditingProductList(pageSize, pageIndex, languageVersion, queryModel)); }
/// <summary> /// 已上傳商品 /// </summary> /// <returns></returns> public ActionResult ProductInfoList(string startTime, string endTime, string spu, string sku, string productName, int supplierId = 0, int productStatus = -1, int salesTerritory = -1, int inventoryStatus = -1, int isOnSales = -1, int fstCagegoryId = 0, int sndCagegoryId = 0, int trdCagegoryId = 0) { var queryInfo = new ProductAuditingQuyModel(); if (string.IsNullOrEmpty(startTime) || string.IsNullOrEmpty(endTime)) { queryInfo.CreateTimeStart = DateTime.Now.AddMonths(-3); queryInfo.CreateTimeEnd = DateTime.Now; } else { queryInfo.CreateTimeStart = DateTime.Parse(startTime); queryInfo.CreateTimeEnd = DateTime.Parse(endTime); } queryInfo.Spu = spu; queryInfo.Sku = sku; queryInfo.ProductName = productName; queryInfo.ProductStatus = productStatus; queryInfo.InventoryStatus = inventoryStatus; queryInfo.SupplierId = supplierId; queryInfo.IsOnSales = isOnSales; queryInfo.SalesTerritory = salesTerritory; queryInfo.FstCagegoryId = fstCagegoryId; queryInfo.SndCagegoryId = sndCagegoryId; queryInfo.TrdCagegoryId = trdCagegoryId; ViewBag.QueryInfo = queryInfo; PageOf <ProductAuditingListModel> dataList = null; try { var page = new PagingModel() { PageIndex = PageNo, PageSize = 50 }; ViewBag.FirCategoryId = CategoryBLL.GetChildrenCategories(LanguageEnum.TraditionalChinese, 0, 0); List <CategoryModel> second = new List <CategoryModel>(); if (fstCagegoryId > 0) { second = CategoryBLL.GetChildrenCategories(LanguageEnum.TraditionalChinese, 1, fstCagegoryId); } ViewBag.SndCategoryId = second; List <CategoryModel> thrid = new List <CategoryModel>(); if (sndCagegoryId > 0) { thrid = CategoryBLL.GetChildrenCategories(LanguageEnum.TraditionalChinese, 2, sndCagegoryId); } ViewBag.TrdCategoryId = thrid; dataList = productBll.GetProductList(queryInfo, LanguageEnum.TraditionalChinese, page); } catch (Exception ex) { LogHelper.Error(ex); } return(View(dataList)); }