封装好增删改查（自用）

最新推荐文章于 2022-03-24 17:34:24 发布

才华高于颜值

最新推荐文章于 2022-03-24 17:34:24 发布

阅读量546

点赞数

分类专栏： spring boot框架

本文链接：https://blog.csdn.net/qq_33416416/article/details/89329687

版权

spring boot框架专栏收录该内容

3 篇文章 0 订阅

订阅专栏

<!DOCTYPE html>
<html>

<head>

<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">


<title>H+ 后台主题UI框架 - jqGird</title>
<meta name="keywords" content="H+后台主题,后台bootstrap框架,会员中心主题,后台HTML,响应式后台">
<meta name="description"
	content="H+是一个完全响应式，基于Bootstrap3最新版本开发的扁平化主题，她采用了主流的左右两栏式布局，使用了Html5+CSS3等现代技术">

<link rel="shortcut icon" href="favicon.ico">
<link href="css/bootstrap.min.css?v=3.3.6" rel="stylesheet">
<link href="css/font-awesome.css?v=4.4.0" rel="stylesheet">

<!-- jqgrid-->
<link href="css/plugins/jqgrid/ui.jqgrid.css?0820" rel="stylesheet">
<link rel="stylesheet" href="js/plugins/layui/css/layui.css" media="all">
<link href="css/animate.css" rel="stylesheet">
<link href="css/style.css?v=4.1.0" rel="stylesheet">
<style type="text/css">
.differ {
	background-color: #e7fafe;
}
.search{
	margin-left: 20px;
}
</style>

<style>
/* Additional style to fix warning dialog position */
#alertmod_table_list_2 {
	top: 900px !important;
}
</style>

</head>

