<%@ WebHandler Language="C#" Class="getWorkTask" Debug="true" %>

using System;
using System.Web;
using System.Text;
using System.Data;
using System.Collections;
using System.Data.Common;
using eMIS.Data;
using System.Configuration;
/***
	修改于2017年3月2日 By 朱
*/

public class getWorkTask : IHttpHandler {

    string type = "";//标志位，0代表按时间进行分组，1代表按照类别进行分组，默认为0
    string userid = "";
    string pageIndex = "1";

    public void ProcessRequest (HttpContext context) {

        if (context.Request.QueryString["userid"] == null || context.Request.QueryString["userid"].ToString() == "")
        {
            context.Response.End();
            return;
        }
        else
        {
            userid = context.Request.QueryString["userid"].ToString();
        }


        if (context.Request.QueryString["type"] == null || context.Request.QueryString["type"].ToString() == "")
        {
            type = "0";
        }
        else
        {
            type = context.Request.QueryString["type"].ToString();
        }

        if (context.Request.QueryString["pageindex"] == null || context.Request.QueryString["pageindex"].ToString() == "")
        {
            pageIndex = "1";
        }
        else
        {
            pageIndex = context.Request.QueryString["pageindex"].ToString();
        }

        ArrayList result = new ArrayList();
        if (type == "0")
        {
            result  = getWorkTaskByTime();
        }
        else
        {
            result = getWorkTaskByLB();
        }
        context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(result));
    }


    private ArrayList getWorkTaskByTime()
    {
        //初始化完毕
        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 connectionString = ConfigurationManager.AppSettings["emisdb0"].ToString();

            eDbManager manager = new eDbManager(connectionString);
            eDbOperator dbo = manager.CreateDbOperator();

            string yhm = dbo.ExecuteScalar("select login from  com_yhb where id="+userid).ToString();

            string orderBy =  " FSSJ desc";

            string sqlWhere = "yhm='" + yhm + "'";
            string sql = "select count(*) from view_xt_xx where yhm= '" + yhm + "'";
            c = (dm.executeScalar(sql)).ToString();
            temp1.Add(c);

            if (orderBy == "") orderBy = " id asc";

            sqlWhere = sqlWhere.Replace("'", "''");
            sql = "pagers " + pageIndex + ",10,'id','id,ZT,FSR,FSSJ,YY,NR,ZTT,flag,fsyhm,jsrz,yhm','view_xt_xx','" + sqlWhere + "','order by  FSSJ  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(reader[0].ToString());
                temp3.Add(reader[1].ToString());
                temp3.Add(reader[2].ToString());
                temp3.Add(DateTime.Parse(reader[3].ToString()).ToString("yyyy-MM-dd"));
                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());
                temp3.Add(reader[10].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 + "]";
        return result;
    }

    private ArrayList getWorkTaskByLB()
    {
        ArrayList result = new ArrayList();
        string sql = "select distinct(fl) from view_com_lcrw where jsrid = " + userid + " and yc = 0 order by fl";
        DbOperate dbo = new DbOperate();
        //string sql = "SELECT ID,CXID,ZDYCX,CaiDanXiangMing,target,nodetype FROM V_XTCDB WHERE ID in (SELECT c.id FROM COM_YHQXB a,COM_YHGWDZB b,COM_XTCDB c where a.GANGWEI_ID=b.GANGWEI_ID and a.CAIDAN_ID=c.ID and (b.RENYUAN_ID=" + userid + ") and c.FuCaiDanID=" + menuid + " and c.XIANSHI=1) ORDER BY CAIDANCIXU";
        DataTable dt = dbo.executeAdapter(sql);
        foreach (DataRow dr in dt.Rows)
        {
            Hashtable ht = new Hashtable();
            ht.Add("lb", dr["fl"].ToString());
            sql = "select id,描述,发送人,时间,类型,备注,lcid,jdid,jlid,jdms,qtid from view_com_lcrw where jsrid=" + userid + " and fl='" + dr[0].ToString() + "' and yc = 0 order by 时间 asc";
            DataTable dt1 = dbo.executeAdapter(sql);
            ArrayList temp = new ArrayList();
            foreach (DataRow dr1 in dt1.Rows)
            {
                ArrayList temp1 = new ArrayList();
                temp1.Add(dr1[0].ToString());
                temp1.Add(dr1[1].ToString());
                temp1.Add(dr1[2].ToString());
                temp1.Add(DateTime.Parse(dr1[3].ToString()).ToString("yyyy-MM-dd HH:mm"));
                temp1.Add(dr1[4].ToString());
                temp1.Add(dr1[5].ToString());
                temp1.Add(dr1[6].ToString());
                temp1.Add(dr1[7].ToString());
                temp1.Add(dr1[8].ToString());
                temp1.Add(dr1[9].ToString());
                temp1.Add(dr1[10].ToString());
                temp.Add(temp1);
            }
            ht.Add("child", temp);
            result.Add(ht);
        }
        return result;
    }


    public bool IsReusable {
        get {
            return false;
        }
    }

}