/// <summary> /// 增加区域 /// </summary> /// <param name="areaName"></param> /// <param name="schoolID"></param> /// <param name="remark"></param> /// <returns></returns> public bool AddSchoolAreaPart(string areaName, int schoolID, string remark) { try { SchoolAreaInfo schoolArea = new SchoolAreaInfo(); schoolArea.SAI_Name = areaName; schoolArea.SI_ID = schoolID; schoolArea.SAI_Remark = remark; _dataContext.SchoolAreaInfos.InsertOnSubmit(schoolArea); _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// 修改区域 /// </summary> /// <param name="areaID"></param> /// <param name="schoolID"></param> /// <param name="areaName"></param> /// <param name="remark"></param> /// <returns></returns> public bool ModifySchoolAreaPartInfo(int areaID, int schoolID, string areaName, string remark) { try { SchoolAreaInfo schoolArea = _dataContext.SchoolAreaInfos.Single(x => x.SAI_ID == areaID); if (schoolID > 0 && schoolID != schoolArea.SI_ID) { schoolArea.SI_ID = schoolID; // 修改AMP表中对应的区域校区 if (_dataContext.AnalogMeasurePoints.Where(x => x.AMP_SAreaID == areaID).Count() > 0) { _dataContext.ExecuteCommand("update AnalogMeasurePoint set AMP_SchooldID={0} where AMP_SAreaID={1}", schoolID, areaID); // 修改父测点编号 var modifiedAMPs = _dataContext.AnalogMeasurePoints.Where(x => x.AMP_SAreaID == areaID && x.AMP_BuildingID == 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_SchooldID == schoolID && x.AMP_SAreaID == 0 && x.AMP_PowerType == item.AMP_PowerType).SingleOrDefault(); if (parentPoint != null) { item.AMP_ParentNo = parentPoint.AMP_AnalogNo; } else { item.AMP_ParentNo = 0; } } } } schoolArea.SAI_Name = areaName; schoolArea.SAI_Remark = remark; _dataContext.SubmitChanges(); return(true); } catch (Exception) { return(false); } }