<body>

	<div class="jqGrid_wrapper">
		<table id="table_list_2"></table>
		<div id="pager_list_2"></div>
	</div>
	
	<!-- 全局js -->
	<script src="js/jquery.min.js?v=2.1.4"></script>
	<script src="js/bootstrap.min.js?v=3.3.6"></script>

	<!-- layer javascript -->
	<script src="../static/js/plugins/layui/layui.all.js"></script>
	<script src="../static/js/layerShow.js"></script>

	<!-- Peity -->
	<script src="js/plugins/peity/jquery.peity.min.js"></script>

	<!-- jqGrid -->
	<script src="js/plugins/jqgrid/i18n/grid.locale-cn.js?0820"></script>
	<script src="js/plugins/jqgrid/jquery.jqGrid.min.js?0820"></script>

	<!-- 自定义js -->
	<script src="../static/js/doCommon.js"></script>

	<!-- Page-Level Scripts -->
	<script>
		var upload = layui.upload;
		upload.render({
			elem : '#uploadFile',
			url : '../uploadFile',
			accept : 'file',
			multiple : true,
			done : function(res, index, upload) {
				//获取当前触发上传的元素，一般用于 elem 绑定 class 的情况，注意：此乃 layui 2.1.0 新增
				showMsg(res.message);
			}
		});

		var allIds = new Array();
		$(document).ready(function() {

			$.jgrid.defaults.styleUI = 'Bootstrap';

			show();

			jQuery("#table_list_2").navGrid('#pager_list_2', {
				edit : false,
				add : false,
				del : false,
				search : false,
				refresh : false
			});

			// Add responsive to jqGrid
			$(window).bind('resize', function() {
				var width = $('.jqGrid_wrapper').width();
				$('#table_list_2').setGridWidth(width);
			});

		});

		function show() {
			// Configuration for jqGrid Example 2
			var jqdata = [];
			var doCommon = new DoCommon();
			doCommon.transcode = 'PT0106';
			doCommon.excute(doCommon, function(data) {
				jqdata = data.jsonArray;
			});
			$("#table_list_2").jqGrid(
					{
						data : jqdata,
						datatype : "local",
						autowidth : true,
						shrinkToFit : true,
						height : 450,
						multiselect : true,//复选框 checkbox 
						//multiboxonly:true,//只能点击checkbox
						rowNum : 3,
						rowList : [ 3, 5, 10 ],
						colNames : [ '交易令', '名称', '操作类型', '是否简单操作', '数据库表',
								'主键列', '后台' ],
						colModel : [ {
							name : 'TRANSCODE',
							index : 'TRANSCODE',
							editable : true,
							width : 60,
							sorttype : "int",
							search : true
						}, {
							name : 'TRANSNAME',
							index : 'TRANSNAME',
							editable : true,
							width : 90,
						}, {
							name : 'OPERLX',
							index : 'OPERLX',
							editable : true,
							width : 60
						}, {
							name : 'ISSIMPLE',
							index : 'ISSIMPLE',
							editable : true, //默认false，是否可编辑 
							width : 60,
							sortable : false
						//是否可排序，默认为true 
						}, {
							name : 'TABLES',
							index : 'TABLES',
							editable : true, //默认false，是否可编辑 
							width : 60,
							sortable : false
						//是否可排序，默认为true 
						}, {
							name : 'KEYCOLS',
							index : 'KEYCOLS',
							editable : true, //默认false，是否可编辑 
							width : 60,
							sortable : false
						//是否可排序，默认为true 
						}, {
							name : 'ACTION',
							index : 'ACTION',
							editable : true, //默认false，是否可编辑 
							width : 60,
							sortable : false
						//是否可排序，默认为true 
						} ],
						toolbar:[true,"top"],
						pager : "#pager_list_2",
						viewrecords : true,
						caption : "交易令表",
						altRows : true,//单双行样式不同
						altclass : 'differ',//隔行变色样式
						add : true,
						edit : true,
						loadonce : false, //一次加载全部数据到客户端，由客户端进行排序。
						sortable : true,
						sortname : 'TRANSCODE', //设置默认的排序列
						sortorder : 'asc', //desc
						addtext : 'Add',
						edittext : 'Edit',
						onSelectAll : function(aRowids, status) { //全选事件

							if (status == true) {
								allIds = $("#table_list_2").jqGrid(
										'getGridParam', 'selarrrow');
							} else {
								allIds = $("#table_list_2").jqGrid(
										'getGridParam', 'selarrrow');
							}

						},
						onSelectRow : function(rowid, status) { //checkb事件

							if (status == true) {
								allIds = $("#table_list_2").jqGrid(
										'getGridParam', 'selarrrow');
							} else {
								allIds = $("#table_list_2").jqGrid(
										'getGridParam', 'selarrrow');
							}

						},

						hidegrid : false
					});
			
			var htmltar = ''+
			'<div>'+
			'<div style="width:30%;float: left;" class="layui-btn-group">'+
				'<button class="layui-btn" onclick="add();"><i class="layui-icon">&#xe654;</i>增加</button>'+
				'<button class="layui-btn" onclick="del();"><i class="layui-icon">&#xe640;</i>删除</button>'+
				'<button class="layui-btn" onclick="update();"><i class="layui-icon">&#xe642;</i>修改</button>'+
			'</div>'+
			'<div style="width:30%;float: left;">'+
			'<div class="layui-inline">'+
			'<input type="text" name="title" required lay-verify="required" placeholder="请输入标题" autocomplete="off" class="layui-input" >'+
			'</div>'+
			
			'<button class="layui-btn search"><i class="layui-icon">&#xe615;</i>搜索</button>'+
			
			'</div>'+
		'</div>';
			
			$("#t_table_list_2").append(htmltar);
		}
		
		function add() {
			var htmlcontent = ""+ 
			'<div class="ibox-content">'+
				 '<form class="form-horizontal" id = "addBean">'+
				 '<div class="form-group">'+
					 '<label class="col-sm-3 control-label">交易令：</label>'+
					 '<div class="col-sm-8">'+
						 '<input type="text" placeholder="交易令"  class="form-control" id="TRANSCODE">'+
					 '</div>'+
				 '</div>'+
				 '<div class="form-group">'+
				 	 '<label class="col-sm-3 control-label">名称：</label>'+
				 	 '<div class="col-sm-8">'+
					 	 '<input type="text" placeholder="名称"  class="form-control" id="TRANSNAME">'+
				 	 '</div>'+
			 	 '</div>'+
			 	'<div class="form-group">'+
				 '<label class="col-sm-3 control-label">操作类型：</label>'+
				 '<div class="col-sm-8">'+
					 '<select class="form-control m-b" id="OPERLX">'+
						 '<option value = "0" selected = "selected">查询</option>'+
						 '<option value = "1">新增</option>'+
						 '<option value = "2">修改</option>'+
						 '<option value = "3">删除</option>'+
					 '</select>'+
				 '</div>'+
			 '</div>'+
			 '<div class="form-group">'+
			 '<label class="col-sm-3 control-label">是否简单操作：</label>'+
			 '<div class="col-sm-8">'+
				 '<select class="form-control m-b" id="ISSIMPLE">'+
					 '<option value = "1" selected = "selected">是</option>'+
					 '<option value = "0">否</option>'+
				 '</select>'+
			 '</div>'+
		 '</div>'+
			 	 '<div class="form-group">'+
			 		 '<label class="col-sm-3 control-label">数据库表：</label>'+
			 		 '<div class="col-sm-8">'+
				 		 '<input type="text" placeholder="数据库表"  class="form-control" id="TABLES">'+
			 		 '</div>'+
		 		 '</div>'+
		 		 '<div class="form-group">'+
		 			 '<label class="col-sm-3 control-label">主键列：</label>'+
		 			 '<div class="col-sm-8">'+
			 		 	 '<input type="text" placeholder="主键列"  class="form-control" id="KEYCOLS">'+
		 			 '</div>'+
	 			 '</div>'+
	 			 '<div class="form-group">'+
	 				 '<label class="col-sm-3 control-label">后台：</label>'+
	 				 '<div class="col-sm-8">'+
		 			 	 '<input type="text" placeholder="后台"  class="form-control" id="ACTION">'+
	 				 '</div>'+
 				 '</div>'+
				 '</form>' +
			 '</div>';
			 contentLayerhtml(htmlcontent, function(index) {
				addCon(index);
				
			});
			
		}
		
		function addCon(index) {
			var TRANSCODE = $("#TRANSCODE").val();
			var TRANSNAME = $("#TRANSNAME").val();
			var OPERLX = $("#OPERLX").val();
			var ISSIMPLE = $("#ISSIMPLE").val();
			var TABLES = $("#TABLES").val();
			var KEYCOLS = $("#KEYCOLS").val();
			var ACTION = $("#ACTION").val();
			var consl = /^[0-9]*$/;
			if ($.trim(TRANSCODE) == "" || TRANSCODE == null || $.trim(TRANSNAME) == ""
					|| TRANSNAME == null || $.trim(OPERLX) == "" || OPERLX == null|| $.trim(ISSIMPLE) == "" || ISSIMPLE == null
					|| $.trim(TABLES) == "" || TABLES == null|| $.trim(KEYCOLS) == "" || KEYCOLS == null|| $.trim(ACTION) == "" || ACTION == null) {
				showMsg("请补全信息");
				return false;

			}  else {
				var info = [
						{
						"TRANSCODE":TRANSCODE,
						"TRANSNAME":TRANSNAME ,
						"OPERLX":OPERLX ,
						"ISSIMPLE":ISSIMPLE ,
						"TABLES":TABLES ,
						"KEYCOLS":KEYCOLS ,
						"ACTION":ACTION 
						}
					];
				var doCommon = new DoCommon();
				doCommon.info = info;
				//doCommon.tj = "name like '%d%'";
				doCommon.transcode = "PT0102";
				doCommon.excute(doCommon,function(data) {
					
					if (data.code==1) {
						showMsg("录入成功！");
						var jqdata = [];
						var doCommon = new DoCommon();
						doCommon.transcode = 'PT0106';
						doCommon.excute(doCommon, function(data) {
							jqdata = data.jsonArray;
							$("#table_list_2").jqGrid('clearGridData'); //清空表格
							$("#table_list_2").jqGrid('setGridParam', { // 重新加载数据
								data : jqdata,
								datatype : "local",
								page : 1
							}).trigger("reloadGrid");
						});
						
						layer.close(index);
					}else{
						showMsg("录入失败！");
					}
					
				});
				
				
			}
		} 
		
		function del() {
			if (allIds.length>0) {
				showConfirm('确定删除?', '删除', function() {
					var datas= jqGridRowData("#table_list_2");
					var TRANSCODE  = new Array();
					for (var i = 0; i < datas.length; i++) {
						
						var TRANSCODEJson = {
							"TRANSCODE":datas[i].TRANSCODE
						}
						TRANSCODE.push(TRANSCODEJson);
					}
					
					var doCommon = new DoCommon();
					doCommon.info = TRANSCODE;
					//doCommon.tj = "name like '%d%'";
					doCommon.transcode = "PT0104";
					doCommon.excute(doCommon,function(fdata) {
						if (fdata.code==1) {
							var jqdata = [];
							var doCommon = new DoCommon();
							doCommon.transcode = 'PT0106';
							doCommon.excute(doCommon, function(redata) {
								jqdata = redata.jsonArray;
								$("#table_list_2").jqGrid('clearGridData'); //清空表格
								$("#table_list_2").jqGrid('setGridParam', { // 重新加载数据
									data : jqdata,
									datatype : "local",
									page : 1
								}).trigger("reloadGrid");
							});
						}else{
							showMsg("删除失败！");
						}
						//layer.close(index);
						
					});
					
				});
			}else {
				layer.msg('请选择要删除的对象！');
			}
		}
		
		
		
		function update() {
			if (allIds.length==0) {
				showMsg("请选择！");
			}else if (allIds.length>1) {
				showMsg("只能选择一个！");
			}else{
				var datas= jqGridRowData("#table_list_2");
				var TRANSCODE  = new Array();
				for (var i = 0; i < datas.length; i++) {
					
					var TRANSCODEJson = {
						"TRANSCODE":datas[i].TRANSCODE
					}
					TRANSCODE.push(TRANSCODEJson);
				}
				var htmlcontent = ""+ 
				'<div class="ibox-content">'+
					 '<form class="form-horizontal" id = "addBean">'+
					 '<div class="form-group">'+
						 '<label class="col-sm-3 control-label">交易令：</label>'+
						 '<div class="col-sm-8">'+
							 '<input type="text" placeholder="交易令"  class="form-control" id="TRANSCODE">'+
						 '</div>'+
					 '</div>'+
					 '<div class="form-group">'+
					 	 '<label class="col-sm-3 control-label">名称：</label>'+
					 	 '<div class="col-sm-8">'+
						 	 '<input type="text" placeholder="名称"  class="form-control" id="TRANSNAME">'+
					 	 '</div>'+
				 	 '</div>'+
				 	'<div class="form-group">'+
					 '<label class="col-sm-3 control-label">操作类型：</label>'+
					 '<div class="col-sm-8">'+
						 '<select class="form-control m-b" id="OPERLX">'+
							 '<option value = "0" selected = "selected">查询</option>'+
							 '<option value = "1">新增</option>'+
							 '<option value = "2">修改</option>'+
							 '<option value = "3">删除</option>'+
						 '</select>'+
					 '</div>'+
				 '</div>'+
				 '<div class="form-group">'+
				 '<label class="col-sm-3 control-label">是否简单操作：</label>'+
				 '<div class="col-sm-8">'+
					 '<select class="form-control m-b" id="ISSIMPLE">'+
						 '<option value = "1" selected = "selected">是</option>'+
						 '<option value = "0">否</option>'+
					 '</select>'+
				 '</div>'+
			 '</div>'+
				 	 '<div class="form-group">'+
				 		 '<label class="col-sm-3 control-label">数据库表：</label>'+
				 		 '<div class="col-sm-8">'+
					 		 '<input type="text" placeholder="数据库表"  class="form-control" id="TABLES">'+
				 		 '</div>'+
			 		 '</div>'+
			 		 '<div class="form-group">'+
			 			 '<label class="col-sm-3 control-label">主键列：</label>'+
			 			 '<div class="col-sm-8">'+
				 		 	 '<input type="text" placeholder="主键列"  class="form-control" id="KEYCOLS">'+
			 			 '</div>'+
		 			 '</div>'+
		 			 '<div class="form-group">'+
		 				 '<label class="col-sm-3 control-label">后台：</label>'+
		 				 '<div class="col-sm-8">'+
			 			 	 '<input type="text" placeholder="后台"  class="form-control" id="ACTION">'+
		 				 '</div>'+
	 				 '</div>'+
					 '</form>' +
				 '</div>';
				 contentLayerhtml(htmlcontent, function(index) {
					 updateCon(index);
					
				});
			}
			
			
		}
		
		function updateCon(index) {
			var TRANSCODE = $("#TRANSCODE").val();
			var TRANSNAME = $("#TRANSNAME").val();
			var OPERLX = $("#OPERLX").val();
			var ISSIMPLE = $("#ISSIMPLE").val();
			var TABLES = $("#TABLES").val();
			var KEYCOLS = $("#KEYCOLS").val();
			var ACTION = $("#ACTION").val();
			var consl = /^[0-9]*$/;
			if ($.trim(TRANSCODE) == "" || TRANSCODE == null || $.trim(TRANSNAME) == ""
					|| TRANSNAME == null || $.trim(OPERLX) == "" || OPERLX == null|| $.trim(ISSIMPLE) == "" || ISSIMPLE == null
					|| $.trim(TABLES) == "" || TABLES == null|| $.trim(KEYCOLS) == "" || KEYCOLS == null|| $.trim(ACTION) == "" || ACTION == null) {
				showMsg("请补全信息");
				return false;

			}  else {
				var info = [
						{
						"TRANSCODE":TRANSCODE,
						"TRANSNAME":TRANSNAME ,
						"OPERLX":OPERLX ,
						"ISSIMPLE":ISSIMPLE ,
						"TABLES":TABLES ,
						"KEYCOLS":KEYCOLS ,
						"ACTION":ACTION 
						}
					];
				var doCommon = new DoCommon();
				doCommon.info = info;
				//doCommon.tj = "name like '%d%'";
				doCommon.transcode = "PT0102";
				doCommon.excute(doCommon,function(data) {
					
					if (data.code==1) {
						showMsg("录入成功！");
						var jqdata = [];
						var doCommon = new DoCommon();
						doCommon.transcode = 'PT0106';
						doCommon.excute(doCommon, function(data) {
							jqdata = data.jsonArray;
							$("#table_list_2").jqGrid('clearGridData'); //清空表格
							$("#table_list_2").jqGrid('setGridParam', { // 重新加载数据
								data : jqdata,
								datatype : "local",
								page : 1
							}).trigger("reloadGrid");
						});
						
						layer.close(index);
					}else{
						showMsg("录入失败！");
					}
					
				});
				
				
			}
		} 
	</script>

	<script type="text/javascript"
		src="http://tajs.qq.com/stats?sId=9051096" charset="UTF-8"></script>
	<!--统计代码，可删除-->

