displaygoods.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 displayGoods : System.Web.UI.Page
{
    public static int currentPage = 1;
    public static int goodsCount;
    dataOperate do1 = new dataOperate();
    public string strSQL = "";//"SELECT * FROM goods,paimaiManner Where goods.manner=paimaiManner.mannerID";
    public string strSQLCount = "SELECT COUNT(*) FROM goods,paimaiManner Where goods.manner=paimaiManner.mannerID";
    protected void Page_Load(object sender, EventArgs e)
    {
        string strParam = "";
        if (Request.QueryString["sql"] != null)
        {
            strParam = System.Text.UnicodeEncoding.Unicode.GetString(Convert.FromBase64String(Request.QueryString["sql"].ToString().Replace("+", " ")));
            SqlDataSource1.SelectCommand += strParam;
        }

        GridView1.DataBind();
        if (!IsPostBack)
        {

            initialButton();
            bindDdlPage();
            bindDll();
        }
        goodsCount = (int)do1.executeScalar(strSQLCount + strParam);
    }
    protected void initialButton()
    {
        currentPage = 1;
        if (GridView1.PageCount == 0)
        {
            Button1.Enabled = false;
            Button2.Enabled = false;
            Button3.Enabled = false;
            Button4.Enabled = false;
            currentPage = 0;
        }
        else if (GridView1.PageCount == 1)
        {
            Button1.Enabled = true;
            Button2.Enabled = false;
            Button3.Enabled = false;
            Button4.Enabled = true;
        }
        else
        {
            Button1.Enabled = true;
            Button2.Enabled = false;
            Button3.Enabled = true;
            Button4.Enabled = true;
        }
        //绑定下拉菜单

    }
    protected void bindDll()
    {
        DropDownList2.DataSource = do1.getDataView("SELECT * FROM paimaiManner");
        DropDownList2.DataTextField = "mannerName";
        DropDownList2.DataValueField = "mannerID";
        DropDownList2.DataBind();
        ListItem li = DropDownList2.Items[0];
        ListItem li2 = new ListItem(li.Text, li.Value);
        li.Text = "请选择拍卖方式..."; li.Value = "-1";
        DropDownList2.Items.Add(li2);

        DropDownList3.DataSource = do1.getDataView("SELECT * FROM catal");
        DropDownList3.DataTextField = "catalName";
        DropDownList3.DataValueField = "ID";
        DropDownList3.DataBind();
        ListItem lii = DropDownList3.Items[0];
        ListItem lii2 = new ListItem(lii.Text, lii.Value);
        lii.Text = "请选择拍品种类..."; lii.Value = "-1";
        DropDownList3.Items.Add(lii2);
    }
    protected void bindDdlPage()//绑定下拉菜单数据
    {
        DropDownList1.Items.Clear();
        int count = GridView1.PageCount;
        if (DropDownList1.Items.Count <= 0)
        {
            for (int i = 1; i <= count; i++)
            {
                DropDownList1.Items.Add(new ListItem("第" + i + "页", i.ToString()));
            }
        }
    }
    protected void on_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType != DataControlRowType.Header)
        {
            e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='lightblue';");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c;");
        }
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)//首页
    {
        GridView1.PageIndex = 0;
        currentPage = 1;
        Button2.Enabled = false;
        if (GridView1.PageCount == 1)
        {
            Button3.Enabled = false;
        }
        else
        {
            Button3.Enabled = true;
        }

        Button4.Enabled = true;
    }

    protected void Button2_Click(object sender, EventArgs e)//上一页
    {
        GridView1.PageIndex = GridView1.PageIndex - 1;
        Button3.Enabled = true;
        currentPage--;
        if (GridView1.PageIndex == 0)
        {
            Button2.Enabled = false;
        }
    }

    protected void Button3_Click(object sender, EventArgs e)//下一页
    {
        GridView1.PageIndex = GridView1.PageIndex + 1;
        Button2.Enabled = true;
        currentPage = currentPage + 1;
        if (GridView1.PageIndex == (GridView1.PageCount - 1))
        {
            Button3.Enabled = false;
        }
    }

    protected void Button4_Click(object sender, EventArgs e)//尾页
    {
        GridView1.PageIndex = GridView1.PageCount - 1;
        currentPage = GridView1.PageCount;
        if (GridView1.PageCount == 1)
        {
            Button2.Enabled = false;
        }
        else
        {
            Button2.Enabled = true;
        }
        Button3.Enabled = false;
    }

    protected void GridView1_DataBound(object sender, EventArgs e)
    {
    }


    protected void on_SelectIndexChanged(object sender, EventArgs e)//下拉菜单选择页码
    {
        int selectIndex = Convert.ToInt32(DropDownList1.Items[DropDownList1.SelectedIndex].Value);
        if (selectIndex == 1)
        {
            Button2.Enabled = false;
            Button3.Enabled = true;
            GridView1.PageIndex = 0;
        }
        else if (selectIndex == GridView1.PageCount)
        {
            Button2.Enabled = true;
            Button3.Enabled = false;
            GridView1.PageIndex = selectIndex - 1;
        }
        else
        {
            Button2.Enabled = true;
            Button3.Enabled = true;
            GridView1.PageIndex = selectIndex - 1;
        }
        currentPage = selectIndex;
    }

    protected void TextBox2_TextChanged(object sender, EventArgs e)
    {

    }
    protected void Button5_Click(object sender, EventArgs e)//搜索事件
    {
        // strSQL = "SELECT * FROM goods,paimaiManner Where goods.manner=paimaiManner.mannerID";
        // strSQLCount = "SELECT COUNT(*) FROM goods,paimaiManner Where goods.manner=paimaiManner.mannerID";            
        if (DropDownList2.SelectedIndex != 0)
        {
            strSQL = strSQL + " AND goods.manner=" + DropDownList2.SelectedValue;
        }
        if (DropDownList3.SelectedIndex != 0)
        {
            strSQL = strSQL + " AND goods.catalID=" + DropDownList3.SelectedValue;
        }
        if (TextBox2.Text != "填写拍卖人用户名...")
        {
            strSQL = strSQL + " AND goods.sellUserID='" + TextBox2.Text + "'";
        }
        if (TextBox3.Text != "填写关键字...")
        {
            strSQL = strSQL + " AND goods.nameOfGoods LIKE '%" + TextBox3.Text + "%'";
        }
        Response.Redirect("~/displayGoods.aspx?sql=" + Convert.ToBase64String(System.Text.UnicodeEncoding.Unicode.GetBytes(strSQL)).Replace(" ", "+"));
    }
    protected void Login_Click(object sender, EventArgs e)
    {
        string userID = UserName.Text;
        string password = Password.Text;
        if (myPaimai.userOperate.register(userID, password))
        {
            Head1.user.Text = "<font size=2 color=green><b>" + userID + "</b></font>";
        }
    }
}