<%@ WebHandler Language="C#" Class="getNew" %>

using System;
using System.Data;
using System.Collections;
using System.Web;
using System.Web.SessionState;

public class getNew : IHttpHandler, IRequiresSessionState
{
    DbOperate dbo = null;
    public void ProcessRequest (HttpContext context) {
        string type = context.Request.QueryString["type"].ToString();
        string pageindex = context.Request.QueryString["pageindex"].ToString();

        dbo = new DbOperate();
       ArrayList result = new ArrayList();
        DataTable dt = getNewDetail(type,pageindex);
        foreach (DataRow dr in dt.Rows)
        {
            string[] tempStr = new string[4];
            tempStr[0] = dr[0].ToString();
            tempStr[1] = DateTime.Parse(dr[1].ToString()).ToString("yyyy年MM月dd日");
            tempStr[2] = dr[2].ToString();
            tempStr[3] = dr[3].ToString();
            result.Add(tempStr);
        }

        string sql = "";
        if (type == "1")
        {
            sql = "select count(*) from 新闻公告 where LB = '公司新闻' and ztz like '%N2P%' ";
        }
        else if (type == "2")
        {
            sql = "select count(*) from 新闻公告 where LB = '通知公告' and ztz like '%N2P%' ";
        } 
        else if (type == "3")
        {
            sql = "select count(*) from 新闻公告 where LB = '企业文化' and ztz like '%N2P%' ";
        }

        string allnum = dbo.executeScalar(sql).ToString();
        result.Add(allnum);
        
            //Hashtable ht = new Hashtable();
            //string[] tempStr = new string[4];
            //string tempDate = DateTime.Parse(dr[1].ToString()).ToString("yyyy年MM月dd日");
            //if (index == 0)
            //{
            //    date = tempDate;
            //    tempStr[0] = dr[0].ToString();
            //    tempStr[1] = DateTime.Parse(dr[1].ToString()).ToString("HH:mm");
            //    tempStr[2] = dr[2].ToString();
            //    tempStr[3] = dr[3].ToString();
            //    temp.Add(tempStr);
            //    index++;
            //    continue;
            //}
            
            //if (tempDate == date)
            //{
            //    tempStr[0] = dr[0].ToString();
            //    tempStr[1] = DateTime.Parse(dr[1].ToString()).ToString("HH:mm");
            //    tempStr[2] = dr[2].ToString();
            //    tempStr[3] = dr[3].ToString();
            //    temp.Add(tempStr);
            //}
            //else
            //{
            //    ht.Add("date", date);
            //    ht.Add("data", temp);
            //    result.Add(ht);
            //    date = tempDate;
            //    temp = new ArrayList();
            //    tempStr[0] = dr[0].ToString();
            //    tempStr[1] = DateTime.Parse(dr[1].ToString()).ToString("HH:mm");
            //    tempStr[2] = dr[2].ToString();
            //    tempStr[3] = dr[3].ToString();
            //    temp.Add(tempStr);
            //}
        //}
        //Hashtable ht1 = new Hashtable();
        //ht1.Add("date", date);
        //ht1.Add("data", temp);
        //result.Add(ht1);
        string nt = Newtonsoft.Json.JsonConvert.SerializeObject(result);
        context.Response.Write(nt);
    }

    private DataTable getNewDetail(string type,string pageindex)
    {
        string sqlWhere = "";
        if (type == "1")
        {
            sqlWhere = "LB='公司新闻' and ztz like '%N2P%'";
        }
        else if (type == "2")
        {
            sqlWhere = "LB='通知公告' and ZTZ like '%N2P%'";
        }
        else if (type == "3")
        {
            sqlWhere = "LB='企业文化' and ZTZ like '%N2P%'";
        }
        
        
        //string sql = "select top 10 ID,日期,标题,内容 from 新闻公告 where " + sqlWhere + " order by id desc  ";
        string sql = "pagers " + pageindex + ",10,'id','ID,日期,标题,内容','新闻公告',\"" + sqlWhere + "\",'order by  id  desc'";
        
        return dbo.executeAdapter(sql);
    }
    
    public bool IsReusable {
        get {
            return false;
        }
    }

}