Beispiel #1
0
        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;
        }