skyversation
/
meidu2021


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446
							<!DOCTYPE html>
<html>
<head>
	<script type="text/javascript" src="plug-in/mutiLang/zh-cn.js"></script>
	<script type="text/javascript" src="plug-in/jquery/jquery-1.9.0.js"></script>
	<script type="text/javascript" src="plug-in/jquery/jquery.cookie.js"></script>
	<script type="text/javascript" src="plug-in/jquery-plugs/storage/jquery.storageapi.min.js"></script>
	<script type="text/javascript" src="plug-in/tools/dataformat.js"></script>
	<link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/easyui.css" type="text/css"></link>
	<link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/main.css" type="text/css"></link>
	<link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/metrole/icon.css" type="text/css"></link>
	<link rel="stylesheet" type="text/css" href="plug-in/accordion/css/accordion.css">
	<link rel="stylesheet" type="text/css" href="plug-in/accordion/css/icons.css">
	<script type="text/javascript" src="plug-in/easyui/jquery.easyui.min.1.3.2.js"></script>
	<script type="text/javascript" src="plug-in/easyui/locale/zh-cn.js"></script>
	<script type="text/javascript" src="plug-in/tools/syUtil.js"></script>
	<script type="text/javascript" src="plug-in/easyui/extends/datagrid-scrollview.js"></script>
	<script type="text/javascript" src="plug-in/My97DatePicker/WdatePicker.js"></script>
	<link rel="stylesheet" href="plug-in/tools/css/metrole/common.css" type="text/css"></link>
	<link rel="stylesheet" href="plug-in/ace/css/font-awesome.css" type="text/css"></link>
	<script type="text/javascript" src="plug-in/lhgDialog/lhgdialog.min.js?skin=metrole"></script>
	<script type="text/javascript" src="plug-in/ace/js/bootstrap-tab.js"></script>
	<script type="text/javascript" src="plug-in/tools/curdtools_zh-cn.js"></script>
	<script type="text/javascript" src="plug-in/tools/easyuiextend.js"></script>
	<script type="text/javascript" src="plug-in/jquery-plugs/hftable/jquery-hftable.js"></script>
	<script type="text/javascript" src="plug-in/tools/json2.js"></script>

	<script type="text/javascript">
		jQuery(function() {
			storage = jQuery.localStorage;
			if (!storage) storage = jQuery.cookieStorage;
			jQuery('#autoFormDbList').datagrid({
				idField: 'id',
				title: '表单数据源配置',
				url: 'autoFormDbController.do?datagrid&autoFormId=$!{autoFormId}&field=id,createName,createBy,updateName,updateBy,sysOrgCode,sysCompanyCode,createDate,updateDate,dbName,dbChName,dbType,dbTableName,tbDbKey,tbDbTableName,dbDynSql,dbKey,',
				fit: true,
				loadMsg: '数据加载中...',
				pageSize: 10,
				pagination: true,
				pageList: [10, 20, 30],
				sortOrder: 'asc',
				rownumbers: true,
				singleSelect: false,
				fitColumns: false,
				striped: true,
				showFooter: true,
				frozenColumns: [[{
					field: 'ck',
					checkbox: 'true'
				},
				]],
				columns: [[{
					field: 'id',
					title: '',
					width: 120,
					hidden: true,
					sortable: true
				},
				{
					field: 'createName',
					title: '创建人名称',
					width: 120,
					hidden: true,
					sortable: true
				},
				{
					field: 'createBy',
					title: '创建人',
					width: 120,
					hidden: true,
					sortable: true
				},
				{
					field: 'updateName',
					title: '更新人名称',
					width: 120,
					hidden: true,
					sortable: true
				},
				{
					field: 'updateBy',
					title: 'common.updateBy',
					width: 120,
					hidden: true,
					sortable: true
				},
				{
					field: 'createDate',
					title: '创建日期',
					width: 120,
					hidden: true,
					sortable: true,
					formatter: function(value, rec, index) {
						return new Date().format('yyyy-MM-dd', value);
					}
				},
				{
					field: 'updateDate',
					title: '更新日期',
					width: 120,
					hidden: true,
					sortable: true,
					formatter: function(value, rec, index) {
						return new Date().format('yyyy-MM-dd', value);
					}
				},
				{
					field: 'dbName',
					title: '数据源编码',
					width: 120,
					sortable: true
				},
				{
					field: 'dbChName',
					title: '数据源名称',
					width: 120,
					sortable: true
				},
				{
					field: 'dbType',
					title: '数据源类型',
					width: 120,
					sortable: true,
					formatter: function(value, rec, index) {
						if (value == undefined) return '';
						var valArray = value.split(',');
						if (valArray.length > 1) {
							var checkboxValue = '';
							for (var k = 0; k < valArray.length; k++) {
								if (valArray[k] == 'table') {
									checkboxValue = checkboxValue + '数据库表' + ',';
								}
								if (valArray[k] == 'sql') {
									checkboxValue = checkboxValue + '动态SQL' + ',';
								}
								if (valArray[k] == 'clazz') {
									checkboxValue = checkboxValue + 'java类' + ',';
								}
							}
							return checkboxValue.substring(0, checkboxValue.length - 1);
						} else {
							if (value == 'table') {
								return '数据库表';
							}
							if (value == 'sql') {
								return '动态SQL';
							}
							if (value == 'clazz') {
								return 'java类';
							} else {
								return value;
							}
						}
					}
				},
				{
					field: 'dbTableName',
					title: '数据库表名',
					width: 120,
					sortable: true
				},
				{
					field: 'tbDbKey',
					title: '填报数据源',
					width: 120,
					sortable: true
				},
				{
					field: 'tbDbTableName',
					title: '填报数据库表',
					width: 120,
					sortable: true
				},
				{
					field: 'dbDynSql',
					title: '动态查询SQ',
					width: 120,
					sortable: true
				},
				{
					field: 'dbKey',
					title: '数据源',
					width: 120,
					hidden: true,
					sortable: true
				},
				{
					field: 'opt',
					title: '操作',
					width: 100,
					formatter: function(value, rec, index) {
						if (!rec.id) {
							return '';
						}
						var href = '';
						href += "<a href='#'   class='ace_button'  onclick=delObj('autoFormDbController.do?doDel&id=" + rec.id + "','autoFormDbList')>  <i class=' fa fa-trash-o'></i> ";
						href += "删除</a>&nbsp;";
						href += "<a href='#'   class='ace_button'  onclick=goView('" + rec.id + "','" + index + "')>  <i class=' fa fa-search'></i>";
						href += "预览</a>&nbsp;";
						return href;
					}
				}]],
				onLoadSuccess: function(data) {
					jQuery("#autoFormDbList").datagrid("clearSelections");
				},
				onClickRow: function(rowIndex, rowData) {
					rowid = rowData.id;
					gridname = 'autoFormDbList';
				}
			});
			jQuery('#autoFormDbList').datagrid('getPager').pagination({
				beforePageText: '',
				afterPageText: '/{pages}',
				displayMsg: '{from}-{to}共 {total}条',
				showPageList: true,
				showRefresh: true
			});
			jQuery('#autoFormDbList').datagrid('getPager').pagination({
				onBeforeRefresh: function(pageNumber, pageSize) {
					jQuery(this).pagination('loading');
					jQuery(this).pagination('loaded');
				}
			});
			try {
				restoreheader();
			} catch(ex) {}
		});
		function reloadTable() {
			try {
				jQuery('#' + gridname).datagrid('reload');
				jQuery('#' + gridname).treegrid('reload');
			} catch(ex) {}
		}
		function reloadautoFormDbList() {
			jQuery('#autoFormDbList').datagrid('reload');
		}
		function getautoFormDbListSelected(field) {
			return getSelected(field);
		}
		function getSelected(field) {
			var row = jQuery('#' + gridname).datagrid('getSelected');
			if (row != null) {
				value = row[field];
			} else {
				value = '';
			}
			return value;
		}
		function getautoFormDbListSelections(field) {
			var ids = [];
			var rows = jQuery('#autoFormDbList').datagrid('getSelections');
			for (var i = 0; i < rows.length; i++) {
				ids.push(rows[i][field]);
			}
			ids.join(',');
			return ids
		};
		function getSelectRows() {
			return jQuery('#autoFormDbList').datagrid('getChecked');
		}
		function saveHeader() {
			var columnsFields = null;
			var easyextends = false;
			try {
				columnsFields = jQuery('#autoFormDbList').datagrid('getColumns');
				easyextends = true;
			} catch(e) {
				columnsFields = jQuery('#autoFormDbList').datagrid('getColumnFields');
			}
			var cols = storage.get('autoFormDbListhiddenColumns');
			var init = true;
			if (cols) {
				init = false;
			}
			var hiddencolumns = [];
			for (var i = 0; i < columnsFields.length; i++) {
				if (easyextends) {
					hiddencolumns.push({
						field: columnsFields[i].field,
						hidden: columnsFields[i].hidden
					});
				} else {
					var columsDetail = jQuery('#autoFormDbList').datagrid("getColumnOption", columnsFields[i]);
					if (init) {
						hiddencolumns.push({
							field: columsDetail.field,
							hidden: columsDetail.hidden,
							visible: (columsDetail.hidden == true ? false: true)
						});
					} else {
						for (var j = 0; j < cols.length; j++) {
							if (cols[j].field == columsDetail.field) {
								hiddencolumns.push({
									field: columsDetail.field,
									hidden: columsDetail.hidden,
									visible: cols[j].visible
								});
							}
						}
					}
				}
			}
			storage.set('autoFormDbListhiddenColumns', JSON.stringify(hiddencolumns));
		}
		function isShowBut() {
			var isShowSearchId = jQuery('#isShowSearchId').val();
			if (isShowSearchId == "true") {
				jQuery("#searchColums").hide();
				jQuery('#isShowSearchId').val("false");
				jQuery('#columsShow').remove("src");
				jQuery('#columsShow').attr("src", "plug-in/easyui/themes/default/images/accordion_expand.png");
			} else {
				jQuery("#searchColums").show();
				jQuery('#isShowSearchId').val("true");
				jQuery('#columsShow').remove("src");
				jQuery('#columsShow').attr("src", "plug-in/easyui/themes/default/images/accordion_collapse.png");
			}
		}
		function restoreheader() {
			var cols = storage.get('autoFormDbListhiddenColumns');
			if (!cols) return;
			for (var i = 0; i < cols.length; i++) {
				try {
					if (cols.visible != false) jQuery('#autoFormDbList').datagrid((cols[i].hidden == true ? 'hideColumn': 'showColumn'), cols[i].field);
				} catch(e) {}
			}
		}
		function resetheader() {
			var cols = storage.get('autoFormDbListhiddenColumns');
			if (!cols) return;
			for (var i = 0; i < cols.length; i++) {
				try {
					jQuery('#autoFormDbList').datagrid((cols.visible == false ? 'hideColumn': 'showColumn'), cols[i].field);
				} catch(e) {}
			}
		}
		function autoFormDbListsearch() {
			try {
				if (!jQuery("#autoFormDbListForm").Validform({
					tiptype: 3
				}).check()) {
					return false;
				}
			} catch(e) {}
			if (true) {
				var queryParams = jQuery('#autoFormDbList').datagrid('options').queryParams;
				jQuery('#autoFormDbListtb').find('*').each(function() {
					queryParams[jQuery(this).attr('name')] = jQuery(this).val();
				});
				jQuery('#autoFormDbList').datagrid({
					url: 'autoFormDbController.do?datagrid&autoFormId=$!{autoFormId}&field=id,createName,createBy,updateName,updateBy,sysOrgCode,sysCompanyCode,createDate,updateDate,dbName,dbChName,dbType,dbTableName,tbDbKey,tbDbTableName,dbDynSql,dbKey,',
					pageNumber: 1
				});
			}
		}
		function dosearch(params) {
			var jsonparams = jQuery.parseJSON(params);
			jQuery('#autoFormDbList').datagrid({
				url: 'autoFormDbController.do?datagrid&autoFormId=$!{autoFormId}&field=id,createName,createBy,updateName,updateBy,sysOrgCode,sysCompanyCode,createDate,updateDate,dbName,dbChName,dbType,dbTableName,tbDbKey,tbDbTableName,dbDynSql,dbKey,',
				queryParams: jsonparams
			});
		}
		function autoFormDbListsearchbox(value, name) {
			var queryParams = jQuery('#autoFormDbList').datagrid('options').queryParams;
			queryParams[name] = value;
			queryParams.searchfield = name;
			jQuery('#autoFormDbList').datagrid('reload');
		}
		jQuery('#autoFormDbListsearchbox').searchbox({
			searcher: function(value, name) {
				autoFormDbListsearchbox(value, name);
			},
			menu: '#autoFormDbListmm',
			prompt: '请输入查询关键字'
		});
		function EnterPress(e) {
			var e = e || window.event;
			if (e.keyCode == 13) {
				autoFormDbListsearch();
			}
		}
		function searchReset(name) {
			jQuery("#" + name + "tb").find(":input").val("");
			var queryParams = jQuery('#autoFormDbList').datagrid('options').queryParams;
			jQuery('#autoFormDbListtb').find('*').each(function() {
				queryParams[jQuery(this).attr('name')] = jQuery(this).val();
			});
			jQuery('#autoFormDbList').datagrid({
				url: 'autoFormDbController.do?datagrid&autoFormId=$!{autoFormId}&field=id,createName,createBy,updateName,updateBy,sysOrgCode,sysCompanyCode,createDate,updateDate,dbName,dbChName,dbType,dbTableName,tbDbKey,tbDbTableName,dbDynSql,dbKey,',
				pageNumber: 1
			});
		}
	</script>
	<script type="text/javascript">
		jQuery(document).ready(function() {
			//给时间控件加上样式
			jQuery("#autoFormDbListtb").find("input[name='createDate']").attr("class", "Wdate").click(function() {
				WdatePicker({
					dateFmt: 'yyyy-MM-dd'
				});
			});
			jQuery("#autoFormDbListtb").find("input[name='updateDate']").attr("class", "Wdate").click(function() {
				WdatePicker({
					dateFmt: 'yyyy-MM-dd'
				});
			});
		});

		//导入
		function ImportXls() {
			openuploadwin('Excel导入', 'autoFormDbController.do?upload', "autoFormDbList");
		}

		//导出
		function ExportXls() {
			JeecgExcelExport("autoFormDbController.do?exportXls", "autoFormDbList");
		}

		//模板下载
		function ExportXlsByT() {
			JeecgExcelExport("autoFormDbController.do?exportXlsByT", "autoFormDbList");
		}

		//数据源预览
		function goView(id) {
			openwindow('查看', 'autoFormDbController.do?goView_vm&id=' + id, '', 600, 500);
		}
	</script>
</head>
<body>
	<div class="easyui-layout" fit="true">
		<div region="center" style="padding:0px;border:0px">
			<table width="100%" id="autoFormDbList" toolbar="#autoFormDbListtb"></table>
			<div id="autoFormDbListtb" style="padding:3px; height: auto">
				<div style="height:30px;" class="datagrid-toolbar">
					<span style="float:left;">
						<a href="#" class="easyui-linkbutton" plain="true" icon="icon-edit" onclick="update('编辑','autoFormDbController.do?goUpdate_vm','autoFormDbList',null,600)">编辑</a>
						<a href="#" class="easyui-linkbutton" plain="true" icon="icon-search" onclick="detail('查看','autoFormDbController.do?goUpdate_vm','autoFormDbList',null,null)">查看</a>
						<a href="#" class="easyui-linkbutton" plain="true" icon="icon-remove" onclick="deleteALLSelect('批量删除','autoFormDbController.do?doBatchDel','autoFormDbList',null,null)">批量删除</a>
					</span>
				</div>
			</div>
		</div>
	</div>
</body>
</html>