Ejemplo n.º 1
0
 public static XElement CreateAuctionInfo(AuctionInfo info)
 {
     return new XElement("Item", new XAttribute("AuctionID", info.AuctionID),
         new XAttribute("AuctioneerID", info.AuctioneerID),
         new XAttribute("AuctioneerName", info.AuctioneerName == null ? "" : info.AuctioneerName),
         new XAttribute("BeginDate", info.BeginDate.ToString("yyyy-MM-dd HH:mm:ss")),
         new XAttribute("BuyerID", info.BuyerID),
         new XAttribute("BuyerName", info.BuyerName == null ? "" : info.BuyerName),
         new XAttribute("ItemID", info.ItemID),
         new XAttribute("Mouthful", info.Mouthful),
         new XAttribute("PayType", info.PayType),
         new XAttribute("Price", info.Price),
         new XAttribute("Rise", info.Rise),
         new XAttribute("ValidDate", info.ValidDate));
 }
Ejemplo n.º 2
0
 public GSPacketIn SendAuctionRefresh(AuctionInfo info, int auctionID, bool isExist, ItemInfo item)
 {
     GSPacketIn pkg = new GSPacketIn((byte)ePackageType.AUCTION_REFRESH);
     pkg.WriteInt(auctionID);
     pkg.WriteBoolean(isExist);
     if (isExist)
     {
         pkg.WriteInt(info.AuctioneerID);
         pkg.WriteString(info.AuctioneerName);
         pkg.WriteDateTime(info.BeginDate);
         pkg.WriteInt(info.BuyerID);
         pkg.WriteString(info.BuyerName);
         pkg.WriteInt(info.ItemID);
         pkg.WriteInt(info.Mouthful);
         pkg.WriteInt(info.PayType);
         pkg.WriteInt(info.Price);
         pkg.WriteInt(info.Rise);
         pkg.WriteInt(info.ValidDate);
         pkg.WriteBoolean(item != null);
         if (item != null)
         {
             pkg.WriteInt(item.Count);
             pkg.WriteInt(item.TemplateID);
             pkg.WriteInt(item.AttackCompose);
             pkg.WriteInt(item.DefendCompose);
             pkg.WriteInt(item.AgilityCompose);
             pkg.WriteInt(item.LuckCompose);
             pkg.WriteInt(item.StrengthenLevel);
             pkg.WriteBoolean(item.IsBinds);
             pkg.WriteBoolean(item.IsJudge);
             pkg.WriteDateTime(item.BeginDate);
             pkg.WriteInt(item.ValidDate);
             pkg.WriteString(item.Color);
             pkg.WriteString(item.Skin);
             pkg.WriteBoolean(item.IsUsed);
         }
     }
     pkg.Compress();
     SendTCP(pkg);
     return pkg;
 }
Ejemplo n.º 3
0
 public bool UpdateAuction(AuctionInfo info)
 {
     bool flag = false;
     try
     {
         SqlParameter[] SqlParameters = new SqlParameter[16]
     {
       new SqlParameter("@AuctionID", (object) info.AuctionID),
       new SqlParameter("@AuctioneerID", (object) info.AuctioneerID),
       new SqlParameter("@AuctioneerName", info.AuctioneerName == null ? (object) "" : (object) info.AuctioneerName),
       new SqlParameter("@BeginDate", (object) info.BeginDate),
       new SqlParameter("@BuyerID", (object) info.BuyerID),
       new SqlParameter("@BuyerName", info.BuyerName == null ? (object) "" : (object) info.BuyerName),
       new SqlParameter("@IsExist", (object) (int) (info.IsExist ? 1 : 0)),
       new SqlParameter("@ItemID", (object) info.ItemID),
       new SqlParameter("@Mouthful", (object) info.Mouthful),
       new SqlParameter("@PayType", (object) info.PayType),
       new SqlParameter("@Price", (object) info.Price),
       new SqlParameter("@Rise", (object) info.Rise),
       new SqlParameter("@ValidDate", (object) info.ValidDate),
       new SqlParameter("Name", (object) info.Name),
       new SqlParameter("Category", (object) info.Category),
       new SqlParameter("@Result", SqlDbType.Int)
     };
         SqlParameters[15].Direction = ParameterDirection.ReturnValue;
         this.db.RunProcedure("SP_Auction_Update", SqlParameters);
         flag = (int)SqlParameters[15].Value == 0;
     }
     catch (Exception ex)
     {
         if (BaseBussiness.log.IsErrorEnabled)
             BaseBussiness.log.Error((object)"Init", ex);
     }
     return flag;
 }
