public IHttpActionResult DeviceAddChart(HomeConfigurationModel model) { UserApi api = new UserApi(); var userApi = api.GetUserInfoByToken(); model.DashBoardType = "1"; model.CreateUserID = userApi.Data.UserId; model.OrgID = userApi.Data.OrgID.ToString(); HomeConfigurationBLL device = new HomeConfigurationBLL(); DashBoardDataListModel DashBoardData = new DashBoardDataListModel() { x = 0, y = 0, w = Convert.ToInt32(model.Width), h = Convert.ToInt32(model.Height) }; model.DashBoardData = JsonConvert.SerializeObject(DashBoardData); model.DatabaseType = "0";//默认设备源 DashBoardChartConfigModel ChartConfig = new DashBoardChartConfigModel() { DatabaseType = model.DatabaseType, DataType = model.DataType, RecentInterval = model.RecentInterval, RecentUnit = model.RecentUnit, StartTime = model.StartTime.ToString(), EndTime = model.EndTime.ToString(), StatisticalInterval = model.StatisticalInterval, IntervalUnit = model.IntervalUnit, MinValue = model.MinValue, MaxValue = model.MaxValue, ValueType = model.ValueType, TextColor = model.TextColor, BackgroundColor = model.BackgroundColor }; List <HomeDeviceInfo> HomeDeviceInfoList = new List <HomeDeviceInfo>(); if (model.DeviceItemList != null) { for (int i = 0; i < model.DeviceItemList.Count; i++) { HomeDeviceInfo HomeDeviceInfo = new HomeDeviceInfo(); HomeDeviceInfo.DeviceID = model.DeviceID; HomeDeviceInfo.DeviceItemID = model.DeviceItemList[i].DeviceItemID; HomeDeviceInfoList.Add(HomeDeviceInfo); } } ChartConfig.HomeDeviceInfoList = HomeDeviceInfoList; model.ChartConfig = JsonConvert.SerializeObject(ChartConfig); var add = device.AddChart(model); return(InspurJson <RetHomeConfiguration>(add)); }
public IHttpActionResult EditChart(HomeConfigurationModel model) { HomeConfigurationBLL device = new HomeConfigurationBLL(); DashBoardDataListModel DashBoardData = new DashBoardDataListModel() { x = Convert.ToInt32(model.XAxis), y = Convert.ToInt32(model.YAxis), w = Convert.ToInt32(model.Width), h = Convert.ToInt32(model.Height), i = model.ID.ToString() }; model.DashBoardData = JsonConvert.SerializeObject(DashBoardData); model.DatabaseType = "0";//默认设备源 DashBoardChartConfigModel ChartConfig = new DashBoardChartConfigModel() { DatabaseType = model.DatabaseType, DataType = model.DataType, RecentInterval = model.RecentInterval, RecentUnit = model.RecentUnit, StartTime = model.StartTime.ToString(), EndTime = model.EndTime.ToString(), StatisticalInterval = model.StatisticalInterval, IntervalUnit = model.IntervalUnit, MinValue = model.MinValue, MaxValue = model.MaxValue, ValueType = model.ValueType, TextColor = model.TextColor, BackgroundColor = model.BackgroundColor }; List <HomeDeviceInfo> HomeDeviceInfoList = new List <HomeDeviceInfo>(); if (model.DeviceItemList != null) { for (int i = 0; i < model.DeviceItemList.Count; i++) { HomeDeviceInfo HomeDeviceInfo = new HomeDeviceInfo(); HomeDeviceInfo.DeviceID = model.DeviceID; HomeDeviceInfo.DeviceItemID = model.DeviceItemList[i].DeviceItemID; HomeDeviceInfoList.Add(HomeDeviceInfo); } } ChartConfig.HomeDeviceInfoList = HomeDeviceInfoList; model.ChartConfig = JsonConvert.SerializeObject(ChartConfig); var update = device.EditChart(model); return(InspurJson <RetHomeConfiguration>(update)); }
/// <summary> /// 保存布局 /// </summary> public ReturnItem <RetHomeConfiguration> SaveLayout(List <DashBoardDataListModel> list) { ReturnItem <RetHomeConfiguration> r = new ReturnItem <RetHomeConfiguration>(); using (UserEntities user = new UserEntities()) { try { foreach (var item in list) { var id = Convert.ToInt32(item.i); var savechart = user.U_HomeConfiguration.Where(s => s.ID == id).FirstOrDefault(); if (savechart != null) { DashBoardDataListModel DashBoardData = new DashBoardDataListModel() { x = item.x, y = item.y, w = item.w, h = item.h, i = item.i }; savechart.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); }
/// <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); }
public IHttpActionResult IndexEditChart(HomeConfigurationModel model) { HomeConfigurationBLL device = new HomeConfigurationBLL(); model.DashBoardType = "0";//首页 DashBoardDataListModel DashBoardData = new DashBoardDataListModel() { x = Convert.ToInt32(model.XAxis), y = Convert.ToInt32(model.YAxis), w = Convert.ToInt32(model.Width), h = Convert.ToInt32(model.Height), i = model.ID.ToString() }; model.DashBoardData = JsonConvert.SerializeObject(DashBoardData); DashBoardChartConfigModel ChartConfig = new DashBoardChartConfigModel() { DatabaseType = model.DatabaseType, DataType = model.DataType, RecentInterval = model.RecentInterval, RecentUnit = model.RecentUnit, StartTime = model.StartTime.ToString(), EndTime = model.EndTime.ToString(), StatisticalInterval = model.StatisticalInterval, IntervalUnit = model.IntervalUnit, MinValue = model.MinValue, MaxValue = model.MaxValue, ValueType = model.ValueType, TextColor = model.TextColor, BackgroundColor = model.BackgroundColor }; List <HomeDeviceInfo> HomeDeviceInfoList = new List <HomeDeviceInfo>(); if (model.Property != null) { if (model.Property.Count == 1) //设备,总览,表格 { if (model.Property[0].data[0] == "1") { // 设备 ChartConfig.SelectionType = "1"; HomeDeviceInfo HomeDeviceInfo = new HomeDeviceInfo(); HomeDeviceInfo.DeviceID = model.Property[0].data[1]; HomeDeviceInfo.DeviceItemID = model.Property[0].data[2]; HomeDeviceInfoList.Add(HomeDeviceInfo); } else if (model.Property[0].data[0] == "2") { // 总览 ChartConfig.SelectionType = "2"; } else if (model.Property[0].data[0] == "3") { // 表格 ChartConfig.SelectionType = "3"; } } else if (model.Property.Count > 1) //只可能设备 { for (int i = 0; i < model.Property.Count; i++) { ChartConfig.SelectionType = "1"; HomeDeviceInfo HomeDeviceInfo = new HomeDeviceInfo(); HomeDeviceInfo.DeviceID = model.Property[i].data[1]; HomeDeviceInfo.DeviceItemID = model.Property[i].data[2]; HomeDeviceInfoList.Add(HomeDeviceInfo); } } } ChartConfig.HomeDeviceInfoList = HomeDeviceInfoList; model.ChartConfig = JsonConvert.SerializeObject(ChartConfig); var update = device.EditChart(model); return(InspurJson <RetHomeConfiguration>(update)); }