/// <summary>
/// SaveExcelRecord
/// </summary>
/// <returns></returns>
public int SaveExcelRecord(ExcelRecordModel model)
{
return(CurrentConnectStringContext.StoredProcedure("Excelrecord_Save")
.Parameter("v_ExcelRecordId", model.ExcelRecordId)
.Parameter("v_ExcelName", model.ExcelName)
.Parameter("v_CreateDateTime", model.CreateDateTime)
.Parameter("v_ExcelUrl", model.ExcelUrl)
.Parameter("v_StatusFlag", model.StatusFlag)
.QuerySingle <int>());
}
/// <summary>
/// 保存上传记录
/// </summary>
/// <param name="excel"></param>
/// <param name="excelName"></param>
/// <returns></returns>
public int SaveExcel(Workbook excel, string excelName)
{
var directory = HttpContext.Current.Request.PhysicalApplicationPath;
var relativePath = string.Concat("\\Files\\FinancialExcel\\", excelName, "_", Guid.NewGuid(), ".xlsx");
var filePath = string.Concat(directory, relativePath);
var directoryPath = Path.GetDirectoryName(filePath);
if (!Directory.Exists(directoryPath))
{
Directory.CreateDirectory(directoryPath);
}
excel.Save(filePath, SaveFormat.Xlsx);
var excelRecordModel = new ExcelRecordModel()
{
ExcelName = excelName,
ExcelUrl = relativePath,
CreateDateTime = DateTime.Now,
StatusFlag = 1
};
var excelId = _financialDataBll.SaveExcelRecord(excelRecordModel);
return(excelId);
}
/// <summary>
/// SaveExcelRecord
/// </summary>
/// <returns></returns>
public int SaveExcelRecord(ExcelRecordModel model)
{
return(_financialDataDal.SaveExcelRecord(model));
}
