|
using iWareCommon.Utils;
|
using OfficeOpenXml;
|
using OfficeOpenXml.Drawing;
|
using System;
|
using System.Collections.Generic;
|
using System.Drawing;
|
using System.IO;
|
using System.Linq;
|
using System.Text;
|
using System.Threading;
|
using System.Threading.Tasks;
|
|
namespace autuPrint.printService
|
{
|
public class creatExcelPrint
|
{
|
//1.cd C:\Windows\Microsoft.NET\Framework\v4.0.30319
|
//2.InstallUtil.exe D:\wms\checkDebug\Debug\siemensSapService.exe 找到自己的服务地址
|
//启动服务 net start IWareCC
|
//停止服务 net stop IWareCC
|
//卸载服务 sc delete IWareCC
|
/// <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(Image img, labelEntity label, string baCode)
|
{
|
if (single.WaitOne())//增加线程锁防止双击并发
|
{
|
|
try
|
{
|
#region 验证模板文件是否存在
|
if (!File.Exists(@"C:\autoPrint\标签模板.xlsx"))
|
{
|
Log4NetHelper.WriteErrorLog(LogType.Print, "类名: creatExcelPrint 方法名: creatEXcel 模板缺失", null);
|
return false;
|
|
}
|
if (img == null)
|
{
|
Log4NetHelper.WriteErrorLog(LogType.Print, "类名: creatExcelPrint 方法名: creatEXcel 标签条形码为空", null);
|
return false;
|
}
|
if (label == null)
|
{
|
Log4NetHelper.WriteErrorLog(LogType.Print, "类名: creatExcelPrint 方法名: creatEXcel 标签参数为空", null);
|
return false;
|
}
|
#endregion
|
//获取模板文件
|
FileInfo copyFile = new FileInfo(@"C:\autoPrint\标签模板.xlsx");
|
copyFile.CopyTo(@"D:\临时.xlsx", true);
|
FileInfo existingFile = new FileInfo(@"D:\临时.xlsx");
|
using (ExcelPackage package = new ExcelPackage(existingFile))
|
{
|
//获取模板内容
|
ExcelWorksheet worksheet = package.Workbook.Worksheets["Sheet1"];
|
worksheet.Cells[2, 3].Value = baCode;//条形号码
|
worksheet.Cells[3, 2].Value = label.purchaseOrder;//采购单号
|
worksheet.Cells[3, 4].Value = label.purchaseOrderItem;//采购项号
|
worksheet.Cells[4, 2].Value = label.materailCode;//物料单号
|
worksheet.Cells[4, 4].Value = label.trackNumber;//跟踪号
|
worksheet.Cells[5, 2].Value = label.materarilName;//物料名称
|
worksheet.Cells[6, 2].Value = label.quantity;//数量
|
worksheet.Cells[6, 4].Value = label.Unit;//库存单位
|
worksheet.Cells[7, 2].Value = label.saleCode;//销售单号
|
worksheet.Cells[7, 4].Value = label.saleCodeItem;//销售项号
|
worksheet.Cells[8, 2].Value = label.receivDate;//收货日期
|
worksheet.Cells[8, 4].Value = label.expireDate;//到期日期
|
worksheet.Cells[9, 2].Value = label.supplierName;//供应商名称
|
ExcelPicture pic = worksheet.Drawings.AddPicture("barCode", img);//插入图片
|
pic.SetSize(180, 35);//设置图片尺寸
|
pic.SetPosition(0, 5, 2, 5);//设置图片位置,以单元格为单位(参数1,3行和列,2,4是偏移量)
|
package.Save();//保存
|
}
|
}
|
catch (Exception ex)
|
{
|
Log4NetHelper.WriteErrorLog(LogType.Print, "类名: creatExcelPrint 方法名: creatEXcel 生成打印文件出错 \r\n " + ex.ToString(), ex);
|
return false;
|
}
|
finally { single.ReleaseMutex(); }//一轮结束
|
}
|
return true;
|
}
|
}
|
}
|
