seniorsearch.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 myPaimai;
public partial class seniorSearch : System.Web.UI.Page
{
    string strSQL = "";
    dataOperate do1 = new dataOperate();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindDll();
        }
    }

    protected void btnSearch_Click(object sender, EventArgs e)
    {


        if (ddlManner.SelectedIndex != 0)
        { 
          strSQL+=" AND goods.manner='"+ddlManner.SelectedValue.ToString()+"'";
        }


        if (ddlCatal.SelectedIndex != 0)
        {
          strSQL += " AND goods.catalID='" +ddlCatal.SelectedValue.ToString() + "'";
        }


        if (tbStartPrice.Text != "请填写起拍价...")
        {
            if (rbHigher.Checked)
            {
                strSQL += " AND goods.startPrice>=" + tbStartPrice.Text;
            }
            else 
            {
                strSQL += " AND goods.startPrice<=" + tbStartPrice.Text;
            }
        }
       
        if (tbFinishTime.Text != "请填写结束时间...")
        {
            if (rbEarlier.Checked)
            {
                strSQL += " AND datediff(day,goods.endTime,'" + tbFinishTime.Text + "')>=0";
            }
            else 
            {
                strSQL += " AND datediff(day,goods.endTime,'" + tbFinishTime.Text + "')<0";

            }
        }
       
        if (tbBidTimes.Text != "请填写竞拍次数...")
        {
            if(rbLess.Checked)
            {
                strSQL += " AND goods.numBid<"+tbBidTimes.Text;
            }
            else

            {
                strSQL += " AND goods.numBid>" + tbBidTimes.Text;

            }
        }


        if (RadioButton1.Checked)
        {
            strSQL += " AND goods.state='拍卖中'";
        }
        else if(RadioButton2.Checked)
        {
            strSQL += " AND goods.state='已结束'";

        }


        if (tbUserID.Text != "请填写拍卖人用户名...")
        { 
          strSQL+=" AND goods.sellUserID like '%"+tbUserID.Text+"%'";
        }

        if (tbKeyWords.Text != "请填写关键字...")
        {
            string[] strs = tbKeyWords.Text.Split(' ');
            foreach (string s in strs)
            {
                if (s == strs[0])
                {
                    strSQL += " AND (goods.nameOfGoods like '%" + s + "%'";
                }
                else
                {
                    strSQL += " or goods.nameOfGoods like '%" + s + "%'";
                }
            }
            strSQL+=")";
        }

        Response.Redirect("~/displayGoods.aspx?sql=" + Convert.ToBase64String(System.Text.UnicodeEncoding.Unicode.GetBytes(strSQL)).Replace(" ", "+"));
    }
    protected void bindDll()
    {
        ddlManner.DataSource = do1.getDataView("SELECT * FROM paimaiManner");
        ddlManner.DataTextField = "mannerName";
        ddlManner.DataValueField = "mannerID";
        ddlManner.DataBind();
        ListItem li = ddlManner.Items[0];
        ListItem li2 = new ListItem(li.Text, li.Value);
        li.Text = "请选择拍卖方式..."; li.Value = "-1";
        ddlManner.Items.Add(li2);

        ddlCatal.DataSource = do1.getDataView("SELECT * FROM catal");
        ddlCatal.DataTextField = "catalName";
        ddlCatal.DataValueField = "ID";
        ddlCatal.DataBind();
        ListItem lii = ddlCatal.Items[0];
        ListItem lii2 = new ListItem(lii.Text, lii.Value);
        lii.Text = "请选择拍品种类..."; lii.Value = "-1";
        ddlCatal.Items.Add(lii2);
    }
}