/// <summary>
/// 分页查询获取设备预案 2016.12.04 乔会会
/// </summary>
/// <param name="servDevicePlanQuery"></param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageNumber">当前页码</param>
/// <param name="totalNumber">共多少条</param>
/// <returns></returns>
public List <DevicePlanModel> GetEntities(ServDevicePlanQuery servDevicePlanQuery, int pageNumber, int pageSize, out int totalNumber)
{
try
{
List <ServDevicePlanModel> DevicePlanlist = new List <ServDevicePlanModel>();
List <DevicePlanModel> devicePlanInfoList = new List <DevicePlanModel>();
DevicePlanlist = servDevicePlanDAL.GetEntities(servDevicePlanQuery, pageSize, pageNumber, out totalNumber);
DevicePlanModel devicePlanInfoModel;
foreach (ServDevicePlanModel item in DevicePlanlist)
{
devicePlanInfoModel = new DevicePlanModel();
devicePlanInfoModel.id = item.id;
devicePlanInfoModel.plan_code = item.plan_code;
devicePlanInfoModel.plan_name = item.plan_name;
devicePlanInfoModel.plan_level = item.plan_level;
//获取设备名称
var u = servDeviceInfoDAL.GetEntity(item.device_id);
devicePlanInfoModel.device_name = u == null ? "未知" : u.device_name;
devicePlanInfoModel.create_time = item.create_time;
//事发园区
if (u != null)
{
var a = baseRegionConfigDAL.GetEntity(u.region_id);
devicePlanInfoModel.region_name = a == null ? "未知" : a.region_name;
}
else
{
devicePlanInfoModel.region_name = "未知";
}
devicePlanInfoModel.update_time = item.update_time;
if (item.plan_status != (int)CSM.Common.EnumClass.PlanStatus.废止)
{
devicePlanInfoModel.planStatus = Enum.GetName(typeof(EnumClass.PlanStatus), item.plan_status);
}
//获取创建人名称
//var a = DeviceInfobll.GetPersonNameById(item.person_id);
//devicePlanInfoModel.person_name = a == null ? "未知" : a.person_name;
//devicePlanInfoModel.start_time = item.start_time;
//devicePlanInfoModel.end_time = item.end_time;
devicePlanInfoList.Add(devicePlanInfoModel);
}
return(devicePlanInfoList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查看时间是否被占用
/// </summary>
/// <param name="deviceId"></param>
/// <param name="planTime"></param>
/// <returns></returns>
public List <DevicePlanModel> IsCheckTimeOccupied(int devicePlanId, int deviceId, string planTime, string executionCycle, string endTime)
{
try
{
DevicePlanModel devicePlanInfo = new DevicePlanModel();
List <DevicePlanModel> devicePlanInfoList = new List <DevicePlanModel>();
devicePlanInfo.device_id = deviceId;
devicePlanInfo.start_time = planTime;
devicePlanInfo.id = devicePlanId;
devicePlanInfo.end_time = endTime;
devicePlanInfo.execution_cycle = executionCycle;
devicePlanInfo.type = (int)RelateType.设备预案;
devicePlanInfo.plan_status = (int)PlanStatus.废止;
if (endTime == "")
{
if (devicePlanId == -1)
{
string sql = IBatisHelper.GetRuntimeSql(this.mapContext, "IsTimeOccupied", devicePlanInfo);
devicePlanInfoList = mapContext.QueryForList <DevicePlanModel>("IsTimeOccupied", devicePlanInfo).ToList();
}
else
{
devicePlanInfoList = mapContext.QueryForList <DevicePlanModel>("UpdateIsTimeOccupied", devicePlanInfo).ToList();
}
}
else
{
if (devicePlanId == -1)
{
devicePlanInfoList = mapContext.QueryForList <DevicePlanModel>("IsVerificationTimeOccupy", devicePlanInfo).ToList();
}
else
{
devicePlanInfoList = mapContext.QueryForList <DevicePlanModel>("UpdateVerificationTimeOccupy", devicePlanInfo).ToList();
}
}
return(devicePlanInfoList);
}
catch (Exception ex)
{
throw ex;
}
}
