/// <summary>
/// 删除指定邮箱
/// </summary>
/// <param name="emailName"></param>
/// <returns></returns>
public bool DeleteEmail(string emailName)
{
try
{
if (_dataContext.ExecuteCommand(@"delete from SetEmail where SE_Email = '" + emailName + "' ") > 0)
{
return(true);
}
return(false);
}
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="pno"></param>
/// <returns></returns>
public bool DeleteAMP(int pno)
{
try
{
var amp = _dataContext.AnalogMeasurePoints.SingleOrDefault(x => x.AMP_AnalogNo == pno);
if (amp != null)
{
if (_dataContext.AnalogMeasurePoints.Where(x => x.AMP_ParentNo == amp.AMP_AnalogNo).Count() > 0)
{
// 更新父测点为该测点的测点的父测点编号为0
_dataContext.ExecuteCommand("update AnalogMeasurePoint set AMP_ParentNo=0 where AMP_ParentNo={0}", amp.AMP_AnalogNo);
}
_dataContext.AnalogMeasurePoints.DeleteOnSubmit(amp);
// 删除该测点的历史值
_dataContext.ExecuteCommand("delete from AnalogHistory where AH_AnalogNo={0}", amp.AMP_AnalogNo);
_dataContext.SubmitChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 删除角色拥有的功能
/// </summary>
/// <param name="roleID"></param>
/// <returns></returns>
public bool DeleteRoleFuns(int roleID)
{
try
{
if (_dataContext.ExecuteCommand(@"delete from RoleFunction where RF_RoleID=" + roleID) > 0)
{
return(true);
}
return(false);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 修改能耗类型
/// </summary>
/// <param name="pc"></param>
/// <returns></returns>
public bool ModifyPower(PowerClass pc)
{
try
{
PowerClass oldPC = _dataContext.PowerClasses.Single(x => x.PC_ID == pc.PC_ID);
oldPC.PC_ID = pc.PC_ID;
oldPC.PC_Name = pc.PC_Name;
oldPC.PC_Type = pc.PC_Type;
oldPC.PC_LocalCode = pc.PC_LocalCode;
oldPC.PC_Unit = pc.PC_Unit;
oldPC.PC_Remark = pc.PC_Remark;
_dataContext.SubmitChanges();
// 检查AMP表中是否已经使用该类型，如果使用同时需要修改能耗类型名称
if (_dataContext.AnalogMeasurePoints.Where(x => x.AMP_PowerType == pc.PC_ID).Count() > 0)
{
_dataContext.ExecuteCommand("update AnalogMeasurePoint set AMP_PowerName={0} where AMP_PowerType={1}", pc.PC_Name, pc.PC_ID);
}
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 修改用户上次登录时间和IP
/// </summary>
/// <param name="userID">用户ID</param>
/// <param name="loginTime">上次登录时间</param>
/// <param name="loginIP">上次登录IP</param>
/// <returns>true修改成功</returns>
public bool ModifyUserInfo(string userID, string loginTime, string loginIP)
{
int count = _dataContext.ExecuteCommand("update Users set USR_LastLoginTime={0},"
+ "USR_LastLoginIP={1} "
+ "where USR_ID={2}",
loginTime, loginIP, userID);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改房间
/// </summary>
/// <param name="roomID"></param>
/// <param name="roomCode"></param>
/// <param name="buildingID"></param>
/// <param name="floor"></param>
/// <param name="remark"></param>
/// <returns></returns>
public bool ModifyRoomPart(int roomID, string roomCode, int buildingID, int?floor, string remark)
{
try
{
RoomInfo room = _dataContext.RoomInfos.Single(x => x.RI_ID == roomID);
room.RI_RoomCode = roomCode;
if (room.BDI_ID != buildingID)
{
room.BDI_ID = buildingID;
// 修改AMP表中对应的房间建筑
if (_dataContext.AnalogMeasurePoints.Where(x => x.AMP_RoomID == roomID).Count() > 0)
{
_dataContext.ExecuteCommand("update AnalogMeasurePoint set AMP_BuildingID={0} where AMP_RoomID={1}", buildingID, roomID);
// 修改父测点编号
var modifiedAMPs = _dataContext.AnalogMeasurePoints.Where(x => x.AMP_RoomID == roomID && 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_BuildingID == buildingID && x.AMP_RoomID == 0 && x.AMP_PowerType == item.AMP_PowerType).SingleOrDefault();
if (parentPoint != null)
{
item.AMP_ParentNo = parentPoint.AMP_AnalogNo;
}
else
{
item.AMP_ParentNo = 0;
}
}
}
}
room.RI_Floor = floor;
room.RI_Remark = remark;
_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);
}
}
