/// <summary>
/// 删除资源
/// </summary>
/// <param name="id">资源ID</param>
/// <param name="db"></param>
/// <returns></returns>
public bool deleteResource(string id, string userId, JSZX_ResourceEntities db)
{
try
{
T_Resource tr = db.T_Resource.First(t => t.ID == id);
tr.DEL_FLG = "1";
tr.MODIFYID = userId;
tr.MODIFYTIME = DateTime.Now;
List <T_Res_Appendix> list = db.T_Res_Appendix.Where(t => t.RES_ID == id).ToList();
if (list != null)
{
foreach (T_Res_Appendix item in list)
{
item.DEL_FLG = "1";
item.MODIFYID = userId;
item.MODIFYTIME = DateTime.Now;
}
}
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
clsLog.ErrorLog("Resource", "deleteResource", ex.Message);
return(false);
}
}
/// <summary>
/// 更新资源信息
/// </summary>
/// <param name="rm">资源信息</param>
/// <param name="db"></param>
/// <returns></returns>
public bool updateResource(ResourceModel rm, JSZX_ResourceEntities db)
{
try
{
T_Resource tr = db.T_Resource.First(t => t.ID == rm.Id);
tr.NAME = rm.Name;
tr.TYPE_ID = rm.TypeId;
tr.INTRODUCTION = rm.Introduction;
tr.STATUS = "0";
tr.LABEL = rm.Label;
tr.NOTE = rm.Note;
tr.MODIFYID = rm.UserId;
tr.MODIFYTIME = DateTime.Now;
doAppendix(rm, db);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
clsLog.ErrorLog("Resource", "updateResource", ex.Message);
return(false);
}
}
/// <summary>
/// 批量删除资源
/// </summary>
/// <param name="rm">资源ID</param>
/// <param name="db"></param>
/// <returns></returns>
public bool deleteResource2(ResourceModel rm, JSZX_ResourceEntities db)
{
string[] ids = rm.Ids;
string[] isSelect = rm.isSelect;
string userId = rm.UserId;
try
{
if (ids != null)
{
for (int i = 0; i < ids.Length; i++)
{
if (isSelect[i] == "1")
{
string id = ids[i];
T_Resource tr = db.T_Resource.First(t => t.ID == id);
tr.DEL_FLG = "1";
tr.MODIFYID = userId;
tr.MODIFYTIME = DateTime.Now;
List <T_Res_Appendix> list = db.T_Res_Appendix.Where(t => t.RES_ID == id).ToList();
if (list != null)
{
foreach (T_Res_Appendix item in list)
{
item.DEL_FLG = "1";
item.MODIFYID = userId;
item.MODIFYTIME = DateTime.Now;
}
}
}
}
}
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
clsLog.ErrorLog("Resource", "deleteResource2", ex.Message);
return(false);
}
}
/// <summary>
/// 保存资源信息
/// </summary>
/// <param name="rm">资源信息</param>
/// <param name="db"></param>
/// <returns></returns>
public bool insertResource(ResourceModel rm, JSZX_ResourceEntities db)
{
try
{
T_Resource tr = new T_Resource();
tr.ID = rm.Id;
tr.NAME = rm.Name;
tr.TYPE_ID = rm.TypeId;
tr.INTRODUCTION = rm.Introduction;
tr.LABEL = rm.Label;
tr.NOTE = rm.Note;
tr.STATUS = "0";
tr.DEL_FLG = "0";
tr.ORIGIN_FLG = "1";
tr.SHARE_FLG = "1";
tr.EXCELLENT_FLG = "0";
tr.CREATEID = rm.UserId;
tr.CREATETIME = DateTime.Now;
tr.MODIFYID = rm.UserId;
tr.MODIFYTIME = DateTime.Now;
db.T_Resource.Add(tr);
doAppendix(rm, db);
db.SaveChanges();
//上传资源时，可以获得积分
PointRule pr = new PointRule();
pr.AddPoint(tr.ID, tr.MODIFYID, "0");
//上传资源时，可以获得积分
return(true);
}
catch (Exception ex)
{
clsLog.ErrorLog("Resource", "insertResource", ex.Message);
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="rm"></param>
/// <param name="db"></param>
/// <returns></returns>
public bool examineResource(ResourceModel rm, JSZX_ResourceEntities db)
{
try
{
T_Resource tr = db.T_Resource.First(t => t.ID == rm.Id);
tr.TYPE_ID = rm.TypeId;
tr.INTRODUCTION = rm.Introduction;
tr.LABEL = rm.Label;
tr.STATUS = rm.Status;
tr.EXCELLENT_FLG = rm.Excellent_Flg;
tr.MODIFYID = rm.UserId;
tr.MODIFYTIME = DateTime.Now;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
clsLog.ErrorLog("Resource", "examineResource", ex.Message);
return(false);
}
}
/// <summary>
/// 批量审核资源
/// </summary>
/// <param name="rm"></param>
/// <param name="db"></param>
/// <returns></returns>
public bool examineResource2(ResourceModel rm, JSZX_ResourceEntities db)
{
string[] ids = rm.Ids;
string[] isSelect = rm.isSelect;
string status = rm.Status;
string excellentFlg = rm.Excellent_Flg;
string userId = rm.UserId;
try
{
if (ids != null)
{
for (int i = 0; i < ids.Length; i++)
{
if (isSelect[i] == "1")
{
string id = ids[i];
T_Resource tr = db.T_Resource.First(t => t.ID == id);
tr.STATUS = status;
tr.EXCELLENT_FLG = excellentFlg;
tr.MODIFYID = userId;
tr.MODIFYTIME = DateTime.Now;
}
}
}
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
clsLog.ErrorLog("Resource", "examineResource2", ex.Message);
return(false);
}
}
/// <summary>
/// 大文件上传数据保存
/// </summary>
/// <param name="model"></param>
/// <param name="db"></param>
/// <returns></returns>
public Boolean JavaUploadSaveData(JavaUploadModel model, JSZX_ResourceEntities db)
{
try
{
#region 资源
T_Resource rModel = new T_Resource();
rModel.ID = model.ID;
rModel.NAME = model.Name;
rModel.TYPE_ID = model.TypeID;
rModel.INTRODUCTION = model.Introduction;
rModel.LABEL = model.Label;
rModel.NOTE = model.Note;
rModel.STATUS = "0";
rModel.DEL_FLG = "0";
rModel.ORIGIN_FLG = "1";
rModel.SHARE_FLG = "1";
rModel.EXCELLENT_FLG = "0";
rModel.CREATEID = model.CreateID;
rModel.CREATETIME = DateTime.Now;
db.T_Resource.Add(rModel);
#endregion
#region 附件
if (model.FileUrl != null && model.FileUrl.Length > 0)
{
#region 循环插入附件
for (int i = 0; i < model.FileUrl.Length; i++)
{
string path = model.FileUrl[i];
string fileType = Constant.GetFileType(System.IO.Path.GetExtension(path));
string fileID = System.IO.Path.GetFileNameWithoutExtension(path);
T_Res_Appendix aModel = new T_Res_Appendix();
aModel.ID = fileID;
aModel.RES_ID = model.ID;
aModel.FILE_NAME = model.FileName[i];
aModel.UPLOAD_TIME = DateTime.Now;
aModel.AUTHOR = model.Author;
aModel.ACTIVE_TIME_START = StringToDateTime(model.ActiveTimeStart);
aModel.ACTIVE_TIME_END = StringToDateTime(model.ActiveTimeEnd);
aModel.CREATEID = model.CreateID;
aModel.CREATETIME = DateTime.Now;
aModel.DEL_FLG = "0";
aModel.FILE_URL = path;
aModel.TYPE_FLG = fileType;
aModel.IS_FOREVER = model.isForever == "1" ? true : false;
db.T_Res_Appendix.Add(aModel);
#region 转换任务
T_ToChange change = new T_ToChange();
change.ID = Guid.NewGuid().ToString();
change.FileName = fileID;
change.SourceFilePath = path;
change.TargetFilePath = Constant.DISK_ADDRESS + Constant.UPLOADDIRECTORY + "\\" + Constant.SWFDIRECTORY;
string sql = "update JSZX_Resource.dbo.T_Res_Appendix set READ_URL=@TargetFilePath,[IMAGE]=@FileFirstImg,[PAGECOUNT]=@PageCount where ID='" + fileID + "'";
change.RetSql = sql;
change.TaskTime = DateTime.Now;
db.T_ToChange.Add(change);
#endregion
}
#endregion
db.SaveChanges();
return(true);
}
else
{
clsLog.ErrorLog("Resource", "ShareResource", "Error! 缺少必要的附件！");
return(false);
}
#endregion
}
catch (Exception ex)
{
clsLog.ErrorLog("Resource", "JavaUploadSaveData", "Error! " + ex.Message);
return(false);
}
}