public bool AddSellOrder(SellStonesOrder order, int userID, CustomerMySqlTransaction trans)
{
MySqlCommand mycmd = null;
try
{
mycmd = trans.CreateCommand();
string cmdTextA = "insert into sellstonesorder " +
"(`OrderNumber`, `SellerUserName`, `SellStonesCount`, `Expense`, `ValueRMB`, `SellTime`, `OrderState` ) " +
" values " +
"(@OrderNumber, @SellerUserName, @SellStonesCount, @Expense, @ValueRMB, @SellTime, @OrderState); ";
mycmd.CommandText = cmdTextA;
mycmd.Parameters.AddWithValue("@OrderNumber", order.OrderNumber);
mycmd.Parameters.AddWithValue("@SellerUserName", DESEncrypt.EncryptDES(order.SellerUserName));
mycmd.Parameters.AddWithValue("@SellStonesCount", order.SellStonesCount);
mycmd.Parameters.AddWithValue("@Expense", order.Expense);
mycmd.Parameters.AddWithValue("@ValueRMB", order.ValueRMB);
mycmd.Parameters.AddWithValue("@SellTime", order.SellTime);
mycmd.Parameters.AddWithValue("@OrderState", order.OrderState);
mycmd.ExecuteNonQuery();
PlayerLastSellStoneRecord lastrecord = new PlayerLastSellStoneRecord()
{
UserID = userID,
SellStoneOrderNumber = order.OrderNumber,
SellTime = order.SellTime
};
string cmdTextB = "delete from playerlastsellstonerecord where `UserID` = @UserID ;" +
"insert into playerlastsellstonerecord " +
"(`UserID`, `SellStoneOrderNumber`, `SellTime` ) " +
" values " +
"(@UserID, @OrderNumber, @SellTime ); ";
mycmd.CommandText = cmdTextB;
mycmd.Parameters.AddWithValue("@UserID", lastrecord.UserID);
mycmd.ExecuteNonQuery();
return(true);
}
finally
{
mycmd.Dispose();
}
}
public bool CheckNeedStoneSellQuan(int userID)
{
bool needUseQuan = false;
PlayerLastSellStoneRecord lastSellOrder = DBProvider.StoneOrderDBProvider.GetPlayerLastSellStoneRecord(userID);
if (lastSellOrder != null)
{
//今天已经出售过矿石，则再出售就需要用券。
DateTime timenow = DateTime.Now;
if (lastSellOrder.SellTime.Year == timenow.Year &&
lastSellOrder.SellTime.Month == timenow.Month &&
lastSellOrder.SellTime.Day == timenow.Day)
{
needUseQuan = true;
}
}
return(needUseQuan);
}
