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 阅读全文
posted @ 2011-07-28 09:11 Wythe 阅读(16378) 评论(4) 推荐(0) 编辑
摘要:--获取当前及以下部门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编辑器加载中... 阅读全文
posted @ 2011-07-21 16:05 Wythe 阅读(1160) 评论(1) 推荐(0) 编辑
摘要:http://blog.csdn.net/21aspnet/article/details/1565877 阅读全文
posted @ 2011-07-16 10:43 Wythe 阅读(102) 评论(0) 推荐(0) 编辑
摘要:现在的手机号码增加了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}$"; 阅读全文
posted @ 2011-07-13 11:56 Wythe 阅读(167) 评论(0) 推荐(0) 编辑
摘要: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 阅读全文
posted @ 2011-07-05 10:39 Wythe 阅读(11813) 评论(1) 推荐(2) 编辑