public bool PushPandianReport(int monthNum, string pandianFolder)
{
var lst = Instance.PandianStatisticServerOptSet.ToList();
foreach (var item in lst)
{
System.Threading.ThreadPool.QueueUserWorkItem(o =>
{
var dt = item.PushMonthReport(monthNum, DateTime.Now.Year);
if (dt != null && dt.Rows.Count > 0)
{
var filename = System.IO.Path.Combine(pandianFolder, "pandian", $"ERP-{item.ServerName}-{monthNum}月份盘点订单{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx");
NPOIExcel.Export(dt, filename);
if (Environment.UserInteractive)
{
Console.WriteLine($"ERP-{item.ServerName}-{monthNum}月份盘点订单生成成功。文件名:{filename}");
}
}
});
}
//按渠道生成对账单
var prolst = Instance.ProductStatisticServerOptSet.ToList();
foreach (var pro in prolst)
{
System.Threading.ThreadPool.QueueUserWorkItem(o =>
{
var dt = pro.PushMonthReport(monthNum, DateTime.Now.Year);
if (dt != null && dt.Rows.Count > 0)
{
var filename = System.IO.Path.Combine(pandianFolder, "pandian", $"ERP-{pro.ServerName}-{monthNum}月份盘点订单{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx");
NPOIExcel.Export(dt, filename);
if (Environment.UserInteractive)
{
Console.WriteLine($"ERP-{pro.ServerName}-{monthNum}月份盘点订单生成成功。文件名:{filename}");
}
}
});
}
return(true);
}
