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));
}
