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); }