<%@ WebHandler Language="C#" Class="GetKQData" %>

using System;
using System.Web;
using System.Collections;
using System.Data.Common;

public class GetKQData : 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 = "userid=" + userid;
            string sql = "select count(*) from xt_wx_kqqd where userid= '" + userid + "'";
            c = (dbo.executeScalar(sql)).ToString();
            temp1.Add(c);

            if (orderBy == "") orderBy = " rq asc";

            sqlWhere = sqlWhere.Replace("'", "''");
            sql = "pagers " + pageIndex + ",10,'id','id,signindate,signinhm,signouthm','xt_wx_kqqd','" + sqlWhere + "','order by  signindate  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());
                DateTime dtime = DateTime.Parse(reader[1].ToString());
                string ymd = dtime.ToString("yyyy-MM-dd");
                temp3.Add(ymd);
                
                string weekday = dtime.DayOfWeek.ToString();
                switch (weekday)
                {
                    case "Monday": weekday = "星期一"; break;
                    case "Tuesday": weekday = "星期二"; break;
                    case "Wednesday": weekday = "星期三"; break;
                    case "Thursday": weekday = "星期四"; break;
                    case "Friday": weekday = "星期五"; break;
                    case "Saturday": weekday = "星期六"; break;
                    case "Sunday": weekday = "星期日"; break;
                }
                temp3.Add(weekday);

                string hs = "";
                if (reader[2] != DBNull.Value && reader[2].ToString() != "")
                {
                    hs = reader[2].ToString().Replace('.', ':');
                }
                temp3.Add(hs);

                string hs1 = "";
                if (reader[3] != DBNull.Value && reader[3].ToString() != "")
                {
                    hs1 = reader[3].ToString().Replace('.', ':');
                }
                temp3.Add(hs1);

                if (hs != "")
                {
                    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);
                }
                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;
        }
    }

}