/// <summary>
/// 获取HOST下设备
/// </summary>
/// <param name="hostid"></param>
/// <returns></returns>
public IList <SC_NODE> getnodelist(int hostid)
{
try
{
DSCfunction dsc = new DSCfunction();
return(dsc.SELECT_HOST_ID_NODELIST(hostid));
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 根据ID取得主机信息
/// </summary>
/// <param name="hostid">主机ID</param>
/// <returns></returns>
public SC_HOST gethost(int hostid)
{
try
{
DSCfunction dsc = new DSCfunction();
return(dsc.SELECT_HOST_ID(hostid));
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 获取当前主机非状态值主机个数
/// </summary>
/// <param name="state"></param>
/// <returns></returns>
public int host_state_num_o(char state)
{
try
{
DSCfunction dsc = new DSCfunction();
IList <SC_HOST> lsc = dsc.SELECT_HOST_STATE_O(state);
return(lsc.Count);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 更新主机信息
/// </summary>
/// <param name="sch"></param>
/// <returns></returns>
public int exchost(SC_HOST sch)
{
try
{
DSCfunction dsc = new DSCfunction();
sch.STATE_DATE = DateTime.Now;
return(dsc.UPDATE_HOST(sch));
}
catch (Exception e)
{
throw e;
}
}
// ---------------------------建筑楼层及设备---------------------------
/// <summary>
/// 添加建筑数据
/// </summary>
/// <param name="info">建筑数据</param>
/// <param name="userid">操作ID</param>
/// <returns></returns>
public int AddLandata(LanData info, int userid)
{
try
{
DLanData dld = new DLanData();
info.PASSWD = md5.Md5Encode(info.PASSWD);
info.Isused = true;
int result = dld.INSERT(info);
if (result != 0)
{
SC_HOST sch = new SC_HOST();
sch.HOST_ID = result;
sch.HOST_CODE = info.HOST_CODE;
sch.PASSWD = info.PASSWD;
sch.ACTIVE = info.ACTIVE;
sch.COMM_DATE = DateTime.Now;
sch.COMM_VARS = "0";
sch.STATE = '1';
sch.STATE_DATE = DateTime.Now;
DSCfunction dsc = new DSCfunction();
dsc.INSERT_HOST(sch);
NodeData nd = new NodeData();
nd.Lid = result;
nd.Sort = 0;
nd.Mainmap = true;
nd.Isused = true;
nd.PicName = "预案图";
nd.Description = "";
nd.PicDescription = "";
nd.PicPath = "";
DNodeData dnd = new DNodeData();
dnd.INSERT(nd);
Log log = new Log();
log.Tablename = "LanData";
log.Tableid = result;
log.Mid = userid;
log.Datetime = DateTime.Now;
log.Discription = "Insert";
DLog dl = new DLog();
dl.INSERT(log);
}
return(result);
}
catch
{
return(0);
}
}
/// <summary>
/// 获取非状态当前主机列表
/// </summary>
/// <param name="state">0=离线，1=在线</param>
/// <returns></returns>
public IList <SC_HOST> host_state_control_o(char state)
{
try
{
DSCfunction dsc = new DSCfunction();
IList <SC_HOST> lsc = dsc.SELECT_HOST_STATE_O(state);
DLanData dld = new DLanData();
for (int i = 0; i < lsc.Count; i++)
{
lsc[i].HostName = dld.SELECT_BY_ID(lsc[i].HOST_ID).Building;
}
return(lsc);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 更新建筑数据
/// </summary>
/// <param name="info">建筑数据</param>
/// <param name="userid">操作ID</param>
/// <returns></returns>
public int EditLandata(LanData info, int userid)
{
try
{
DLanData dld = new DLanData();
if (info.PASSWD != "")
{
info.PASSWD = md5.Md5Encode(info.PASSWD);
}
else
{
info.PASSWD = dld.SELECT_BY_ID(info.ID).PASSWD;
}
info.Isused = true;
int result = dld.UPDATE(info);
DSCfunction dsc = new DSCfunction();
SC_HOST sch = dsc.SELECT_HOST_ID(info.ID);
sch.HOST_CODE = info.HOST_CODE;
sch.PASSWD = info.PASSWD;
sch.ACTIVE = info.ACTIVE;
dsc.UPDATE_HOST(sch);
Log log = new Log();
log.Tablename = "LanData";
log.Tableid = result;
log.Mid = userid;
log.Datetime = DateTime.Now;
log.Discription = "Update";
DLog dl = new DLog();
dl.INSERT(log);
return(result);
}
catch
{
return(0);
}
}
/// <summary>
/// 获取设备信息地图
/// </summary>
/// <param name="nd"></param>
/// <param name="le"></param>
/// <returns></returns>
public static string MakeEquipMap(NodeData nd, IList <EquipData> le, int lid)
{
DSCfunction dsc = new DSCfunction();
DEquipType edt = new DEquipType();
IList <EquipType> letype = edt.SELECT_BY_ISUSED(true);
string points = "";
string pclick = "\r\n<script type=\"text/javascript\">\r\n";
for (int i = 0; i < le.Count; i++)
{
string curicon = "";
string curtype = "";
for (int j = 0; j < letype.Count; j++)
{
curtype = letype[j].Name;
if (le[i].Type == letype[j].Id)
{
//curicon = iconurl + letype[j].Icon;
SC_NODE sn = new SC_NODE();
try
{
sn = dsc.SELECT_NODE_ID(lid, le[i].Logicid);
}
catch
{
sn = null;
}
string[] tmp = letype[j].Icon.Split('.');
string tmpicon = "";
if (sn != null)
{
if (sn.STATE == '0') // 恢复（正常）
{
tmpicon = tmp[0] + "1." + tmp[1]; // 绿色
}
else if (sn.STATE == '1') // 故障
{
tmpicon = tmp[0] + "4." + tmp[1]; // 黄色
}
else if (sn.STATE == '2') // 火警
{
tmpicon = tmp[0] + "3." + tmp[1]; // 红色
}
else if (sn.STATE == '3') // 隔离
{
tmpicon = tmp[0] + "2." + tmp[1]; // 灰色
}
else if (sn.STATE == '4') // 启动
{
tmpicon = tmp[0] + "5." + tmp[1]; // 深蓝色
}
else if (sn.STATE == '5') // 预警
{
tmpicon = tmp[0] + "8." + tmp[1]; // 粉色
}
else if (sn.STATE == '6') // 回答
{
tmpicon = tmp[0] + "7." + tmp[1]; // 浅蓝色
}
//else if (sn.STATE == "10")
//{
// tmpicon = tmp[0] + "8" + tmp[1];
//}
//else if (sn.STATE == "12")
//{
// tmpicon = tmp[0] + "2" + tmp[1];
//}
else
{
tmpicon = letype[j].Icon; // 白色
}
}
else
{
tmpicon = letype[j].Icon;
}
curicon = iconurl + tmpicon;
break;
}
}
points += "<div class=\"jt\" style=\"left:" + le[i].X + "px;top:" + le[i].Y + "px;\"><img id=\"imge_" + le[i].Id + "\" src=\"" + curicon + "\"/></div>\r\n ";
//pclick += "C$('imge_" + le[i].Id + "').onclick = function () {var info = \'设备描述：" + le[i].Description + "<br/>设备编码：" + le[i].Logicid + "<br/>设备链接：<a href=\"" + le[i].Url + "\" target=\"_eurl\">点击显示</a>\';cwxbox.box.show(info);}\r\n";
pclick += "C$('imge_" + le[i].Id + "').onclick = function () {var info = \'设备描述：" + le[i].Description + "<br/>设备编码：" + le[i].Logicid + "<br/>设备类型：" + curtype + "\';cwxbox.box.show(info);}\r\n";
}
pclick += "\r\n</script>\r\n";
string h0 = "<!DOCTYPE html>\r\n<html>\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n<title>";
string h1 = "</title>\r\n<style>\r\n.jt{position:absolute;}\r\n*{ margin:0px; padding:0px;}\r\nbody{ font-size:12px; font:Arial, Helvetica, sans-serif; margin:25PX 0PX; background:#eee;}\r\n.botton{ color:#F00; cursor:pointer;}\r\n.mybody{width:600px; margin:0 auto; height:1500px; border:1px solid #ccc; padding:20px 25px; background:#fff}\r\n#cwxBg{ position:absolute; display:none; background:#000; width:100%; height:100%; left:0px; top:0px; z-index:1000;}\r\n#cwxWd{ position:absolute; display:none; border:10px solid #CCC; padding:10px;background:#FFF; z-index:1500;}\r\n#cwxCn{ background:#FFF; display:block;}\r\n.imgd{ width:400px; height:300px;}\r\n</style>\r\n</head>\r\n<body>\r\n<div style=\"position:relative;\">\r\n<script type = \"text/javascript\" src = \"./Scripts/DropBox.js\"></script>\r\n<img src=\"";
string h2 = "\"/>\r\n";
string h3 = "\r\n</div>\r\n</body>\r\n</html>";
return(h0 + nd.PicName + h1 + mapurl + nd.PicPath + h2 + points + pclick + h3);
}
