public List <V_Offline> GetHistory(DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = SqlTypeConverter.DBNullDateTimeHandler(start);
parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(end);
var entities = new List <V_Offline>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Offline_Repository_GetHistory1, parms)) {
while (rdr.Read())
{
var entity = new V_Offline();
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> 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> GetHistory(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_GetHistory5, 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 Formula GetEntity(string id, EnmOrganization type, EnmFormula formulaType)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100),
new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@FormulaType", SqlDbType.Int) };
parms[0].Value = id;
parms[1].Value = (int)type;
parms[2].Value = (int)formulaType;
Formula entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_Formula_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new Formula();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Type = SqlTypeConverter.DBNullEnmOrganizationHandler(rdr["Type"]);
entity.FormulaType = SqlTypeConverter.DBNullEnmFormulaHandler(rdr["FormulaType"]);
entity.FormulaText = SqlTypeConverter.DBNullStringHandler(rdr["Formula"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]);
}
}
return(entity);
}
public List <M_Formula> GetFormulas(string id, EnmSSH type)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100),
new SqlParameter("@Type", SqlDbType.Int) };
parms[0].Value = id;
parms[1].Value = (int)type;
var entities = new List <M_Formula>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_M_Formula_Repository_GetFormulas, parms)) {
while (rdr.Read())
{
var entity = new M_Formula();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Type = SqlTypeConverter.DBNullEnmSSHHandler(rdr["Type"]);
entity.FormulaType = SqlTypeConverter.DBNullEnmFormulaHandler(rdr["FormulaType"]);
entity.ComputeType = SqlTypeConverter.DBNullEnmComputeHandler(rdr["ComputeType"]);
entity.FormulaText = SqlTypeConverter.DBNullStringHandler(rdr["FormulaText"]);
entity.FormulaValue = SqlTypeConverter.DBNullStringHandler(rdr["FormulaValue"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entities.Add(entity);
}
}
return(entities);
}
public List <V_Offline> GetActive()
{
var entities = new List <V_Offline>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Offline_Repository_GetActive1, null)) {
while (rdr.Read())
{
var entity = new V_Offline();
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 <Formula> GetEntities()
{
var entities = new List <Formula>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_Formula_Repository_GetAllEntities, null)) {
while (rdr.Read())
{
var entity = new Formula();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Type = SqlTypeConverter.DBNullEnmOrganizationHandler(rdr["Type"]);
entity.FormulaType = SqlTypeConverter.DBNullEnmFormulaHandler(rdr["FormulaType"]);
entity.FormulaText = SqlTypeConverter.DBNullStringHandler(rdr["Formula"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.CreatedTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedTime"]);
entities.Add(entity);
}
}
return(entities);
}
public List <M_Formula> GetAllFormulas()
{
var entities = new List <M_Formula>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_M_Formula_Repository_GetAllFormulas, null)) {
while (rdr.Read())
{
var entity = new M_Formula();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Type = SqlTypeConverter.DBNullEnmSSHHandler(rdr["Type"]);
entity.FormulaType = SqlTypeConverter.DBNullEnmFormulaHandler(rdr["FormulaType"]);
entity.ComputeType = SqlTypeConverter.DBNullEnmComputeHandler(rdr["ComputeType"]);
entity.FormulaText = SqlTypeConverter.DBNullStringHandler(rdr["FormulaText"]);
entity.FormulaValue = SqlTypeConverter.DBNullStringHandler(rdr["FormulaValue"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entities.Add(entity);
}
}
return(entities);
}