Ejemplo n.º 4
0
 public bool AddAuction(AuctionInfo info)
 {
     bool flag = false;
     try
     {
         SqlParameter[] SqlParameters = new SqlParameter[18];
         SqlParameters[0] = new SqlParameter("@AuctionID", (object)info.AuctionID);
         SqlParameters[0].Direction = ParameterDirection.Output;
         SqlParameters[1] = new SqlParameter("@AuctioneerID", (object)info.AuctioneerID);
         SqlParameters[2] = new SqlParameter("@AuctioneerName", info.AuctioneerName == null ? (object)"" : (object)info.AuctioneerName);
         SqlParameters[3] = new SqlParameter("@BeginDate", (object)info.BeginDate);
         SqlParameters[4] = new SqlParameter("@BuyerID", (object)info.BuyerID);
         SqlParameters[5] = new SqlParameter("@BuyerName", info.BuyerName == null ? (object)"" : (object)info.BuyerName);
         SqlParameters[6] = new SqlParameter("@IsExist", (object)(int)(info.IsExist ? 1 : 0));
         SqlParameters[7] = new SqlParameter("@ItemID", (object)info.ItemID);
         SqlParameters[8] = new SqlParameter("@Mouthful", (object)info.Mouthful);
         SqlParameters[9] = new SqlParameter("@PayType", (object)info.PayType);
         SqlParameters[10] = new SqlParameter("@Price", (object)info.Price);
         SqlParameters[11] = new SqlParameter("@Rise", (object)info.Rise);
         SqlParameters[12] = new SqlParameter("@ValidDate", (object)info.ValidDate);
         SqlParameters[13] = new SqlParameter("@TemplateID", (object)info.TemplateID);
         SqlParameters[14] = new SqlParameter("Name", (object)info.Name);
         SqlParameters[15] = new SqlParameter("Category", (object)info.Category);
         SqlParameters[16] = new SqlParameter("Random", (object)info.Random);
         SqlParameters[17] = new SqlParameter("goodsCount", (object)info.goodsCount);
         flag = this.db.RunProcedure("SP_Auction_Add", SqlParameters);
         info.AuctionID = (int)SqlParameters[0].Value;
     }
     catch (Exception ex)
     {
         if (BaseBussiness.log.IsErrorEnabled)
             BaseBussiness.log.Error((object)"Init", ex);
     }
     return flag;
 }
Ejemplo n.º 5
0
 public GSPacketIn SendAuctionRefresh(SqlDataProvider.Data.AuctionInfo info, int auctionID, bool isExist, SqlDataProvider.Data.ItemInfo item)
 {
     throw new NotImplementedException();
 }
Ejemplo n.º 6
0
 public AuctionInfo InitAuctionInfo(SqlDataReader reader)
 {
     AuctionInfo info = new AuctionInfo();
     info.AuctioneerID = (int)reader["AuctioneerID"];
     info.AuctioneerName = reader["AuctioneerName"] == null ? "" : reader["AuctioneerName"].ToString();
     info.AuctionID = (int)reader["AuctionID"];
     info.BeginDate = (DateTime)reader["BeginDate"];
     info.BuyerID = (int)reader["BuyerID"];
     info.BuyerName = reader["BuyerName"] == null ? "" : reader["BuyerName"].ToString();
     info.IsExist = (bool)reader["IsExist"];
     info.ItemID = (int)reader["ItemID"];
     info.Mouthful = (int)reader["Mouthful"];
     info.PayType = (int)reader["PayType"];
     info.Price = (int)reader["Price"];
     info.Rise = (int)reader["Rise"];
     info.ValidDate = (int)reader["ValidDate"];
     info.Name = reader["Name"].ToString();
     info.Category = (int)reader["Category"];
     return info;
 }
