当前文件： ChePiaoGuanLi/WebForm/Cxpj2.aspx.cs[1K，2009-6-12 11:35:13]，打开代码结构图

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Text;
12
13public partial class WebForm_Cxpj2 : System.Web.UI.Page
14...{
15    bool isfirst = true;
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18
19    }
20    protected void Button1_Click(object sender, EventArgs e)
21    ...{
22        StringBuilder sql = new StringBuilder("SELECT * FROM [unbuy] ");
23        if (CheckBoxList1.Items[0].Selected)
24            if (isfirst) ...{
25                sql.Append("WHERE [车次编号]='" + TextBox1.Text + "'");
26                isfirst = false;
27            } else
28                sql.Append(" or [车次编号]='" + TextBox1.Text + "'");
29        if (CheckBoxList1.Items[1].Selected)
30            if (isfirst) ...{
31                sql.Append("WHERE [发车地点]='" + TextBox2.Text + "'");
32                isfirst = false;
33            } else
34                sql.Append(" or [发车地点]='" + TextBox2.Text + "'");
35        if (CheckBoxList1.Items[2].Selected)
36            if (isfirst) ...{
37                sql.Append("WHERE [目的地点]='" + TextBox3.Text + "'");
38                isfirst = false;
39            } else
40                sql.Append(" or [目的地点]='" + TextBox3.Text + "'");
41        if (CheckBoxList1.Items[3].Selected)
42            if (isfirst) ...{
43                sql.Append("WHERE [发车时间]='" + TextBox4.Text + "'");
44                isfirst = false;
45            } else
46                sql.Append(" or [发车时间]='" + TextBox4.Text + "'");
47        SqlDataSource1.SelectCommand = sql.ToString();
48        DataBind();
49    }
50}
51