queryhousesaleform.aspx.cs

一个房屋中介系统的源码

//文件名：QueryHouseSaleForm.aspx.cs
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 HouseManage_QueryHouseSaleForm : System.Web.UI.Page
{
    private static string MySQL = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        string MyForbidString = Session["MyForbid"].ToString();
        if (MyForbidString.IndexOf("B3") > 1)
        {
            Server.Transfer("~/SystemManage/AllErrorHelp.aspx");
        }
        if (!IsPostBack)
        {
            String MySQLConnectionString = ConfigurationManager.ConnectionStrings["MyHouseDBConnectionString"].ConnectionString;
            string MySQL = "Select * From 房源参数 Where 自编号='CQ001'";
            SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
            MyConnection.Open();
            DataTable MyHouseTable = new DataTable();
            SqlDataAdapter MyAdapter = new SqlDataAdapter(MySQL, MyConnection);
            MyAdapter.Fill(MyHouseTable);
            string MyName = "城区";
            string MyValue = MyHouseTable.Rows[0][MyName].ToString();
            String[] MyPayData = MyValue.Split(new char[1] { '、' });
            foreach (String MyString in MyPayData)
            {
                this.DropDownList1.Items.Add(MyString);
            }
            MyName = "装修";
            MyValue = MyHouseTable.Rows[0][MyName].ToString();
            String[] MyDecData = MyValue.Split(new char[1] { '、' });
            foreach (String MyString in MyDecData)
            {
                this.DropDownList2.Items.Add(MyString);
            }
            if (MyConnection.State == ConnectionState.Open)
            {
                MyConnection.Close();
            }
        } 
    }
    protected void Button1_Click(object sender, EventArgs e)
    {//查询可售房源
        DataTable MyQueryTable = new System.Data.DataTable();
        SqlConnection MyConnection = new SqlConnection();
        MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings["MyHouseDBConnectionString"].ConnectionString;
        MyConnection.Open();
        int My电梯 = this.CheckBox1.Checked?1 : 0;
        MySQL = "SELECT * FROM 可售房源视图 WHERE ('" +
           this.TextBox1.Text + "' BETWEEN 委托日期 AND 截止日期) AND (所在城区='" +
           this.DropDownList1.SelectedValue.ToString() + "') AND (装修级别='" +
           this.DropDownList2.SelectedValue.ToString() + "') AND (电梯="+My电梯 + 
           ") AND ( 房 BETWEEN "+this.TextBox4.Text + " AND " + 
           this.TextBox5.Text +") AND (建筑面积 BETWEEN " + this.TextBox6.Text +" AND " + 
           this.TextBox7.Text + ") AND (价格 BETWEEN " + this.TextBox8.Text + " AND " +
           this.TextBox9.Text + ")";
        SqlDataAdapter MyAdapter = new SqlDataAdapter(MySQL, MyConnection);
        MyAdapter.Fill(MyQueryTable);
        this.GridView1.DataSource= MyQueryTable;
        this.GridView1.DataBind();
        if (MyConnection.State == ConnectionState.Open)
        {
            MyConnection.Close();
        }
    }
    public string MyPrintSQL
    {//设置要传递到打印页的数据
        get
        {
            return MySQL;
        }
    }
    public String MyPrintDate
    {//设置要传递到打印页的数据
        get
        {
            return "当前日期:"+DateTime.Now.ToShortDateString()+" 查询条件:所在城区：" +
           this.DropDownList1.SelectedValue.ToString() +" 装修级别：" +
           this.DropDownList2.SelectedValue.ToString() + " 房型："+this.TextBox4.Text + "房至" + 
           this.TextBox5.Text +"房 建筑面积：" + this.TextBox6.Text +"至" + 
           this.TextBox7.Text + "m2 价格：" + this.TextBox8.Text + "至" +
           this.TextBox9.Text + "元";
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {//打印可售房源
        Server.Transfer("~/HouseManage/QueryHouseSalePrint.aspx");
    }
}