|
|
<!DOCTYPE html>
|
|
|
<html>
|
|
|
<head>
|
|
|
<meta charset="UTF-8" />
|
|
|
<title>选择组</title>
|
|
|
<link href="../../Comm/Style/CommStyle.css" rel="stylesheet" type="text/css" />
|
|
|
<link href="../../../DataUser/Style/ccbpm.css" rel="stylesheet" type="text/css" />
|
|
|
<link href="../../Scripts/easyUI/themes/default/easyui.css" rel="stylesheet" type="text/css" />
|
|
|
<link href="../../Scripts/easyUI/themes/icon.css" rel="stylesheet" type="text/css" />
|
|
|
<script src="../../Scripts/jquery-1.7.2.min.js" type="text/javascript"></script>
|
|
|
<script src="../../Scripts/easyUI/jquery.easyui.min.js" type="text/javascript"></script>
|
|
|
<script src="../../Scripts/QueryString.js" type="text/javascript"></script>
|
|
|
<script type="text/javascript" src="../../Scripts/config.js"></script>
|
|
|
<script type="text/javascript" src="../../Comm/Gener.js"></script>
|
|
|
<script src="../../Scripts/EasyUIUtility.js" type="text/javascript"></script>
|
|
|
<link href="../../Style/skin/adminfont/iconfont.css" rel="stylesheet" />
|
|
|
<link href="../../Style/skin/css/Default.css" rel="stylesheet" />
|
|
|
<link href="../../Scripts/bootstrap/css/bootstrap.min.css" rel="stylesheet" />
|
|
|
<base target="_self" />
|
|
|
<script type="text/javascript">
|
|
|
|
|
|
//页面启动函数.
|
|
|
var Data;
|
|
|
$(function () {
|
|
|
|
|
|
var orgNo = GetQueryString("OrgNo");
|
|
|
if (orgNo == null || orgNo == undefined)
|
|
|
orgNo = 0;
|
|
|
|
|
|
});
|
|
|
|
|
|
function Save() {
|
|
|
|
|
|
var en = new Entity("BP.CCFast.CCMenu.PowerCenter");
|
|
|
en.CopyURL();
|
|
|
en.CtrlModel = "SQL";
|
|
|
|
|
|
en.IDs = $("#TB_SQL").val();
|
|
|
en.IDNames = $("#TB_SQL").val();
|
|
|
en.Insert();
|
|
|
|
|
|
var url = "../PowerCenter.htm";
|
|
|
url += "?CtrlObj=" + GetQueryString("CtrlObj") + "&CtrlPKVal=" + GetQueryString("CtrlPKVal") + "&CtrlGroup=" + GetQueryString("CtrlGroup");
|
|
|
SetHref(url);
|
|
|
window.parent.selectStasWindowClose("确定");
|
|
|
}
|
|
|
</script>
|
|
|
</head>
|
|
|
<body>
|
|
|
|
|
|
请输入SQL表达式:
|
|
|
<textarea id="TB_SQL" name="TB_SQL" style="width:90%;">
|
|
|
</textarea>
|
|
|
<input type="button" value="保存" onclick="Save();">
|
|
|
<fieldset>
|
|
|
<legend>说明</legend>
|
|
|
<ul>
|
|
|
<li>1. 输入的SQL是一个查询语句，返回的一行的第一列数据。</li>
|
|
|
<li>2. 该数据大于0 ，就是真(可以拥有此权限)，否则就是假（不能操作此权限）。</li>
|
|
|
<li>3. SQL语句支持ccbpm的表达式，比如：SELECT count(*) FROM Port_Dept WHERE No='@WebUser.FK_Dept'。</li>
|
|
|
<li> @WebUser.No 当前登录的人员编号 </li>
|
|
|
<li> @WebUser.FK_Dept 当前登录的部门编号 </li>
|
|
|
<li> @RDT 是当前日期， 比如：2020-01-01 </li>
|
|
|
<li> @DateTime 是当前时间， 比如：2020-01-01 10:09 </li>
|
|
|
</ul>
|
|
|
</fieldset>
|
|
|
</body>
|
|
|
</html>
|