public List <V_ACabinet> GetHistory(string device, EnmVSignalCategory category, DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime),
new SqlParameter("@Category", SqlDbType.Int),
new SqlParameter("@DeviceId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullDateTimeHandler(start);
parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(end);
parms[2].Value = (int)category;
parms[3].Value = SqlTypeConverter.DBNullStringHandler(device);
var entities = new List <V_ACabinet>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_ACabinet_Repository_GetHistory3, parms)) {
while (rdr.Read())
{
var entity = new V_ACabinet();
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.PointId = SqlTypeConverter.DBNullStringHandler(rdr["PointId"]);
entity.Category = SqlTypeConverter.DBNullVSignalCategoryHandler(rdr["Category"]);
entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]);
entity.ValueTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["ValueTime"]);
entity.AValue = SqlTypeConverter.DBNullDoubleHandler(rdr["AValue"]);
entity.AValueTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["AValueTime"]);
entity.BValue = SqlTypeConverter.DBNullDoubleHandler(rdr["BValue"]);
entity.BValueTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["BValueTime"]);
entity.CValue = SqlTypeConverter.DBNullDoubleHandler(rdr["CValue"]);
entity.CValueTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CValueTime"]);
entities.Add(entity);
}
}
return(entities);
}
public List <D_VSignal> GetVSignals(string device, EnmVSignalCategory category)
{
if (string.IsNullOrWhiteSpace(device))
{
throw new ArgumentNullException("device");
}
return(_repository.GetVSignals(device, category));
}
public static string GetVSignalCategoryDisplay(EnmVSignalCategory ext)
{
switch (ext)
{
case EnmVSignalCategory.Category01:
return("普通虚拟信号");
case EnmVSignalCategory.Category02:
return("能耗虚拟信号");
case EnmVSignalCategory.Category03:
return("列头柜分路功率");
case EnmVSignalCategory.Category04:
return("列头柜分路电流");
case EnmVSignalCategory.Category05:
return("列头柜分路电量");
default:
return("未定义");
}
}
public List <V_ACabinet> GetLast(EnmVSignalCategory category, DateTime start, DateTime end)
{
return(_repository.GetLast(category, start, end));
}
public List <V_ACabinet> GetHistory(string device, EnmVSignalCategory category, DateTime start, DateTime end)
{
return(_repository.GetHistory(device, category, start, end));
}
public List <D_VSignal> GetVSignals(EnmVSignalCategory category)
{
return(_repository.GetVSignals(category));
}
