timejudge.cs

拍卖系统

using System;
using System.Data;
using System.Configuration;
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;

/// <summary>
/// timeJudge 的摘要说明
/// </summary>
namespace myPaimai
{
    public class timeJudge
    {
        string goodsID = "";
        myPaimai.dataOperate do1;
        DateTime dt;
        DateTime now = DateTime.Now;
        static string userID;
        static string sellUserID;
        static float priceCurrent;
        static string scale;

        public timeJudge(string goodsID)
        {
            this.goodsID = goodsID;
            do1 = new myPaimai.dataOperate();
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }

        public bool isNeedModify()
        {
            try
            {
                if (do1.executeScalar("SELECT state FROM goods WHERE goodsID=" + goodsID).ToString().Trim()== "已结束")
                    return false;
                else
                    return true;
            }
            catch(Exception e)
            {
                HttpContext.Current.Response.Write(e.ToString());
                return false;
            }
        }

        public bool isEnd()
        {
            try
            {
                DataView dv1=do1.getDataView("SELECT endTime,sellUserID,scale FROM goods WHERE goodsID=" + goodsID);
                DataRow dr1=dv1.Table.Rows[0];
                dt=(DateTime)dr1[0];
                sellUserID =dr1[1].ToString().Trim();
                scale = dr1[2].ToString().Trim();
            }
            catch (Exception e)
            {
                HttpContext.Current.Response.Write(e.ToString());
            }
            if (dt.CompareTo(now) <= 0)
                return true;
            else
                return false;
        }


        public void infoModify()
        {
            modifyGoods();
            modifyBidRecord();
            modifyMes();
        }


        public void modifyGoods()
        {
            try
            {
                priceCurrent = Convert.ToSingle(do1.executeScalar("SELECT hightestPrice FROM goods WHERE goodsID=" + goodsID));
                do1.setParameter("@lastPrice", priceCurrent);
                do1.setParameter("@state", "已结束");
                do1.executeNonQuery("UPDATE goods SET lastPrice=@lastPrice,state=@state WHERE goodsID=" + goodsID);
            }
            catch (Exception e)
            {
                HttpContext.Current.Response.Write(e.ToString());
            }
        }


        public void modifyBidRecord()
        {
            string ID;
            try
            {
                DataView dv = do1.getDataView("SELECT TOP(1) ID,userID,myPrice FROM bidOfGoods WHERE goodsID=" + goodsID + " ORDER BY bidTime DESC");
                DataRow dr = dv.Table.Rows[0];
                ID = dr[0].ToString().Trim();
                userID = dr[1].ToString().Trim();
                do1.executeNonQuery("UPDATE bidOfGoods SET bidState='已竞得' WHERE ID=" + ID);
            }
            catch (Exception e)
            {

                HttpContext.Current.Response.Write(e.ToString());
            }
        }


        public void modifyMes()
        {
            string nameOfGoods = "";
            try
            {
                nameOfGoods =(string)do1.executeScalar("SELECT nameOfGoods FROM goods WHERE goodsID="+goodsID);
                string mesToSeller = "<strong class='red'>" + sellUserID.Trim() + "</strong> 您好，您的拍品【" + nameOfGoods.Trim() + "】拍卖已经结束。<br/>用户【"+sellUserID+
                "】以"+priceCurrent.ToString()+scale+"的价格竞得了这个拍品。<a href='goodsDetail.aspx?goodsID="+goodsID.Trim()+"' class='link1'>查看请点击...</a>";
                do1.setParameter("@fromUserID", "系统");
                do1.setParameter("@title", "系统通知");
                do1.setParameter("@generateTime",DateTime.Now.ToString());
                do1.setParameter("@contOfMessage",mesToSeller);
                do1.setParameter("@userID", sellUserID);
                do1.executeNonQuery("INSERT INTO shortMessage(fromUserID,title,generateTime,contOfMessage,userID) VALUES(@fromUserID,@title,@generateTime,@contOfMessage,@userID)");

                mesToSeller = "<strong class='red'>" + userID.Trim() + "</strong> 您好，您对拍品【" + nameOfGoods.Trim() + "】的竞买成功。<br/>您以" + priceCurrent.ToString()+scale+"的价格竞得了这个拍品。<a href='goodsDetail.aspx?goodsID=" + goodsID.Trim() + "' class='link1'>查看请点击...</a>";
                do1.spc["@fromUserID"].Value = "系统";
                do1.spc["@title"].Value = "系统通知";
                do1.spc["@generateTime"].Value = DateTime.Now.ToString();
                do1.spc["@contOfMessage"].Value = mesToSeller;
                do1.executeNonQuery("INSERT INTO shortMessage(fromUserID,title,generateTime,contOfMessage,userID) VALUES(@fromUserID,@title,@generateTime,@contOfMessage,@userID)");

            }
            catch (Exception e)
            {
                HttpContext.Current.Response.Write(e.ToString());
            }
        }
    }
}