public ActionResult SaveHautoDevice(MSTB_COM_HUMITURE_HYGROTHERMOGRAPHModel deviceInfo) { StringBuilder errorMsg = new StringBuilder(); StringBuilder errorExceptionMsg = new StringBuilder(); if (deviceInfo.EQUIPMENT_ID == 0) { } else { var updateDevice = _hautoProductContext.MSTB_COM_HUMITURE_HYGROTHERMOGRAPHS.FirstOrDefault(p => p.EQUIPMENT_ID == deviceInfo.EQUIPMENT_ID); if (!deviceInfo.ConnectStatusValue.IsNullOrEmpty()) { updateDevice.ConnectStatus = deviceInfo.ConnectStatusValue.ToString(); } if (!deviceInfo.DeviceArea.IsNullOrEmpty()) { updateDevice.DeviceArea = deviceInfo.DeviceArea; } if (!deviceInfo.HygrothermographAddress.IsNullOrEmpty()) { updateDevice.HygrothermographAddress = deviceInfo.HygrothermographAddress; } try { _hautoProductContext.SaveChanges(); } catch (Exception ex) { errorExceptionMsg.Append(ex.Message.ToString() + ex.InnerException.ToString()); } } return(new JsonResult(new { Success = true, ErrorMsg = "", ErrorDetailMsg = errorMsg.ToString() })); }
public ActionResult GetDeviceDetail(GetDeviceListRequest request) { var model = default(MSTB_COM_HUMITURE_HYGROTHERMOGRAPHModel); if (request.eqid > 0) { var deviceInfo = _hautoProductContext.MSTB_COM_HUMITURE_HYGROTHERMOGRAPHS.FirstOrDefault(p => p.EQUIPMENT_ID == request.eqid); if (deviceInfo != null) { model = new MSTB_COM_HUMITURE_HYGROTHERMOGRAPHModel { DeviceArea = deviceInfo.DeviceArea, DeviceSerialNumber = deviceInfo.DeviceSerialNumber, EQUIPMENT_ID = deviceInfo.EQUIPMENT_ID, GetRate = deviceInfo.GetRate.HasValue ? deviceInfo.GetRate.Value : 10, TempratureUper = deviceInfo.TempratureUper, TempratureLower = deviceInfo.TempratureLower, HumidityUper = deviceInfo.HumidityUper, HumidityLower = deviceInfo.HumidityLower, HygrothermographAddress = deviceInfo.HygrothermographAddress, HygrothermographName = deviceInfo.HygrothermographName, HygrothermographPort = deviceInfo.HygrothermographPort, HygrothermographType = deviceInfo.HygrothermographType.ToString(), HumidityUperLowerStr = (deviceInfo.HumidityUper.HasValue && deviceInfo.HumidityLower.HasValue) ? (deviceInfo.HumidityLower.Value.ToString() + " - " + deviceInfo.HumidityUper.ToString()) : "", TempratureUpLowerStr = (deviceInfo.TempratureUper.HasValue && deviceInfo.TempratureLower.HasValue) ? (deviceInfo.TempratureLower.Value.ToString() + " - " + deviceInfo.TempratureUper.ToString()) : "", Status = deviceInfo.Status, ConnectStatusValue = deviceInfo.ConnectStatus }; if (deviceInfo.ConnectStatus == EnumConnectStatus.Connected.ToString()) { model.ConnectStatus = "连接"; } else if (deviceInfo.ConnectStatus == EnumConnectStatus.Disconnected.ToString()) { model.ConnectStatus = "断开"; } } else { return(new JsonResult(new { Success = false, ErrorMsg = "未找到相关设备!" })); } } return(new JsonResult(new { Success = true, data = model })); }
public ActionResult GetHautoDeviceList(GetDeviceListRequest request) { var modelList = new List <MSTB_COM_HUMITURE_HYGROTHERMOGRAPHModel>(); var q = _hautoProductContext.MSTB_COM_HUMITURE_HYGROTHERMOGRAPHS as IQueryable <MSTB_COM_HUMITURE_HYGROTHERMOGRAPH>; if (!request.deviceSerialNumber.IsNullOrEmpty()) { q = q.Where(p => p.DeviceSerialNumber == request.deviceSerialNumber); } if (!request.deviceName.IsNullOrEmpty()) { q = q.Where(p => p.HygrothermographName.Contains(request.deviceName)); } if (!request.deviceType.IsNullOrEmpty()) { var deviceType = (HygrothermographType)(int.Parse(request.deviceType)); q = q.Where(p => p.HygrothermographType == deviceType); } if (request.deviceIds != null && request.deviceIds.Count > 0) { q = q.Where(p => request.deviceIds.Contains(p.EQUIPMENT_ID)); } var rowCount = q.Count(); q = q.Skip((request.page - 1) * request.pageSize).Take(request.pageSize); var dataList = q.ToList(); if (dataList != null && dataList.Count > 0) { foreach (var item in dataList) { var tmpModel = new MSTB_COM_HUMITURE_HYGROTHERMOGRAPHModel { DeviceArea = item.DeviceArea, DeviceSerialNumber = item.DeviceSerialNumber, EQUIPMENT_ID = item.EQUIPMENT_ID, GetRate = item.GetRate.HasValue ? item.GetRate.Value : 10, TempratureUper = item.TempratureUper, TempratureLower = item.TempratureLower, HumidityUper = item.HumidityUper, HumidityLower = item.HumidityLower, HygrothermographAddress = item.HygrothermographAddress, HygrothermographName = item.HygrothermographName, HygrothermographPort = item.HygrothermographPort, HygrothermographType = item.HygrothermographType.ToString(), HumidityUperLowerStr = (item.HumidityUper.HasValue && item.HumidityLower.HasValue)?(item.HumidityLower.Value.ToString() + " - " + item.HumidityUper.ToString()) :"", TempratureUpLowerStr = (item.TempratureUper.HasValue && item.TempratureLower.HasValue) ? (item.TempratureLower.Value.ToString() + " - " + item.TempratureUper.ToString()) : "", Status = item.Status, ConnectStatusValue = item.ConnectStatus }; if (item.ConnectStatus == EnumConnectStatus.Connected.ToString()) { tmpModel.ConnectStatus = "连接"; } else if (item.ConnectStatus == EnumConnectStatus.Disconnected.ToString()) { tmpModel.ConnectStatus = "断开"; } modelList.Add(tmpModel); } } return(new JsonResult(new { Datas = modelList, page = request.page, pageSize = request.pageSize, recordCount = rowCount, result = true })); }