/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <param name="userid"></param>
/// <returns></returns>
public long DeleteEquipData(long id, int userid)
{
try
{
DEquipData dfh = new DEquipData();
EquipData tmp = dfh.SELECT_BY_ID(id);
tmp.Isused = false;
long result = dfh.UPDATE(tmp);
Log log = new Log();
log.Tablename = "EquipData";
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="id">设备ID</param>
/// <returns></returns>
public EquipData GetEquipdata(long id)
{
try
{
DEquipData ded = new DEquipData();
return(ded.SELECT_BY_ID(id));
}
catch
{
return(null);
}
}
// ---------------------------设备数据获取---------------------------
/// <summary>
/// 获取某楼层设备信息
/// </summary>
/// <param name="nid">楼层ID</param>
/// <returns></returns>
public IList <EquipData> GetEquipdataList(int nid)
{
try
{
DEquipData ded = new DEquipData();
return(ded.SELECT_BY_NID(nid));
}
catch
{
return(null);
}
}
/// <summary>
/// 更新楼层数据
/// </summary>
/// <param name="info">楼层数据</param>
/// <param name="userid">操作ID</param>
/// <returns></returns>
public long EditEquipdata(EquipData info, int userid)
{
try
{
DEquipData ded = new DEquipData();
info.Isused = true;
long result = ded.UPDATE(info);
Log log = new Log();
log.Tablename = "EquipData";
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);
}
}
