public V_AMeasure GetEntity(string device, string point)
{
SqlParameter[] parms = { new SqlParameter("@DeviceId", SqlDbType.VarChar, 100),
new SqlParameter("@PointId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(device);
parms[1].Value = SqlTypeConverter.DBNullStringChecker(point);
V_AMeasure entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_AMeasure_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new V_AMeasure();
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.SignalDesc = SqlTypeConverter.DBNullStringHandler(rdr["SignalDesc"]);
entity.Status = SqlTypeConverter.DBNullEnmStateHandler(rdr["Status"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entity.UpdateTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["UpdateTime"]);
}
}
return(entity);
}
public List <V_AMeasure> GetMeasuresInStation(string id)
{
SqlParameter[] parms = { new SqlParameter("@StationId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
var entities = new List <V_AMeasure>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_AMeasure_Repository_GetMeasuresInStation, parms)) {
while (rdr.Read())
{
var entity = new V_AMeasure();
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.Status = SqlTypeConverter.DBNullEnmStateHandler(rdr["Status"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entity.UpdateTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["UpdateTime"]);
if (entity.Status != EnmState.Normal)
{
entity.Status = EnmState.Invalid;
}
entities.Add(entity);
}
}
return(entities);
}
public List <V_AMeasure> GetMeasures(IList <Kv <string, string> > keys)
{
if (keys == null || keys.Count == 0)
{
throw new ArgumentNullException("keys");
}
var commands = new string[keys.Count];
for (var i = 0; i < keys.Count; i++)
{
commands[i] = string.Format(@"SELECT '{0}' AS [DeviceId], '{1}' AS [PointId]", keys[i].Key, keys[i].Value);
}
var query = string.Format(@"
;WITH Keys AS (
{0}
)
SELECT VA.* FROM [dbo].[V_AMeasure] VA INNER JOIN Keys K ON VA.[DeviceId]=K.[DeviceId] AND VA.[PointId]=K.[PointId];", string.Join(@" UNION ALL ", commands));
var entities = new List <V_AMeasure>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, query, null)) {
while (rdr.Read())
{
var entity = new V_AMeasure();
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.Status = SqlTypeConverter.DBNullEnmStateHandler(rdr["Status"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entity.UpdateTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["UpdateTime"]);
if (entity.Status != EnmState.Normal)
{
entity.Status = EnmState.Invalid;
}
entities.Add(entity);
}
}
return(entities);
}
public List <V_AMeasure> GetEntities()
{
var entities = new List <V_AMeasure>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_AMeasure_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new V_AMeasure();
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.FsuId = SqlTypeConverter.DBNullStringHandler(rdr["FsuId"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.SignalDesc = SqlTypeConverter.DBNullStringHandler(rdr["SignalDesc"]);
entity.Status = SqlTypeConverter.DBNullEnmStateHandler(rdr["Status"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entity.UpdateTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["UpdateTime"]);
entities.Add(entity);
}
}
return(entities);
}