摘要：
IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #t;create table #t(id int identity,Dt varchar(10));declare @starttime datetime,@endtime datetimeset @starttime = '===start==='set @endtime ='===end==='insert #tselect convert(varchar(10),dateadd(day,number,@starttime),112) dtf 阅读全文
摘要：
protected StringBuilder sb = new StringBuilder(); protected void Page_Load(object sender, EventArgs e) { string str = QConnectSDK.CustomWebRequest.getResponse("/", QConnectSDK.Method.GET, null); Regex reg = new Regex("<img([^\\/>src]+)src=\"([^\"]+)\"([^\\/]*)\\/? 阅读全文
摘要：
<script src="js/jquery-1.7.2.min.js" type="text/javascript"></script> <script type="text/javascript"> (function ($) { $.extend($.fn, { lazyloadImg: function (option) { var settings = { defObj: null, defHeight: 0 }; ... 阅读全文
摘要：
/** JsonSQL var _f1_obj = jsonsql.query("select id,mc,fid from json where (fid==475 && id==875 || fid==475)", json);*/var jsonsql = { query: function (sql, json) { var returnfields = sql.match(/^(select)\s+([a-z0-9_\,\.\s\*]+)\s+from\s+([a-z0-9_\.]+)(?: where\s+\((.+)\))?\s*(?:orde 阅读全文
摘要：
<!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><meta http-equiv="Content-Type" content="text/html; charset=utf- 阅读全文
摘要：
(function ($) { $.extend($.fn, { lSelect: function (options) { // 默认参数 var settings = { url: "", // 数据获取url parameter: "pid", // 数据获取参数名称 title: "title", // 定义JSON数据格式：选择名称 value: "value", // 定义JSON数据格式：选择值 ... 阅读全文
摘要：
<html><head><title> 年月日三下拉框联动 </title> <script src="jquery-1.7.2.min.js" type="text/javascript"></script> <script type="text/javascript"> (function ($) { $.extend($.fn, { sjSelect: function (options) { // 默认参数 var settings ... 阅读全文
摘要：
<!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>无标题页</title> <script type="text/javascript" src=& 阅读全文
摘要：
Uri u = context.Request.UrlReferrer;//访问来源地址string ip = context.Request.UserHostAddress;//访问来源IPstring serverHost = context.Request.Url.Host;//当前访问主机地址 string localIP=System.Configuration.ConfigurationManager.AppSettings["LocalIP"];if (u == null || u.Host.ToLower() != serverHost.ToLower(). 阅读全文
摘要：
CREATE FUNCTION StrComp(@Str1 VARCHAR(50),@Str2 VARCHAR(50))RETURNS INTEGERASBEGINDECLARE @i INTEGERDECLARE @y INTSET @i=0SET @y=1DECLARE @iLen INTSET @iLen = LEN(LTRIM(RTRIM(@Str1)))IF LEN(LTRIM(RTRIM(@Str1))) < LEN(LTRIM(RTRIM(@Str2)))SET @iLen = LEN(LTRIM(RTRIM(@Str2)))WHILE (@i < @iLen)BEG 阅读全文