</body>

</html>

未整理代码

<!DOCTYPE html>
<html>

<head>

<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">


<title>H+ 后台主题UI框架 - 选项�? &amp; 面板</title>
<meta name="keywords"
	content="H+后台主题,后台bootstrap框架,会员中心主题,后台HTML,响应式后�?">
<meta name="description"
	content="H+是一个完全响应式，基于Bootstrap3�?新版本开发的扁平化主题，她采用了主流的左右两栏式布局，使用了Html5+CSS3等现代技�?">

<link rel="shortcut icon" href="favicon.ico">
<link href="css/bootstrap.min.css?v=3.3.6" rel="stylesheet">
<link href="css/font-awesome.css?v=4.4.0" rel="stylesheet">

<!-- jqgrid-->
<link href="css/plugins/jqgrid/ui.jqgrid.css?0820" rel="stylesheet">
<link rel="stylesheet" href="js/plugins/layui/css/layui.css" media="all">
<link href="css/animate.css" rel="stylesheet">
<link href="css/style.css?v=4.1.0" rel="stylesheet">
<style type="text/css">
#selectTub1 *{
	margin-bottom: 5px
}
#selectTub2 *{
	margin-bottom: 5px
}
 .col-sm-7 input{
display: inline !important;
width: 80% !important;
margin-right: 5px !important;
}
.col-sm-7 select{
display: inline !important;
width: 80% !important;
} 
 .col-sm-7 span{
color: red;
}
.differ {
	background-color: #e7fafe;
}
.search{
	margin-left: 20px;
}
.tank .layui-layer-btn .layui-layer-btn0{
	background:rgb(0, 150, 136);
	border:1px solid rgb(0, 150, 136);
	
}

.tank .layui-layer-title{ color:inherit; border: none;}
</style>

<style>
/* Additional style to fix warning dialog position */
#alertmod_table_list_2 {
	top: 900px !important;
}
</style>

</head>

