89 lines
3.7 KiB
Plaintext
89 lines
3.7 KiB
Plaintext
<%@ page contentType="text/html; charset=GBK"%><%@
|
||
include file="/Frame/resources/include/include_begin_list.jspf"%><%
|
||
/*
|
||
Content: 对查询条件进行处理，并且显示数据窗口
|
||
*/
|
||
//获得组件参数 ，传入要执行的sql语句、查询类型
|
||
String querySQL = (String)session.getAttribute("querySQL"); //查询语句
|
||
String queryClass = CurPage.getParameter("queryClass"); //查询的jboclass
|
||
String sStatResult = CurPage.getParameter("StatResult"); //查询类型,1--汇总,2--明细
|
||
//System.out.println(">>>>>>>>>>>>>>"+sStatResult+"@"+queryClass+"@"+querySQL);
|
||
|
||
ASObjectModel doTemp = new ASObjectModel();
|
||
CurPage.setAttribute("EnvironmentSortNo",CurOrg.getSortNo());
|
||
CurPage.setAttribute("EnvironmentCorpID",CurOrg.getCorpOrgID());
|
||
doTemp.setCurPage(CurPage);
|
||
doTemp.initQuery(queryClass, querySQL);
|
||
doTemp.setColumnFilter("*", false);
|
||
//doTemp.setColumnFilter("InputOrgId", true);
|
||
|
||
ASObjectWindow dwTemp = new ASObjectWindow(CurPage,doTemp,request);
|
||
dwTemp.setPageSize(20);
|
||
dwTemp.Style="1"; //设置为Grid风格
|
||
dwTemp.ReadOnly = "1";//只读模式
|
||
if(sStatResult.equals("1")){//汇总查询
|
||
dwTemp.ShowSummary="1";//设置合计列
|
||
}
|
||
dwTemp.genHTMLObjectWindow("");
|
||
|
||
String sButtons[][] = {
|
||
{"false","","Button","查看客户详情","查看客户详情","my_CustomerInfo()","","","",""},
|
||
{"true","","Button","导出Excel","导出Excel","exportPage('"+sWebRootPath+"',0,'excel','"+dwTemp.getArgsValue()+"')","","","",""},
|
||
};
|
||
%><%@ include file="/Frame/resources/include/ui/include_list.jspf"%>
|
||
<script type="text/javascript">
|
||
/*~[Describe=查看客户详情;]~*/
|
||
function my_CustomerInfo(){
|
||
sCustomerID=getItemValue(0,getRow(),"CustomerID");
|
||
if (typeof(sCustomerID)=="undefined" || sCustomerID.length==0){
|
||
alert(getMessageText('AWEW1001')); //请选择一条记录！
|
||
}else{
|
||
openObject("Customer",sCustomerID,"002");
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 重写方法，转换为按钮选择
|
||
*/
|
||
function afterOpenFilterArea(){
|
||
var filterColName = "InputOrgId";
|
||
var sHtml = getFilterCustomWhereClauses(0);
|
||
var index = getColIndex(0, filterColName);
|
||
filterValues["myiframe0"][index] = ""; // 为了方便，将已查询的记录置为空
|
||
var sSrc = '<span class="filter_btsel"><span class="shower" onclick="AsLink.stopEvent(event);"></span><span class="editor"><span></span><input id="filter_btsel_0_'+index+'"></span></span><span id="DOFILTER_EXTSP_'+filterColName.toUpperCase()+'"></span></span>';
|
||
var sSrc2 = '<SPAN class=filter_btsel><SPAN class=shower onclick=AsLink.stopEvent(event);></SPAN><SPAN class=editor><SPAN></SPAN><INPUT id=filter_btsel_0_'+index+'></SPAN></SPAN><SPAN id=DOFILTER_EXTSP_'+filterColName.toUpperCase()+'></SPAN></SPAN>';
|
||
var sTarg = '<input id="filter_btsel_0_'+index+'_show" /><input type="button" value="..." onclick="selectOrgSearch('+index+');" />';
|
||
if(sHtml.indexOf(sSrc) > -1){
|
||
setFilterCustomWhereClauses(0,sHtml.replace(sSrc, sTarg));
|
||
}else if(sHtml.indexOf(sSrc2) > -1){
|
||
setFilterCustomWhereClauses(0,sHtml.replace(sSrc2, sTarg));
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 选择机构进行查询
|
||
*/
|
||
function selectOrgSearch(index){
|
||
var sSelected = filterValues["myiframe0"][index];
|
||
AsDialog.SelectTreeValue("OrgList", "<%=CurOrg.getSortNo()%>%", "OrgId@OrgName", "SortNo", "OrgName", sSelected, true, false, null, function(sReturn){
|
||
if(!sReturn) return;
|
||
var sValue = "", sText = "";
|
||
if(sReturn != "_CLEAR_"){
|
||
var aReturn = sReturn.split("~");
|
||
for(var i = 0; i < aReturn.length; i++){
|
||
var aVT = aReturn[i].split("@");
|
||
if(i == 0){
|
||
sValue = aVT[0];
|
||
sText = aVT[1];
|
||
}else{
|
||
sValue += "|" + aVT[0];
|
||
sText += "|" + aVT[1];
|
||
}
|
||
}
|
||
}
|
||
document.getElementById("filter_btsel_0_"+index+"_show").value = sText;
|
||
filterValues["myiframe0"][index] = sValue;
|
||
});
|
||
}
|
||
</script>
|
||
<%@ include file="/Frame/resources/include/include_end.jspf"%> |