/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <param name="userid"></param>
/// <returns></returns>
public int DeleteNodeData(int id, int userid)
{
try
{
DNodeData dfh = new DNodeData();
NodeData tmp = dfh.SELECT_BY_ID(id);
tmp.Isused = false;
int result = dfh.UPDATE(tmp);
Log log = new Log();
log.Tablename = "NodeData";
log.Tableid = result;
log.Mid = userid;
log.Datetime = DateTime.Now;
log.Discription = "Delete";
DLog dl = new DLog();
dl.INSERT(log);
return(result);
}
catch
{
return(0);
}
}
/// <summary>
/// 获取建筑楼层信息
/// </summary>
/// <param name="nid">楼层ID</param>
/// <returns></returns>
public NodeData GetNodedata(int nid)
{
try
{
DNodeData dnd = new DNodeData();
return(dnd.SELECT_BY_ID(nid));
}
catch
{
return(null);
}
}
// ---------------------------楼层数据获取---------------------------
/// <summary>
/// 获取建筑楼层列表
/// </summary>
/// <param name="lid">建筑ID</param>
/// <returns></returns>
public IList <NodeData> GetNodedataList(int lid)
{
try
{
DNodeData dnd = new DNodeData();
return(dnd.SELECT_BY_LID(lid));
}
catch
{
return(null);
}
}
// ---------------------------建筑楼层及设备---------------------------
/// <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="info">楼层数据</param>
/// <param name="userid">操作ID</param>
/// <returns></returns>
public int EditNodedata(NodeData info, int userid)
{
try
{
DNodeData dnd = new DNodeData();
info.Isused = true;
int result = dnd.UPDATE(info);
Log log = new Log();
log.Tablename = "NodeData";
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>
/// 导入XML文档数据
/// </summary>
/// <param name="filename"></param>
/// <param name="lan"></param>
/// <returns></returns>
public bool ImportXml(string filename, LanData lan)
{
try
{
DNodeData dnd = new DNodeData();
DEquipData ded = new DEquipData();
XmlDocument doc = new XmlDocument();
doc.Load(StrUtil.upload + filename);
//doc.Load("H:\\Users\\ttxy\\Desktop\\LanMap\\WebSite\\Upload\\map\\凯宾斯基.xml");
XmlElement rootElem = doc.DocumentElement;
XmlNodeList pronodes = rootElem.GetElementsByTagName("project");
for (int i = 0; i < pronodes.Count; i++)
{
string pro = ((XmlElement)pronodes[i]).GetAttribute("name");
if (lan.Building != pro)
{
//Console.WriteLine(pro);
return(false);
}
XmlNodeList lnodes = pronodes[i].ChildNodes;
for (int j = 0; j < lnodes.Count; j++)
{
string zone = ((XmlElement)lnodes[j]).GetAttribute("name");
//Console.WriteLine(zone);
NodeData nd = new NodeData();
nd.Lid = lan.ID;
nd.PicName = zone;
nd.Mainmap = false;
nd.PicDescription = ((XmlElement)lnodes[j]).GetAttribute("picpath");
nd.PicPath = pro + zone;
nd.Sort = 32767;
nd.Description = ((XmlElement)lnodes[j]).GetAttribute("description");
nd.Isused = true;
int nid = dnd.INSERT(nd);
XmlNodeList enodes = lnodes[j].ChildNodes;
foreach (XmlNode enode in enodes)
{
string devicenumber = ((XmlElement)enode).GetAttribute("devicenumber");
//Console.Write(devicenumber);
EquipData ed = new EquipData();
ed.Nid = nid;
ed.Logicid = devicenumber;
ed.Status = 1;
ed.Type = short.Parse(((XmlElement)enode).GetAttribute("deviceTypeid"));
ed.Url = "";
ed.X = short.Parse(((XmlElement)enode).GetAttribute("left"));
ed.Y = short.Parse(((XmlElement)enode).GetAttribute("top"));
ed.Description = (((XmlElement)enode).GetAttribute("mark"));
ed.Isused = true;
ded.INSERT(ed);
}
}
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
