04 2014 档案
摘要：1 public DataTable ConvertToDataTable(IList data) 2 { 3 PropertyDescriptorCollection properties = 4 TypeDescriptor.GetProperti...
阅读全文
摘要：添加引用http://htmlagilitypack.codeplex.com/downloads/get/437941protected void Export(string content,string file) { HtmlDocument doc = new HtmlD...
阅读全文
摘要：declare @dt1 as datetimedeclare @dt2 as datetimeset @dt1 = '2008-01-01'set @dt2 = '2009-01-01' ;with tas(select @dt1 as y union all select dateadd(m,1...
阅读全文
摘要：Response.ContentType = "text/html; text/plain; charset=UTF-8";
阅读全文
摘要：List _year = new List() { "一月", "二月", "三月", "四月", "五月", "六月", "七月", "八月", "九月", "十月", "十一月", "十二月" };string delim = ","; var str = _year.Ag...
阅读全文
摘要：declare @str varchar(2000) set @str='1,2,3,4,6,8,5,9,10,11,12,13,14,15,16,17,18,19,20,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,52,53,54,55,56,57,25,27,28,58' Declare @x XML sele...
阅读全文
摘要：CREATE TABLE #tmp(m_Meter_ID varchar(20),low_Voltage int,num_Attack int,num_DER int,company_id int,aid int,cid int,selfId varchar(25))INSERT ...
阅读全文
摘要：/*declare @str1 varchar(200),@str2 varchar(200)set @str1=N'江西省南昌市其它区高新区火炬大道809号' set @str2=N'江西省南昌市其它区高新区火炬大道809号'*/ALTER FUNCTION [dbo].[F_strcompare](@str1 nVARCHAR(200), @str2 nVARCHAR(200))RETURNS numeric(3,2)ASBEGINdeclare @returnvalue numeric(3,2)set @returnvalue=0i...
阅读全文
