<%@ WebHandler Language="C#" Class="exesql" debug="true" %>

using System;
using System.Web;
using eMIS;
using System.Data;

public class exesql : IHttpHandler, System.Web.SessionState.IRequiresSessionState
{
    public void ProcessRequest (HttpContext context)
    {
        /*
        ID	bigint	Checked
        ERR_NUM	int	Checked
        ERR_DATE	smalldatetime	Checked
        ERR_TIME	datetime	Checked
        USER_ID	bigint	Checked
        USER_CN	nvarchar(20)	Checked
        RECORD_ID	bigint	Checked
        FLOW_ID	bigint	Checked
        NODE_ID	bigint	Checked
        TASKID	bigint	Checked
        INST_DESC	nvarchar(100)	Checked
        TASK_DESC	nvarchar(100)	Checked
        NODE_DESC
        */


        DataManager dm = new DataManager();
        dm.OpenConnection();


        string MENU_ID = context.Request.QueryString["mid"].ToString();
        string USER_ID = context.Session["userid"].ToString();
        string USER_CN = UserManager.GetUserCnName(dm, USER_ID);
        string ERR_NUM = "0";

        DateTime n = DateTime.Now;





        DataTable dt = dm.ExecuteTable("select * from XT_ERR_REPORT where USER_ID=? and MENU_ID=? and ERR_DATE=? and ERR_FROM=1",USER_ID,MENU_ID,n.ToString("yyyy-MM-dd"));

        if (dt.Rows.Count == 0)
        {
            DataRow row = dt.NewRow();

            DataTable dt2;
            string mid = MENU_ID;
            string DESC = "";
            for (int i = 0; i < 10; i++)
            {
                dt2 = dm.ExecuteTable("select FuCaiDanID,CaiDanXiangMing from COM_XTCDB where ID='" +mid + "'");
                if (dt2.Rows.Count == 0)
                    break;

                DESC += (DESC == "" ? "" : "/") + dt2.Rows[0][1].ToString();
                mid = dt2.Rows[0][0].ToString();
            }

            dt2 = dm.ExecuteTable("select max(ERR_NUM) from XT_ERR_REPORT where ERR_DATE='" + n.ToString("yyyy-MM-dd") + "'");
            if (dt2.Rows.Count == 0)
            {
                ERR_NUM = "1";
            }
            else if (dt2.Rows[0][0].ToString() == "")
            {
                ERR_NUM = "1";
            }
            else
            {
                ERR_NUM = (int.Parse(dt2.Rows[0][0].ToString()) + 1).ToString();
            }

            row["ID"] = dm.GetNewID();
            row["ERR_NUM"] = ERR_NUM;
            row["ERR_DATE"] = n.ToString("yyyy-MM-dd");
            row["ERR_TIME"] = n;
            row["USER_ID"] = USER_ID;
            row["USER_CN"] = USER_CN;
            row["TASK_DESC"] = DESC;
            row["MENU_ID"] = MENU_ID;
            row["ERR_FROM"] =  1;

            dt.Rows.Add(row);
            dm.Append(dt, "XT_ERR_REPORT");

        }
        else
        {
            ERR_NUM = dt.Rows[0]["ERR_NUM"].ToString();
        }



        dm.CloseConnection();



        context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
        context.Response.Write(ERR_NUM);

    }

    public bool IsReusable {
        get {
            return false;
        }
    }

}