public List <V_Elec> GetActive(EnmSSH type, EnmFormula formula) { SqlParameter[] parms = { new SqlParameter("@Type", SqlDbType.Int), new SqlParameter("@FormulaType", SqlDbType.Int) }; parms[0].Value = (int)type; parms[1].Value = (int)formula; var entities = new List <V_Elec>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Elec_Repository_GetActive4, parms)) { while (rdr.Read()) { var entity = new V_Elec(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Type = SqlTypeConverter.DBNullEnmSSHHandler(rdr["Type"]); entity.FormulaType = SqlTypeConverter.DBNullEnmFormulaHandler(rdr["FormulaType"]); entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]); entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EndTime"]); entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]); entities.Add(entity); } } return(entities); }
public List <V_Elec> GetEachDay(string id, EnmSSH type, EnmFormula formula, DateTime start, DateTime end) { SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100), new SqlParameter("@Type", SqlDbType.Int), new SqlParameter("@FormulaType", SqlDbType.Int), new SqlParameter("@Start", SqlDbType.DateTime), new SqlParameter("@End", SqlDbType.DateTime) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(id); parms[1].Value = (int)type; parms[2].Value = (int)formula; parms[3].Value = SqlTypeConverter.DBNullDateTimeHandler(start); parms[4].Value = SqlTypeConverter.DBNullDateTimeHandler(end); var entities = new List <V_Elec>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Elec_Repository_GetHistory6, parms)) { while (rdr.Read()) { var entity = new V_Elec(); entity.Id = id; entity.Type = type; entity.FormulaType = formula; entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]); entity.EndTime = entity.StartTime.AddDays(1); entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]); entities.Add(entity); } } return(entities); }
public List <V_Elec> GetActive() { var entities = new List <V_Elec>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Elec_Repository_GetActive1, null)) { while (rdr.Read()) { var entity = new V_Elec(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Type = SqlTypeConverter.DBNullEnmSSHHandler(rdr["Type"]); entity.FormulaType = SqlTypeConverter.DBNullEnmFormulaHandler(rdr["FormulaType"]); entity.StartTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StartTime"]); entity.EndTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EndTime"]); entity.Value = SqlTypeConverter.DBNullDoubleHandler(rdr["Value"]); entities.Add(entity); } } return(entities); }