摘要：
--获得上级with my as(select * from TB_Area where AreaID=72344566572777472union allselect aa.* from my,TB_Area aa where my.ParentID=aa.AreaID) select * from mygo--获得下级with my as(select * from TB_Area where AreaID=72339069014638592union allselect aa.* from my,TB_Area aa where my.AreaID=aa.ParentID) select 阅读全文
摘要：
if exists(select [name] from sys.objects where [name]='updateChild' and [type]='TR')drop trigger updateChildgocreate trigger updateChildon TB_ProductTypefor updateasif update(Pids) or update(Pid) or update([Level])begin update TB_ProductType set Pids=replace(pt.Pids,d.Pids,i.Pids), [ 阅读全文
摘要：
#region 防止钓鱼string host = request.UrlReferrer.Host;if (string.Compare(host, request.Url.Host) > 0){ return;}#endregionStringBuilder sb = new StringBuilder();//如果UrlReferrer为空，禁止盗链 if (context.Request.UrlReferrer.Host == null) {sb.Append("禁止"); } else { // 如果UrlReferrer中不包含自己站点主机域名，则禁止盗链 阅读全文
摘要：
public string getUrlPara(string sUrl, string paraName) { string sReg = "(?:\\?|&){1}" + paraName + "=([^&]*)"; System.Text.RegularExpressions.Regex re = new System.Text.RegularExpressions.Regex(sReg, System.Text.RegularExpressions.RegexOptions.IgnoreCase); return re.Match 阅读全文