温故而知新——积累了N久的代码！

1， 获取当前电脑上所使用的域名

        /// <summary>
        /// 获取当前电脑上所使用的域名
        /// </summary>
        /// <returns></returns>
        private static string GetDomainName()
        {
            SelectQuery query = new SelectQuery("Win32_ComputerSystem");//使用SelectQuery类需引用System.Management空间及System.Management.dll程序集
            using (ManagementObjectSearcher searcher = new ManagementObjectSearcher(query))
            {
                foreach (ManagementObject mo in searcher.Get())
                {
                    if((bool)(mo["partofdomain"]))
                    {
                        return mo["domain"].ToString();
                    }
                }
            }
            return null;
        }

2, SQL游标案例：

alter procedure usp_FrontEnd_CandidateResume_SaveHistory_V2
(  
 @AccountID int,  
 @EntityID int,  
 @CandidateID int,  
 @TypeID int,  
 @JobID int ,  
 @TemplateID nvarchar(1000)  
)  
As  
 SET NOCOUNT ON  
 declare @HistoryID int  
 declare @error_var int  
 declare @Source int 
  
 Declare @CursorID int
 Declare UserCursor Cursor for --定义游标
 select convert(int,item) from UDF_Common_Split(@TemplateID,',')  ---游标后必须跟select 一个表
 open UserCursor  --打开游标
 Fetch next from UserCursor into @CursorID   --默认第一行
 while(@@FETCH_STATUS = 0)  ----循环
 begin
  
     Exec usp_sys_genglobalid @AccountID, 'HistoryID', @HistoryID output  
     select @error_var = @@ERROR  
     if @error_var <> 0 goto Local_Error  
     Insert into Resume_History with (rowlock)  
     (AccountID, EntityID, CandidateID, HistoryID, TypeID, JobID, TemplateID, LastModifiedDate)  
     select  @AccountID,@EntityID, @CandidateID, @HistoryID, @TypeID, @JobID, @CursorID , GETUTCDATE()
      
    Fetch next from UserCursor into @CursorID  ----必须指定向下循环
 end
 close UserCursor  ---关闭游标
 Deallocate UserCursor -----删除游标
 
 select @error_var = @@ERROR  
 if @error_var <> 0 goto Local_Error  
 return  
 Local_Error:  
  return @error_var  

 3 , SQL编写一个UDF实现字符串按符号分割成表 如：‘1,,2,5,8’实现分割返回表结构 。使用方法 ： select item from UDF_Common_Split('1,2,3',',')

CREATE   FUNCTION [dbo].[UDF_Common_Split] 
(
@inPattern As nvarchar(4000),
@inDelimiter As char(1)
)  
RETURNS @SplitResult TABLE  
(  
 item sql_variant  
)  
AS  
BEGIN   
Declare @startPos As int  
Declare @endPos As int  
Declare @tempPattern As nvarchar(4000)  
Declare @result As nvarchar(4000)  
Set @startPos = 1  
Set @endPos = 1  
Set @result = ''  
While @startPos <= Len(@inPattern)  
Begin  
 Set @endPos = CharINDEX (@inDelimiter, @inPattern, @startPos)  
 if @endPos = 0  
  begin  
   Set @tempPattern = SubString(@inPattern, @startPos, Len(@inPattern))  
   Set @tempPattern = LTrim(RTrim(@tempPattern))  
   Insert into @SplitResult values (@tempPattern)  
   break  
  end  
 else  
  begin  
   Set @tempPattern = SubString(@inPattern, @startPos, (@endPos - @startPos + 1))  
   Set @tempPattern = REPLACE (@tempPattern , @inDelimiter , '' )  
   Set @tempPattern = LTrim(RTrim(@tempPattern))  
   Insert into @SplitResult values (@tempPattern)  
   Set @startPos = @endPos + 1  
  end  
END  
return  
end  
  
  

 4 , 牛人写的将javascript代码压缩为png图片的代码，php下压缩：

<?

$filename = "prototype-1.6.0.2.js";