Ejemplo n.º 7
0
        //拼抽
        public AuctionInfo[] GetAuctionPage(int page, string name, int type, int pay, ref int total, int userID, int buyID, int order, bool sort, int size, string AuctionIDs)
        {
            List<AuctionInfo> infos = new List<AuctionInfo>();
            //SqlDataReader reader = null;
            try
            {
                //int View_flag = 1;//标识别:1代表type在1-24的视图,0代表type在其余的视图.
                string sWhere = " IsExist=1 ";
                if (!string.IsNullOrEmpty(name))
                {
                    sWhere += " and Name like '%" + name + "%' ";
                }
                if (type != -1)
                {
                    //sWhere += " and Category =" + type + " ";
                    //                -美容
                    //  翅膀
                    //  眼睛
                    //  脸饰
                    //  头发
                    //-装备
                    //  套装
                    //  衣服
                    //  帽子
                    //  眼镜
                    //-饰品
                    //  项链
                    //  戒指
                    //  手镯
                    //-道具
                    //  特殊
                    //  战斗道具
                    //  宝石及公式

                    switch (type)
                    {
                        case 0:
                        case 1:
                        case 2:
                        case 3:
                        case 4:
                        case 5:
                        case 6:
                        case 7:
                        case 8:
                        case 9:
                        case 10:
                        case 11:
                        case 12:
                        case 13:
                        case 14:
                        case 15:
                        case 16:
                        case 17:
                            sWhere += " and Category =" + type + " ";
                            break;
                        case 21:
                            sWhere += " and Category in(1,2,5,8,9) ";   //服装
                            break;
                        case 22:
                            sWhere += " and Category in(13,15,6,4,3) "; //美容
                            break;
                        case 23:
                            sWhere += " and Category in(16,11,10) ";    //道具
                            break;
                        case 24:
                            sWhere += " and Category in(8,9) ";         //首饰
                            break;
                        case 25:
                            sWhere += " and Category in (7,17) ";       //武器、副武器
                            break;
                        case 26:
                            sWhere += " and TemplateId>=311000 and TemplateId<=313999"; //所有宝珠
                            break;
                        case 27:
                            sWhere += " and TemplateId>=311000 and TemplateId<=311999 ";//三角宝珠
                            break;
                        case 28:
                            sWhere += " and TemplateId>=312000 and TemplateId<=312999 ";//方形宝珠
                            break;
                        case 29:
                            sWhere += " and TemplateId>=313000 and TempLateId<=313999"; //圆形宝珠
                            break;
                        case 1100:
                            //View_flag = 0;
                            sWhere += " and TemplateID in (11019,11021,11022,11023) "; //所有强化石
                            break;
                        case 1101:
                            //View_flag = 0;
                            sWhere += " and TemplateID='11019' ";     //强化石1
                            break;
                        case 1102:
                            //View_flag = 0;
                            sWhere += " and TemplateID='11021' ";     //强化石2
                            break;
                        case 1103:
                            //View_flag = 0;
                            sWhere += " and TemplateID='11022' ";     //强化石3
                            break;
                        case 1104:
                            //View_flag = 0;
                            sWhere += " and TemplateID='11023' ";     //强化石4
                            break;
                        case 1105:
                            //View_flag = 0;
                            sWhere += " and TemplateID in (11001,11002,11003,11004,11005,11006,11007,11008,11009,11010,11011,11012,11013,11014,11015,11016) ";   //所有合成石
                            break;
                        case 1106:
                            //View_flag = 0;
                            sWhere += " and TemplateID in (11001,11002,11003,11004) ";   //朱雀石
                            break;
                        case 1107:
                            //View_flag = 0;
                            sWhere += " and TemplateID in (11005,11006,11007,11008) ";  //玄武石
                            break;
                        case 1108:
                            //View_flag = 0;
                            sWhere += " and TemplateID in (11009,11010,11011,11012) ";  //青龙石
                            break;
                        case 1109:
                            //View_flag = 0;
                            sWhere += " and TemplateID in (11013,11014,11015,11016) ";  //白虎石
                            break;



                    }
                }
                if (pay != -1)
                {
                    sWhere += " and PayType =" + pay + " ";
                }
                if (userID != -1)
                {
                    sWhere += " and AuctioneerID =" + userID + " ";
                }
                if (buyID != -1)
                {
                    //sWhere += " and BuyerID =" + buyID + " ";
                    //if (string.IsNullOrEmpty(AuctionIDs))
                    //{
                    //    AuctionIDs = null;
                    //}
                    sWhere += " and (BuyerID =" + buyID + " or AuctionID in (" + AuctionIDs + ")) ";
                }
                //默认排序按照排序的优先级进行:物品类型>物品名称>当前价格(以一口价为准)>剩余时间>出售人
                string sOrder = "Category,Name,Price,dd,AuctioneerID";
                switch (order)
                {
                    case 0:
                        sOrder = "Name";
                        break;
                    case 1:
                        //sOrder = "Repute1";
                        break;
                    case 2:
                        //sOrder = "Count1";
                        sOrder = "dd";
                        break;
                    case 3:
                        sOrder = "AuctioneerName";
                        break;
                    case 4:
                        sOrder = "Price";
                        break;
                    case 5:
                        sOrder = "BuyerName";
                        break;
                }

                sOrder += sort ? " desc" : "";
                sOrder += ",AuctionID ";

                SqlParameter[] para = new SqlParameter[8];

                para[0] = new SqlParameter("@QueryStr", "V_Auction_Scan");//表名,视图名,查询语句           
                para[1] = new SqlParameter("@QueryWhere", sWhere);//查询条件
                para[2] = new SqlParameter("@PageSize", size);//每页的行数
                para[3] = new SqlParameter("@PageCurrent", page);//要显示页面
                para[4] = new SqlParameter("@FdShow", "*");//要显示的字段列表,必须排除表识字段
                para[5] = new SqlParameter("@FdOrder", sOrder);//排序字段列表
                para[6] = new SqlParameter("@FdKey", "AuctionID");//强制指定主键
                para[7] = new SqlParameter("@TotalRow", total);//总记录行数
                para[7].Direction = ParameterDirection.Output;
                DataTable dt = db.GetDataTable("Auction", "SP_CustomPage", para);
                total = (int)para[7].Value;
                foreach (DataRow dr in dt.Rows)
                {
                    AuctionInfo info = new AuctionInfo();
                    info.AuctioneerID = (int)dr["AuctioneerID"];
                    info.AuctioneerName = dr["AuctioneerName"].ToString();
                    info.AuctionID = (int)dr["AuctionID"];
                    info.BeginDate = (DateTime)dr["BeginDate"];
                    info.BuyerID = (int)dr["BuyerID"];
                    info.BuyerName = dr["BuyerName"].ToString();
                    info.Category = (int)dr["Category"];
                    info.IsExist = (bool)dr["IsExist"];
                    info.ItemID = (int)dr["ItemID"];
                    info.Name = dr["Name"].ToString();
                    info.Mouthful = (int)dr["Mouthful"];
                    info.PayType = (int)dr["PayType"];
                    info.Price = (int)dr["Price"];
                    info.Rise = (int)dr["Rise"];
                    info.ValidDate = (int)dr["ValidDate"];

                    infos.Add(info);
                }
                //db.GetReader(ref reader, "SP_CustomPage", para);
                //total = (int)para[7].Value;
                //while (reader.Read())
                //{
                //    infos.Add(InitAuctionInfo(reader));
                //}
            }
            catch (Exception e)
            {
                if (log.IsErrorEnabled)
                    log.Error("Init", e);
            }
            finally
            {
                //if (reader != null && !reader.IsClosed)
                //    reader.Close();
            }

            return infos.ToArray();
        }
