public List <V_Elec> GetHistory(EnmSSH type, DateTime start, DateTime end)
{
SqlParameter[] parms = { new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@Start", SqlDbType.DateTime),
new SqlParameter("@End", SqlDbType.DateTime) };
parms[0].Value = (int)type;
parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(start);
parms[2].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_GetHistory2, 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 static string GetSSHDisplay(EnmSSH type)
{
switch (type)
{
case EnmSSH.Root:
return("全部");
case EnmSSH.Area:
return("区域");
case EnmSSH.Station:
return("站点");
case EnmSSH.Room:
return("机房");
case EnmSSH.Fsu:
return("FSU");
case EnmSSH.Device:
return("设备");
case EnmSSH.Point:
return("信号");
default:
return("未定义");
}
}
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_Offline> GetActive(EnmSSH type, EnmFormula ftype)
{
SqlParameter[] parms = { new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@FormulaType", SqlDbType.Int) };
parms[0].Value = (int)type;
parms[1].Value = (int)ftype;
var entities = new List <V_Offline>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Offline_Repository_GetActive3, 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 <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 double GetCurrentMonthTotal(string id, EnmSSH type, EnmFormula formula)
{
var now = DateTime.Now;
var start = new DateTime(now.Year, now.Month, 1);
return(_repository.GetTotal(id, type, formula, start, now));
}
public double GetLastMonthTotal(string id, EnmSSH type, EnmFormula formula)
{
var now = DateTime.Now;
var current = new DateTime(now.Year, now.Month, 1);
var start = current.AddMonths(-1);
var end = current.AddSeconds(-1);
return(_repository.GetTotal(id, type, formula, start, end));
}
public List <M_NodeInReservation> GetNodesInReservationsInType(EnmSSH type)
{
SqlParameter[] parms = { new SqlParameter("@NodeType", SqlDbType.Int) };
parms[0].Value = (int)type;
var entities = new List <M_NodeInReservation>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_M_NodesInReservation_Repository_GetNodesInReservationsInType, parms)) {
while (rdr.Read())
{
var entity = new M_NodeInReservation();
entity.ReservationId = SqlTypeConverter.DBNullStringHandler(rdr["ReservationId"]);
entity.NodeId = SqlTypeConverter.DBNullStringHandler(rdr["NodeId"]);
entity.NodeType = SqlTypeConverter.DBNullEnmSSHHandler(rdr["NodeType"]);
entities.Add(entity);
}
}
return(entities);
}
public double GetTotal(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 total = 0d;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Cs.Sql_V_Elec_Repository_GetHistory7, parms)) {
if (rdr.Read())
{
total = SqlTypeConverter.DBNullDoubleHandler(rdr["Total"]);
}
}
return(total);
}
public List <V_Offline> GetActive(EnmSSH type, EnmFormula ftype)
{
return(_repository.GetActive(type, ftype));
}
public List <V_Elec> GetActive(EnmSSH type)
{
return(_repository.GetActive(type));
}
public List <V_Elec> GetActive(string id, EnmSSH type)
{
return(_repository.GetActive(id, type));
}
public List <M_NodeInReservation> GetNodesInReservationsInType(EnmSSH type)
{
return(_repository.GetNodesInReservationsInType(type));
}
public List <V_Elec> GetActive(EnmSSH type, EnmFormula formula)
{
return(_repository.GetActive(type, formula));
}
public List <M_Formula> GetFormulas(string id, EnmSSH type)
{
return(_repository.GetFormulas(id, type));
}
public List <V_Elec> GetHistory(EnmSSH type, EnmFormula formula, DateTime start, DateTime end)
{
return(_repository.GetHistory(type, formula, start, end));
}
public M_Formula GetFormula(string id, EnmSSH type, EnmFormula formulaType)
{
return(_repository.GetFormula(id, type, formulaType));
}
public List <V_Elec> GetHistory(string id, EnmSSH type, DateTime start, DateTime end)
{
return(_repository.GetHistory(id, type, start, end));
}
public List <V_Offline> GetHistory(EnmSSH type, EnmFormula ftype, DateTime start, DateTime end)
{
return(_repository.GetHistory(type, ftype, start, end));
}
public double GetTotal(string id, EnmSSH type, EnmFormula formula, DateTime start, DateTime end)
{
return(_repository.GetTotal(id, type, formula, start, end));
}
public List <V_Elec> GetEachDay(string id, EnmSSH type, EnmFormula formula, DateTime start, DateTime end)
{
return(_repository.GetEachDay(id, type, formula, start, end));
}
