//public ClubStatus GetClubSlotStatus() //{ // ClubStatus Result = new ClubStatus(); // var club = IffEntry.Club.GetItem(ItemTypeID); // if (club.Base.TypeID == ItemTypeID) // { // if (ItemC0Slot == 0) // { // Result.Power = club.C0; // } // if (ItemC1Slot == 0) // { // Result.Control = club.C1; // } // if (ItemC2Slot == 0) // { // Result.Impact = club.C2; // } // if (ItemC3Slot == 0) // { // Result.Spin = club.C3; // } // if (ItemC4Slot == 0) // { // Result.Curve = club.C4; // } // Result.ClubType = (ECLUBTYPE)club.ClubType; // } // else // { // Result.Power = this.ItemC0Slot; // Result.Control = this.ItemC1Slot; // Result.Impact = this.ItemC2Slot; // Result.Spin = this.ItemC3Slot; // Result.Curve = this.ItemC4Slot; // } // return Result; //} public byte[] GetItems() { using (var result = new PangyaBinaryWriter()) { result.Write(ItemIndex); result.Write(ItemTypeID); result.Write(ItemHourLeft); if ((IffGroupFlag)ItemGroup == IffGroupFlag.ITEM_TYPE_CLUB) { result.Write(ItemC0Slot); result.Write(ItemC1Slot); result.Write(ItemC2Slot); result.Write(ItemC3Slot); result.Write(ItemC4Slot);//22 result.Write((byte)0); result.Write(ItemFlag ?? 0); result.Write(ItemRegDate.UnixTimeConvert()); //UNIXTIME campo RegDate result.Write(ItemEndDate.UnixTimeConvert()); //UNIXTIME campo EndDate result.Write((byte)2); result.WriteStr(Utils.IsUCCNull(ItemUCCName), 16); result.WriteZero(25); result.WriteStr(Utils.IsUCCNull(ItemUCCUnique), 9);//chave do SD result.Write(ItemUCCStatus ?? 0); result.Write(ItemUCCCopyCount ?? 0); result.WriteStr(Utils.IsUCCNull(ItemUCCDrawer), 16); result.WriteZero(70); //70 result.Write(Convert.ToUInt32(ItemClubPoint ?? 0)); //74 result.Write(Convert.ToUInt32(ItemClubSlotCancelledCount ?? 0)); // 78 result.Write((long)ItemClubWorkCount); //86 } else { result.WriteUInt16(ItemC0); result.WriteUInt16(ItemC1); result.WriteUInt16(ItemC2); result.WriteUInt16(ItemC3); result.WriteUInt16(ItemC4); result.WriteByte(0); result.WriteByte(ItemFlag ?? 0); result.Write(ItemRegDate.UnixTimeConvert()); //UNIXTIME campo RegDate result.Write(ItemEndDate.UnixTimeConvert()); //UNIXTIME campo EndDate result.Write((byte)2); result.WriteStr(Utils.IsUCCNull(ItemUCCName), 16); result.WriteZero(25); result.WriteStr(Utils.IsUCCNull(ItemUCCUnique), 9);//chave do SD result.Write(ItemUCCStatus ?? 0); result.Write(ItemUCCCopyCount ?? 0); result.WriteStr(Utils.IsUCCNull(ItemUCCDrawer), 16); result.WriteZero(86); } return(result.GetBytes()); } }
public string GetSqlUpdateString() { StringBuilder SQLString; SQLString = new StringBuilder(); try { SQLString.Append('^'); SQLString.Append(ItemIndex); SQLString.Append('^'); SQLString.Append(ItemC0); SQLString.Append('^'); SQLString.Append(ItemC1); SQLString.Append('^'); SQLString.Append(ItemC2); SQLString.Append('^'); SQLString.Append(ItemC3); SQLString.Append('^'); SQLString.Append(ItemC4); SQLString.Append('^'); SQLString.Append(ItemIsValid); SQLString.Append('^'); SQLString.Append(Compare.IfCompare <byte>(IFFEntry.GetIff.IsSelfDesign(ItemTypeID), 1, 0)); SQLString.Append('^'); SQLString.Append(ItemUCCStatus ?? 0); SQLString.Append('^'); SQLString.Append(ItemUCCUnique ?? "0"); SQLString.Append('^'); SQLString.Append(ItemEndDate.GetSQLTime()); SQLString.Append('^'); SQLString.Append(ItemFlag ?? 0); SQLString.Append('^'); // { CLUB SET DATA } SQLString.Append(ItemClubPoint); SQLString.Append('^'); SQLString.Append(ItemClubWorkCount); SQLString.Append('^'); SQLString.Append(ItemClubPointLog); SQLString.Append('^'); SQLString.Append(ItemClubPangLog); SQLString.Append('^'); SQLString.Append(ItemC0Slot); SQLString.Append('^'); SQLString.Append(ItemC1Slot); SQLString.Append('^'); SQLString.Append(ItemC2Slot); SQLString.Append('^'); SQLString.Append(ItemC3Slot); SQLString.Append('^'); SQLString.Append(ItemC4Slot); SQLString.Append('^'); SQLString.Append(ItemClubSlotCancelledCount); SQLString.Append('^'); SQLString.Append(Compare.IfCompare <byte>(IFFTools.GetItemGroup(ItemTypeID) == IffGroupFlag.ITEM_TYPE_CLUB, 1, 0)); SQLString.Append(','); // close for next player var data = SQLString.ToString(); return(data); } finally { SQLString.Clear(); } }