/// <summary> /// 验证文件夹是否重复 /// </summary> /// <param name="FolderName"></param> /// <returns></returns> public Model.Folder YanZhenFolderByName(string FolderName, int FatherFolderID, int UserId) { using (var db = new Model.ZKJSkyDriveEntities()) { return(db.Set <Model.Folder>().FirstOrDefault(x => x.Folder_Name == FolderName && x.FatherFolderID == FatherFolderID && x.FounderID == UserId)); } }
/// <summary> /// 根据文件夹名查询文件夹 /// </summary> /// <param name="FolderName"></param> /// <returns></returns> public Model.Folder GetFolder(string FolderName) { using (var db = new Model.ZKJSkyDriveEntities()) { return(db.Set <Model.Folder>().FirstOrDefault(x => x.Folder_Name == FolderName)); } }
/// <summary> /// 根据文件名查询文件 /// </summary> /// <param name="id"></param> /// <returns></returns> public Model.Store_data GetFile(string FileName, int id) { using (var db = new Model.ZKJSkyDriveEntities()) { return(db.Set <Model.Store_data>().FirstOrDefault(x => x.Real_FileName == FileName && x.User_ID == id)); } }
/// <summary> /// 用户登录 /// </summary> /// <param name="User"></param> /// <returns></returns> public Model.User Login(Model.User User) { using (var db = new Model.ZKJSkyDriveEntities()){ return(db.Set <Model.User>() .FirstOrDefault(x => x.User_Name == User.User_Name && x.User_Password == User.User_Password)); } }
/// <summary> /// 根据文件id查询文件 /// </summary> /// <param name="id"></param> /// <returns></returns> public Model.Store_data GetFile(int id) { using (var db = new Model.ZKJSkyDriveEntities()) { return(db.Set <Model.Store_data>().Find(id)); } }
/// <summary> /// 回收站文件 /// </summary> /// <param name="Uid"></param> /// <param name="SuffixName"></param> /// <returns></returns> public List <Model.Store_data> recovery(int Uid) { using (var db = new Model.ZKJSkyDriveEntities()) { return(db.Set <Model.Store_data>().Where(x => x.DeleteState == 1 && x.User_ID == Uid).ToList()); } }
/// <summary> /// 查询其他文件 /// </summary> /// <param name="Uid"></param> /// <param name="SuffixName"></param> /// <returns></returns> public List <Model.Store_data> GetStore_dataBySuffixName(int Uid) { using (var db = new Model.ZKJSkyDriveEntities()) { return(db.Set <Model.Store_data>().Where(x => x.SuffixName == "weizhi.png" && x.User_ID == Uid).ToList()); } }
/// <summary> /// 根据用户id查询用户信息 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public Model.User GetUserByID(int UserID) { using (Model.ZKJSkyDriveEntities db = new Model.ZKJSkyDriveEntities()) { return(db.Set <Model.User>().Find(UserID)); } }
public int GetNewFolderId(int UserId) { using (var db = new Model.ZKJSkyDriveEntities()) { return(db.Set <Model.Folder>().Where(x => x.FounderID == UserId).Max(x => x.Folder_ID)); } }
/// <summary> /// 根据文件id查询文件夹 /// </summary> /// <param name="FolderName"></param> /// <returns></returns> public Model.Folder GetFolderByID(int FolderID, int UserId) { using (var db = new Model.ZKJSkyDriveEntities()) { return(db.Set <Model.Folder>().FirstOrDefault(x => x.Folder_ID == FolderID && x.FounderID == UserId && x.DeleteState == 0)); } }
/// <summary> /// 彻底删除 /// </summary> /// <param name="FileID"></param> /// <returns></returns> public int DeleteFile(int FileID) { using (var db = new Model.ZKJSkyDriveEntities()) { Model.Store_data store = db.Set <Model.Store_data>().Find(FileID); db.Entry <Model.Store_data>(store).State = System.Data.Entity.EntityState.Deleted; return(db.SaveChanges()); } }
/// <summary> /// 根据父ID查询文件夹 /// </summary> /// <param name="Folder"></param> /// <returns></returns> public List <Model.Folder> GetFolderByID(int FolderID) { var db = new Model.ZKJSkyDriveEntities(); return(db.Set <Model.Folder>() .Where(x => x.FatherFolderID == FolderID && x.DeleteState == 0) .OrderByDescending(x => x.EstablishTime) .ToList()); }
/// <summary> /// 修改密码 /// </summary> /// <param name="NewPwd"></param> /// <param name="user"></param> /// <returns></returns> public int UpdatePwd(string NewPwd, Model.User user) { using (var db = new Model.ZKJSkyDriveEntities()) { Model.User odduser = db.Set <Model.User>().FirstOrDefault(x => x.User_Name == user.User_Name && x.User_Password == user.User_Password); odduser.User_Password = NewPwd; db.Entry <Model.User>(odduser).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); } }
/// <summary> /// 查询用户所有文件 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public List <Model.Store_data> GetAll(int UserID) { using (var db = new Model.ZKJSkyDriveEntities()) { return(db.Set <Model.Store_data>() .Where(x => x.User_ID == UserID && x.Folder_ID == 0 && x.DeleteState == 0) .OrderByDescending(x => x.EstablishTime) .ToList()); } }
/// <summary> /// 查询用户所有文件夹 /// </summary> /// <param name="UserId"></param> /// <returns></returns> public List <Model.Folder> GetFolderList(int UserId) { using (var db = new Model.ZKJSkyDriveEntities()) { return(db.Set <Model.Folder>() .Where(x => x.FounderID == UserId && x.FatherFolderID == 0 && x.DeleteState == 0) .OrderByDescending(x => x.EstablishTime) .ToList()); } }
/// <summary> /// 还原文件 /// </summary> /// <param name="FileID"></param> /// <returns></returns> public int UpdateFile2(int FileID) { using (var db = new Model.ZKJSkyDriveEntities()) { Model.Store_data store = db.Set <Model.Store_data>().Find(FileID); store.DeleteState = 0; store.EstablishTime = DateTime.Now; db.Entry <Model.Store_data>(store).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); } }
/// <summary> /// 根据后缀查询文件 /// </summary> /// <param name="Uid"></param> /// <param name="SuffixName"></param> /// <returns></returns> public List <Model.Store_data> GetStore_dataBySuffixName(int Uid, string SuffixName) { using (var db = new Model.ZKJSkyDriveEntities()){ return(db.Set <Model.Store_data>().Where(x => x.SuffixName == SuffixName && x.User_ID == Uid && x.DeleteState == 0).ToList()); } }