Ejemplo n.º 8
0
        public bool UpdateAuction(AuctionInfo info)
        {
            bool result = false;
            try
            {
                SqlParameter[] para = new SqlParameter[16];
                para[0] = new SqlParameter("@AuctionID", info.AuctionID);
                para[1] = new SqlParameter("@AuctioneerID", info.AuctioneerID);
                para[2] = new SqlParameter("@AuctioneerName", info.AuctioneerName == null ? "" : info.AuctioneerName);
                para[3] = new SqlParameter("@BeginDate", info.BeginDate);
                para[4] = new SqlParameter("@BuyerID", info.BuyerID);
                para[5] = new SqlParameter("@BuyerName", info.BuyerName == null ? "" : info.BuyerName);
                para[6] = new SqlParameter("@IsExist", info.IsExist);
                para[7] = new SqlParameter("@ItemID", info.ItemID);
                para[8] = new SqlParameter("@Mouthful", info.Mouthful);
                para[9] = new SqlParameter("@PayType", info.PayType);
                para[10] = new SqlParameter("@Price", info.Price);
                para[11] = new SqlParameter("@Rise", info.Rise);
                para[12] = new SqlParameter("@ValidDate", info.ValidDate);
                para[13] = new SqlParameter("Name", info.Name);
                para[14] = new SqlParameter("Category", info.Category);
                para[15] = new SqlParameter("@Result", System.Data.SqlDbType.Int);
                para[15].Direction = ParameterDirection.ReturnValue;

                db.RunProcedure("SP_Auction_Update", para);
                int returnValue = (int)para[15].Value;
                result = returnValue == 0;
            }
            catch (Exception e)
            {
                if (log.IsErrorEnabled)
                    log.Error("Init", e);
            }
            finally
            {
            }
            return result;
        }
