<%@ WebHandler Language="C#" Class="getSignHis" %>

using System;
using System.Web;
using System.Text;
using System.Collections;
using System.Data.Common;

public class getSignHis : IHttpHandler {
    
    public void ProcessRequest (HttpContext context) {
        string userid = context.Request.QueryString["userid"].ToString();
        string pageindex = context.Request.QueryString["pageindex"].ToString();

        //初始化完毕
        DbOperate dm = new DbOperate();
        StringBuilder sb = new StringBuilder();
        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 = " 时间 desc";

            string sqlWhere = "  userid=" + userid;
            string sql = "select count(*) from xt_coord where  userid= '" + userid + "'";
            c = (dm.executeScalar(sql)).ToString();
            temp1.Add(c);

            //if (orderBy == "") orderBy = " id asc";

            sqlWhere = sqlWhere.Replace("'", "''");
            sql = "pagers " + pageindex + ",10,'id','dt,address,bz','xt_coord','" + sqlWhere + "','order by  dt desc'";

            //string sql = "select top 10 id,描述,发送人,时间,类型,备注 from view_com_lcrw where  jsrid = '" + userId + "' order by id";
            DbDataReader reader = dm.ExecuteDataReader(sql);
            while (reader.Read())
            {
                ArrayList temp3 = new ArrayList();
                temp3.Add(DateTime.Parse(reader[0].ToString()).ToString("yyyy-MM-dd HH:mm"));
                temp3.Add(reader[1].ToString());
                temp3.Add(reader[2].ToString());
                temp2.Add(temp3);
                //sb.Append(",['" + reader[0].ToString() + "','" + reader[1].ToString() + "','" + reader[2].ToString() + "'");
                //s = reader[5].ToString();
                //s = s.Replace("\r\n", "");
                //s = s.Replace("\n", "");
                //sb.Append(",'" + DateTime.Parse( reader[3].ToString()).ToString("yyyy-MM-dd HH:mm") + "','" + reader[4].ToString() + "','" + s + "'");
                //sb.Append(",'" + reader[6].ToString() + "','" + reader[7].ToString() + "','" + reader[8].ToString() + "','" + reader[9].ToString() + "']");
                i++;
            }

            reader.Close();

        }
        else
        {
        }
        //sb.Append("]}");
        temp1.Insert(0, i.ToString());
        result.Add(temp1);
        result.Add(temp2);
        // string result = "{rows:[[" + i.ToString() + "," + c + "]";
        context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(result));
    }
 
    public bool IsReusable {
        get {
            return false;
        }
    }

}