public bool AddPlayerBuyDiamondShoppingItemRecord(PlayerBuyDiamondShoppingItemRecord record, CustomerMySqlTransaction myTrans)
{
MySqlCommand mycmd = null;
try
{
mycmd = myTrans.CreateCommand();
string sqlText = "insert into playerbuydiamondshoppingitemrecord " +
"(`OrderNumber`,`UserID`,`DiamondShoppingItemID`,`SendAddress`,`BuyTime`,`ShoppingState`) " +
" values (@OrderNumber,@UserID,@DiamondShoppingItemID,@SendAddress,@BuyTime,@ShoppingState )";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@OrderNumber", record.OrderNumber);
mycmd.Parameters.AddWithValue("@UserID", record.UserID);
mycmd.Parameters.AddWithValue("@DiamondShoppingItemID", record.DiamondShoppingItemID);
mycmd.Parameters.AddWithValue("@SendAddress", DESEncrypt.EncryptDES(record.SendAddress));
mycmd.Parameters.AddWithValue("@BuyTime", record.BuyTime.ToDateTime());
mycmd.Parameters.AddWithValue("@ShoppingState", (int)record.ShoppingState);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public bool UpdatePlayerBuyDiamondShoppingItemRecord(PlayerBuyDiamondShoppingItemRecord record)
{
return(MyDBHelper.Instance.ConnectionCommandExecuteNonQuery(mycmd =>
{
string sqlText = "update playerbuydiamondshoppingitemrecord " +
" set `ShoppingState`=@ShoppingState,`ExpressCompany`=@ExpressCompany,`ExpressNumber`=@ExpressNumber,`OperAdmin`=@OperAdmin,`OperTime`=@OperTime,`ShoppingState`=@ShoppingState " +
" where `ID`=@ID ";
mycmd.CommandText = sqlText;
mycmd.Parameters.AddWithValue("@ShoppingState", (int)record.ShoppingState);
mycmd.Parameters.AddWithValue("@ShoppingState", (int)record.ShoppingState);
mycmd.Parameters.AddWithValue("@ExpressCompany", record.ExpressCompany);
mycmd.Parameters.AddWithValue("@ExpressNumber", record.ExpressNumber);
mycmd.Parameters.AddWithValue("@OperAdmin", record.OperAdmin);
mycmd.Parameters.AddWithValue("@OperTime", record.OperTime.ToDateTime());
mycmd.Parameters.AddWithValue("@ID", record.ID);
mycmd.ExecuteNonQuery();
}));
}
public int BuyDiamondShoppingItem(int userID, string userName, DiamondShoppingItem shoppingItem, PostAddress address, CustomerMySqlTransaction myTrans)
{
DateTime time = DateTime.Now;
PlayerBuyDiamondShoppingItemRecord record = null;
record = new PlayerBuyDiamondShoppingItemRecord()
{
OrderNumber = OrderController.Instance.CreateOrderNumber(userName, time, AlipayTradeInType.DiamondShopping),
UserID = userID,
DiamondShoppingItemID = shoppingItem.ID,
BuyTime = new MetaData.MyDateTime(time),
SendAddress = address.ToString(),
ShoppingState = DiamondShoppingState.Payed
};
bool isOK = DBProvider.DiamondShoppingDBProvider.AddPlayerBuyDiamondShoppingItemRecord(record, myTrans);
if (isOK)
{
return(OperResult.RESULTCODE_TRUE);
}
return(OperResult.RESULTCODE_FALSE);
}
public int HandleBuyDiamondShopping(PlayerBuyDiamondShoppingItemRecord record)
{
DBProvider.DiamondShoppingDBProvider.UpdatePlayerBuyDiamondShoppingItemRecord(record);
return(OperResult.RESULTCODE_TRUE);
}
public void HandleBuyDiamondShopping(string actionPassword, PlayerBuyDiamondShoppingItemRecord record)
{
this._invoker.Invoke <int>(this._context, "HandleBuyDiamondShopping", this.HandleBuyDiamondShoppingCompleted, GlobalData.Token, actionPassword, record);
}
