/// <summary>
/// 新增视频轮播计划任务
/// </summary>
/// <param name="custom"></param>
/// <returns></returns>
public bool InsertCameraPatrolSchedule(CameraScheduleCustom custom)
{
mapContext.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted);//创建事务
ServScheduleTimeConfigDAL timeConfigDal = new ServScheduleTimeConfigDAL();
try
{
ServScheduleModel schedule = new ServScheduleModel();
schedule.content = custom.content;
schedule.create_time = custom.create_time;
schedule.end_time = custom.end_time;
schedule.ext1 = custom.ext1;
schedule.ext10 = custom.ext10;
schedule.ext2 = custom.ext2;
schedule.ext3 = custom.ext3;
schedule.ext4 = custom.ext4;
schedule.ext5 = custom.ext5;
schedule.ext6 = custom.ext6;
schedule.ext7 = custom.ext7;
schedule.ext8 = custom.ext8;
schedule.ext9 = custom.ext9;
schedule.period_expression = custom.period_expression;
schedule.region_id = custom.region_id;
schedule.schedule_name = custom.schedule_name;
schedule.schedule_state = custom.schedule_state;
schedule.schedule_type = custom.schedule_type;
schedule.start_time = custom.start_time;
schedule.span_time = custom.span_time;
int scheduleId = AddEntity(schedule);
if (scheduleId > 0)
{
ServScheduleTimeConfigModel timeModel = new ServScheduleTimeConfigModel();
timeModel.schedule_id = scheduleId;
timeModel.schedule_time = custom.start_execute_time;
timeModel.schedule_date = custom.schedule_date;
timeModel.time_type = 1;//开始时间
if (timeConfigDal.AddEntity(timeModel) > 0)
{
mapContext.CommitTransaction();
return(true);
}
else
{
mapContext.RollBackTransaction();
return(false);
}
}
else
{
mapContext.RollBackTransaction();
return(false);
}
}
catch (Exception ex)
{
mapContext.RollBackTransaction();
throw ex;
}
}
/// <summary>
/// 获取资产巡检列表
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="assetType"></param>
/// <param name="regionId"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="totalNumber"></param>
/// <returns></returns>
public List <RetCameraPatrolSchedule> GetAssetInspectionByPage(int pageIndex, int pageSize, int assetType, int regionId, string startTime, string endTime, out int totalNumber)
{
try
{
List <RetCameraPatrolSchedule> retList = new List <RetCameraPatrolSchedule>();
RetCameraPatrolSchedule retModel = null;
AssetInspectionQuery query = new AssetInspectionQuery();
ServScheduleTimeConfigDAL scheduleTimeConfigDal = new ServScheduleTimeConfigDAL();
BaseRegionConfigDAL baseRegionConfigDal = new BaseRegionConfigDAL();
query.assetType = assetType;
query.endTime = endTime;
query.pageIndex = pageIndex;
query.pageSize = pageSize;
query.regionId = regionId;
query.startTime = startTime;
List <ServScheduleModel> list = servScheduleDal.GetAssetInspectionPage(query, out totalNumber);
//获取全部园区配置
List <BaseRegionConfigModel> regionConfigList = baseRegionConfigDal.GetAllRegionConfig();
for (int i = 0; i < list.Count; i++)
{
retModel = new RetCameraPatrolSchedule();
retModel.content = list[i].content;
retModel.create_time = list[i].create_time;
retModel.cronTime = CSM.Utils.TimeExpression.GetCronTimeModel(list[i].period_expression);//生成时间表达式model
retModel.span_time = list[i].span_time;
#region 查询时间配置
ServScheduleTimeConfigQuery timeQuery = new ServScheduleTimeConfigQuery();
timeQuery.schedule_id = list[i].id;
timeQuery.time_type = 1;//查询开始时间
ServScheduleTimeConfigModel timeModel = scheduleTimeConfigDal.GetScheduleTimeConfigByIdAndTimeType(timeQuery).FirstOrDefault();
retModel.start_execute_time = timeModel == null ? "" : timeModel.schedule_time;
retModel.execute_date = timeModel == null ? "" : timeModel.schedule_date;
#endregion
retModel.id = list[i].id;
retModel.end_execute_time = "";
retModel.end_time = list[i].end_time;
retModel.period_expression = list[i].period_expression;
retModel.region_id = list[i].region_id;
retModel.schedule_name = list[i].schedule_name;
retModel.schedule_state = list[i].schedule_state;
retModel.schedule_type = list[i].schedule_type;
retModel.start_time = list[i].start_time;
var regionModel = regionConfigList.Where(n => n.id == list[i].region_id).FirstOrDefault();
retModel.ext10 = regionModel == null ? "" : regionModel.region_name; //备用字段10用于存储园区名称
retModel.ext7 = list[i].end_time > DateTime.Now ? "1" : "2"; //1：未过期，2：过期
retModel.ext9 = retModel.cronTime.describe; //获取表达式描述
retList.Add(retModel);
}
return(retList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 分页查询获取视频巡更计划任务
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="scheduleName"></param>
/// <param name="regionId"></param>
/// <param name="scheduleType"></param>
/// <param name="scheduleState"></param>
/// <param name="validStartTime"></param>
/// <param name="validEndTime"></param>
/// <param name="totalNumber"></param>
/// <returns></returns>
public List <RetCameraPatrolSchedule> GetCameraPatrolSchedule(int pageIndex, int pageSize, string scheduleName, int regionId, int scheduleType, int scheduleState, string validStartTime, string validEndTime, out int totalNumber)
{
try
{
List <RetCameraPatrolSchedule> retList = new List <RetCameraPatrolSchedule>();
RetCameraPatrolSchedule retModel = null;
BaseRegionConfigDAL baseRegionConfigDal = new BaseRegionConfigDAL();
ServScheduleTimeConfigDAL scheduleTimeConfigDal = new ServScheduleTimeConfigDAL();
ServScheduleQuery query = new ServScheduleQuery();
query.eEndTime = validEndTime;
query.pageIndex = pageIndex;
query.pageSize = pageSize;
query.regionId = regionId;
query.scheduleName = scheduleName;
query.scheduleState = scheduleState;
query.scheduleType = scheduleType;
query.sEndTime = validStartTime;
//分页获视频巡更计划任务
List <CameraPatrolSchedule> cameraPatrolScheduleList = servScheduleDal.GetCameraPatrolScheduleByPage(query, out totalNumber);
//获取全部园区配置
List <BaseRegionConfigModel> regionConfigList = baseRegionConfigDal.GetAllRegionConfig();
//查询园区名称
for (int i = 0; i < cameraPatrolScheduleList.Count; i++)
{
retModel = new RetCameraPatrolSchedule();
retModel.content = cameraPatrolScheduleList[i].content;
retModel.create_time = cameraPatrolScheduleList[i].create_time;
retModel.span_time = cameraPatrolScheduleList[i].span_time;
retModel.cronTime = CSM.Utils.TimeExpression.GetCronTimeModel(cameraPatrolScheduleList[i].period_expression);//生成时间表达式model
#region 查询时间配置
ServScheduleTimeConfigQuery timeQuery = new ServScheduleTimeConfigQuery();
timeQuery.schedule_id = cameraPatrolScheduleList[i].id;
timeQuery.time_type = 1;//查询开始时间
ServScheduleTimeConfigModel timeModel = scheduleTimeConfigDal.GetScheduleTimeConfigByIdAndTimeType(timeQuery).FirstOrDefault();
retModel.start_execute_time = timeModel == null ? "" : timeModel.schedule_time;
retModel.execute_date = timeModel == null ? "" : timeModel.schedule_date;
#endregion
retModel.end_execute_time = "";
retModel.end_time = cameraPatrolScheduleList[i].end_time;
retModel.ext1 = cameraPatrolScheduleList[i].ext1;
// retModel.ext10 = cameraPatrolScheduleList[i].ext10;
retModel.ext2 = cameraPatrolScheduleList[i].ext2;
retModel.ext3 = cameraPatrolScheduleList[i].ext3;
retModel.ext4 = cameraPatrolScheduleList[i].ext4;
retModel.ext5 = cameraPatrolScheduleList[i].ext5;
retModel.ext6 = cameraPatrolScheduleList[i].ext6;
// retModel.ext7 = cameraPatrolScheduleList[i].ext7;
retModel.ext8 = cameraPatrolScheduleList[i].ext8;
// retModel.ext9 = cameraPatrolScheduleList[i].ext9;
retModel.group_id = cameraPatrolScheduleList[i].group_id;
retModel.group_name = cameraPatrolScheduleList[i].group_name;
retModel.id = cameraPatrolScheduleList[i].id;
retModel.period_expression = cameraPatrolScheduleList[i].period_expression;
retModel.region_id = cameraPatrolScheduleList[i].region_id;
retModel.schedule_name = cameraPatrolScheduleList[i].schedule_name;
retModel.schedule_state = cameraPatrolScheduleList[i].schedule_state;
retModel.schedule_type = cameraPatrolScheduleList[i].schedule_type;
retModel.start_time = cameraPatrolScheduleList[i].start_time;
var regionModel = regionConfigList.Where(n => n.id == cameraPatrolScheduleList[i].region_id).FirstOrDefault();
retModel.ext10 = regionModel == null ? "" : regionModel.region_name; //备用字段10用于存储园区名称
retModel.ext7 = cameraPatrolScheduleList[i].end_time > DateTime.Now ? "1" : "2"; //1：未过期，2：过期
retModel.ext9 = retModel.cronTime.describe; //获取表达式描述
retList.Add(retModel);
}
return(retList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新视频轮播计划任务
/// </summary>
/// <param name="custom"></param>
/// <returns></returns>
public bool UpdateCameraPatrolSchedule(CameraScheduleCustom custom)
{
mapContext.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted);//创建事务
ServScheduleTimeConfigDAL timeConfigDal = new ServScheduleTimeConfigDAL();
try
{
ServScheduleModel schedule = new ServScheduleModel();
schedule.id = custom.id;
schedule.content = custom.content;
schedule.create_time = custom.create_time;
schedule.end_time = custom.end_time;
schedule.ext1 = custom.ext1;
schedule.ext10 = custom.ext10;
schedule.ext2 = custom.ext2;
schedule.ext3 = custom.ext3;
schedule.ext4 = custom.ext4;
schedule.ext5 = custom.ext5;
schedule.ext6 = custom.ext6;
schedule.ext7 = custom.ext7;
schedule.ext8 = custom.ext8;
schedule.ext9 = custom.ext9;
schedule.period_expression = custom.period_expression;
schedule.region_id = custom.region_id;
schedule.schedule_name = custom.schedule_name;
schedule.schedule_state = custom.schedule_state;
schedule.schedule_type = custom.schedule_type;
schedule.start_time = custom.start_time;
schedule.span_time = custom.span_time;
int res = UpdateScheduleById(schedule);
if (res > 0)
{
ServScheduleTimeConfigModel timeModel = timeConfigDal.GetScheduleTimeConfigByScheduleId(custom.id).FirstOrDefault(); //获取第一个视频轮播计划任务时间配置
//如果未找到当前时间配置，则新增时间配置记录；找到时间配置，进行更新操作
if (timeModel != null)
{
timeModel.schedule_time = custom.start_execute_time;
timeModel.schedule_date = custom.schedule_date;
if (timeConfigDal.UpdateTimeConfig(timeModel) > 0)
{
mapContext.CommitTransaction();
return(true);
}
else
{
mapContext.RollBackTransaction();
return(false);
}
}
else
{
timeModel = new ServScheduleTimeConfigModel();
timeModel.schedule_id = custom.id;
timeModel.schedule_time = custom.start_execute_time;
timeModel.schedule_date = custom.schedule_date;
timeModel.time_type = 1;//开始时间
if (timeConfigDal.AddEntity(timeModel) > 0)
{
mapContext.CommitTransaction();
return(true);
}
else
{
mapContext.RollBackTransaction();
return(false);
}
}
}
else
{
mapContext.RollBackTransaction();
return(false);
}
}
catch (Exception ex)
{
mapContext.RollBackTransaction();
throw ex;
}
}
