hs
/
jsgkj


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229
							<%@ page contentType="text/html;charset=UTF-8"%>
<!DOCTYPE html>
<html lang="en">
<head>
<title>执行语句管理</title>
<%@ include file="../../layouts/header.jsp"%>

<link rel="stylesheet"
	href="<%=base%>/js/common/zTree_v3/css/zTreeStyle/zTreeStyle.css"
	type="text/css">
<script
	src="<%=base%>/js/common/zTree_v3/js/jquery.ztree.core-3.5.min.js"></script>
<script type="text/javascript" src="<%=base%>/js/rwgl/tasksql/tasksql.js"></script>
</head>

<body class="no-skin">
	<!-- #section:basics/navbar.layout -->
	<%@ include file="../../layouts/navbar.jsp"%>

	<div class="main-container" id="main-container">
		<script type="text/javascript">
			try {
				ace.settings.check('main-container', 'fixed')
			} catch (e) {
			}
		</script>

		<!-- #section:basics/sidebar -->
		<%@ include file="../../layouts/sidebar.jsp"%>
		<div class="main-content">
			<div class="breadcrumbs" id="breadcrumbs">
				<ul class="breadcrumb">
					<li><i class="ace-icon fa fa-home home-icon"></i> <a
						href="<%=home%>">首页</a></li>

					<li class="active">任务管理</li>
					<li class="active">执行语句管理</li>
				</ul>
			</div>
			<div class="col-xs-12"></div>
			<div class="main-content-inner">
				<div class="page-content">
					<div class="widget-box">
						<div class="widget-header">
							<h4 class="widget-title">执行语句查询</h4>
							<div class="widget-toolbar">
								<a href="#" data-action="collapse"> <i
									class="ace-icon fa fa-chevron-up"></i>
								</a> <a href="#" data-action="close"> <i
									class="ace-icon fa fa-times"></i>
								</a>
							</div>
						</div>

						<div class="widget-body">
							<div class="widget-main">
								<form class="form-horizontal" onsubmit="return false">
									<label class="col-sm-12 control-label"></label>
									<div class="form-group">
										<label for="srchName" class="col-sm-2 control-label">任务编码</label>
										<div class="col-sm-2">
											<input type="text" class="form-control limited"
												id="srchName" placeholder="">
										</div>
										<label for="srchCode" class="col-sm-2 control-label">查询语句</label>
										<div class="col-sm-2">
											<input type="text" class="form-control limited"
												id="srchCode" placeholder="">
										</div>
										<div class="col-sm-2">
											<button class="btn btn-purple btn-round btn-sm"
												onclick="searchRecord()">
												<i class="ace-icon fa fa-search"></i> 查询
											</button>

										</div>
										<label class="col-sm-1 control-label"></label>
									</div>
								</form>
							</div>
						</div>
					</div>
					<!--列表部分-->
					<div>
						<div>
							<table id="grid-table"></table>
							<div id="grid-pager"></div>
						</div>
					</div>
				</div>
			</div>
		</div>
		<!--弹出新增界面-->
		<div id="modal-table" class="modal fade" tabindex="-1">
			<div class="modal-dialog" style="width: 700px; height: 500px;">
				<div class="modal-content">
					<div class="modal-header no-padding">
						<div class="table-header">
							<button type="button" class="close" data-dismiss="modal"
								aria-hidden="true">
								<span class="white">&times;</span>
							</button>
							<label class="modal-title" id="myModalLabel"></label>
						</div>
					</div>
					<div class="modal-body no-padding">
						<form class="form-horizontal" id="form" method="post"
							onsubmit="return false;">
							<input type="hidden" id="id" name="id">
							<div class="form-group">
								<label for="taskCode" class="col-sm-2 control-label">所在任务</label>
								<div class="col-sm-3">
									<div id="taskCodeError"></div>
                                    <select class="form-control" id="taskCode" name="taskCode">
                                    </select>
								</div>
								<div class="col-sm-1">
									<span id="taskCodeImageTip" class="sp_yes"
										style="display: none"></span>
								</div>
								<label for="srcConn" class="col-sm-2 control-label">源连接地址</label>
								<div class="col-sm-3">
									<div id="srcConnError"></div>
                                    <select class="form-control" id="srcConn" name="srcConn">
                                    </select>
								</div>
								<div class="col-sm-1">
									<span id="srcConnImageTip" class="sp_yes"
										style="display: none"></span>
								</div>
							</div>
							<div class="form-group">
								<label for="targetConn" class="col-sm-2 control-label">目标连接地址</label>
								<div class="col-sm-3">
									<div id="targetConnError"></div>
                                    <select class="form-control" id="targetConn" name="targetConn">
                                    </select>
								</div>
								<div class="col-sm-1">
									<span id="targetConnImageTip" class="sp_yes"
										style="display: none"></span>
								</div>
								<label for="targetTable" class="col-sm-2 control-label">目标表</label>
								<div class="col-sm-3">
                                    <input type="text" class="form-control limited" id="targetTable"
										name="targetTable" maxlength="200" placeholder="">
								</div>
							</div>
							<div class="form-group">
								<label for="querySql" class="col-sm-2 control-label">查询SQL</label>
								<div class="col-sm-9">
									<textarea rows="3" cols="" id="querySql" class="form-control limited"
										name="querySql" maxlength="2000">
									</textarea>
								</div>
							</div>
							<div class="form-group">
								<label for="updateSql" class="col-sm-2 control-label">更新SQL</label>
								<div class="col-sm-9">
									<textarea rows="3" cols="" id="updateSql" class="form-control limited"
										name="updateSql" maxlength="2000">
									</textarea>
								</div>
							</div>
							<div class="form-group">
								<label for="insertSql" class="col-sm-2 control-label">插入SQL</label>
								<div class="col-sm-9">
									<textarea rows="3" cols="" id="insertSql" class="form-control limited"
										name="insertSql" maxlength="2000">
									</textarea>
								</div>
							</div>
							<div class="form-group">
								<label for="refreshSql" class="col-sm-2 control-label">执行前更新sql</label>
								<div class="col-sm-3">
                                    <select class="form-control" id="refreshSql" name="refreshSql">
	                                    <option selected value='1'>是</option>
	                                    <option selected value='0'>否</option>
                                    </select>
								</div>
								<div class="col-sm-1"></div>
								<label for="mode" class="col-sm-2 control-label">同步模式</label>
								<div class="col-sm-3">
                                    <select class="form-control" id="mode" name="mode">
	                                    <option selected value='1'>逐条</option>
	                                    <option selected value='2'>全表</option>
                                    </select>
								</div>
							</div>
							<div class="form-group">
								<label for="columns" class="col-sm-2 control-label">同步列</label>
								<div class="col-sm-9">
									<input type="text" class="form-control limited" id="columns"
										name="columns" maxlength="200" placeholder="">
								</div>
							</div>
					
					<div class="modal-footer no-margin-top center modal-foot-border">
						<button id="btnSave" class="btn btn-success btn-round btn-sm">
							<i class="ace-icon fa fa-save"></i> 保存
						</button>
						<button type="button" class="btn btn-grey btn-round btn-sm"
							onclick="closeWin()">
							<i class="ace-icon fa fa-remove"></i> 关闭
						</button>
					</div>
					</form>
				</div>
			</div>
		</div>
	</div>

	<!-- #section:basics/footer -->
	<%@ include file="../../layouts/footer.jsp"%>
	</div>

	<script type="text/javascript">
		$(function() {
			$("#form").validate({
				submitHandler : function(form) {
					submitForm();
				}
			});
		});
	</script>
	<!-- /.main-container -->
</body>
</html>