public IResponseResult GetBuyOrderDetail(Guid buyOrderId)
{
var result = new UserBuyOrderBiz().GetBuyOrderDetail(UserModel, buyOrderId, out var msg);
if (result == null)
{
return(ReturnResult(false, msg));
}
return(ReturnResult(result));
}
/// <summary>
/// 导出备货单
/// </summary>
/// <param name=""></param>
/// <param name="userModel"></param>
/// <param name="saleOrderId"></param>
/// <param name="msg"></param>
/// <param name="bt"></param>
/// <param name="saleOrder"></param>
/// <returns></returns>
public bool ExportStocking(UserModel userModel, Guid saleOrderId, out string msg, out byte[] bt, out BuyOrder saleOrder)
{
bt = null;
var order = Da.Get <BuyOrder>(saleOrderId);
saleOrder = order;
var b1 = CheckAuthOrder(userModel, order, out msg);
if (!b1)
{
return(false);
}
var path = $"{Config.Root}/static/files/ExportStockIn.xlsx";
if (!File.Exists(path))
{
msg = "配置错误";
return(false);
}
//产品
var orderProducts = new UserBuyOrderBiz().GetBuyOrderDetailProduct(userModel, saleOrderId);
var products = orderProducts.data;
//统计
var count = new UserBuyOrderBiz().GetBuyOrderDetailCount(userModel, order);
bt = ExcelHelper.Export(path, wb =>
{
var sheet = wb.GetSheetAt(0);
//
sheet.GetRow(0).Cells[1].SetCellValue(order.BuyOrderNumber);
sheet.GetRow(0).Cells[4].SetCellValue(order.UserNickName);
//sheet.GetRow(1).Cells[1].SetCellValue(Convert.ToDateTime(order.ShipDate).ToString("yyyy/MM/dd"));
sheet.GetRow(1).Cells[4].SetCellValue(order.DefaultShip);
sheet.GetRow(2).Cells[1].SetCellValue(order.DefaultRemark);
//
for (var i = 0; i < products.Count - 1; i++)
{
sheet.CopyRowSample(i + 10, i + 11);
}
var rs = products.Count;
var index = 0;
foreach (var item in products)
{
var rows = sheet.GetRow(index + 10);
rows.Cells[0].SetCellValue(item.ProductSku);
rows.Cells[1].SetCellValue(item.CategoryName);
rows.Cells[2].SetCellValue(item.ProductName);
rows.Cells[3].SetCellValue(item.ProductSpecification);
rows.Cells[4].SetCellValue(item.ProductRemark);
rows.Cells[5].SetCellValue(item.Qty);
rows.Cells[6].SetCellValue(item.AreaPosition);
rows.Cells[7].SetCellValue(item.Remark);
index++;
}
//数量总计
sheet.GetRow(11 + rs).Cells[5].SetCellFormula($"SUM(H11:H{rs + 10})");
sheet.GetRow(11 + rs).Cells[5].SetCellValue(Convert.ToDouble(count.ProductQtys));
});
msg = null;
return(true);
}
