/// <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="entity"></param>
public int AddEntity(ServScheduleModel entity)
{
try
{
int id = (int)mapContext.Insert("InsertSchedule", entity);
return(id);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
public int UpdateScheduleById(ServScheduleModel model)
{
try
{
string sql = CSM.Utils.IBatisHelper.GetRuntimeSql(mapContext, "UpdateSchedule", model);
int result = mapContext.Update("UpdateSchedule", model);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateEntity(int id, ServScheduleModel newentity)
{
throw new NotImplementedException();
}
/// <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;
}
}