/// <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)); }