/// <summary> /// 按IP地址获取设备基本信息 /// </summary> /// <param name="deviceIP"></param> /// <returns></returns> public static Model.DeviceInfo GetDeviceInfoByIP(string deviceIP) { string sql = "select * from ROSO_DeviceInfo where DeviceIP=@DeviceIP"; SqlParameter[] p = { new SqlParameter("@DeviceIP", deviceIP) }; using (SqlDataReader reader = SQLHelper.ExecuteReader(sql, CommandType.Text, p)) { Model.DeviceInfo di = new Model.DeviceInfo(); if (reader.Read()) { di.ID = Convert.ToInt32(reader["ID"]); di.DeviceID = Convert.ToInt16(reader["DeviceID"]); di.DeviceIP = Convert.ToString(reader["DeviceIP"]); di.DeviceName = Convert.ToString(reader["DeviceName"]); di.DeviceStatus = Convert.ToInt16(reader["DeviceStatus"]); di.DeviceType = Convert.ToString(reader["DeviceType"]); di.Remark = Convert.ToString(reader["Remark"]); di.DeviceSpec = Convert.ToString(reader["DeviceSpec"]); } return(di); } }
/// <summary> /// 获取指定状态设备的基本信息列表 /// </summary> /// <param name="deviceStatus"></param> /// <returns></returns> public static List <Model.DeviceInfo> GetDeviceInfoList(int deviceStatus) { string sql = "select * from ROSO_DeviceInfo where DeviceStatus=@DeviceStatus order by DeviceType,DeviceIP"; SqlParameter[] p = new SqlParameter[] { new SqlParameter("@DeviceStatus", deviceStatus) }; using (SqlDataReader reader = SQLHelper.ExecuteReader(sql, CommandType.Text, p)) { List <Model.DeviceInfo> list = new List <Model.DeviceInfo>(); while (reader.Read()) { Model.DeviceInfo di = new Model.DeviceInfo(); di.ID = Convert.ToInt32(reader["ID"]); di.DeviceID = Convert.ToInt16(reader["DeviceID"]); di.DeviceIP = Convert.ToString(reader["DeviceIP"]); di.DeviceName = Convert.ToString(reader["DeviceName"]); di.DeviceStatus = Convert.ToInt16(reader["DeviceStatus"]); di.DeviceType = Convert.ToString(reader["DeviceType"]); di.Remark = Convert.ToString(reader["Remark"]); di.DeviceSpec = Convert.ToString(reader["DeviceSpec"]); list.Add(di); } return(list); } }
/// <summary> /// 获取指定类型指定状态设备的基本信息列表 /// </summary> /// <param name="deviceType"></param> /// <param name="deviceStatus"></param> /// <returns></returns> public static List <Model.DeviceInfo> GetDeviceInfoList(Model.DeviceType deviceType, int deviceStatus) { string type; switch (deviceType) { case Model.DeviceType.ROSO_RSJ: type = "ROSO_RSJ"; break; case Model.DeviceType.ROSO_BZJ: type = "ROSO_BZJ"; break; case Model.DeviceType.ROSO_DXJ: type = "ROSO_DXJ"; break; case Model.DeviceType.ROSO_RDJ: type = "ROSO_RDJ"; break; default: return(null); } string sql = "select * from ROSO_DeviceInfo where DeviceType=@DeviceType and DeviceStatus=@DeviceStatus order by DeviceType,DeviceIP"; SqlParameter[] p = { new SqlParameter("@DeviceType", type), new SqlParameter("@DeviceStatus", deviceStatus) }; using (SqlDataReader reader = SQLHelper.ExecuteReader(sql, CommandType.Text, p)) { List <Model.DeviceInfo> list = new List <Model.DeviceInfo>(); while (reader.Read()) { Model.DeviceInfo di = new Model.DeviceInfo(); di.ID = Convert.ToInt32(reader["ID"]); di.DeviceID = Convert.ToInt16(reader["DeviceID"]); di.DeviceIP = Convert.ToString(reader["DeviceIP"]); di.DeviceName = Convert.ToString(reader["DeviceName"]); di.DeviceStatus = Convert.ToInt16(reader["DeviceStatus"]); di.DeviceType = Convert.ToString(reader["DeviceType"]); di.Remark = Convert.ToString(reader["Remark"]); di.DeviceSpec = Convert.ToString(reader["DeviceSpec"]); list.Add(di); } return(list); } }
/// <summary> /// 修改设备基本信息,编号不能修改 /// </summary> /// <param name="deviceInfo"></param> /// <returns></returns> public static bool ChangeDeviceInfo(Model.DeviceInfo deviceInfo) { string sql = "update ROSO_DeviceInfo set DeviceType=@DeviceType,DeviceIP=@DeviceIP,DeviceSpec=@DeviceSpec,DeviceName=@DeviceName,DeviceStatus=@DeviceStatus,Remark=@Remark where DeviceID=@DeviceID"; SqlParameter[] p = { new SqlParameter("@DeviceID", deviceInfo.DeviceID), new SqlParameter("@DeviceType", deviceInfo.DeviceType), new SqlParameter("@DeviceIP", deviceInfo.DeviceIP), new SqlParameter("@DeviceSpec", deviceInfo.DeviceSpec), new SqlParameter("@DeviceName", deviceInfo.DeviceName), new SqlParameter("@DeviceStatus", deviceInfo.DeviceStatus), new SqlParameter("@Remark", deviceInfo.Remark) }; int j = SQLHelper.ExecuteNonQuery(sql, CommandType.Text, p); return(j > 0); }
/// <summary> /// 添加设备基本信息 /// </summary> /// <param name="deviceInfo"></param> /// <returns></returns> public static bool AddDeviceInfo(Model.DeviceInfo deviceInfo) { string sql = "insert into ROSO_DeviceInfo(DeviceID,DeviceType,DeviceIP,DeviceSpec,DeviceName,DeviceStatus,Remark) values(@DeviceID,@DeviceType,@DeviceIP,@DeviceSpec,@DeviceName,@DeviceStatus,@Remark)"; SqlParameter[] p = { new SqlParameter("@DeviceID", deviceInfo.DeviceID), new SqlParameter("@DeviceType", deviceInfo.DeviceType), new SqlParameter("@DeviceIP", deviceInfo.DeviceIP), new SqlParameter("@DeviceSpec", deviceInfo.DeviceSpec), new SqlParameter("@DeviceName", deviceInfo.DeviceName), new SqlParameter("@DeviceStatus", deviceInfo.DeviceStatus), new SqlParameter("@Remark", deviceInfo.Remark) }; int i = SQLHelper.ExecuteNonQuery(sql, CommandType.Text, p); return(i > 0); }
/// <summary> /// 修改设备基本信息 /// </summary> /// <param name="deviceInfo"></param> /// <returns></returns> public static bool ChangeDeviceInfo(Model.DeviceInfo deviceInfo) { return(DAL.DA_DeviceInfo.ChangeDeviceInfo(deviceInfo)); }
/// <summary> /// 添加设备基本信息 /// </summary> /// <param name="deviceInfo"></param> /// <returns></returns> public static bool AddDeviceInfo(Model.DeviceInfo deviceInfo) { return(DAL.DA_DeviceInfo.AddDeviceInfo(deviceInfo)); }