private SqlParamInfo[] GetDevicePars(DepDeviceData devInfo)
{
return(new SqlParamInfo[] {
new SqlParamInfo("设备ID", DbType.String, devInfo.设备ID),
new SqlParamInfo("房间ID", DbType.String, devInfo.房间ID),
new SqlParamInfo("影像类别", DbType.String, devInfo.影像类别),
new SqlParamInfo("设备名称", DbType.String, devInfo.设备名称),
new SqlParamInfo("设备信息", DbType.String, devInfo.设备信息.ToString())
});
}
/// <summary>
/// 修改设备
/// </summary>
/// <returns></returns>
public bool UpdateDevice(DepDeviceData devInfo)
{
string sql = "update " +
" 影像设备信息 set 影像类别=:影像类别,设备名称=:设备名称,设备信息=:设备信息 " +
" where 设备ID=:设备ID";
sql = SqlHelper.GetSqlBiz().GetSqlContext("修改设备信息", sql);
SqlParamInfo[] sqlPars = GetDevicePars(devInfo);
DataTable dtResult = _dbHelper.ExecuteSQL(sql, sqlPars);
return(true);
}
/// <summary>
/// 新增房间
/// </summary>
/// <returns></returns>
public bool AddDevice(DepDeviceData devInfo)
{
string sql = "insert into " +
" 影像设备信息(设备ID,房间ID,影像类别,设备名称,设备信息) " +
" values " +
" (:设备ID,:房间ID,:影像类别,:设备名称,:设备信息)";
sql = SqlHelper.GetSqlBiz().GetSqlContext("插入设备信息", sql);
SqlParamInfo[] sqlPars = GetDevicePars(devInfo);
DataTable dtResult = _dbHelper.ExecuteSQL(sql, sqlPars);
return(true);
}
