十万火急！！！！js画表格问题有哪位大哥好心，帮我详细解释一下下面这段代码，主要是位重数据库表里取数据然后用下面这段代码一一的画出表格显示到页面

[liaojianhua888888]

js画表格问题有哪位大哥好心，帮我详细解释一下下面这段代码，主要是位重数据库表里取数据然后用下面这段代码一一的画出表格显示到页面

function reload(){
for(var a=0;a <bms.length;a++)
for(var b=0;b <shsizes.length;b++)
{
getBookmakerOdds(bms[a],shsizes[b]);

}
}
function draw(){

var sb=[];
for(var k in sds.versus){

if(!leagueData[sds.versus[k][0]]) leagueData[sds.versus[k][0]]=sds.league[sds.versus[k][0]];
alert(shsizes.length);alert(k);
var i1=false;
var osb=[];

for(var a=0;a <siz;a++){
var home=away=hgd=ih=ia=id='';
if(a <siz&&bmsts[k]&&bmsts[k][bms[a]]&&bmsts[k][bms[a]][curOddsType]){
alert(shsizes.length);alert(home);
var b=bmsts[k][bms[a]][curOddsType];
home=b[3];
away=b[4];
hgd=curOddsType==1?def.vs.handicap[b[2]]||'':b[curOddsType==2?6:2];
ih=b[6];
id=b[5];
ia=b[7];

if(!i1)i1=true;
}
osb.push(tpl_oddsbody[curOddsType].format(k,bms[a],(a%2==0?'':' bg2')+(a <siz-1?'':' la-'),home,hgd,away,ih,id,ia,
bms[a]==0?' title="'+bmsn[a]+'"':home==''?'':(' onclick="oddsdialog(this,'+k+','+bms[a]+','+curOddsType+',\''+bmsn[a]+' | '+sds.versus[k][2]+' VS '+sds.versus[k][4]+'\')" onmouseover="mouseover(this)" onmouseout="mouseout(this)" style="cursor:pointer" title="'+bmsn[a]+'"'),
home==''&&away==''&&hgd==''&&ih==''&&id==''&&ia==''?' style=display:none':'',
odds.compareInit(home,ih),odds.compareInit(hgd,id),odds.compareInit(away,ia)));
}
if(!i1)continue;
var b=sds.versus[k];
var lid=b[0];
var league=sds.league[lid];
var lcolor=league[5];
if(lcolor=='')lcolor='#00ccff';
var home_rank=b[10];
if(home_rank!='')home_rank=' <span class=rank-s>['+b[10]+'] </span>';
var away_rank=b[11];
if(away_rank!='')away_rank=' <span class=rank-s>['+b[11]+'] </span>';
sp = tpl_spoddsbody.format(k,b[9],b[6],b[7],b[8]);
sb.push(tpl_body.format(k,lcolor,lid,league[1],b[5],b[1],b[2],b[3],b[4],osb.join(''),sp,'','',home_rank,away_rank
));
alert(home);
delete osb;
}
$('oddstable').innerHTML=tpl_header.format(bmsths.join(''))+sb.join('')+' </table>';
for(var a=0;a <bms.length;a++){
getBookmakerLive(bms[a]);
}
delete bmsts;
//odds.leagueMenuInit();
live();
}
下面是cs文件里面的
if (!Page.IsPostBack)
{
int vid;
int.TryParse(Request.QueryString["vid"], out vid);
string tsql = string.Format(@"
select b.vid,c.color,c.lid,d.{0}_short 'lname',b.home_tid,f.{0} 'hname',b.away_tid,h.{0} 'aname',vs_date
from versus b
inner join league c on c.lid = b.lid
inner join lang d on d.id = c.lang_id
inner join team e on e.tid = b.home_tid
inner join lang f on f.id = e.lang_id
inner join team g on g.tid = b.away_tid
inner join lang h on h.id = g.lang_id
where b.vid = {1} and home_tid=807 and away_tid=817 and year(vs_date)=2008
order by b.vs_date", base.Lang, 382822);
DataTable SPSchedule = Func.GetDataTable(tsql);
this.JsLeague = CreateJsLeague(SPSchedule);
this.JsVersus = CreateJsVersus(SPSchedule);
//Response.Write(tsql);
tsql = string.Format(@"select DISTINCT Convert(varchar(10),b.vs_date,120) as vs_date
from versus b
inner join league c on c.lid = b.lid
inner join lang d on d.id = c.lang_id
inner join team e on e.tid = b.home_tid
inner join lang f on f.id = e.lang_id
inner join team g on g.tid = b.away_tid
inner join lang h on h.id = g.lang_id
where b.vid = {0} and home_tid=807 and away_tid=817 and year(vs_date)=2008", 382822);//vid
DataTable SPDate = Func.GetDataTable(tsql);
this.DataDiff = SetScheduleDataLink(SPDate);
//Response.Write(tsql);
//Response.Write(this.DataDiff);
}


}

protected String SetScheduleDataLink(DataTable SPDate)
{

DateTime date;
String _DataDiff = String.Empty;
if (SPDate != null)
{
DateTime now;
if (DateTime.Now.Hour > 8)
now = DateTime.Parse(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd 8:00"));
else
now = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 8:00"));
for (int i = 0; i < SPDate.Rows.Count; i++)
{
if (DateTime.TryParse(SPDate.Rows[i]["vs_date"].ToString(), out date))
{
TimeSpan span = date - now;
int Diff = (int)span.TotalDays;
_DataDiff += Diff.ToString() + ",";

}

}
}
if (_DataDiff.Length == 0)
return "0";
else
return _DataDiff.Substring(0, _DataDiff.Length - 1);


}
protected String CreateJsLeague(DataTable SPSchedule)
{
String _JsLeague = String.Empty;
if (SPSchedule != null)
{

for (int i = 0; i < SPSchedule.Rows.Count; i++)
{
_JsLeague += string.Format("{0}:['{1}','{2}','{3}']",
SPSchedule.Rows[i]["vid"],
Func.getJsString(SPSchedule.Rows[i]["lname"]),
Func.getJsString(SPSchedule.Rows[i]["lname"]),
SPSchedule.Rows[i]["color"]);


if (i < SPSchedule.Rows.Count - 1)
_JsLeague += ",\r\n";

}
} //Response.Write(_JsLeague);
return _JsLeague;
//171:['波兰甲级联赛','波兰甲',11,12,3,'#ED0002'],
}
protected String CreateJsVersus(DataTable SPSchedule)
{
//'400911':[171,1818,'冈尼克萨比利斯',2318,'克拉科维亚','11/16 23:45',,'0.75','',[27,'大部多云',9,3],'15','16']
String _JsVersus = String.Empty;
if (SPSchedule != null)
{

for (int i = 0; i < SPSchedule.Rows.Count; i++)
{

_JsVersus += string.Format("'{0}':[{1},'{2}',{3},'{4}','{5}']",
SPSchedule.Rows[i]["vid"],
SPSchedule.Rows[i]["home_tid"],
Func.getJsString(SPSchedule.Rows[i]["hname"]),
SPSchedule.Rows[i]["away_tid"],
Func.getJsString(SPSchedule.Rows[i]["aname"]),
((DateTime)SPSchedule.Rows[i]["vs_date"]).ToString("M/d HH:mm"));


if (i < SPSchedule.Rows.Count - 1)
_JsVersus += ",\r\n";

}
} //Response.Write(_JsVersus);
return _JsVersus;

}