123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432 |
- <!DOCTYPE HTML>
- <html>
- <head>
- <meta charset="utf-8">
- <meta name="renderer" content="webkit|ie-comp|ie-stand">
- <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
- <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />
- <meta http-equiv="Cache-Control" content="no-siteapp" />
- <!--[if lt IE 9]>
- <script type="text/javascript" src="${ctx}/assets/lib/html5.js"></script>
- <script type="text/javascript" src="${ctx}/assets/lib/respond.min.js"></script>
- <script type="text/javascript" src="${ctx}/assets/lib/PIE_IE678.js"></script>
- <![endif]-->
- <link rel="stylesheet" type="text/css" href="${ctx}/assets/static/h-ui/css/H-ui.min.css" />
- <link rel="stylesheet" type="text/css" href="${ctx}/assets/static/h-ui.admin/css/H-ui.admin.css" />
- <link rel="stylesheet" type="text/css" href="${ctx}/assets/lib/Hui-iconfont/1.0.7/iconfont.css" />
- <link rel="stylesheet" type="text/css" href="${ctx}/assets/lib/icheck/icheck.css" />
- <link rel="stylesheet" type="text/css" href="${ctx}/assets/static/h-ui.admin/skin/default/skin.css" id="skin" />
- <link rel="stylesheet" type="text/css" href="${ctx}/assets/static/h-ui.admin/css/style.css" />
- <script type="text/ecmascript" src="${ctx}/assets/lib/jquery/1.9.1/jquery.js"></script>
- <script type="text/javascript" src="${ctx}/assets/static/h-ui/js/H-ui.js"></script>
- <link rel="stylesheet" type="text/css" media="screen" href="${ctx}/assets/lib/jqueryui/jquery-ui.css" />
- <link rel="stylesheet" type="text/css" media="screen" href="${ctx}/assets/lib/jqgrid/css/ui.jqgrid.css" />
- <script type="text/ecmascript" src="${ctx}/assets/lib/jqueryui/jquery-ui.js"></script>
- <script type="text/ecmascript" src="${ctx}/assets/lib/jqgrid/js/i18n/grid.locale-cn.js"></script>
- <script type="text/ecmascript" src="${ctx}/assets/lib/jqgrid/js/jquery.jqGrid.min.js"></script>
- <script type="text/javascript" src="${ctx}/assets/js/base.js"></script>
- <!--[if IE 6]>
- <script type="text/javascript" src="${ctx}/assets/lib/DD_belatedPNG_0.0.8a-min.js" ></script>
- <script>DD_belatedPNG.fix('*');</script>
- <![endif]-->
- <script type="text/javascript">
- $(function() {
- $(window).resize(function(){
- $("#jqGrid").setGridWidth($(window).width()-40);
- });
- $("#jqGrid").jqGrid({
- url : '${ctx}/myconsole/metatable/getByPage',
- editurl:"${ctx}/myconsole/metatable/saveOrUpdate",
- mtype : "POST",
- datatype : "json",
- multiselect: true,
- caption:'元数据对象(栏目类型)',
- prmNames : {
- id: "keyid",
- oper:"oper",
- addoper:"add",
- editoper:"edit",
- deloper:"del"
- },
- colModel : [ {
- label : '元数据编号',
- name : 'keyid',
- hidden : true,
- key : true,
- width : 50
- }, {
- label : '包名称',
- name : 'packagename',
- editable: true,
- formoptions:{
- elmsuffix:'小写'
- },
- editoptions:{
- defaultValue:'com.fsm.app'
- },
- editrules:{required:true},
- width : 80
- }, {
- label : '类名',
- name : 'modelname',
- editable: true,
- formoptions:{
- elmsuffix:'英文,首字母大写'
- },
- editrules:{required:true},
- width : 80
- },{
- label : '类描述',
- name : 'modeldesc',
- formoptions:{
- elmsuffix:'中文描述'
- },
- editrules:{required:true},
- editable: true,
- width : 80
- },{
- label : 'Excel工作表',
- name : 'excelsheet',
- formoptions:{
- elmsuffix:'工作表名称'
- },
- editoptions:{
- defaultValue:'Sheet1'
- },
- editable: true,
- width : 80
- },{
- label : 'Excel标题行',
- name : 'exceltitle',
- editoptions:{
- defaultValue:'1'
- },
- editrules:{integer:true,minValue:0},
- editable: true,
- width : 80
- }, {
- label : '更新时间',
- name : 'updatetime',
- editable: false,
- width : 80
- }],
- rownumbers : true,//添加左侧行号
- viewrecords : true,//是否在浏览导航栏显示记录总数
- rowNum : 10,//每页显示记录数
- rowList : [10,15,20,30,40,50 ],//用于改变显示行数的下拉列表框的元素数组。
- autowidth : true,
- height : 'auto',
- onSelectRow : function( rowid ) {
- if(rowid.length>10){
- $("#jqGrid1").setColProp('tableid',{editoptions:{value:rowid+":a"}});
- var row = $(this).getRowData(rowid);
- $("#jqGrid1").setCaption("元数据属性--"+row.modeldesc);
- $("#jqGrid1").jqGrid('setGridParam',{url: "${ctx}/myconsole/metafield/getByPage?tableid="+rowid});
- $("#jqGrid1").trigger("reloadGrid");
- }
- },
- pager : "#jqGridPager"
- });
- $('#jqGrid').navGrid('#jqGridPager',
- // the buttons to appear on the toolbar of the grid
- {
- edit : true,
- add : true,
- del : true,
- search : true,
- refresh : true,
- view : true,
- position : "left",
- cloneToTop : true
- },
- // options for the Edit Dialog
- {
- recreateForm : true,
- checkOnUpdate : true,
- checkOnSubmit : true,
- closeAfterEdit : true,
- onInitializeForm:function(formid) {
- },
- serializeEditData: function(postdata) {
- //myconsole.log(postdata);
- $.each(postdata,function (index, value) {
- //myconsole.log(index);
- if(index!="jqGrid_id" && index!="oper" && index!="keyid"){
- modifyJosnKey(postdata,index,"metaTable."+index);
- }
- if(index=="keyid"){
- postdata["metaTable."+index]=value
- }
- })
- //myconsole.log(postdata);
- return postdata;
- },
- errorTextFormat : function(data) {
- return 'Error: ' + data.responseText
- }
- },
- // options for the Add Dialog
- {
- closeAfterAdd : true,
- recreateForm : true,
- beforeSubmit: function(postdata, formid){
- $.each(postdata,function (index, value) {
- if(index!="jqGrid_id" && index!="oper"){
- modifyJosnKey(postdata,index,"metaTable."+index);
- }
- })
- return[true,''];
- },
- errorTextFormat : function(data) {
- return 'Error: ' + data.responseText
- }
- },
- // options for the Delete Dailog
- {
- errorTextFormat : function(data) {
- return 'Error: ' + data.responseText
- }
- },{
- // search options 这里支持多条件查询
- multipleSearch: true,
- sopt:['eq','ne','cn','nc','lt','le','gt','ge'],
- afterSubmit: function(r, data) {
- var messageString = r.responseText;
- var mesObj = eval('(' + messageString + ')');
- return [mesObj.state, mesObj.message];
- }
- }
- );
- /////////////////////////////////////////////////////////////////////////////////////////////////
- $(window).resize(function(){
- $("#jqGrid1").setGridWidth($(window).width()-40);
- });
- $("#jqGrid1").jqGrid({
- url : '${ctx}/myconsole/metafield/getByPage',
- editurl:"${ctx}/myconsole/metafield/saveOrUpdate",
- mtype : "POST",
- datatype : "json",
- caption:'元数据属性',
- prmNames : {
- id: "keyid",
- oper:"oper",
- addoper:"add",
- editoper:"edit",
- deloper:"del"
- },
- colModel : [ {
- label : '属性编号',
- name : 'keyid',
- hidden : true,
- key : true,
- width : 50
- }, {
- label : '元数据 编号',
- name : 'tableid',
- hidden : true,
- editable : true,
- edittype :"select",
- editoptions:{value:"a:a"}
- },{
- label : '属性名称',
- name : 'fieldname',
- editable: true,
- width : 80
- }, {
- label : '属性类型',
- name : 'fieldtype',
- editable: true,
- formatter:"select",
- edittype: "select",
- editoptions: {
- value: "${fieldType}"
- },
- stype:"select",
- searchoptions:{
- value: "${fieldType}"
- },
- width : 80
- }, {
- label : '属性长度',
- name : 'fieldlength',
- editable: true,
- width : 80
- }, {
- label : '属性描述',
- name : 'fielddesc',
- editable: true,
- width : 80
- }, {
- label : '表单类型',
- name : 'formtype',
- editable: true,
- formatter:"select",
- edittype: "select",
- editoptions: {
- value: "${formType}"
- },
- stype:"select",
- searchoptions:{
- value: "${formType}"
- },
- width : 80
- }, {
- label : '字典选项',
- name : 'formoption',
- editable: true,
- formatter:"select",
- edittype: "select",
- editoptions: {
- value: "${dataDic}"
- },
- stype:"select",
- searchoptions:{
- value: "${dataDic}"
- },
- width : 80
- }, {
- label : '表单验证',
- name : 'formvalidate',
- editable: true,
- formatter:"select",
- edittype: "select",
- editoptions: {
- value: "${formVerification}"
- },
- stype:"select",
- searchoptions:{
- value: "${formVerification}"
- },
- width : 80
- }, {
- label : '列表显示',
- name : 'listshow',
- editable: true,
- formatter:"select",
- edittype: "select",
- editoptions: {
- value: "${listshow}"
- },
- stype:"select",
- searchoptions:{
- value: "${listshow}"
- },
- width : 80
- }, {
- label : '表单提示',
- name : 'formsuffix',
- editable: true,
- width : 80
- }],
- rownumbers : true,//添加左侧行号
- viewrecords : true,//是否在浏览导航栏显示记录总数
- rowNum : 10,//每页显示记录数
- rowList : [10,15,20,30,40,50 ],//用于改变显示行数的下拉列表框的元素数组。
- autowidth : true,
- height : 'auto',
- pager : "#jqGridPager1"
- });
- $('#jqGrid1').navGrid('#jqGridPager1',
- // the buttons to appear on the toolbar of the grid
- {
- edit : true,
- add : true,
- del : true,
- search : true,
- refresh : true,
- view : true,
- position : "left",
- cloneToTop : true
- },
- // options for the Edit Dialog
- {
- recreateForm : true,
- checkOnUpdate : true,
- checkOnSubmit : true,
- closeAfterEdit : true,
- onInitializeForm:function(formid) {
- },
- serializeEditData: function(postdata) {
- //myconsole.log(postdata);
- $.each(postdata,function (index, value) {
- //myconsole.log(index);
- if(index!="jqGrid_id" && index!="oper" && index!="keyid"){
- modifyJosnKey(postdata,index,"metaField."+index);
- }
- if(index=="keyid"){
- postdata["metaField."+index]=value
- }
- })
- //myconsole.log(postdata);
- return postdata;
- },
- errorTextFormat : function(data) {
- return 'Error: ' + data.responseText
- }
- },
- // options for the Add Dialog
- {
- closeAfterAdd : true,
- recreateForm : true,
- beforeSubmit: function(postdata, formid){
- $.each(postdata,function (index, value) {
- if(index!="jqGrid_id" && index!="oper"){
- modifyJosnKey(postdata,index,"metaField."+index);
- }
- })
- return[true,''];
- },
- errorTextFormat : function(data) {
- return 'Error: ' + data.responseText
- }
- },
- // options for the Delete Dailog
- {
- errorTextFormat : function(data) {
- return 'Error: ' + data.responseText
- }
- },{
- // search options 这里支持多条件查询
- multipleSearch: true,
- sopt:['eq','ne','cn','nc','lt','le','gt','ge'],
- afterSubmit: function(r, data) {
- var messageString = r.responseText;
- var mesObj = eval('(' + messageString + ')');
- return [mesObj.state, mesObj.message];
- }
- }
- );
- $("#make").click(function(){
- var mataTableIDs = $('#jqGrid').jqGrid('getGridParam','selarrrow');
- $.get("${ctx}/myconsole/metatable/make",{"mataTableIDs":mataTableIDs},function(data){
- alert(data);
- })
- })
- })
- </script>
- <title>我的桌面</title>
- </head>
- <body>
- <div class="page-container">
- <div style="text-align:right">
- <button id="make" class="btn btn-primary radius" type="button"><i class="Hui-iconfont"></i> 生成程序和库表</button>
- </div>
- <table id="jqGrid"></table>
- <div id="jqGridPager"></div>
- <div> </div>
- <table id="jqGrid1"></table>
- <div id="jqGridPager1"></div>
- </div>
- <footer class="footer mt-20">
- <div class="container">
- <p></p>
- </div>
- </footer>
- </body>
- </html>
|