- /*获得将要显示行的值的map*/
- function getDispMapValue(msql,dsql){
- var sql1=msql;
- var sql2=dsql;
- var map = getMonthDetails();
- if(map!=null && map.size()>0){
- return map;
- }
- var mquery=queryBySQL(sql1);
- if(mquery!=null){
- var dquery=queryBySQL(sql2);
- if(dquery!=null && dquery.size()>0){
- for (var it1= mquery.iterator(); it1.hasNext();) {
- var mdoc = it1.next();
-
- var mname=mdoc.getItemValueAsString("mname");
- var proportion=mdoc.getItemValueAsString("proportion");
-
- var details = createObject("java.util.ArrayList");
- for (var it2 = dquery.iterator(); it2.hasNext();) {
- var ddoc=it2.next();
- var submname=ddoc.getItemValueAsString("mname");
- var subdname=ddoc.getItemValueAsString("dname");
- var subid=ddoc.getItemValueAsString("did");
- if(mname!=null && mname.equals(submname)){
- var row=[subid,subdname,"","","","","","",proportion];
- details.add(row)
- }
- }
- if(details.size()>0){
- map.put(mname,details);
- }
- }
- }
- }
- return map;
- }
- function getMonthDetails(){
- var doc = getCurrentDocument();
- var dsql = "select * from gzjwoa.dbo.TLK_RS_C_MONTHSINGLE where id='"+doc.getId()+"'";
- var docs = queryBySQL(dsql);
- var map = createObject("java.util.HashMap");
- if (docs!=null && docs.size()>0){
- var sql="SELECT * FROM view_rs_monthsingle_info WHERE ITEM_RS_C_MONTHDETAIL_MID='"+doc.getId()+"'";
- var dquery = queryBySQL(sql);
- if(dquery!=null && dquery.size()>0){
- var tempList = createObject("java.util.ArrayList");
- for(var i=0;i<dquery.size();i++){
- var dp=dquery.get(i);
- //隐藏字段
- var pcontent=dp.getItemValueAsString("RS_C_MONTHDETAIL_PCONTENT");
- if(tempList.contains(pcontent)){
- continue;
- }else{
- tempList.add(pcontent);
- }
- var details = createObject("java.util.ArrayList");
- for(var j=0;j<dquery.size();j++){
- var dc=dquery.get(j);
- var temp=dc.getItemValueAsString("RS_C_MONTHDETAIL_PCONTENT");
- if(pcontent!=null && pcontent.equals(temp)){
- //隐藏字段
- var did=dc.getItemValueAsString("RS_C_MONTHDETAIL_CID");
- var ccontent=dc.getItemValueAsString("RS_C_MONTHDETAIL_CCONTENT");
- //显示字段
- var selfcount=dc.getItemValueAsString("RS_C_MONTHDETAIL_SELFCOUNT");
- var firstcount=dc.getItemValueAsString("RS_C_MONTHDETAIL_FIRSTCOUNT");
- var secondcount=dc.getItemValueAsString("RS_C_MONTHDETAIL_SECONDCOUNT");
- var selfhelp=dc.getItemValueAsString("RS_C_MONTHDETAIL_SELFHELP");
- var firsthelp=dc.getItemValueAsString("RS_C_MONTHDETAIL_FIRSTHELP");
- var secondhelp=dc.getItemValueAsString("RS_C_MONTHDETAIL_SECONDHELP");
- var proportion=dc.getItemValueAsString("RS_C_MONTHDETAIL_PROPORTION");
- var row=[did,ccontent,selfcount,firstcount,secondcount,selfhelp,firsthelp,secondhelp,proportion];
- details.add(row);
- }
- }
- if(details.size()>0){
- map.put(pcontent,details);
- }
- }
- }
- }
- return map;
- }
复制代码
|