/// <summary>
/// Initializes new instances of dependencies that are used in this controller
/// </summary>
/// <param name="service">An instances of FileInfoService</param>
/// <param name="userService">An instances of UserService</param>
/// <param name="options">An instances of IOptions<AppSettingOption></param>
public FileInfoController(
FileInfoService service,
UserService userService
)
{
_service = service;
_userService = userService;
}
/// <summary>
///递归 获得此文件夹的所有子目录的ID（包括子子目录）
/// </summary>
/// <param name="lists">将ID放入此集合中</param>
/// <param name="fileId"></param>
public static void GetAllChildByFileId(IList <int> lists, int fileId)
{
IList <FileInfo> fileLists = FileInfoService.GetFileByParentId(fileId);
foreach (FileInfo file in fileLists)
{
lists.Add(file.FileId);
GetAllChildByFileId(lists, file.FileId);
}
}
public DownloadPresenter(FileInfoService fileInfoService,
DownloadService downloadService,
int pageStart,
int pageEnd,
int taskNumber)
{
this.pageStart = pageStart;
this.pageEnd = pageEnd;
this.taskNumber = taskNumber;
this.fileInfoService = fileInfoService;
this.downloadService = downloadService;
}
public JsonResult AjaxSaveFileInfo()
{
string dataString = Request.Form["Data"];
dataString = HttpUtility.UrlDecode(dataString);
FileInfo data = SerializeHelper.JsonDeserialize <FileInfo>(dataString);
var result = FileInfoService.InsertFileInfo(data);
return(new JsonResult()
{
Data = result
});
}
public static DownloadPresenter DownloadPresenter(string[] args)
{
var binder = new DownloadBinder(args);
var taskNuber = binder.GetTaskNumber();
var pageStart = binder.GetPageStart();
var pageEnd = binder.GetPageEnd();
var downloadDirectory = binder.GetDownloadDirectory();
var httpService = new HttpService();
var fileInfoService = new FileInfoService(httpService, downloadDirectory);
var downloadService = new DownloadService(httpService, downloadDirectory);
return(new DownloadPresenter(fileInfoService, downloadService, pageStart, pageEnd, taskNuber));
}
/// <summary>
/// 批量新增外包人员的体检信息
/// </summary>
/// <param name="keyValue"></param>
/// <param name="entity"></param>
/// <returns></returns>
public void SummitPhyInfo(string keyValue, PhyInfoEntity entity)
{
string[] ids = entity.ids.Split(',');
string strIds = string.Join(",", ids).Replace(",", "','");
string strUpdate = string.Empty;
if (!string.IsNullOrWhiteSpace(entity.PhysicalUnit))
{
strUpdate += string.Format(" PhysicalUnit='{0}',", entity.PhysicalUnit);
}
if (!string.IsNullOrWhiteSpace(entity.IsComtraindication))
{
strUpdate += string.Format(" IsComtraindication='{0}',", entity.IsComtraindication);
}
if (entity.PhysicalTime != null)
{
strUpdate += string.Format(" PhysicalTime=to_date('{0}','yyyy-MM-dd'),", entity.PhysicalTime.Value.ToString("yyyy-MM-dd"));
}
if (!string.IsNullOrWhiteSpace(entity.ComtraindicationName))
{
strUpdate += string.Format(" ComtraindicationName='{0}',", entity.ComtraindicationName);
}
var files = new FileInfoService().GetFiles(keyValue);
if (files.Rows.Count > 0)
{
for (int i = 0; i < ids.Length; i++)
{
var key = ids[i] + "01";
foreach (DataRow item in files.Rows)
{
FileInfoEntity itemFile = new FileInfoEntity();
itemFile.FileName = item["FileName"].ToString();
itemFile.FilePath = item["filepath"].ToString();
itemFile.FileSize = item["filesize"].ToString();
itemFile.RecId = key;
new FileInfoService().SaveForm("", itemFile);
}
}
}
if (!string.IsNullOrWhiteSpace(strUpdate))
{
strUpdate = strUpdate.Substring(0, strUpdate.Length - 1);
var sql = string.Format("update epg_aptitudeinvestigatepeople set {0} where id in('{1}')", strUpdate, strIds);
this.BaseRepository().ExecuteBySql(sql);
}
}
public FileInfoController CreateControllerInstance()
{
// initialize Repositories
var userRepo = new UserRepository(Context);
var fileInfoRepo = new FileInfoRepository(Context);
// initialize AppSettingOption
var options = Options.Create(GetOptions());
// initialize Services
var userService = new UserService(userRepo);
var fileInfoService = new FileInfoService(fileInfoRepo, options);
return(new FileInfoController(fileInfoService, userService));
}
private IFileInfoService getFileInfoService(string s3SignedURL, Mock <IFormFile> formFileMock,
ApplicationDbContext applicationDbContext)
{
var amazonS3Mock = new Mock <IAmazonS3>();
const string fileName = "test.png";
var streamMock = new Mock <SystemIO.Stream>();
var httpClientFactoryMock = new Mock <IHttpClientFactory>();
var mockHttpMessageHandler = new Mock <HttpMessageHandler>();
formFileMock.SetupGet <String>(formFile => formFile.FileName).Returns(fileName);
formFileMock.Setup(formFile => formFile.OpenReadStream()).Returns(streamMock.Object);
var fixture = new Fixture();
amazonS3Mock.Setup(amazonS3 =>
amazonS3.GetPreSignedURL(It.IsAny <GetPreSignedUrlRequest>())).Returns(s3SignedURL);
mockHttpMessageHandler.Protected()
.Setup <Task <HttpResponseMessage> >("SendAsync", ItExpr.IsAny <HttpRequestMessage>(), ItExpr.IsAny <CancellationToken>())
.ReturnsAsync(new HttpResponseMessage
{
StatusCode = HttpStatusCode.OK,
Content = new StringContent(fixture.Create <String>()),
});
httpClientFactoryMock.Setup(_ => _.CreateClient(It.IsAny <string>()))
.Returns(() => new HttpClient(mockHttpMessageHandler.Object)
{
BaseAddress = fixture.Create <Uri>()
});
FileInfoService fileInfoService = new FileInfoService(
applicationDbContext,
amazonS3Mock.Object,
httpClientFactoryMock.Object);
return(fileInfoService);
}
public RenameService(FileRenamer renamer, RequestResolver resolver, FileInfoService fileInfoService)
{
this.renamer = renamer;
this.resolver = resolver;
this.fileInfoService = fileInfoService;
}
/// <summary>
/// 修改文件目录
/// </summary>
/// <param name="file"></param>
/// <returns></returns>
public static int MoveFile(FileInfo file)
{
return(FileInfoService.UpdateParentId(file));
}
/// <summary>
/// 根据文件名查询
/// </summary>
/// <param name="file"></param>
/// <returns></returns>
public static IList <FileInfo> GetFileInfoByFileName(string fileName, string createUser, string beginTime, string endTime)
{
return(FileInfoService.GetFileInfoByFileName(fileName, createUser, beginTime, endTime));
}
/// <summary>
/// 修改文件 不修改文件路径
/// </summary>
/// <param name="file"></param>
/// <returns></returns>
public static int UpdateFile(FileInfo file)
{
return(FileInfoService.UpdateFile(file));
}
/// <summary>
/// 修改文件 包括修改文件路径
/// </summary>
/// <param name="file"></param>
/// <returns></returns>
public static int UpdateFileAndFilePath(FileInfo file)
{
return(FileInfoService.UpdateFileAndFilePath(file));
}
/// <summary>
/// 根据父ID查找所有文件夹对象
/// </summary>
/// <param name="parentId"></param>
/// <returns></returns>
public static IList <FileInfo> GetFolderByParentId(int parentId)
{
return(FileInfoService.GetFolderByParentId(parentId));
}
public static int AddFile(FileInfo file)
{
return(FileInfoService.AddFile(file));
}
/// <summary>
/// 前台文件管理中显示文件夹中包含的文件或附件需要
/// 根据FileInfo表中文件夹的ID返回本文件夹中所包含的文件夹(FileInfo表)或附件(Accessory表)的ID
/// </summary>
/// <param name="fileId"></param>
/// <returns>返回的数组中第一个值为文件夹(或附件)所在的表的表名,第二个值为主键ID</returns>
public static IList <string[]> GetFileIdAndAccessoryIdByFileId(int fileId)
{
return(FileInfoService.GetFileIdAndAccessoryIdByFileId(fileId));
}
/// <summary>
/// 根据主键查找对象
/// </summary>
/// <param name="fileId"></param>
/// <returns></returns>
public static FileInfo GetFileByFileId(int fileId)
{
return(FileInfoService.GetFileByFileId(fileId));
}
public SelectFilesService(OpenFileService openFileService, FileInfoService fileInfoService)
{
this.openFileService = openFileService;
this.fileInfoService = fileInfoService;
}
/// <summary>
/// 将对象放入回收站
/// </summary>
/// <param name="fileId"></param>
/// <returns></returns>
public static int update_IfDelete_ByFileId(int fileId)
{
return(FileInfoService.update_IfDelete_ByFileId(fileId));
}
public List <ReportEntity> Build(string reporttype)
{
IReportService service = new ReportService();
var setting = service.GetSetting(reporttype);
var start = DateTime.MinValue;
var end = DateTime.MinValue;
this.BuildPiror(setting, out start, out end);
var data = service.BuildAllReport(start, end, reporttype);
var filelist = new List <FileInfoEntity>();
var folder = ConfigurationManager.AppSettings["FilePath"];
foreach (var item in data)
{
if (item.TaskList != null)
{
var id = Guid.NewGuid();
var fileentity = new FileInfoEntity()
{
FileId = id.ToString(),
FileName = string.Format("{0}{1}{2}", item.ReportUser, item.ReportType, ".xlsx"),
FilePath = string.Format("~/Resource/Report/{0}.xlsx", id),
FileExtensions = ".xlsx",
FileType = "xlsx",
DeleteMark = 0,
EnabledMark = 1,
CreateDate = DateTime.Now,
CreateUserId = "system",
CreateUserName = "******",
ModifyDate = DateTime.Now,
ModifyUserId = "system",
ModifyUserName = "******",
RecId = item.ReportId.ToString()
};
var book = new Workbook();
var sheet = book.Worksheets[0];
sheet.Name = "任务清单";
sheet.Cells[0, 0].PutValue("序号");
sheet.Cells[0, 1].PutValue("工作时间");
sheet.Cells[0, 2].PutValue("工作任务");
sheet.Cells[0, 3].PutValue("作业人");
var style = sheet.Cells[0, 0].GetStyle();
style.ForegroundColor = System.Drawing.ColorTranslator.FromHtml("#C6EFCE");
style.Pattern = BackgroundType.Solid;
var range = sheet.Cells.CreateRange(0, 0, 1, 4);
range.ApplyStyle(style, new StyleFlag()
{
All = true
});
for (int i = 0; i < item.TaskList.Count; i++)
{
sheet.Cells[i + 1, 0].PutValue(i + 1);
sheet.Cells[i + 1, 1].PutValue(item.TaskList[i].TaskPrior);
sheet.Cells[i + 1, 2].PutValue(item.TaskList[i].TaskContent);
sheet.Cells[i + 1, 3].PutValue(item.TaskList[i].TaskPerson);
}
sheet.Cells.SetColumnWidthPixel(0, 100);
sheet.Cells.SetColumnWidthPixel(1, 200);
sheet.Cells.SetColumnWidthPixel(2, 600);
sheet.Cells.SetColumnWidthPixel(3, 300);
if (!Directory.Exists(Path.Combine(folder, "Report")))
{
Directory.CreateDirectory(Path.Combine(folder, "Report"));
}
book.Save(Path.Combine(folder, "Report", id.ToString() + ".xlsx"), SaveFormat.Xlsx);
filelist.Add(fileentity);
}
}
if (filelist.Count > 0)
{
var fileservice = new FileInfoService();
fileservice.SaveFiles(filelist);
}
return(data);
}
/// <summary>
/// 将被删除文件还原
/// </summary>
/// <param name="fileId"></param>
/// <returns></returns>
public static int revert_IfDelete_ByFileId(int fileId)
{
return(FileInfoService.revert_IfDelete_ByFileId(fileId));
}
/// <summary>
/// 获得所有放在回收站中的文件
/// </summary>
/// <returns></returns>
public static IList <FileInfo> GetAllDelFileInfo()
{
return(FileInfoService.GetAllDelFileInfo());
}
/// <summary>
/// 构造
/// </summary>
public UploadController(FileInfoService fileInfoService)
{
_fileInfoService = fileInfoService;
}
public UndoService(FileRenamer fileRenamer, FileInfoService fileInfoService)
{
this.fileRenamer = fileRenamer;
this.fileInfoService = fileInfoService;
}
public FileInfoController(FileInfoService service)
{
_service = service;
}
/// <summary>
/// 根据主键删除对象
/// </summary>
/// <param name="fileId"></param>
/// <returns></returns>
public static int DelFileById(int fileId)
{
return(FileInfoService.DelFileById(fileId));
}
