public int UPDATE(LanData info)
{
try
{
U_landata temp = new U_landata();
Table <U_landata> table = db.GetTable <U_landata>();
temp = (from row in db.U_landata where row.id == info.ID select row).First();
//temp.id = info.ID;
temp.areaid = info.AreaData;
temp.lng = info.Lng;
temp.lat = info.Lat;
temp.building = info.Building;
temp.address = info.Address;
temp.ptid = info.Ptid;
temp.mtid = info.Mtid;;
temp.isused = info.Isused;
temp.cate = info.Cate;
temp.type = info.Type;
temp.manager = info.Manager;
temp.HOST_CODE = info.HOST_CODE;
temp.PASSWD = info.PASSWD;
temp.ACTIVE = info.ACTIVE;
db.SubmitChanges();
return(temp.id);
}
catch
{
return(-2);
}
}
public IList <LanData> SELECT_BY_PTID(short ptid, bool isused)
{
try
{
IList <LanData> result = new List <LanData>();
var temp = (from row in db.U_landata where row.ptid == ptid && row.isused == isused orderby row.building ascending select row).GetEnumerator();
while (temp.MoveNext())
{
LanData element = new LanData();
element.ID = temp.Current.id;
element.AreaData = temp.Current.areaid;
element.Lng = temp.Current.lng;
element.Lat = temp.Current.lat;
element.Building = temp.Current.building;
element.Address = temp.Current.address;
element.Ptid = temp.Current.ptid;
element.Mtid = temp.Current.mtid;
element.Isused = temp.Current.isused;
element.Cate = temp.Current.cate;
element.Type = temp.Current.type;
element.Manager = temp.Current.manager;
element.HOST_CODE = temp.Current.HOST_CODE;
element.PASSWD = temp.Current.PASSWD;
element.ACTIVE = temp.Current.ACTIVE;
result.Add(element);
}
return(result);
}
catch
{
return(null);
}
}
public int INSERT(LanData info)
{
try
{
U_landata temp = new U_landata();
//temp.id = info.ID;
temp.areaid = info.AreaData;
temp.lng = info.Lng;
temp.lat = info.Lat;
temp.building = info.Building;
temp.address = info.Address;
temp.ptid = info.Ptid;
temp.mtid = info.Mtid;
temp.isused = info.Isused;
temp.cate = info.Cate;
temp.type = info.Type;
temp.manager = info.Manager;
temp.HOST_CODE = info.HOST_CODE;
temp.PASSWD = info.PASSWD;
temp.ACTIVE = info.ACTIVE;
Table <U_landata> table = db.GetTable <U_landata>();
table.InsertOnSubmit(temp);
db.SubmitChanges();
return(temp.id);
}
catch
{
return(-2);
}
}
/// <summary>
/// 根据火警告警设备获取告警建筑
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public IList <LanData> GetFireTarget(IList <EquipData> info)
{
UseFunc uf = new UseFunc();
IList <EquipData> tmp = new List <EquipData>();
for (int i = 0; i < info.Count; i++)
{
tmp.Add(uf.GetEquipdata(info[i].Id));
}
IList <LanData> result = new List <LanData>();
for (int j = 0; j < tmp.Count; j++)
{
LanData lt = uf.GetLandata(uf.GetNodedata(tmp[j].Nid).Lid);
bool isexist = false;
for (int k = 0; k < result.Count; k++)
{
if (result[k].ID == lt.ID)
{
isexist = true;
break;
}
}
if (isexist == false)
{
result.Add(lt);
}
}
return(result);
}
public LanData SELECT_BY_NAME(string name)
{
try
{
LanData rd = new LanData();
U_landata temp = (from row in db.U_landata where row.building == name && row.isused == true select row).First();
rd.ID = temp.id;
rd.AreaData = temp.areaid;
rd.Lng = temp.lng;
rd.Lat = temp.lat;
rd.Building = temp.building;
rd.Address = temp.address;
rd.Ptid = temp.ptid;
rd.Mtid = temp.mtid;
rd.Isused = temp.isused;
rd.Cate = temp.cate;
rd.Type = temp.type;
rd.Manager = temp.manager;
rd.HOST_CODE = temp.HOST_CODE;
rd.PASSWD = temp.PASSWD;
rd.ACTIVE = temp.ACTIVE;
return(rd);
}
catch
{
return(null);
}
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <param name="userid"></param>
/// <returns></returns>
public int DeleteLanData(int id, int userid)
{
try
{
DLanData dfh = new DLanData();
LanData tmp = dfh.SELECT_BY_ID(id);
tmp.Isused = false;
int result = dfh.UPDATE(tmp);
Log log = new Log();
log.Tablename = "LanData";
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>
/// 更新landata数据
/// </summary>
/// <param name="temp">表单内容</param>
/// <returns>物理主码id</returns>
public int update_landata(LanData temp, int userid)
{
try
{
int result = dld.UPDATE(temp);
LanDataHistory tmp = new LanDataHistory();
tmp.LanDataID = result;
tmp.ZhuHuLiang = temp.ZhuHuLiang;
tmp.RuZhuLv = temp.RuZhuLv;
tmp.JX_DianXin = temp.JX_DianXin;
tmp.JX_LianTong = temp.JX_LianTong;
tmp.JX_YiDong = temp.JX_YiDong;
tmp.DuanKouShu = temp.DuanKouShu;
tmp.ShiZhuangShu = temp.ShiZhuangShu;
tmp.JingZhengPingJi = temp.JingZhengPingJi;
tmp.Datetime = DateTime.Now;
dldh.INSERT(tmp);
Log log = new Log();
log.Tablename = "LanData";
log.Tableid = result;
log.Mid = Members.newMembers(userid);
log.Datetime = DateTime.Now;
log.Discription = "更新节点数据(LanData)";
dl.INSERT(log);
return(result);
}
catch
{
return(0);
}
}
protected void Button_addlandata_Click(object sender, EventArgs e)
{
this.U_updateLandata1.Visible = false;
this.U_landdata1.Visible = true;
LanData ld = new LanData();
ld.AreaData = short.Parse(Session["Areaid"].ToString());
this.U_landdata1.landata = ld;
}
/// <summary>
/// 根据小区名获取landata数据，避免重复数据
/// </summary>
/// <param name="tf">小区名称</param>
/// <returns></returns>
public LanData getLandata_by_name(string name)
{
try
{
LanData result = dld.SELECT_BY_NAME(name);
return(result);
}
catch
{
return(null);
}
}
/// <summary>
/// 主码id获取目标行
/// </summary>
/// <param name="id">主码id</param>
/// <returns>目标行数据</returns>
public LanData getLandata_by_id(int id)
{
try
{
LanData result = dld.SELECT_BY_ID(id);
return(result);
}
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);
}
}
private static string mainurl = StrUtil.mainurl;//ConfigurationManager.AppSettings["hostname"];
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string url = HttpContext.Current.Request.Url.Query;
int id = int.Parse(url.Substring(1));
Session["Lanid"] = id.ToString();
UseFunc uf = new UseFunc();
LanData ld = uf.GetLandata(id);
this.Label_maptitle1.Text = ld.Building;
IList <NodeData> nodelist = uf.GetNodedataList(id);
bindlist(nodelist);
}
}
private static void PushToLanList(string key, params string[] valList)
{
if (LanData.ContainsKey(key))
{
throw new MsgException($"已包含{key}的定义");
}
else
{
valList = valList ?? new string[] { };
var lanList = new List <LanguageInfo> {
new LanguageInfo(LanguageType.Cn, key)
};
for (var i = 0; i < valList.Length; i++)
{
lanList.Add(new LanguageInfo((LanguageType)(i + 2), valList[0]));
}
LanData.Add(key, lanList);
}
}
/// <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);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
UseFunc uf = new UseFunc();
LanData ld = uf.GetLandata(int.Parse(Session["Lanid"].ToString()));
//LanData ld = uf.GetLandata(36);
IList <FireHouse> fhlist = uf.GetFirehouse(ld.AreaData);
this.Label_building.Text = ld.Building + "," + ld.Address;
IList <double> result = new List <double>();
for (int i = 0; i < fhlist.Count; i++)
{
double tmp = (fhlist[i].Lng - ld.Lng) * (fhlist[i].Lng - ld.Lng) + (fhlist[i].Lat - ld.Lat) * (fhlist[i].Lat - ld.Lat);
result.Add(tmp);
}
if (result.Count > 2)
{
}
int first = 0;
for (int j = 1; j < result.Count; j++)
{
if (result[first] > result[j])
{
first = j;
}
}
int second = 1;
this.S_CountPath1.s1_Lng = fhlist[first].Lng;
this.S_CountPath1.s1_Lat = fhlist[first].Lat;
this.S_CountPath1.s2_Lng = fhlist[second].Lng;
this.S_CountPath1.s2_Lat = fhlist[second].Lat;
this.S_CountPath1.e_Lng = ld.Lng;
this.S_CountPath1.e_Lat = ld.Lat;
}
}
/// <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);
}
}
