/// <summary> /// ---------新加 /// 实时监控页面新增数据位置 /// </summary> public ReturnItem <RetRealTimeMonitor> AddRealTimeRoot(RealTimeMonitorModel parameter) { ReturnItem <RetRealTimeMonitor> r = new ReturnItem <RetRealTimeMonitor>(); using (UserEntities user = new UserEntities()) { try { var OrgID = Convert.ToInt32(parameter.OrgID); var DashBoardType = Convert.ToInt32(parameter.DashBoardType);// 3 实时查看的图 var addmonitor = user.U_HomeConfiguration.Where(s => s.OrgID == OrgID && s.DashBoardType == DashBoardType).AsQueryable(); //0代表背景图,1代表建筑物的名字(只有建筑物会调用这个接口) //查询位置是否存在 addmonitor = addmonitor.Where(s => s.DashBoardData == parameter.DashBoardData); addmonitor = addmonitor.OrderByDescending(s => s.CreateTime); if (addmonitor.ToList().Count != 0) { r.Data = null; r.Code = -1; r.Msg = "该位置数据信息已存在"; return(r); } else if (addmonitor.ToList().Count == 0) { U_HomeConfiguration newChart = new U_HomeConfiguration() { DashBoardType = DashBoardType, // 2设备,3总览 ChartType = Convert.ToInt32(parameter.ChartType), // 0 背景图信息 1建筑物信息 DashBoardData = parameter.DashBoardData, Remark = parameter.Remark, CreateTime = DateTime.Now, CreateUserID = Convert.ToInt32(parameter.CreateUserID), OrgID = Convert.ToInt32(parameter.OrgID) }; user.U_HomeConfiguration.Add(newChart); user.SaveChanges(); r.Msg = "新增成功"; r.Code = 0; } } catch (Exception e) { r.Msg = "内部错误请重试"; log.ErrorFormat("内部错误:{0},{1}", e.Message, e.StackTrace); r.Code = -1; } } return(r); }
/// <summary> /// 新增/更新能源信息数据 /// </summary> public ReturnItem <RetEquipmentEnergyList> AddChart(EquipmentEnergyModel parameter) { ReturnItem <RetEquipmentEnergyList> r = new ReturnItem <RetEquipmentEnergyList>(); using (UserEntities user = new UserEntities()) { try { var OrgID = Convert.ToInt32(parameter.OrgID); var DashBoardType = Convert.ToInt32(parameter.DashBoardType); var addchart = user.U_HomeConfiguration.Where(s => s.OrgID == OrgID && s.DashBoardType == DashBoardType).FirstOrDefault(); if (addchart != null) { addchart.ChartConfig = parameter.ChartConfig; user.SaveChanges(); r.Msg = "能源报表配置信息更新成功"; r.Code = 0; } if (addchart == null) { U_HomeConfiguration newChart = new U_HomeConfiguration() { DashBoardType = Convert.ToInt32(parameter.DashBoardType), ChartConfig = parameter.ChartConfig, SortID = Convert.ToInt32(parameter.SortID), CreateTime = DateTime.Now, CreateUserID = Convert.ToInt32(parameter.CreateUserID), OrgID = Convert.ToInt32(parameter.OrgID) }; user.U_HomeConfiguration.Add(newChart); user.SaveChanges(); r.Msg = "能源报表配置信息新增成功"; r.Code = 0; } } catch (Exception e) { r.Msg = "内部错误请重试"; log.ErrorFormat("内部错误:{0},{1}", e.Message, e.StackTrace); r.Code = -1; } } return(r); }
/// <summary> /// 实时监控页面新增数据位置 /// </summary> public ReturnItem <RetRealTimeMonitor> AddRealTimeMonitor(RealTimeMonitorModel parameter) { ReturnItem <RetRealTimeMonitor> r = new ReturnItem <RetRealTimeMonitor>(); using (UserEntities user = new UserEntities()) { try { var OrgID = Convert.ToInt32(parameter.OrgID); var DashBoardType = Convert.ToInt32(parameter.DashBoardType); // 2设备,3总览 var addmonitor = user.U_HomeConfiguration.Where(s => s.OrgID == OrgID && s.DashBoardType == DashBoardType).AsQueryable(); if ("2".Equals(parameter.DashBoardType)) // 设备 { var DeviceID = Convert.ToInt32(parameter.DeviceID); if ("0".Equals(parameter.ChartType)) { addmonitor = addmonitor.Where(s => s.DeviceID == DeviceID && s.ChartType == 0); } else if ("1".Equals(parameter.ChartType) || "2".Equals(parameter.ChartType)) { addmonitor = addmonitor.Where(s => s.DeviceID == DeviceID && s.DashBoardData == parameter.DashBoardData); } } else if ("3".Equals(parameter.DashBoardType)) // 总览 { if ("0".Equals(parameter.ChartType)) { addmonitor = addmonitor.Where(s => s.ChartType == 0); } else if ("1".Equals(parameter.ChartType) || "2".Equals(parameter.ChartType)) { addmonitor = addmonitor.Where(s => s.DashBoardData == parameter.DashBoardData); } } addmonitor = addmonitor.OrderByDescending(s => s.CreateTime); if (addmonitor.ToList().Count != 0) { if ("1".Equals(parameter.ChartType) || "2".Equals(parameter.ChartType))// 0 背景图信息 1 设备信息 2 设备属性信息 { r.Data = null; r.Code = -1; r.Msg = "该位置数据信息已存在"; return(r); } else if ("0".Equals(parameter.ChartType)) { if ("2".Equals(parameter.DashBoardType)) // 设备 { var DeviceID = Convert.ToInt32(parameter.DeviceID); var editmonitor = user.U_HomeConfiguration.Where(s => s.OrgID == OrgID && s.DashBoardType == DashBoardType && s.DeviceID == DeviceID && s.ChartType == 0).FirstOrDefault(); editmonitor.DashBoardData = parameter.DashBoardData; editmonitor.Remark = parameter.Remark; user.SaveChanges(); } else if ("3".Equals(parameter.DashBoardType)) // 总览 { var editmonitor = user.U_HomeConfiguration.Where(s => s.OrgID == OrgID && s.DashBoardType == DashBoardType && s.ChartType == 0).FirstOrDefault(); editmonitor.DashBoardData = parameter.DashBoardData; editmonitor.Remark = parameter.Remark; user.SaveChanges(); } if (parameter.DelDeviceTags.Count != 0) { foreach (var deltags in parameter.DelDeviceTags) { var delid = Convert.ToInt32(deltags); var deletechart = user.U_HomeConfiguration.Where(s => s.ID == delid).FirstOrDefault(); if (deletechart != null) { var entry = user.Entry(deletechart); //设置该对象的状态为删除 entry.State = EntityState.Deleted; user.SaveChanges(); //保存修改 } } } if (parameter.DelTags.Count != 0) { foreach (var deltags in parameter.DelTags) { var delid = Convert.ToInt32(deltags); var deletechart = user.U_HomeConfiguration.Where(s => s.ID == delid).FirstOrDefault(); if (deletechart != null) { var entry = user.Entry(deletechart); //设置该对象的状态为删除 entry.State = EntityState.Deleted; user.SaveChanges(); //保存修改 } } } r.Msg = "更新成功"; r.Code = 0; return(r); } } else if (addmonitor.ToList().Count == 0) { U_HomeConfiguration newChart = new U_HomeConfiguration() { DashBoardType = DashBoardType, // 2设备,3总览 ChartType = Convert.ToInt32(parameter.ChartType), // 0 背景图信息 1 设备信息 2 设备属性信息 DashBoardData = parameter.DashBoardData, Remark = parameter.Remark, CreateTime = DateTime.Now, CreateUserID = Convert.ToInt32(parameter.CreateUserID), OrgID = Convert.ToInt32(parameter.OrgID) }; if (parameter.DeviceID != "" && parameter.DeviceID != null) { newChart.DeviceID = Convert.ToInt32(parameter.DeviceID); } if (parameter.DeviceItemID != "" && parameter.DeviceItemID != null) { newChart.DeviceItemID = Convert.ToInt32(parameter.DeviceItemID); } if (parameter.GroupID != "" && parameter.GroupID != null) { newChart.GroupID = Convert.ToInt32(parameter.GroupID); } user.U_HomeConfiguration.Add(newChart); user.SaveChanges(); r.Msg = "新增成功"; r.Code = 0; } } catch (Exception e) { r.Msg = "内部错误请重试"; log.ErrorFormat("内部错误:{0},{1}", e.Message, e.StackTrace); r.Code = -1; } } return(r); }
/// <summary> /// 新增图表 /// </summary> public ReturnItem <RetHomeConfiguration> AddChart(HomeConfigurationModel parameter) { ReturnItem <RetHomeConfiguration> r = new ReturnItem <RetHomeConfiguration>(); using (UserEntities user = new UserEntities()) { try { var OrgID = Convert.ToInt32(parameter.OrgID); var DashBoardType = Convert.ToInt32(parameter.DashBoardType); var addchart = user.U_HomeConfiguration.Where(s => s.ChartName == parameter.ChartName && s.OrgID == OrgID && s.DashBoardType == DashBoardType).FirstOrDefault(); if (addchart != null) { r.Data = null; r.Code = -1; r.Msg = "设备图表已存在"; return(r); } if (addchart == null) { U_HomeConfiguration newChart = new U_HomeConfiguration() { DashBoardType = Convert.ToInt32(parameter.DashBoardType), ChartName = parameter.ChartName, ChartType = Convert.ToInt32(parameter.ChartType), ChartConfig = parameter.ChartConfig, DashBoardData = parameter.DashBoardData, Remark = parameter.Remark, SortID = Convert.ToInt32(parameter.SortID), CreateTime = DateTime.Now, CreateUserID = Convert.ToInt32(parameter.CreateUserID), OrgID = Convert.ToInt32(parameter.OrgID) }; if (parameter.DeviceID != "" && parameter.DeviceID != null) { newChart.DeviceID = Convert.ToInt32(parameter.DeviceID); } user.U_HomeConfiguration.Add(newChart); user.SaveChanges(); var getchart = user.U_HomeConfiguration.Where(s => s.ChartName == parameter.ChartName && s.OrgID == OrgID).FirstOrDefault(); if (getchart != null) { DashBoardDataListModel DashBoardData = new DashBoardDataListModel(); if (getchart.DashBoardData != "" && getchart.DashBoardData != null) { DashBoardData = JsonConvert.DeserializeObject <DashBoardDataListModel>(getchart.DashBoardData); } DashBoardData.i = getchart.ID.ToString(); getchart.DashBoardData = JsonConvert.SerializeObject(DashBoardData); } user.SaveChanges(); r.Msg = "设备信息新增成功"; r.Code = 0; } } catch (Exception e) { r.Msg = "内部错误请重试"; log.ErrorFormat("内部错误:{0},{1}", e.Message, e.StackTrace); r.Code = -1; } } return(r); }