<%@ WebHandler Language="C#" Class="getXX" %>

using System;
using System.Data.Common;
using System.Collections;
using System.Text;
using System.Web;
using System.Web.SessionState;
using eMIS.Data;
public class getXX : IHttpHandler, IRequiresSessionState
{
    
    public void ProcessRequest (HttpContext context) {
		string userid = context.Request["logname"];


		if (string.IsNullOrEmpty(userid))
		{ return; }

		eDbManager manager = new eDbManager(eMIS.Data.WebConfigManager.DefaultDb);
		eDbOperator dbo = manager.CreateDbOperator();



		string logname = context.Request["logname"];
        
        int[] a = new int[2];
        string now = DateTime.Now.ToString("yyyy-MM-dd");
        string newsEnd = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
        
            string sql = "select  count(*) from XT_XXZT a  where YHM='"+ logname + "'";
            //string sql = "select top 10 a.zt,a.fssj,a.fsr,a.id from XT_XX a,XT_XXZT b where a.id=b.xxid and b.yhm='" + username + "' order by a.fssj desc";
            a[0]  = Convert.ToInt16(dbo.ExecuteScalar(sql));
            sql = "select count(*) from 新闻公告 where 日期 between '" + newsEnd + "' and '" + now + "'";
            a[1] = Convert.ToInt16(dbo.ExecuteScalar(sql));
        
        string result = "{[" + a[0] + "," + a[1] + "]}";
        context.Response.Write(result);
    }
 
    public bool IsReusable {
        get {
            return false;
        }
    }

}