后台打印出来的数据:
<Response>
<transResult>
<resultCode>1</resultCode>
<resultInfoDesc>交易处理成功</resultInfoDesc>
</transResult>
<object class="PageGrid">
<page>1</page>
<total>1</total>
<records>3</records>
<data>
<map>
<PRODUCT__CHANNEL>Z250000034</PRODUCT__CHANNEL>
<NAME>张三</NAME>
<CONT__NO>QH41A8160122000086</CONT__NO>
<START__ROWNUM__>1</START__ROWNUM__>
<PAYMENT__NAME>在线支付</PAYMENT__NAME>
<BIZE__CODE>101</BIZE__CODE>
<ORDER__NO>925120160122016952</ORDER__NO>
<HEART__STATUS>1</HEART__STATUS>
<PLAN__CODE></PLAN__CODE>
<RISK__CODE>41A8</RISK__CODE>
<PAY__STATUS>3</PAY__STATUS>
<ORG__FILE__PATH>http://127.0.0.1:8080/eservice/ebiz/client/insure.action?action=downloadPolicyFile&paras=emh1bW9iYW5uYW1lPUpLNDFBOCZwYXJhcz0xJTNkUUg0MUE4MTYwMTIyMDAwMDg2Jmlzc2lnbj10cnVl</ORG__FILE__PATH>
</map>
<map>
<PRODUCT__CHANNEL>Z250000034</PRODUCT__CHANNEL>
<NAME>张三</NAME>
<CONT__NO>QH41A8160122000084</CONT__NO>
<START__ROWNUM__>2</START__ROWNUM__>
<PAYMENT__NAME>在线支付</PAYMENT__NAME>
<BIZE__CODE>101</BIZE__CODE>
<ORDER__NO>925120160122016950</ORDER__NO>
<HEART__STATUS>1</HEART__STATUS>
<PLAN__CODE></PLAN__CODE>
<RISK__CODE>41A8</RISK__CODE>
<PAY__STATUS>3</PAY__STATUS>
<ORG__FILE__PATH>http://127.0.0.1:8080/eservice/ebiz/client/insure.action?action=downloadPolicyFile&paras=emh1bW9iYW5uYW1lPUpLNDFBOCZwYXJhcz0xJTNkUUg0MUE4MTYwMTIyMDAwMDg0Jmlzc2lnbj10cnVl</ORG__FILE__PATH>
</map>
<map>
<PRODUCT__CHANNEL>Z250000034</PRODUCT__CHANNEL>
<NAME>张三</NAME>
<CONT__NO>QH41A8160122000085</CONT__NO>
<START__ROWNUM__>3</START__ROWNUM__>
<PAYMENT__NAME>在线支付</PAYMENT__NAME>
<BIZE__CODE>101</BIZE__CODE>
<ORDER__NO>925120160122016951</ORDER__NO>
<HEART__STATUS>1</HEART__STATUS>
<PLAN__CODE></PLAN__CODE>
<RISK__CODE>41A8</RISK__CODE>
<PAY__STATUS>3</PAY__STATUS>
<ORG__FILE__PATH>http://127.0.0.1:8080/eservice/ebiz/client/insure.action?action=downloadPolicyFile&paras=emh1bW9iYW5uYW1lPUpLNDFBOCZwYXJhcz0xJTNkUUg0MUE4MTYwMTIyMDAwMDg1Jmlzc2lnbj10cnVl</ORG__FILE__PATH>
</map>
</data>
</object>
</Response>
查询SQL:
select
ord.order_no,<!-- 订单时间 -->
ord.cont_no, <!-- 保单号 -->
ord.product_Channel,<!-- 渠道代码 -->
insurance.risk_code, <!-- 产品编码 -->
insurance.plan_code,<!-- 款别 -->
appnt.name,<!-- 投保人 -->
ord.payment_name, <!-- 支付方式 -->
ord.bize_code,<!-- 业务类型 -->
ord.pay_status,
ord.HEART_STATUS, <!-- 导入核心状态 -->
cont.ORG_FILE_PATH <!--电子保单下载地址-->
from ebiz_order ord <!-- 订单表 -->
left join ebiz_appnt appnt <!-- 投保人表 -->
on ord.order_no =appnt.order_no
left join ebiz_payment pay <!-- 订单支付表 -->
on ord.unno = pay.order_no
and pay.is_delete =0
left join EBIZ_ORDER_INSURANCE insurance <!-- (订单险种表) -->
on ord.order_no = insurance.order_no
and insurance.is_delete =0
left join EBIZ_ELEC_CONT cont
on ord.cont_no = cont.cont_no
where ord.is_delete =0
<isNotNull property="orderNo"> and ord.order_No = #orderNo# </isNotNull>
<isNotNull property="contNo"> and ord.cont_No = #contNo# </isNotNull>
<isNotNull property="channelName">and ord.channel_Name = #channelName# </isNotNull>
<isNotNull property="productChannel">and ord.product_Channel = #productChannel# </isNotNull>
<isNotNull property="riskCode">and insurance.risk_Code= #riskCode# </isNotNull>
<isNotNull property="planCode">and insurance.plan_Code= #planCode# </isNotNull>
<isNotNull property="name">and appnt.name= #name# </isNotNull>
<isNotNull property="paymentName">and sale.payment_Name= #paymentName# </isNotNull>
<isNotNull property="payStatus">and ord.pay_Status= #payStatus# </isNotNull>
<isNotNull property="bizeCode">and ord.bize_Code= #bizeCode# </isNotNull>
<isNotNull property="heartStatus">and ord.heart_Status= #heartStatus# </isNotNull>
<isNotNull property="startDate"><![CDATA[and to_char(ord.modified_date,'yyyy-mm-dd') >= #startDate#]]></isNotNull>
<isNotNull property="endDate" ><![CDATA[and to_char(ord.modified_date, 'yyyy-mm-dd') <= #endDate# ]]></isNotNull>
order by ord.modified_date desc
JS代码:
$("#jqGridTableId").jqGrid({
url : Eservice.ctx +'/ebiz/inquire/contNoShow.action?action=getPolicyList&ajax=true',
mtype : 'POST',
postData : {
heartStatus:$("#heartStatus").val(),
contNo:$("#contNo").val(),
riskCode:$("#riskCode").val(),
planCode:$("#planCode").val(),
channelName:$("#channelName").val(),
productChannel:$("#productChannel").val(),
name:$("#name").val(),
paymentName:$("#paymentName").val(),
bizeCode:$("#bizeCode").val()
},
datatype : "xml",
colNames : ['保单号','渠道代码', '险种代码','款别',
'投保人','支付方式', '导入核心状态', '业务类型','操作','订单号','支付状态','电子保单下载地址'],
colModel : [{
name : 'CONT__NO',
index : 'CONT__NO',
align : 'center',
sortable : false,
width: 70
},{
name : 'PRODUCT__CHANNEL',
index : 'PRODUCT__CHANNEL',
align : 'center',
sortable : false,
width: 70
},{
name : 'RISK__CODE',
index : 'RISK__CODE',
align : 'center',
formatter : 'date',
sortable : false,
width: 55
},{
name : 'PLAN__CODE',
index : 'PLAN__CODE',
align : 'center',
sortable : false,
width: 120
},{
name : 'NAME',
index : 'NAME',
align : 'center',
sortable : false,
width: 55
},{
name : 'PAYMENT__NAME',
index : 'PAYMENT__NAME',
align : 'center',
sortable : false,
width: 50/*,*/
// formatter:function(val,rec){
// var cname;
// if(val=='1'){
// cname="已支付";
// }else if(val=='2'){
// cname="未支付";
// }else if(val=='3'){
// cname="支付失败";
// }
// return cname;
// }
},{
name : 'HEART__STATUS',
index : 'HEART__STATUS',
align : 'center',
sortable : false,
width: 50 /*,*/
/*formatter:function(val,rec){
var cname;
if(val=='1'){
cname="已导入";
}else if(val=='2'){
cname="未导入";
}else if(val=='3'){
cname="导入失败";
}
return cname;
}*/
},{
name : 'BIZE__CODE',
index : 'BIZE__CODE',
align : 'center',
sortable : false,
width: 75/*,
formatter:function(val,rec){
var cname;
if(val=='101'){
cname="投保";
}else if(val=='102'){
cname="退保";
}else if(val=='103'){
cname="投保批改";
}else if(val=='104'){
cname="异步返回";
}else if(val=='105'){
cname="注销";
}
return cname;
}*/
},{
name : 'OPER',
index : 'OPER',
align : 'center',
sortable : false,
width: 75
},{
name : 'ORDER__NO',
index : 'ORDER__NO',
hidden: true
},{
name : 'PAY__STATUS',
index : 'PAY__STATUS',
hidden: true
},{
name : 'ORG__FILE__PATH',
index : 'ORG__FILE__PATH',
hidden: true
}],
shrinkToFit : true,
rowNum : 10,
rowList : [ 10, 30, 50 ],
pager : '#jqGridPagerId',
viewrecords : true,
xmlReader : {
repeatitems : false,
root : "object",
row : "map",
page : 'page',
total : 'total',
records : 'records'
},
caption : "保单信息",
height:'auto',
gridComplete: function(){ //获得所有行的ID数组
var ids = $("#jqGridTableId").jqGrid('getDataIDs');
alert(ids);
var contNo=$('#contNo').val();
for(var i=0;i < ids.length;i++){
var arr = $("#jqGridTableId").jqGrid('getRowData',ids[i]);
alert(arr.ORDER__NO);
var linkReq = "<a href=# onclick=\'ContManage.winShowRequest('" + arr.ORDER__NO + "', '" + arr.CONT__NO + "')\'>" + arr.CONT__NO + "</a>";
$("#jqGridTableId").jqGrid('setRowData',ids[i],{CONT__NO:linkReq});
var linkHis = "<a href=# onclick=\'ContManage.winShowHis('" + arr.ORDER__NO + "', '" + arr.CONT__NO + "')\'>" + "日志" + "</a>";
$("#jqGridTableId").jqGrid('setRowData',ids[i],{OPER:linkHis});
var linkDetail = "<a href=# onclick=\'ContManage.winOpenOrder('" + arr.ORDER__NO + "', '" + arr.CONT__NO + "')\'>" + "详情" + "</a>";
$("#jqGridTableId").jqGrid('setRowData',ids[i],{OPER:linkDetail});
var linkDown = "<a href="+arr.ORG__FILE__PATH+"?"+ arr.CONT__NO + "\'>" + "电子保单下载" + "</a>";
$("#jqGridTableId").jqGrid('setRowData',ids[i],{OPER:linkDown});
}
}
});
jqGrid 从后台能获取xml数据,但是前台grid数据就是显示不出来!页面有三条记录
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
10条回答 默认 最新
- tony4geek 2016-01-26 02:24关注
浏览器 F12 看看数据response 到前台没有,如果数据回来了请确认,列名和返回的字段是否一一对应包括大小写。
解决 无用评论 打赏 举报
悬赏问题
- ¥15 请问这个是什么意思?
- ¥15 STM32驱动继电器
- ¥15 Windows server update services
- ¥15 关于#c语言#的问题:我现在在做一个墨水屏设计,2.9英寸的小屏怎么换4.2英寸大屏
- ¥15 模糊pid与pid仿真结果几乎一样
- ¥15 java的GUI的运用
- ¥15 我想付费需要AKM公司DSP开发资料及相关开发。
- ¥15 怎么配置广告联盟瀑布流
- ¥15 Rstudio 保存代码闪退
- ¥20 win系统的PYQT程序生成的数据如何放入云服务器阿里云window版?