|
|
|
|
|
<!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>
|
|
|
|
|
|
<title>创建数据表向导</title>
|
|
|
|
|
|
<link href="../../../../DataUser/Style/ccbpm.css" rel="stylesheet" type="text/css" />
|
|
|
|
|
|
<link href="../../../Scripts/easyUI145/themes/default/easyui.css" rel="stylesheet"
|
|
|
|
|
|
type="text/css" />
|
|
|
|
|
|
<link href="../../../Scripts/easyUI145/themes/icon.css" rel="stylesheet" type="text/css" />
|
|
|
|
|
|
<script src="../../../Scripts/easyUI145/jquery.min.js" type="text/javascript"></script>
|
|
|
|
|
|
<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>
|
|
|
|
|
|
<style>
|
|
|
|
|
|
.cancel_scroll {
|
|
|
|
|
|
overflow-x: hidden;
|
|
|
|
|
|
scrollbar-width: none;
|
|
|
|
|
|
}
|
|
|
|
|
|
.title_Settings {
|
|
|
|
|
|
margin-top:20px;
|
|
|
|
|
|
width: 100%;
|
|
|
|
|
|
background: #f7f7f7;
|
|
|
|
|
|
padding: 10px 10px 10px 25px;
|
|
|
|
|
|
/* font-weight: 700;
|
|
|
|
|
|
color:rgba(0,0,0,.5);*/
|
|
|
|
|
|
}
|
|
|
|
|
|
li {
|
|
|
|
|
|
margin: 15px 0;
|
|
|
|
|
|
font-size: 13px;
|
|
|
|
|
|
color: #737373;
|
|
|
|
|
|
}
|
|
|
|
|
|
a {
|
|
|
|
|
|
color: #3e38ff;
|
|
|
|
|
|
}
|
|
|
|
|
|
</style>
|
|
|
|
|
|
<script type="text/javascript">
|
|
|
|
|
|
$(function () {
|
|
|
|
|
|
var webUser = new WebUser();
|
|
|
|
|
|
// if (webUser.CCBPMRunModel == 2)
|
|
|
|
|
|
// SetHref("../../../../Admin/CCFormDesigner/SFTable/Default.htm");
|
|
|
|
|
|
})
|
|
|
|
|
|
</script>
|
|
|
|
|
|
</head>
|
|
|
|
|
|
<body class="cancel_scroll">
|
|
|
|
|
|
<fieldset>
|
|
|
|
|
|
<legend class="title_Settings">外键表</legend>
|
|
|
|
|
|
<ul>
|
|
|
|
|
|
<li><a href="SF7.htm?SFType=SysDict">创建通用的系统字典表(数据存储到:Sys_SFTableDtl里面)</a></li>
|
|
|
|
|
|
<li><a href="SF1.htm?SFType=CreateTable">创建本地数据表(外键表)</a></li>
|
|
|
|
|
|
<!--<a href="SF2.htm?SFType=2"></a>-->
|
|
|
|
|
|
<li><a href="SF2.htm?SFType=TableOrView">把现有的表或者视图作为外键表注册到表单数据字典.</a>(新版本暂不支持该功能)</li>
|
|
|
|
|
|
<li><a href="SF0.htm?SFType=BPClass">BP类(外键表)</a></li>
|
|
|
|
|
|
</ul>
|
|
|
|
|
|
<legend class="title_Settings">外部数据源 </legend>
|
|
|
|
|
|
<ul>
|
|
|
|
|
|
<li><a href="SF3.htm?SFType=SQL">SQL查询表</a></li>
|
|
|
|
|
|
<li>
|
|
|
|
|
|
<a href="SF6_Handler.htm?SFType=Handler">
|
|
|
|
|
|
微服务Handler外部数据源,(需要重写 \DataUser\SFTableHandler.ashx
|
|
|
|
|
|
或者 SFTableHandler.do 文件.)
|
|
|
|
|
|
</a>
|
|
|
|
|
|
</li>
|
|
|
|
|
|
<li><a href="SF7_JQuery.htm?SFType=JQuery">JavaScript外部数据源(需要重写\DataUser\SFTable.js 文件.)</a></li>
|
|
|
|
|
|
<li><a href="SF8_WebApi.htm?SFType=WebApi">WebApi接口</a></li>
|
|
|
|
|
|
</ul>
|
|
|
|
|
|
<legend class="title_Settings">帮助</legend>
|
|
|
|
|
|
<ul>
|
|
|
|
|
|
<li>外键表再组成SQL的时候，需要关联查询，创建一个字段，名称是关联 join 查询出来的。</li>
|
|
|
|
|
|
<li>外部数据源创建2个字段比如：一个是abc，另外一个是abcT, abcT字段存储名称, abc字段存储编号列。</li>
|
|
|
|
|
|
</ul>
|
|
|
|
|
|
</fieldset>
|
|
|
|
|
|
<!--
|
|
|
|
|
|
<a href="../CreateSFGuide.htm?DoType=New&FromApp=SL&s=0.5799617608442691">旧版本</a>-->
|
|
|
|
|
|
</body>
|
|
|
|
|
|
</html>
|
