<div class="portlet box ltblue" xmlns:th="http://www.w3.org/1999/xhtml">
|
<div class="portlet-title">
|
基本信息
|
<div class="caption">
|
<i class="icon-reorder"></i>
|
</div>
|
<div class="tools">
|
<!--<a href="javascript:;" class="collapse"></a>-->
|
</div>
|
</div>
|
<div class="portlet-body">
|
<input type="hidden" id="primarykey" th:value="${primarykey}"/>
|
<table id="sort" class="table table-bordered table-hover">
|
<thead>
|
<tr>
|
<th th:if="${FileldConfig==null}"></th>
|
<th>字段名称</th>
|
<th>字段类型</th>
|
<th>字段别名</th>
|
<th th:if="${FileldConfig==null}" style="text-align:center;vertical-align:middle;">显示格式</th>
|
<th th:if="${FileldConfig==null}">显示宽度(单位:像素)</th>
|
<th th:if="${FileldConfig==null}" style="text-align:center;vertical-align:middle;">移动</th>
|
</tr>
|
</thead>
|
<tbody id="ziDuanBieMing">
|
<tr th:each="ja,jaStat:${jsonArray}" th:if="${FileldConfig!=null}">
|
<td class="index"><input th:value="${ja.ZiDuanName}" name="ZiDuanName" class="form-control col-sm-9" disabled="disabled"/></td>
|
<td class="index"><input name="ZiDuanType" th:value="${ja.ZiDuanType}" class="form-control col-sm-6" disabled="disabled"/></td>
|
<td class="index"><input name="ZiDuanBieMing" th:value="${ja.ZiDuanBieMing}" class="form-control col-sm-6" disabled="disabled"/></td>
|
|
</tr>
|
|
<tr th:each="user,userStat:${list}" th:if="${FileldConfig==null and user.NAME!='OBJECTID' and user.NAME!='SHAPE'}">
|
<td class="index">
|
<input th:if="${user.ZiDuanXuanZe=='0'}" type="checkbox" name="one" /><!--//onclick="jiancha(this)"onclick="jiancha(this)"-->
|
<input th:if="${user.ZiDuanXuanZe=='1'}" type="checkbox" name="one" checked="checked"/>
|
</td>
|
<td class="index">
|
<input th:value="${user.NAME}" name="ZiDuanName" class="form-control col-sm-9" disabled="disabled"/>
|
</td>
|
<td class="index"><input name="ZiDuanType" th:value="${user.type}" class="form-control col-sm-6" disabled="disabled"/></td>
|
<td class="index"><input name="ZiDuanBieMing" th:value="${user.remarks}" class="form-control col-sm-9"/></td>
|
<td class="index" style="text-align:center;vertical-align:middle;"><button title="显示格式" class="btn btn-primary" style="padding: 0.37em 0.7em; vertical-align: baseline;" th:onclick="'Display('+${userStat.count}+')'" type="button">显示格式</button>
|
<input type="hidden" name="ZiDuanGeShi" th:id="'ZiDuanGeShi'+${userStat.count}" th:value="${user.ZiDuanGeShi}" class="form-control col-sm-6" value="{}" />
|
</td>
|
<td class="index"><input name="ZiDuanKuanDu" th:value="${user.ZiDuanKuanDu}" class="form-control col-sm-6" onkeyup="value=value.replace(/[^\d]/g,'')"/></td>
|
<td class="ui-widget-content" style="text-align:center;vertical-align:middle;">
|
<img src="/image/down.gif" onclick="check(this,'MoveDown')" style="cursor:pointer;"/>
|
<img src="/image/up.gif" onclick="check(this,'MoveUp')" style="cursor:pointer;"/>
|
<button title="置顶" class="btn btn-primary" style="padding: 0.37em 0.7em; vertical-align: baseline;" onclick="setTop(this);" type="button">置顶</button>
|
</td>
|
</tr>
|
</tbody>
|
</table>
|
</div>
|
</div>
|
|
|
<div style="height:50px;"></div>
|
<div class="form-actions navbar-fixed-bottom" style="z-index: 0;">
|
<div style="float: left;" th:if="${FileldConfig==null}">
|
<button type="button" id="save" class="btn btn-primary" onclick="save();"><i class="icon-save"></i> 保存</button>
|
</div>
|
<div style="float: left;" th:if="${FileldConfig!=null}">
|
<button type="button" id="bianji" class="btn btn-primary" onclick="bianji();"><i class="icon-save"></i> 编辑</button>
|
</div>
|
</div>
|
|
|
<script th:inline="javascript">
|
/*<![CDATA[*/
|
$(function () {
|
//默认选中主键字段,不可编辑勾选框，避免用户漏选主键 alert ykm 2018/12/26
|
var primarykey = $("#primarykey").val();
|
var primarykeys = primarykey.split(",");
|
var check = $("input[name='one']");
|
check.each(function () {
|
var row = $(this).parent("td").parent("tr");
|
var ZiDuanName = row.find("[name='ZiDuanName']").val();//注意html()和val()
|
for(var j=0;j<primarykeys.length;j++){
|
if(primarykeys[j]==ZiDuanName){
|
$(this).attr("checked",true);
|
$(this).attr("disabled",true);
|
$(this).attr("title","该字段为主键，主键为必选字段！");
|
$(this).parent("td").append("<span style=\"color: red;\">*</span>");
|
}
|
}
|
});
|
})
|
|
function jiancha(t) {
|
var check = $(t);//选中的复选框
|
check.each(function(){
|
var row = $(this).parent("td").parent("tr");
|
var ZiDuanBieMing = row.find("[name='ZiDuanBieMing']").val();
|
var array=["（","：","，","）","、"," "];
|
var k=0;
|
for(var i=0;i<array.length;i++){
|
if(ZiDuanBieMing.indexOf(array[i])>0){
|
k=1;
|
}
|
}
|
if(k==1){
|
alert("字段别名包含特殊字符或空格，请重新填写")
|
$(this).attr("checked",false);
|
}
|
});
|
|
|
}
|
function save() {
|
var primarykey = $("#primarykey").val();
|
var primarykeys = primarykey.split(",");
|
var keyTotal=0;//勾选主键个数
|
var check = $("input[name='one']:checked");//选中的复选框
|
var fieldconfig = "{\"sql\":[";
|
var i = 0;
|
if(check.length>0){
|
check.each(function () {
|
var row = $(this).parent("td").parent("tr");
|
var ZiDuanName = row.find("[name='ZiDuanName']").val();//注意html()和val()
|
var ZiDuanBieMing = row.find("[name='ZiDuanBieMing']").val();
|
var ZiDuanGeShi=row.find("[name='ZiDuanGeShi']").val();
|
var ZiDuanType=row.find("[name='ZiDuanType']").val();
|
var ZiDuanKuanDu=row.find("[name='ZiDuanKuanDu']").val();
|
for(var j=0;j<primarykeys.length;j++){
|
if(primarykeys[j]==ZiDuanName){
|
keyTotal++;
|
}
|
}
|
if(i > 0) {
|
fieldconfig += ",";
|
}
|
if(ZiDuanBieMing==""){
|
ZiDuanBieMing=ZiDuanName;
|
}
|
fieldconfig += "{ ZiDuanName: \"" + ZiDuanName + "\",ZiDuanType:\""+ZiDuanType+"\",ZiDuanBieMing: \"" + ZiDuanBieMing +"\",ZiDuanKuanDu: \"" + ZiDuanKuanDu+ "\",ZiDuanGeShi : "+ZiDuanGeShi+", Order: " + i + " }";
|
i++;
|
});
|
if(keyTotal!=primarykeys.length){
|
alert("存在主键未勾选!");
|
return;
|
}
|
fieldconfig += "]}";
|
window.opener.document.getElementById('fieldconfig').value = fieldconfig;
|
window.close();
|
}else {
|
alert("请选择列");
|
}
|
|
}
|
|
function bianji() {
|
var datasourceid=$("#datasourceid").val();
|
var primarykey =$("#primarykey").val();
|
//数据库表参数s
|
var tablename=$("#tablename").val();
|
var resMainInfoId = $("#resMainInfoId").val();
|
window.location.replace("ZiDuanBieMingBasic?datasourceid="+datasourceid+"&tablename="+tablename+"&resMainInfoId="+resMainInfoId+"&primarykey="+primarykey+"&bianji=1");
|
}
|
function check(t,oper){
|
var data_tr=$(t).parent().parent(); //获取到触发的tr
|
if(oper=="MoveUp"){ //向上移动
|
if($(data_tr).prev().html()==null){ //获取tr的前一个相同等级的元素是否为空
|
alert("已经是最顶部了!");
|
return;
|
}{
|
$(data_tr).insertBefore($(data_tr).prev()); //将本身插入到目标tr的前面
|
}
|
}else{
|
if($(data_tr).next().html()==null){
|
alert("已经是最低部了!");
|
return;
|
}{
|
$(data_tr).insertAfter($(data_tr).next()); //将本身插入到目标tr的后面
|
}
|
}
|
}
|
|
function setTop(obj){
|
var tr= $(obj).parent("td").parent("tr");
|
$("#ziDuanBieMing").find("tr").first().before(tr);
|
}
|
|
function Display(id) {
|
layer.open({
|
type: 2,
|
title: '设置格式',
|
shadeClose: true,
|
shade: 0.7,
|
maxmin: false, //开启最大化最小化按钮
|
area: ['800px', '600px'],
|
content: 'DisplayType?id='+id
|
});
|
|
}
|
/*]]>*/
|
</script>
|
