private void GetAlarmsList(HttpContext context) { int numOfRecords = 0; StringBuilder sb = new StringBuilder(); if (context.Request.Params["starttime"] == null) { } if (context.Request.Params["endtime"] == null) { } if (context.Request.Params["dusttype"] == null) { } if (context.Request.Params["cityId"] == null) { } string startTime = context.Request.Params["starttime"]; string endTime = context.Request.Params["endtime"]; string dusttype = context.Request.Params["dusttype"]; string cityId = context.Request.Params["cityId"]; sb.AppendFormat("UpdateTime >=\'{0}' and UpdateTime <=\'{1}' and Country=\'{2}\'", startTime, endTime, cityId); if (dusttype == "0") { _dataTable = _bll.GetDustOverDataPerDay(sb.ToString()).Tables[0]; foreach (DataRow dr in _dataTable.Rows) { _json.AddItem("Val", dr["Total"].ToString()); _json.AddItem("Time", dr["UpdateTime"].ToString()); _json.ItemOk(); numOfRecords++; } } else if (dusttype == "1") { _dataTable = _bll.GetDustOverDataPerDay(sb.ToString()).Tables[0]; foreach (DataRow dr in _dataTable.Rows) { _json.AddItem("Val", dr["Total"].ToString()); _json.AddItem("Time", dr["UpdateTime"].ToString()); _json.ItemOk(); numOfRecords++; } } _json.success = true; _json.totalCount = numOfRecords; }