/// <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> /// 获取建筑列表 /// </summary> /// <param name="ptid">物业公司ID</param> /// <returns></returns> public IList <LanData> GetLandataListPt(short ptid) { try { DLanData dld = new DLanData(); return(dld.SELECT_BY_PTID(ptid, true)); } catch { return(null); } }
/// <summary> /// 获取建筑列表 /// </summary> /// <param name="id">模糊搜索名字关键字</param> /// <param name="aid">所属区域ID</param> /// <returns></returns> public IList <LanData> GetLandataList(string name, short aid) { try { DLanData dld = new DLanData(); return(dld.SELECT_LIKE_NAME_AID(name, aid, true)); } catch { return(null); } }
// ---------------------------建筑数据获取--------------------------- /// <summary> /// 获取在用建筑列表 /// </summary> /// <returns></returns> public IList <LanData> GetLandataList() { try { DLanData dld = new DLanData(); return(dld.SELECT_ISUSED(true)); } catch { return(null); } }
/// <summary> /// 获取建筑信息 /// </summary> /// <param name="id">建筑ID</param> /// <returns></returns> public LanData GetLandata(int id) { try { DLanData dld = new DLanData(); return(dld.SELECT_BY_ID(id)); } 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="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); } }