|
|
|
|
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
|
|
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
|
|
|
|
|
<head>
|
|
|
|
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
|
|
|
|
|
<title>方向条件-按照SQL计算</title>
|
|
|
|
|
|
<!--SQL编辑器-->
|
|
|
|
|
|
<link href="../../Scripts/easyUI145/themes/default/easyui.css" rel="stylesheet" type="text/css" />
|
|
|
|
|
|
<link href="../../Scripts/CodeMirror/lib/codemirror.css" rel="stylesheet" />
|
|
|
|
|
|
<link href="../../Scripts/CodeMirror/addon/hint/show-hint.css" rel="stylesheet" />
|
|
|
|
|
|
<script src="../../Scripts/CodeMirror/lib/codemirror.js"></script>
|
|
|
|
|
|
<script src="../../Scripts/CodeMirror/addon/edit/matchbrackets.js"></script>
|
|
|
|
|
|
<script src="../../Scripts/CodeMirror/mode/sql/sql.js"></script>
|
|
|
|
|
|
<script src="../../Scripts/CodeMirror/addon/hint/show-hint.js"></script>
|
|
|
|
|
|
<script src="../../Scripts/CodeMirror/addon/hint/sql-hint.js"></script>
|
|
|
|
|
|
<script src="../../Scripts/LoadSql.js"></script>
|
|
|
|
|
|
<script type="text/javascript" src="../../Scripts/bootstrap/js/jquery.min.js"></script>
|
|
|
|
|
|
<script type="text/javascript" src="../../Scripts/bootstrap/js/bootstrap.min.js"></script>
|
|
|
|
|
|
|
|
|
|
|
|
<link href="../../Style/skin/css/Default.css" rel="stylesheet" />
|
|
|
|
|
|
<link href="../../Style/skin/adminfont/iconfont.css" rel="stylesheet" />
|
|
|
|
|
|
<link href="../../Scripts/bootstrap/css/bootstrap.min.css" rel="stylesheet" />
|
|
|
|
|
|
|
|
|
|
|
|
<script src="../../Scripts/QueryString.js" type="text/javascript"></script>
|
|
|
|
|
|
<script src="../../Scripts/config.js" type="text/javascript"></script>
|
|
|
|
|
|
<script src="../../Comm/Gener.js" type="text/javascript"></script>
|
|
|
|
|
|
<script src="../Admin.js" type="text/javascript"></script>
|
|
|
|
|
|
|
|
|
|
|
|
<script src="../../Scripts/easyUI/jquery-1.8.0.min.js" type="text/javascript"></script>
|
|
|
|
|
|
<link href="../../../DataUser/Style/ccbpm.css" rel="stylesheet" type="text/css" />
|
|
|
|
|
|
<base target="_self" />
|
|
|
|
|
|
|
|
|
|
|
|
<script type="text/javascript">
|
|
|
|
|
|
|
|
|
|
|
|
function Esc() {
|
|
|
|
|
|
if (event.keyCode == 27)
|
|
|
|
|
|
window.close();
|
|
|
|
|
|
return true;
|
|
|
|
|
|
}
|
|
|
|
|
|
var condOrAnd = GetQueryString("CondOrAnd");
|
|
|
|
|
|
//初始化页面函数.....
|
|
|
|
|
|
$(function () {
|
|
|
|
|
|
|
|
|
|
|
|
var mypk = GetQueryString("MyPK");
|
|
|
|
|
|
var cond = new Entity("BP.WF.Template.Cond");
|
|
|
|
|
|
cond.MyPK = mypk;
|
|
|
|
|
|
if (mypk != null && mypk!=undefined && mypk!="") {
|
|
|
|
|
|
cond.SetPKVal(mypk);
|
|
|
|
|
|
cond.RetrieveFromDBSources();
|
|
|
|
|
|
var docs = cond.OperatorValue;
|
|
|
|
|
|
|
|
|
|
|
|
docs = docs.replace(/~/g, "'");
|
|
|
|
|
|
document.getElementById("TB_SQL").value = docs;
|
|
|
|
|
|
document.getElementById("TB_Note").value = cond.Note;
|
|
|
|
|
|
editor.setValue(document.getElementById("TB_SQL").value);
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
});
|
|
|
|
|
|
|
|
|
|
|
|
//执行保存..
|
|
|
|
|
|
function Save() {
|
|
|
|
|
|
|
|
|
|
|
|
var sqlVal = editor.getValue();
|
|
|
|
|
|
var note = document.getElementById("TB_Note").value;
|
|
|
|
|
|
if (sqlVal == "") {
|
|
|
|
|
|
alert('请输入参数.');
|
|
|
|
|
|
return;
|
|
|
|
|
|
}
|
|
|
|
|
|
if (note == "") {
|
|
|
|
|
|
alert('请输入备注说明.');
|
|
|
|
|
|
return;
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
var handler = new HttpHandler("BP.WF.HttpHandler.WF_Admin_Cond");
|
|
|
|
|
|
handler.AddUrlData();
|
|
|
|
|
|
handler.AddPara("TB_Docs", sqlVal);
|
|
|
|
|
|
handler.AddPara("TB_Note", note);
|
|
|
|
|
|
|
|
|
|
|
|
var data = handler.DoMethodReturnString("CondBySQL_Save");
|
|
|
|
|
|
if (data.indexOf('err@') == 0) {
|
|
|
|
|
|
$("#Msg").html("<font color=red>" + data + "</font>");
|
|
|
|
|
|
return;
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
if (data.indexOf('url@') == 0) {
|
|
|
|
|
|
var url = data.replace('url@', '');
|
|
|
|
|
|
SetHref(url);
|
|
|
|
|
|
return;
|
|
|
|
|
|
}
|
|
|
|
|
|
Back();
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
//装载模版.
|
|
|
|
|
|
function LoadTemplate() {
|
|
|
|
|
|
|
|
|
|
|
|
//打开方向条件.
|
|
|
|
|
|
var url = "../SettingTemplate.htm?TemplateType=CondBySQL&CondType=2";
|
|
|
|
|
|
var newWindow = window.open(url, 'SQL模板', 'width=900,height=700,top=100,left=300,scrollbars=yes,resizable=yes,toolbar=false,location=false,center=yes,center: yes;');
|
|
|
|
|
|
newWindow.focus();
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
//返回.
|
|
|
|
|
|
function Back() {
|
|
|
|
|
|
var url = GetHrefUrl();
|
|
|
|
|
|
|
|
|
|
|
|
url = url.replace('CondBySQL.htm', 'List.htm');
|
|
|
|
|
|
if (url.indexOf("MyPK=") != -1) {
|
|
|
|
|
|
url = url.replace("&MyPK=" + GetQueryString("MyPK"), "");
|
|
|
|
|
|
}
|
|
|
|
|
|
SetHref(url);
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
</script>
|
|
|
|
|
|
</head>
|
|
|
|
|
|
<body onkeypress="Esc();">
|
|
|
|
|
|
<div class="container-full">
|
|
|
|
|
|
<div class="attrnode-bar-header">
|
|
|
|
|
|
<span class="pull-right">
|
|
|
|
|
|
<!--<input type="button" value="加载模版" onclick="LoadTemplate()" />-->
|
|
|
|
|
|
<button id="Btn_Save" name="Btn_Save" onclick="Save();">保存</button>
|
|
|
|
|
|
<!--<input type="button" value="删除" onclick="Delete()" />-->
|
|
|
|
|
|
<button id="Btn_Back" name="Btn_Back" onclick="Back();">返回</button>
|
|
|
|
|
|
|
|
|
|
|
|
</span>
|
|
|
|
|
|
<strong>方向条件-按照SQl</strong>
|
|
|
|
|
|
</div>
|
|
|
|
|
|
<form id="cc">
|
|
|
|
|
|
|
|
|
|
|
|
<table class="table">
|
|
|
|
|
|
|
|
|
|
|
|
<tr>
|
|
|
|
|
|
<td style="width: 20%;">
|
|
|
|
|
|
要执行的SQL:
|
|
|
|
|
|
</td>
|
|
|
|
|
|
<td>
|
|
|
|
|
|
<textarea rows="4" style="width: 95%;" id="TB_SQL" name="TB_Docs"> </textarea>
|
|
|
|
|
|
</td>
|
|
|
|
|
|
</tr>
|
|
|
|
|
|
<tr>
|
|
|
|
|
|
<td>
|
|
|
|
|
|
备注(不为空):
|
|
|
|
|
|
</td>
|
|
|
|
|
|
<td>
|
|
|
|
|
|
<input type="text" value="" id="TB_Note" name="TB_Note" style="width: 95%;" />
|
|
|
|
|
|
</td>
|
|
|
|
|
|
</tr>
|
|
|
|
|
|
</table>
|
|
|
|
|
|
|
|
|
|
|
|
<div style="text-align: left">
|
|
|
|
|
|
<h4>
|
|
|
|
|
|
帮助
|
|
|
|
|
|
</h4>
|
|
|
|
|
|
<ul>
|
|
|
|
|
|
<ul>
|
|
|
|
|
|
<li>在文本框里设置一个查询SQL，它返回一行一列。比如: SELECT COUNT(*) AS Num FROM MyTable WHERE NAME='@MyFieldName'。</li>
|
|
|
|
|
|
<li>该SQL参数支持系统的表达式，什么是ccflow的表达式请查看说明书。</li>
|
|
|
|
|
|
<li>当前登录信息变量: @WebUser.No, @WebUser.Name, @WebUser.FK_Dept.</li>
|
|
|
|
|
|
<li>系统就会获取该返回的值把它转化为decimal类型</li>
|
|
|
|
|
|
<li>如果该值大于零，该条件就是成立的，否则不成立，不成立就不到达这个节点。</li>
|
|
|
|
|
|
</ul>
|
|
|
|
|
|
</ul>
|
|
|
|
|
|
</div>
|
|
|
|
|
|
</form>
|
|
|
|
|
|
<center>
|
|
|
|
|
|
<div id="Msg" />
|
|
|
|
|
|
</center>
|
|
|
|
|
|
</div>
|
|
|
|
|
|
</body>
|
|
|
|
|
|
</html>
|
