DataSetEditInner.jsp 8.48 KB

Raw Blame History Permalink

<%@page import="weaver.fna.general.FnaCommon"%>
<%@page import="weaver.systeminfo.label.LabelComInfo"%>
<%@page import="org.apache.commons.lang.StringEscapeUtils"%>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>
<%@page import="weaver.hrm.HrmUserVarify"%>
<%@page import="weaver.hrm.User"%>
<%@ page import="weaver.general.Util" %>

<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="UserDefaultManager" class="weaver.docs.tools.UserDefaultManager" scope="session" />
<%
if(true) {
    response.sendRedirect("/notice/noright.jsp") ;
    return ;
}

String imagefilename = "/images/hdMaintenance_wev8.gif";
String titlename = "";//
String needfav ="1";
String needhelp ="";

int detachable=Util.getIntValue(String.valueOf(session.getAttribute("detachable")),0);
int parentid=Util.getIntValue(request.getParameter("paraid"),0);

String nameQuery = Util.null2String(request.getParameter("nameQuery")).trim();
%>
<html>
<head>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<script language="javascript" src="/wui/theme/ecology8/jquery/js/zDialog_wev8.js"></script>
<script language="javascript" src="/wui/theme/ecology8/jquery/js/zDrag_wev8.js"></script>
<script language="javascript" src="/js/weaver_wev8.js"></script>
<script language="javascript" src="/fna/js/e8Common_wev8.js?r=3"></script>
</head>
<body style="overflow:hidden;">
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>

<%
RCMenu += "{"+SystemEnv.getHtmlLabelName(82,user.getLanguage())+",javascript:doCreate(),_self} ";//新建
RCMenuHeight += RCMenuHeightStep ;
RCMenu += "{"+SystemEnv.getHtmlLabelName(32136,user.getLanguage())+",javascript:doBatchDel(),_self} ";//批量删除
RCMenuHeight += RCMenuHeightStep ;
%>

<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
<form id="form2" name="form2" method="post"  action="/fna/mulDimensions/dataSet/DataSetEditInner.jsp">
<table id="topTitle" cellpadding="0" cellspacing="0">
	<tr>
		<td>
		</td>
		<td class="rightSearchSpan" style="text-align:right; width:500px!important">
			<input type="button" value="<%=SystemEnv.getHtmlLabelName(82,user.getLanguage()) %>"
				class="e8_btn_top" onclick="doCreate();"/><!-- 新建 -->
			<input type="button" value="<%=SystemEnv.getHtmlLabelName(32136,user.getLanguage()) %>" class="e8_btn_top" onclick="doBatchDel()"/><!-- 批量删除 -->
			<input type="text" class="searchInput" id="nameQuery" name="nameQuery" value="<%=FnaCommon.escapeHtml(nameQuery) %>" /><!-- 快速搜索 -->
			&nbsp;&nbsp;&nbsp;
			<span title="<%=SystemEnv.getHtmlLabelName(23036,user.getLanguage()) %>" class="cornerMenu"></span><!-- 菜单 -->
		</td>
	</tr>
</table>

<%
	//设置好搜索条件
	String backFields ="a.id, a.datasetName, a.accountId, a.datasourcename, a.sourceSql,a.templateId, b.accountName," +
			"case when(datasetType=1) then '"+SystemEnv.getHtmlLabelName(126462,user.getLanguage())+
			"' else '"+SystemEnv.getHtmlLabelName(389012,user.getLanguage())+"' end datasetType ";
	String fromSql = " from FnaDatasSet a  join FnaAccountInfo b on a.accountId=b.id  \r";
	String sqlWhere = " where 1=1 ";
	if(!"".equals(nameQuery)){
		sqlWhere += " and a.datasetName like '%"+StringEscapeUtils.escapeSql(nameQuery)+"%' \n";
	}

	String orderBy = " a.id ";

	String sqlprimarykey = "a.id";

	//out.println("select "+backFields+" "+fromSql+" "+sqlWhere+" order by "+orderBy);

	String tableString=""+
       "<table instanceid=\"FNA_REPAYMENT_WF_SET_EDIT_INNER_LIST\" pageId=\""+PageIdConst.FNA_REPAYMENT_WF_SET_EDIT_INNER_LIST+"\" "+
      		" pagesize=\""+PageIdConst.getPageSize(PageIdConst.FNA_REPAYMENT_WF_SET_EDIT_INNER_LIST,user.getUID(),PageIdConst.FNA)+"\" tabletype=\"checkbox\">"+
       "<sql backfields=\""+Util.toHtmlForSplitPage(backFields)+"\" sqlform=\""+Util.toHtmlForSplitPage(fromSql)+"\" sqlwhere=\""+Util.toHtmlForSplitPage(sqlWhere)+"\" sqlorderby=\""+Util.toHtmlForSplitPage(orderBy)+"\" "+
       " sqlprimarykey=\""+Util.toHtmlForSplitPage(sqlprimarykey)+"\" sqlsortway=\"desc\" />"+
       "<head>"+
			"<col width=\"25%\"  text=\""+SystemEnv.getHtmlLabelName(388995,user.getLanguage())+"\" column=\"datasetName\" orderkey=\"datasetName\" "+//数据集名称
     				" transmethod=\"weaver.fna.general.FnaSplitPageTransmethod.doJsFunc\" otherpara=\"doEdit_grid+column:id\"/>"+
			"<col width=\"25%\"  text=\""+SystemEnv.getHtmlLabelName(24427,user.getLanguage())+"\" column=\"accountName\" orderkey=\"accountName\" "+//账套
					" />"+
     		"<col width=\"25%\"  text=\""+SystemEnv.getHtmlLabelName(389006,user.getLanguage())+"\" column=\"datasetType\" orderkey=\"datasetType\" "+//数据集类型
					" />"+
			"<col width=\"25%\"  text=\""+SystemEnv.getHtmlLabelName(18076,user.getLanguage())+"\" column=\"datasourcename\" orderkey=\"datasourcename\" "+//数据源
					" />"+
       "</head>"+
		"		<operates>"+
		"			<popedom transmethod=\"weaver.fna.general.FnaSplitPageTransmethod.getFnaRepaymentWfSetEditInner_popedom\" otherpara=\"column:enable\" ></popedom> "+
		"			<operate href=\"javascript:doEdit_grid();\"  text=\""+SystemEnv.getHtmlLabelName(93,user.getLanguage())+"\" index=\"2\"/>"+//编辑
		"			<operate href=\"javascript:doDel_grid();\" text=\""+SystemEnv.getHtmlLabelName(91,user.getLanguage())+"\" otherpara=\"column:datasetType\" index=\"3\"/>"+//删除
		"		</operates>"+
       "</table>";
