/// <summary>
/// 移除资源
/// </summary>
/// <param name="ResourceIDs"></param>
/// <param name="UserID"></param>
/// <returns></returns>
public bool RemoveResourceByResourceIDs(string ResourceIDs, string UserID)
{
using (var db = new fz_resourceEntities())
{
if (ResourceIDs.IndexOf(',') > -1)
{
string[] resourceArray = ResourceIDs.Split(',');
foreach (string resid in resourceArray)
{
r_resource resource = db.r_resource.Where(w => w.ResourceID == resid && w.ResourceCreaterID == UserID).FirstOrDefault();
//////////用户自己上传的////////////
if (resource != null)
{
if (resource.ShareStauts != 2)
{
db.r_resource_approve.RemoveRange(db.r_resource_approve.Where(w => w.ResourceID == resid));
db.r_resource.Remove(db.r_resource.Find(resid));
db.r_files.Remove(db.r_files.Find(resource.FileID));
}
else
{
resource.ResourceCreaterID = "shared";
}
}
/////////////用户收藏的资源////////////
else
{
r_resource_favorite resfavor = db.r_resource_favorite.Where(w => w.UId == UserID && w.ResourceID == resid).FirstOrDefault();
db.r_resource_favorite.Remove(resfavor);
}
}
}
else
{
r_resource resource = db.r_resource.Where(w => w.ResourceID == ResourceIDs && w.ResourceCreaterID == UserID).FirstOrDefault();
if (resource != null)
{
if (resource.ShareStauts != 2)
{
string fileID = resource.FileID;
db.r_resource_approve.RemoveRange(db.r_resource_approve.Where(w => w.ResourceID == ResourceIDs));
db.r_resource.Remove(db.r_resource.Find(ResourceIDs));
db.r_files.Remove(db.r_files.Find(fileID));
}
else
{
resource.ResourceCreaterID = "shared";
}
}
/////////////用户收藏的资源////////////
else
{
r_resource_favorite resfavor = db.r_resource_favorite.Where(w => w.UId == UserID && w.ResourceID == ResourceIDs).FirstOrDefault();
db.r_resource_favorite.Remove(resfavor);
}
}
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 智慧教室上传文件
/// </summary>
/// <param name="Filedata">文件数据</param>
/// <returns></returns>
public bool UploadFileFromClassRoom(string Filedata)
{
using (var db = new fz_resourceEntities())
{
List <R_FileResource> fileresList = JsonHelper.JosnDeserializer <R_FileResource>(Filedata);
foreach (R_FileResource fr in fileresList)
{
r_files file = db.r_files.Find(fr.FileID);
if (file == null)
{
file = new r_files();
file.Id = fr.FileID;
file.FileName = fr.FileName;
file.FilePath = fr.FilePath;
file.FileSize = Convert.ToInt32(fr.FileSize);
file.FileDescription = fr.FileDescription;
file.FileExtension = fr.FileExtension;
file.FileType = fr.FileType;
file.UploadTime = DateTime.Now;
db.r_files.Add(file);
}
r_resource resource = db.r_resource.Where(w => w.FileID == file.Id).FirstOrDefault();
if (resource == null)
{
resource = new r_resource();
resource.ResourceID = System.Guid.NewGuid().ToString();
resource.SubjectID = fr.SubjectID;
resource.FileID = file.Id;
resource.GradeID = fr.GradeID;
resource.EditionID = fr.EditionID;
resource.Catalog = fr.Catalog;
resource.ResourceName = fr.FileName;
resource.ResourceSize = fr.FileSize;
resource.Description = fr.FileDescription;
resource.ResourceStyle = fr.ResourceStyle;
resource.FileType = file.FileExtension;
resource.ShareStauts = 0;
resource.Copyright = 4;
resource.ResourceCreaterID = fr.UserID;
resource.ResourceCreaterName = fr.UserName;
resource.ResourceCreateDate = DateTime.Now;
}
else
{
resource.ResourceStyle = fr.ResourceStyle;
}
db.r_resource.Add(resource);
}
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 导入mod资源
/// </summary>
/// <param name="files"></param>
/// <param name="resources"></param>
/// <returns></returns>
public string ImportModResource(string files, string resources)
{
try
{
List <R_ResourceExport_File> filelist = JsonHelper.JosnDeserializer <R_ResourceExport_File>(files);
List <R_ResourceExport_Resource> resourcelist = JsonHelper.JosnDeserializer <R_ResourceExport_Resource>(resources);
using (var dbcontext = new fz_resourceEntities())
{
/////////////先增加文件信息//////////////
foreach (R_ResourceExport_File file in filelist)
{
r_files tempfile = dbcontext.r_files.Find(file.ID);
if (tempfile == null)
{
dbcontext.r_files.Add(new r_files {
Id = file.ID,
FileName = file.FileName,
ConvertStatus = file.ConvertStatus == null ? 0 : (int)file.ConvertStatus,
EncryptStatus = file.EncryptStatus == null ? 0 : (int)file.EncryptStatus,
FileDescription = file.FileDescription,
FileExtension = file.FileExtension,
FilePath = file.FilePath,
FileSize = file.FileSize == null ? 0 : (int)file.FileSize,
FileType = file.FileType == null ? 0 : (int)file.FileType,
FinishStatus = (bool)file.FinishStatus,
Height = file.Height == null ? 0 : (int)file.Height,
UploadTime = file.UploadTime,
Width = file.Width == null ? 0 : (int)file.Width
});
}
}
////////////后增加资源信息//////////////////
foreach (R_ResourceExport_Resource resource in resourcelist)
{
r_resource tempresource = dbcontext.r_resource.Find(resource.ID);
if (tempresource == null)
{
dbcontext.r_resource.Add(new r_resource {
ResourceID = resource.ID,
Applicable = resource.Applicable,
AppraisedCounts = resource.AppraisedCounts,
BookReelID = resource.BookReel,
BreviaryImgUrl = resource.BreviaryImgUrl,
Catalog = resource.Catalog,
CollectCounts = resource.CollectCounts,
ComeFrom = resource.ComeFrom,
Copyright = resource.Copyrigh,
CopyrightName = resource.CopyrighName,
Description = resource.Description,
EditionID = resource.Edition,
FileID = resource.FileID,
FileType = resource.FileType,
GradeID = resource.Grade,
IsDelete = resource.IsDelete,
IsRecommend = resource.IsRecommend,
IsVerify = resource.IsVerify,
KeyWords = resource.KeyWords,
MaterialID = resource.MaterialID == null ? null : resource.MaterialID,
ModifyDate = resource.ModifyDate,
Number = resource.Number,
Purview = resource.Purview,
Sort = (int)resource.Sort,
SubjectID = resource.Subject,
ResourceClass = resource.ResourceClass,
ResourceLevel = resource.ResourceLevel,
ResourceName = resource.Title,
ResourceScanNum = resource.ScanCounts,
ResourceSize = resource.ResourceSize,
ResourceStyle = resource.ResourceStyle,
ResourceType = resource.ResourceType,
SchoolStage = resource.SchoolStage,
TeachingModules = resource.TeachingModules,
TeachingStep = resource.TeachingStep,
TeachingStyle = resource.TeachingStyle,
TimeSpan = resource.TimeSpan,
ResourceDowLoadNum = resource.DownCounts,
ResourceCreateDate = System.DateTime.Now,
ResourceCollectNum = 0,
ResourceCreaterID = "",
ResourceCreaterName = "方直",
ShareStauts = null
});
}
}
try {
dbcontext.SaveChanges();
return("ok");
} catch (Exception ex) {
return(ex.Message);
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
