public ActionResult SaveForm(string keyValue, KbscameramanageEntity entity) { if (keyValue == "") { entity.State = "在线"; } kbscameramanagebll.SaveForm(keyValue, entity); //将新绑定的标签信息同步到后台计算服务中 return(Success("操作成功。")); }
/// <summary> /// 接口修改状态用方法 /// </summary> /// <param name="entity"></param> public void UpdateState(KbscameramanageEntity entity) { try { service.UpdateState(entity); } catch (Exception e) { throw; } }
public ActionResult SaveForm(KbscameramanageEntity entity, string keyValue) { try { if (!camerabll.UniqueCheck(entity.CameraId)) { throw new Exception("摄像头唯一编码已存在"); } camerabll.SaveEntity(keyValue, entity); return(Success("操作成功")); } catch (Exception ex) { return(Error(ex.Message)); } }
/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, KbscameramanageEntity entity) { try { service.SaveForm(keyValue, entity); RabbitMQHelper rh = RabbitMQHelper.CreateInstance(); SendData sd = new SendData(); if (keyValue == "") { sd.DataName = "AddCamera"; } else { sd.DataName = "UpdateCamera"; } sd.EntityString = JsonConvert.SerializeObject(entity); rh.SendMessage(JsonConvert.SerializeObject(sd)); } catch (Exception) { throw; } }
public string ImportCamera() { int error = 0; string message = "请选择格式正确的文件再导入!"; string falseMessage = ""; int count = HttpContext.Request.Files.Count; if (count > 0) { HttpPostedFileBase file = HttpContext.Request.Files[0]; if (string.IsNullOrEmpty(file.FileName)) { return(message); } if (!(file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xls") || file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx"))) { return(message); } string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName); file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName)); DataTable dt = ExcelHelper.ExcelImport(Server.MapPath("~/Resource/temp/" + fileName)); int order = 1; DistrictBLL districtbll = new DistrictBLL(); List <DistrictEntity> AreaList = districtbll.GetListByOrgIdAndParentId("", ""); DataItemDetailBLL dataItemDetailBLL = new DataItemDetailBLL(); List <DataItemModel> data = dataItemDetailBLL.GetDataItemListByItemCode("'CameraType'").ToList(); for (int i = 0; i < dt.Rows.Count; i++) { string CameraID = dt.Rows[i][0].ToString(); string CameraName = dt.Rows[i][1].ToString(); string CameraType = dt.Rows[i][2].ToString(); string CameraTypeId = ""; //区域 string AreaName = dt.Rows[i][3].ToString(); string AreaValue = ""; string AreaCode = ""; //楼层编号 string FloorNo = dt.Rows[i][4].ToString(); string CameraPoint = dt.Rows[i][5].ToString(); string CameraIp = dt.Rows[i][6].ToString(); if (string.IsNullOrEmpty(CameraID)) { falseMessage += "</br>" + "第" + (i + 2) + "摄像头ID为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(CameraName)) { falseMessage += "</br>" + "第" + (i + 2) + "摄像头名称为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(CameraType)) { falseMessage += "</br>" + "第" + (i + 2) + "摄像头类别为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(AreaName)) { falseMessage += "</br>" + "第" + (i + 2) + "区域名称为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(FloorNo)) { falseMessage += "</br>" + "第" + (i + 2) + "楼层编号为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(CameraPoint)) { falseMessage += "</br>" + "第" + (i + 2) + "摄像头坐标为空,未能导入."; error++; continue; } if (string.IsNullOrEmpty(CameraIp)) { falseMessage += "</br>" + "第" + (i + 2) + "IP地址为空,未能导入."; error++; continue; } var IP = @"(^(\d+)\.(\d+)\.(\d+)\.(\d+)$)";//@"/^(\d+)\.(\d+)\.(\d+)\.(\d+)$/g"; var point = @"(^\d{1,9}(.\d{1,2});\d{1,9}(.\d{1,2})$)"; ////验证是否是IP if (!Regex.IsMatch(CameraIp, IP)) { falseMessage += "</br>" + "第" + (i + 2) + "行IP地址格式填写错误,未能导入."; error++; continue; } ////验证是否是坐标 if (!Regex.IsMatch(CameraPoint, point)) { falseMessage += "</br>" + "第" + (i + 2) + "行坐标格式填写错误,格式应为xx.xx;xx.xx,未能导入."; error++; continue; } var ct = data.Where(it => it.ItemName == CameraType).FirstOrDefault(); if (ct == null) { falseMessage += "</br>" + "第" + (i + 2) + "行摄像头类别填写错误,未找到对应的摄像头类别,未能导入."; error++; continue; } CameraTypeId = ct.ItemValue; var area = AreaList.Where(it => it.DistrictName == AreaName).FirstOrDefault(); if (area == null) { falseMessage += "</br>" + "第" + (i + 2) + "行区域名称填写错误,未找到对应的区域,未能导入."; error++; continue; } AreaValue = area.DistrictID; AreaCode = area.DistrictCode; KbscameramanageEntity kbs = new KbscameramanageEntity(); kbs.AreaCode = AreaCode; kbs.AreaName = AreaName; kbs.CameraId = CameraID; kbs.CameraName = CameraName; kbs.CameraType = CameraType; kbs.FloorNo = FloorNo; kbs.OperuserName = OperatorProvider.Provider.Current().UserName; kbs.AreaId = AreaValue; kbs.CameraIP = CameraIp; kbs.CameraPoint = CameraPoint; kbs.CameraTypeId = Convert.ToInt32(CameraTypeId); kbs.State = "在线"; try { kbscameramanagebll.SaveForm("", kbs); } catch { error++; } } count = dt.Rows.Count; message = "共有" + count + "条记录,成功导入" + (count - error) + "条,失败" + error + "条"; message += "</br>" + falseMessage; } return(message); }
public void SaveEntity(string keyValue, KbscameramanageEntity entity) { service.SaveForm(keyValue, entity); }