public bool AddPlayerBuyVirtualShoppingItemRecord(PlayerBuyVirtualShoppingItemRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into playerbuyvirtualshoppingitemrecord " +
"(`OrderNumber`,`UserID`,`VirtualShoppingItemID`,`BuyTime`) " +
" values (@OrderNumber,@UserID,@VirtualShoppingItemID,@BuyTime )";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@OrderNumber", record.OrderNumber);
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@VirtualShoppingItemID", record.VirtualShoppingItemID);
mycmd.Parameters.AddWithValue("@BuyTime", record.BuyTime.ToDateTime());
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public int BuyVirtualShoppingItem(int userID, string userName, VirtualShoppingItem shoppingItem, CustomerMySqlTransaction myTrans)
{
PlayerBuyVirtualShoppingItemRecord record = null;
DateTime time = DateTime.Now;
if (shoppingItem.ItemType == VirtualShoppingItemType.FactorySlaveFoods30Days)
{
int result = StoneFactoryController.Instance.AddFoods(userID, 30, myTrans);
if (result != OperResult.RESULTCODE_TRUE)
{
return(result);
}
record = new PlayerBuyVirtualShoppingItemRecord()
{
OrderNumber = OrderController.Instance.CreateOrderNumber(userName, time, AlipayTradeInType.VirtualShopping),
UserID = userID,
VirtualShoppingItemID = shoppingItem.ID,
VirtualShoppingItemName = shoppingItem.Name,
BuyTime = new MetaData.MyDateTime(time),
UserName = userName,
};
}
else if (shoppingItem.ItemType == VirtualShoppingItemType.FactoryOpenTool)
{
int result = StoneFactoryController.Instance.OpenFactory(userID, myTrans);
if (result != OperResult.RESULTCODE_TRUE)
{
return(result);
}
record = new PlayerBuyVirtualShoppingItemRecord()
{
OrderNumber = OrderController.Instance.CreateOrderNumber(userName, time, AlipayTradeInType.VirtualShopping),
UserID = userID,
VirtualShoppingItemID = shoppingItem.ID,
VirtualShoppingItemName = shoppingItem.Name,
BuyTime = new MetaData.MyDateTime(time),
UserName = userName,
};
}
else
{
record = new PlayerBuyVirtualShoppingItemRecord()
{
OrderNumber = OrderController.Instance.CreateOrderNumber(userName, time, AlipayTradeInType.VirtualShopping),
UserID = userID,
VirtualShoppingItemID = shoppingItem.ID,
BuyTime = new MetaData.MyDateTime(time)
};
}
bool isOK = DBProvider.VirtualShoppingItemDBProvider.AddPlayerBuyVirtualShoppingItemRecord(record, myTrans);
if (isOK)
{
return(OperResult.RESULTCODE_TRUE);
}
return(OperResult.RESULTCODE_FALSE);
}
public PlayerBuyVirtualShoppingItemRecordUIModel(PlayerBuyVirtualShoppingItemRecord parent)
{
this.ParentObject = parent;
}
