/// <summary>
/// 获取MD5名称EF
/// </summary>
/// <param name="name">名字</param>
/// <returns>MD5名称</returns>
public static string GetMd5Name(string name)
{
using (mainEntities db = new mainEntities())
{
Filedate filedate = db.Filedate.Where(u => u.Name == name).FirstOrDefault();
return(filedate.MD5Name);
}
}
/// <summary>
/// 移动文件EF
/// </summary>
/// <param name="name">文件名</param>
/// <param name="relativePath">相对路径</param>
/// <returns>成功OR失败</returns>
public static bool MoveFile(string name, string fullPath)
{
using (mainEntities db = new mainEntities())
{
Floder floder = db.Floder.Where(u => u.FullPath == fullPath).FirstOrDefault();
Filedate filedate = db.Filedate.Where(u => u.Name == name).FirstOrDefault();
filedate.FatherFolder = floder.ID;
filedate.FullPath = floder.FullPath + @"\" + filedate.MD5Name;
filedate.RelativePath = floder.RelativePath + @"\" + filedate.MD5Name;
return(db.SaveChanges() > 0 ? true : false);
}
}
/// <summary>
/// 获取完整路径EF
/// </summary>
/// <param name="name">文件夹名称</param>
/// <returns>文件夹路径</returns>
public static string GetFullPath(string name)
{
using (mainEntities db = new mainEntities())
{
Floder floder = db.Floder.Where(u => u.Name == name).FirstOrDefault();
Filedate filedate = db.Filedate.Where(u => u.Name == name).FirstOrDefault();
if (filedate != null)
{
return(filedate.FullPath);
}
return(floder.FullPath);
}
}
/// <summary>
/// 重命名文件夹EF
/// </summary>
/// <param name="name">旧文件名</param>
/// <param name="newname">新文件名</param>
/// <returns>成功OR失败</returns>
public static bool NewNameFloderOrFile(string name, string newname)
{
using (mainEntities db = new mainEntities())
{
Floder floder = db.Floder.Where(u => u.FullPath == name).FirstOrDefault();
if (floder != null)
{
floder.Name = newname;
}
Filedate filedate = db.Filedate.Where(u => u.FullPath == name).FirstOrDefault();
if (filedate != null)
{
filedate.Name = newname;
}
return(db.SaveChanges() > 0 ? true : false);
}
}
/// <summary>
/// 得到相对路径
/// </summary>
/// <param name="name">名称</param>
/// <returns>路径</returns>
public static string GetRelativePath(string name)
{
using (mainEntities db = new mainEntities())
{
Filedate filedate = db.Filedate.Where(u => u.Name == name).FirstOrDefault();
if (filedate != null)
{
return(filedate.RelativePath);
}
Floder flode = db.Floder.Where(u => u.Name == name).FirstOrDefault();
if (flode != null)
{
Floder flod = db.Floder.Where(u => u.ID == flode.ID).FirstOrDefault();
return(flod.RelativePath);
}
return(null);
}
}
/// <summary>
/// 更新用户上传记录
/// </summary>
/// <returns></returns>
public JsonResult AddUploadRecord()
{
using (mainEntities db = new mainEntities())
{
Filedate filedate = new Filedate()
{
Name = Request["name"].ToString(),
MD5Name = Request["md5"].ToString(),
Size = Convert.ToInt32(Request["size"].ToString()),
Type = Request["type"].ToString(),
FatherFolder = 1,
RelativePath = @"NetworkDisk\" + Request["md5"].ToString(),
FullPath = AppDomain.CurrentDomain.BaseDirectory + @"NetworkDisk\" + Request["md5"].ToString(),
Date = DateTime.Now.ToString()
};
db.Filedate.Add(filedate);
return(Json(db.SaveChanges() > 0 ? true : false));
}
}
/// <summary>
/// 获得ID
/// </summary>
/// <returns>ID</returns>
public static long GetID(string name)
{
using (mainEntities db = new mainEntities())
{
Filedate filedate = db.Filedate.Where(u => u.Name == name).FirstOrDefault();
if (filedate != null)
{
Floder floder = db.Floder.Where(u => u.ID == filedate.FatherFolder).FirstOrDefault();
return(floder.ID);
}
Floder flode = db.Floder.Where(u => u.Name == name).FirstOrDefault();
if (flode != null)
{
Floder flod = db.Floder.Where(u => u.ID == flode.ID).FirstOrDefault();
return(flod.ID);
}
return(0);
}
}
/// <summary>
/// 上传文件EF
/// </summary>
/// <param name="name">文件名称</param>
/// <param name="MD5">MD5</param>
/// <param name="type">文件类型</param>
/// <param name="size">文件大小</param>
/// <param name="relativePath">文件相对路径</param>
/// <returns>成功OR失败</returns>
public static bool FileUpLoad(string name, string MD5, string type, double size)
{
using (mainEntities db = new mainEntities())
{
Filedate filedate = new Filedate()
{
Name = name,
MD5Name = MD5,
Type = type,
FatherFolder = 0,
Size = size,
FullPath = AppDomain.CurrentDomain.BaseDirectory + @"NetworkDisk\" + name,
RelativePath = @"NetworkDisk\" + name,
Date = DateTime.Now.ToString()
};
db.Filedate.Add(filedate);
return(db.SaveChanges() > 0 ? true : false);
}
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <param name="MD5"></param>
/// <param name="type"></param>
/// <param name="size"></param>
/// <param name="fatherFolder"></param>
/// <returns></returns>
public static bool UpdateFile(string name, string MD5, string type, double size, string fatherFolder)
{
using (mainEntities db = new mainEntities())
{
var folder = db.Floder.Where(u => u.FullPath == fatherFolder).FirstOrDefault();
Filedate filedate = new Filedate()
{
Name = name,
MD5Name = MD5,
Type = type,
FatherFolder = folder.ID,
Size = size,
FullPath = fatherFolder + @"\" + MD5,
RelativePath = folder.RelativePath + @"\" + MD5,
Date = DateTime.Now.ToString()
};
db.Filedate.Add(filedate);
return(db.SaveChanges() > 0 ? true : false);
}
}
