$(document).ready(function(){
init(dataArray);
$("#d11").datepicker({
});
$("#d12").datepicker({
}); $("#orderquery").bind("click",researchEvent);
});
function researchEvent(){
var startime = $("#d11").attr("value");
var endtime = $("#d12").attr("value");
var param = {"startime":startime,"endtime":endtime,"order_id":order_id,"goodsname":goodsname,"act":"orderquery"};
$.ajax({
type:"get",
url:"queryorder_do.jsp",
data:param,
dataType:"json",
success:function(s){
if(typeof(s)!="undefined"){
alert("查询成功!");
clearTable();
init(s);
}else{
alert("查询失败!");
}
}
})
}
function init(array){
var tableObj = document.getElementById("table");
var tr_title = tableObj.insertRow(0);
tr_title.width="1000";
tr_title.height="18";
tr_title.align = "center";
var td_title_order_id = tr_title.insertCell(0);
td_title_order_id.width="100";
td_title_order_id.height="18";
td_title_order_id.innerHTML="订单编号";
var td_createtime = tr_title.insertCell(1);
td_title_createtime.width="100";
td_title_createtime.height="18";
td_title_createtime.innerHTML = "下单时间";
var td_goosname = tr_title.insertCell(2);
td_title_goodsname.width = "100";
td_title_goodsname.height = "18";
td_title_goodsname.innerHTML = "商品名称";
var td_unitprice = tr_title.innsertCell(3);
td_title_unitprice.width = "100";
td_title_unitprice.height = "18";
td_title_unitprice.innerHTML = "原价";
var td_trade_price = tr_title.innsertCell(4);
td_title_trade_price.width = "100";
td_title_trade_price.height ="18";
td_title_trade_price.innerHTML = "现价";
var td_user_grade = tr_title.innsertCell(5);
td_title_user_grade.width ="100";
td_title_user_grade.height="18";
td_title_user_grade.innerHTML = "买家等级";
var td_issend =tr_title.innsertCell(6);
td_title_issend.width ="100";
td_title_issend.height ="18";
td_title_issend.innerHTML = "发货状态";
var td_shopping_number = tr_title.innsertCell(7);
td_title_shopping_number.width ="100";
td_title_shopping_number.height="18";
td_title_shopping_number.innerHTML="商品数量";
var td_totalprice = tr_title.innsertCell(8);
td_title_totalprice.width ="100";
td_title_totalprice.height="18";
td_title_totalprice.innerHTML="原价合计";
var td_trade_total = tr_title.innsertCell(9);
td_title_trade_total.width = "100";
td_title_trade_total.height = "18";
td_title_trade_total.innerHTML ="现价合计";
for(var i=0;i<array.length;i++){
var tr_content = tableObj.insertRow(i+1);
tr_content.id="tr_"+array[i].id;
tr_content.width="1000";
tr_content.height="18";
tr_content.align = "center";
var td_content_order_id = tr_content.insertCell(0);
td_content_order_id.width="100";
td_content_order_id.height="18";
td_content_order_id.innerHTML = array[i].order_id;
var td_content_createtime = tr_content.insertCell(1);
td_content_createtime.width="100";
td_content_createtime.height="18";
td_content_createtime.innerHTML = array[i].createtime;
var td_content_goosname= tr_content.insertCell(2);
td_content_goosname.width="100";
td_content_goosname.height="18";
td_content_goosname.innerHTML = array[i].goosname;
var td_content_unitprice= tr_content.insertCell(3);
td_content_unitprice.width="100";
td_content_unitprice.height="18";
td_content_unitprice.innerHTML = array[i].unitprice;
var td_content_trade_pricee= tr_content.insertCell(4);
td_content_trade_price.width="100";
td_content_trade_price.height="18";
td_content_trade_price.innerHTML = array[i].trade_price;
var td_content_user_grade= tr_content.insertCell(5);
td_content_user_grade.width="100";
td_content_user_grade.height="18";
td_content_user_grade.innerHTML = array[i].user_grade;
var td_content_issend= tr_content.insertCell(6);
td_content_issend.width="100";
td_content_issend.height="18";
td_content_issend.innerHTML = array[i].issend;
var td_content_shopping_number= tr_content.insertCell(7);
td_content_shopping_number.width="100";
td_content_shopping_number.height="18";
td_content_shopping_number.innerHTML = array[i].shopping_nunber;
var td_content_totalprice= tr_content.insertCell(9);
td_content_totalprice.width="100";
td_content_totalprice.height="18";
td_content_totalprice.innerHTML = array[i].totalprice;
var td_content_trade_total= tr_content.insertCell(9);
td_content_trade_total.width="100";
td_content_trade_total.height="18";
td_content_trade_total.innerHTML = array[i].trade_total;
}
}
谷歌浏览器老是报错:
Uncaught ReferenceError: td_title_createtime is not defined
initdevelopers_order.js:45
(anonymous function)developers_order.js:2
f.extend._Deferred.e.resolveWithjquery-1.6.2.min.js:16
e.extend.readyjquery-1.6.2.min.js:16
c.addEventListener.B
init(dataArray);
$("#d11").datepicker({
});
$("#d12").datepicker({
}); $("#orderquery").bind("click",researchEvent);
});
function researchEvent(){
var startime = $("#d11").attr("value");
var endtime = $("#d12").attr("value");
var param = {"startime":startime,"endtime":endtime,"order_id":order_id,"goodsname":goodsname,"act":"orderquery"};
$.ajax({
type:"get",
url:"queryorder_do.jsp",
data:param,
dataType:"json",
success:function(s){
if(typeof(s)!="undefined"){
alert("查询成功!");
clearTable();
init(s);
}else{
alert("查询失败!");
}
}
})
}
function init(array){
var tableObj = document.getElementById("table");
var tr_title = tableObj.insertRow(0);
tr_title.width="1000";
tr_title.height="18";
tr_title.align = "center";
var td_title_order_id = tr_title.insertCell(0);
td_title_order_id.width="100";
td_title_order_id.height="18";
td_title_order_id.innerHTML="订单编号";
var td_createtime = tr_title.insertCell(1);
td_title_createtime.width="100";
td_title_createtime.height="18";
td_title_createtime.innerHTML = "下单时间";
var td_goosname = tr_title.insertCell(2);
td_title_goodsname.width = "100";
td_title_goodsname.height = "18";
td_title_goodsname.innerHTML = "商品名称";
var td_unitprice = tr_title.innsertCell(3);
td_title_unitprice.width = "100";
td_title_unitprice.height = "18";
td_title_unitprice.innerHTML = "原价";
var td_trade_price = tr_title.innsertCell(4);
td_title_trade_price.width = "100";
td_title_trade_price.height ="18";
td_title_trade_price.innerHTML = "现价";
var td_user_grade = tr_title.innsertCell(5);
td_title_user_grade.width ="100";
td_title_user_grade.height="18";
td_title_user_grade.innerHTML = "买家等级";
var td_issend =tr_title.innsertCell(6);
td_title_issend.width ="100";
td_title_issend.height ="18";
td_title_issend.innerHTML = "发货状态";
var td_shopping_number = tr_title.innsertCell(7);
td_title_shopping_number.width ="100";
td_title_shopping_number.height="18";
td_title_shopping_number.innerHTML="商品数量";
var td_totalprice = tr_title.innsertCell(8);
td_title_totalprice.width ="100";
td_title_totalprice.height="18";
td_title_totalprice.innerHTML="原价合计";
var td_trade_total = tr_title.innsertCell(9);
td_title_trade_total.width = "100";
td_title_trade_total.height = "18";
td_title_trade_total.innerHTML ="现价合计";
for(var i=0;i<array.length;i++){
var tr_content = tableObj.insertRow(i+1);
tr_content.id="tr_"+array[i].id;
tr_content.width="1000";
tr_content.height="18";
tr_content.align = "center";
var td_content_order_id = tr_content.insertCell(0);
td_content_order_id.width="100";
td_content_order_id.height="18";
td_content_order_id.innerHTML = array[i].order_id;
var td_content_createtime = tr_content.insertCell(1);
td_content_createtime.width="100";
td_content_createtime.height="18";
td_content_createtime.innerHTML = array[i].createtime;
var td_content_goosname= tr_content.insertCell(2);
td_content_goosname.width="100";
td_content_goosname.height="18";
td_content_goosname.innerHTML = array[i].goosname;
var td_content_unitprice= tr_content.insertCell(3);
td_content_unitprice.width="100";
td_content_unitprice.height="18";
td_content_unitprice.innerHTML = array[i].unitprice;
var td_content_trade_pricee= tr_content.insertCell(4);
td_content_trade_price.width="100";
td_content_trade_price.height="18";
td_content_trade_price.innerHTML = array[i].trade_price;
var td_content_user_grade= tr_content.insertCell(5);
td_content_user_grade.width="100";
td_content_user_grade.height="18";
td_content_user_grade.innerHTML = array[i].user_grade;
var td_content_issend= tr_content.insertCell(6);
td_content_issend.width="100";
td_content_issend.height="18";
td_content_issend.innerHTML = array[i].issend;
var td_content_shopping_number= tr_content.insertCell(7);
td_content_shopping_number.width="100";
td_content_shopping_number.height="18";
td_content_shopping_number.innerHTML = array[i].shopping_nunber;
var td_content_totalprice= tr_content.insertCell(9);
td_content_totalprice.width="100";
td_content_totalprice.height="18";
td_content_totalprice.innerHTML = array[i].totalprice;
var td_content_trade_total= tr_content.insertCell(9);
td_content_trade_total.width="100";
td_content_trade_total.height="18";
td_content_trade_total.innerHTML = array[i].trade_total;
}
}
谷歌浏览器老是报错:
Uncaught ReferenceError: td_title_createtime is not defined
initdevelopers_order.js:45
(anonymous function)developers_order.js:2
f.extend._Deferred.e.resolveWithjquery-1.6.2.min.js:16
e.extend.readyjquery-1.6.2.min.js:16
c.addEventListener.B
解决方案 »
- 鼠标悬停触发事件,当悬停的时候一直触发事件
- 救助高手!onclick事件!
- 类似百度输入查询的内容并自动提示可以选择相关信息
- js与servlet结合使用问题
- javascript实现表格
- frameset框架组成的html在ie中点击右上角“关闭”按钮和点击“退出”链接的问题
- 急!!希望大家帮忙,如何实现多个页面随意浮动广告????
- 新手求助:如何用javascript实现鼠标单击时链接.asp文件?
- 可不可以通过JAVASCRIPT来运行一个批处理文件啊?
- 怎样判断鼠标对td的操作是onclick,onmouseover,还是onmouseout呀?立即给分!!!!!!!
- 【分享】魔兽技能冷却效果(希望能有更好的思路)
- 用哪个函数能得到随机数值?
var td_title_createtime = tr_title.insertCell(1);
initdevelopers_order.js:52
(anonymous function)developers_order.js:2
f.extend._Deferred.e.resolveWithjquery-1.6.2.min.js:16
e.extend.readyjquery-1.6.2.min.js:16
c.addEventListener.Bjquery-1.6.2.min.js:16
订单编号 下单时间 商品名称 原价 现价 买家等级 发货状态 商品数量 原价合计 现价合计
1 2012-05-10 undefined 20 10 2 undefined undefined 40 20
alert(array[i].goosname); //有数据吗?
td_content_issend.width="100";
td_content_issend.height="18";
td_content_issend.innerHTML = array[i].issend;
alert(array[i].issend); 这里没有值
select a.order_id,to_char(a.createtime,'yyyy-MM-dd') createtime,a.user_grade,b.goodsname,b.shopping_number,b.unitprice,b.totalprice,(case b.issend when 1 then '已经发货'when 0 then '暂未发货'end),b.trade_price,b.trade_total from orderr a, order_info b where 1 = 1 and a.order_id = b.order_id 这条SQL语句是这样的