/// <summary>
/// 开是否开启事务增加一条数据
/// <param name="model">要插入的用户账号对象</param>
/// <param name="db">操作数据对象</param>
/// <param name="trm">开启事务对象，如果为null不开启</param>
/// </summary>
public void Add(UA_BankAccountTableInfo model, Database db, DbTransaction trm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UA_BankAccountTable(");
strSql.Append(
"CapitalRemainAmount,TradeCurrencyTypeLogo,UserAccountDistributeLogo,BalanceOfTheDay,TodayOutInCapital,FreezeCapital,AvailableCapital)");
strSql.Append(" values (");
strSql.Append(
"@CapitalRemainAmount,@TradeCurrencyTypeLogo,@UserAccountDistributeLogo,@BalanceOfTheDay,@TodayOutInCapital,@FreezeCapital,@AvailableCapital)");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CapitalRemainAmount", DbType.Decimal, model.CapitalRemainAmount);
db.AddInParameter(dbCommand, "TradeCurrencyTypeLogo", DbType.Int32, model.TradeCurrencyTypeLogo);
db.AddInParameter(dbCommand, "UserAccountDistributeLogo", DbType.AnsiString, model.UserAccountDistributeLogo);
db.AddInParameter(dbCommand, "BalanceOfTheDay", DbType.Decimal, model.BalanceOfTheDay);
db.AddInParameter(dbCommand, "TodayOutInCapital", DbType.Decimal, model.TodayOutInCapital);
db.AddInParameter(dbCommand, "FreezeCapital", DbType.Decimal, model.FreezeCapital);
db.AddInParameter(dbCommand, "AvailableCapital", DbType.Decimal, model.AvailableCapital);
if (trm == null)
{
db.ExecuteNonQuery(dbCommand);
}
else
{
db.ExecuteNonQuery(dbCommand, trm);
}
}
/// <summary>
/// 开启是否使用事务新数据
/// </summary>
/// <param name="model"></param>
/// <param name="db"></param>
/// <param name="trm"></param>
public void Update(UA_BankAccountTableInfo model, Database db, DbTransaction trm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UA_BankAccountTable set ");
strSql.Append("CapitalRemainAmount=@CapitalRemainAmount,");
strSql.Append("BalanceOfTheDay=@BalanceOfTheDay,");
strSql.Append("TodayOutInCapital=@TodayOutInCapital,");
strSql.Append("FreezeCapital=@FreezeCapital,");
strSql.Append("AvailableCapital=@AvailableCapital");
strSql.Append(
" where TradeCurrencyTypeLogo=@TradeCurrencyTypeLogo and UserAccountDistributeLogo=@UserAccountDistributeLogo ");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CapitalRemainAmount", DbType.Decimal, model.CapitalRemainAmount);
db.AddInParameter(dbCommand, "TradeCurrencyTypeLogo", DbType.Int32, model.TradeCurrencyTypeLogo);
db.AddInParameter(dbCommand, "UserAccountDistributeLogo", DbType.AnsiString, model.UserAccountDistributeLogo);
db.AddInParameter(dbCommand, "BalanceOfTheDay", DbType.Decimal, model.BalanceOfTheDay);
db.AddInParameter(dbCommand, "TodayOutInCapital", DbType.Decimal, model.TodayOutInCapital);
db.AddInParameter(dbCommand, "FreezeCapital", DbType.Decimal, model.FreezeCapital);
db.AddInParameter(dbCommand, "AvailableCapital", DbType.Decimal, model.AvailableCapital);
if (trm != null)
{
db.ExecuteNonQuery(dbCommand, trm);
}
else
{
db.ExecuteNonQuery(dbCommand);
}
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public UA_BankAccountTableInfo ReaderBind(IDataReader dataReader)
{
UA_BankAccountTableInfo model = new UA_BankAccountTableInfo();
object ojb;
ojb = dataReader["CapitalRemainAmount"];
if (ojb != null && ojb != DBNull.Value)
{
model.CapitalRemainAmount = (decimal)ojb;
}
ojb = dataReader["TradeCurrencyTypeLogo"];
if (ojb != null && ojb != DBNull.Value)
{
model.TradeCurrencyTypeLogo = (int)ojb;
}
model.UserAccountDistributeLogo = dataReader["UserAccountDistributeLogo"].ToString();
ojb = dataReader["BalanceOfTheDay"];
if (ojb != null && ojb != DBNull.Value)
{
model.BalanceOfTheDay = (decimal)ojb;
}
ojb = dataReader["TodayOutInCapital"];
if (ojb != null && ojb != DBNull.Value)
{
model.TodayOutInCapital = (decimal)ojb;
}
ojb = dataReader["FreezeCapital"];
if (ojb != null && ojb != DBNull.Value)
{
model.FreezeCapital = (decimal)ojb;
}
ojb = dataReader["AvailableCapital"];
if (ojb != null && ojb != DBNull.Value)
{
model.AvailableCapital = (decimal)ojb;
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public UA_BankAccountTableInfo GetModel(int TradeCurrencyTypeLogo, string UserAccountDistributeLogo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(
"select CapitalRemainAmount,TradeCurrencyTypeLogo,UserAccountDistributeLogo,BalanceOfTheDay,TodayOutInCapital,FreezeCapital,AvailableCapital from UA_BankAccountTable ");
strSql.Append(
" where TradeCurrencyTypeLogo=@TradeCurrencyTypeLogo and UserAccountDistributeLogo=@UserAccountDistributeLogo ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "TradeCurrencyTypeLogo", DbType.Int32, TradeCurrencyTypeLogo);
db.AddInParameter(dbCommand, "UserAccountDistributeLogo", DbType.AnsiString, UserAccountDistributeLogo);
UA_BankAccountTableInfo model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(UA_BankAccountTableInfo model)
{
Database db = DatabaseFactory.CreateDatabase();
Add(model, db, null);
}
/// <summary>
/// 初始化银行资金账户
/// </summary>
/// <param name="account">账户实体对象</param>
/// <param name="outMessage">返回信息</param>
/// <param name="db">数据库对象</param>
/// <param name="tm">事务对象</param>
public void InitializationBankCapitalAccount(AccountEntity account, out string outMessage, Database db, DbTransaction tm)
{
outMessage = string.Empty;
//account.
if (account == null)
{
outMessage = "银行资金账户对象为空！";
return;
}
decimal _CurrencyAmount;
//var _BKCapitalAccount = new SqlUaBankAccountTableProvider(TransactionFactory.RC_ConnectionString, true, "");
UA_BankAccountTableDal dal = new UA_BankAccountTableDal();
UA_BankAccountTableInfo model = new UA_BankAccountTableInfo();
model.UserAccountDistributeLogo = account.Account;
model.TodayOutInCapital = 0;
model.FreezeCapital = 0;
//人民币
if (account.CurrencyRMB == decimal.MaxValue || account.CurrencyRMB == decimal.MinValue)
{
_CurrencyAmount = 0;
}
else
{
_CurrencyAmount = account.CurrencyRMB;
}
model.CapitalRemainAmount = _CurrencyAmount;
model.BalanceOfTheDay = _CurrencyAmount;
model.AvailableCapital = _CurrencyAmount;
model.TradeCurrencyTypeLogo = (int)GTA.VTS.Common.CommonObject.Types.CurrencyType.RMB;
dal.Add(model, db, tm);
//港元
if (account.CurrencyHK == decimal.MaxValue || account.CurrencyHK == decimal.MinValue)
{
_CurrencyAmount = 0;
}
else
{
_CurrencyAmount = account.CurrencyHK;
}
model.CapitalRemainAmount = _CurrencyAmount;
model.BalanceOfTheDay = _CurrencyAmount;
model.AvailableCapital = _CurrencyAmount;
model.TradeCurrencyTypeLogo = (int)GTA.VTS.Common.CommonObject.Types.CurrencyType.HK;
dal.Add(model, db, tm);
//美元
if (account.CurrencyUS == decimal.MaxValue || account.CurrencyUS == decimal.MinValue)
{
_CurrencyAmount = 0;
}
else
{
_CurrencyAmount = account.CurrencyUS;
}
model.CapitalRemainAmount = _CurrencyAmount;
model.BalanceOfTheDay = _CurrencyAmount;
model.AvailableCapital = _CurrencyAmount;
model.TradeCurrencyTypeLogo = (int)GTA.VTS.Common.CommonObject.Types.CurrencyType.US;
dal.Add(model, db, tm);
}
