微信幸运九宫格抽奖源码/51wsb_wxjgg/allzjlist.ashx.cs

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

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

using System;
using System.Collections;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace wxjgg
{
    /// <summary>
    /// $codebehindclassname$ 的摘要说明
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    public class allzjlist : IHttpHandler
    {

        public int hdid;
        public int page;
        public int itempage = 10;//每页显示数量
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            //不让浏览器缓存
            context.Response.Buffer = true;
            context.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1);
            context.Response.AddHeader("pragma", "no-cache");
            context.Response.AddHeader("cache-control", "");
            context.Response.CacheControl = "no-cache";
            context.Response.ContentType = "text/plain";

            page = Convert.ToInt32(context.Request["page"]);
            hdid = Convert.ToInt32(context.Request["hdid"]);

            context.Response.Write(list());
        }
        //手机号码加密隐藏
        public string phonechar(string str)
        {
            if (str != "")
            {
                string newstr = str.Substring(0, 3) + "*****" + str.Substring(str.Length - 3, 3);
                return newstr;
            }
            else
            {
                return "**********";
            }
        }
        public string list()
        {
            string result = "";
            SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["sqldb"].ToString());
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            string sqlstr = "";
            sqlstr = "select TOP " + itempage.ToString() + " * FROM zjlist where id NOT IN ( select TOP " + (itempage * (page - 1)).ToString() + " id FROM zjlist where  hdid=@hdid order by id desc) and hdid=@hdid order by id desc";