/// <summary>
/// 按状态(非)获取主机信息列表
/// </summary>
/// <param name="state"></param>
/// <returns></returns>
public IList <SC_HOST> SELECT_HOST_STATE_O(char state)
{
try
{
string str = "select HOST_ID , HOST_CODE , PASSWD , ACTIVE , COMM_DATE , COMM_VARS, STATE, STATE_DATE from HOST where state<>'" + state + "'";
DataTable dt = SqlHelper.ExecuteReader(str).Tables[0];
IList <SC_HOST> result = new List <SC_HOST>();
for (int i = 0; i < dt.Rows.Count; i++)
{
SC_HOST info = new SC_HOST();
info.HOST_ID = int.Parse(dt.Rows[i][0].ToString());
info.HOST_CODE = dt.Rows[i][1].ToString();
info.PASSWD = dt.Rows[i][2].ToString();
info.ACTIVE = dt.Rows[i][3].ToString()[0];
info.COMM_DATE = DateTime.Parse(dt.Rows[i][4].ToString());
info.COMM_VARS = dt.Rows[i][5].ToString();
info.STATE = dt.Rows[i][6].ToString()[0];
info.STATE_DATE = DateTime.Parse(dt.Rows[i][7].ToString());
result.Add(info);
}
return(result);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 更新主机信息
/// </summary>
/// <param name="sch"></param>
/// <returns></returns>
public int exchost(SC_HOST sch)
{
try
{
DSCfunction dsc = new DSCfunction();
sch.STATE_DATE = DateTime.Now;
return(dsc.UPDATE_HOST(sch));
}
catch (Exception e)
{
throw e;
}
}
// ---------------------------建筑楼层及设备---------------------------
/// <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="sch"></param>
/// <returns></returns>
public int UPDATE_HOST(SC_HOST sch)
{
try
{
string str = "update HOST set HOST_CODE='" +
sch.HOST_CODE + "', PASSWD='" +
sch.PASSWD + "', ACTIVE='" +
sch.ACTIVE + "', COMM_DATE='" +
sch.COMM_DATE + "', COMM_VARS='" +
sch.COMM_VARS + "', STATE='" +
sch.STATE + "', STATE_DATE='" +
sch.STATE_DATE + "' where HOST_ID=" +
sch.HOST_ID;
return(SqlHelper.ExecuteNonQuery(str));
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 添加主机状态信息
/// </summary>
/// <param name="sch"></param>
/// <returns></returns>
public int INSERT_HOST(SC_HOST sch)
{
try
{
string str = "insert into HOST (HOST_ID , HOST_CODE , PASSWD , ACTIVE , COMM_DATE , COMM_VARS, STATE, STATE_DATE) values(" +
sch.HOST_ID + ", '" +
sch.HOST_CODE + "', '" +
sch.PASSWD + "', '" +
sch.ACTIVE + "', '" +
sch.COMM_DATE + "', '" +
sch.COMM_VARS + "', '" +
sch.STATE + "', '" +
sch.STATE_DATE + "');";
return(SqlHelper.ExecuteNonQuery(str));
}
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);
}
}
/// <summary>
/// 根据HOST_ID获取主机状态信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public SC_HOST SELECT_HOST_ID(int id)
{
try
{
string str = "select HOST_ID , HOST_CODE , PASSWD , ACTIVE , COMM_DATE , COMM_VARS, STATE, STATE_DATE from HOST where HOST_ID=" + id;
DataTable dt = SqlHelper.ExecuteReader(str).Tables[0];
SC_HOST result = new SC_HOST();
result.HOST_ID = int.Parse(dt.Rows[0][0].ToString());
result.HOST_CODE = dt.Rows[0][1].ToString();
result.PASSWD = dt.Rows[0][2].ToString();
result.ACTIVE = dt.Rows[0][3].ToString()[0];
result.COMM_DATE = DateTime.Parse(dt.Rows[0][4].ToString());
result.COMM_VARS = dt.Rows[0][5].ToString();
result.STATE = dt.Rows[0][6].ToString()[0];
result.STATE_DATE = DateTime.Parse(dt.Rows[0][7].ToString());
return(result);
}
catch (Exception e)
{
throw e;
}
}
