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