DataSetDetailInfo.jsp 7.74 KB

Raw Blame History Permalink

<%@page import="weaver.fna.general.FnaCommon"%>
<%@page import="weaver.fna.budget.FnaWfSet"%>
<%@page import="weaver.systeminfo.label.LabelComInfo"%>
<%@page import="weaver.workflow.field.BrowserComInfo"%>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>
<%@ taglib uri="/browserTag" prefix="brow"%>
<%@ 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" />
<%
if(true) {
    response.sendRedirect("/notice/noright.jsp") ;
    return ;
}

String imagefilename = "/images/hdMaintenance_wev8.gif";
String titlename = SystemEnv.getHtmlLabelName(82,user.getLanguage())+SystemEnv.getHtmlLabelName(84712,user.getLanguage());
String needfav ="1";
String needhelp ="";

String  id = Util.null2String(request.getParameter("id"));

String sqlSetColumn = "";
String showname = "";
String dimensionID = "";
String dimensionName="";
int dataColumn = 0;
String datasetName="";
String accountid="";
String tablename="";
String sql = "select * from FnaDatasSet where id =? ";
rs.executeQuery(sql,id);
while (rs.next()){
	datasetName=rs.getString("datasetName");
	accountid=rs.getString("accountId");
}

new BaseBean().writeLog("8888"+accountid);
String sql2 = "select * from FnaDataSetDetail where dasetID = ?";
rs.executeQuery(sql2,id);
if(rs.next()){

	sqlSetColumn = Util.null2String(rs.getString("sqlSetColumn"));
	showname = Util.null2String(rs.getString("showname"));
	dimensionID = Util.null2String(rs.getString("dimensionID"));
	dataColumn =rs.getInt("dataColumn");
}
	String sql1="select tableName from FnaAccountDtl where accountId=? and tableType=?";
	rs.executeQuery(sql1,accountid,2);
	if(rs.next()){
		tablename=rs.getString("tableName");
	}
	String dsql="select * from "+tablename+" where id = ?";
  	rs.executeQuery(dsql,dimensionID);
	while (rs.next()){
	dimensionName=rs.getString("dimensionName");
	}

	new BaseBean().writeLog("9999"+tablename);

%>

<%@page import="weaver.filter.XssUtil"%><HTML><HEAD>
<%@page import="weaver.fna.encrypt.Des"%>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<script language="javascript" src="/js/weaver_wev8.js"></script>
<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/checkbox/jquery.tzCheckbox_wev8.js"></script>
<script language="javascript" src="/fna/js/e8Common_wev8.js?r=3"></script>
<script type="text/javascript" src="/fna/encrypt/des/des_wev8.js"></script>


</head>
<BODY style="overflow:hidden;">
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<%
	RCMenu += "{" + SystemEnv.getHtmlLabelName(86, user.getLanguage())
			+ ",javascript:doSave(false),_self} ";
	RCMenuHeight += RCMenuHeightStep;
%>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
<div class="zDialog_div_content">
		<table id="topTitle" cellpadding="0" cellspacing="0">
			<tr><td>&nbsp;</td>
				<td class="rightSearchSpan" style="text-align: right;">
		    		<input class="e8_btn_top" type="button" id="btnSave" onclick="doSave(false);"
		    			value="<%=SystemEnv.getHtmlLabelName(86,user.getLanguage())%>"/><!-- 保存 -->
					<span title="<%=SystemEnv.getHtmlLabelName(23036, user.getLanguage())%>" class="cornerMenu"></span>
				</td>
			</tr>
		</table>