if (file_exists($filename)) {

    $iFileSize = filesize($filename);
    
    $iWidth = ceil(sqrt($iFileSize / 1));
    $iHeight = $iWidth;

    $im = imagecreatetruecolor($iWidth, $iHeight);

    $fs = fopen($filename, "r");
    $data = fread($fs, $iFileSize);
    fclose($fs);

    $i = 0;

    for ($y=0;$y<$iHeight;$y++) {
        for ($x=0;$x<$iWidth;$x++) {
            $ord = ord($data[$i]);
            imagesetpixel($im, 
                $x, $y,
                imagecolorallocate($im,
                    $ord,
                    $ord,
                    $ord
                )
            );
            $i++;
        }
    }

    header("Content-Type: image/png");
    imagepng($im);
    imagedestroy($im);
}

?>

javascript 解码：

function loadPNGData(strFilename, fncCallback) {
    // test for canvas and getImageData
    var bCanvas = false;
    var oCanvas = document.createElement("canvas");
    if (oCanvas.getContext) {
        var oCtx = oCanvas.getContext("2d");
        if (oCtx.getImageData) {
            bCanvas = true;
        }
    }
    if (bCanvas) {
        var oImg = new Image();
        oImg.style.position = "absolute";
        oImg.style.left = "-10000px";
        document.body.appendChild(oImg);
        oImg.onload = function() {
            var iWidth = this.offsetWidth;
            var iHeight = this.offsetHeight;
            oCanvas.width = iWidth;
            oCanvas.height = iHeight;
            oCanvas.style.width = iWidth+"px";
            oCanvas.style.height = iHeight+"px";
            var oText = document.getElementById("output");
            oCtx.drawImage(this,0,0);
            var oData = oCtx.getImageData(0,0,iWidth,iHeight).data;
            var a = [];
            var len = oData.length;
            var p = -1;
            for (var i=0;i<len;i+=4) {
                if (oData[i] > 0)
                    a[++p] = String.fromCharCode(oData[i]);
            };
            var strData = a.join("");
            if (fncCallback) {
                fncCallback(strData);
            }
            document.body.removeChild(oImg);
        }
        oImg.src = strFilename;
        return true;
    } else {
        return false;
    }
}

 5，关于xslt的特殊操作

（1）在xslt中使用c#方法：

