<%@ WebHandler Language="C#" Class="UpdateDZ" %>

using System;
using System.Web;
using System.Collections;
using System.Data;

public class UpdateDZ : IHttpHandler {
    DbOperate dbo = null;
    public void ProcessRequest (HttpContext context) {
        string id = context.Request.QueryString["id"].ToString();
        string userid = context.Request.QueryString["userid"].ToString();
        string tag = context.Request.QueryString["tag"].ToString();
        ArrayList result = new ArrayList();
        string sql = "update zh_公司相册_记录 set type = '" + tag + "' where userid = " + userid + " and zid = " + id;
        dbo = new DbOperate();
        int i = -1;
        if ( (i = dbo.ExNonQuery(sql)) <= 0)
        {
            sql = "insert into zh_公司相册_记录(zid,userid,type) values(" + id + "," + userid + ",1)";
            i = dbo.ExNonQuery(sql);
        }
        
        result.Add(dbo.ExNonQuery(sql).ToString());
        
        sql = "select * from zh_公司相册_记录 a,com_yhb b where a.userid=b.id  and zid=" + id + " and type = 1";
        DataTable dt = dbo.ExecuteDataTable(sql);
        string ry = "";
        int index = 0;
        ArrayList dzrylist = new ArrayList();
        foreach (DataRow dr in dt.Rows)
        {
            if (index == 0)
            {
                dzrylist.Add(dr["userid"].ToString());
            }
            else
            {
                if (dzrylist.Contains(dr["userid"].ToString()))
                    continue;
                else
                    dzrylist.Add(dr["userid"].ToString());
            }
          
           ry += dr["xingming"].ToString() + ",";
            index++;
        }
        if(index != 0)
            ry = ry.Substring(0, ry.Length - 1);
        
        result.Add(ry);
        result.Add(index);

        context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(result));
    }
 
    public bool IsReusable {
        get {
            return false;
        }
    }

}