%>
	<wea:layout type="1col">
		<wea:group context="" attributes="{'groupDisplay':'none'}">
			<wea:item attributes="{'isTableList':'true'}">
				<input type="hidden" name="pageId" id="pageId" value="<%=PageIdConst.FNA_BORROW_WF_SET_EDIT_INNER_LIST %>" />
				<wea:SplitPageTag  tableString='<%=tableString%>'  mode="run" />
			</wea:item>
		</wea:group>
	</wea:layout>
</form>


<script language="javascript">
var _Label33574 = "<%=SystemEnv.getHtmlLabelName(33574,user.getLanguage()) %>";//正在处理数据，请不要离开该页面，请稍等...

//快速（高级）搜索事件
function onBtnSearchClick(from_advSubmit){
	form2.submit();
}

//批量删除
function doBatchDel(){
	var ids = _xtable_CheckedCheckboxId();
	if(ids==null||ids==""){
		top.Dialog.alert("<%=SystemEnv.getHtmlLabelName(24244,user.getLanguage()) %>");//请先选择需要删除的数据
		return;
	}
	var _data = "op=batchDel&ids="+ids;

	//确认要删除吗
	top.Dialog.confirm("<%=SystemEnv.getHtmlLabelName(389111,user.getLanguage()) %>",
		function(){
			openNewDiv_FnaBudgetViewInner1(_Label33574);
			jQuery.ajax({
				url : "/fna/mulDimensions/dataSet/DatasSetOp.jsp",
				type : "post",
				cache : false,
				processData : false,
				data : _data,
				dataType : "json",
				success: function do4Success(_json){
				    try{
						try{closeNewDiv_FnaBudgetViewInner1();}catch(ex1){}
				    	top.Dialog.alert(_json.msg);
						if(_json.flag){

							_table.reLoad();
						}
				    }catch(e1){
				    }
				}
			});
		},
		function(){}
	);
}

//删除
function doDel_grid(id,_para2,_obj){
	var _data = "op=delete&ids="+id;

	//确认要删除吗
	top.Dialog.confirm("<%=SystemEnv.getHtmlLabelName(389111,user.getLanguage()) %>",
		function(){
			openNewDiv_FnaBudgetViewInner1(_Label33574);
			jQuery.ajax({
				url : "/fna/mulDimensions/dataSet/DatasSetOp.jsp",
				type : "post",
				cache : false,
				processData : false,
				data : _data,
				dataType : "json",
				success: function do4Success(_json){
				    try{
						try{closeNewDiv_FnaBudgetViewInner1();}catch(ex1){}
				    	top.Dialog.alert(_json.msg);
						if(_json.flag){
							_table.reLoad();
						}
				    }catch(e1){
				    }
				}
			});
		},
		function(){}
	);
}


//明细设置
function doDetailSet_grid(id){
	openEditPage(id, null, null, 2);
}

//基本信息
function doEdit_grid(id){
	openEditPage(id, null, null, 1);
}

//进入明细设置
function openEditPage(id, param2, param3, tabId, parentWin){
    var _w = 600;
    var _h = 520;
	if(parentWin!=null){
		doClose1();
		onBtnSearchClick();
	}
	_fnaOpenDialog("/fna/mulDimensions/dataSet/DataSetEditPage.jsp?id="+id+"&tabId="+tabId,
			"<%=SystemEnv.getHtmlLabelName(93,user.getLanguage())+SystemEnv.getHtmlLabelName(84712,user.getLanguage()) %>",
			_w, _h);
}

//新建
function doCreate(){
	var _w = 600;
	var _h = 420;
	_fnaOpenDialog("/fna/mulDimensions/dataSet/DataSetEditCreate.jsp",
			"<%=SystemEnv.getHtmlLabelName(82,user.getLanguage())+SystemEnv.getHtmlLabelName(84712,user.getLanguage()) %>",
			_w, _h);
}

//关闭
function doClose1(){
	window.closeDialog();
}

</script>
</body>
</html>