/// <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>
/// 主码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="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="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);
}
}