public static string GetEnergyIconCls(EnmFormula formula)
{
switch (formula)
{
case EnmFormula.KT:
return("ipems-icon-font-kongtiao");
case EnmFormula.ZM:
return("ipems-icon-font-zhaoming");
case EnmFormula.BG:
return("ipems-icon-font-computer");
case EnmFormula.DY:
return("ipems-icon-font-dianyuan");
case EnmFormula.UPS:
return("ipems-icon-font-ups");
case EnmFormula.IT:
return("ipems-icon-font-vdevice");
case EnmFormula.QT:
return("ipems-icon-font-nenghao");
case EnmFormula.TT:
return("ipems-icon-font-jifang");
case EnmFormula.PUE:
return("ipems-icon-font-zhishu");
default:
return("ipems-icon-font-nenghao");
}
}
public static string GetEnergyColorCls(EnmFormula formula)
{
switch (formula)
{
case EnmFormula.KT:
return("indicator-kt");
case EnmFormula.ZM:
return("indicator-zm");
case EnmFormula.BG:
return("indicator-bg");
case EnmFormula.DY:
return("indicator-dy");
case EnmFormula.UPS:
return("indicator-ups");
case EnmFormula.IT:
return("indicator-it");
case EnmFormula.QT:
return("indicator-qt");
case EnmFormula.TT:
return("indicator-tt");
case EnmFormula.PUE:
return("indicator-pue");
default:
return("indicator-qt");
}
}
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 <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 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 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 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 static string GetEnergyDisplay(EnmFormula formula)
{
switch (formula)
{
case EnmFormula.KT:
return("空调");
case EnmFormula.ZM:
return("照明");
case EnmFormula.BG:
return("办公");
case EnmFormula.DY:
return("开关电源");
case EnmFormula.UPS:
return("UPS");
case EnmFormula.IT:
return("IT设备");
case EnmFormula.QT:
return("其他");
case EnmFormula.TT:
return("总计");
case EnmFormula.PUE:
return("PUE");
case EnmFormula.WD:
return("温度");
case EnmFormula.SD:
return("湿度");
default:
return("未定义");
}
}
public List <Formula> GetEntities(EnmFormula type)
{
SqlParameter[] parms = { new SqlParameter("@FormulaType", SqlDbType.Int) };
parms[0].Value = (int)type;
var entities = new List <Formula>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_Formula_Repository_GetEntities, parms)) {
while (rdr.Read())
{
var entity = new 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 void DeleteEntities(string id, EnmOrganization type, EnmFormula formulaType, 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.DBNullDateTimeHandler(start);
parms[1].Value = SqlTypeConverter.DBNullDateTimeHandler(end);
using (var conn = new SqlConnection(this._databaseConnectionString)) {
conn.Open();
var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
try {
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlCommands_Cs.Sql_V_Elec_Repository_DeleteEntities, parms);
trans.Commit();
} catch {
trans.Rollback();
throw;
}
}
}
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, EnmFormula formula)
{
return(_repository.GetActive(type, formula));
}
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_Offline> GetHistory(EnmSSH type, EnmFormula ftype, DateTime start, DateTime end)
{
return(_repository.GetHistory(type, ftype, 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));
}
public double GetTotal(string id, EnmSSH type, EnmFormula formula, DateTime start, DateTime end)
{
return(_repository.GetTotal(id, type, formula, start, end));
}