/// <summary>
/// 根据时间获取五大集团最优机组供电煤耗信息。
/// </summary>
/// <param name="times"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public List<BestUnitConsumeInfo> GetInfoByTime(string times, out string errMsg)
{
DataTable dts=dt.GetInfoByTime(times, out errMsg);
List<BestUnitConsumeInfo> infoList = new List<BestUnitConsumeInfo>();
//转化为list，筛选。
if (dts.Rows.Count > 0)
{
for (int i = 0; i < dts.Rows.Count; i++)
{
BestUnitConsumeInfo info = new BestUnitConsumeInfo();
info.T_COMPANY = String.IsNullOrEmpty(dts.Rows[i]["T_COMPANY"].ToString()) ? String.Empty : dts.Rows[i]["T_COMPANY"].ToString();
info.T_900_SL = String.IsNullOrEmpty(dts.Rows[i]["T_900_SL"].ToString()) ? 0 : Convert.ToDouble(dts.Rows[i]["T_900_SL"].ToString());
info.T_600_HJ = String.IsNullOrEmpty(dts.Rows[i]["T_600_HJ"].ToString()) ? 0 : Convert.ToDouble(dts.Rows[i]["T_600_HJ"].ToString());
info.T_300_HJ = String.IsNullOrEmpty(dts.Rows[i]["T_300_HJ"].ToString()) ? 0 : Convert.ToDouble(dts.Rows[i]["T_300_HJ"].ToString());
info.T_200_HJ = String.IsNullOrEmpty(dts.Rows[i]["T_200_HJ"].ToString()) ? 0 : Convert.ToDouble(dts.Rows[i]["T_200_HJ"].ToString());
info.T_120_HJ = String.IsNullOrEmpty(dts.Rows[i]["T_120_HJ"].ToString()) ? 0 : Convert.ToDouble(dts.Rows[i]["T_120_HJ"].ToString());
infoList.Add(info);
}
}
return infoList;
}
public void ProcessRequest(HttpContext context)
{
string time = context.Request["beginTime"].ToString() != "undefined" ? context.Request["beginTime"].ToString() : string.Empty;
string times = string.Empty;
AllInfo aInfo = new AllInfo();
//时间
//times += String.IsNullOrEmpty(time) ? string.Empty : time + "-01 00:00:00.0";
//times = "2013-05-01 00:00:00.0";
//五大集团供电煤耗
List<BestUnitConsumeInfo> info = new List<BestUnitConsumeInfo>();
info = bt.GetInfoByTime(time, out errMsg);
List<BestUnitConsumeInfo> saveInfo = new List<BestUnitConsumeInfo>();
BestUnitConsumeInfo tmp = new BestUnitConsumeInfo();
if (info.Count > 0)
{
tmp = info.Where(infos => infos.T_COMPANY.Trim() == "华电").FirstOrDefault();
saveInfo.Add(tmp);
tmp = info.Where(infos => infos.T_COMPANY.Trim() == "华能").FirstOrDefault();
saveInfo.Add(tmp);
tmp = info.Where(infos => infos.T_COMPANY.Trim() == "大唐").FirstOrDefault();
saveInfo.Add(tmp);
tmp = info.Where(infos => infos.T_COMPANY.Trim() == "国电").FirstOrDefault();
saveInfo.Add(tmp);
tmp = info.Where(infos => infos.T_COMPANY.Trim() == "中电投").FirstOrDefault();
saveInfo.Add(tmp);
}
else
{
for (int i = 0; i < 4; i++)
{ saveInfo.Add(tmp); }
}
aInfo.SInfo = saveInfo;
saveInfo = null;
//供电煤耗月线
List<MonthConsumeInfo> mTmp = bc.GetMonthConsume(out errMsg);
List<MonthConsumeInfo> m = new List<MonthConsumeInfo>();
aInfo.Minfo = new List<ArrayList>();
//2011年
ArrayList al = new ArrayList();
m = mTmp.Where(tinfo => tinfo.year == 2011).OrderBy(infos => infos.month).ToList();
foreach (MonthConsumeInfo ts in m)
{
al.Add(ts.values);
}
aInfo.Minfo.Add(al);
//2012年
al = new ArrayList();
m = mTmp.Where(tinfo => tinfo.year == 2012).OrderBy(infos => infos.month).ToList();
foreach (MonthConsumeInfo ts in m)
{
al.Add(ts.values);
}
aInfo.Minfo.Add(al);
//2013年
al = new ArrayList();
m = mTmp.Where(tinfo => tinfo.year == 2013).OrderBy(infos => infos.month).ToList();
foreach (MonthConsumeInfo ts in m)
{
al.Add(ts.values);
}
aInfo.Minfo.Add(al);
string content = aInfo.ToJsonItem();
context.Response.ContentType = "text/json;charset=gb2312;";
context.Response.Write(content);
}