goodsdetail.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 goodsDetail : System.Web.UI.Page
{
    dataOperate do1 = new dataOperate();
    int goodsID = 2;
    myPaimai.timeJudge tj;
    //Goods 的信息
    public string images = "";
    public string nameOfGoods = "";
    public string priceNow="";
    public string startPrice="";
    public string leastAdd = "";
    public string manner = "";
    public string startTime = "";
    public string endTime = "";
    public string timesClick = "";
    public string timesBid = "";
    public string catal = "";
    public string description = "";
    public string imagePath = "";
    public string state = "";
    public string scale = "";
    public static string sellUserID = "";
    public string lingxian = "";


    //拍卖人信息
    public string nickName = "";
    public string realName = "";
    public string detailAddress = "";
    public string connectNO = "";
    public string imagePathSeller = "";
    public string timesLogin = "";
    public string credit = "";
    public string scores = "";
    public string email = "";
    public string registerTime = "";
    public string companyName = "";
    public string addressOfCompany = "";
    public string userCatal = "";
    protected void Page_Load(object sender, EventArgs e)
    {
       // if (!IsPostBack)
        {
            goodsID =Convert.ToInt32(Request.QueryString["goodsID"].ToString());
            tj = new timeJudge(goodsID.ToString());
            if (tj.isEnd()&&tj.isNeedModify())
            {
                    tj.infoModify();
            }
            refresh();
        }
        if (Session["userID"] == null)
        {
            plHasResistered.Visible = false;
            plHasNotResistered.Visible = true;
        }
        else
        {   plHasResistered.Visible =true;
            plHasNotResistered.Visible =false;
        }
    }
    protected void initialDlBid()
    {
        DataView dvBid = do1.getDataView("SELECT * FROM bidOfGoods where goodsID="+goodsID);
       // dlRecord.DataSource = dvBid;
      //  dlRecord.DataBind();
    }
    protected void initialSeller()
    {
        DataView dvSeller = do1.getDataView("select * from userPaimai where userID='"+sellUserID+"'");
        DataRow drSeller = dvSeller.Table.Rows[0];
        userCatal = drSeller[1].ToString().Trim();
        if (userCatal == "1")
        {
            userCatal = "个人";
        }
        else 
        {
            userCatal = "公司";
        }
        companyName = drSeller[2].ToString().Trim();
        addressOfCompany = drSeller[3].ToString().Trim();
        realName = drSeller[5].ToString().Trim();
        detailAddress = drSeller[8].ToString().Trim();
        connectNO = drSeller[9].ToString().Trim();
        imagePathSeller = drSeller[10].ToString().Trim();
        imagePathSeller = "upLoad\\"+HttpUtility.UrlDecode(imagePathSeller, System.Text.Encoding.Default);
        timesLogin = drSeller[11].ToString().Trim();
        credit = drSeller[12].ToString().Trim();
        scores = drSeller[13].ToString().Trim();
        email = drSeller[14].ToString().Trim();
        nickName = drSeller[15].ToString().Trim();
        registerTime = drSeller[18].ToString().Trim();
    }
    protected void initialGoods()
    {
        DataView dvGoods = do1.getDataView("SELECT * FROM goods,paimaiManner,catal Where goods.manner=paimaiManner.mannerID AND goods.catalID=catal.ID AND goodsID="+goodsID);
        DataRow dr=dvGoods.Table.Rows[0] as DataRow;
        nameOfGoods=dr[1].ToString().Trim();
        description = dr[2].ToString().Trim();
        startPrice = dr[3].ToString().Trim();
        startTime = dr[4].ToString().Trim(); //startTime = startTime.Substring(0, startTime.LastIndexOf('.') + 1);
        endTime = dr[5].ToString().Trim(); //endTime = endTime.Substring(0, startTime.LastIndexOf('.') + 1);
        imagePath =dr[6].ToString().Trim();
        timesClick = dr[7].ToString().Trim();
        timesBid = dr[8].ToString().Trim();
        priceNow = dr[9].ToString().Trim();
        state = dr[13].ToString().Trim();
        scale = dr[15].ToString().Trim();
        leastAdd = dr[16].ToString().Trim();
        sellUserID = dr[10].ToString().Trim();
        manner = dr[18].ToString().Trim();
        catal = dr[20].ToString().Trim();
        lingxian =do1.executeScalar("select TOP 1 userID from bidOfGoods WHERE goodsID="+goodsID+" ORDER BY bidTime DESC").ToString();
        //绑定时分秒 
    }
    protected void initialImages()
    {
        images = "";
        DataView dvImages = do1.getDataView("SELECT top 5 * FROM images WHERE goodsID=" + goodsID+" ORDER BY imageID ASC");
        images += "<img onmouseover=\"javascript:this.className='clear';on_mouseover(this)\" onmouseout=\"javascript:this.className='blur'\" class=\"blur\" src=\""+imagePath+"\"  width=\"30px\" height=\"30px\"/>";
        foreach(DataRow tr in dvImages.Table.Rows)
        {
            images += "<img onmouseover=\"javascript:this.className='clear';on_mouseover(this)\" onmouseout=\"javascript:this.className='blur'\" class=\"blur\" src=\"" +tr[2].ToString().Trim()+ "\"  width=\"30px\" height=\"30px\"/>";
        }
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowIndex == 0)
        {
            e.Row.Cells[1].ForeColor = System.Drawing.Color.Green;
            e.Row.Cells[2].ForeColor = System.Drawing.Color.Green;
            e.Row.Cells[3].ForeColor = System.Drawing.Color.Green;
        }
        else
        {
            e.Row.Cells[3].ForeColor = System.Drawing.Color.Red;

        }
    }
    protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType != DataControlRowType.Header)
        {
            e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#b3c9e6';");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c;");
        }
    }
    protected void GridView2_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType != DataControlRowType.Header)
        {
            e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#b3c9e6';");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c;");
        }
    }

    protected void btnRefRecord_Click(object sender, EventArgs e)
    {
        refresh();
        Response.Write("<script language='javascript'>location.href='#chujia';</script>");

    }
    protected void refresh()
    { 
        initialGoods();
        initialSeller();
        initialImages();
        initialDlBid();
        SqlDataSource1.DataBind();
        GridView1.DataBind();

    }
    protected void btnAssess_Click1(object sender, EventArgs e)//添加评论
    {
        string assUser = "";
        if (Session["userID"] != null)
        {
            assUser = (string)Session["userID"];
        }
        else//未登录，匿名
        {
            assUser ="匿名";
        }
        string assContent = TextBox1.Text;
        do1.setParameter("@goodsID",goodsID);
        do1.setParameter("@userID",assUser);
        do1.setParameter("@conOfAssess",assContent);
        do1.setParameter("@assessTime",DateTime.Now.ToString());
        do1.executeNonQuery("INSERT INTO assess(goodsID,userID,conOfAssess,assessTime) VALUES(@goodsID,@userID,@conOfAssess,@assessTime)");
        GridView2.DataBind();
    }
    protected void btnLogin_Click(object sender, EventArgs e)//登录
    {
        string userID = tbUser.Text;
        string password = tbPassword.Text;
        if (myPaimai.userOperate.register(userID, password))//登录成功
        {
            Head1.user.Text = "<font size=2 color=green><b>" + userID + "</b></font>";
            plHasResistered.Visible = true;
            plHasNotResistered.Visible = false;
            Response.Write("<script language='javascript'>location.href='#bid';</script>");

        }
    }

    protected void Button1_Click(object sender, EventArgs e)//竞拍
    {
        try
        {
            if (tj.isEnd() && tj.isNeedModify())//时间过了
            {
                tj.infoModify();
                Response.Write("<script language='javascript'>alert('对不起，竞拍已结束！');location.href='#bid';</script>");
            }
            else
            {
                string ID;
                float priceCur;
                DataView dvUp = do1.getDataView("SELECT TOP(1) ID,myPrice FROM bidOfGoods WHERE goodsID=" + goodsID + " ORDER BY bidTime DESC");
                DataRow drUp = dvUp.Table.Rows[0];
                ID = drUp[0].ToString().Trim();
                priceCur = Convert.ToSingle(drUp[1].ToString());
                if (priceCur >= Convert.ToSingle(tbBidPrice.Text))//判断价格是否高于最高价
                {
                    Response.Write("<script language='javascript'>alert('对不起，您的出价必须高于现价！');location.href='#bid';</script>");
                }
                else
                {
                    //更新出价记录表
                    do1.executeNonQuery("UPDATE bidOfGoods SET bidState='出局' WHERE ID=" + ID);
                    do1.setParameter("@goodsID", goodsID);
                    do1.setParameter("@userID", (string)Session["userID"]);
                    do1.setParameter("@myPrice", Convert.ToSingle(tbBidPrice.Text));
                    do1.setParameter("@bidTime", DateTime.Now);
                    do1.setParameter("@bidState", "领先");
                    do1.executeNonQuery("INSERT INTO bidOfGoods(goodsID,userID,myPrice,bidtime,bidState) VALUES(@goodsID,@userID,@myPrice,@bidTime,@bidState)");
                   //更新物品的最高价
                    do1.executeNonQuery("UPDATE goods SET hightestPrice=@myPrice WHERE goodsID=" + goodsID);

                    string mesToSeller = "<strong class='red'>" +sellUserID.Trim() + "</strong> 您好，您对拍品【" + nameOfGoods.Trim() + "】成功得进行了竞价。<br/>您"+
                             "以" + tbBidPrice.Text.ToString() + scale + "的价格参与竞拍了次拍品。<a href='goodsDetail.aspx?goodsID=" + goodsID + "' class='link1'>查看请点击...</a>";
                    do1.setParameter("@fromUserID", "系统");
                    do1.setParameter("@title", "系统通知");
                    do1.setParameter("@generateTime", DateTime.Now.ToString());
                    do1.setParameter("@contOfMessage", mesToSeller);
                    do1.setParameter("@bidUserID",Session["userID"].ToString() );
                    do1.executeNonQuery("INSERT INTO shortMessage(fromUserID,title,generateTime,contOfMessage,userID) VALUES(@fromUserID,@title,@generateTime,@contOfMessage,@bidUserID)");

                    refresh();
                    Response.Write("<script language='javascript'>alert('恭喜，竞价成功！');location.href='#chujia';</script>");
                 }
            }
        }
        catch (Exception ex)
        {
            Response.Write(ex.ToString());
        }
    }
    protected void otherOfOwner_ServerClick(object sender, EventArgs e)
    {
        string sql = " AND goods.sellUserID='"+sellUserID+"'";
        sql = Convert.ToBase64String(System.Text.UnicodeEncoding.Unicode.GetBytes(sql)).Replace(" ", "+");
        Response.Redirect("~/displayGoods.aspx?sql=" + sql);
    }
}