|
4 公交查询系统应用程序设计（部分） 4.1查询模块的功能实现 paper51.com
4.1.1按线路查 http://www.paper51.com
1．界面如图4.1.1所示： copyright paper51.com
图4.1.1 线路查询 paper51.com 2.代码如下： 内容来自论文无忧网 www.paper51.com public stringline=""; 内容来自论文无忧网 www.paper51.com private void Page_Load(object sender, System.EventArgs e) paper51.com { paper51.com stringnum=Request.QueryString["num"].ToString(); paper51.com SqlConnection con=DB.createConnection(); paper51.com con.Open(); http://www.paper51.com SqlCommand cmdCheliang=newSqlCommand("select * from 车辆表 where 车次="+num,con); 内容来自论文无忧网 www.paper51.com SqlDataReadersdrCheliang=cmdCheliang.ExecuteReader(); http://www.paper51.com
this.dgCheliang.DataSource=sdrCheliang; http://www.paper51.com this.dgCheliang.DataBind(); paper51.com sdrCheliang.Close(); 内容来自论文无忧网 www.paper51.com string cmdstring=""; 内容来自www.paper51.com int timetemp=Convert.ToInt32(DateTime.Now.Month); 内容来自www.paper51.com if((timetemp>3)&&(timetemp<9)) 内容来自论文无忧网 www.paper51.com
{ 内容来自www.paper51.com cmdstring="select首班时间,末班时间from 夏季发车时间表 where 车次="+num; 内容来自www.paper51.com } copyright paper51.com else http://www.paper51.com
{ 内容来自论文无忧网 www.paper51.com
cmdstring="select首班时间,末班时间from 冬季发车时间表 where 车次="+num; 内容来自www.paper51.com
} copyright paper51.com
SqlCommand cmdsj=new SqlCommand(cmdstring,con); http://www.paper51.com SqlDataReadersdrsj=cmdsj.ExecuteReader(); http://www.paper51.com while(sdrsj.Read()) http://www.paper51.com { http://www.paper51.com string linetemp1=sdrsj["首班时间"].ToString(); 内容来自www.paper51.com string linetemp2=sdrsj["末班时间"].ToString(); paper51.com line+="<fontsize=3>(首班时间为："+linetemp1+" "; copyright paper51.com line+="末班时间为："+linetemp2+")</font><br>"; 内容来自论文无忧网 www.paper51.com } paper51.com sdrsj.Close(); http://www.paper51.com SqlCommand cmd=new SqlCommand("select* from 公交车线路表 where 车次="+num+"order by 次序ASC",con); 内容来自www.paper51.com SqlDataReadersdr=cmd.ExecuteReader(); 内容来自论文无忧网 www.paper51.com try 内容来自论文无忧网 www.paper51.com { paper51.com
while(sdr.Read()) 内容来自www.paper51.com { paper51.com line+=sdr["站名"].ToString(); copyright paper51.com line=line.Replace(sdr["站名"].ToString(),"<font color=red>"+sdr["站名"].ToString()+"</font>"); copyright paper51.com
line+="-->"; 内容来自www.paper51.com } http://www.paper51.com } copyright paper51.com
finally 内容来自www.paper51.com { copyright paper51.com
sdr.Close(); paper51.com con.Close(); http://www.paper51.com } http://www.paper51.com
int i; 内容来自www.paper51.com i=Convert.ToInt32(line.Length); paper51.com
line=line.Substring(0,i-3); paper51.com } paper51.com |