<%@ WebHandler Language="C#" Class="getnewdata" %>
using System;
using System.Web;
using System.Text;
using System.Collections;
using System.IO;
using eMIS.Data;
using System.Data;
using System.Web.SessionState;
using System.Data.Common;


public class getnewdata : IHttpHandler, IRequiresSessionState
{

    public void ProcessRequest(HttpContext context)
    {

		string userid = context.Request["userid"];


		if (string.IsNullOrEmpty(userid))
		{ return; }
		
		eDbManager manager = new eDbManager(eMIS.Data.WebConfigManager.DefaultDb);
		eDbOperator dbo = manager.CreateDbOperator();
		
        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 = "";
            string sqlWhere = "1=1";

            sqlWhere = "jsrid=" + userid + " and (" + sqlWhere + ")";
            string sql = "select count(*) from xt_lcrw where jsrid= '" + userid +"'";
            c = (dbo.ExecuteScalar(sql)).ToString();
            temp1.Add(c);
            
            if (orderBy == "") orderBy = " id asc";

            sqlWhere = sqlWhere.Replace("'", "''");
            sql = "pagers "+pageIndex+",10,'id','id,描述,发送人,时间,类型,备注,lcid,jdid,jlid,jdms','view_com_lcrw','"+sqlWhere+"','order by "+orderBy+"'";

            //string sql = "select top 10 id,描述,发送人,时间,类型,备注 from view_com_lcrw where  jsrid = '" + userId + "' order by id";
            DbDataReader reader =dbo.ExecuteReader(sql);
            while (reader.Read())
            {
                ArrayList temp3 = new ArrayList();
                temp3.Add(reader[0].ToString());
                temp3.Add(reader[1].ToString());
                temp3.Add(reader[2].ToString());
                temp3.Add(DateTime.Parse(reader[3].ToString()).ToString("yyyy-MM-dd HH:mm"));
                temp3.Add(reader[4].ToString());
                s = reader[5].ToString();
                s = s.Replace("\r\n", "");
                s = s.Replace("\n", "");
                temp3.Add(s);
                temp3.Add(reader[6].ToString());
                temp3.Add(reader[7].ToString());
                temp3.Add(reader[8].ToString());
                temp3.Add(reader[9].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));
        context.Response.Write(sb.ToString());
    }

 
    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}