<![CDATA[xslt中使用C#方法的属性设置  ]]>
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet
    version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxml="urn:schemas-microsoft-com:xslt"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt"
    xmlns:umbraco.library="urn:umbraco.library"
    xmlns:scripts="urn:scripts.this"
    exclude-result-prefixes="msxml msxsl umbraco.library scripts">
<![CDATA[C#方法的定义    ]]>
    <msxsl:script language="C#" implements-prefix="scripts">
<![CDATA[
    public string replace(string s0)
    {
        return "<b>sdf</b>";
    }
    ]]>

  </msxsl:script>
<![CDATA[使用方法    ]]>
<td>
            <xsl:value-of select="@JobTitle" />
            <xsl:value-of select="scripts:replace(@JobTitle)"/>
          </td>

（2）xslt系统替换函数的使用：

<xsl:value-of select="translate($pageTitle,$apostrophe,'')" />

（3）xslt中使用js自定义函数：

<![CDATA[定义]]>
<xsl:template match="Report" mode="HtmlHeader" >

        <head>
            <title>JobsDB Dimension</title>
            <style>
                h1 { font-size:18pt;font-family:Verdana;font-weight:bold;text-align:center;vertical-align:middle;width:100%; }
                td { font-family: Arial; font-size: 9pt; }
                .HeaderText { font-family: Arial;font-size: 8pt; font-weight: normal; text-align:left; width: 200px; }
                .HeaderData { font-family: Arial;font-size: 8pt; font-weight: normal; text-align:left; }
                .xlsText{mso-style-parent:style0;mso-number-format:"\@";}

            </style>
            <script>
            <![CDATA[
            function replaceHTML(desc, pos){
            document.getElementById("td_"+ pos).innerHTML=desc;
            }
            ]]>
           </script>
            <meta HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" />
        </head>

    </xsl:template>

<![CDATA[使用方法]]>
<td dataformattas="html">
                 <xsl:attribute name="id">td_<xsl:value-of select="position()"/></xsl:attribute>
                 <script>replaceHTML('<xsl:value-of select="@JobDes"/>', <xsl:value-of select="position()"/>)</script>
                 </td>

6，将sql查询结果自动传化成xml：

Select * from @Information Job For Xml Auto,Type

成功的结果：

<Job AccountID="12100387" EntityCode="Aceyue" JobID="9" LangID="1" JobTitle="test29408" JobDes="&lt;FONT size=2&gt;ssssssssssssssssss&lt;/FONT&gt;" JobReference="ssssssss" JobLevelID="101" />
    <Job AccountID="12100387" EntityCode="Aceyue" JobID="10" LangID="1" JobTitle="sssssssssssss" JobDes="&lt;FONT size=2&gt;ssssssssssssssssssssssssssssssssssssssssssssssss&lt;/FONT&gt;" JobReference="sssssssss" JobLevelID="102" />
    <Job AccountID="12100387" EntityCode="ace" JobID="11" LangID="1" JobTitle="sssssssssssss" JobDes="&lt;FONT size=2&gt;ssssssssssssss&lt;/FONT&gt;" JobReference="" JobLevelID="103" />
    <Job AccountID="12100387" EntityCode="ace" JobID="12" LangID="1" JobTitle="ssssssssss" JobDes="&lt;FONT size=2&gt;ssssssssss&lt;/FONT&gt;" JobReference="ssss" JobLevelID="101" />
    <Job AccountID="12100387" EntityCode="ace" JobID="13" LangID="1" JobTitle="bbbbbbbbb" JobDes="ssssssssssssssssssss" JobReference="" JobLevelID="102" />
    <Job AccountID="12100387" EntityCode="ace" JobID="14" LangID="1" JobTitle="ssssssssss" JobDes="&lt;FONT size=2&gt;ssssssssssssssssss&lt;/FONT&gt;" JobReference="" JobLevelID="102" />

 7，将SQL中某些行的值合并：

如：

合并为：

实例代码：

CREATE TABLE body
（
ID int,
Body nvarchar(20)
）

insert into body values(1,'aaaaaaa'),(2,'bbbbbbbb'),(3,'cccccccc'),(1,'ddddddddddd')

select * from body

    SELECT distinct a.ID,stuff((SELECT ','+BODY FROM body WHERE ID=a.ID FOR xml path('')),1,1,'') AS BODY from body a

--具体思路是
SELECT ','+BODY FROM body WHERE ID=a.ID FOR xml path('') 
--这条语句的作用是按照a中的ID查找body表中ID=a.ID的所有记录，并把它转换成一个xml
stuff((SELECT ','+BODY FROM body WHERE ID=a.ID FOR xml path('')),1,1,'') 
--这条语句的作用是把生成的xml前面的一个逗号去掉并转化成标量值
--最后用一个distinct去掉重复的记录

--如果查询过程中有‘’这种空字符串，使用这种方法会出现‘，，，aaa’这样的情况，我们可以 采取以下方法替换：
select distinct f.AccountID,f.JobID,stuff((SELECT case JobFuntion when '' then '' when null then '' else ','+JobFuntion end FROM @Job_Function WHERE AccountID=f.AccountID and JobID=f.JobID FOR xml path('')),1,1,'') as JobFunction from @Job_Function  f

 8 ， MVC3 全站域名重定向代码：

 protected void Application_BeginRequest(object sender, EventArgs e)
 {
            string strUrl = Request.Url.ToString().Trim().ToLower();
            if (strUrl.Contains("http://xxx.cn"))
            {
                      Response.RedirectPermanent(strUrl.Replace("http://xxx.cn", "http://www.xxx.cn")); 
            }
 }

 9，求数组中出现次数超过一半元素（一定存在一个超过一半的情况下） 一种算法：

 int Find(int *arr,int n)
 {
     int tmp = arr[0];
     int count = 1;//计数器
     for(int i = 1 ; i < n ; i++)
     {
         if(count == 0)
         {
             tmp = arr[i];
             count = 1;
         }
         else if(tmp == arr[i])
         {
             count++;
        }
         else
         {
            count--;
         }
     }
     return tmp;
 }

 10，使用反射解决简单工厂模式的（违背开发封闭）

抽象产品的定义

//------------------------------------------------
// All Rights Reserved , Copyright (C) 2012 AceYue
//------------------------------------------------
using System;
using System.Collections.Generic;

namespace Common.DesignPattern.Factory
{
    /// <summary>
    /// 抽象产品
    /// </summary>
    interface IHero
    {
        /// <summary>
        /// 姓名
        /// </summary>
        string Name { get; }

        /// <summary>
        /// 英雄方法
        /// </summary>
        void Create();
    }
}

具体产品

//--------------------------------------------------------
// All Rights Reserved , Copyrights (C) 2012  AceYue
//--------------------------------------------------------
using System;
using System.Collections.Generic;

namespace Common.DesignPattern.Factory
{
    /// <summary>
    /// 具体产品
    /// </summary>
    [HeroMark(HeroType.Ace)]
    public class Ace:IHero
    {
        public string Name { get { return "Ace"; } }

        public void Create()
        {
            Console.WriteLine(this.Name);
        }
    }
}

//-------------------------------------------------
// All Rights Reserved , Copyright (C) 2012 AceYue
//---------------------------------------------------
using System;
using System.Collections.Generic;


namespace Common.DesignPattern.Factory
{
    /// <summary>
    /// 具体产品
    /// </summary>
    [HeroMark(HeroType.Milo)]
    public class Milo:IHero
    {
        public string Name { get { return "Milo"; } }

        public void Create()
        {
            Console.WriteLine(this.Name);
        }
    }
}

产品枚举

//--------------------------------------------------
// All Rights Reserved,  Copyright (C) 2012 AceYue
//--------------------------------------------------
using System;


namespace Common.DesignPattern.Factory
{
    /// <summary>
    /// 产品枚举
    /// </summary>
     public enum HeroType
    {
         /// <summary>
         /// Ace
         /// </summary>
         Ace,
         /// <summary>
         /// Milo
         /// </summary>
         Milo
    }
}

反射标记

//------------------------------------------------------------
// All Rights Reserved , Copyright (C) 2012 AceYue
//------------------------------------------------------------
using System;


namespace Common.DesignPattern.Factory
{
    /// <summary>
    /// 产品属性，标记要被反射的实例
    /// </summary>
    [AttributeUsage(AttributeTargets.All,AllowMultiple=false,Inherited=true)]
    public class HeroMarkAttribute:Attribute
    {
        public HeroType Type { get; private set; }

        public HeroMarkAttribute(HeroType type)
        {
            this.Type = type;
        }
    }
}

工厂类

//---------------------------------------------------
// All Rights Reserved , Copyright (C) 2012 AceYue
//-------------------------------------------------------
using System;
using System.Collections.Generic;


namespace Common.DesignPattern.Factory
{
    /// <summary>
    /// HeroFactory
    /// 工厂类
    /// </summary>
    public class HeroFactory
    {
        /// <summary>
        /// hero字典
        /// </summary>
        private static Dictionary<HeroType, IHero> heroInstanceDic = new Dictionary<HeroType, IHero>();

        /// <summary>
        /// 构造函数 （用反射自动添加所有实例到字典中）
        /// </summary>
        static HeroFactory()
        {
            var types = typeof(HeroFactory).Assembly.GetTypes();
            if (types.Length > 0)
            {
                foreach (var type in types)
                {
                    var attributes = type.GetCustomAttributes(typeof(HeroMarkAttribute), true);
                    if (attributes.Length > 0)
                    {
                        HeroType heroType = (attributes[0] as HeroMarkAttribute).Type;
                        IHero instance = (IHero)typeof(HeroFactory).Assembly.CreateInstance(type.FullName, true);
                        heroInstanceDic.Add(heroType, instance);
                    }
                }
            }
        }

        /// <summary>
        /// 创建实例类
        /// </summary>
        /// <param name="type"></param>
        public static void CreateHero(HeroType type)
        {
            if (heroInstanceDic.ContainsKey(type))
            {
                heroInstanceDic[type].Create();
            }
        }
    }
}

 11, 在存储过程中调用WebServices

create procedure usp_CallWebServices
(
@parameter nvarchar(500)=null
)
as
   Declare @obj int
   Declare @SvercieUrl nvarchar(200)
   Declare @response nvarchar(max)


   Set @SvercieUrl = 'http://locahost/webservices/service.asmx/saludar?param='+@parameter
   
   
   Execute sp_OACreate 'MSXML2.ServerXMLHttp',@obj out
   Execute sp_OAMethod @obj,'open',null,'Get',@SvercieUrl,false
   Execute sp_OAMethod @obj,'Send'
   Execute sp_OAGetProperty @obj,'responseText',@response out
   
   Select @response [Response]
   Execute sp_OADestroy @obj
   
return



Execute    usp_CallWebServices 'Frometa'

 12, SQL Server使用ROW_NUMBER分页实现：

      select * from (
          select ROW_NUMBER() over(order by JobID desc) as orderIndex, * from @JobData 
       ) d where d.orderIndex > ((@PageIndex-1)*@Pagecount) and d.orderIndex <=(@PageIndex * @Pagecount)

 13，SQL 中取出xml的属性值：

        方法一：

declare @str nvarchar(max)
set @str = '<Terms>
  <Term TermID="OT_3" TermName="Basic Salary" TermRmk="25 April 2002"/>
  <Term TermID="OT_4" TermName="Probation Period" TermRmk="25 April 2002"/>
  <Term TermID="OT_5" TermName="Annual Leave" TermRmk="25 April 2002"/>
  <Term TermID="OT_6" TermName="MPF/PF contribution %" TermRmk="25 April 2002"/>
  <Term TermID="OT_7" TermName="Share Options Number" TermRmk="25 April 2002"/>
  <Term TermID="OT_8" TermName="Commission" TermRmk="25 April 2002"/>
  <Term TermID="OT_9" TermName="Housing Allowance" TermRmk="25 April 2002"/>
  <Term TermID="OT_10" TermName="Traveling Allowance" TermRmk="25 April 2002"/>
  <Term TermID="OT_11" TermName="Bonus" TermRmk="25 April 2002"/>
</Terms>'
declare @table table(string nvarchar(max))
insert into @table values(@str)
select cast(string as xml).value('((//Terms/Term[@TermName="Basic Salary"])[1]/@TermRmk)[1]','nvarchar(255)') from @table

        方法二：

declare @str xml
set @str = N'<Terms>
  <Term TermID="OT_3" TermName="Basic Salary" TermRmk="25 April 2002"/>
  <Term TermID="OT_4" TermName="Probation Period" TermRmk="25 April 2002"/>
  <Term TermID="OT_5" TermName="Annual Leave" TermRmk="25 April 2002"/>
  <Term TermID="OT_6" TermName="MPF/PF contribution %" TermRmk="25 April 2002"/>
  <Term TermID="OT_7" TermName="Share Options Number" TermRmk="25 April 2002"/>
  <Term TermID="OT_8" TermName="Commission" TermRmk="25 April 2002"/>
  <Term TermID="OT_9" TermName="Housing Allowance" TermRmk="25 April 2002"/>
  <Term TermID="OT_10" TermName="Traveling Allowance" TermRmk="25 April 2002"/>
  <Term TermID="OT_11" TermName="Bonus" TermRmk="25 April 2002"/>
</Terms>'

Select T.c.value('@TermName','nvarchar(200)')
From @str.nodes('Terms/Term') T(c)
Where T.c.value('@TermID','nvarchar(20)') = 'OT_3'  

14，SQL中操作xml的帮助示例：

/*
sql xml 入门:

    1、xml:        能认识元素、属性和值
    
    2、xpath:    寻址语言，类似windows目录的查找(没用过dir命令的话就去面壁)
                
                语法格式，这些语法可以组合为条件：
                "."表示自己，".."表示父亲，"/"表示儿子，"//"表示后代，
                "name"表示按名字查找，"@name"表示按属性查找
                
                "集合[条件]" 表示根据条件取集合的子集，条件可以是
                    数  值：数字,last(),last()-数字 等
                    布尔值：position()<数字,@name='条件',name='条件'
                条件是布尔值的时候可以合并计算：and or
    
    3、xquery:    基于xpath标的准查询语言，sqlserver xquery包含如下函数
                exist(xpath条件)：返回布尔值表示节点是否存在
                query(xpath条件)：返回由符合条件的节点组成的新的xml文档
                value(xpath条件,数据类型)：返回指定的标量值，xpath条件结果必须唯一
                nodes(xpath条件): 返回由符合条件的节点组成的一行一列的结果表
*/

declare @data xml
set @data='
<bookstore>
<book category="COOKING">
  <title lang="en">Everyday Italian</title>
  <author>Giada De Laurentiis</author>
  <year>2005</year>
  <price>30.00</price>
</book>
<book category="CHILDREN">
  <title lang="jp">Harry Potter</title>
  <author>J K. Rowling</author>
  <year>2005</year>
  <price>29.99</price>
</book>
<book category="WEB">
  <title lang="en">XQuery Kick Start</title>
  <author>James McGovern</author>
  <author>Per Bothner</author>
  <author>Kurt Cagle</author>
  <author>James Linn</author>
  <author>Vaidyanathan Nagarajan</author>
  <year>2003</year>
  <price>49.99</price>
</book>
<book category="WEB">
  <title lang="cn">Learning XML</title>
  <author>Erik T. Ray</author>
  <year>2003</year>
  <price>39.95</price>
</book>
</bookstore>
'

--测试语句，如果不理解语法请参考上面的xpath规则和xquery函数说明

--1、文档
select @data
--2、任意级别是否存在price节点
select @data.exist('//price')
--3、获取所有book节点
select @data.query('//book')
--4、获取所有包含lang属性的节点
select @data.query('//*[@lang]') 
--5、获取第一个book节点
select @data.query('//book[1]')
--6、获取前两个book节点
select @data.query('//book[position()<=2]')
--7、获取最后一个book节点
select @data.query('//book[last()]')
--8、获取price>35的所有book节点
select @data.query('//book[price>35]')
--9、获取category="WEB"的所有book节点
select @data.query('//book[@category="WEB"]')
--10、获取title的lang="en"的所有book节点
select @data.query('//book/title[@lang="en"]')
--11、获取title的lang="en"且 price>35的所有book节点
select @data.query('//book[./title[@lang="en"] or price>35 ]')
--12、获取title的lang="en"且 price>35的第一book的(第一个)title
select @data.query('//book[./title[@lang="en"] and price>35 ]').value('(book/title)[1]','varchar(max)')
--13、等价于12
select @data.value('(//book[./title[@lang="en"] and price>35 ]/title)[1]','varchar(max)')
--14、获取title的lang="en"且 price>35的第一book的(第一个)title的lang属性
select @data.value('((//book[@category="WEB" and price>35 ]/title)[1]/@lang)[1]','varchar(max)')
--15、获取第一本书的title
select Tab.Col.value('(book/title)[1]','varchar(max)') as title
    from @data.nodes('bookstore')as Tab(Col) 
--16、获取每本书的第一个author
select Tab.Col.value('author[1]','varchar(max)') as title
    from @data.nodes('//book')as Tab(Col)
--17、获取所有book的所有信息
select
 T.C.value('title[1]','varchar(max)') as title,
 T.C.value('year[1]','int') as year,
 T.C.value('title[1]','varchar(max)')as title,
 T.C.value('price[1]','float') as price,
 T.C.value('author[1]','varchar(max)') as author1,
 T.C.value('author[2]','varchar(max)') as author2,
 T.C.value('author[3]','varchar(max)') as author3,
 T.C.value('author[4]','varchar(max)') as author4
from @data.nodes('//book') as T(C)
--18、获取不是日语(lang!="jp")且价格大于35的书的所有信息
select
 T.C.value('title[1]','varchar(max)') as title,
 T.C.value('year[1]','int') as year,
 T.C.value('title[1]','varchar(max)')as title,
 T.C.value('price[1]','float') as price,
 T.C.value('author[1]','varchar(max)') as author1,
 T.C.value('author[2]','varchar(max)') as author2,
 T.C.value('author[3]','varchar(max)') as author3,
 T.C.value('author[4]','varchar(max)') as author4
from @data.nodes('//book[./title[@lang!="jp"] and price>35 ]') as T(C)