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