public IEnumerable <DataItem> GetDataItem(string organizationId, params string[] variableIds)
{
IList <DataItem> results = new List <DataItem>();
//ParametersHelper.AddParamsCondition(sqlSourceBase, sourceparameters, variableIds);
DataTable sourceDt = ParametersHelper.GetCDMBalanceEnergyValue(organizationId, _nxjcFactory);
//SqlParameter parameter = new SqlParameter("organizationId",organizationId);
//DataTable sourceDt = _nxjcFactory.Query(sqlSource, parameter);
//cdy修改结束
string sqlTemplate = @"select * from (SELECT A.OrganizationID,B.VariableID,B.ValueFormula
FROM system_Organization AS A,balance_Energy_Template AS B
WHERE A.Type=B.ProductionLineType
AND B.ValueType='ElectricityConsumption'
OR B.ValueType='CoalConsumption'
AND B.Enabled='True') as C
where C.OrganizationID=@organizationId";
StringBuilder sqlTemplateBase = new StringBuilder(sqlTemplate);
IList <SqlParameter> templateparameters = new List <SqlParameter>();
templateparameters.Add(new SqlParameter("@organizationId", organizationId));
ParametersHelper.AddParamsCondition(sqlTemplateBase, templateparameters, variableIds);
DataTable templateDt = _nxjcFactory.Query(sqlTemplateBase.ToString(), templateparameters.ToArray());
string[] columns = { "CumulantClass", "CumulantDay", "CumulantMonth" };
DataTable resultDt = EnergyConsumption.EnergyConsumptionCalculate.CalculateByOrganizationId(sourceDt, templateDt, "ValueFormula", columns);
foreach (DataRow dr in resultDt.Rows)
{
DataItem itemClass = new DataItem
{
ID = dr["OrganizationID"].ToString().Trim() + ">" + dr["VariableId"].ToString().Trim() + ">Class",
Value = dr["CumulantClass"] is DBNull ? "0" : Convert.ToDecimal(dr["CumulantClass"]).ToString("#.00").Trim()
};
results.Add(itemClass);
DataItem itemDay = new DataItem
{
ID = dr["OrganizationID"].ToString().Trim() + ">" + dr["VariableId"].ToString().Trim() + ">Day",
Value = dr["CumulantDay"] is DBNull ? "0" : Convert.ToDecimal(dr["CumulantDay"]).ToString("#.00").Trim()
};
results.Add(itemDay);
DataItem itemMonth = new DataItem
{
ID = dr["OrganizationID"].ToString().Trim() + ">" + dr["VariableId"].ToString().Trim() + ">Month",
Value = dr["CumulantMonth"] is DBNull ? "0" : Convert.ToDecimal(dr["CumulantMonth"]).ToString("#.00").Trim()
};
results.Add(itemMonth);
}
return(results);
}
public IEnumerable <DataItem> GetDataItem(string organizationId, params string[] variableIds)
{
IList <DataItem> results = new List <DataItem>();
// string queryString = @"select * from (SELECT A.OrganizationID,A.VariableId,A.CumulantClass,A.CumulantLastClass,A.CumulantDay,(A.CumulantDay+(case when B.MonthValue is null then 0 else B.MonthValue end)) AS CumulantMonth
// FROM RealtimeIncrementCumulant AS A
// left join
// (select D.OrganizationID,D.VariableId,sum(D.TotalPeakValleyFlat) as MonthValue
// from tz_Balance as C, balance_Energy as D
// where C.BalanceId=D.KeyId and TimeStamp>=CONVERT(varchar(8),GETDATE(),20)+'01'
// group by D.OrganizationID, VariableId) AS B
// on A.VariableId=B.VariableId and A.OrganizationID=B.OrganizationID) AS E
// where E.OrganizationID=@organizationId";
// StringBuilder baseString = new StringBuilder(queryString);
// IList<SqlParameter> parameters = new List<SqlParameter>();
// parameters.Add(new SqlParameter("@organizationId", organizationId));
// ParametersHelper.AddParamsCondition(baseString, parameters, variableIds);
DataTable dt = ParametersHelper.GetCDMBalanceEnergyValue(organizationId, _nxjcFactory, variableIds);
foreach (DataRow dr in dt.Rows)
{
DataItem itemClass = new DataItem
{
ID = dr["OrganizationID"].ToString().Trim() + ">" + dr["VariableId"].ToString().Trim() + ">Class",
Value = dr["CumulantClass"] is DBNull ? "0" : Convert.ToDecimal(dr["CumulantClass"]).ToString("#")
};
DataItem itemDay = new DataItem
{
ID = dr["OrganizationID"].ToString().Trim() + ">" + dr["VariableId"].ToString().Trim() + ">Day",
Value = dr["CumulantDay"] is DBNull ? "0" : Convert.ToDecimal(dr["CumulantDay"]).ToString("#")
};
DataItem itemMonth = new DataItem
{
ID = dr["OrganizationID"].ToString().Trim() + ">" + dr["VariableId"].ToString().Trim() + ">Month",
Value = dr["CumulantMonth"] is DBNull?"0":Convert.ToDecimal(dr["CumulantMonth"]).ToString("#").Trim()
};
results.Add(itemClass);
results.Add(itemDay);
results.Add(itemMonth);
}
return(results);
}