Ejemplo n.º 9
0
 public bool AddAuction(AuctionInfo info)
 {
     bool result = false;
     try
     {
         SqlParameter[] para = new SqlParameter[17];
         para[0] = new SqlParameter("@AuctionID", info.AuctionID);
         para[0].Direction = ParameterDirection.Output;
         para[1] = new SqlParameter("@AuctioneerID", info.AuctioneerID);
         para[2] = new SqlParameter("@AuctioneerName", info.AuctioneerName == null ? "" : info.AuctioneerName);
         para[3] = new SqlParameter("@BeginDate", info.BeginDate);
         para[4] = new SqlParameter("@BuyerID", info.BuyerID);
         para[5] = new SqlParameter("@BuyerName", info.BuyerName == null ? "" : info.BuyerName);
         para[6] = new SqlParameter("@IsExist", info.IsExist);
         para[7] = new SqlParameter("@ItemID", info.ItemID);
         para[8] = new SqlParameter("@Mouthful", info.Mouthful);
         para[9] = new SqlParameter("@PayType", info.PayType);
         para[10] = new SqlParameter("@Price", info.Price);
         para[11] = new SqlParameter("@Rise", info.Rise);
         para[12] = new SqlParameter("@ValidDate", info.ValidDate);
         para[13] = new SqlParameter("@TemplateID", info.TemplateID);
         para[14] = new SqlParameter("Name", info.Name);
         para[15] = new SqlParameter("Category", info.Category);
         para[16] = new SqlParameter("Random", info.Random);
         result = db.RunProcedure("SP_Auction_Add", para);
         info.AuctionID = (int)para[0].Value;
     }
     catch (Exception e)
     {
         if (log.IsErrorEnabled)
             log.Error("Init", e);
     }
     finally
     {
     }
     return result;
 }
