//using iWareCC.Common;
//using iWareCommon.Utils;
//using iWareSql.MyDbContext;
//using OfficeOpenXml;
//using OfficeOpenXml.Drawing;
//using System;
//using System.Collections.Generic;
//using System.IO;
//using System.Threading;

//namespace autuPrint.printService
//{
//    public class CreatExcelForMail
//    {
//        /// <summary>
//        /// //线程锁防止并发
//        /// </summary>
//        private static Mutex single = new Mutex();
//        /// <summary>
//        /// 生成打印数据源
//        /// </summary>
//        /// <param name="img">条形码</param>
//        ///   <param name="label">标签参数</param>
//        /// <returns>成功返回true</returns>
//        public static bool creatEXcel(List<v_ware_stock_early_warming> dataList, ref string realFilePath, ref string errMsg)
//        {
//            if (single.WaitOne())//增加线程锁防止双击并发
//            {

//                try
//                {
//                    //获取模板文件
//                    realFilePath = SystemValueUtil.TEMPORARY_MAILWARNING_DIR + @"\库存预警信息(" + DateTime.Now.ToString("yyyy-MM-dd") + ").xlsx";
//                    FileInfo copyFile = new FileInfo(SystemValueUtil.TEMPORARY_MAILWARNING_FILEPATH);
//                    copyFile.CopyTo(realFilePath, true);
//                    FileInfo existingFile = new FileInfo(realFilePath);
//                    using (ExcelPackage package = new ExcelPackage(existingFile))
//                    {
//                        //获取模板内容
//                        ExcelWorksheet worksheet = package.Workbook.Worksheets["Sheet1"];
//                        //行,列
//                        //注意：行和列都是从1开始，而不是从0开始！！！

//                        for (int i = 0; i < (dataList.Count); i++)
//                        {
//                            worksheet.Cells[i + 2, 1].Value = dataList[i].Code;//物料编号
//                            worksheet.Cells[i + 2, 2].Value = dataList[i].Name;//物料名称
//                            worksheet.Cells[i + 2, 3].Value = dataList[i].Quantity;//库存数量
//                            worksheet.Cells[i + 2, 4].Value = dataList[i].Miniquantity;//最小库存预警值
//                            worksheet.Cells[i + 2, 5].Value = dataList[i].Maxquantity;//最大库存预警值
//                        }


//                        package.Save();//保存
//                    }
//                }
//                catch (Exception ex)
//                {
//                    Log4NetHelper.WriteErrorLog(LogType.SrmTheadService, "类名: creatExcelPrint 方法名: creatEXcel 生成打印文件出错 \r\n  " + ex.ToString(), ex);
//                    //logtxt.txtWrite("类名: creatExcelPrint 方法名: creatEXcel 生成打印文件出错 \r\n  " + ex.ToString(), 2);
//                    errMsg = ex.Message;
//                    return false;
//                }
//                finally { single.ReleaseMutex(); }//一轮结束
//            }
//            return true;
//        }


//    }
//}