public ActionResult FinancialReportDataText()
{
SalesStatisticsReportQueryFilter filter = SerializationUtility.JsonDeserialize2 <SalesStatisticsReportQueryFilter>(Request.Form["data"]);
filter.C1SysNo = filter.Category.C1SysNo == 0 ? null : filter.Category.C1SysNo;
filter.C2SysNo = filter.Category.C2SysNo == 0 ? null : filter.Category.C2SysNo;
filter.C3SysNo = filter.Category.C3SysNo == 0 ? null : filter.Category.C3SysNo;
filter.SortFields = "B.ProductID DESC";
int MerchantSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo;
filter.VendorSysNoList = new List <int>();
filter.VendorSysNoList.Add(MerchantSysNo);
filter.SOStatusList = new List <int>();
if (filter.SOStatus.HasValue)
{
filter.SOStatusList.Add(filter.SOStatus.Value);
}
var result = FinancialReportService.SalesStatisticsReportQuery(filter);
string text = "";
if (result.SalesStatisticsResult.ResultList != null && result.SalesStatisticsResult.ResultList.Count > 0)
{
string page = string.Format("{0}： --- 销售成本：{1} 销售金额：{2} 优惠金额：{3} 实际销售金额：{4} 商品毛利：{5}",
"本页小计",
result.CostReportStatisticList[0].ProductCost,
result.CostReportStatisticList[0].ProductPriceAmount,
result.CostReportStatisticList[0].PromotionDiscountAmount,
result.CostReportStatisticList[0].ProductSaleAmount,
result.CostReportStatisticList[0].ProductGrossMargin);
string Total = string.Format("{0}： --- 销售成本：{1} 销售金额：{2} 优惠金额：{3} 实际销售金额：{4} 商品毛利：{5}",
"全部总计",
result.CostReportStatisticList[1].ProductCost,
result.CostReportStatisticList[1].ProductPriceAmount,
result.CostReportStatisticList[1].PromotionDiscountAmount,
result.CostReportStatisticList[1].ProductSaleAmount,
result.CostReportStatisticList[1].ProductGrossMargin);
text = "<div class='col-md-12' style='color:red;'>" + page + "</div><div class='col-md-12' style='color:red;'>" + Total + "</div>";
}
return(Content(text));
}
public ActionResult GetFinancialReportData()
{
SalesStatisticsReportQueryFilter filter = BuildQueryFilterEntity <SalesStatisticsReportQueryFilter>();
filter.C1SysNo = filter.Category.C1SysNo == 0 ? null : filter.Category.C1SysNo;
filter.C2SysNo = filter.Category.C2SysNo == 0 ? null : filter.Category.C2SysNo;
filter.C3SysNo = filter.Category.C3SysNo == 0 ? null : filter.Category.C3SysNo;
int MerchantSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo;
filter.VendorSysNoList = new List <int>();
filter.VendorSysNoList.Add(MerchantSysNo);
filter.SOStatusList = new List <int>();
if (filter.SOStatus.HasValue)
{
filter.SOStatusList.Add(filter.SOStatus.Value);
}
SalesStatisticsReport result = FinancialReportService.SalesStatisticsReportQuery(filter);
return(AjaxGridJson(result.SalesStatisticsResult));
}
public FileResult AjaxFinancialExportData(string queryString)
{
//每页显示条数:
SalesStatisticsReportQueryFilter getQueryEntity = SerializationUtility.JsonDeserialize2 <SalesStatisticsReportQueryFilter>(queryString);
getQueryEntity.C1SysNo = getQueryEntity.Category.C1SysNo == 0 ? null : getQueryEntity.Category.C1SysNo;
getQueryEntity.C2SysNo = getQueryEntity.Category.C2SysNo == 0 ? null : getQueryEntity.Category.C2SysNo;
getQueryEntity.C3SysNo = getQueryEntity.Category.C3SysNo == 0 ? null : getQueryEntity.Category.C3SysNo;
getQueryEntity.SortFields = "B.ProductID DESC";
int MerchantSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo;
getQueryEntity.VendorSysNoList = new List <int>();
getQueryEntity.VendorSysNoList.Add(MerchantSysNo);
getQueryEntity.SOStatusList = new List <int>();
if (getQueryEntity.SOStatus.HasValue)
{
getQueryEntity.SOStatusList.Add(getQueryEntity.SOStatus.Value);
}
getQueryEntity.PageSize = 10000000;
getQueryEntity.PageIndex = 0;
SalesStatisticsReport result = FinancialReportService.SalesStatisticsReportQuery(getQueryEntity);
List <DataTable> dataTableList = new List <DataTable>();
if (result.SalesStatisticsResult.ResultList.Count <= 0)
{
throw new BusinessException("无数据可导出！！！");
}
DataTable newDt = ToDataTableTow(result.SalesStatisticsResult.ResultList);
dataTableList.Add(newDt);
List <ColumnData> columndatalist = new List <ColumnData>();
ColumnData columndata = null;
columndata = new ColumnData()
{
FieldName = "ProductID", Width = 20, Title = "商品ID"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "ProductName", Width = 30, Title = "商品名称"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "C1Name", Width = 15, Title = "一级分类"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "C2Name", Width = 15, Title = "二级分类"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "C3Name", Width = 15, Title = "三级分类", ValueFormat = ""
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "BeginDate", Width = 20, Title = "开始时间"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "EndDate", Width = 20, Title = "结束时间"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "BrandName", Width = 20, Title = "品牌"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "VendorName", Width = 20, Title = "供应商"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "StockName", Width = 20, Title = "仓库"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "BMCode", Width = 20, Title = "BM编号"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "ProductProperty1", Width = 20, Title = "属性1"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "ProductProperty2", Width = 20, Title = "属性2"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "Quantity", Width = 20, Title = "数量"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "ProductCost", Width = 20, Title = "销售成本"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "ProductPriceAmount", Width = 20, Title = "销售金额"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "PromotionDiscountAmount", Width = 20, Title = "优惠金额"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "ProductSaleAmount", Width = 20, Title = "实际销售金额"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "PayTypeName", Width = 20, Title = "支付方式"
};
columndatalist.Add(columndata);
columndata = new ColumnData()
{
FieldName = "ProductGrossMargin", Width = 20, Title = "商品毛利"
};
columndatalist.Add(columndata);
List <List <ColumnData> > columnList = new List <List <ColumnData> >();
columnList.Add(columndatalist);
//步骤5：调用生成Excel的公共方法，返回
/*例如:
* IFileExport excelExport = new ExcelFileExporter();
* byte[] excelByte = excelExport.CreateFile(dataTableList, columnList, null, out fileName, "测试导出Excel");
* return File(new MemoryStream(excelByte), "application/ms-excel", fileName);
*/
string fileName = "";
IFileExport excelExport = new ExcelFileExporter();
byte[] excelByte = excelExport.CreateFile(dataTableList, columnList, null, out fileName, "销售统计报表");
return(File(new MemoryStream(excelByte), "application/ms-excel", fileName));
}
