<%@ WebHandler Language="C#" Class="survery"  Debug="true" %>
using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.Data.Common;
using System.Text;
using System.Web.SessionState;
using eMIS;
using eMIS.Data;

public class survery : IHttpHandler, IRequiresSessionState
{
    public void ProcessRequest (HttpContext context)
    {

        string questionId = context.Request.Form["id"].ToString();
        string userId;

        DataManager dm = new DataManager();
        DataTable dt;

        if (context.Session["userid"] != null)
        {
            userId = context.Session["userid"].ToString();
        }
        else
        {
            string userLogin = WeiXinWebCommon.ReadCookieUserId(context);
            userId = dm.Operator.ExecuteScalar("select id,xingming from com_yhb where login='" + userLogin + "'").ToString();
        }



        string newsubmitid = dm.GetNewID();
        dm.ExecuteNonQuery("insert into wj_ques_users (id,quesid,userid,submittime) values (" + newsubmitid + ","+questionId+","+userId+",getdate())");



        dt = dm.ExecuteTable("select * from wj_ques_items where qid="+questionId);
        int l = dt.Rows.Count;
        string itemId,itemType,resultId,s;
        string[] values;
        int ii;
        for(int i=0;i<l;i++)
        {
            itemId = dt.Rows[i]["id"].ToString();
            itemType = dt.Rows[i]["itemtype"].ToString();
            if (context.Request.Form["c_" + itemId] != null)
            {
                s = context.Request.Form["c_" + itemId].ToString();
                values =s.Split(';');
                if (s.Length > 50) s = s.Substring(0, 50);
                dm.ExecuteNonQuery("insert into wj_ques_users_items (id,pid,quesid,itemid,itemval) values (" + dm.GetNewID() + "," + newsubmitid + ","+questionId+"," + itemId + ",'" + s + "')");

                if (itemType == "1" || itemType == "2" || itemType=="4" || itemType=="5")
                {
                    for (ii = 0; ii < values.Length; ii++)
                    {
                        dm.ExecuteNonQuery("update wj_ques_result set num=num+1 where itemid="+itemId+" and idx="+values[ii]);
                    }

                    if (itemType == "4" || itemType == "5")
                    {
                        if (context.Request.Form["ck-" + itemId + "-i"].ToString() != "")
                            dm.ExecuteNonQuery("insert into wj_ques_users_input (id,quesid,itemid,userid,input) values (" + dm.GetNewID() + "," + questionId + "," + itemId + "," + userId + ",'" + context.Request.Form["ck-" + itemId + "-i"].ToString() + "')");
                    }
                }
                else if(itemType=="6")
                {

                    for (ii = 0; ii < values.Length; ii=ii+2)
                    {
                        resultId = dm.ExecuteScalar("select id from wj_ques_result where itemid=" + itemId + " and idx="+ values[ii]).ToString();
                        dm.ExecuteNonQuery("update wj_ques_result set num=num+1 where itemid=" + resultId + " and idx=" + values[ii + 1]);
                    }


                }


            }
        }
        dm.ExecuteNonQuery("update wj_ques set r_number=r_number+1 where id=" + questionId);

        context.Response.Redirect("list.aspx?"+DateTime.Now.Ticks.ToString());

    }



    public bool IsReusable
    {
        get
        {
            return false;
        }
    }
}