/// <summary> /// 判断供电柜开关是否和其他设备有关系 /// </summary> /// <param name="powerId"></param> /// <param name="switchId">供电柜开关编号</param> /// <returns></returns> public bool HasRelation(string powerId, string switchId) { try { Log.Info("BllDEV_POWER_SWITCH->HasRelation---START"); bool result = false; //声明一个变量 DataSet dstemp = new DataSet(); ConnectionOpen(); //供电柜输入输出关系 DalDEV_SWITCH_INOUT dalDevSwitchInout = new DalDEV_SWITCH_INOUT(); dalDevSwitchInout.SetDBAccess(GetDBAccess()); dstemp = dalDevSwitchInout.GetList("F_POWER_ID='" + powerId + "' AND (F_POWER_SWITCH_ID_IN='" + switchId + "' OR F_POWER_SWITCH_ID_OUT='" + switchId + "')"); if (dstemp != null && dstemp.Tables.Count > 0) { result |= dstemp.Tables[0].Rows.Count > 0; } //供电柜输入开关与负载电源柜关系 DalDEV_LOADPOW_TO_SWITCH dalDevLoadpowToSwitch = new DalDEV_LOADPOW_TO_SWITCH(); dalDevLoadpowToSwitch.SetDBAccess(GetDBAccess()); dstemp = dalDevLoadpowToSwitch.GetList("F_POWER_ID='" + powerId + "' AND F_POWER_SWITCH_ID='" + switchId + "'"); if (dstemp != null && dstemp.Tables.Count > 0) { result |= dstemp.Tables[0].Rows.Count > 0; } //供电柜输出开关与负载柜关系 DalDEV_SWITCH_TO_LOAD dalDevSwitchToLoad = new DalDEV_SWITCH_TO_LOAD(); dalDevSwitchToLoad.SetDBAccess(GetDBAccess()); dstemp = dalDevSwitchToLoad.GetList("F_POWER_ID='" + powerId + "' AND F_POWER_SWITCH_ID='" + switchId + "'"); if (dstemp != null && dstemp.Tables.Count > 0) { result |= dstemp.Tables[0].Rows.Count > 0; } return(result); } catch (Exception ex) { Log.Error("BllDEV_POWER_SWITCH->HasRelation---FAILED", ex); throw ex; } finally { ConnectionClose(); Log.Info("BllDEV_POWER_SWITCH->HasRelation---finally"); } }
/// <summary> /// 判断负载是否和其他设备有关系 /// </summary> /// <param name="loadId">负载id</param> /// <returns></returns> public bool HasRelation(string loadId) { try { Log.Info("BllDEV_LOAD_INFO->HasRelation---START"); bool result = false; //声明一个变量 DataSet dstemp = new DataSet(); ConnectionOpen(); //负载和供电柜输入开关关系 DalDEV_SWITCH_TO_LOAD dalloSwitchToLoad = new DalDEV_SWITCH_TO_LOAD(); dalloSwitchToLoad.SetDBAccess(GetDBAccess()); dstemp = dalloSwitchToLoad.GetList("F_LOAD_ID='" + loadId + "'"); if (dstemp != null && dstemp.Tables.Count > 0) { result |= dstemp.Tables[0].Rows.Count > 0; } //负载和下位机关系 DalDEV_LOAD_TO_SUB dalDevLoadToSub = new DalDEV_LOAD_TO_SUB(); dalDevLoadToSub.SetDBAccess(GetDBAccess()); dstemp = dalDevLoadToSub.GetList("F_LOAD_ID='" + loadId + "'"); if (dstemp != null && dstemp.Tables.Count > 0) { result |= dstemp.Tables[0].Rows.Count > 0; } //负载和线圈电源关系 DalDEV_COILPOWER_TO_LOAD dalDevCoilpowerToLoad = new DalDEV_COILPOWER_TO_LOAD(); dalDevCoilpowerToLoad.SetDBAccess(GetDBAccess()); dstemp = dalDevCoilpowerToLoad.GetList("F_LOAD_ID='" + loadId + "'"); if (dstemp != null && dstemp.Tables.Count > 0) { result |= dstemp.Tables[0].Rows.Count > 0; } return(result); } catch (Exception ex) { Log.Error("BllDEV_LOAD_INFO->HasRelation---FAILED", ex); throw ex; } finally { ConnectionClose(); Log.Info("BllDEV_LOAD_INFO->HasRelation---finally"); } }