/// <summary> /// 对设施采集设备编码进行更新 /// </summary> /// <param name="fas">设施采集设备</param> /// <param name="strCode1">编码1</param> /// <param name="strCode2">编码2</param> /// <param name="strCode3">编码3</param> private static void AquireCollectCode(FacilitySensorDeviceUnit fas, string strCode1, string strCode2, string strCode3) { var list = FacilitySensorDeviceUnit.FindAllByFacilityIdAndCollectDeviceId(fas.FacilityID, fas.SensorDeviceUnitID); //根据设施Id和采集设备Id查找设施采集设备 if (list.Count > 0) { if (!list[0].Code1.EqualIgnoreCase()) { fas.Code1 = list[0].Code1; //编码1不动 } else { fas.Code1 = ""; } //if (!list[0].Code2.EqualIgnoreCase()) //{ // fas.Code2 = list[0].Code2;//编码2不动 //} //else //{ // fas.Code2 = ""; //} //if (!list[0].Code3.EqualIgnoreCase()) //{ // fas.Code3 = list[0].Code3;//编码3不动 //} //else //{ // fas.Code3 = ""; //} } else { if (!strCode1.IsNullOrWhiteSpace()) { fas.Code1 = FacilitySensorDeviceUnit.GetCode1(fas.FacilityID); } if (!strCode2.IsNullOrWhiteSpace()) { fas.Code2 = FacilitySensorDeviceUnit.GetCode2(fas.FacilityID); } if (!strCode3.IsNullOrWhiteSpace()) { fas.Code3 = FacilitySensorDeviceUnit.GetCode3(fas.FacilityID); } } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { // if (this.lstFarm.SelectedItems.Count == 0) return; if (this.txtName.Text.Trim().Equals("")) { MessageBox.Show("名称不能为空,请输入"); this.txtName.Focus(); return; } //if (this.txtCode1.Text.Trim().Equals("")) //{ // MessageBox.Show("编码1不能为空,请输入"); // this.txtName.Focus(); // return; //} //if (this.txtCode2.Text.Trim().Equals("")) //{ // MessageBox.Show("编码2不能为空,请输入"); // this.txtName.Focus(); // return; //} //if (this.txtCode3.Text.Trim().Equals("")) //{ // MessageBox.Show("编码3不能为空,请输入"); // this.txtName.Focus(); // return; //} //if (this.txtCompanySerialNum.Text.Trim().Equals("")) //{ // MessageBox.Show("公司不能为空,请输入"); // this.txtName.Focus(); // return; //} //List<Facility> facilityList = (from item in this.lstFacility.Items.Cast<ListViewItem>() where item.Checked select item.Tag as Facility).ToList();//设施列表 if (this.farmId != 0) { try { #region 更新基地 var farm = Farm.FindByID(this.farmId); if (farm == null) { farm = new Farm(); farm.Code1 = this.txtCode1.Text; } farm.Code1 = this.txtCode1.Text.Trim(); farm.Code2 = this.txtCode2.Text.Trim(); farm.Code3 = this.txtCode3.Text.Trim(); farm.Name = this.txtName.Text.Trim(); farm.CompanySerialnum = this.txtCompanySerialNum.Text.Trim(); farm.Address = this.txtAddress.Text.Trim(); //PhotoUrl = this.pbPhotoUrl.Text, farm.Lotitude = this.txtLotitude.Text; farm.Latitude = this.txtLatitude.Text; farm.Area = Convert.ToInt32(this.txtArea.Text.Trim()); farm.ContactMan = this.txtContactMan.Text.Trim(); farm.ContactPhone = this.txtContactPhone.Text.Trim(); farm.ContactMobile = this.txtContactMobile.Text.Trim(); //Status = Convert.ToBoolean(this.cbStatus.SelectedValue), farm.Status = this.rbtOnlineStatus.Checked; //CreateTime = this.dtCreateTime.Value, farm.UpdateTime = Convert.ToDateTime(DateTime.Now.ToString("G")); farm.APIKey = this.txtAPIKey.Text; //Upload = Convert.ToBoolean(this.cbUpLoad.SelectedValue), //Upload=this.rbtUpLoad.Checked, //Version = Convert.ToInt32(this.txtVersion.Text), ////Introduce = this.lstIntroduce.Text, farm.Remark = this.txtPwd.Text; farm.Save(); this.farmId = farm.ID; #endregion 更新基地 //MessageBox.Show("更新成功"); } catch (Exception ex) { XTrace.WriteException(ex); MessageBox.Show("更新失败"); return; } } else { try { // 保存 var farm = new Farm(); farm.Code1 = this.txtCode1.Text.Trim(); farm.Code2 = this.txtCode2.Text.Trim(); farm.Code3 = this.txtCode3.Text.Trim(); farm.Name = this.txtName.Text.Trim(); farm.CompanySerialnum = this.txtCompanySerialNum.Text.Trim(); farm.Address = this.txtAddress.Text.Trim(); //PhotoUrl = this.pbPhotoUrl.Text, farm.Lotitude = this.txtLotitude.Text; farm.Latitude = this.txtLatitude.Text; farm.Area = Convert.ToInt32(this.txtArea.Text.Trim()); farm.ContactMan = this.txtContactMan.Text.Trim(); farm.ContactPhone = this.txtContactPhone.Text.Trim(); farm.ContactMobile = this.txtContactMobile.Text.Trim(); //Status = Convert.ToBoolean(this.cbStatus.SelectedValue), farm.Status = this.rbtOnlineStatus.Checked; //CreateTime = this.dtCreateTime.Value, farm.UpdateTime = Convert.ToDateTime(DateTime.Now.ToString("G")); farm.APIKey = this.txtAPIKey.Text; //Upload = Convert.ToBoolean(this.cbUpLoad.SelectedValue), //Upload=this.rbtUpLoad.Checked, //Version = Convert.ToInt32(this.txtVersion.Text), ////Introduce = this.lstIntroduce.Text, farm.Remark = this.txtPwd.Text; farm.Save(); this.farmId = farm.ID; //this.InitFacilityListView(); //MessageBox.Show("保存成功"); } catch (Exception ex) { XTrace.WriteException(ex); MessageBox.Show("新增失败"); return; } } try { var facilityListChecked = new List <Facility>(); var facilityListUnchecked = new List <Facility>(); foreach (ListViewItem item in this.lstFacility.Items) { if (item.Checked == false) { var facility = item.Tag as Facility; //设施 facilityListUnchecked.Add(facility); } else { //facilityListChecked = (from i in this.lstFacility.Items.Cast<ListViewItem>() where i.Checked select i.Tag as Facility).ToList();//显示数据 foreach (ListViewItem lvi in lstFacility.Items) { if (lvi.Checked) { facilityListChecked.Add(lvi.Tag as Facility); } } } } var farm = Farm.FindByID(farmId); //未选中的设施不能删除,只删除编码 foreach (var item in facilityListUnchecked) { if (item.FarmID == this.farmId) { item.Code1 = ""; item.FarmID = 0; item.Update(); //删除映射关系 item.FacilitySensorDeviceUnits.Delete(true); item.FacilityControlDeviceUnits.Delete(true); item.FacilityCameras.Delete(true); } } //更新基地设施 foreach (var item in facilityListChecked) { #region 更新设施 //Facility fac = new Facility(); //fac.ID = item.ID; //fac.FarmID = this.farmId; var fac = Facility.FindByID(item.ID); fac.FarmID = farm.ID; if (this.txtCode1.Text.IsNullOrWhiteSpace()) { fac.Code1 = ""; } else if (!this.txtCode1.Text.IsNullOrWhiteSpace() && !(fac.Code1 + "").StartsWith(farm.Code1)) { fac.Code1 = fac.GetCode1(); } fac.Update(); #endregion 更新设施 #region 设施下的采集设备的更新 IEnumerable <FacilitySensorDeviceUnit> facilitySensorDeviceUnits = FacilitySensorDeviceUnit.FindAllByFacilityID(fac.ID).ToList().OrderBy(fas => fas.ID); if (facilitySensorDeviceUnits.Count() > 0) { foreach (var fas in facilitySensorDeviceUnits) { if (fac.Code1.IsNullOrWhiteSpace()) { fas.Code1 = ""; } else if (!fac.Code1.IsNullOrWhiteSpace() && !(fas.Code1 + "").StartsWith(fac.Code1)) { //XTrace.WriteLine("-->" + fas.Code1 + " -- " + fas.GetCode1()); fas.Code1 = fas.GetCode1(); //XTrace.WriteLine("<--" + fas.Code1); } fas.Save(); } } #endregion 设施下的采集设备的更新 #region 设施下的控制设备的更新 IEnumerable <FacilityControlDeviceUnit> facilityControlDeviceUnits = FacilityControlDeviceUnit.FindAllByFacilityID(fac.ID).ToList().OrderBy(fas => fas.ID); if (facilityControlDeviceUnits.Count() > 0) { foreach (var fas in facilityControlDeviceUnits) { if (fac.Code1.IsNullOrWhiteSpace()) { fas.Code1 = ""; } else if (!fac.Code1.IsNullOrWhiteSpace() && !(fas.Code1 + "").StartsWith(fac.Code1)) { fas.Code1 = fas.GetCode1(); } fas.Update(); } } #endregion 设施下的控制设备的更新 #region 设施下的摄像机设备的更新 IEnumerable <FacilityCamera> facilityCameras = FacilityCamera.FindAllByFacilityID(fac.ID).ToList().OrderBy(fas => fas.ID); if (facilityCameras.Count() > 0) { foreach (var fas in facilityCameras) { if (fac.Code1.IsNullOrWhiteSpace()) { fas.Code1 = ""; } else if (!fac.Code1.IsNullOrWhiteSpace() && !(fas.Code1 + "").StartsWith(fac.Code1)) { fas.Code1 = fas.GetCode1(); } fas.Update(); } } #endregion 设施下的摄像机设备的更新 } this.InitFacilityListView(); this.InitList(); MessageBox.Show("操作成功"); } catch (Exception ex) { XTrace.WriteException(ex); MessageBox.Show("更新设备编码失败"); return; } this.farmId = 0; }
private void advTreeData_DragDrop(object sender, DragEventArgs e) { //var item = e.Data.GetData(e.Data.GetFormats()[0]); if (status) { var location = this.advTreeData.PointToClient(new Point(e.X, e.Y)); var node = this.advTreeData.GetNodeAt(location.X, location.Y); if (node != null && node.Tag.Equals(parent)) { #region 采集设备 if (parent.Equals("SensorDeviceUnit")) { var device = SensorDeviceUnit.FindByID(dragId); var faciliy = node.Parent.Tag as Facility; if (MessageBox.Show("确定要将该设备移动到该设施下吗?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { var dbList = FacilitySensorDeviceUnit.FindAllByFacilityIdAndCollectDeviceId(faciliy.ID, device.ID); if (dbList == null || dbList.Count == 0) { var fas = new FacilitySensorDeviceUnit() { FacilityID = faciliy.ID, SensorDeviceUnitID = device.ID }; fas.Code1 = fas.GetCode1(); int i = fas.Insert(); if (i != 0) { FacilitySensorDeviceUnit.DeleteByFacilityAndSensorDeviceunit(facId, device.ID);//删除原有关系 } } else { var fas = dbList[0]; if (!(fas.Code1 + "").StartsWith(faciliy.Code1)) { fas.Code1 = fas.GetCode1(); fas.Update(); } } } } #endregion #region 控制设备 if (parent.Equals("ControlDeviceUnit")) { var device = ControlDeviceUnit.FindByID(dragId); var faciliy = node.Parent.Tag as Facility; if (MessageBox.Show("确定要将该设备移动到该设施下吗?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { var dbList = FacilityControlDeviceUnit.FindAllByFacilityIdAndControlDeviceGroupNum(faciliy.ID, device.GroupNum); if (dbList == null || dbList.Count == 0) { var fas = new FacilityControlDeviceUnit() { FacilityID = faciliy.ID, ControlDeviceUnitGroupNum = device.GroupNum }; fas.Code1 = fas.GetCode1(); int i = fas.Insert(); if (i != 0) { FacilityControlDeviceUnit.DeleteByFacilityAndControlDeviceunGroupNum(facId, device.GroupNum);//删除原有关系 } } else { var fas = dbList[0]; if (!(fas.Code1 + "").StartsWith(faciliy.Code1)) { fas.Code1 = fas.GetCode1(); fas.Update(); } } InitData(); } } #endregion #region 视频设备 if (parent.Equals("Camera")) { var device = Camera.FindByID(dragId); var faciliy = node.Parent.Tag as Facility; if (MessageBox.Show("确定要将该设备移动到该设施下吗?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { var dbList = FacilityCamera.FindAllByFacilityIdAndCameraId(faciliy.ID, device.ID); if (dbList == null || dbList.Count == 0) { var fas = new FacilityCamera() { FacilityID = faciliy.ID, CameraID = device.ID }; fas.Code1 = fas.GetCode1(); int i = fas.Insert(); if (i != 0) { FacilityCamera.GetDeviceByFacilityIdAndCameraId(facId, device.ID);//删除原有关系 } } else { var fas = dbList[0]; if (!(fas.Code1 + "").StartsWith(faciliy.Code1)) { fas.Code1 = fas.GetCode1(); fas.Update(); } } InitData(); } } #endregion } } else { return; } InitData(); }
private void btnSave_Click(object sender, EventArgs e) { #region 判断条件 if (this.txtName.Text.IsNullOrWhiteSpace()) { MessageBox.Show("名称不能为空,请输入"); this.txtName.Focus(); return; } #endregion 判断条件 var facility = new Facility(); if (this.facilityId != 0) { #region 更新 facility = Facility.FindByID(this.facilityId); facility.Name = this.txtName.Text; facility.FacilityTypeSerialnum = this.cbFacilityType.SelectedValue.ToString(); facility.FarmID = Convert.ToInt32(this.cbFarm.SelectedValue); //facility.Code1 = facility.GetCode1(); //facility.Code2 = this.txtCode2.Text; //facility.Code3 = this.txtCode3.Text; facility.ContactPhone = this.txtContactPhone.Text; //facility.CreateTime = this.dtCreateTime.Value; facility.UpdateTime = DateTime.Now; //facility.Upload = this.rbtUpLoad.Checked; //facility.Version = Convert.ToInt32(this.txtVersion.Text); facility.Status = this.rbtOnlineStatus.Checked; facility.Address = this.txtAddress.Text; facility.Introduce = this.txtIntroduce.Text; facility.ContactMan = this.txtContactMan.Text; facility.ContactMobile = this.txtContactMobile.Text; //facility.Remark = this.txtRemark.Text; //facility.PhotoUrl = this.pbPhotoUrl.Text; try { // Facility.Update(facility); facility.Update(); } catch (Exception ex) { MessageBox.Show("更新失败" + ex.Message); } #endregion 更新 } else { #region 保存设施 facility.Name = this.txtName.Text; facility.FarmID = Convert.ToInt32(this.cbFarm.SelectedValue); if (!(facility.Code1 + "").StartsWith(facility.Farm.Code1 + "")) { facility.Code1 = facility.GetCode1(); } //if (!facility.Farm.Code2.IsNullOrWhiteSpace()) //{ // //facility.Code2 = facility.Farm.Code2 + "G00" + facility.ID; // facility.Code1 = Facility.GetCode2(facility.Farm.ID); //} //if (!facility.Farm.Code3.IsNullOrWhiteSpace()) //{ // //facility.Code3 = facility.Farm.Code3 + "G00" + facility.ID; // facility.Code1 = Facility.GetCode3(facility.Farm.ID); //} facility.FacilityTypeSerialnum = this.cbFacilityType.SelectedValue.ToString(); facility.FarmID = Convert.ToInt32(this.cbFarm.SelectedValue); facility.ContactPhone = this.txtContactPhone.Text; facility.CreateTime = DateTime.Now; facility.UpdateTime = DateTime.Now; //facility.Upload = Convert.ToBoolean(this.cbUpLoad.SelectedValue); //facility.Upload = this.rbtUpLoad.Checked; //facility.Version = Convert.ToInt32(this.txtVersion.Text); //facility.Status = Convert.ToBoolean(this.cbStatus.SelectedValue); facility.Status = this.rbtOnlineStatus.Checked; facility.Address = this.txtAddress.Text; facility.Introduce = this.txtIntroduce.Text; facility.ContactMan = this.txtContactMan.Text; facility.ContactMobile = this.txtContactMobile.Text; //facility.Remark = this.txtRemark.Text; //facility.PhotoUrl = this.pbPhotoUrl.Text; #endregion 保存设施 try { //Facility.Save(facility); facility.Insert(); } catch (Exception ex) { MessageBox.Show("新增失败" + ex); } } #region 获取所有选中的设备 //List<SensorDeviceUnit> sensorDeviceUnitList = (from item in this.listView2.Items.Cast<ListViewItem>() where item.Checked select item.Tag as SensorDeviceUnit).ToList(); var sensorDeviceUnitListChecked = new List <SensorDeviceUnit>(); var sensorDeviceUnitListUncheck = new List <SensorDeviceUnit>(); foreach (ListViewItem item in this.listView2.Items) { if (item.Checked == false) { var sensorDeviceUnit = item.Tag as SensorDeviceUnit; //未选中的采集设备 sensorDeviceUnitListUncheck.Add(sensorDeviceUnit); } else { sensorDeviceUnitListChecked = (from i in this.listView2.Items.Cast <ListViewItem>() where i.Checked select i.Tag as SensorDeviceUnit).ToList(); //选中的采集设备 } } //List<FacilityControlDeviceUnit> facilityControlDeviceUnitList = (from item in this.listView3.Items.Cast<ListViewItem>() where item.Checked select item.Tag as FacilityControlDeviceUnit).ToList();//控制设备 var controlDeviceUnitListChecked = new List <ControlDeviceUnit>(); var controlDeviceUnitListUnchecked = new List <ControlDeviceUnit>(); foreach (ListViewItem item in this.listView3.Items) { if (item.Checked == false) { var controlDeviceUnit = item.Tag as ControlDeviceUnit; //未选中的控制设备 controlDeviceUnitListUnchecked.Add(controlDeviceUnit); } else { controlDeviceUnitListChecked = (from i in this.listView3.Items.Cast <ListViewItem>() where i.Checked select i.Tag as ControlDeviceUnit).ToList(); //选中的控制设备 } } //List<FacilityCamera> facilityCameraList = (from item in this.listView4.Items.Cast<ListViewItem>() where item.Checked select item.Tag as FacilityCamera).ToList();//摄像机设备 var cameraListChecked = new List <Camera>(); var cameraListUnchecked = new List <Camera>(); foreach (ListViewItem item in this.listView4.Items) { if (item.Checked == false) { var camera = item.Tag as Camera; //未选中的摄像机设备 cameraListUnchecked.Add(camera); } else { cameraListChecked = (from i in this.listView4.Items.Cast <ListViewItem>() where i.Checked select i.Tag as Camera) .ToList(); //选中的摄像机设备 } } #endregion 获取所有选中的设备 #region 更新采集设备 foreach (var sensorDevice in sensorDeviceUnitListChecked) { var dbList = FacilitySensorDeviceUnit.FindAllByFacilityIdAndCollectDeviceId(this.facilityId, sensorDevice.ID); if (dbList == null || dbList.Count == 0) { var fas = new FacilitySensorDeviceUnit() { FacilityID = this.facilityId, SensorDeviceUnitID = sensorDevice.ID }; fas.Code1 = fas.GetCode1(); fas.Insert(); } else { var fas = dbList[0]; if (!(fas.Code1 + "").StartsWith(facility.Code1)) { fas.Code1 = fas.GetCode1(); fas.Update(); } } } foreach (var sensorDevice in sensorDeviceUnitListUncheck) { FacilitySensorDeviceUnit.DeleteByFacilityAndSensorDeviceunit(this.facilityId, sensorDevice.ID); } this.InitCollectDeviceListView(); #endregion 更新采集设备 #region 更新控制设备 foreach (var controlDevice in controlDeviceUnitListChecked) { var dbList = FacilityControlDeviceUnit.FindAllByFacilityIdAndControlDeviceGroupNum(this.facilityId, controlDevice.GroupNum); if (dbList == null || dbList.Count == 0) { var fac = new FacilityControlDeviceUnit() { FacilityID = this.facilityId, ControlDeviceUnitGroupNum = controlDevice.GroupNum, Name = controlDevice.Name.ToString().Substring(0, controlDevice.Name.ToString().IndexOf("-")) }; fac.Code1 = fac.GetCode1(); fac.Insert(); } else { var fac = dbList[0]; if (!(fac.Code1 + "").StartsWith(facility.Code1)) { fac.Code1 = fac.GetCode1(); fac.Update(); } } } foreach (var controlDevice in controlDeviceUnitListUnchecked) { FacilityControlDeviceUnit.DeleteByFacilityAndControlDeviceunGroupNum(this.facilityId, controlDevice.GroupNum); } this.InitControlDeviceListView(); #endregion 更新控制设备 #region 更新摄像机设备 foreach (var facilityCamera in cameraListChecked) { var dbList = FacilityCamera.FindAllByFacilityIdAndCameraId(this.facilityId, facilityCamera.ID); if (dbList == null || dbList.Count == 0) { var fac = new FacilityCamera() { FacilityID = this.facilityId, CameraID = facilityCamera.ID }; fac.Code1 = fac.GetCode1(); fac.Save(); } else { var fac = dbList[0]; if (!(fac.Code1 + "").StartsWith(facility.Code1)) { fac.Code1 = fac.GetCode1(); fac.Update(); } } } foreach (var camera in cameraListUnchecked) { FacilityCamera.DeleteByFacilityAndCamera(this.facilityId, camera.ID); } this.InitCameraDeviceListView(); #endregion 更新摄像机设备 this.InitFacilityListView(); MessageBox.Show("更新成功"); }
/// <summary> /// 加载树结构 /// </summary> private void InitTreeView() { this.treeView1.Nodes.Clear(); // 获取所有的设施列表 List <Facility> facilityList = Facility.FindAll(); if (facilityList.Count > 0 && facilityList.Any()) { var firstNode = new TreeNode(facilityList[0].FarmName) { Tag = "FisrtPag" }; this.treeView1.Nodes.Add(firstNode); foreach (var facility in facilityList) { var allnode = new TreeNode(facility.Name) { ImageIndex = 0, Tag = facility }; //采集设备 var collectnode = new TreeNode("采集设备") { ImageIndex = 1, Tag = "SensorDeviceUnit" }; List <FacilitySensorDeviceUnit> sensorDeviceUnitList = FacilitySensorDeviceUnit.FindAllByFacilityID(facility.ID); if (sensorDeviceUnitList == null) { return; } foreach (var sensorDeviceUnit in sensorDeviceUnitList) { var treeNode = new TreeNode(SensorDeviceUnit.FindByID(sensorDeviceUnit.SensorDeviceUnitID).Name.ToString()); treeNode.Tag = sensorDeviceUnit; collectnode.Nodes.Add(treeNode); } allnode.Nodes.Add(collectnode); //控制设备 var controlnode = new TreeNode("控制设备") { ImageIndex = 1, Tag = "ControlDeviceUnit" }; List <FacilityControlDeviceUnit> controlDeviceUnitList = FacilityControlDeviceUnit.FindAllByFacilityID(facility.ID); if (controlDeviceUnitList == null) { return; } foreach (var controlDeviceUnit in controlDeviceUnitList) { var treeNode = new TreeNode( ControlDeviceUnit.FindByGroupNum(controlDeviceUnit.ControlDeviceUnitGroupNum)[0].Name .ToString()); treeNode.Tag = controlDeviceUnit; controlnode.Nodes.Add(treeNode); } allnode.Nodes.Add(controlnode); ////摄像机设备 //var cameranode = new TreeNode("摄像机设备") { ImageIndex = 1, Tag = "facilityCamera" }; //List<FacilityCamera> cameraList = FacilityCamera.FindAllByFacilityID(facility.ID); //if (cameraList == null) //{ // return; //} //foreach (FacilityCamera facilityCamera in cameraList) //{ // var treeNode = new TreeNode(facilityCamera.CameraName); // treeNode.Tag = facilityCamera; // cameranode.Nodes.Add(treeNode); //} //allnode.Nodes.Add(cameranode); ////展示设备 //var showDevicenode = new TreeNode("显示设备") { ImageIndex = 1, Tag = "showDevice" }; //List<ShowDevice> showDeviceList = ShowDevice.FindAll(); //if (showDeviceList == null) //{ // return; //} //foreach (ShowDevice showDevice in showDeviceList) //{ // var treeNode = new TreeNode(showDevice.Name); // treeNode.Tag = showDevice; // showDevicenode.Nodes.Add(treeNode); //} //allnode.Nodes.Add(showDevicenode); this.treeView1.Nodes.Add(allnode); } this.treeView1.ExpandAll(); } }
/// <summary> /// 查询数据 /// </summary> /// <param name="id"> /// </param> private void SearchDataInfo(int id, string tag) { this.listView1.Items.Clear(); if (tag.EqualIgnoreCase("SensorDeviceUnit")) { string data; var fs = FacilitySensorDeviceUnit.FindByID(id); if (fs.SensorDeviceUnit.Sensor.Code.EqualIgnoreCase("collect-weather-YuXueGanZhi")) { data = fs.SensorDeviceUnit.ProcessedValue == 1 ? "有" : "无"; } else { data = fs.SensorDeviceUnit.ProcessedValue.ToString(); } var strings = new[] { fs.Code1, fs.SensorDeviceUnit.Name, data, fs.SensorDeviceUnit.Sensor.Unit, fs.SensorDeviceUnit.UpdateTime.ToString() }; var listViewItem = new ListViewItem(strings); this.listView1.Items.Add(listViewItem); } else if (tag.EqualIgnoreCase("ControlDeviceUnit")) { string data; var controlList = ControlDeviceUnit.FindByGroupNum(id); if (controlList.Count > 0) { controlList.ForEach(c => { data = c.ProcessedValue; var strings = new[] { c.FacilityControlDeviceUnits[0].Code1, c.Name, data, "", c.UpdateTime.ToString() }; var listViewItem = new ListViewItem(strings); this.listView1.Items.Add(listViewItem); }); } } var fsList = FacilitySensorDeviceUnit.FindAllByFacilityID(id); var fcList = FacilityControlDeviceUnit.FindAllByFacilityID(id); string data1; if (fsList.Count > 0) { fsList.ForEach( fs => { if (fs.SensorDeviceUnit.Sensor.Code.EqualIgnoreCase("collect-weather-YuXueGanZhi")) { data1 = fs.SensorDeviceUnit.ProcessedValue == 1 ? "有" : "无"; } else { data1 = fs.SensorDeviceUnit.ProcessedValue.ToString(); } var strings = new[] { fs.Code1, fs.SensorDeviceUnit.Name, data1, fs.SensorDeviceUnit.Sensor.Unit, fs.SensorDeviceUnit.UpdateTime.ToString() }; var listViewItem = new ListViewItem(strings); this.listView1.Items.Add(listViewItem); }); } if (fcList.Count > 0) { fcList.ForEach(fc => { var controls = ControlDeviceUnit.FindByGroupNum(fc.ControlDeviceUnitGroupNum); controls.ForEach(control => { data1 = control.ProcessedValue; var strings = new[] { fc.Code1, control.Name, data1, "", control.UpdateTime.ToString() }; var listViewItem = new ListViewItem(strings); this.listView1.Items.Add(listViewItem); }); }); } }
/// <summary> /// 同步采集设备 /// </summary> /// <returns></returns> private bool SyncCollectDevices() { //System.Threading.Thread.Sleep(50); var syncResult = false; //采集设备 var collectDevices = FacilitySensorDeviceUnit.FindAllWithCache() .ToList() .Where(c => c.Code1.Substring(13, 1).EqualIgnoreCase("C")); var facilitySensorDeviceUnits = collectDevices as FacilitySensorDeviceUnit[] ?? collectDevices.ToArray(); if (facilitySensorDeviceUnits.Any()) { //逐个上传设备数据 facilitySensorDeviceUnits.ToList().ForEach(cd => { var code = cd.Code1; var dev = cd.SensorDeviceUnit; #region 构建DeviceModel var deviceModel = new DeviceModel { Serialnum = code, Name = dev.Name, DeviceTypeSerialnum = dev.Sensor.DeviceTypeSerialnum, FacilitySerialnum = cd.Facility.Code1, ProcessedValue = dev.ProcessedValue, ShowValue = dev.ShowValue, Unit = dev.Sensor.Unit, Max = dev.Sensor.ExperienceMax, Min = dev.Sensor.ExperienceMin, UpdateTime = dev.UpdateTime }; #endregion 构建DeviceModel var entity = AwEntityHelper.GetEntity(cd.Facility.Farm.Code1); #if DEBUG var sw = new Stopwatch(); sw.Start(); #endif try { var trans = ApiTransportHelper.GetTransport(); var responseResult = _deviceApi.QueryDevice(entity, trans, deviceModel.Serialnum); if (responseResult.Data != null) //判断远程数据库中是否已经存在该设备 { var entity1 = AwEntityHelper.GetEntity(cd.Facility.Farm.Code1); var result = _deviceApi.UpdateDevice(entity1, trans, deviceModel); //设备单个上传 trans.Dispose(); LogHelper.Debug("更新设备{0}:{1}", deviceModel.Serialnum, result ? "成功" : "失败"); syncResult = result; } else { var entity1 = AwEntityHelper.GetEntity(cd.Facility.Farm.Code1); var result = _deviceApi.AddDevice(entity1, trans, deviceModel); //设备单个上传 trans.Dispose(); LogHelper.Debug("添加设备{0}:{1}", deviceModel.Serialnum, result ? "成功" : "失败"); syncResult = result; } } catch (Exception ex) { LogHelper.Fatal(ex.ToString()); } #if DEBUG sw.Stop(); var apiAccesslog = new ApiAccessLog { ApiName = "同步采集设备", Result = syncResult, CreateTime = DateTime.Now, CostTime = Convert.ToInt32(sw.ElapsedMilliseconds) }; apiAccesslog.Save(); LogHelper.Debug("同步采集设备耗时" + sw.ElapsedMilliseconds.ToString() + "ms"); #endif }); } //return syncResult; return(true); }