public HttpResponseMessage GetLastNewIndex()
{
ResponseMessage responseMessage = new ResponseMessage(0);
HttpResponseMessage result = new HttpResponseMessage();
try
{
bool flag = false;
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*");
Dictionary <string, object> dcParams = new Dictionary <string, object>();
dcParams = DictionaryPro.RequestToDic(context);
DataTable td = new DataTable();
系统采集器Index_DAL dal = new 系统采集器Index_DAL();
td = dal.GetLastNewIndex();
responseMessage.message = new { rows = td };
result.Content = new StringContent(JsonHelper.Object2Json(responseMessage), Encoding.GetEncoding("utf-8"), "application/json");
}
catch (Exception ex)
{
//返回错误信息
//返回错误信息
responseMessage.status = -1;
responseMessage.message = ex.Message;
}
return(result);
}
public HttpResponseMessage GetVW_TodayEmissionreduction()
{
ResponseMessage responseMessage = new ResponseMessage(0);
HttpResponseMessage result = new HttpResponseMessage();
try
{
HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context
HttpContext.Current.Response.AddHeader("Access-Control-Allow-Origin", "*");
Dictionary <string, object> dcParams = new Dictionary <string, object>();
dcParams = DictionaryPro.RequestToDic(context);
int cnt = 0;
DateTime starttm = DateTime.Parse(DictionaryPro.GetDicValue(dcParams, "starttm"));
DateTime endtm = DateTime.Parse(DictionaryPro.GetDicValue(dcParams, "endtm"));
DataTable MyDataTable = new DataTable();
//DAL
系统采集器Index_DAL dal = new 系统采集器Index_DAL();
DataTable list = dal.GetVW_TodayEmissionreduction(starttm, endtm);
//构造列
MyDataTable.Columns.Add(new DataColumn("AllQuse", typeof(float)));
MyDataTable.Columns.Add(new DataColumn("AllQss", typeof(float)));
MyDataTable.Columns.Add(new DataColumn("Allmco2", typeof(float)));
MyDataTable.Columns.Add(new DataColumn("Allmso2", typeof(float)));
MyDataTable.Columns.Add(new DataColumn("Allmnox", typeof(float)));
MyDataTable.Columns.Add(new DataColumn("Allmfc", typeof(float)));
//构造行
DataRow dr;
dr = MyDataTable.NewRow();
dr["AllQuse"] = Convert.ToDouble(list.Rows[list.Rows.Count - 1][1]) - Convert.ToDouble(list.Rows[0][1]);
dr["AllQss"] = (Convert.ToDouble(list.Rows[list.Rows.Count - 1][2]) - Convert.ToDouble(list.Rows[0][2])) * 0.001; //*0.001是为了单位换算
dr["Allmco2"] = (Convert.ToDouble(list.Rows[list.Rows.Count - 1][3]) - Convert.ToDouble(list.Rows[0][3])) * 0.001;
dr["Allmso2"] = (Convert.ToDouble(list.Rows[list.Rows.Count - 1][4]) - Convert.ToDouble(list.Rows[0][4])) * 0.001;
dr["Allmnox"] = (Convert.ToDouble(list.Rows[list.Rows.Count - 1][5]) - Convert.ToDouble(list.Rows[0][5])) * 0.001;
dr["Allmfc"] = (Convert.ToDouble(list.Rows[list.Rows.Count - 1][6]) - Convert.ToDouble(list.Rows[0][6])) * 0.001;
MyDataTable.Rows.Add(dr);
//返回数据
responseMessage.message = new { total = cnt, rows = MyDataTable };
result.Content = new StringContent(JsonHelper.Object2Json(responseMessage), Encoding.GetEncoding("utf-8"), "application/json");
}
catch (Exception ex)
{
//返回错误信息
//responseMessage.status = -1;
//responseMessage.message = ex.Message;
}
return(result);
}