<input id="id" name="id" value="<%=id %>" type="hidden" />
<wea:layout type="2col">
	<wea:group context='<%=SystemEnv.getHtmlLabelName(1361,user.getLanguage())%>'>

		<wea:item><%=SystemEnv.getHtmlLabelName(389083,user.getLanguage())%></wea:item><!-- 返回数据列 -->

		<wea:item>
			<input class="inputstyle" id="sqlSetColumn" name="sqlSetColumn" maxlength="2000" style="width: 80%;" value="<%=sqlSetColumn%>"/>
		</wea:item>

		<wea:item><%=SystemEnv.getHtmlLabelName(17607,user.getLanguage())%></wea:item><!-- 自定义名称 -->

		<wea:item>
			<input class="inputstyle" id="showname" name="showname" maxlength="2000" style="width: 80%;" value="<%=showname%>" />
		</wea:item>

		<wea:item><%=SystemEnv.getHtmlLabelName(389084,user.getLanguage())%></wea:item><!-- 账套维度 -->

		<wea:item>
			<%
				String _browserUrl = "/systeminfo/BrowserMain.jsp?url=/fna/browser/budgetDimension/BudgetDimensionBrowser.jsp%3Faccountid="+accountid;
			%>
			<brow:browser viewType="0" name="dimensionID" browserValue='<%="" %>'
						  browserUrl="<%=_browserUrl %>"
						  hasInput="true" isSingle="true" hasBrowser = "true" isMustInput="2"
						  browserSpanValue='<%=dimensionName %>' width="70%"
						  _callback="workflowid_callback" >
			</brow:browser>
		</wea:item>

		<wea:item><%=SystemEnv.getHtmlLabelNames("389087",user.getLanguage())%></wea:item><!-- 是否最终数据列 -->
		<wea:item>
			<select class="inputstyle" id="dataColumn" name="dataColumn" style="width: 80px;" onchange="enableGlobalFnaCtrl_onClick();">
				<option value="0" <% if(dataColumn == 0) { %>selected<%}%>><%=SystemEnv.getHtmlLabelName(163,user.getLanguage())%></option>
				<option value="1"<% if(dataColumn == 1) { %>selected<%}%>><%=SystemEnv.getHtmlLabelName(161,user.getLanguage())%></option>
			</select>
		</wea:item>

	</wea:group>
</wea:layout>
</div>
<div id="zDialog_div_bottom" class="zDialog_div_bottom">
<wea:layout needImportDefaultJsAndCss="false">
	<wea:group context="" attributes="{'groupDisplay':'none'}">
    	<wea:item type="toolbar">
    		<input class="zd_btn_cancle" type="button" id="btnClose" onclick="onCancel();"
    			value="<%=SystemEnv.getHtmlLabelName(309,user.getLanguage())%>"/><!-- 取消 -->
    	</wea:item>
    </wea:group>
</wea:layout>
</div>
<script language=javascript>
var _Label33574 = "<%=SystemEnv.getHtmlLabelName(33574,user.getLanguage()) %>";//正在处理数据，请不要离开该页面，请稍等...

jQuery(document).ready(function(){
	resizeDialog(document);
});

function workflowid_callback(){

}

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

//关闭
function doClose(){
	var parentWin = parent.parent.getParentWindow(window);
	parentWin.closeDialog();
}

//保存
function doSave(_openEditPage){
	var id = null2String(jQuery("#id").val());
	var sqlSetColumn = null2String(jQuery("#sqlSetColumn").val());
	var showname =null2String(jQuery("#showname").val());
	var dimensionID = null2String(jQuery("#dimensionID").val());
	var dataColumn = null2String(jQuery("#dataColumn").val());

	try{
		//确定要保存么？
		top.Dialog.confirm("<%=SystemEnv.getHtmlLabelName(32130,user.getLanguage()) %>",
			function(){
				hideRightMenuIframe();
				var _data = "op=editDetailInfo&id="+id+"&sqlSetColumn="+sqlSetColumn+"&showname="+showname+
					"&dimensionID="+dimensionID+"&dataColumn="+dataColumn;

				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){}
							if(_json.flag){
								var parentWin = parent.parent.getParentWindow(parent.window);
								parentWin.onBtnSearchClick();
								//onCancel2();
								top.Dialog.alert("<%=SystemEnv.getHtmlLabelName(18758,user.getLanguage()) %>");//保存成功
							}else{
								top.Dialog.alert(_json.msg);
							}

					    	showRightMenuIframe();
					    }catch(e1){
					    	showRightMenuIframe();
					    }
					}
				});
			},
			function(){}
		);
	}catch(e1){
		showRightMenuIframe();
	}
}

function onCancel(){
	var dialog = parent.parent.getDialog(parent.window);
	dialog.closeByHand();
}

function onCancel2(){
	parent.onCancel();
}

</script>
</BODY>
</HTML>