<%@ page contentType="text/html; charset=GBK"%>
<%@ include file="/IncludeBegin.jsp"%><%
//定义变量
String sSql;
String PG_TITLE = "合同转移列表"; // 浏览器窗口标题 PG_TITLE
String sHeaders[][] = {
{"BCFlag","是否转移"},
{"SerialNo","合同流水号"},
{"CustomerName","客户名称"},
{"StatOrgName","合同入帐机构"},
{"BusinessTypeName","业务品种"},
{"CurrencyName","币种"},
{"BusinessSum","金额"},
{"PutOutDate","起始日"},
{"Maturity","到期日"}
};
sSql = sSql = " select '' as BCFlag,SerialNo,CustomerName,getOrgName(StatOrgID) as StatOrgName, "+
" StatOrgID,getBusinessName(BusinessType) as BusinessTypeName, "+
" getItemName('Currency',BusinessCurrency) as CurrencyName,BusinessSum, "+
" PutOutDate,Maturity from BUSINESS_CONTRACT where ManageOrgID in "+
" (select OrgID from ORG_INFO where SortNo like '"+CurOrg.getSortNo()+"%') ";
ASDataObject doTemp = new ASDataObject(sSql);
//设置表头
doTemp.setHeader(sHeaders);
//设置可更新目标表
doTemp.UpdateTable = "BUSINESS_CONTRACT";
doTemp.setKey("SerialNo",true);
doTemp.setType("BusinessSum","Number");
doTemp.setAlign("BusinessSum","3");
doTemp.setAlign("BCFlag","2");
//设置字段不可见
doTemp.setVisible("StatOrgID",false);
//设置字段显示宽度
doTemp.setHTMLStyle("BusinessTypeName,CustomerName,StatOrgName"," style={width:200px} ");
doTemp.setHTMLStyle("CurrencyName"," style={width:80px} ");
doTemp.setHTMLStyle("BCFlag","style={width:60px} ondblclick=\"javascript:parent.onDBClickStatus()\"");
//置字段是否可更新
doTemp.setUpdateable("BusinessTypeName,StatOrgName,CurrencyName",false);
//生成查询条件
doTemp.generateFilters(Sqlca);
doTemp.setFilter(Sqlca,"1","SerialNo","");
doTemp.setFilter(Sqlca,"2","CustomerName","");
doTemp.parseFilterData(request,iPostChange);
doTemp.haveReceivedFilterCriteria();
CurPage.setAttribute("FilterHTML",doTemp.getFilterHtml(Sqlca));
//生成ASDataWindow对象
ASDataWindow dwTemp = new ASDataWindow(CurPage,doTemp,Sqlca);
//设置为Grid风格
dwTemp.Style="1";
//设置为只读
dwTemp.ReadOnly = "1";
Vector vTemp = dwTemp.genHTMLDataWindow("");
for(int i=0;i<%@include file="/Resources/CodeParts/List05.jsp"%>
<%@ include file="/IncludeEnd.jsp"%>