mobile/ajax/messageLoad.ashx

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ WebHandler Language="C#" Class="messageLoad" %>

using System;
using System.Web;
using mobile_BLL;
using mobile_DBUtility;
using mobile_DAL;
using System.Data;
using System.Collections.Generic;
using Jayrock.Json;

public class messageLoad : IHttpHandler {
    
    public void ProcessRequest (HttpContext context) {
        context.Response.ContentType = "text/plain";        
        String id = context.Request["id"];
        String page=context.Request["page"];
        int size = 5;
        int start = (Int32.Parse(page)-1) * size + 1 + 5;
        int end = start + size + 5;

        N25175_Message_BLL bll = new N25175_Message_BLL();
        SqlFrom from=new SqlFrom(N25175_Message_DAL.TableName);
        from.LeftOutJoin(N25175_Message_DAL.TableName, N25175_VIP_DAL.TableName, N25175_Message_DAL.m_from, N25175_VIP_DAL.v_id);
        SqlColumn column = new SqlColumn();
        column.Add(N25175_Message_DAL.m_msg);
        column.Add(N25175_Message_DAL.m_index);
        column.Add(N25175_Message_DAL.m_cdate);
        column.Add(N25175_VIP_DAL.v_numberID);
        column.Add(N25175_VIP_DAL.v_id);
        column.Add(N25175_VIP_DAL.v_zhaopian);
        int count;
        String colstr = column.ToColumn();
        String fromstr = from.ToFrom();
        String where = "m_to='" + id + "'";
        DataTable dt = bll.Pageing(colstr, fromstr, where, N25175_Message_DAL.m_index + " desc", null, start, end, out count);
       
        JsonObject json=new JsonObject();
        JsonArray array=new JsonArray();
       
        for(int i=0;i<dt.Rows.Count;i++)
        {
            JsonObject obj = new JsonObject();
            DataRow row = dt.Rows[i];
            obj.Accumulate("v_id", row["v_id"].ToString());
            obj.Accumulate("v_numberID", row["v_numberID"].ToString());
            obj.Accumulate("v_zhaopian", row["v_zhaopian"].ToString());
            obj.Accumulate("m_msg", row["m_msg"].ToString());
            obj.Accumulate("m_cdate", DateTime.Parse(row["m_cdate"].ToString()));


            array.Add(obj);
        }

        json.Accumulate("data", array);
        context.Response.Write(json);
        context.Response.End();
    }
 
    public bool IsReusable {