DavidYun

  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

2011年9月6日

摘要: set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER procedure [dbo].[proc_newOfferKongmingdeng]@userid int,@username varchar(20),@usename varchar(20)='',@dengnum varchar(50),@dengtype bigint,@dengshopid bigint,@wishcontent varchar(350),@x varchar(20),@y varchar(20)as begindeclare @num as intset 阅读全文
posted @ 2011-09-06 23:41 David.Yun 阅读(475) 评论(0) 推荐(0)

摘要: set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER procedure [dbo].[proc_GetStoreBoxProductsForOther]@userid intasbeginselect storeid,shopid,shopname,canusetimes,unit,shopprice,isattach,istime,displaypic,flashdir,iwidth,iheight,iszorz,typeid,displaymode,userid,operation,oriposition,cemeteryid,displayo 阅读全文
posted @ 2011-09-06 23:39 David.Yun 阅读(795) 评论(0) 推荐(0)

摘要: <%# Eval("Fuck")==1?已完成:为完成%>select (case column when '0' then '未完成' when '1' then '已完成' end)as newcolumn from 阅读全文
posted @ 2011-09-06 17:41 David.Yun 阅读(189) 评论(0) 推荐(0)

摘要: publicstatic DataSet ConvertToDataSet<T>(IList<T> list) { if (list ==null|| list.Count <=0) { returnnull; } DataSet ds =new DataSet(); DataTable dt =new DataTable(typeof(T).Name); DataColumn column; DataRow row; System.Reflection.... 阅读全文
posted @ 2011-09-06 12:56 David.Yun 阅读(1925) 评论(0) 推荐(0)