c#（asp.net）杂谈笔记

 //转换json格式时间的方法 如Date(1340239979000)转换为正常
            function ConvertJSONDateToJSDateObject(JSONDateString) {
                var date = new Date(parseInt(JSONDateString.replace("/Date(", "").replace(")/", ""), 10));
                var year = date.getFullYear();
                var month = date.getMonth + 1 < 10 ? "0" + (date.getMonth() + 1) : date.getMonth() + 1;
                var currentDate = date.getDate() < 10 ? "0" + date.getDate() : date.getDate();
                var hour = date.getHours();
                var minute = date.getMinutes();
                var second = date.getSeconds();
                var datastr = year + "-" + month + "-" + currentDate + " " + hour + ":" + minute + ":" + second;
                return datastr;
            }

with a as 
(
   select * from TbRegion where RegionUid='1'
   union all
   select s.* from TbRegion as s , a where s.ParRegionUid=a.RegionUid   ---这里查的a表是那个表啊？
)
select * from a

using System.Web.SessionState;  //添加此引用
public class roadshow_demo : IHttpHandler, IReadOnlySessionState   //继承IReadOnlySessionState接口
{ 
    
    public void ProcessRequest (HttpContext context) {
        context.Response.ContentType = "text/plain";

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

using System.Net;
using System.IO;
using System.Text;
using System.Text.RegularExpressions;
using HtmlAgilityPack;

namespace asp.net技术点测试
{
    public partial class _Default : System.Web.UI.Page
    {
        //HtmlAgilityPack.dll
        //http://blog.cnfol.com/jldgold
        protected string aa;
        protected void Page_Load(object sender, EventArgs e)
        {
            //HttpWebRequest httpWebRequest = WebRequest.Create(@"http://blog.cnfol.com/jldgold/list") as HttpWebRequest;
            //HttpWebResponse httpWebResponse = httpWebRequest.GetResponse() as HttpWebResponse;
            //Stream stream = httpWebResponse.GetResponseStream();
            //StreamReader reader = new StreamReader(stream, Encoding.UTF8);
            //string s = reader.ReadToEnd();
            //reader.Close();
            //stream.Close();
            //httpWebResponse.Close();
            //HtmlDocument htmlDoc = new HtmlDocument();
            //htmlDoc.LoadHtml(s);
            //HtmlNodeCollection anchors = htmlDoc.DocumentNode.SelectNodes(@"//a");
            //foreach (HtmlNode anchor in anchors)
            //{
            //    Regex reg = new Regex("景良东：");
            //    if (reg.Matches(anchor.InnerHtml).Count == 0)
            //    {

            //    }
            //    else
            //    {
            //        Response.Write(anchor.OuterHtml + "<br/>");
            //    }
            //}
            //Response.End();

            Response.Write(GainLink("http://blog.cnfol.com/jldgold/list","景良东："));
            Response.End();
        }

        /// <summary>
        /// 获取网页上自己想要的链接
        /// </summary>
        /// <param name="link">获取网页上的链接的网页地址</param>
        /// <param name="regexstr">正则匹配自己想要的链接所共有包含的内容</param>
        /// <returns>返回链接集合</returns>
        public string GainLink(string link, string regexstr)
        {
            String str="";
            HttpWebRequest httpWebRequest = WebRequest.Create(link) as HttpWebRequest;
            HttpWebResponse httpWebResponse = httpWebRequest.GetResponse() as HttpWebResponse;
            Stream stream = httpWebResponse.GetResponseStream();
            StreamReader reader = new StreamReader(stream, Encoding.UTF8);
            string s = reader.ReadToEnd();
            reader.Close();
            stream.Close();
            httpWebResponse.Close();
            HtmlDocument htmlDoc = new HtmlDocument();
            htmlDoc.LoadHtml(s);
            HtmlNodeCollection anchors = htmlDoc.DocumentNode.SelectNodes(@"//a");
            foreach (HtmlNode anchor in anchors)
            {
                Regex reg = new Regex(regexstr);
                if (reg.Matches(anchor.InnerHtml).Count == 0)
                {

                }
                else
                {
                    str += anchor.OuterHtml+"</br>";
                }
            }
            return str;
        }
    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="图片延时加载._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <title>Lazy Load Enabled</title>
        <script src="Scripts/jquery-1.4.2.min.js" type="text/javascript"></script>
    </head>
    <body>
    <br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /> <!--备注，必须有滚滚动条出现，才能有延时加载效果。所以这里加了一对换行符，为了获得滚动条-->
        <img lazyload="img/bmw_m1_hood.jpg?1277878639" /><br />
        <img lazyload="img/bmw_m1_side.jpg?1277878639" /><br />
        <img lazyload="img/viper_1.jpg?1277878639" /><br />
        <img lazyload="img/viper_corner.jpg?1277878639" /><br />
        <img lazyload="img/bmw_m3_gt.jpg?1277878639" /><br />
        <img lazyload="img/corvette_pitstop.jpg?1277878639" /><br />
        <script type="text/javascript" src="Scripts/LazeLoad.js"></script>  <!--这里是需要下载添加的js-->
        <script type="text/javascript">   
            lazyLoad.Run();
        </script>
    </body>
</html>

SELECT id, Name, Introduction, phone, contact, imageUrl, types, username,
(
SELECT  TOP (1) id  FROM ShoppingCoupons WHERE ( username = m.username ) ORDER BY addtime DESC 
)
AS sid 

FROM  dbo.MerchantsInfo AS m