Ejemplo n.º 10
0
        public int HandlePacket(GameClient client, GSPacketIn packet)
        {
          
                eBageType bagType = (eBageType)packet.ReadByte();
                int place = packet.ReadInt();
                int payType = packet.ReadByte();
                int price = packet.ReadInt();
                int mouthful = packet.ReadInt();
                int validDate = packet.ReadInt();

                string msg = "AuctionAddHandler.Fail";
                payType = 1;
                if (client.Player.PlayerCharacter.HasBagPassword && client.Player.PlayerCharacter.IsLocked)
                {

                    client.Out.SendMessage(eMessageType.Normal, LanguageMgr.GetTranslation("Bag.Locked"));
                    return 0;
                }

                if (price < 0 || (mouthful != 0 && mouthful < price))
                    return 0;

                int multiple = 1;
                if (payType != 0)
                {
                    //multiple = 10;
                    multiple = 1;
                    payType = 1;
                }
                int needGold = (int)(multiple * price * 0.03 * (validDate == 0 ? 1 : validDate == 1 ? 3 : 6));
                needGold = needGold < 1 ? 1 : needGold;
                ItemInfo goods = client.Player.GetItemAt(bagType, place);

                if (price < 0)
                {
                    msg = "AuctionAddHandler.Msg1";
                }
                else if (mouthful != 0 && mouthful < price)
                {
                    msg = "AuctionAddHandler.Msg2";
                }
                else if (needGold > client.Player.PlayerCharacter.Gold)
                {
                    msg = "AuctionAddHandler.Msg3";
                }
                else if (goods == null)
                {
                    msg = "AuctionAddHandler.Msg4";
                }
                else if (goods.IsBinds)
                {
                    msg = "AuctionAddHandler.Msg5";
                }
                else
                {
                    client.Player.SaveIntoDatabase();
                    AuctionInfo info = new AuctionInfo();
                    info.AuctioneerID = client.Player.PlayerCharacter.ID;//获取物品ID
                    info.AuctioneerName = client.Player.PlayerCharacter.NickName;//获取物品妮称
                    info.BeginDate = DateTime.Now;
                    info.BuyerID = 0;
                    info.BuyerName = "";
                    info.IsExist = true;
                    info.ItemID = goods.ItemID;
                    info.Mouthful = mouthful;
                    info.PayType = payType;
                    info.Price = price;
                    info.Rise = price / 10;
                    info.Rise = info.Rise < 1 ? 1 : info.Rise;
                    info.Name = goods.Template.Name;
                    info.Category = goods.Template.CategoryID;
                    info.ValidDate = validDate == 0 ? 8 : validDate == 1 ? 24 : 48;
                    info.TemplateID = goods.TemplateID;

                    info.Random = Bussiness.ThreadSafeRandom.NextStatic(GameProperties.BeginAuction, GameProperties.EndAuction);
                    using (PlayerBussiness db = new PlayerBussiness())//写数据库
                    {
                        if (db.AddAuction(info))
                        {
                            //client.Player.RemoveAllItem(goods, true, Game.Server.Statics.ItemRemoveType.Auction, bagType);
                            //client.Player.up
                            //client.Player.SaveIntoDatabase();
                            //client.Player.SetGold(-needGold, Game.Server.Statics.GoldRemoveType.Auction);
                            //msg = "AuctionAddHandler.Msg6";
                            //client.Out.SendAuctionRefresh(info, info.AuctionID, true, goods);
                            client.Player.RemoveItem(goods);

                            goods.IsExist = true;

                            client.Player.SaveIntoDatabase();
                            client.Player.RemoveGold(needGold);
                            msg = "AuctionAddHandler.Msg6";
                            client.Out.SendAuctionRefresh(info, info.AuctionID, true, goods);
                        }
                    }
                }

                //client.Out.SendMailResponse(client.Player.PlayerCharacter.ID, eMailRespose.Receiver);
                client.Out.SendMessage(eMessageType.Normal, LanguageMgr.GetTranslation(msg));
                return 0;
            
         
        }