/// <summary> /// 修改用户所属房间 /// </summary> /// <param name="userID">用户ID</param> /// <param name="oldRoomID">原来房间ID</param> /// <param name="newRoomID">新房间ID</param> /// <returns></returns> public bool ModifyUserRoom(string userID, int oldRoomID, int newRoomID) { UserRoom ur = null; if (newRoomID == 0) { return(false); } if (oldRoomID == 0) { ur = new UserRoom { USR_ID = userID, RI_ID = newRoomID }; _dataContext.UserRooms.InsertOnSubmit(ur); } else { ur = _dataContext.UserRooms.FirstOrDefault(p => p.USR_ID == userID && p.RI_ID == oldRoomID); ur.RI_ID = newRoomID; } try { _dataContext.SubmitChanges(); return(true); } catch (ChangeConflictException) { return(false); } }
/// <summary> /// 删除校区 /// </summary> /// <param name="schoolID"></param> /// <returns></returns> public bool DeleteSchool(int schoolID) { try { _dataContext.SchoolInfos.DeleteOnSubmit(_dataContext.SchoolInfos.Single(p => p.SI_ID == schoolID)); _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 添加部门 /// </summary> /// <param name="department"></param> /// <returns></returns> public bool AddDepartment(DepartmentInfo department) { try { _dataContext.DepartmentInfos.InsertOnSubmit(department); _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 添加类型 /// </summary> /// <param name="pc"></param> /// <returns></returns> public bool AddPower(PowerClass pc) { try { _dataContext.PowerClasses.InsertOnSubmit(pc); _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 增加模拟量 /// </summary> /// <param name="ai"></param> /// <returns>增加成功返回大于0的编号,否则返回0</returns> public int AddAnalogInfo(AnalogInfo ai) { try { _dataContext.AnalogInfos.InsertOnSubmit(ai); _dataContext.SubmitChanges(); return(ai.AI_No); } catch (Exception) { return(0); } }
public bool AddAnnouncementInfo(IList <AnnouncementInfo> amiList) { try { _dataContext.AnnouncementInfos.InsertAllOnSubmit(amiList); _dataContext.SubmitChanges(); return(true); } catch (Exception e) { System.Console.WriteLine(e.Message); return(false); } }
/// <summary> /// 添加角色 /// </summary> /// <param name="roleName"></param> /// <returns>返回添加生成的ID,失败返回-1</returns> public int AddRole(string roleName) { try { Role role = new Role(); role.RL_Name = roleName; role.RL_Status = true; _dataContext.Roles.InsertOnSubmit(role); _dataContext.SubmitChanges(); return(role.RL_ID); } catch (Exception) { return(-1); } }
public bool ModifyUpdateInfoOfTime(UpdateInfo ui) { try { UpdateInfo uii = _dataContext.UpdateInfos.Where(x => x.ID == ui.ID).Single(); uii.Start_Date = ui.Start_Date; uii.End_Date = ui.End_Date; _dataContext.SubmitChanges(); return(true); } catch (Exception e) { System.Console.Write(e.Message); return(false); } }
public bool ModifyOrAddBEC(int buildingID, int year, string powerType, double Val) { try { var count = _dataContext.BuildingEnergyConsums.Where(x => x.BEC_BID == buildingID && x.BEC_Year == year && x.BEC_PowerType == powerType).Count(); if (count > 0) { var item = _dataContext.BuildingEnergyConsums.Where(x => x.BEC_BID == buildingID && x.BEC_Year == year && x.BEC_PowerType == powerType).Single(); item.BEC_Consum = Val; } else { var newItem = new BuildingEnergyConsum(); newItem.BEC_BID = buildingID; newItem.BEC_Year = year; newItem.BEC_PowerType = powerType; newItem.BEC_Consum = Val; _dataContext.BuildingEnergyConsums.InsertOnSubmit(newItem); } _dataContext.SubmitChanges(); return(true); } catch (Exception e) { return(false); } }
/// <summary> /// 增加测点 /// </summary> /// <param name="amp"></param> /// <returns></returns> public bool AddAMP(AnalogMeasurePoint amp) { try { //if (!amp.AMP_ParentNo.HasValue || amp.AMP_ParentNo.Value <= 0) //{ // int parentNo = 0; // AnalogMeasurePoint tempAMP = null; // if (amp.AMP_RoomID > 0) // { // tempAMP = _dataContext.AnalogMeasurePoints.FirstOrDefault(x => x.AMP_CptFlag == 0 && x.AMP_Statistic == 1 && x.AMP_PowerType == amp.AMP_PowerType && x.AMP_BuildingID == amp.AMP_BuildingID && x.AMP_RoomID == 0); // } // else if (amp.AMP_BuildingID > 0) // { // tempAMP = _dataContext.AnalogMeasurePoints.FirstOrDefault(x => x.AMP_CptFlag == 0 && x.AMP_Statistic == 1 && x.AMP_PowerType == amp.AMP_PowerType && x.AMP_SAreaID == amp.AMP_SAreaID && x.AMP_BuildingID == 0); // } // else if (amp.AMP_SAreaID > 0) // { // tempAMP = _dataContext.AnalogMeasurePoints.FirstOrDefault(x => x.AMP_CptFlag == 0 && x.AMP_Statistic == 1 && x.AMP_PowerType == amp.AMP_PowerType && x.AMP_SchooldID == amp.AMP_SchooldID && x.AMP_SAreaID == 0); // } // if (tempAMP != null) // { // parentNo = tempAMP.AMP_AnalogNo; // } // amp.AMP_ParentNo = parentNo; //} _dataContext.AnalogMeasurePoints.InsertOnSubmit(amp); _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 增加日志 /// </summary> /// <param name="log"></param> /// <returns></returns> public bool AddLog(Log log) { try { _dataContext.Logs.InsertOnSubmit(log); _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
public bool BatchAddRealPoints(IList <Models.LinqEntity.AnalogInfo> aiList, IList <Models.LinqEntity.AnalogMeasurePoint> ampList) { try { _dataContext.AnalogInfos.InsertAllOnSubmit(aiList); for (int i = 0; i < aiList.Count; i++) { ampList[i].AMP_AnalogNo = aiList[i].AI_No; } _dataContext.AnalogMeasurePoints.InsertAllOnSubmit(ampList); _dataContext.SubmitChanges(); return(true); } catch (Exception e) { throw e; } }
/// <summary> /// 根据键值对修改系统参数 /// </summary> /// <param name="newDic"></param> /// <returns></returns> public bool Modify(IDictionary newDic) { try { foreach (var key in newDic.Keys) { var query = _dataContext.SystemProfiles.SingleOrDefault(x => x.SP_ID == key); var newVal = newDic[key].ToString(); if (query.SP_Value != newVal) { query.SP_Value = newVal; } } _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 添加角色功能 /// </summary> /// <param name="roleID"></param> /// <param name="funIDs"></param> /// <returns></returns> public bool AddRoleFuns(int roleID, string[] funIDs) { try { var list = new List <RoleFunction>(); foreach (string funID in funIDs) { RoleFunction rf = new RoleFunction(); rf.RF_RoleID = roleID; rf.RF_FunID = funID; list.Add(rf); } _dataContext.RoleFunctions.InsertAllOnSubmit(list); _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 更新图表中的所有状态的位置 /// </summary> /// <param name="list"></param> /// <returns></returns> public bool UpdateStatePosition(List <StateReal> list) { try { var modifyList = _dataContext.StateReals.Where(x => x.SR_Type != "C").ToList(); foreach (var item in list) { var modify = modifyList.SingleOrDefault(x => x.SR_Type == item.SR_Type && x.SR_No == item.SR_No); if (modify != null) { modify.SR_PositionX = item.SR_PositionX; modify.SR_PositionY = item.SR_PositionY; } } _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 修改邮箱 /// </summary> /// <param name="userID">用户ID</param> /// <param name="newMail">新邮箱</param> /// <param name="activeStr">邮箱激活码</param> /// <returns>修改成功返回true,否则返回false</returns> public bool ModifyMail(string userID, string newMail, string activeStr) { User user = _dataContext.Users.FirstOrDefault(u => u.USR_ID == userID); if (user != null) { user.USR_Mail = newMail; user.USR_MailActiveCode = activeStr; try { _dataContext.SubmitChanges(); return(true); } catch (ChangeConflictException) { return(false); } } else { return(false); } }
/// <summary> /// 根据键值对修改机器管理人员邮箱 /// </summary> /// <param name="newDic"></param> /// <returns></returns> public bool ModifyEmail(IDictionary newDic) { try { foreach (var key in newDic.Keys) { var query = _dataContext.SetEmail.SingleOrDefault(x => (x.SE_EmailNo - 1).ToString() == key.ToString()); var newVal = newDic[key].ToString(); if (query.SE_Email != newVal) { query.SE_Email = newVal; } } _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 删除楼宇及相关设备信息 /// </summary> /// <param name="buildingID"></param> /// <returns></returns> public bool DeleteBuilding(int buildingID) { try { _dataContext.BuildingDetailInfos.DeleteOnSubmit(_dataContext.BuildingDetailInfos.SingleOrDefault(x => x.BDI_ID == buildingID)); _dataContext.BuildingBriefInfos.DeleteOnSubmit(_dataContext.BuildingBriefInfos.SingleOrDefault(x => x.BDI_ID == buildingID)); _dataContext.LightDetails.DeleteAllOnSubmit(_dataContext.LightDetails.Where(x => x.BDI_ID == buildingID)); _dataContext.ElevatorDetails.DeleteAllOnSubmit(_dataContext.ElevatorDetails.Where(x => x.BDI_ID == buildingID)); _dataContext.WaterPumpDetails.DeleteAllOnSubmit(_dataContext.WaterPumpDetails.Where(x => x.BDI_ID == buildingID)); _dataContext.WindMachDetails.DeleteAllOnSubmit(_dataContext.WindMachDetails.Where(x => x.BDI_ID == buildingID)); _dataContext.KitchenEquipDetails.DeleteAllOnSubmit(_dataContext.KitchenEquipDetails.Where(x => x.BDI_ID == buildingID)); _dataContext.OfficeEquipDetails.DeleteAllOnSubmit(_dataContext.OfficeEquipDetails.Where(x => x.BDI_ID == buildingID)); _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }