/// <summary>
/// 修改卷宗信息
/// </summary>
/// <param name="archiveId"></param>
/// <param name="addArchiveName"></param>
/// <param name="addArchiveType"></param>
/// <param name="addCreatePerson"></param>
/// <param name="addReportPerson"></param>
/// <param name="addArchiveDescription"></param>
/// <param name="addAlarmId"></param>
/// <param name="addAssociatedInfo"></param>
/// <param name="addArchiveStatus"></param>
/// <param name="addArchiveLog"></param>
/// <returns></returns>
public JsonResult UpdateDossierData(int archiveId, string archiveNum, string addArchiveName, int addArchiveType, int addCreatePerson, string addReportPerson, string addArchiveDescription, string addAlarmId, string addAssociatedInfo, int addArchiveStatus, string addArchiveLog)
{
try
{
//向卷宗表中添加数据
ServArchiveInfoModel servArchiveInfoModel = new ServArchiveInfoModel();
servArchiveInfoModel.archive_name = addArchiveName;
servArchiveInfoModel.id = archiveId;
servArchiveInfoModel.archive_num = archiveNum;
servArchiveInfoModel.archive_status = addArchiveStatus;
servArchiveInfoModel.report_person = addReportPerson;
servArchiveInfoModel.report_type = addArchiveType;
servArchiveInfoModel.archive_decription = addArchiveDescription;
servArchiveInfoModel.create_persson_id = addCreatePerson;
servArchiveInfoModel.create_time = DateTime.Now;
servArchiveInfoModel.update_time = DateTime.Now;
servArchiveInfoModel.alarm_id = addAlarmId;
//向文件表中添加数据
List <ServFileInfoModel> Node = JsonConvert.DeserializeObject <List <ServFileInfoModel> >(addAssociatedInfo);
//根据卷宗id 获取关联文件信息
List <ServFileInfoModel> FileInfoList = servArchiveInfoBLL.GetFileinfo(archiveId);
var picture = ".bmp,.jpg,.jpeg,.tiff,.gif,.pcx,.tga,.exif,.fpx,.svg,.psd,.cdr,.pcd,.dxf,.ufo,.eps,.ai,.raw,.WMF"; //图片格式
var video = ".avi,.rmvb,.rm,.asf,.divx,.mpg,.mpeg,.mpe,.wmv,.mkv,.mp4,.vob,.dat,.vcd,.svcd,.mov,.qt,.mpfg,.flv,.3gp,.xvid,.ts"; //视频格式
var excel = ".xlsx,.xls,.xlsm,.xlsb,xltx,.xltm,.xlt,.xlam,.xla"; //excel格式
List <ServFileInfoModel> ServFileInfoList = new List <ServFileInfoModel>();
var address = "";
for (int i = 0; i < Node.Count; i++)
{
ServFileInfoModel FileInfo = new ServFileInfoModel();
FileInfo.file_name = Node[i].file_name;
if (picture.IndexOf(Node[i].file_ext_name) > -1)
{
FileInfo.file_type = (int)EnumClass.FileType.图片;
}
else if (video.IndexOf(Node[i].file_ext_name) > -1)
{
FileInfo.file_type = (int)EnumClass.FileType.视频;
}
else if (excel.IndexOf(Node[i].file_ext_name) > -1)
{
FileInfo.file_type = (int)EnumClass.FileType.Excel;
}
else
{
FileInfo.file_type = (int)EnumClass.FileType.文件;
}
FileInfo file = new FileInfo(Server.MapPath(Node[i].file_address));
string timeInfo = DateTime.Now.ToString("yyyyMMdd");
string localPath = "/upload/dossier/" + timeInfo + "/";
string newFilePath = Server.MapPath(localPath + file.Name);
string localPaths = Server.MapPath(localPath);
if (!System.IO.Directory.Exists(localPaths))
{
System.IO.Directory.CreateDirectory(localPaths);
}
if (file.Exists)
{
file.MoveTo(newFilePath); //移动单个文件
FileInfo.file_address = localPath + file.Name;
}
else
{
return(Json(new { status = 1, msg = "未找到上传的文件" }, JsonRequestBehavior.AllowGet));
}
FileInfo.file_ext_name = Node[i].file_ext_name;
FileInfo.content = Node[i].content;
FileInfo.create_time = Node[i].create_time;
address += FileInfo.file_address + ",";
ServFileInfoList.Add(FileInfo);
}
//向日志表里添加信息
ServArhiveUpdateLogModel servArhiveUpdateLog = new ServArhiveUpdateLogModel();
servArhiveUpdateLog.archive_id = archiveId;
servArhiveUpdateLog.archive_log_content = addArchiveLog;
servArhiveUpdateLog.log_create_time = DateTime.Now;
bool ISResult = servArchiveInfoBLL.UpdateservArchiveInfo(servArchiveInfoModel, ServFileInfoList, servArhiveUpdateLog);
if (ISResult == true)
{
for (var d = 0; d < FileInfoList.Count; d++)
{
if (address.IndexOf(FileInfoList[d].file_address) < 0)
{
FileInfo file = new FileInfo(Server.MapPath(FileInfoList[d].file_address));
if (file.Exists)
{
file.Delete(); //删除单个文件
}
}
}
}
return(Json(new { status = 0, msg = ISResult }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { status = 1, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 修改卷宗
/// </summary>
/// <param name="servArchiveInfoModel"></param>
/// <param name="ServFileInfoList"></param>
/// <param name="servArhiveUpdateLog"></param>
/// <returns></returns>
public bool UpdateservArchiveInfo(ServArchiveInfoModel servArchiveInfoModel, List <ServFileInfoModel> ServFileInfoList, ServArhiveUpdateLogModel servArhiveUpdateLog)
{
mapContext.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted);//创建事务
try
{
bool result = false;
//向卷宗信息表中添加信息
int regId = (int)mapContext.Update("UpdateArchiveInfo", servArchiveInfoModel);
if (regId > 0)
{
result = true;
List <ServArchiveFileModel> servArchiveFileModel = mapContext.QueryForList <ServArchiveFileModel>("GetArchiveFileByRegId", servArchiveInfoModel.id).ToList();
for (var i = 0; i < servArchiveFileModel.Count(); i++)
{
int fileId = (int)mapContext.Delete("DeleteFileInfoById", servArchiveFileModel[i].relate_id);
if (fileId > -1)
{
result = true;
}
else
{
mapContext.RollBackTransaction();
result = false;
break;
}
}
if (result == true)
{
int Id = (int)mapContext.Delete("DeleteArchiveFileInfoById", servArchiveInfoModel.id);
if (Id > -1)
{
//向文件表中添加数据
for (var i = 0; i < ServFileInfoList.Count(); i++)
{
int fileId = (int)mapContext.Insert("InsertFileInfo", ServFileInfoList[i]);
if (fileId > 0)
{
//向关联表中添加信息
ServArchiveFileModel archiveFile = new ServArchiveFileModel();
archiveFile.archive_id = servArchiveInfoModel.id;
archiveFile.relate_id = fileId;
archiveFile.type = ServFileInfoList[i].file_type;
int relationId = (int)mapContext.Insert("InsertArchiveFile", archiveFile);
if (relationId > 0)
{
result = true;
}
else
{
result = false;
break;
}
}
}
}
if (result == true)
{
//向日志表里添加信息
int fileId = (int)mapContext.Insert("InsertArhiveUpdateLog", servArhiveUpdateLog);
if (fileId > 0)
{
result = true;
}
else
{
result = false;
}
}
else
{
result = false;
}
}
}
else
{
mapContext.RollBackTransaction();
result = false;
}
if (result == true)
{
mapContext.CommitTransaction();//提交事务
return(result);
}
else
{
mapContext.RollBackTransaction();//事务回滚
return(result);
}
}
catch (Exception ex)
{
mapContext.RollBackTransaction();
throw ex;
}
finally
{
//mapContext.CommitTransaction();
}
}
public bool UpdateEntity(int id, ServArhiveUpdateLogModel newentity)
{
throw new NotImplementedException();
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
public int UpdateArhiveUpdateLogById(ServArhiveUpdateLogModel model)
{
int result = mapContext.Update("UpdateArhiveUpdateLog", model);
return(result);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="entity"></param>
public int AddEntity(ServArhiveUpdateLogModel entity)
{
int id = (int)mapContext.Insert("InsertArhiveUpdateLog", entity);
return(id);
}
/// <summary>
/// 修改卷宗
/// </summary>
/// <param name="servArchiveInfoModel"></param>
/// <param name="ServFileInfoList"></param>
/// <param name="servArhiveUpdateLog"></param>
/// <returns></returns>
public bool UpdateservArchiveInfo(ServArchiveInfoModel servArchiveInfoModel, List <ServFileInfoModel> ServFileInfoList, ServArhiveUpdateLogModel servArhiveUpdateLog)
{
try
{
bool ISResult = servArchiveInfoDAL.UpdateservArchiveInfo(servArchiveInfoModel, ServFileInfoList, servArhiveUpdateLog);
return(ISResult);
}
catch (Exception ex)
{
throw ex;
}
}
