public HttpResponseMessage AddGroupsJinRunXian([FromBody] SensorGroupJinRunXian model) { using (var db = new SecureCloud_Entities()) { try { var group = new T_DIM_GROUP(); group.GROUP_NAME = model.GroupName; group.GROUP_TYPE_ID = 3; var entry = db.Entry(group); entry.State = System.Data.EntityState.Added; var sensorIds = model.SensorList.Select(s => s.SensorId); var sensors = db.T_DIM_SENSOR.Where(s => sensorIds.Contains(s.SENSOR_ID)).ToList(); StringBuilder sb = new StringBuilder(); foreach (var sensor in model.SensorList) { sb.AppendFormat( "位置-{0}_高度-{1};", sensors.Where(s => s.SENSOR_ID == sensor.SensorId) .Select(s => s.SENSOR_LOCATION_DESCRIPTION) .FirstOrDefault(), sensor.Height); var sensorGroupJinRunXian = new T_DIM_SENSOR_GROUP_JINRUNXIAN(); sensorGroupJinRunXian.GROUP_ID = group.GROUP_ID; sensorGroupJinRunXian.SENSOR_ID = sensor.SensorId; sensorGroupJinRunXian.HEIGHT = sensor.Height; var test = db.Entry(sensorGroupJinRunXian); test.State = System.Data.EntityState.Added; } #region 日志 this.Request.Properties["ActionParameter"] = JsonConvert.SerializeObject(model); this.Request.Properties["ActionParameterShow"] = string.Format("组:{0},传感器:{1}", model.GroupName, sb); #endregion db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Accepted, StringHelper.GetMessageString("测斜传感器组新增成功"))); } catch (NullReferenceException e) { return(Request.CreateResponse( HttpStatusCode.BadRequest, StringHelper.GetMessageString("测斜传感器组新增失败:参数无效"))); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.BadRequest, StringHelper.GetMessageString("测斜传感器组新增失败"))); } } }
public HttpResponseMessage AddGroupsChenJiang([FromBody] SensorGroupChenJiang model) { using (var db = new SecureCloud_Entities()) { try { var group = new T_DIM_GROUP(); group.GROUP_NAME = model.GroupName; group.GROUP_TYPE_ID = 2; var entry = db.Entry(group); entry.State = System.Data.EntityState.Added; var sensorIds = model.SensorList.Select(s => s.SensorId); var sensors = db.T_DIM_SENSOR.Where(s => sensorIds.Contains(s.SENSOR_ID)).ToList(); StringBuilder sb = new StringBuilder(); foreach (var p in model.SensorList) { sb.AppendFormat( "位置-{0}_长度-{2}_是否基准点-{1};", sensors.Where(s => s.SENSOR_ID == p.SensorId) .Select(s => s.SENSOR_LOCATION_DESCRIPTION) .FirstOrDefault(), p.IsDatum, p.Len); var sensorGroupChenJiang = new T_DIM_SENSOR_GROUP_CHENJIANG(); sensorGroupChenJiang.GROUP_ID = group.GROUP_ID; sensorGroupChenJiang.SENSOR_ID = p.SensorId; sensorGroupChenJiang.isJIZHUNDIAN = p.IsDatum; sensorGroupChenJiang.LENGTH = p.Len; var test = db.Entry(sensorGroupChenJiang); test.State = System.Data.EntityState.Added; } #region 日志 this.Request.Properties["ActionParameter"] = JsonConvert.SerializeObject(model); this.Request.Properties["ActionParameterShow"] = string.Format("组:{0},传感器:{1}", model.GroupName, sb); #endregion db.SaveChanges(); int gid = group.GROUP_ID; // 增加的组信息 var gs = (from s in db.T_DIM_SENSOR from sg in sensorIds from d in db.T_DIM_REMOTE_DTU where s.SENSOR_ID == sg && d.ID == s.DTU_ID select new SensorGroup { GroupId = gid, DtuId = s.DTU_ID.Value, DtuCode = d.REMOTE_DTU_NUMBER, DacInterval = d.REMOTE_DTU_GRANULARITY.Value }) .Distinct(); try { SendMsg2ET(gs.ToList()); } catch (Exception ex) { log.Error(ex); } return(Request.CreateResponse(HttpStatusCode.Accepted, StringHelper.GetMessageString("测斜传感器组新增成功"))); } catch (NullReferenceException e) { return(Request.CreateResponse( HttpStatusCode.BadRequest, StringHelper.GetMessageString("测斜传感器组新增失败:参数无效"))); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.BadRequest, StringHelper.GetMessageString("测斜传感器组新增失败"))); } } }