public bool ModifyBuildingOperateRule(int buildingID, string operateRule) { try { BuildingBriefInfo bBriefInfo = _dataContext.BuildingBriefInfos.Where(x => x.BDI_ID == buildingID).SingleOrDefault(); bBriefInfo.BDI_OperateRule = operateRule; _dataContext.SubmitChanges(); return(true); }catch (Exception) { return(false); } }
public bool ModifyBuildingHJFlag(int buildingID, byte hJFlag) { try { BuildingBriefInfo bBriefInfo = _dataContext.BuildingBriefInfos.Where(x => x.BDI_ID == buildingID).SingleOrDefault(); bBriefInfo.BDI_HJFlag = hJFlag; _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 修改楼宇 /// </summary> /// <param name="buildingID"></param> /// <param name="areaID"></param> /// <param name="buildingName"></param> /// <param name="buildingCode"></param> /// <returns></returns> public bool ModifyBuildingPart(int buildingID, int areaID, string buildingName, string buildingCode) { try { BuildingBriefInfo bb = _dataContext.BuildingBriefInfos.Single(x => x.BDI_ID == buildingID); if (bb.SAI_ID != areaID) { // 修改建筑信息本身的区域ID bb.SAI_ID = areaID; // 修改AMP表中对应的建筑区域 if (_dataContext.AnalogMeasurePoints.Where(x => x.AMP_BuildingID == bb.BDI_ID).Count() > 0) { _dataContext.ExecuteCommand("update AnalogMeasurePoint set AMP_SAreaID={0} where AMP_BuildingID={1}", areaID, bb.BDI_ID); // 修改父测点编号 var modifiedAMPs = _dataContext.AnalogMeasurePoints.Where(x => x.AMP_BuildingID == bb.BDI_ID && x.AMP_RoomID == 0 && x.AMP_ParentNo > 1).ToList(); foreach (var item in modifiedAMPs) { var parentPoint = _dataContext.AnalogMeasurePoints.Where(x => x.AMP_CptFlag == 0 && x.AMP_Statistic == 1 && x.AMP_SAreaID == areaID && x.AMP_BuildingID == 0 && x.AMP_PowerType == item.AMP_PowerType).SingleOrDefault(); if (parentPoint != null) { item.AMP_ParentNo = parentPoint.AMP_AnalogNo; } else { item.AMP_ParentNo = 0; } } } } bb.BDI_Name = buildingName; BuildingDetailInfo bd = _dataContext.BuildingDetailInfos.Single(x => x.BDI_ID == buildingID); bd.BDI_Name = buildingName; bd.BDI_Code = buildingCode; _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 增加楼宇 /// </summary> /// <param name="b"></param> /// <param name="areaID"></param> /// <returns>成功返回新的楼宇ID,否则返回0</returns> public int AddBuilding(BuildingDetailInfo b, int areaID) { try { _dataContext.BuildingDetailInfos.InsertOnSubmit(b); _dataContext.SubmitChanges(); BuildingBriefInfo bb = new BuildingBriefInfo(); bb.BDI_ID = b.BDI_ID; bb.BDI_Name = b.BDI_Name; bb.SAI_ID = areaID; bb.BDI_Flag = 1; _dataContext.BuildingBriefInfos.InsertOnSubmit(bb); _dataContext.SubmitChanges(); return(b.BDI_ID); } catch (Exception) { return(0); } }
/// <summary> /// 增加楼宇 /// </summary> /// <param name="buildingName"></param> /// <param name="areaID"></param> /// <param name="buildingCode"></param> /// <returns></returns> public bool AddBuildingPart(string buildingName, int areaID, string buildingCode) { try { BuildingDetailInfo bd = new BuildingDetailInfo(); bd.BDI_Name = buildingName; bd.BDI_Code = buildingCode; _dataContext.BuildingDetailInfos.InsertOnSubmit(bd); _dataContext.SubmitChanges(); BuildingBriefInfo bb = new BuildingBriefInfo(); bb.BDI_ID = bd.BDI_ID; bb.BDI_Name = buildingName; bb.SAI_ID = areaID; _dataContext.BuildingBriefInfos.InsertOnSubmit(bb); _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 修改建筑 /// </summary> /// <param name="b"></param> /// <param name="areaID"></param> /// <returns></returns> public bool ModifyBuilding(BuildingDetailInfo b, int areaID) { try { BuildingBriefInfo bb = _dataContext.BuildingBriefInfos.SingleOrDefault(x => x.BDI_ID == b.BDI_ID); if (bb.SAI_ID != areaID) { // 修改建筑信息本身的区域ID bb.SAI_ID = areaID; // 修改AMP表中对应的建筑区域 if (_dataContext.AnalogMeasurePoints.Where(x => x.AMP_BuildingID == bb.BDI_ID).Count() > 0) { _dataContext.ExecuteCommand("update AnalogMeasurePoint set AMP_SAreaID={0} where AMP_BuildingID={1}", areaID, bb.BDI_ID); // 修改父测点编号 var modifiedAMPs = _dataContext.AnalogMeasurePoints.Where(x => x.AMP_BuildingID == bb.BDI_ID && x.AMP_RoomID == 0 && x.AMP_ParentNo > 1).ToList(); foreach (var item in modifiedAMPs) { var parentPoint = _dataContext.AnalogMeasurePoints.Where(x => x.AMP_CptFlag == 0 && x.AMP_Statistic == 1 && x.AMP_SAreaID == areaID && x.AMP_BuildingID == 0 && x.AMP_PowerType == item.AMP_PowerType).SingleOrDefault(); if (parentPoint != null) { item.AMP_ParentNo = parentPoint.AMP_AnalogNo; } else { item.AMP_ParentNo = 0; } } } } bb.BDI_Name = b.BDI_Name; BuildingDetailInfo bd = _dataContext.BuildingDetailInfos.SingleOrDefault(x => x.BDI_ID == b.BDI_ID); bd.BDI_Name = b.BDI_Name; bd.BDI_Address = b.BDI_Address; bd.BDI_Code = b.BDI_Code; bd.BDI_Introduction = b.BDI_Introduction; bd.BDI_Telephone = b.BDI_Telephone; bd.BDI_LinkMan = b.BDI_LinkMan; bd.BDI_LinkManPhone = b.BDI_LinkManPhone; bd.BDI_StatMan = b.BDI_StatMan; bd.BDI_StatManPhone = b.BDI_StatManPhone; bd.BDI_Academy = b.BDI_Academy; bd.BDI_Date = b.BDI_Date; bd.BDI_Direction = b.BDI_Direction; bd.BDI_Users = b.BDI_Users; bd.BDI_RunPerWeek = b.BDI_RunPerWeek; bd.BDI_WeekStart = b.BDI_WeekStart; bd.BDI_WeekEnd = b.BDI_WeekEnd; bd.BDI_RunPreMonth = b.BDI_RunPreMonth; bd.BDI_MonthStart = b.BDI_MonthStart; bd.BDI_MonthEnd = b.BDI_MonthEnd; bd.BDI_RunPerYear = b.BDI_RunPerYear; bd.BDI_YearStart = b.BDI_YearStart; bd.BDI_YearEnd = b.BDI_YearEnd; bd.BDI_Holiday = b.BDI_Holiday; bd.BDI_Height = b.BDI_Height; bd.BDI_FloorUp = b.BDI_FloorUp; bd.BDI_FloorDn = b.BDI_FloorDn; bd.BDI_FloorHeight = b.BDI_FloorHeight; bd.BDI_Area = b.BDI_Area; bd.BDI_AreaAir = b.BDI_AreaAir; bd.BDI_AreaHot = b.BDI_AreaHot; bd.BDI_AreaSpe = b.BDI_AreaSpe; bd.BDI_AauditFlag = b.BDI_AauditFlag; bd.BDI_AauditDate = b.BDI_AauditDate; bd.BDI_TransforFlag = b.BDI_TransforFlag; bd.BDI_TransforContent = b.BDI_TransforContent; bd.BDI_ElectricCompName = b.BDI_ElectricCompName; bd.BDI_GasCompName = b.BDI_GasCompName; bd.BDI_Type = b.BDI_Type; bd.BDI_TypeOther = b.BDI_TypeOther; bd.BDI_AreaRatio = b.BDI_AreaRatio; bd.BDI_KindsOut = b.BDI_KindsOut; bd.BDI_WarmKeep = b.BDI_WarmKeep; bd.BDI_Structure = b.BDI_Structure; bd.BDI_WinOut = b.BDI_WinOut; bd.BDI_Visor = b.BDI_Visor; bd.BDI_Glass = b.BDI_Glass; bd.BDI_Win = b.BDI_Win; bd.BDI_TemCool = b.BDI_TemCool; bd.BDI_TemHot = b.BDI_TemHot; bd.BDI_TemSepcialCool = b.BDI_TemSepcialCool; bd.BDI_TemSepcialHot = b.BDI_TemSepcialHot; bd.BDI_AirSys = b.BDI_AirSys; bd.BDI_DevCool = b.BDI_DevCool; bd.BDI_DevHot = b.BDI_DevHot; bd.BDI_LiBr = b.BDI_LiBr; bd.BDI_BoilerPower = b.BDI_BoilerPower; bd.BDI_AirSplit = b.BDI_AirSplit; bd.BDI_Boiler = b.BDI_Boiler; bd.BDI_PowerHot = b.BDI_PowerHot; bd.BDI_DevOther = b.BDI_DevOther; bd.BDI_LightIn = b.BDI_LightIn; bd.BDI_LightOut = b.BDI_LightOut; bd.BDI_LightOutPower = b.BDI_LightOutPower; bd.BDI_LightOutWorkHours = b.BDI_LightOutWorkHours; if (!String.IsNullOrWhiteSpace(b.BDI_ImageUrl)) { bd.BDI_ImageUrl = b.BDI_ImageUrl; } _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
public BuildingBriefInfo GetBuildingByBuildingID(int buildingID) { BuildingBriefInfo bBriefInfo = _dataContext.BuildingBriefInfos.Where(x => x.BDI_ID == buildingID).SingleOrDefault(); return(bBriefInfo); }