/// <summary>
/// 更新附件信息
/// </summary>
/// <param name="rm">附件id</param>
/// <param name="db"></param>
private void updateAppendix(AppendixModel am, JSZX_ResourceEntities db)
{
T_Res_Appendix app = db.T_Res_Appendix.FirstOrDefault(t => t.ID == am.Id);
app.AUTHOR = am.Author;
app.ACTIVE_TIME_START = am.GetStartTime();
app.ACTIVE_TIME_END = am.GetEndTime();
app.MODIFYID = am.ModifyId;
app.MODIFYTIME = DateTime.Now;
app.IS_FOREVER = am.getIsForever();
}
/**获取最新版本信息和之前版本号**/
public T_Res_Appendix GetVersionContrast(JSZX_ResourceEntities db, string Aid, ref List <VersionModel> VersionList)
{
try
{
T_Res_Appendix model = db.T_Res_Appendix.First(t => t.ID == Aid);
GetVersion(db, Aid, ref VersionList);
return(model);
}
catch (Exception ex)
{
clsLog.ErrorLog("Resource", "GetVersionContrast", "Error! " + ex.Message);
return(null);
}
}
/// <summary>
/// 根据id获取附件信息
/// </summary>
/// <param name="id">附件id</param>
/// <param name="db"></param>
/// <returns></returns>
public T_Res_Appendix GetAppendixInfoById(string id, JSZX_ResourceEntities db)
{
T_Res_Appendix app = null;
var query = from t in db.T_Res_Appendix where t.ID == id select t;
List <T_Res_Appendix> list = query.ToList();
if (list != null && list.Count > 0)
{
app = list[0];
}
return(app);
}
/// <summary>
/// 删除附件信息
/// </summary>
/// <param name="rm">附件id</param>
/// <param name="db"></param>
private void DeleteAppendix(AppendixModel am, JSZX_ResourceEntities db)
{
T_Res_Appendix app = db.T_Res_Appendix.FirstOrDefault(t => t.ID == am.Id);
app.DEL_FLG = "1";
app.MODIFYID = am.ModifyId;
app.MODIFYTIME = DateTime.Now;
//删除评价信息
var query = from t in db.T_Res_Score where t.APPEND_ID == am.Id select t;
List <T_Res_Score> scoList = query.ToList();
if (scoList != null)
{
foreach (T_Res_Score item in scoList)
{
db.T_Res_Score.Remove(item);
db.SaveChanges();
}
}
//删除问题信息
var query2 = from t in db.T_Res_Qa where t.APPEND_ID == am.Id select t;
List <T_Res_Qa> qaList = query2.ToList();
if (qaList != null)
{
foreach (T_Res_Qa item in qaList)
{
db.T_Res_Qa.Remove(item);
db.SaveChanges();
}
}
//删除评价结果表
var query3 = from t in db.T_Res_Result where t.APPEND_ID == am.Id select t;
List <T_Res_Result> resList = query3.ToList();
if (resList != null)
{
foreach (T_Res_Result item in resList)
{
db.T_Res_Result.Remove(item);
db.SaveChanges();
}
}
}
public string GetFileOriginalName(string fileName)
{
try
{
string fID = Path.GetFileNameWithoutExtension(fileName);
using (JSZX_ResourceEntities db = new JSZX_ResourceEntities())
{
T_Res_Appendix model = db.T_Res_Appendix.First(t => t.ID.Equals(fID));
fileName = model.FILE_NAME;
}
}
catch (Exception e)
{
clsLog.ErrorLog("Resource", "GetFileOriginalName", "Error! " + e.Message);
}
return(fileName);
}
/// <summary>
/// 插入附件信息
/// </summary>
/// <param name="rm">附件id</param>
/// <param name="db"></param>
private void insertAppendix(AppendixModel am, JSZX_ResourceEntities db)
{
T_Res_Appendix tra = new T_Res_Appendix();
tra.ID = am.Id;
tra.RES_ID = am.Res_Id;
tra.FILE_NAME = am.FileName;
tra.UPLOAD_TIME = am.GetUploadTime();
tra.AUTHOR = am.Author;
tra.ACTIVE_TIME_START = am.GetStartTime();
tra.ACTIVE_TIME_END = am.GetEndTime();
tra.IS_FOREVER = am.getIsForever();
tra.CREATEID = am.CreateId;
tra.CREATETIME = DateTime.Now;
tra.DEL_FLG = "0";
tra.FILE_URL = am.FileUrl;
tra.TYPE_FLG = am.TypeFlg;
db.T_Res_Appendix.Add(tra);
T_ToChange change = new T_ToChange();
change.ID = Guid.NewGuid().ToString();
change.FileName = am.Id;
change.SourceFilePath = am.FileUrl;
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='" + am.Id + "'";
change.RetSql = sql;
change.TaskTime = DateTime.Now;
db.T_ToChange.Add(change);
}
/// <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);
}
}
/// <summary>
/// 保存附件信息
/// </summary>
/// <param name="rm">附件信息</param>
/// <param name="db"></param>
private void doAppendix(ResourceModel rm, JSZX_ResourceEntities db)
{
string[] fileNames = rm.FileName;
string[] saveNames = rm.SaveName;
string[] authors = rm.Author;
string[] activeStart = rm.ActiveTimeStart;
string[] activeEnd = rm.ActiveTimeEnd;
string[] uploadTime = rm.UploadTime;
string[] fileType = rm.FileType;
string[] fileUrl = rm.FileUrl;
string[] dataType = rm.DataType;
string[] isForever = rm.isForever;
if (fileNames != null)
{
for (int i = 0; i < fileNames.Length; i++)
{
string saveName = saveNames[i];
string ext = "";
string id = saveName;
if (fileNames[i] != null && fileNames[i].LastIndexOf('.') > 0)
{
id = saveName.Substring(0, saveName.LastIndexOf('.'));
ext = fileNames[i].Substring(fileNames[i].LastIndexOf('.'), fileNames[i].Length - fileNames[i].LastIndexOf('.')).ToLower();
}
AppendixModel am = null;
if (dataType[i] == "add")
{
am = new AppendixModel();
am.Id = id;
am.Res_Id = rm.Id;
am.FileName = fileNames[i];
am.SaveName = saveName;
am.Ext = ext;
am.Author = authors[i];
am.SetUploadTime(uploadTime[i]);
am.SetStartTime(activeStart[i]);
am.SetEndTime(activeEnd[i]);
am.FileUrl = fileUrl[i];
am.TypeFlg = fileType[i];
am.CreateId = rm.UserId;
am.setIsForever(isForever[i]);
insertAppendix(am, db);
}
else if (dataType[i] == "update")
{
am = new AppendixModel();
am.Id = id;
am.Author = authors[i];
am.SetStartTime(activeStart[i]);
am.SetEndTime(activeEnd[i]);
am.ModifyId = rm.UserId;
am.setIsForever(isForever[i]);
updateAppendix(am, db);
}
else if (dataType[i] == "delete")
{
am = new AppendixModel();
am.Id = id;
am.ModifyId = rm.UserId;
DeleteAppendix(am, db);
}
/**更新资源附件 2014-12-19 5920 **/
else //前台更新了附件 此时的dataType是旧的附件ID
{
string OldFileID = dataType[i];
/**逻辑删除旧的附件**/
T_Res_Appendix app = db.T_Res_Appendix.FirstOrDefault(t => t.ID == OldFileID);
app.DEL_FLG = "1";
app.MODIFYID = rm.UserId;
app.MODIFYTIME = DateTime.Now;
/**添加新的附件**/
am = new AppendixModel();
am.Id = id;
am.Res_Id = rm.Id;
am.FileName = fileNames[i];
am.SaveName = saveName;
am.Ext = ext;
am.SetUploadTime(uploadTime[i]);
am.Author = authors[i];
am.SetStartTime(activeStart[i]);
am.SetEndTime(activeEnd[i]);
am.FileUrl = fileUrl[i];
am.TypeFlg = fileType[i];
am.CreateId = rm.UserId;
am.setIsForever(isForever[i]);
insertAppendix(am, db);
/**记录下版本更新**/
T_Version model = new T_Version();
model.ID = Guid.NewGuid().ToString();
model.NID = id;
model.OID = OldFileID;
model.VERSION_NUM = GetVersionNum(db, OldFileID); //这边需要算出之前的所有版本
model.USERID = rm.UserId;
model.CreateTime = DateTime.Now;
db.T_Version.Add(model);
}
}
}
}