<body>
	<!-- <div class="wrapper wrapper-content  animated fadeInRight" id="aaaa" style="width:100%"> -->
		<div class="wrapper wrapper-content  animated fadeInRight">
		<div class="tabs-container" id="ubub" style="width:100%;float:left;">
			<ul class="nav nav-tabs">
				<li class="active"><a data-toggle="tab" href="#tab-1"
					aria-expanded="true" id="lexing" class="grid_tab">类型</a></li>
				<li class=""><a data-toggle="tab" href="#tab-2"
					aria-expanded="false" id="xiangqing" class="grid_tab">类型详情</a></li>
			</ul>
			<div class="tab-content">
				<div id="tab-1" class="tab-pane active">
					<div id = "selectTub1"></div>
					<div class="jqgrid_box" id="role">
						<table class="table_list" id="table_list_2"></table>
						<div id="pager_list_2"></div>

					</div>
				</div>
				<div id="tab-2" class="tab-pane">
					<div id = "selectTub2"></div>
					<div class="jqgrid_box" id="role2">
						<table class="table_list" id="table_list_3"></table>
						<div id="pager_list_3"></div>

					</div>
				</div>
			</div>
		</div>
		</div>
	<!-- </div>-->


	<!-- 全局js -->
	<script src="../static/js/jquery.min.js?v=2.1.4"></script>
	<script src="../static/js/bootstrap.min.js?v=3.3.6"></script>

	<!-- layer javascript -->
	<script src="../static/js/plugins/layui/layui.all.js"></script>
	<script src="../static/js/layerShow.js"></script>

	<!-- Peity -->
	<script src="js/plugins/peity/jquery.peity.min.js"></script>
	<!-- jqGrid -->
	<script src="js/plugins/jqgrid/i18n/grid.locale-cn.js?0820"></script>
	<script src="js/plugins/jqgrid/jquery.jqGrid.min.js?0820"></script>

	<script type="text/javascript" src="../static/js/json2.js"></script>
	<!-- 自定义js -->
	<script src="../static/js/doCommon.js"></script>
	<script src="js/content.js?v=1.0.0"></script>

	<script type="text/javascript"
		src="http://tajs.qq.com/stats?sId=9051096" charset="UTF-8"></script>
	<!--统计代码，可删除-->
	<script>
		var allIds = new Array();
		var width;
		$(document).ready(function() {

			$.jgrid.defaults.styleUI = 'Bootstrap';

			show();
			show2();

			jQuery("#table_list_2").navGrid('#pager_list_2', {
				edit : false,
				add : false,
				del : false,
				search : false,
				refresh : false
			});

			jQuery("#table_list_3").navGrid('#pager_list_3', {
				edit : false,
				add : false,
				del : false,
				search : false,
				refresh : false
			});

			// Add responsive to jqGrid
			$(window).bind('resize', function() {
				width = $('.jqGrid_wrapper').width();
				console.log(width);
				$('#table_list_2').setGridWidth(width);
				$('#table_list_3').setGridWidth(width);
			});
		});

		$('.grid_tab').on('shown.bs.tab',function() {
					$($(this).attr('href')).find('.table_list').jqGrid('setGridWidth',$($(this).attr('href')).find('.jqgrid_box').width());
		});
		//代码类型
		function show() {
			// Configuration for jqGrid Example 2
			var jqdata = [];
			var doCommon = new DoCommon();
			doCommon.transcode = 'PT0307';
			doCommon.excute(doCommon, function(data) {
				jqdata = data.jsonArray;
			});
			$("#table_list_2").jqGrid(
					{
						data : jqdata,
						datatype : "local",
						autowidth : true,
						shrinkToFit : true,
						height : 450,
						multiselect : true,//复选框 checkbox 
						//multiboxonly:true,//只能点击checkbox
						rowNum : 15,
						rowList : [ 15, 20, 50 ],
						colNames : [ '代码类型', '代码名称', '代码级次','不可操作列' ],
						colModel : [ {
							name : 'DMLX',
							index : 'DMLX',
							editable : true,
							width : 3
						}, {
							name : 'DMLXMC',
							index : 'DMLXMC',
							editable : true,
							width : 5
						}, {
							name : 'DMJC',
							index : 'DMJC',
							editable : true,
							width : 3
						},{
							name : 'a',
							index : 'a',
							editable : true,
							width : 15
						}],						
						pager : "#pager_list_2",
						viewrecords : true,
						caption : "代码类型",
						altRows : true,//单双行样式不同
						altclass : 'differ',//隔行变色样式
						add : true,
						edit : true,
						loadonce : false, //一次加载全部数据到客户端，由客户端进行排序。
						sortable : true,
						sortname : 'TRANSCODE', //设置默认的排序列
						sortorder : 'asc', //desc
						addtext : 'Add',
						edittext : 'Edit',
						beforeSelectRow: function (rowid, e) {
						    var $myGrid = $(this),
						        i = $.jgrid.getCellIndex($(e.target).closest('td')[0]),
						        cm = $myGrid.jqGrid('getGridParam', 'colModel');
						    return (cm[i].name === 'cb');
						},
						onSelectAll : function(aRowids, status) { //全选事件

							if (status == true) {
								allIds = $("#table_list_2").jqGrid(
										'getGridParam', 'selarrrow');
							} else {
								allIds = $("#table_list_2").jqGrid(
										'getGridParam', 'selarrrow');
							}

						},
						onSelectRow : function(rowid, status) { //checkb事件

							if (status == true) {
								allIds = $("#table_list_2").jqGrid(
										'getGridParam', 'selarrrow');
							} else {
								allIds = $("#table_list_2").jqGrid(
										'getGridParam', 'selarrrow');
							}

						},

						hidegrid : false
					});

			var htmltar = ''
					+ '<div>'
					+ '<div style="width:5.3%;float: right;" class="layui-btn-group">'
					+ '<button class="layui-btn search" onclick="search();"><i class="layui-icon">&#xe615;</i>搜索</button>'		
					+ '</div>'
					+ '<div style="width:16%;height:24px;float:right; margin-right:12px;">'					
					+ '<select class="form-control m-b" id="SelectDMLX" style="height:38px";>';					
					for (var i = 0; i < jqdata.length; i++) {
						if (i==0) {
							htmltar += '<option value = '+""+'>'
							+ "" + '</option>'
							+'<option value = '+jqdata[i].DMLXMC+'>'
							+ jqdata[i].DMLXMC + '</option>';
						}else {
							htmltar += '<option value = '+jqdata[i].DMLXMC+'>'
							+ jqdata[i].DMLXMC + '</option>';
						}
					}
					htmltar += '</select>'
					+ '</div>'					
					+ '<div style="width:35%;float: left;" class="layui-btn-group">'					
					+ '<button class="layui-btn" onclick="add();" id="bottun"><i class="layui-icon">&#xe654;</i>增加</button>'
					+ '<button class="layui-btn" onclick="del();"><i class="layui-icon">&#xe640;</i>删除</button>'
					+ '<button class="layui-btn" onclick="update();"><i class="layui-icon">&#xe642;</i>修改</button>'
					+ '</div>'					
					+'</div>'; 

				$("#selectTub1").append(htmltar);

		}
		
