/// <summary>
/// 添加数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddFileInfo(ServFileInfoModel model)
{
try
{
int id = servFileInfoDAL.AddEntity(model);
return(id);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="entity"></param>
public int AddEntity(ServFileInfoModel entity)
{
try
{
int id = (int)mapContext.Insert("InsertFileInfo", entity);
return(id);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 根据id获取文件数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ServFileInfoModel GetServFileInfoByID(int id)
{
try
{
ServFileInfoModel fileInfo = servFileInfoDAL.GetEntity(id);
return(fileInfo);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 将报警记录转入卷宗
/// </summary>
/// <param name="alarmId"></param>
private void GotoArchive(int alarmId, int ssoId, ServAlarmRecordModel alarmRecord, int handleItemId, int itemType)
{
try
{
ServVideoInfoDAL videoDal = new ServVideoInfoDAL();
ServPlanRecordDAL planRecordDal = new ServPlanRecordDAL();
ServArchiveInfoBLL archiveInfoBll = new ServArchiveInfoBLL();
ServPlanItemResultDAL planItemResultDal = new ServPlanItemResultDAL();
List <ServVideoInfoModel> videoList = videoDal.GetVideoInfoByAlarmId(alarmId);//获取下载的视频
List <ServFileInfoModel> fileInfoList = new List <ServFileInfoModel>();
ServFileInfoModel fileInfo = null;
for (int i = 0; i < videoList.Count; i++)
{
fileInfo = new ServFileInfoModel();
fileInfo.content = "确警后转入";
fileInfo.create_time = DateTime.Now;
fileInfo.file_address = videoList[i].video_path;
fileInfo.file_ext_name = Path.GetExtension(videoList[i].video_path);
fileInfo.file_name = videoList[i].video_name;
fileInfo.file_type = (int)EnumClass.FileType.视频;
fileInfo.person_id = ssoId;
fileInfoList.Add(fileInfo);
}
bool bl = archiveInfoBll.AddservArchiveInfo(alarmRecord.alarm_name, 7, ssoId, alarmRecord.alarm_code, "", alarmRecord.id.ToString(), fileInfoList, (int)EnumClass.ArchiveStatus.新建);
//插入数据库
ServPlanRecordModel planRecord = planRecordDal.GetEntityByAlarmId(alarmId);
ServPlanItemResultModel result = new ServPlanItemResultModel();
result.confirm_type = (int)EnumClass.PlanHandleTime.确警后;
result.content = "";
result.execute_time = DateTime.Now;
result.handleitem_id = handleItemId;
result.item_result = bl == true ? (int)EnumClass.PlanItemResult.成功 : (int)EnumClass.PlanItemResult.失败;
result.item_type = itemType;
result.plan_record_id = planRecord == null ? -1 : planRecord.id;
planItemResultDal.AddEntity(result); //插入处置项处理记录
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取预案条例信息
/// </summary>
/// <param name="regId"></param>
/// <returns></returns>
public PlanRegulationModel GetPlanRegulations(int regId)
{
try
{
//获取预案条例信息
ServPlanRegulationModel entity = servPlanRegulationDAL.GetEntity(regId);
//获取关联文件
List <ServRegulationFileModel> RegulationFile = servRegulationFileDAL.GetRegulationFile(regId);
//获取文件信息
List <ServFileInfoModel> FileInfoList = new List <ServFileInfoModel>();
for (var i = 0; i < RegulationFile.Count; i++)
{
ServFileInfoModel fileInfo = servFileInfoDAL.GetEntity(RegulationFile[i].file_id);
FileInfoList.Add(fileInfo);
}
//获取文件信息
PlanRegulationModel model = new PlanRegulationModel();
model.id = entity.id;
model.keyword = entity.keyword;
model.person_id = entity.person_id;
model.reg_level = entity.reg_level;
model.reg_name = entity.reg_name;
model.reg_type = entity.reg_type;
var a = baseEventTypeDAL.GetEntity(entity.reg_type);
model.reg_typeName = a == null ? "未知" : a.event_name;
model.reg_levelName = Enum.GetName(typeof(EnumClass.PlanRegulation), entity.reg_level);
model.create_time = entity.create_time;
model.update_time = entity.update_time;
model.FileInfoList = FileInfoList;
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
public int UpdateFileInfoById(ServFileInfoModel model)
{
int result = mapContext.Update("UpdateFileInfo", model);
return(result);
}
public bool UpdateEntity(int id, ServFileInfoModel newentity)
{
throw new NotImplementedException();
}
/// <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="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>
/// <returns></returns>
public JsonResult InsetDossierData(string addArchiveName, int addArchiveType, int addCreatePerson, string addReportPerson, string addArchiveDescription, string addAlarmId, string addAssociatedInfo, int addArchiveStatus)
{
try
{
//向文件表中添加数据
List <ServFileInfoModel> Node = JsonConvert.DeserializeObject <List <ServFileInfoModel> >(addAssociatedInfo);
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>();
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;
ServFileInfoList.Add(FileInfo);
}
bool ISResult = servArchiveInfoBLL.AddservArchiveInfo(addArchiveName, addArchiveType, addCreatePerson, addReportPerson, addArchiveDescription, addAlarmId, ServFileInfoList, addArchiveStatus);
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="id"></param>
/// <returns></returns>
public ArchiveInfoList GetDossierInfo(int id)
{
try
{
//根据id 获取卷宗信息
ServArchiveInfoModel ArchiveInfo = servArchiveInfoDAL.GetEntity(id);
List <AlarmRecordModel> AlarmRecorInfoList = new List <AlarmRecordModel>();
//获取报警信息
if (ArchiveInfo != null)
{
ServAlarmRecordModel AlarmRecorInfo = new ServAlarmRecordModel();
if (!string.IsNullOrEmpty(ArchiveInfo.alarm_id))
{
string[] alarmArray = ArchiveInfo.alarm_id.Split(',');
for (int i = 0; i < alarmArray.Length; i++)
{
AlarmRecordModel AlarmRecordModel = new AlarmRecordModel();
AlarmRecorInfo = servAlarmRecordDAL.GetEntity(Convert.ToInt32(alarmArray[i]));
AlarmRecordModel.id = AlarmRecorInfo.id;
// var e= baseEventTypeDAL.GetEntity(AlarmRecorInfo.alarm_event);
if (AlarmRecorInfo.alarm_event != "" && !string.IsNullOrEmpty(AlarmRecorInfo.alarm_event))
{
var e = baseEventTypeDAL.GetEntityByCode(AlarmRecorInfo.alarm_event);
AlarmRecordModel.alarmEvent = e == null ? "未知" : e.event_name;
}
else
{
AlarmRecordModel.alarmEvent = "未知";
}
AlarmRecordModel.alarmLocation = AlarmRecorInfo.alarm_location;
AlarmRecordModel.subSystem = Enum.GetName(typeof(EnumClass.SubSystem), AlarmRecorInfo.alarm_subsystem);
AlarmRecordModel.alarmTime = AlarmRecorInfo.alarm_time;
AlarmRecorInfoList.Add(AlarmRecordModel);
}
}
}
//获取关联文件
List <ServArchiveFileModel> archiveFile = servArchiveFileDAL.GetArchiveFile(id);
//获取文件信息
List <ServFileInfoModel> FileInfoList = new List <ServFileInfoModel>();
for (var i = 0; i < archiveFile.Count; i++)
{
ServFileInfoModel fileInfo = servFileInfoDAL.GetEntity(archiveFile[i].relate_id);
FileInfoList.Add(fileInfo);
}
//获取更改日志
List <ServArhiveUpdateLogModel> ServArhiveUpdateLogList = servArhiveUpdateLogDAL.GetArhiveUpdateLogInfo(id);
ArchiveInfoList archiveInfoList = new ArchiveInfoList();
ArchiveInfo archiveInfo = new Model.CustomModel.ArchiveInfo();
archiveInfo.id = ArchiveInfo.id;
archiveInfo.archive_num = ArchiveInfo.archive_num;
archiveInfo.archive_name = ArchiveInfo.archive_name;
archiveInfo.create_time = ArchiveInfo.create_time;
archiveInfo.update_time = ArchiveInfo.update_time;
archiveInfo.archive_decription = ArchiveInfo.archive_decription;
archiveInfo.report_person = ArchiveInfo.report_person;
archiveInfo.archive_status = ArchiveInfo.archive_status;
archiveInfo.report_type = ArchiveInfo.report_type;
archiveInfo.create_persson_id = ArchiveInfo.create_persson_id;
//获取卷宗类别类型
var u = baseReportTypeDAL.GetEntity(ArchiveInfo.report_type);
archiveInfo.report_name = u == null ? "未知" : u.type_name;
//创建人
var a = servPersonInfoDAL.GetPersonInfoBySSOId(ArchiveInfo.create_persson_id);
archiveInfo.create_name = a == null ? "未知" : a.alias;
archiveInfo.status_name = Enum.GetName(typeof(EnumClass.ArchiveStatus), ArchiveInfo.archive_status);
archiveInfo.alarm_id = ArchiveInfo.alarm_id;
archiveInfoList.archiveInfo = archiveInfo;
archiveInfoList.alarmRecord = AlarmRecorInfoList;
archiveInfoList.fileInfo = FileInfoList;
archiveInfoList.arhiveUpdateLog = ServArhiveUpdateLogList;
return(archiveInfoList);
}
catch (Exception ex)
{
throw ex;
}
}
