public IList<Hashtable> GetChartData(string id)
{
double capacity = 0;
string errMsg = "";
DataTable dt = null;
string sql = "";
if (id == "1")
{
sql = "select T_PLANTID,t_base_plant.T_COMID,T_COMNAME from t_base_plant " +
"left join T_BASE_COMPANY on T_BASE_COMPANY.T_COMID =t_base_plant.T_COMID order by t_base_plant.T_COMID asc";
}
else if (id == "2")
{
sql = "select T_PLANTID,t_base_plant.T_DEPID as T_COMID,T_DEPNAME as T_COMNAME from t_base_plant " +
"left join T_BASE_DEPARTMENT on T_BASE_DEPARTMENT.T_DEPID =t_base_plant.T_DEPID order by t_base_plant.T_DEPID asc";
}
else if (id == "3")
{
sql = "select T_PLANTID,t_base_plant.t_plantid as T_COMID,t_base_plant.t_plantname as T_COMNAME from t_base_plant inner join "+
"T_BASE_DEPARTMENT on T_BASE_DEPARTMENT.T_DEPID =t_base_plant.T_DEPID and t_base_plant.T_comid ='C_DIMIAN' order by t_base_plant.t_plantid asc";
}
else if (id == "4")
{
sql = "select T_PLANTID,t_base_plant.t_plantid as T_COMID,t_base_plant.t_plantname as T_COMNAME from t_base_plant inner join " +
"T_BASE_DEPARTMENT on T_BASE_DEPARTMENT.T_DEPID =t_base_plant.T_DEPID and t_base_plant.T_comid ='C_BAPV' order by t_base_plant.t_plantid asc";
}
dt = dl.RunDataTable(sql, out errMsg);
IList<Hashtable> listdata = new List<Hashtable>();
Hashtable ht = new Hashtable();
ArrayList ld = new ArrayList();
ArrayList lt = new ArrayList();
DAL.DALDefault df = new DALDefault();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
capacity +=df.GetPowerByDianzhan(dt.Rows[i]["T_PLANTID"].ToString(), DateTime.Now);
}
else if (dt.Rows[i]["T_COMID"].ToString() == dt.Rows[i - 1]["T_COMID"].ToString())
{
capacity += df.GetPowerByDianzhan(dt.Rows[i]["T_PLANTID"].ToString(), DateTime.Now);
}
else
{
ld.Add(dt.Rows[i - 1]["T_COMNAME"].ToString());
ld.Add(Math.Round(capacity, 2));
lt.Add(ld);
ld = new ArrayList();
capacity = df.GetPowerByDianzhan(dt.Rows[i]["T_PLANTID"].ToString(), DateTime.Now);
}
if (i == dt.Rows.Count - 1)
{
ld.Add(dt.Rows[i]["T_COMNAME"].ToString());
ld.Add(Math.Round(capacity, 2));
lt.Add(ld);
ht.Add("name", "发电比重");
ht.Add("data", lt);
listdata.Add(ht);
}
}
}
return listdata;
}
public IList <Hashtable> GetChartData(string id)
{
double capacity = 0;
string errMsg = "";
DataTable dt = null;
string sql = "";
if (id == "1")
{
sql = "select T_PLANTID,t_base_plant.T_COMID,T_COMNAME from t_base_plant " +
"left join T_BASE_COMPANY on T_BASE_COMPANY.T_COMID =t_base_plant.T_COMID order by t_base_plant.T_COMID asc";
}
else if (id == "2")
{
sql = "select T_PLANTID,t_base_plant.T_DEPID as T_COMID,T_DEPNAME as T_COMNAME from t_base_plant " +
"left join T_BASE_DEPARTMENT on T_BASE_DEPARTMENT.T_DEPID =t_base_plant.T_DEPID order by t_base_plant.T_DEPID asc";
}
else if (id == "3")
{
sql = "select T_PLANTID,t_base_plant.t_plantid as T_COMID,t_base_plant.t_plantname as T_COMNAME from t_base_plant inner join " +
"T_BASE_DEPARTMENT on T_BASE_DEPARTMENT.T_DEPID =t_base_plant.T_DEPID and t_base_plant.T_comid ='C_DIMIAN' order by t_base_plant.t_plantid asc";
}
else if (id == "4")
{
sql = "select T_PLANTID,t_base_plant.t_plantid as T_COMID,t_base_plant.t_plantname as T_COMNAME from t_base_plant inner join " +
"T_BASE_DEPARTMENT on T_BASE_DEPARTMENT.T_DEPID =t_base_plant.T_DEPID and t_base_plant.T_comid ='C_BAPV' order by t_base_plant.t_plantid asc";
}
dt = dl.RunDataTable(sql, out errMsg);
IList <Hashtable> listdata = new List <Hashtable>();
Hashtable ht = new Hashtable();
ArrayList ld = new ArrayList();
ArrayList lt = new ArrayList();
DAL.DALDefault df = new DALDefault();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
capacity += df.GetPowerByDianzhan(dt.Rows[i]["T_PLANTID"].ToString(), DateTime.Now);
}
else if (dt.Rows[i]["T_COMID"].ToString() == dt.Rows[i - 1]["T_COMID"].ToString())
{
capacity += df.GetPowerByDianzhan(dt.Rows[i]["T_PLANTID"].ToString(), DateTime.Now);
}
else
{
ld.Add(dt.Rows[i - 1]["T_COMNAME"].ToString());
ld.Add(Math.Round(capacity, 2));
lt.Add(ld);
ld = new ArrayList();
capacity = df.GetPowerByDianzhan(dt.Rows[i]["T_PLANTID"].ToString(), DateTime.Now);
}
if (i == dt.Rows.Count - 1)
{
ld.Add(dt.Rows[i]["T_COMNAME"].ToString());
ld.Add(Math.Round(capacity, 2));
lt.Add(ld);
ht.Add("name", "发电比重");
ht.Add("data", lt);
listdata.Add(ht);
}
}
}
return(listdata);
}
