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