/// <summary>
/// 添加文件导出记录
/// </summary>
/// <param name="args"></param>
/// <returns></returns>
public byte Create(OT_ExportHis args)
{
byte num;
using (DataSubmittedEntities db = new DataSubmittedEntities())
{
using (TransactionScope transaction = new TransactionScope())
{
db.OT_ExportHis.Add(args);
num = (byte)db.SaveChanges();
transaction.Complete();
}
}
return num;
}
/// <summary>
/// 添加报表存储记录
/// </summary>
/// <param name="args"></param>
/// <returns></returns>
public byte Create(OT_ExportHis args)
{
throw new NotImplementedException();
}
/// <summary>
/// 保存文件
/// </summary>
/// <param name="hssfworkbook"></param>
/// <param name="filename"></param>
/// <returns>返回文件保存路径</returns>
private string SaveFile(IWorkbook hssfworkbook, string filename, QueryParameters para)
{
try
{
string pPath = config;
if (pPath.Substring(pPath.Length - 1) != "\\")
pPath = pPath + "\\";
var tmpPath = pPath + DateTime.Now.ToString("yyyyMMdd") + "\\" + para.ReportType;
//创建存储目录
if (!Directory.Exists(tmpPath))
{
Directory.CreateDirectory(tmpPath);
}
//创建文件
string path = tmpPath + "\\" + filename;
FileStream files = new FileStream(path, FileMode.Create);
hssfworkbook.Write(files);
files.Close();
//添加数据导出记录
ContactInfo pContactinfo = new ContactInfo();
OT_ExportHis contactinfo = new OT_ExportHis();
contactinfo.Id = Guid.NewGuid();
contactinfo.DataDate = para.StartTime;
contactinfo.HDayId = para.HolidayId;
contactinfo.CalcuTime = DateTime.Now;
contactinfo.SavePath = path;
contactinfo.TableType = para.ReportType;
pContactinfo.Create(contactinfo);
return filename;
}
catch (Exception e)
{
SystemLog.GetInstance().Error(e);
}
return null;
}