摘要: var regex = /^[\u4e00-\u9fa5\w]{4,12}$/; //昵称长度在4-12个字节之间,由中文,英文字母、数字和下划线组成var regex = /^(((13[0-9]{1})|(15[0-9]{1})|(18[0-9]{1}))+\d{8})$/; //请输入有效的手机号码//手机var pp=/^(13[0-9]|15[0|3|6|7|8|9]|18[0-9])\d{8}$/;//电话var reTel=/^([\+][0-9]{1,3}[ \.\-])?([\(]{1}[0-9]{2,6}[\)])?([0-9 \.\-\/]{3,20})((x|ex... 阅读全文
posted @ 2012-11-13 18:21 一千零一夜 阅读(237) 评论(0) 推荐(0) 编辑
摘要: <%@ Page Language="C#" AutoEventWireup="true" CodeFile="ReceiverEmail_List.aspx.cs" Inherits="Web_Admin_ReceiverEmail_ReceiverEmail_List" %><%@ Register src="../ascx/navigation.ascx" tagname="navigation" tagprefix="uc1" % 阅读全文
posted @ 2012-11-13 17:53 一千零一夜 阅读(314) 评论(0) 推荐(0) 编辑
摘要: using System;using System.Collections.Generic;using Comm;/// <summary>///ShowPage 的摘要说明/// </summary>public class ShowPage : System.Web.UI.Page{ protected Util gjShowPage = new Util(); protected MySqlExecute mseShowPage = new MySqlExecute(); public ShowPage() { base.PreInit += new... 阅读全文
posted @ 2012-11-13 17:51 一千零一夜 阅读(222) 评论(0) 推荐(0) 编辑
摘要: using System.Web;using System.Data;using System;/// <summary>///Util 的摘要说明/// </summary>public class Util{ /// <summary> /// 过滤字符串中的html代码 /// </summary> /// <param name="Str">传入字符串</param> /// <returns>过滤后的字符串</returns> public string LostHTM 阅读全文
posted @ 2012-11-13 17:50 一千零一夜 阅读(188) 评论(0) 推荐(0) 编辑
摘要: function isSQL(st){ var in_str = "'|and|exec|insert|select|delete|update|count|*|%|chr|mid|master|truncate|char|declare|;|or|-|+|,"; var arrStr = in_str.split('|'); var l = arrStr.length; for(var i = 0; i < l; i++) { if(st.indexOf(arrStr[i]) >= 0) return true; } return fa 阅读全文
posted @ 2012-11-13 17:48 一千零一夜 阅读(870) 评论(0) 推荐(0) 编辑
摘要: using System;using System.Collections.Generic;using System.Text;using System.Collections;using System.Text.RegularExpressions; /*----------------------------------------------------------------------------- * 公司: * 作者: 肖品 * 文件描述: 中文获取拼音 * 创建时间: 2011-8-27 9:40:58 * 版本: v1.0 ----... 阅读全文
posted @ 2012-11-13 17:47 一千零一夜 阅读(885) 评论(0) 推荐(0) 编辑
摘要: private static string getPinYin(string text) { char pinyin; byte[] array; System.Text.StringBuilder sb = new System.Text.StringBuilder(text.Length); foreach (char c in text) { pinyin = c; array = System.Text.Encoding.Default.GetBytes(new ch... 阅读全文
posted @ 2012-11-13 17:47 一千零一夜 阅读(588) 评论(0) 推荐(0) 编辑
摘要: protected void Page_Load(object sender, EventArgs e) { string sql = "a|b|c|d| | |e|f|g|h|i|j|k"; System.Text.RegularExpressions.Regex ze = new System.Text.RegularExpressions.Regex("\\s"); sql= ze.Replace(sql,""); System.Text.RegularExpressions.Regex ze1 = new System.... 阅读全文
posted @ 2012-11-13 17:46 一千零一夜 阅读(646) 评论(0) 推荐(0) 编辑
摘要: ALTER proc [dbo].[pageing]( @tableName varchar(255), --表名 @showField varchar(1000), --显示的字段 @orderField varchar(255), --排序的字段 @pa... 阅读全文
posted @ 2012-11-13 17:45 一千零一夜 阅读(284) 评论(0) 推荐(0) 编辑
摘要: using System;using System.Data;using System.Configuration;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;/// <summary>///BasePage 的摘 阅读全文
posted @ 2012-11-13 17:44 一千零一夜 阅读(478) 评论(0) 推荐(0) 编辑
摘要: declare @t varchar(255),@c varchar(255)declare table_cursor cursor for select a.name,b.namefrom sysobjects a,syscolumns b ,systypes cwhere a.id=b.id and a.xtype='u' and c.namein ('char', 'nchar', 'nvarchar', 'varchar','text','ntext')declare @st 阅读全文
posted @ 2012-11-13 17:43 一千零一夜 阅读(195) 评论(0) 推荐(0) 编辑
摘要: using System.Net.Mail;private bool SendEmail(string astrEachEmail, string bt, string nr) { string strSendEmail = ConfigurationManager.AppSettings["fromMail"]; string strUserName = ConfigurationManager.AppSettings["mailAccount"]; string strPassWord = AllTableHelp.jieMi(Configu... 阅读全文
posted @ 2012-11-13 17:43 一千零一夜 阅读(144) 评论(0) 推荐(0) 编辑
摘要: using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Web.Caching;namespace SpaceTime{ /// <summary> /// VsC 阅读全文
posted @ 2012-11-13 17:42 一千零一夜 阅读(237) 评论(0) 推荐(0) 编辑
摘要: SqlParameter[] sps = new SqlParameter[] { new SqlParameter("@name", "%" + name + "%") }; 阅读全文
posted @ 2012-11-13 17:41 一千零一夜 阅读(115) 评论(0) 推荐(0) 编辑
摘要: private void DropDownListBind() { ddl.Items.Clear(); dt = Productmanage.Instance.GetAllProCate(); if (dt != null) bindTree(dt, 0, 0); ddl.Items.Insert(0, new ListItem("所有分类", "0")); } private void bindTree(DataTable dt, int parentId, int dep) ... 阅读全文
posted @ 2012-11-13 17:40 一千零一夜 阅读(137) 评论(0) 推荐(0) 编辑
摘要: convert(varchar(10),H_houseUpdateTime,23)=convert(varchar(10),getdate(),23) 阅读全文
posted @ 2012-11-13 17:33 一千零一夜 阅读(119) 评论(0) 推荐(0) 编辑
摘要: create function [dbo].[f_GetPy](@str nvarchar(4000))returns nvarchar(4000)asbegindeclare @strlen int,@re nvarchar(4000)declare @t table(chr nchar(1) collate Chinese_PRC_CI_AS,letter nchar(1))insert into @t(chr,letter) select '吖 ', 'A ' union all select '八 ', ... 阅读全文
posted @ 2012-11-13 17:32 一千零一夜 阅读(164) 评论(0) 推荐(0) 编辑
摘要: <style type="text/css"> #bottomNav { background-color: red; z-index: 999; position: fixed; bottom: 0px; left: 0px; width: 100%; _position: absolute; /* for IE6 */ _top: expression(documentEl... 阅读全文
posted @ 2012-11-13 17:32 一千零一夜 阅读(918) 评论(0) 推荐(0) 编辑
摘要: var tempColor; $(".listTable tr:even").css("backgroundColor", "#B3D59A"); $(".listTable tr:odd").css("backgroundColor", "#9AB3D5"); $(".listTable tr").mouseover(function () { tempColor = $(this).css("backgroundColor"); $ 阅读全文
posted @ 2012-11-13 17:31 一千零一夜 阅读(198) 评论(0) 推荐(0) 编辑
摘要: --完全相同的数据去掉重复select id,orderId from (select row_number() over(order by id) rowId,* from v_order) as tt where rowId in(select min(rowId) from (select row_number() over(order by id) rowId,* from v_order) bb group by id having count(id)>=1) 阅读全文
posted @ 2012-11-13 17:30 一千零一夜 阅读(766) 评论(0) 推荐(0) 编辑