/// <summary> /// 更新一个记录 /// </summary> /// <param name="P_Entity"></param> /// <returns></returns> public async Task <int> UpdateAsync(PlanFileEntity PEntity) { if (PEntity == null) { return(0); } PEntity.UpDateTime = DateTime.Now; _GhDbContext.dsPlanFiles.Update(PEntity); return(await _GhDbContext.SaveChangesAsync().ConfigureAwait(false)); }
/// <summary> /// 向数据库表添加一个新的记录,如果该记录已经存在,返回-2。 /// </summary> /// <param name="P_Entity"></param> /// <returns></returns> public async Task <int> AddAsync(PlanFileEntity PEntity, string FileId) { if (PEntity == null || PEntity.Id != null) { return(-2); } PEntity.Id = FileId; PEntity.UpDateTime = DateTime.Now; _GhDbContext.dsPlanFiles.Add(PEntity); return(await _GhDbContext.SaveChangesAsync().ConfigureAwait(false)); }
public async Task <string> PutAsync([FromBody] PlanFileEntity PEntity) { ExcuteResult actResult = new ExcuteResult(); if (await _FileRepository.UpdateAsync(PEntity).ConfigureAwait(false) > 0) { actResult.SetValues(p_state: 0, p_msg: "文件信息更新成功", p_tag: PEntity?.Id); } else { actResult.SetValues(1, "文件信息更新失败!"); } return(JsonConvert.SerializeObject(actResult)); }
public async Task <string> PostUpLoadFileAsync([FromForm] PlanFileEntity PFile) { ExcuteResult actResult = new ExcuteResult(); if (Request.Form.Files.Count > 0 && PFile != null) { try { string FileId = AppCodes.AppStaticClass.GetIdOfDateTime(); if (!System.IO.Directory.Exists(_FileBaseDir)) { System.IO.Directory.CreateDirectory(_FileBaseDir); } string FileName = Path.Combine(_FileBaseDir, $"{FileId}{PFile.ExtendName}");// _configuration["StaticFileDir"] + $"\\WorkFiles\\{pfile.Id}{pfile.ExtendName}"; using (FileStream fs = System.IO.File.Create(FileName)) { await Request.Form.Files[0].CopyToAsync(fs).ConfigureAwait(false); fs.Flush(); } if (System.IO.File.Exists(FileName)) { //文件写入成功后,再保存文件信息到数据表 PFile.UpDateTime = DateTime.Now; if (await _FileRepository.AddAsync(PFile, FileId).ConfigureAwait(false) > 0) { actResult.SetValues(0, "上传成功", p_tag: FileId); } else { actResult.SetValues(-3, "文件保存到服务器数据库时出错。"); } } else { actResult.SetValues(-1, "文件保存到服务器磁盘时出错。"); } } catch (System.Exception err) { actResult.SetValues(1, err.Message); } } return(JsonConvert.SerializeObject(actResult)); }
/// <summary> /// 删除一个记录 /// </summary> /// <param name="Id"></param> /// <returns></returns> public async Task <int> DeleteByIdAsync(string FileBaseDir, string Id) { int DelCount = 0; if (Id == null) { return(0); } PlanFileEntity CurFile = _GhDbContext.dsPlanFiles.Find(Id); _GhDbContext.dsPlanFiles.Remove(CurFile); DelCount = await _GhDbContext.SaveChangesAsync().ConfigureAwait(false); if (DelCount > 0) { //删除硬盘上的文件 var fileName = Path.Combine(FileBaseDir, $"{CurFile.Id}{CurFile.ExtendName}"); if (System.IO.File.Exists(fileName)) { System.IO.File.Delete(fileName); } } return(DelCount); }
/// <summary> /// 根据Id获取一个对象 /// </summary> /// <param name="P_Id"></param> /// <returns></returns> public async Task <PlanFileDto> GetOneByIdAsync(string Id) { PlanFileEntity RecordEntity = await _GhDbContext.dsPlanFiles.FindAsync(Id).ConfigureAwait(false); return(_Mapper.Map <PlanFileDto>(RecordEntity)); }