07 2011 档案
摘要:1,角色权限2. <link href="../Scripts/jsTree/themes/default/style.css" rel="stylesheet" type="text/css" /> <script src="../Scripts/jsTree/jquery-1.6.min.js" type="text/javascript"></script> <script src="../Scripts/jsTree/jquery.js
阅读全文
摘要:--获取当前及以下部门Create proc GetCurrentAndUnderOrg@orgId intasbegin WITH cte AS ( SELECT * ,0 AS level FROM Static_Organ WHERE OrganID=@orgId UNION ALL SELECT g.*,level+1 FROM Static_Organ g INNER JOIN cte ON g.ParentOrgan=cte.OrganID ) SELECT * FROM cteend编辑器加载中...
阅读全文
摘要:http://blog.csdn.net/21aspnet/article/details/1565877
阅读全文
摘要:现在的手机号码增加了150,153,156,158,159,157,188,189所以正则表达式如下:string s = @"^(13[0-9]|15[0|3|6|7|8|9]|18[8|9])\d{8}$";
阅读全文
摘要:1.表结构 2.查询语句create procedure Pro_GetUnderOrg(in idd varchar(36))begindeclare lev int;set lev=1;drop table if exists tmp1; CREATE TABLE tmp1(ID VARCHAR(36),OrgName varchar(50),ParentID varchar(36) ,levv INT); INSERT tmp1 SELECT ID,OrgName,ParentID,1 FROM `organization` WHERE ParentID=idd;while row_co
阅读全文