<%@ page language="java" import="java.util.*" pageEncoding="UTF-8" %>
|
<%@ taglib uri="http://shiro.apache.org/tags" prefix="shiro" %>
|
<%
|
String path = request.getContextPath();
|
String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
|
+ path + "/";
|
%>
|
|
<!DOCTYPE HTML>
|
<html>
|
<head>
|
<base href="<%=basePath%>">
|
<meta name="viewport" charset="width=device-width, initial-scale=1.0">
|
<meta http-equiv="X-UA-Compatible" content="ie=edge">
|
<title>导入模板信息</title>
|
|
<link rel="stylesheet" href="static/plugins/jquery-steps/css/main.css" type="text/css">
|
<link rel="stylesheet" href="static/plugins/jquery-steps/css/jquery.steps.css" type="text/css">
|
<link href="static/plugins/font-awesome/css/font-awesome.css" rel="stylesheet" type="text/css">
|
<link href="static/plugins/jquery-easyui/themes/bootstrap/easyui.css" rel="stylesheet" type="text/css">
|
<link rel="stylesheet" href="static/styles/initialize.css" type="text/css">
|
<link rel="stylesheet" href="static/styles/common.css" type="text/css">
|
<link rel="stylesheet" href="static/plugins/layer/skin/default/layer.css" type="text/css">
|
|
<script type="text/javascript" src="static/plugins/jquery/jquery.min.js"></script>
|
<script type="text/javascript" src="static/plugins/jquery-easyui/jquery.easyui.min.js"></script>
|
<script type="text/javascript" src="static/plugins/jquery-easyui/locale/easyui-lang-zh_CN.js"></script>
|
<script type="text/javascript" src="static/scripts/easyuiExtend.js"></script>
|
<script type="text/javascript" src="static/scripts/jquery-extend.js"></script>
|
<script type="text/javascript" src="static/plugins/layer/layer.js"></script>
|
<script type="text/javascript" src="static/plugins/slimScroll/jquery.slimscroll.min.js"></script>
|
<script type="text/javascript" src="static/scripts/ResizeScroll.js"></script>
|
<script type="text/javascript" src="static/plugins/jquery-easyui-edatagrid/jquery.edatagrid.js"></script>
|
<script type="text/javascript" src="static/plugins/jquery-easyui-datagrid-dnd/datagrid-dnd.js"></script>
|
<script src="static/plugins/ace/src-noconflict/ace.js" type="text/javascript"></script>
|
<!-- 弹窗加载组件 -->
|
<script type="text/javascript" src="static/plugins/layer/layer.js"></script>
|
<script type="text/javascript" src="static/plugins/spinjs/spin.js"></script>
|
<script type="text/javascript" src="static/plugins/spinjs/jquery.spin.js"></script>
|
<script type="text/javascript" src="static/plugins/jquery.blockUI.js"></script>
|
<!-- wcp组件 -->
|
<script type="text/javascript" src="static/wcp/scripts/wcp.js"></script>
|
<script type="text/javascript" src="static/wcp/scripts/libs/wcp.layer.js"></script>
|
<script type="text/javascript" src="static/wcp/scripts/libs/wcp.blockUI.js"></script>
|
<script type="text/javascript" src="static/wcp/scripts/libs/wcp.spin.js"></script>
|
<script type="text/javascript" src="static/wcp/scripts/libs/wcp.jquery.js"></script>
|
|
<!--[if lt IE 9]>
|
<script type="text/javascript" src="static/plugins/json2.js"></script>
|
<![endif]-->
|
<script type="text/javascript" src="static/wcp/scripts/libs/wcp.infoPicker.js"></script>
|
|
|
<style>
|
.combobox-group {
|
clear: both;
|
}
|
|
.radios label {
|
line-height: 26px !important;
|
}
|
|
.content {
|
height: 420px !important;
|
}
|
</style>
|
|
</head>
|
<body>
|
<div class="wizard clearfix" role="application" id="steps-uid-0">
|
<div class="steps clearfix">
|
<ul role="tablist">
|
<li id="steps-uid-0-t-0" role="tab" class="first current"><a>
|
<span class="number">1.</span> 导入模板信息
|
</a></li>
|
<li id="steps-uid-0-t-1" role="tab" class="disabled last"><a>
|
<span class="number">2.</span> 导入字段设计
|
</a></li>
|
</ul>
|
</div>
|
<div class="content clearfix">
|
<h3 id="steps-uid-0-h-0" tabindex="-1" class="title current">导入模板信息</h3>
|
<fieldset id="steps-uid-0-p-0" role="tabpanel" class="body current" style="padding:10px 20px;">
|
<form id="tablefrom" action="">
|
<div class="currentmargin" style="width:300px;">
|
<select id="scene" name="scene" labelWidth="100px" style="width:250px;height:60px"
|
class="easyui-combobox" data-options="panelHeight: '70px',editable:false" label="场景:"
|
labelPosition="top">
|
<option value="1" ${importTemplate.scene == '1'?'selected':''} >导数据</option>
|
<option value="2" ${importTemplate.scene == '2'?'selected':''} >归档导入</option>
|
</select>
|
</div>
|
<div class="currentmargin" style="width:300px;">
|
<input type="hidden" id="importTemplateId" name="importTemplateId"
|
value="${importTemplate.importTemplateId }"/>
|
<input id="importTemplateName" name="importTemplateName"
|
value="${importTemplate.importTemplateName }" label="导入模板名称:"
|
class="easyui-textbox easyui-validatebox" labelPosition="top"
|
labelWidth="100px" style="width:250px;height:60px" data-options="required:true">
|
</div>
|
<div class="currentmargin" style="width:300px;display:none;">
|
<input type="hidden" name="moduleId" value="${importTemplate.moduleId }" id="txt_ModuleId"
|
class="easyui-textbox">
|
<input id="txt_ModuleName" name="moduleName" value="${importTemplate.moduleName }"
|
class="easyui-textbox" label="所属模块:" labelPosition="top" style="width:250px;height:60px"
|
data-options="required:true,editable:false,buttonText:'选择模块',prompt:'',onClickButton:function(){selectModule();}"/>
|
|
</div>
|
<div class="currentmargin" style="width:300px;">
|
<input type="hidden" id="tableId" name="tableId" value="${importTemplate.tableId }">
|
<input id="tableName" name="tableName" value="${importTemplate.tableName }" class="easyui-textbox"
|
label="表名:" labelPosition="top" style="width:250px;height:60px"
|
data-options="required:true,editable:false,buttonText:'选择表',prompt:'',onClickButton:function(){selectTable();}"/>
|
|
</div>
|
<div class="currentmargin radios" style="width:600px;">
|
<p style="margin:16px 0px 6px 0px">遇错是否继续导入：</p>
|
<input class="easyui-radiobutton" name="importType" labelWidth="30px" label="是" value="0">
|
<input class="easyui-radiobutton" name="importType" labelWidth="30px" label="否" value="1">
|
</div>
|
<div class="currentmargin radios" style="width:600px;">
|
<p style="margin:16px 0px 6px 0px">挂载附件：</p>
|
<input class="easyui-radiobutton" name="mountFile" labelWidth="30px" label="是" value="1"
|
data-options="onChange:mountFileChange">
|
<input class="easyui-radiobutton" name="mountFile" labelWidth="30px" label="否" value="0"
|
data-options="checked:true,onChange:mountFileChange">
|
|
</div>
|
<div name="ruleDiv" class="currentmargin" style="width:500px;">
|
<p style="margin:16px 0px 6px 0px">规则：</p>
|
<input id="ruleCode" name="ruleCode" class="easyui-textbox" type="text"
|
value="${importTemplate.ruleCode}"
|
data-options="required:false,buttonText:'选择字段',prompt:'',onClickButton:selectColumnByRule"
|
style="width:100%"/>
|
|
</div>
|
<div name="ruleDiv" class="currentmargin" style="width:500px;">
|
<p style="margin:16px 0px 6px 0px">规则别名：</p>
|
<input id="ruleName" name="ruleName" class="easyui-textbox" type="text"
|
value="${importTemplate.ruleName}" data-options="required:false" style="width:100%"/>
|
</div>
|
<div class="currentmargin radios" style="width:600px;">
|
|
<p style="margin:16px 0px 6px 0px">重命名文件：</p>
|
<input class="easyui-radiobutton" name="renameFile" labelWidth="30px" label="是" value="1"
|
data-options="onChange:renameFileChange">
|
<input class="easyui-radiobutton" name="renameFile" labelWidth="30px" label="否" value="0"
|
data-options="checked:true,onChange:renameFileChange">
|
</div>
|
<div name="renameFileDiv" class="currentmargin" style="width:500px;display: none">
|
<p style="margin:16px 0px 6px 0px">重命名文件规则：</p>
|
<input id="renameFileRuleCode" name="renameFileRuleCode" class="easyui-textbox" type="text"
|
value="${importTemplate.renameFileRuleCode}"
|
data-options="required:false,buttonText:'选择字段',prompt:'',onClickButton:selectColumnByRenameFile"
|
style="width:100%"/>
|
|
</div>
|
<div name="renameFileDiv" class="currentmargin" style="width:500px;display: none">
|
<p style="margin:16px 0px 6px 0px">重命名文件别名：</p>
|
<input id="renameFileRuleName" name="renameFileRuleName" class="easyui-textbox" type="text"
|
value="${importTemplate.renameFileRuleName}" data-options="required:false"
|
style="width:100%"/>
|
</div>
|
<div class="currentmargin radios" style="width:600px;">
|
<p style="margin:16px 0px 6px 0px">导入后事件：</p>
|
<input id="afterEvent" name="afterEvent" value="${importTemplate.afterEvent}" class="easyui-textbox"
|
labelPosition="top" labelWidth="20px" style="width:100%"
|
data-options="required:false">
|
</div>
|
<div class="currentmargin radios" style="width:600px;">
|
<p style="margin:16px 0px 6px 0px">模板排序：</p>
|
<input id="sortNum" name="sortNum" value="${importTemplate.sortNum}"
|
class="easyui-numberbox easyui-validatebox" labelPosition="top" labelWidth="20px"
|
style="width:250px"
|
data-options="required:true">
|
</div>
|
<div class="currentmargin radios" style="width:600px;">
|
<p style="margin:16px 0px 6px 0px">首行是否显示模板名称：</p>
|
<input type="hidden" id="enableShowName" name="enableShowName"
|
value="${importTemplate.enableShowName}"/>
|
<input id="enableShowNameText" class="easyui-switchbutton"
|
data-options="onText:'是',offText:'否',onChange:changeEvent"/>
|
</div>
|
<div class="currentmargin radios" style="width:600px;">
|
<p style="margin:16px 0px 6px 0px">是否增加导入说明：</p>
|
<input type="hidden" id="enableAddMark" name="enableAddMark"
|
value="${importTemplate.enableAddMark}"/>
|
<input id="enableAddMarkText" class="easyui-switchbutton"
|
data-options="onText:'是',offText:'否',onChange:changeEvent"/>
|
</div>
|
<div name="addMarkConfigDiv" class="currentmargin" style="width:600px;">
|
<p style="margin:16px 0px 6px 0px">导入说明内容：</p>
|
<pre id="editorMarkContent" style="height:400px; width:800px;"></pre>
|
<textarea rows="2" cols="20" id="markContent" name="markContent"
|
style="display:none;width:800px">${importTemplate.markContent}</textarea>
|
</div>
|
<%-- <div name="addMarkConfigDiv" class="currentmargin" style="width:600px;">--%>
|
<%-- <p style="margin:16px 0px 6px 0px">数据从第几行开始导：</p>--%>
|
<%-- <input id="startRowNum" name="startRowNum" class="easyui-textbox" type="text"--%>
|
<%-- value="${importTemplate.startRowNum==null? 3:importTemplate.startRowNum}"--%>
|
<%-- style="width:100%"/>--%>
|
<%-- </div>--%>
|
</form>
|
</fieldset>
|
<h3 id="steps-uid-0-h-1" tabindex="-1" class="title">导入字段设计</h3>
|
<fieldset id="steps-uid-0-p-1" role="tabpanel" class="body" style="width:100%; display: none;">
|
<table id="tb_TableFields" singleselect="true" idfield="importColumnId" style="width: auto; height: 100%"
|
toolbar="#toolbar">
|
<thead>
|
<tr>
|
<th field="columnName" width="150" align="left">字段名</th>
|
<th field="displayName" width="120" align="left">显示名称</th>
|
<th field="excelColunm" width="120" align="left" editor="{type:'validatebox'}">excel列名</th>
|
<th field="enableUnique" width="60" align="center"
|
editor="{type:'checkbox',options:{on:'是',off:'否'}}">唯一
|
</th>
|
<th field="enableNotNull" width="60" align="center"
|
editor="{type:'checkbox',options:{on:'是',off:'否'}}">必填
|
</th>
|
<th field=enableDefaultColumn width="100" align="center"
|
editor="{type:'checkbox',options:{on:'是',off:'否'}}">默认字段
|
</th>
|
<th field="defaultValue" width="100" align="center" editor="text">默认值</th>
|
<th field="linkedData" width="120" align="center" formatter="linkedDataFormatter"
|
editor="{type:'combobox',options:{valueField:'csmc',textField:'csmc',data:linkedDataList,multiple:false,editable:false,panelHeight:'auto',onChange:function(newValue,oldValue){ setLinkedType(this,newValue,oldValue);}}}">
|
数据关联
|
</th>
|
<th field="linkedType" width="180" align="center" editor="selectlinkedbox">关联类型</th>
|
<th field="verificationExpression" width="100" align="left" editor="text">验证表达式</th>
|
<th field="enableFormula" width="60" align="center"
|
editor="{type:'checkbox',options:{on:'是',off:'否'}}">公式
|
</th>
|
<th field="formulaExpression" width="100" align="center" editor="text">公式表达式</th>
|
<th field="enableCoding" width="60" align="center"
|
editor="{type:'checkbox',options:{on:'是',off:'否'}}">编码
|
</th>
|
<th field="codingId" width="160" align="center"
|
editor="{type:'combobox',options:{valueField:'codingId',textField:'codingName',data:codingList,
|
multiple:false,editable:false,panelHeight:'auto'}}">编码格式
|
</th>
|
<th field="sortNum" width="60" align="center" editor="text" sorter="numSorter">排序</th>
|
</tr>
|
</thead>
|
</table>
|
<div id="toolbar" style="height: auto">
|
<div style="margin-left:2px;">
|
<a onclick="selectColumn()" class="pt-btn pt-btn-success">
|
<i class="fa fa-plus"></i> 添加字段
|
</a>
|
<a onclick="$('#tb_TableFields').edatagrid('saveRow');" class="pt-btn pt-btn-info">
|
<i class="fa fa-save"></i> 确认修改
|
</a>
|
<a onclick="$('#tb_TableFields').edatagrid('cancelRow');" class="pt-btn pt-btn-warning">
|
<i class="fa fa-scissors"></i> 取消修改
|
</a>
|
<a onclick="$('#tb_TableFields').edatagrid('destroyRow');" class="pt-btn pt-btn-danger">
|
<i class="fa fa-trash-o"></i> 删除字段
|
</a>
|
</div>
|
</div>
|
</fieldset>
|
</div>
|
|
<div class="pt-form-btn" style="bottom: 0">
|
<div class="form-group">
|
<button id="prev" class="pt-btn" role="menuitem">上一步</button>
|
<button id="next" class="pt-btn pt-btn-primary" role="menuitem">下一步</button>
|
<shiro:hasPermission name="SYS_CONFIG.MODULE.OPERATION.CONFIG.IMPORT.SAVE">
|
<button id="btnSave" class="pt-btn pt-btn-primary">保存</button>
|
</shiro:hasPermission>
|
<button id="btnClose" class="pt-btn pt-btn-default">关闭</button>
|
<input type="hidden" id="deleteFields">
|
</div>
|
</div>
|
</div>
|
</body>
|
<script type="text/javascript" src="static/scripts/ResizeScroll.js"></script>
|
<script>
|
//窗口参数，用于弹窗传递
|
var params = {
|
callBack: null
|
};
|
|
var next = null;
|
var deleteFields = [];
|
var codingList = [];
|
var linkedDataList = [
|
{
|
"csid": "0",
|
"csmc": "不关联",
|
},
|
{
|
"csid": "1",
|
"csmc": "关联参数"
|
},
|
{
|
"csid": "2",
|
"csmc": "关联表数据"
|
},
|
{
|
"csid": "3",
|
"csmc": "关联页签条件"
|
}
|
];
|
var _mountFile = '${importTemplate.mountFile}'
|
var _renameFile = '${importTemplate.renameFile}'
|
var editor_markContent;
|
$(function () {
|
editor_markContent = ace.edit("editorMarkContent");
|
editor_markContent.setTheme("ace/theme/monokai");
|
editor_markContent.session.setMode("ace/mode/javascript");
|
editor_markContent.setFontSize(16);
|
editor_markContent.session.setValue($("#markContent").val());
|
|
//初始化表单值(单选按钮)
|
$("input[radiobuttonName='importType'][value='${importTemplate.importType}']").radiobutton('check');
|
$("input[radiobuttonName='mountFile'][value='${importTemplate.mountFile}']").radiobutton('check');
|
$("input[radiobuttonName='renameFile'][value='${importTemplate.renameFile}']").radiobutton('check');
|
|
if ('${importTemplate.enableAddMark}' == "true") {
|
$('#enableAddMarkText').switchbutton("check");
|
$("div[name='addMarkConfigDiv']").show();
|
} else {
|
$('#enableAddMarkText').switchbutton("uncheck");
|
$("div[name='addMarkConfigDiv']").hide();
|
}
|
|
if ('${importTemplate.enableShowName}' == "true") {
|
$('#enableShowNameText').switchbutton("check");
|
} else {
|
$('#enableShowNameText').switchbutton("uncheck");
|
}
|
|
if (_mountFile != '1') {
|
$("div[name='ruleDiv']").hide();
|
}
|
if (_renameFile != '1') {
|
$("div[name='renameFileDiv']").hide();
|
}
|
var moduleName = "${moduleName}";
|
var moduleId = "${moduleId}";
|
if (moduleId != null && moduleId != "") {
|
$("#txt_ModuleId").textbox("setValue", moduleId);
|
}
|
if (moduleName != null && moduleName != "") {
|
$("#txt_ModuleName").textbox("setValue", moduleName);
|
}
|
|
$("#next").click(function () {
|
var valid = $("#importTemplateName").validatebox("isValid");
|
if (valid) {
|
if (_mountFile == 1) {
|
var _ruleCode = $("#ruleCode").val();
|
if (_ruleCode == '') {
|
wcp.notify.warn('规则项必填，请设置规则！');
|
return false;
|
}
|
}
|
//上一步下一步按钮
|
$("#prev").addClass("pt-btn-primary");
|
$(this).removeClass("pt-btn-primary");
|
$(this).addClass("disabled");
|
//内容
|
$("#steps-uid-0-p-1").show();
|
$("#steps-uid-0-p-0").hide();
|
//导航条
|
$("#steps-uid-0-t-1").addClass("current").removeClass("disabled");
|
$("#steps-uid-0-t-0").addClass("disabled").removeClass("current");
|
$("#steps-uid-0-t-0").removeClass("error");
|
} else {
|
$("#steps-uid-0-t-0").addClass("error");
|
}
|
|
var importTemplateId = "${importTemplate.importTemplateId }";
|
if (importTemplateId == null || importTemplateId == "") {
|
importTemplateId = 0;
|
}
|
//上一步，下一步不刷新表单内容
|
if (next != 1) {
|
$('#tb_TableFields').edatagrid({
|
rownumbers: true,
|
pagination: false,
|
fitColumns: true,
|
remoteSort: false,
|
method: "get",
|
url: "config/importTemplate/selectImportColumnList?importTemplateId=" + importTemplateId,
|
saveUrl: "",
|
updateUrl: "",
|
destroyUrl: "",
|
onBeforeSave: function (rowIndex) {
|
var Editrow = $('#tb_TableFields').datagrid('getEditor', {
|
index: rowIndex,
|
field: 'columnName'
|
});
|
},
|
onSave: function (index, row) {
|
$('#tb_TableFields').datagrid('sort', {
|
sortName: 'sortNum',
|
sortOrder: 'asc'
|
});
|
},
|
onDestroy: function (index, row) {
|
if (row.importColumnId > 0) {
|
deleteFields.push(row.importColumnId)
|
}
|
}
|
});
|
}
|
});
|
|
$("#prev").click(function () {
|
var valid = true;
|
next = 1;
|
if (valid) {
|
//上一步下一步按钮
|
$("#next").addClass("pt-btn-primary");
|
$(this).removeClass("pt-btn-primary");
|
//内容
|
$("#steps-uid-0-p-1").hide();
|
$("#steps-uid-0-p-0").show();
|
//导航条
|
$("#steps-uid-0-t-1").addClass("disabled").removeClass("current");
|
$("#steps-uid-0-t-0").addClass("current").removeClass("disabled");
|
}
|
});
|
|
$("#finish").click(function () {
|
var valid = $("#importTemplateName").validatebox("isValid");
|
});
|
|
//绑定按钮事件
|
$("#btnSave").click(function () {
|
$("#markContent").val(editor_markContent.getValue().replace(/(^\s*)|(\s*$)/g, ""));
|
//验证表单信息
|
var isValid = $('#tablefrom').form('validate');
|
if (!isValid) {
|
wcp.notify.warn('表单验证有误，请检查表单输入项！');
|
return false;
|
}
|
if (_mountFile == 1) {
|
var _ruleCode = $("#ruleCode").val();
|
if (_ruleCode == '') {
|
wcp.notify.warn('规则项必填，请设置规则！');
|
return false;
|
}
|
}
|
|
// if(next != 1){
|
// wcp.notify.warn('请先下一步！');
|
// return false;
|
// }
|
var obj = $("#tablefrom").serializeObject();
|
var importColumn = $('#tb_TableFields').datagrid("getRows");
|
//判断是否有字段
|
if (importColumn.length == 0) {
|
layer.alert("请添加字段再提交！");
|
return false;
|
}
|
|
//判断是否点击保存
|
for (i = 0; i < importColumn.length; i++) {
|
if (importColumn[i].hasOwnProperty('isNewRecord')) {
|
var isNewRecord = importColumn[i].isNewRecord;
|
if (isNewRecord) {
|
layer.alert("请先确认字段！");
|
return false;
|
}
|
//删除isNewRecord属性
|
delete importColumn[i].isNewRecord;
|
}
|
}
|
|
wcp.ui.setBusy("body", wcp.ajax({
|
url: "config/importTemplate/saveImportTemplate",
|
data: JSON.stringify({
|
importTemplate: obj,
|
columnList: importColumn,
|
deleteFields: deleteFields
|
}),
|
}).done(function (result) {
|
//判断是否需要执行回调函数
|
if (params.callBack) {
|
params.callBack();
|
}
|
closeWindow();
|
top.wcp.notify.success("保存成功！");
|
}));
|
});
|
|
|
$("#btnClose").click(function () {
|
closeWindow();
|
});
|
|
var moduleId = $("#txt_ModuleId").textbox("getValue");
|
wcp.ajax({
|
url: "config/coding/getCodingList?moduleId=" + moduleId,
|
}).done(function (result) {
|
for (var i = 0; i < result.length; i++) {
|
var map = {}
|
map["codingId"] = result[i].codingId,
|
map["codingName"] = result[i].codingName
|
codingList.push(map);
|
}
|
});
|
|
new ResizeScroll({
|
"id": "#tablefrom",
|
fun: function () {
|
return 410;
|
}
|
});
|
});
|
|
$.extend($.fn.datagrid.defaults.editors, {
|
selectlinkedbox: {
|
init: function (container, options) {
|
var selectlinkedboxi = $(container).closest(".datagrid-row").attr("datagrid-row-index");
|
|
var input = $("<div><input readonly=\"readonly\" id=\"txt_linkedType_" + selectlinkedboxi + "\" class=\"datagrid-editable-input\" style=\"width:100px; height:30px;\"></input><input type=\"hidden\" id=\"txt_UserRangeIds_" + selectlinkedboxi + "\" /><input type=\"button\" value=\"选\" class=\"pt-btn pt-btn-default\" style=\"width: 40px\" onclick=\"linkedData('txt_linkedType_" + selectlinkedboxi + "')\"/> </div>").appendTo(container);
|
return input;
|
},
|
getValue: function (target) {
|
return $($(target).children()[0]).val();
|
},
|
setValue: function (target, value) {
|
$($(target).children()[0]).val(value);
|
},
|
resize: function (target, width) {
|
$(target)._outerWidth(width);
|
}
|
}
|
});
|
|
function linkedDataFormatter(value) {
|
for (var i = 0; i < linkedDataList.length; i++) {
|
if (linkedDataList[i].csid == value)
|
return linkedDataList[i].csmc;
|
}
|
return value;
|
}
|
|
|
function setLinkedType(obj, newValue, oldValue) {
|
var rowData = $('#tb_TableFields').datagrid('getSelected');
|
if (newValue == "不关联") {
|
rowData.linkedData = "不关联";
|
//rowData.linkedType = "";
|
} else if (newValue == "关联参数") {
|
rowData.linkedData = "关联参数";
|
} else if (newValue == "关联表数据") {
|
rowData.linkedData = "关联表数据";
|
}
|
}
|
|
function linkedData(id) {
|
var rowData = $('#tb_TableFields').datagrid('getSelected');
|
var type = 0;
|
if (rowData.linkedData == "关联参数") {
|
type = 1;
|
} else if (rowData.linkedData == "关联表数据") {
|
type = 2;
|
}
|
if (type != 0) {
|
var tableName = $("#tableName").textbox("getValue");
|
var linkedType = $("#" + id).val();
|
var url = "config/importTemplate/linkedData?type=" + type + "&tableName=" + tableName + "&linkedType=" + encodeURIComponent(linkedType);
|
top.layer.open({
|
title: "关联数据设置",
|
type: 2,
|
area: ["500px", "300px"],
|
fixed: false,
|
content: url,
|
success: function (layero, index) {
|
var body = window.top.layer.getChildFrame('body', index);
|
var iframeWin = window.top[layero.find('iframe')[0]['name']]; //得到iframe页的窗口对象
|
|
//将回调函数传给子页面
|
iframeWin.params.id = id;
|
iframeWin.params.callBack = callBackData;
|
}
|
});
|
} else {
|
top.wcp.notify.error("无需选择数据！");
|
}
|
|
}
|
|
function callBackData(id, data) {
|
$("#" + id).val(data);
|
}
|
|
function closeWindow() {
|
var index = top.layer.getFrameIndex(window.name); //获取窗口索引
|
top.layer.close(index);
|
}
|
|
function numSorter(a, b) {
|
a = parseInt(a);
|
b = parseInt(b);
|
return a == b ? 0 : (a > b ? 1 : -1);
|
}
|
|
function codingFormatter(value) {
|
for (var i = 0; i < codingList.length; i++) {
|
if (codingList[i].codingId == value)
|
return codingList[i].codingName;
|
}
|
return value;
|
}
|
|
//选择模块
|
function selectModule() {
|
wcp.picker.selectModule({
|
title: "请选择模块",
|
multiSelect: false,
|
idElement: "txt_ModuleId",
|
nameElement: "txt_ModuleName",
|
layerOpener: window
|
});
|
}
|
|
function getMaxSortNum() {
|
var maxSortNum = 1;
|
var rows = $('#tb_TableFields').datagrid("getRows");
|
if (rows.length > 0) {
|
for (var i = 0; i < rows.length; i++) {
|
if (rows[i].sortNum != "") {
|
var sortNum = parseInt(rows[i].sortNum);
|
if (sortNum > maxSortNum) {
|
maxSortNum = sortNum + 1;
|
}
|
}
|
}
|
}
|
|
return maxSortNum;
|
}
|
|
function selectColumn() {
|
var maxSortNum = getMaxSortNum();
|
var tableName = $("#tableName").textbox("getValue");
|
wcp.picker.selectTableColumn({
|
title: "请选择字段",
|
tableName: tableName,
|
multiSelect: true,
|
layerOpener: window
|
}, function (rows) {
|
$.each(rows, function (index, value) {
|
$('#tb_TableFields').datagrid('appendRow', {
|
columnName: value.columnName,
|
displayName: value.displayName,
|
excelColunm: value.displayName,
|
enableNotNull: "否",
|
enableUnique: "否",
|
enableDefaultColumn: "否",
|
enableCoding: "否",
|
enableFormula: "否",
|
linkedData: "不关联",
|
sortNum: maxSortNum++
|
});
|
});
|
});
|
}
|
|
//选择字段
|
function selectColumnByRule() {
|
var idName = this.id;
|
var moduleId = "${moduleId}";
|
wcp.picker.selectTableColumn({
|
title: "请选择字段",
|
moduleId: moduleId,
|
multiSelect: true,
|
layerOpener: window
|
}, function (rows) {
|
var _separator = '-';
|
var selectedColumns = "";
|
var selectedDisplayName = "";
|
$.each(rows, function (index, value) {
|
selectedColumns += '\${' + value.columnName + '}' + _separator;
|
selectedDisplayName += '\${' + value.displayName + '}' + _separator;
|
;
|
});
|
|
selectedColumns = selectedColumns.substr(0, selectedColumns.length - 1);
|
selectedColumns = selectedColumns + "*.*"
|
|
selectedDisplayName = selectedDisplayName.substr(0, selectedDisplayName.length - 1);
|
selectedDisplayName = selectedDisplayName + "*.*"
|
|
$('#' + idName).textbox("setValue", selectedColumns);
|
$('#ruleName').textbox("setValue", selectedDisplayName);
|
});
|
}
|
|
//选择字段
|
function selectColumnByRenameFile() {
|
var idName = this.id;
|
var moduleId = "${moduleId}";
|
wcp.picker.selectTableColumn({
|
title: "请选择字段",
|
moduleId: moduleId,
|
multiSelect: true,
|
layerOpener: window
|
}, function (rows) {
|
var _separator = '-';
|
var selectedColumns = "";
|
var selectedDisplayName = "";
|
$.each(rows, function (index, value) {
|
selectedColumns += '\${' + value.columnName + '}' + _separator;
|
selectedDisplayName += '\${' + value.displayName + '}' + _separator;
|
;
|
});
|
|
selectedColumns = selectedColumns.substr(0, selectedColumns.length - 1);
|
|
selectedDisplayName = selectedDisplayName.substr(0, selectedDisplayName.length - 1);
|
|
$('#' + idName).textbox("setValue", selectedColumns);
|
$('#renameFileRuleName').textbox("setValue", selectedDisplayName);
|
});
|
}
|
|
function selectTable() {
|
var moduleId = "${moduleId}";
|
wcp.picker.selectTable({
|
title: "请选择表",
|
multiSelect: false,
|
layerOpener: window,
|
moduleId: moduleId
|
}, function (rows) {
|
var selectedTables = "";
|
var tableIds = "";
|
$.each(rows, function (index, value) {
|
selectedTables += value.tableName + ',';
|
tableIds = tableIds + value.tableId + ",";
|
});
|
selectedTables = selectedTables.substr(0, selectedTables.length - 1);
|
tableIds = tableIds.substr(0, tableIds.length - 1);
|
$('#tableName').textbox("setValue", selectedTables);
|
$('#tableId').val(tableIds);
|
});
|
}
|
|
//挂接附件改变事件
|
function mountFileChange(checked) {
|
if (checked) {
|
var value = $(this).val();
|
_mountFile = value;
|
if (value == 1) {
|
$("div[name='ruleDiv']").show();
|
} else {
|
$("div[name='ruleDiv']").hide();
|
}
|
}
|
}
|
|
//选择控件切换事件
|
function changeEvent(checked) {
|
$('#' + this.id.replace("Text", "")).val(checked);
|
if (this.id == "enableAddMarkText") {
|
if (checked) {
|
$("div[name='addMarkConfigDiv']").show();
|
} else {
|
$("div[name='addMarkConfigDiv']").hide();
|
}
|
}
|
}
|
|
//重命名文件名称改变事件
|
function renameFileChange(checked) {
|
if (checked) {
|
var value = $(this).val();
|
_mountFile = value;
|
if (value == 1) {
|
$("div[name='renameFileDiv']").show();
|
} else {
|
$("div[name='renameFileDiv']").hide();
|
}
|
}
|
}
|
|
</script>
|
</html>
|
