/// <summary>
/// 个性化资金设置
/// </summary>
/// <param name="amount">设置金额</param>
/// <param name="account">资金账号</param>
/// <param name="currencyType">币种</param>
/// <param name="db">数据连接对象</param>
/// <param name="trm">开启事务</param>
public void PersonalizationCapital(decimal amount, string account, GTA.VTS.Common.CommonObject.Types.CurrencyType currencyType, Database db, DbTransaction trm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE [XH_CapitalAccountTable] SET ");
strSql.Append(" AvailableCapital = @amount");
strSql.Append(" WHERE UserAccountDistributeLogo=@UserAccountDistributeLogo");
strSql.Append(" And TradeCurrencyType=@TradeCurrencyType");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "amount", DbType.Decimal, amount);
db.AddInParameter(dbCommand, "TradeCurrencyType", DbType.Int32, (int)currencyType);
db.AddInParameter(dbCommand, "UserAccountDistributeLogo", DbType.AnsiString, account);
db.ExecuteNonQuery(dbCommand, trm);
}
public void TwoAccountsFreeTransferFundsTest()
{
AccountAndCapitalManagementService target = new AccountAndCapitalManagementService(); // TODO: 初始化为适当的值
FreeTransferEntity freeTransfer = null; // TODO: 初始化为适当的值
GTA.VTS.Common.CommonObject.Types.CurrencyType currencyType = new GTA.VTS.Common.CommonObject.Types.CurrencyType(); // TODO: 初始化为适当的值
string outMessage = string.Empty; // TODO: 初始化为适当的值
string outMessageExpected = string.Empty; // TODO: 初始化为适当的值
bool expected = false; // TODO: 初始化为适当的值
bool actual;
actual = target.TwoAccountsFreeTransferFunds(freeTransfer, currencyType, out outMessage);
Assert.AreEqual(outMessageExpected, outMessage);
Assert.AreEqual(expected, actual);
Assert.Inconclusive("验证此测试方法的正确性。");
}
/// <summary>
/// 开户时根据银行账号和交易货币类型增加资金
/// Create BY:李健华
/// Crate Date:2009-07-12
/// </summary>
/// <param name="addAmount">增加总数</param>
/// <param name="bankAccount">银行账号</param>
/// <param name="currencyType">交易货币类型</param>
/// <param name="db"></param>
/// <param name="trm">开启事务</param>
public void AddCapital(decimal addAmount, string bankAccount, GTA.VTS.Common.CommonObject.Types.CurrencyType currencyType, Database db, DbTransaction trm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE [UA_BankAccountTable] SET ");
strSql.Append(" CapitalRemainAmount = CapitalRemainAmount + @AddAmount");
strSql.Append(" ,TodayOutInCapital = TodayOutInCapital + @AddAmount");
strSql.Append(" ,AvailableCapital =AvailableCapital + @AddAmount");
strSql.Append(" WHERE UserAccountDistributeLogo=@UserAccountDistributeLogo");
strSql.Append(" And TradeCurrencyTypeLogo=@TradeCurrencyTypeLogo");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "AddAmount", DbType.Decimal, addAmount);
db.AddInParameter(dbCommand, "TradeCurrencyTypeLogo", DbType.Int32, (int)currencyType);
db.AddInParameter(dbCommand, "UserAccountDistributeLogo", DbType.AnsiString, bankAccount);
db.ExecuteNonQuery(dbCommand, trm);
}