<%@ WebHandler Language="C#" Class="getCarData" %>

using System;
using System.Web;
using System.Collections;
using System.Data.Common;

public class getCarData : IHttpHandler {

    DbOperate dbo = null;
    public void ProcessRequest (HttpContext context) {

        string userid = context.Request.QueryString["userid"].ToString();
        string pageIndex = context.Request.QueryString["pageindex"].ToString();
        dbo = new DbOperate();
        ArrayList result = new ArrayList();
        ArrayList temp1 = new ArrayList();
        ArrayList temp2 = new ArrayList();
        string c = "0";
        int i = 0;
        string s;
        if (userid != "")
        {
            // string pageIndex = "1";
            string orderBy = " rq desc";
            string sqlWhere = "renyuan_id=" + userid;
            string sql = "select count(*) from View_汽车蓝牙明细 where renyuan_id= '" + userid + "'";
            c = (dbo.executeScalar(sql)).ToString();
            temp1.Add(c);

            if (orderBy == "") orderBy = " rq asc";

            sqlWhere = sqlWhere.Replace("'", "''");
            sql = "pagers " + pageIndex + ",10,'id','id,rq,wday,jrsj,lksj','View_汽车蓝牙明细','" + sqlWhere + "','order by  rq  desc'";

            //string sql = "select top 10 id,描述,发送人,时间,类型,备注 from view_com_lcrw where  jsrid = '" + userId + "' order by id";
            DbDataReader reader = dbo.ExecuteDataReader(sql);
            while (reader.Read())
            {
                ArrayList temp3 = new ArrayList();
                temp3.Add(reader[0].ToString());
                string ymd = DateTime.Parse(reader[1].ToString()).ToString("yyyy-MM-dd");
                temp3.Add(ymd);
                temp3.Add(reader[2].ToString());
                string hs = reader[3].ToString();
                temp3.Add(hs);
                temp3.Add(reader[4].ToString());
                DateTime jrsj = DateTime.Parse(ymd + " " + hs);
                DateTime comsj = DateTime.Parse(ymd + " 08:30");
                if (ymd == "" || hs == "" || jrsj.CompareTo(comsj) > 0)
                    temp3.Add(1);
                else
                    temp3.Add(0);
                temp2.Add(temp3);
                i++;
            }

            reader.Close();
        }
        temp1.Insert(0, i.ToString());
        result.Add(temp1);
        result.Add(temp2);
        
        context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(result));
    }
 
    public bool IsReusable {
        get {
            return false;
        }
    }

}