/// <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);
}
}
