/// <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);
}
}
