三层架构源代码

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class domesticselecet : System.Web.UI.Page
{
    public static string dt;
    public static string week;
    protected void Page_Load（object sender EventArgs e）
    {
        this.Label1.Text = DateTime.Now.ToString（“T“）;

         startdate_box.Attributes.Add（“onfocus“ “javascript:calendar（）“）;

        backdate_box.Attributes.Add（“onfocus“ “javascript:calendar（）“）;

        string[] selectinf = { “国内机票实时查询“ “国外机票“ “航班类型：“ “出发城市：“ “到达城市：“ “出发日期：“ “返程日期：“ };
        dmselect.Text = selectinf[0];
        extra_table.Text = selectinf[1];
        startcity.Text = selectinf[3];
        arrivelcity.Text = selectinf[4];
        startdate.Text = selectinf[5];
        backdate.Text = selectinf[6];

        date.Text = DateTime.Now.ToLongDateString（）;
        dt = DateTime.Today.DayOfWeek.ToString（）;
        switch （dt）
        {
            case “Monday“:
                week = “星期一“;
                break;
            case “Tuesday“:
                week = “星期二“;
                break;
            case “Wednesday“:
                week = “星期三“;
                break;
            case “Thursday“:
                week = “星期四“;
                break;
            case “Friday“:
                week = “星期五“;
                break;
            case “Saturday“:
                week = “星期六“;
                break;
            case “Sunday“:
                week = “星期日“;
                break;
        }
        weekdate.Text = week;

        this.bind（）;

    }

    //private void timer1_Tick（object sender EventArgs e）
    //{
    //   this.Label1.Text = DateTime.Now.ToString（）;
        
    // }
    private void bind（）
    {
        SqlConnection ts = new SqlConnection（System.Configuration.ConfigurationManager.AppSettings[“ts“]）;
        //打开数据库连接
        ts.Open（）;
        //设置SQL语句，查询出所有航班信息
        SqlDataAdapter sda = new SqlDataAdapter（“select * from FlightInformation order by id desc“ ts）;    
        //创建数据集
        DataSet ds = new DataSet（）;
        //装载数据集
        sda.Fill（ds “FlightInformation“）;
        //数据绑定
        GridView1.DataSource = ds.Tables[“FlightInformation“];
        //将航班信息id设置为GridView主键
        GridView1.DataKeyNames = new string[] { “id“ };   
        GridView1.DataBind（）;
    }
    //点击了查询按钮
    protected void select_button_Click（object sender ImageClickEventArgs e）
    {
        string start = this.startcity_list.Text;
        
        string arrived = this.arrivelcity_box.Text;

        string startdate_box = this.startdate_box.Text;
        
        if （arrivelcity_box.Text == ““）
        {
            Response.Write（“<

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2014-02-24 23:14  TicketSaler
     文件        2223  2012-08-21 10:43  TicketSaler51Aspx源码必读.txt
     目录           0  2014-02-23 15:07  TicketSalerApp_Code
     文件       22476  2012-08-21 10:43  TicketSalerApp_CodeDataSet1.xsd
     文件         859  2012-08-21 10:43  TicketSalerApp_CodeDataSet1.xss
     文件        2404  2012-08-21 10:43  TicketSalerApp_Codeform.cs
     目录           0  2014-02-24 10:15  TicketSalerackwork
     文件       17906  2014-02-23 21:55  TicketSalerackworkAddFlightInfor.aspx
     文件        2734  2014-02-23 21:47  TicketSalerackworkAddFlightInfor.aspx.cs
     文件        4774  2014-02-23 17:43  TicketSalerackworkAddUser.aspx
     文件        1778  2014-02-23 17:42  TicketSalerackworkAddUser.aspx.cs
     文件        4564  2012-08-21 10:43  TicketSalerackworkAlterPW.aspx
     文件        1644  2014-02-23 17:54  TicketSalerackworkAlterPW.aspx.cs
     文件        2383  2014-02-23 21:13  TicketSalerackworkDeleteUser.aspx
     文件        2913  2014-02-23 21:14  TicketSalerackworkDeleteUser.aspx.cs
     文件        4886  2014-02-24 10:15  TicketSalerackworkDetaildeSuggestion.aspx
     文件        1453  2012-08-21 10:43  TicketSalerackworkDetaildeSuggestion.aspx.cs
     文件       13079  2014-02-24 09:37  TicketSalerackworkDetailedInfor.aspx
     文件        3927  2014-02-24 09:59  TicketSalerackworkDetailedInfor.aspx.cs
     文件        2741  2012-08-21 10:43  TicketSalerackworkHomePage.aspx
     文件        1705  2012-08-21 10:43  TicketSalerackworkHomePage.aspx.cs
     文件        4072  2014-02-23 16:41  TicketSalerackworkLogin.aspx
     文件        2215  2014-02-23 15:46  TicketSalerackworkLogin.aspx.cs
     文件        2790  2014-02-24 09:48  TicketSalerackworkLookOrder.aspx
     文件        4340  2014-02-24 10:10  TicketSalerackworkLookOrder.aspx.cs
     文件        2439  2014-02-24 10:14  TicketSalerackworkLookSug.aspx
     文件        2630  2012-08-21 10:43  TicketSalerackworkLookSug.aspx.cs
     文件        5381  2014-02-24 08:55  TicketSalerackworkTreeView.aspx
     文件         722  2014-02-23 17:01  TicketSalerackworkTreeView.aspx.cs
     文件        2393  2014-02-24 07:42  TicketSalerackworkUpDateFlight.aspx
     文件        2436  2012-08-21 10:43  TicketSalerackworkUpDateFlight.aspx.cs
............此处省略82个文件信息