<%@ WebHandler Language="C#" Class="UpdatePL" %>

using System;
using System.Web;
using System.Collections;
using System.Data;


public class UpdatePL : IHttpHandler {

    DbOperate dbo = null;
    public void ProcessRequest (HttpContext context) {
        string pl = context.Request.QueryString["pl"].ToString();
        string userid = context.Request.QueryString["userid"].ToString();
        string id = context.Request.QueryString["id"].ToString();
        string sql = "insert into zh_公司相册_记录(zid,userid,type,pl,plrq) values(" + id + "," + userid + ",0,'" + pl + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')";
        dbo = new DbOperate();
        ArrayList result = new ArrayList();
        string tag = dbo.ExNonQuery(sql).ToString();
        result.Add(tag);

        sql = "select * from zh_公司相册_记录 a,com_yhb b where a.userid = b.id and zid = " + id + " and pl <> '' order by plrq";
        DataTable dt = dbo.ExecuteDataTable(sql);
        int plnum = 0;
        ArrayList pllist = new ArrayList();
        foreach (DataRow dr in dt.Rows)
        {
            string[] temp = new string[3];
            temp[0] = dr["xingming"].ToString();
            temp[1] = dr["pl"].ToString();
            temp[2] = DateTime.Parse(dr["plrq"].ToString()).ToString("yyyy-MM-dd");
            plnum++;
            pllist.Add(temp);
        }
        result.Add(pllist);
        result.Add(plnum);

        context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(result));
    }
 
    public bool IsReusable {
        get {
            return false;
        }
    }

}