public async Task <IActionResult> PutTblFiles([FromRoute] int?id, [FromBody] TblFiles tblFiles)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblFiles.Id)
{
return(BadRequest());
}
_context.Entry(tblFiles).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblFilesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public DefaultModel()
{
Files = new List <TblFiles>();
PageInfo = new Page();
UpFile = new TblFiles();
ActionMessage = "";
ActionCode = 0;
}
public async Task <Guid> AddFile(DBFile file)
{
if (file.Id == Guid.Empty)
{
file.Id = Guid.NewGuid();
}
await TblFiles.Insert(file, false).ExecuteAsync().ConfigureAwait(false);
return(file.Id);
}
public async Task <IActionResult> PostTblFiles([FromBody] TblFiles tblFiles)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.TblFiles.Add(tblFiles);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTblFiles", new { id = tblFiles.Id }, tblFiles));
}
private static int StoreFolder(string directoryName, int pageRef)
{
var f = new TblFiles
{
Name = Path.GetFileName(directoryName),
IsDirectory = true,
PageRef = pageRef,
};
ServerModel.DB.Insert(f);
return f.ID;
}
private static void StoreFile(int pid, FileSystemInfo file, int pageRef)
{
var f = new TblFiles
{
Name = file.Name,
IsDirectory = false,
PageRef = pageRef,
File = File.ReadAllBytes(file.FullName),
PID = pid
};
ServerModel.DB.Insert(f);
}
private static int StoreFolder(string directoryName, int pageRef)
{
var f = new TblFiles
{
Name = Path.GetFileName(directoryName),
IsDirectory = true,
PageRef = pageRef,
};
ServerModel.DB.Insert(f);
return(f.ID);
}
private static void StoreFile(int pid, FileSystemInfo file, int pageRef)
{
var f = new TblFiles
{
Name = file.Name,
IsDirectory = false,
PageRef = pageRef,
File = File.ReadAllBytes(file.FullName),
PID = pid
};
ServerModel.DB.Insert(f);
}
private static TblFiles StoreFile(XmlNode node, int pageRef, string filePath)
{
var reader = new StreamReader(filePath);
byte[] file = Encoding.Unicode.GetBytes(reader.ReadToEnd());
var f = new TblFiles
{
PageRef = pageRef,
File = file,
Name = node.Attributes["href"].Value,
IsDirectory = false,
};
ServerModel.DB.Insert(f);
return f;
}
private static TblFiles StoreFile(XmlNode node, int pageRef, string filePath)
{
var reader = new StreamReader(filePath);
byte[] file = Encoding.Unicode.GetBytes(reader.ReadToEnd());
var f = new TblFiles
{
PageRef = pageRef,
File = file,
Name = node.Attributes["href"].Value,
IsDirectory = false,
};
ServerModel.DB.Insert(f);
return(f);
}
public ActionResult AddFiles(DefaultModel model, HttpPostedFileBase[] uploadFile)
{
try
{
//处理文件上传
if (uploadFile != null)
{
foreach (HttpPostedFileBase uf in uploadFile)
{
TblFiles tf = new TblFiles();
tf.Description = model.UpFile.Description;
//原始文件名称
string filename = uf.FileName;
if (filename.IndexOf("\\") > -1)
{
filename = filename.Substring(filename.LastIndexOf("\\") + 1);
}
tf.Filename = filename;
//通过guid产生不重复的文件名
tf.Filepath = Guid.NewGuid().ToString();
//获取文件类型和文件大小
tf.ContentType = uf.ContentType;
tf.Size = uf.ContentLength;
//设置保存文件名
string saveName = Server.MapPath(
WebMvc.MvcApplication.UploadPath +
tf.Filepath);
//保存文件
uf.SaveAs(saveName);
//保存信息到数据库
TblFilesDAO.Add(tf);
}
}
model.ActionCode = 200;
}
catch (Exception ex)
{
model.ActionCode = 500;
model.ActionMessage = ex.Message;
}
return(View("ToUpFiles", model));
}
private static int SearchForResources(XmlNode node, int pageRef, string courseTempPath)
{
XmlNode resource = XmlUtility.GetNode(node, "//ns:resource[@identifier='" + node.Attributes["identifierref"].Value + "']");
string filePath = resource.Attributes["href"].Value;
int fileID = 0;
foreach (XmlNode childNode in resource.ChildNodes)
{
if (XmlUtility.IsFile(childNode))
{
TblFiles file = StoreFile(childNode, pageRef, Path.Combine(courseTempPath, childNode.Attributes["href"].Value));
if (filePath == file.Name)
{
fileID = file.ID;
}
}
}
return(fileID);
}
public void BinaryDataOperationsTest()
{
using (var c = new DataObjectCleaner())
{
var fileContent = new byte[] { 13, 13, 13, 13 };
var file = new TblFiles
{
File = new Binary(fileContent),
};
c.Insert(file);
var id1 = file.ID;
var loadedFile = ServerModel.DB.Load<TblFiles>(id1);
Assert.AreEqual(loadedFile.File.ToArray(), fileContent);
loadedFile.File = null;
ServerModel.DB.Update(loadedFile);
loadedFile = ServerModel.DB.Load<TblFiles>(id1);
Assert.IsNull(loadedFile.File);
}
}
public void BinaryDataOperationsTest()
{
using (var c = new DataObjectCleaner())
{
var fileContent = new byte[] { 13, 13, 13, 13 };
var file = new TblFiles
{
File = new Binary(fileContent),
};
c.Insert(file);
var id1 = file.ID;
var loadedFile = ServerModel.DB.Load <TblFiles>(id1);
Assert.AreEqual(loadedFile.File.ToArray(), fileContent);
loadedFile.File = null;
ServerModel.DB.Update(loadedFile);
loadedFile = ServerModel.DB.Load <TblFiles>(id1);
Assert.IsNull(loadedFile.File);
}
}
public async Task <IEnumerable <DBFile> > GetFiles(Guid backup)
{
return(await TblFiles.Where(f => f.Backup == backup).ExecuteAsync().ConfigureAwait(false));
}
public async Task <DBFile> GetFile(Guid file)
{
return(await TblFiles.Where(f => f.Id == file).FirstOrDefault().ExecuteAsync().ConfigureAwait(false));
}
public static TblFiles QueryById(TblFiles file)
{
return(DBHelper.QueryOneRow(file, @"select * from TblFiles where fid=@p0", file.Fid));
}
public static int Add(TblFiles file)
{
return(DBHelper.Update(
@"insert into TblFiles(filepath,filename,contentType,size,description) values(@p0,@p1,@p2,@p3,@p4)"
, file.Filepath, file.Filename, file.ContentType, file.Size, file.Description));
}
public async Task <long> BackupSize(Guid backupId)
{
var files = await TblFiles.Where(f => f.Backup == backupId).Select(f => f.Length).ExecuteAsync().ConfigureAwait(false);
return(files.Sum());
}
