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