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