/* 		//切换按钮刷新页面
		$("#xiangqing").click(function(){
			 var jqdata = [];
			var doCommon = new DoCommon();
			doCommon.transcode = 'PT0309';
			doCommon.excute(doCommon, function(data) {
				jqdata = data.jsonArray;
				$("#table_list_3").jqGrid('clearGridData'); //清空表格
				$("#table_list_3").jqGrid('setGridParam', { // 重新加载数据
					data : jqdata,
					datatype : "local",
					page : 1
				}).trigger("reloadGrid");
			}); 
		});
		
		$("#xiangqing").click(function(){
			 var jqdata = [];
			var doCommon = new DoCommon();
			doCommon.transcode = 'PT0307';
			doCommon.excute(doCommon, function(data) {
				jqdata = data.jsonArray;
				$("#table_list_2").jqGrid('clearGridData'); //清空表格
				$("#table_list_2").jqGrid('setGridParam', { // 重新加载数据
					data : jqdata,
					datatype : "local",
					page : 1
				}).trigger("reloadGrid");
			}); 
		});
		 */
		function shows1() {
			 var jqdata = [];
				var doCommon = new DoCommon();
				doCommon.transcode = 'PT0307';
				doCommon.excute(doCommon, function(data) {
					jqdata = data.jsonArray;
					$("#table_list_2").jqGrid('clearGridData'); //清空表格
					$("#table_list_2").jqGrid('setGridParam', { // 重新加载数据
						data : jqdata,
						datatype : "local",
						page : 1
					}).trigger("reloadGrid");
				}); 
		}
		 
			function shows2() {
				 var jqdata = [];
					var doCommon = new DoCommon();
					doCommon.transcode = 'PT0309';
					doCommon.excute(doCommon, function(data) {
						jqdata = data.jsonArray;
						$("#table_list_3").jqGrid('clearGridData'); //清空表格
						$("#table_list_3").jqGrid('setGridParam', { // 重新加载数据
							data : jqdata,
							datatype : "local",
							page : 1
						}).trigger("reloadGrid");
					}); 
			}
			 
		 
		//代码类型子类
		function show2() {
			// Configuration for jqGrid Example 2

			//var jqdata;
/* 			var doCommon = new DoCommon();
			doCommon.transcode = 'PT0309';
			doCommon.excute(doCommon, function(data) {
				jqdata = data.jsonArray;
			}); */
			var jqdata = [];
			$.ajax({
				url : "../delxDel/dmlxZselect",			
				type : "post",
				dataType : "json",
				async: false,
				success : function(data) {				
					jqdata = data.lists;
					console.log(jqdata)
				},
				error : function(msg) {
					alert("ajax连接异常：" + msg);
				}
			});
			
			
			$("#table_list_3").jqGrid(
	
					{
						data : jqdata,
						datatype : "local",
						autowidth : true,
						shrinkToFit : true,
						height : 450,
						multiselect : true,//复选框 checkbox 
						//multiboxonly:true,//只能点击checkbox
						rowNum : 15,
						rowList : [ 15, 20, 50 ],
						colNames : [ '代码年份', '代码类型', '代码键名', '代码键值','不可操作列'],
						colModel : [ {
							name : 'YSNF',
							index : 'YSNF',
							editable : true,
							width : 10
						}, {
							name : 'DMLX',
							index : 'DMLX',
							editable : true,
							width : 15
						}, {
							name : 'KEYNAME',
							index : 'KEYNAME',
							editable : true,
							width : 10
						}, {
							name : 'KEYVALUE',
							index : 'KEYVALUE',
							editable : true,
							width : 15
						},{
							name : 'b',
							index : 'b',
							editable : true,
							width : 60
						}],
						pager : "#pager_list_3",
						viewrecords : true,
						caption : "代码类型子类",
						altRows : true,//单双行样式不同
						altclass : 'differ',//隔行变色样式
						add : true,
						edit : true,
						loadonce : false, //一次加载全部数据到客户端，由客户端进行排序。
						sortable : true,
						sortname : 'TRANSCODE', //设置默认的排序列
						sortorder : 'asc', //desc
						addtext : 'Add',
						edittext : 'Edit',
						beforeSelectRow: function (rowid, e) {
						    var $myGrid = $(this),
						        i = $.jgrid.getCellIndex($(e.target).closest('td')[0]),
						        cm = $myGrid.jqGrid('getGridParam', 'colModel');
						    return (cm[i].name === 'cb');
						},
						onSelectAll : function(aRowids, status) { //全选事件

							if (status == true) {
								allIds = $("#table_list_3").jqGrid(
										'getGridParam', 'selarrrow');
							} else {
								allIds = $("#table_list_3").jqGrid(
										'getGridParam', 'selarrrow');
							}

						},
						onSelectRow : function(rowid, status) { //checkb事件

							if (status == true) {
								allIds = $("#table_list_3").jqGrid(
										'getGridParam', 'selarrrow');
							} else {
								allIds = $("#table_list_3").jqGrid(
										'getGridParam', 'selarrrow');
							}

						},

						hidegrid : false
					});
			//取对象数组唯一值
			var objs = {};
			 
			jqdata = jqdata.reduce((cur, next) => {
			    objs[next.DMLX] ? "" : objs[next.DMLX] = true && cur.push(next);
			    return cur;
			}, []) //设置cur默认类型为数组，并且初始值为空的数组
			console.log(jqdata);

			var htmltar = ''
				+ '<div>'
				+ '<div style="width:5.3%;float:right;" class="layui-btn-group">'
				+'<button class="layui-btn search" onclick="search2();"><i class="layui-icon">&#xe615;</i>搜索</button>'		
				+ '</div>'
				+ '<div style="width:16%;height:24px;float: right;margin-right:12px;">'					
				+ '<select class="form-control m-b" id="SelectDMLX2" style="height:38px">';				
				for (var i = 0; i < jqdata.length; i++) {
					if (i==0) {
						htmltar += '<option value = '+""+'>'
						+ "" + '</option>'
						+'<option value = '+jqdata[i].DMLX+'>'
						+ jqdata[i].DMLX + '</option>';
					}else {
						htmltar += '<option value = '+jqdata[i].DMLX+'>'
						+ jqdata[i].DMLX + '</option>';
					}
				}
				htmltar += '</select>'												
				+ '</div>'
				+ '<div style="width:35%;float: left;" class="layui-btn-group">'
				+ '<button class="layui-btn" onclick="add2();" id="bottun"><i class="layui-icon">&#xe654;</i>增加</button>'
				+ '<button class="layui-btn" onclick="del2();"><i class="layui-icon">&#xe640;</i>删除</button>'
				+ '<button class="layui-btn" onclick="update2();"><i class="layui-icon">&#xe642;</i>修改</button>'
				+ '</div>'					
				+'</div>'; 
			$("#selectTub2").append(htmltar);

		}
		//新增
		function add() {
			var titlesBt = "新增";
			var htmlcontent = ""
					+ '<div class="ibox-content">'
					+ '<form class="form-horizontal" id = "addBean">'
					+ '<div class="form-group">'
					+ '<label class="col-sm-3 control-label">代码类型：</label>'
					+ '<div class="col-sm-7">'
					+ '<input type="text" placeholder=""  class="form-control" id="DMLX">'
					+ '<span id="jylmsg" style="color:#F00">(必填)</span>'
					+ '</div>'
					+ '</div>'
					+ '<div class="form-group">'
					+ '<label class="col-sm-3 control-label">代码名称：</label>'
					+ '<div class="col-sm-7">'
					+ '<input type="text" placeholder=""  class="form-control" id="DMLXMC">'
					+ '<span id="jylmsg" style="color:#F00">(必填)</span>'
					+ '</div>'
					+ '</div>'
					+ '<div class="form-group">'
					+ '<label class="col-sm-3 control-label">代码级次：</label>'
					+ '<div class="col-sm-7">'
					+ '<input type="text" placeholder=""  class="form-control" id="DMJC"  onblur="DMJCyanZheng()">'+'<span id="text1" style="color:black"></span>'
					+ '<span id="jylmsg" style="color:#F00">(必填)</span>'
					+ '</div>' + '</div>' + '</form>' + '</div>';
			contentLayerhtmlTitile(titlesBt, htmlcontent, function(index) {
				addCon(index);

			});

		}
		//正则表达式验证是否是数字
		function DMJCyanZheng() {
			var ops= new RegExp("^[0-9]*$");
			var DMJC = $("#DMJC").val();
			var dm = $("#DMJC");
			if (ops.test(DMJC)==true) {
				$("#text1").text("");
			} else {
				$("#DMJC").val("");
				$(dm).attr('placeholder','请您输入整数数字');
				/* dm.focus(function(){
					$(this).attr('placeholder','请您输入整数数字')
				}) */
			}
		}
		

		function addCon(index) {
			var DMLX = $("#DMLX").val();
			var DMLXMC = $("#DMLXMC").val();
			var DMJC = $("#DMJC").val();		
			var consl = /^[0-9]*$/;
			if ($.trim(DMLX) == "" || DMLX == null) {
				showMsg("代码类型为必填项");
				return false;

			}else if ($.trim(DMLXMC) == ""
				|| DMLXMC == null ) {
				showMsg("代码名称为必填项");
				return false;
			}else if ($.trim(DMJC) == "" || DMJC == null) {
				showMsg("代码级次为必填项");
				return false;
			}
			else {
				var info = [ {
					"DMLX" : DMLX,
					"DMLXMC" : DMLXMC,
					"DMJC" : DMJC
				} ];
				var doCommon = new DoCommon();
				doCommon.info = info;
				//doCommon.tj = "name like '%d%'";
				doCommon.transcode = "PT0306";
				doCommon.excute(doCommon, function(data) {

					if (data.code == 1) {
						showMsg("录入成功！");
						var jqdata = [];
						var doCommon = new DoCommon();
						doCommon.transcode = 'PT0307';
						doCommon.excute(doCommon, function(data) {
							jqdata = data.jsonArray;
							$("#table_list_2").jqGrid('clearGridData'); //清空表格
							$("#table_list_2").jqGrid('setGridParam', { // 重新加载数据
								data : jqdata,
								datatype : "local",
								page : 1
							}).trigger("reloadGrid");
						});

						layer.close(index);
					} else {
						showMsg("录入失败！请检查代码类型是否重复");
					}

				});

			}
		}

		function del() {
			if (allIds.length > 0) {
				showConfirm('确定删除?', '删除', function() {
					var datas = jqGridRowData("#table_list_2");
					var RID = new Array();
					var delId;
					for (var i = 0; i < datas.length; i++) {
						delId = datas[i].DMLX;
						var TRANSCODEJson = {
							"RID" : datas[i].DMLX
						}
						RID.push(TRANSCODEJson);
					}
					/* var doCommon = new DoCommon();
					doCommon.info = RID;
					//doCommon.tj = "name like '%d%'";
					doCommon.transcode = "PT0107"; */
					var arrJson = JSON.stringify(RID);
					arrJson = encodeURIComponent(arrJson);
					$.ajax({
						url : "../delxDel/dmlxDele?arrJson=" + arrJson,
						type : "post",
						dataType : "json",
						success : function(data) {
							if (data.result == "true") {
								showMsg("删除成功！");
								var doCommon = new DoCommon();
								doCommon.transcode = 'PT0307';
								var jqdata = [];
								doCommon.excute(doCommon, function(redata) {						
									jqdata = redata.jsonArray;						
								});
								layer.msg("删除成功",{icon: 1});
								$("#table_list_2").jqGrid('clearGridData'); //清空表格
								$("#table_list_2").jqGrid('setGridParam', { // 重新加载数据
									data : jqdata,
									datatype : "local",
									page : 1
								}).trigger("reloadGrid");					
								allIds = [];
								
								var jqdata2 = [];
								var doCommon = new DoCommon();
								doCommon.transcode = 'PT0309';
								doCommon.excute(doCommon, function(fdata) {
									jqdata2 = fdata.jsonArray;
									$("#table_list_3").jqGrid('clearGridData'); //清空表格
									$("#table_list_3").jqGrid('setGridParam', { // 重新加载数据
										data : jqdata2,
										datatype : "local",
										page : 1
									}).trigger("reloadGrid");
								});
								allIds = [];
							} else {
								showMsg("删除失败！");
							}
							//layer.close(index);
						},
						error : function(msg) {
							alert("ajax连接异常：" + msg);
						}
					});

					
					/* var doCommon = new DoCommon();
					doCommon.transcode = 'PT0307';
					var jqdata = [];
					doCommon.excute(doCommon, function(redata) {						
						jqdata = redata.jsonArray;						
					});
					layer.msg("删除成功",{icon: 1});
					$("#table_list_2").jqGrid('clearGridData'); //清空表格
					$("#table_list_2").jqGrid('setGridParam', { // 重新加载数据
						data : jqdata,
						datatype : "local",
						page : 1
					}).trigger("reloadGrid");					
					allIds = []; */
					
/* 					var jqdata2 = [];
					var doCommon = new DoCommon();
					doCommon.transcode = 'PT0309';
					doCommon.excute(doCommon, function(fdata) {
						jqdata2 = fdata.jsonArray;
						$("#table_list_3").jqGrid('clearGridData'); //清空表格
						$("#table_list_3").jqGrid('setGridParam', { // 重新加载数据
							data : jqdata2,
							datatype : "local",
							page : 1
						}).trigger("reloadGrid");
					});
					allIds = []; */
				});
			} else {
				layer.msg('请选择要删除的对象！');
			}
		}

		function update() {
			if (allIds.length == 0) {
				showMsg("请选择！");
			} else if (allIds.length > 1) {
				showMsg("只能选择一个！");
			} else {
				var datas = jqGridRowData("#table_list_2");
				var id = datas[0].DMLX;
				var list;
				var doCommon = new DoCommon();
				doCommon.tj = "DMLX = '" + id + "'";
				doCommon.transcode = 'PT0307';
				doCommon.excute(doCommon, function(data) {
					list = data.list;
				});
				var titlesBt = "修改";
				var htmlcontent = ""
						+ '<div class="ibox-content">'
						+ '<form class="form-horizontal" id = "addBean">'
						+ '<div class="form-group">'
						+ '<label class="col-sm-3 control-label">代码类型：</label>'
						+ '<div class="col-sm-8">'
						+ '<input type="text" placeholder="代码类型"  class="form-control" id="TRANSCODE" readonly="readonly" value="'+list[0].DMLX+'">'
						+ '</div>'
						+ '</div>'
						+ '<div class="form-group">'
						+ '<label class="col-sm-3 control-label">代码名称：</label>'
						+ '<div class="col-sm-8">'
						+ '<input type="text" placeholder="代码名称"  class="form-control" id="TRANSNAME" value="'+list[0].DMLXMC+'">'
						+ '</div>'
						+ '</div>'
						+ '<div class="form-group">'
						+ '<label class="col-sm-3 control-label">代码级次：</label>'
						+ '<div class="col-sm-8">'
						+ '<input type="text" placeholder="代码级次"  class="form-control" id="TABLES" readonly="readonly" value="'+list[0].DMJC+'">'
						+ '</div>' + '</div>' + '</form>' + '</div>';
				contentLayerhtmlTitile(titlesBt, htmlcontent, function(index) {
					updateCon(index, id);

				});
			}

		}

		function updateCon(index, id) {
			var TRANSCODE = $("#TRANSCODE").val();
			var TRANSNAME = $("#TRANSNAME").val();
			var TABLES = $("#TABLES").val();
			var consl = /^[0-9]*$/;
			if ($.trim(TRANSCODE) == "" || TRANSCODE == null
					|| $.trim(TRANSNAME) == "" || TRANSNAME == null
					|| $.trim(TABLES) == "" || TABLES == null) {
				showMsg("请补全信息");
				return false;

			} else {
				var info = [ {
					"DMLX" : TRANSCODE,
					"DMLXMC" : TRANSNAME,
					"DMJC" : TABLES
				} ];
				var doCommon = new DoCommon();
				doCommon.info = info;
				doCommon.tj = "DMLX='" + TRANSCODE + "'";
				doCommon.transcode = "PT0308";
				doCommon.excute(doCommon, function(data) {

					if (data.code == 1) {
						showMsg("修改成功！");
						var jqdata = [];
						var doCommon = new DoCommon();
						doCommon.transcode = 'PT0307';
						doCommon.excute(doCommon, function(data) {
							jqdata = data.jsonArray;
							$("#table_list_2").jqGrid('clearGridData'); //清空表格
							$("#table_list_2").jqGrid('setGridParam', { // 重新加载数据
								data : jqdata,
								datatype : "local",
								page : 1
							}).trigger("reloadGrid");
						});
						allIds = [];
						layer.close(index);
					} else {
						showMsg("修改失败！");
					}

				});

			}
		}
		function search() {
			var search = $("#SelectDMLX").val();
			if ($.trim(search) == "" || search == null) {
				var jqdata = [];
				var doCommon = new DoCommon();
				doCommon.transcode = 'PT0307';
				doCommon.excute(doCommon, function(data) {
					jqdata = data.jsonArray;
					$("#table_list_2").jqGrid('clearGridData'); //清空表格
					$("#table_list_2").jqGrid('setGridParam', { // 重新加载数据
						data : jqdata,
						datatype : "local",
						page : 1
					}).trigger("reloadGrid");
				});	
			} else {
				var jqdata = [];
				var doCommon = new DoCommon();
				doCommon.transcode = 'PT0307';
				doCommon.tj = "DMLXMC = '" + search + "'";
				doCommon.excute(doCommon, function(data) {
					jqdata = data.jsonArray;
					$("#table_list_2").jqGrid('clearGridData'); //清空表格
					$("#table_list_2").jqGrid('setGridParam', { // 重新加载数据
						data : jqdata,
						datatype : "local",
						page : 1
					}).trigger("reloadGrid");
				});	
			}
			
		}

		//表单2&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
		function add2() {
			var titlesBt = "新增";
			var list;
			var doCommon = new DoCommon();
			doCommon.transcode = 'PT0307';
			doCommon.excute(doCommon, function(data) {
				list = data.list;
			});
			var htmlcontent = ""
				+ '<div class="ibox-content">'
				+ '<form class="form-horizontal" id = "addBean">'
				+ '<div class="form-group">'
				+ '<label class="col-sm-3 control-label">代码年份：</label>'
				+ '<div class="col-sm-7">'
				+ '<input type="text" placeholder=""  class="form-control" id="YSNF" onblur="DMNFyanZheng()">'+'<span id="text" style="color:black"></span>'
				+ '<span id="jylmsg" style="color:#F00">(必填)</span>'
				+ '</div>' + '</div>' + '<div class="form-group">'
				+ '<label class="col-sm-3 control-label">代码类型：</label>'
				+ '<div class="col-sm-7">'
				+ '<select class="form-control m-b" id="DMLX">';
		for (var i = 0; i < list.length; i++) {
			htmlcontent += '<option value = '+list[i].DMLXMC+'>'
					+ list[i].DMLXMC + '</option>';
		}
		htmlcontent += '</select>'
				+ '</div>'
				+ '</div>'
				+ '<div class="form-group">'
				+ '<label class="col-sm-3 control-label">代码键名：</label>'
				+ '<div class="col-sm-7">'
				+ '<input type="text" placeholder=""  class="form-control" id="KEYNAME">'
				+ '<span id="jylmsg" style="color:#F00">(必填)</span>'
				+ '</div>'
				+ '</div>'
				+

				'<div class="form-group">'
				+ '<label class="col-sm-3 control-label">代码键值：</label>'
				+ '<div class="col-sm-7">'
				+ '<input type="text" placeholder=""  class="form-control" id="KEYVALUE">'
				+ '<span id="jylmsg" style="color:#F00">(必填)</span>'
				+ '</div>' + '</div>' + '</form>' + '</div>';
				contentLayerhtmlTitile(titlesBt,htmlcontent, function(index) {
				addCon2(index);

			});
		}
		
		//正则验证数字
		function DMNFyanZheng(){
			var ops= /^\d{4}$/;
			var DMJC = $("#YSNF").val();
			var dm = $("#YSNF");
			console.log(ops.test(DMJC));
			if (ops.test(DMJC)==true) {
				$("#text").text("");	
			} else {			
				$("#YSNF").val("");
				$(dm).attr('placeholder','请您输入4位整数数字');
				//$("#text").text("*请您输入4位整数数字,");
				//showMsg("请您输入4位整数数字");
			}	
		} 
		
		function addCon2(index) {
			var listfid;
			var YSNF = $("#YSNF").val();
			//取得父类类型
			var DMLX = $("#DMLX").val();
			var KEYNAME = $("#KEYNAME").val();
			var KEYVALUE = $("#KEYVALUE").val();
			var consl = /^[0-9]*$/;
			if ($.trim(YSNF) == "" || YSNF == null 
					) {
				showMsg("年份为必填项");
				return false;
			}else if ($.trim(SelectDMLX2) == ""
				|| SelectDMLX2 == null ) {
				showMsg("类型为必填项");
				return false;
				
			}else if ($.trim(KEYNAME) == "" || KEYNAME == null) {
				showMsg("键名为必填项");
				return false;
				
			}else if ($.trim(KEYVALUE) == "" || KEYVALUE == null) {
				showMsg("键值为必填项");
				return false;
				
			} 
			
			else {
				var doCommonfid = new DoCommon();
				doCommonfid.transcode = 'PT0307';
				doCommonfid.tj = "DMLXMC = '" + DMLX + "'";
				doCommonfid.excute(doCommonfid, function(data) {
					listfid = data.list;
				});

				var listdmlx;
				for (var i = 0; i < listfid.length; i++) {
					listdmlx = listfid[i].DMLX;
				}
				var info = [ {
					"YSNF" : YSNF,
					"DMLX" : listdmlx,
					"KEYNAME" : KEYNAME,
					"KEYVALUE" : KEYVALUE
				} ];
				var doCommon = new DoCommon();
				doCommon.info = info;
				//doCommon.tj = "name like '%d%'";
				doCommon.transcode = "PT0312";
				doCommon.excute(doCommon, function(data) {
				 	if (data.code == 1) {
						showMsg("录入成功！");
						layer.close(index);
					} else {
						showMsg("录入失败！请检查代码年份是否重复");
					}
					var jqdata = [];
					$.ajax({
						url : "../delxDel/dmlxZselect",			
						type : "post",
						dataType : "json",
						async: false,
						success : function(data) {				
							jqdata = data.lists;
							console.log(jqdata)
							$("#table_list_3").jqGrid('clearGridData'); //清空表格
							$("#table_list_3").jqGrid('setGridParam', { // 重新加载数据
								data : jqdata,
								datatype : "local",
								page : 1
							}).trigger("reloadGrid");
						},
						error : function(msg) {
							alert("ajax连接异常：" + msg);
						}
					});
				});

			}
		}

		function del2() {
			if (allIds.length > 0) {
				showConfirm('确定删除?', '删除', function() {
					var datas = jqGridRowData("#table_list_3");
					var YSNF = new Array();
					for (var i = 0; i < datas.length; i++) {

						var TRANSCODEJson = {
							"YSNF" : datas[i].YSNF
						}
						YSNF.push(TRANSCODEJson);
					}
					var doCommon = new DoCommon();
					doCommon.info = YSNF;
					//doCommon.tj = "name like '%d%'";
					doCommon.transcode = "PT0311";
					doCommon.excute(doCommon, function(fdata) {
						if (fdata.code == 1) {
							var jqdata = [];
							var doCommon = new DoCommon();
							doCommon.transcode = 'PT0309';
							doCommon.excute(doCommon, function(redata) {
								jqdata = redata.jsonArray;
								$("#table_list_3").jqGrid('clearGridData'); //清空表格
								$("#table_list_3").jqGrid('setGridParam', { // 重新加载数据
									data : jqdata,
									datatype : "local",
									page : 1
								}).trigger("reloadGrid");
							});
							showMsg("删除成功！");
							allIds = [];
						} else {
							showMsg("删除失败！");
						}
						//layer.close(index);

					});

				});
			} else {
				layer.msg('请选择要删除的对象！');
			}
		}

		function update2() {
			if (allIds.length == 0) {
				showMsg("请选择！");
			} else if (allIds.length > 1) {
				showMsg("只能选择一个！");
			} else {
				var datas = jqGridRowData("#table_list_3");
				var id = datas[0].YSNF;
				var list;
				var doCommon = new DoCommon();
				doCommon.tj = "YSNF = '" + id + "'";
				doCommon.transcode = 'PT0309';
				doCommon.excute(doCommon, function(data) {
					list = data.list;
				});
				var titlesBt = "修改";
				var htmlcontent = ""
						+ '<div class="ibox-content">'
						+ '<form class="form-horizontal" id = "addBean">'
						+ '<div class="form-group">'
						+ '<label class="col-sm-3 control-label">代码年份：</label>'
						+ '<div class="col-sm-8">'
						+ '<input type="text" placeholder="代码年份"  class="form-control" id="TRANSCODE" readonly="readonly" value="'+list[0].YSNF+'">'
						+ '</div>'
						+ '</div>'
						+ '<div class="form-group">'
						+ '<label class="col-sm-3 control-label">代码类型：</label>'
						+ '<div class="col-sm-8">'
						+ '<input type="text" placeholder="代码类型"  class="form-control" id="TRANSNAME" readonly="readonly"  value="'+list[0].DMLX+'">'
						+ '</div>'
						+ '</div>'
						+

						'<div class="form-group">'
						+ '<label class="col-sm-3 control-label">代码键名：</label>'
						+ '<div class="col-sm-8">'
						+ '<input type="text" placeholder="代码键名"  class="form-control" id="TABLES" value="'+list[0].KEYNAME+'">'
						+ '</div>'
						+ '</div>'
						+

						'<div class="form-group">'
						+ '<label class="col-sm-3 control-label">代码键值：</label>'
						+ '<div class="col-sm-8">'
						+ '<input type="text" placeholder="代码键值"  class="form-control" id="KEYVALUE"  value="'+list[0].KEYVALUE+'">'
						+ '</div>' + '</div>' +

						'</form>' + '</div>';
				contentLayerhtmlTitile(titlesBt, htmlcontent, function(index) {
					updateCon2(index);

				});
			}

		}

		function updateCon2(index) {
			var TRANSCODE = $("#TRANSCODE").val();
			var TRANSNAME = $("#TRANSNAME").val();
			var TABLES = $("#TABLES").val();
			var KEYVALUE = $("#KEYVALUE").val();
			var consl = /^[0-9]*$/;
			if ($.trim(TRANSCODE) == "" || TRANSCODE == null
					|| $.trim(TRANSNAME) == "" || TRANSNAME == null
					|| $.trim(TABLES) == "" || TABLES == null
					|| $.trim(KEYVALUE) == "" || KEYVALUE == null) {
				showMsg("请补全信息");
				return false;

			} else {
				var info = [ {
					"YSNF" : TRANSCODE,
					"DMLX" : TRANSNAME,
					"KEYNAME" : TABLES,
					"KEYVALUE" : KEYVALUE
				} ];
				var doCommon = new DoCommon();
				doCommon.info = info;
				doCommon.tj = "YSNF='" + TRANSCODE + "'";
				doCommon.transcode = "PT0310";
				doCommon.excute(doCommon, function(data) {
					if (data.code == 1) {
						showMsg("修改成功！");
						allIds = [];
						layer.close(index);
					} else {
						showMsg("修改失败！");
					}
					var jqdata = [];
					$.ajax({
						url : "../delxDel/dmlxZselect",			
						type : "post",
						dataType : "json",
						async: false,
						success : function(data) {				
							jqdata = data.lists;
							console.log(jqdata)
							$("#table_list_3").jqGrid('clearGridData'); //清空表格
							$("#table_list_3").jqGrid('setGridParam', { // 重新加载数据
								data : jqdata,
								datatype : "local",
								page : 1
							}).trigger("reloadGrid");
						},
						error : function(msg) {
							alert("ajax连接异常：" + msg);
						}
					});	
				});

			}
		}
		function search2() {
			var search = $("#SelectDMLX2").val();
			if ($.trim(search) == "" || search == null) {
				
				var jqdata = [];
				$.ajax({
					url : "../delxDel/dmlxZselect",			
					type : "post",
					dataType : "json",
					async: false,
					success : function(data) {				
						jqdata = data.lists;
						console.log(jqdata)
						$("#table_list_3").jqGrid('clearGridData'); //清空表格
						$("#table_list_3").jqGrid('setGridParam', { // 重新加载数据
							data : jqdata,
							datatype : "local",
							page : 1
						}).trigger("reloadGrid");
					},
					error : function(msg) {
						alert("ajax连接异常：" + msg);
					}
				});
		/* 		var jqdata = [];
				var doCommon = new DoCommon();
				doCommon.transcode = 'PT0309';
				doCommon.excute(doCommon, function(data) {
					jqdata = data.jsonArray;
					$("#table_list_3").jqGrid('clearGridData'); //清空表格
					$("#table_list_3").jqGrid('setGridParam', { // 重新加载数据
						data : jqdata,
						datatype : "local",
						page : 1
					}).trigger("reloadGrid");
				});	 */
			} else {
				var jqdata = [];
				$.ajax({
					url : "../delxDel/searchZselect?search="+search,			
					type : "post",
					dataType : "json",
					async: false,
					success : function(data) {				
						jqdata = data.lists;
						console.log(jqdata)
						$("#table_list_3").jqGrid('clearGridData'); //清空表格
						$("#table_list_3").jqGrid('setGridParam', { // 重新加载数据
							data : jqdata,
							datatype : "local",
							page : 1
						}).trigger("reloadGrid");
					},
					error : function(msg) {
						alert("ajax连接异常：" + msg);
					}
				});
				/* var jqdata = [];
				var doCommon = new DoCommon();
				doCommon.transcode = 'PT0309';
				//doCommon.tj = "DMLXMC = '" + search + "'";
				doCommon.excute(doCommon, function(data) {
					jqdata = data.jsonArray;
					$("#table_list_3").jqGrid('clearGridData'); //清空表格
					$("#table_list_3").jqGrid('setGridParam', { // 重新加载数据
						data : jqdata,
						datatype : "local",
						page : 1
					}).trigger("reloadGrid");
				});	 */
			}
		}
	</script>

</body>

</html>

才华高于颜值

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
封装好增删改查（自用）

<!DOCTYPE html><html><head><meta charset="utf-8"><meta name="viewport" content="width=device-width, initial-scale=1.0"><title>H+ 后台主题UI框架 - jqGird</tit...
复制链接

扫一扫