public void ExportPurchaseData(Hyt.Model.InventorySheet.WhInventoryDetail list, string userIp, int operatorSysno)
{
try
{
// 查询商品
List <WhInventoryProductDetailOutput> outputData = new List <WhInventoryProductDetailOutput>();
foreach (var item in list.dataList)
{
WhInventoryProductDetailOutput model = new WhInventoryProductDetailOutput();
model.WarehouseNameDate = item.WarehouseNameDate;
model.PrCode = item.ErpCode;
model.PrName = item.EasName;
model.ZhangCunQuantity = item.ZhangCunQuantity;
model.InventoryQuantity = item.InventoryQuantity;
model.Remarks = item.Remarks;
outputData.Add(model);
}
var fileName = string.Format("" + list.Code + "({0})", DateTime.Now.ToString("yyyyMMddHHmmss"));
/*
* 仓库名称
* 商品编码
* 后台显示名称
* 条形码
* 海关备案号
* 采购价格
* 库存数量
*/
//导出Excel，并设置表头列名
Util.ExcelUtil.Export <WhInventoryProductDetailOutput>(outputData,
new List <string> {
"仓库名称", "商品编号", "商品名称", "账存数量", "盘点数量", "备注"
},
fileName);
SysLog.Instance.WriteLog(LogStatus.SysLogLevel.Info, LogStatus.系统日志来源.后台, "盘点数据录入商品导出excel",
LogStatus.系统日志目标类型.ExcelExporting, 0, null, userIp, operatorSysno);
}
catch (Exception ex)
{
SysLog.Instance.WriteLog(LogStatus.SysLogLevel.Error, LogStatus.系统日志来源.后台, "盘点数据录入商品导出excel",
LogStatus.系统日志目标类型.ExcelExporting, 0, ex, userIp, operatorSysno);
}
}
public void ExportPurchaseData(int?id)
{
Hyt.Model.InventorySheet.WhInventoryDetail model = Hyt.BLL.InventorySheet.WhInventoryBo.Instance.GetWhInventoryDetail((int)id);
BLL.InventorySheet.WhInventoryBo.Instance.ExportPurchaseData(model, "", 0);
}
