/// <summary>
/// 带有事物执行sql语句
/// </summary>
/// <param name="strSql">sql语句</param>
/// <param name="reckoningTransaction">事物</param>
public static void ExecuteSql(string strSql, ReckoningTransaction reckoningTransaction)
{
Database db = reckoningTransaction.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
db.ExecuteNonQuery(dbCommand, reckoningTransaction.Transaction);
}
/// <summary>
/// 执行一条sql语句
/// </summary>
/// <param name="strSql">sql语句</param>
/// <param name="reckoningTransaction">事务</param>
/// <returns></returns>
public static int ExecuteCountSql(string strSql, ReckoningTransaction reckoningTransaction)
{
Database db = reckoningTransaction.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
return(db.ExecuteNonQuery(dbCommand, reckoningTransaction.Transaction));
}
/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="storedProcName"></param>
/// <param name="reckoningTransaction"></param>
public static void RunProcedure(string storedProcName, ReckoningTransaction reckoningTransaction)
{
Database db = reckoningTransaction.Database;
DbCommand dbCommand = db.GetStoredProcCommand(storedProcName);
db.ExecuteNonQuery(dbCommand, reckoningTransaction.Transaction);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(QH_HoldAccountFreezeTableInfo model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into QH_HoldAccountFreezeTable(");
strSql.Append("FreezeTime,FreezeAmount,ThawTime,EntrustNumber,AccountHoldLogo,FreezeTypeLogo)");
strSql.Append(" values (");
strSql.Append("@FreezeTime,@FreezeAmount,@ThawTime,@EntrustNumber,@AccountHoldLogo,@FreezeTypeLogo)");
strSql.Append(";select @@IDENTITY");
Database db = tm.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "FreezeTime", DbType.DateTime, model.FreezeTime);
db.AddInParameter(dbCommand, "FreezeAmount", DbType.Int32, model.FreezeAmount);
db.AddInParameter(dbCommand, "ThawTime", DbType.DateTime, model.ThawTime);
db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber);
db.AddInParameter(dbCommand, "AccountHoldLogo", DbType.Int32, model.AccountHoldLogo);
db.AddInParameter(dbCommand, "FreezeTypeLogo", DbType.Int32, model.FreezeTypeLogo);
int result;
object obj = db.ExecuteScalar(dbCommand, tm.Transaction);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(QH_TodayTradeTableInfo model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into QH_TodayTradeTable(");
strSql.Append("TradeNumber,EntrustNumber,PortfolioLogo,TradePrice,EntrustPrice,TradeAmount,TradeProceduresFee,Margin,ContractCode,TradeAccount,CapitalAccount,BuySellTypeId,OpenCloseTypeId,TradeUnitId,TradeTypeId,CurrencyTypeId,TradeTime,MarketProfitLoss)");
strSql.Append(" values (");
strSql.Append("@TradeNumber,@EntrustNumber,@PortfolioLogo,@TradePrice,@EntrustPrice,@TradeAmount,@TradeProceduresFee,@Margin,@ContractCode,@TradeAccount,@CapitalAccount,@BuySellTypeId,@OpenCloseTypeId,@TradeUnitId,@TradeTypeId,@CurrencyTypeId,@TradeTime,@MarketProfitLoss)");
Database db = tm.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "TradeNumber", DbType.AnsiString, model.TradeNumber);
db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber);
db.AddInParameter(dbCommand, "PortfolioLogo", DbType.AnsiString, model.PortfolioLogo);
db.AddInParameter(dbCommand, "TradePrice", DbType.Decimal, model.TradePrice);
db.AddInParameter(dbCommand, "EntrustPrice", DbType.Decimal, model.EntrustPrice);
db.AddInParameter(dbCommand, "TradeAmount", DbType.Int32, model.TradeAmount);
db.AddInParameter(dbCommand, "TradeProceduresFee", DbType.Decimal, model.TradeProceduresFee);
db.AddInParameter(dbCommand, "Margin", DbType.Decimal, model.Margin);
db.AddInParameter(dbCommand, "ContractCode", DbType.AnsiString, model.ContractCode);
db.AddInParameter(dbCommand, "TradeAccount", DbType.AnsiString, model.TradeAccount);
db.AddInParameter(dbCommand, "CapitalAccount", DbType.AnsiString, model.CapitalAccount);
db.AddInParameter(dbCommand, "BuySellTypeId", DbType.Int32, model.BuySellTypeId);
db.AddInParameter(dbCommand, "OpenCloseTypeId", DbType.Int32, model.OpenCloseTypeId);
db.AddInParameter(dbCommand, "TradeUnitId", DbType.Int32, model.TradeUnitId);
db.AddInParameter(dbCommand, "TradeTypeId", DbType.Int32, model.TradeTypeId);
db.AddInParameter(dbCommand, "CurrencyTypeId", DbType.Int32, model.CurrencyTypeId);
db.AddInParameter(dbCommand, "TradeTime", DbType.DateTime, model.TradeTime);
db.AddInParameter(dbCommand, "MarketProfitLoss", DbType.Decimal, model.MarketProfitLoss);
db.ExecuteNonQuery(dbCommand, tm.Transaction);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(QH_HoldAccountFreezeTableInfo model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update QH_HoldAccountFreezeTable set ");
strSql.Append("FreezeTime=@FreezeTime,");
strSql.Append("FreezeAmount=@FreezeAmount,");
strSql.Append("ThawTime=@ThawTime,");
strSql.Append("EntrustNumber=@EntrustNumber,");
strSql.Append("AccountHoldLogo=@AccountHoldLogo,");
strSql.Append("FreezeTypeLogo=@FreezeTypeLogo");
strSql.Append(" where HoldFreezeLogoId=@HoldFreezeLogoId ");
Database db = tm.Database;
DbTransaction trans = tm.Transaction;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "HoldFreezeLogoId", DbType.Int32, model.HoldFreezeLogoId);
db.AddInParameter(dbCommand, "FreezeTime", DbType.DateTime, model.FreezeTime);
db.AddInParameter(dbCommand, "FreezeAmount", DbType.Int32, model.FreezeAmount);
db.AddInParameter(dbCommand, "ThawTime", DbType.DateTime, model.ThawTime);
db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber);
db.AddInParameter(dbCommand, "AccountHoldLogo", DbType.Int32, model.AccountHoldLogo);
db.AddInParameter(dbCommand, "FreezeTypeLogo", DbType.Int32, model.FreezeTypeLogo);
db.ExecuteNonQuery(dbCommand, trans);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool AddRecord(HK_AccountHoldInfo model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HK_AccountHold (");
strSql.Append("AvailableAmount,FreezeAmount,UserAccountDistributeLogo,");
strSql.Append(" CostPrice,Code,BreakevenPrice,CurrencyTypeId,HoldAveragePrice)");
strSql.Append(" values (");
strSql.Append("@AvailableAmount,@FreezeAmount,@UserAccountDistributeLogo,");
strSql.Append(" @CostPrice,@Code,@BreakevenPrice,@CurrencyTypeId,@HoldAveragePrice)");
strSql.Append(";select @@IDENTITY");
Database db = tm.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "AvailableAmount", DbType.Decimal, model.AvailableAmount);
db.AddInParameter(dbCommand, "FreezeAmount", DbType.Decimal, model.FreezeAmount);
db.AddInParameter(dbCommand, "UserAccountDistributeLogo", DbType.AnsiString, model.UserAccountDistributeLogo);
db.AddInParameter(dbCommand, "CostPrice", DbType.Decimal, model.CostPrice);
db.AddInParameter(dbCommand, "Code", DbType.AnsiString, model.Code);
db.AddInParameter(dbCommand, "BreakevenPrice", DbType.Decimal, model.BreakevenPrice);
db.AddInParameter(dbCommand, "CurrencyTypeId", DbType.Int32, model.CurrencyTypeID);
db.AddInParameter(dbCommand, "HoldAveragePrice", DbType.Decimal, model.HoldAveragePrice);
int result;
object obj = db.ExecuteScalar(dbCommand, tm.Transaction);
if (!int.TryParse(obj.ToString(), out result))
{
return(false);
}
model.AccountHoldLogoID = result;
return(true);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool AddRecord(QH_CapitalAccountFreezeTableInfo model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into QH_CapitalAccountFreezeTable(");
strSql.Append(
"FreezeTime,FreezeAmount,ThawTime,CapitalAccountLogo,FreezeTypeLogo,EntrustNumber,OweCosting,FreezeCost)");
strSql.Append(" values (");
strSql.Append(
"@FreezeTime,@FreezeAmount,@ThawTime,@CapitalAccountLogo,@FreezeTypeLogo,@EntrustNumber,@OweCosting,@FreezeCost)");
strSql.Append(";select @@IDENTITY");
Database db = tm.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "FreezeTime", DbType.DateTime, model.FreezeTime);
db.AddInParameter(dbCommand, "FreezeAmount", DbType.Decimal, model.FreezeAmount);
db.AddInParameter(dbCommand, "ThawTime", DbType.DateTime, model.ThawTime);
db.AddInParameter(dbCommand, "CapitalAccountLogo", DbType.Int32, model.CapitalAccountLogo);
db.AddInParameter(dbCommand, "FreezeTypeLogo", DbType.Int32, model.FreezeTypeLogo);
db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber);
db.AddInParameter(dbCommand, "OweCosting", DbType.Decimal, model.OweCosting);
db.AddInParameter(dbCommand, "FreezeCost", DbType.Decimal, model.FreezeCost);
int result;
object obj = db.ExecuteScalar(dbCommand, tm.Transaction);
if (!int.TryParse(obj.ToString(), out result))
{
return(false);
}
model.CapitalFreezeLogoId = result;
return(true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(XH_CapitalAccountFreezeTableInfo model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update XH_CapitalAccountFreezeTable set ");
strSql.Append("FreezeTime=@FreezeTime,");
strSql.Append("FreezeCapitalAmount=@FreezeCapitalAmount,");
strSql.Append("ThawTime=@ThawTime,");
strSql.Append("FreezeTypeLogo=@FreezeTypeLogo,");
strSql.Append("EntrustNumber=@EntrustNumber,");
strSql.Append("CapitalAccountLogo=@CapitalAccountLogo,");
strSql.Append("OweCosting=@OweCosting,");
strSql.Append("FreezeCost=@FreezeCost");
strSql.Append(" where CapitalFreezeLogoId=@CapitalFreezeLogoId ");
Database db = tm.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "FreezeTime", DbType.DateTime, model.FreezeTime);
db.AddInParameter(dbCommand, "FreezeCapitalAmount", DbType.Decimal, model.FreezeCapitalAmount);
db.AddInParameter(dbCommand, "CapitalFreezeLogoId", DbType.Int32, model.CapitalFreezeLogoId);
db.AddInParameter(dbCommand, "ThawTime", DbType.DateTime, model.ThawTime);
db.AddInParameter(dbCommand, "FreezeTypeLogo", DbType.Int32, model.FreezeTypeLogo);
db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber);
db.AddInParameter(dbCommand, "CapitalAccountLogo", DbType.Int32, model.CapitalAccountLogo);
db.AddInParameter(dbCommand, "OweCosting", DbType.Decimal, model.OweCosting);
db.AddInParameter(dbCommand, "FreezeCost", DbType.Decimal, model.FreezeCost);
db.ExecuteNonQuery(dbCommand, tm.Transaction);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void UpdateRecord(QH_TodayEntrustTableInfo model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update QH_TodayEntrustTable set ");
strSql.Append("PortfolioLogo=@PortfolioLogo,");
strSql.Append("EntrustPrice=@EntrustPrice,");
strSql.Append("EntrustAmount=@EntrustAmount,");
strSql.Append("TradeAmount=@TradeAmount,");
strSql.Append("TradeAveragePrice=@TradeAveragePrice,");
strSql.Append("CancelAmount=@CancelAmount,");
strSql.Append("CancelLogo=@CancelLogo,");
strSql.Append("BuySellTypeId=@BuySellTypeId,");
strSql.Append("CurrencyTypeId=@CurrencyTypeId,");
strSql.Append("OpenCloseTypeId=@OpenCloseTypeId,");
strSql.Append("TradeUnitId=@TradeUnitId,");
strSql.Append("OrderStatusId=@OrderStatusId,");
strSql.Append("ContractCode=@ContractCode,");
strSql.Append("TradeAccount=@TradeAccount,");
strSql.Append("CapitalAccount=@CapitalAccount,");
strSql.Append("IsMarketValue=@IsMarketValue,");
strSql.Append("OrderMessage=@OrderMessage,");
strSql.Append("CallbackChannelId=@CallbackChannelId,");
strSql.Append("McOrderId=@McOrderId,");
strSql.Append("CloseFloatProfitLoss=@CloseFloatProfitLoss,");
strSql.Append("CloseMarketProfitLoss=@CloseMarketProfitLoss,");
strSql.Append("OfferTime=@OfferTime,");
strSql.Append("EntrustTime=@EntrustTime");
strSql.Append(" where EntrustNumber=@EntrustNumber ");
Database db = tm.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber);
db.AddInParameter(dbCommand, "PortfolioLogo", DbType.AnsiString, model.PortfolioLogo);
db.AddInParameter(dbCommand, "EntrustPrice", DbType.Decimal, model.EntrustPrice);
db.AddInParameter(dbCommand, "EntrustAmount", DbType.Int32, model.EntrustAmount);
db.AddInParameter(dbCommand, "TradeAmount", DbType.Int32, model.TradeAmount);
db.AddInParameter(dbCommand, "TradeAveragePrice", DbType.Decimal, model.TradeAveragePrice);
db.AddInParameter(dbCommand, "CancelAmount", DbType.Int32, model.CancelAmount);
db.AddInParameter(dbCommand, "CancelLogo", DbType.Boolean, model.CancelLogo);
db.AddInParameter(dbCommand, "BuySellTypeId", DbType.Int32, model.BuySellTypeId);
db.AddInParameter(dbCommand, "CurrencyTypeId", DbType.Int32, model.CurrencyTypeId);
db.AddInParameter(dbCommand, "OpenCloseTypeId", DbType.Int32, model.OpenCloseTypeId);
db.AddInParameter(dbCommand, "TradeUnitId", DbType.Int32, model.TradeUnitId);
db.AddInParameter(dbCommand, "OrderStatusId", DbType.Int32, model.OrderStatusId);
db.AddInParameter(dbCommand, "ContractCode", DbType.AnsiString, model.ContractCode);
db.AddInParameter(dbCommand, "TradeAccount", DbType.AnsiString, model.TradeAccount);
db.AddInParameter(dbCommand, "CapitalAccount", DbType.AnsiString, model.CapitalAccount);
db.AddInParameter(dbCommand, "IsMarketValue", DbType.Boolean, model.IsMarketValue);
db.AddInParameter(dbCommand, "OrderMessage", DbType.AnsiString, model.OrderMessage);
db.AddInParameter(dbCommand, "CallbackChannelId", DbType.AnsiString, model.CallbackChannelId);
db.AddInParameter(dbCommand, "McOrderId", DbType.AnsiString, model.McOrderId);
db.AddInParameter(dbCommand, "CloseFloatProfitLoss", DbType.Decimal, model.CloseFloatProfitLoss);
db.AddInParameter(dbCommand, "CloseMarketProfitLoss", DbType.Decimal, model.CloseMarketProfitLoss);
db.AddInParameter(dbCommand, "OfferTime", DbType.DateTime, model.OfferTime);
db.AddInParameter(dbCommand, "EntrustTime", DbType.DateTime, model.EntrustTime);
db.ExecuteNonQuery(dbCommand, tm.Transaction);
}
/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="CapitalFreezeLogoId">资金冻结Id</param>
/// <param name="reckoningTransaction">事务对象</param>
public void Delete(int CapitalFreezeLogoId, ReckoningTransaction reckoningTransaction)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from XH_CapitalAccountFreezeTable ");
strSql.Append(" where CapitalFreezeLogoId=@CapitalFreezeLogoId ");
Database db = reckoningTransaction.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CapitalFreezeLogoId", DbType.Int32, CapitalFreezeLogoId);
db.ExecuteNonQuery(dbCommand, reckoningTransaction.Transaction);
}
/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="storedProcName"></param>
/// <param name="commandTimeout"></param>
/// <param name="reckoningTransaction"></param>
public static void RunProcedure(string storedProcName, int commandTimeout, ReckoningTransaction reckoningTransaction)
{
Database db = reckoningTransaction.Database;
DbCommand dbCommand = db.GetStoredProcCommand(storedProcName);
if (commandTimeout < 0)
{
commandTimeout = 30;
}
dbCommand.CommandTimeout = commandTimeout;
db.ExecuteNonQuery(dbCommand, reckoningTransaction.Transaction);
}
/// <summary>
/// 根据名称删除记录
/// </summary>
/// <param name="name">名称</param>
/// <param name="reckoningTransaction">事物</param>
public void Delete(string name, ReckoningTransaction reckoningTransaction)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from BD_StatusTable ");
strSql.Append(" where name='{0}' ");
string sql = string.Format(strSql.ToString(), name);
Database db = reckoningTransaction.Database;
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.ExecuteNonQuery(dbCommand, reckoningTransaction.Transaction);
}
/// <summary>
/// 执行一条sql语句
/// </summary>
/// <param name="strSql">sql语句</param>
/// <param name="reckoningTransaction">事务</param>
/// <returns></returns>
public static bool ExecuteBollSql(string strSql, ReckoningTransaction reckoningTransaction)
{
Database db = reckoningTransaction.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
try
{
db.ExecuteNonQuery(dbCommand, reckoningTransaction.Transaction);
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(QH_TodayEntrustTableInfo model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into QH_TodayEntrustTable(");
strSql.Append("EntrustNumber,PortfolioLogo,EntrustPrice,EntrustAmount,TradeAmount,TradeAveragePrice,CancelAmount,CancelLogo,BuySellTypeId,CurrencyTypeId,OpenCloseTypeId,TradeUnitId,OrderStatusId,ContractCode,TradeAccount,CapitalAccount,IsMarketValue,OrderMessage,CallbackChannelId,McOrderId,CloseFloatProfitLoss,CloseMarketProfitLoss,OfferTime,EntrustTime)");
strSql.Append(" values (");
strSql.Append("@EntrustNumber,@PortfolioLogo,@EntrustPrice,@EntrustAmount,@TradeAmount,@TradeAveragePrice,@CancelAmount,@CancelLogo,@BuySellTypeId,@CurrencyTypeId,@OpenCloseTypeId,@TradeUnitId,@OrderStatusId,@ContractCode,@TradeAccount,@CapitalAccount,@IsMarketValue,@OrderMessage,@CallbackChannelId,@McOrderId,@CloseFloatProfitLoss,@CloseMarketProfitLoss,@OfferTime,@EntrustTime)");
Database db = tm.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber);
db.AddInParameter(dbCommand, "PortfolioLogo", DbType.AnsiString, model.PortfolioLogo);
db.AddInParameter(dbCommand, "EntrustPrice", DbType.Decimal, model.EntrustPrice);
db.AddInParameter(dbCommand, "EntrustAmount", DbType.Int32, model.EntrustAmount);
db.AddInParameter(dbCommand, "TradeAmount", DbType.Int32, model.TradeAmount);
db.AddInParameter(dbCommand, "TradeAveragePrice", DbType.Decimal, model.TradeAveragePrice);
db.AddInParameter(dbCommand, "CancelAmount", DbType.Int32, model.CancelAmount);
db.AddInParameter(dbCommand, "CancelLogo", DbType.Boolean, model.CancelLogo);
db.AddInParameter(dbCommand, "BuySellTypeId", DbType.Int32, model.BuySellTypeId);
db.AddInParameter(dbCommand, "CurrencyTypeId", DbType.Int32, model.CurrencyTypeId);
db.AddInParameter(dbCommand, "OpenCloseTypeId", DbType.Int32, model.OpenCloseTypeId);
db.AddInParameter(dbCommand, "TradeUnitId", DbType.Int32, model.TradeUnitId);
db.AddInParameter(dbCommand, "OrderStatusId", DbType.Int32, model.OrderStatusId);
db.AddInParameter(dbCommand, "ContractCode", DbType.AnsiString, model.ContractCode);
db.AddInParameter(dbCommand, "TradeAccount", DbType.AnsiString, model.TradeAccount);
db.AddInParameter(dbCommand, "CapitalAccount", DbType.AnsiString, model.CapitalAccount);
db.AddInParameter(dbCommand, "IsMarketValue", DbType.Boolean, model.IsMarketValue);
db.AddInParameter(dbCommand, "OrderMessage", DbType.AnsiString, model.OrderMessage);
db.AddInParameter(dbCommand, "CallbackChannelId", DbType.AnsiString, model.CallbackChannelId);
db.AddInParameter(dbCommand, "McOrderId", DbType.AnsiString, model.McOrderId);
db.AddInParameter(dbCommand, "CloseFloatProfitLoss", DbType.Decimal, model.CloseFloatProfitLoss);
db.AddInParameter(dbCommand, "CloseMarketProfitLoss", DbType.Decimal, model.CloseMarketProfitLoss);
db.AddInParameter(dbCommand, "OfferTime", DbType.DateTime, model.OfferTime);
db.AddInParameter(dbCommand, "EntrustTime", DbType.DateTime, model.EntrustTime);
try
{
db.ExecuteNonQuery(dbCommand, tm.Transaction);
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(QH_HoldAccountTableInfo model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update QH_HoldAccountTable set ");
strSql.Append("HistoryHoldAmount=@HistoryHoldAmount,");
strSql.Append("HistoryFreezeAmount=@HistoryFreezeAmount,");
strSql.Append("HoldAveragePrice=@HoldAveragePrice,");
strSql.Append("TodayHoldAmount=@TodayHoldAmount,");
strSql.Append("TradeCurrencyType=@TradeCurrencyType,");
strSql.Append("TodayHoldAveragePrice=@TodayHoldAveragePrice,");
strSql.Append("UserAccountDistributeLogo=@UserAccountDistributeLogo,");
strSql.Append("BuySellTypeId=@BuySellTypeId,");
strSql.Append("TodayFreezeAmount=@TodayFreezeAmount,");
strSql.Append("Contract=@Contract,");
strSql.Append("CostPrice=@CostPrice,");
strSql.Append("BreakevenPrice=@BreakevenPrice,");
strSql.Append("Margin=@Margin,");
strSql.Append("ProfitLoss=@ProfitLoss,");
strSql.Append("OpenAveragePrice=@OpenAveragePrice");
strSql.Append(" where AccountHoldLogoId=@AccountHoldLogoId ");
Database db = tm.Database;
DbTransaction trans = tm.Transaction;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "AccountHoldLogoId", DbType.Int32, model.AccountHoldLogoId);
db.AddInParameter(dbCommand, "HistoryHoldAmount", DbType.Decimal, model.HistoryHoldAmount);
db.AddInParameter(dbCommand, "HistoryFreezeAmount", DbType.Decimal, model.HistoryFreezeAmount);
db.AddInParameter(dbCommand, "HoldAveragePrice", DbType.Decimal, model.HoldAveragePrice);
db.AddInParameter(dbCommand, "TodayHoldAmount", DbType.Decimal, model.TodayHoldAmount);
db.AddInParameter(dbCommand, "TradeCurrencyType", DbType.Int32, model.TradeCurrencyType);
db.AddInParameter(dbCommand, "TodayHoldAveragePrice", DbType.Decimal, model.TodayHoldAveragePrice);
db.AddInParameter(dbCommand, "UserAccountDistributeLogo", DbType.AnsiString, model.UserAccountDistributeLogo);
db.AddInParameter(dbCommand, "BuySellTypeId", DbType.Int32, model.BuySellTypeId);
db.AddInParameter(dbCommand, "TodayFreezeAmount", DbType.Decimal, model.TodayFreezeAmount);
db.AddInParameter(dbCommand, "Contract", DbType.AnsiString, model.Contract);
db.AddInParameter(dbCommand, "CostPrice", DbType.Decimal, model.CostPrice);
db.AddInParameter(dbCommand, "BreakevenPrice", DbType.Decimal, model.BreakevenPrice);
db.AddInParameter(dbCommand, "Margin", DbType.Decimal, model.Margin);
db.AddInParameter(dbCommand, "ProfitLoss", DbType.Decimal, model.ProfitLoss);
db.AddInParameter(dbCommand, "OpenAveragePrice", DbType.Decimal, model.OpenAveragePrice);
db.ExecuteNonQuery(dbCommand, trans);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool DeleteRecord(int HoldFreezeLogoId, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from QH_HoldAccountFreezeTable ");
strSql.Append(" where HoldFreezeLogoId=@HoldFreezeLogoId ");
Database db = tm.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "HoldFreezeLogoId", DbType.Int32, HoldFreezeLogoId);
try
{
db.ExecuteNonQuery(dbCommand, tm.Transaction);
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XH_TodayEntrustTableInfo GetModel(string EntrustNumber, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select EntrustNumber,PortfolioLogo,EntrustPrice,EntrustAmount,SpotCode,TradeAmount,TradeAveragePrice,CancelAmount,CancelLogo,BuySellTypeId,StockAccount,CapitalAccount,OrderStatusId,IsMarketValue,OrderMessage,CurrencyTypeId,TradeUnitId,CallbackChannlId,McOrderId,HasDoneProfit,OfferTime,EntrustTime from XH_TodayEntrustTable ");
strSql.Append(" where EntrustNumber=@EntrustNumber ");
Database db = tm.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, EntrustNumber);
XH_TodayEntrustTableInfo model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand, tm.Transaction))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool AddRecord(QH_HoldAccountTableInfo model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into QH_HoldAccountTable(");
strSql.Append(
"HistoryHoldAmount,HistoryFreezeAmount,HoldAveragePrice,TodayHoldAmount,TradeCurrencyType,TodayHoldAveragePrice,UserAccountDistributeLogo,BuySellTypeId,TodayFreezeAmount,Contract,CostPrice,BreakevenPrice,Margin,ProfitLoss,OpenAveragePrice)");
strSql.Append(" values (");
strSql.Append(
"@HistoryHoldAmount,@HistoryFreezeAmount,@HoldAveragePrice,@TodayHoldAmount,@TradeCurrencyType,@TodayHoldAveragePrice,@UserAccountDistributeLogo,@BuySellTypeId,@TodayFreezeAmount,@Contract,@CostPrice,@BreakevenPrice,@Margin,@ProfitLoss,@OpenAveragePrice)");
strSql.Append(";select @@IDENTITY");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "HistoryHoldAmount", DbType.Decimal, model.HistoryHoldAmount);
db.AddInParameter(dbCommand, "HistoryFreezeAmount", DbType.Decimal, model.HistoryFreezeAmount);
db.AddInParameter(dbCommand, "HoldAveragePrice", DbType.Decimal, model.HoldAveragePrice);
db.AddInParameter(dbCommand, "TodayHoldAmount", DbType.Decimal, model.TodayHoldAmount);
db.AddInParameter(dbCommand, "TradeCurrencyType", DbType.Int32, model.TradeCurrencyType);
db.AddInParameter(dbCommand, "TodayHoldAveragePrice", DbType.Decimal, model.TodayHoldAveragePrice);
db.AddInParameter(dbCommand, "UserAccountDistributeLogo", DbType.AnsiString, model.UserAccountDistributeLogo);
db.AddInParameter(dbCommand, "BuySellTypeId", DbType.Int32, model.BuySellTypeId);
db.AddInParameter(dbCommand, "TodayFreezeAmount", DbType.Decimal, model.TodayFreezeAmount);
db.AddInParameter(dbCommand, "Contract", DbType.AnsiString, model.Contract);
db.AddInParameter(dbCommand, "CostPrice", DbType.Decimal, model.CostPrice);
db.AddInParameter(dbCommand, "BreakevenPrice", DbType.Decimal, model.BreakevenPrice);
db.AddInParameter(dbCommand, "Margin", DbType.Decimal, model.Margin);
db.AddInParameter(dbCommand, "ProfitLoss", DbType.Decimal, model.ProfitLoss);
db.AddInParameter(dbCommand, "OpenAveragePrice", DbType.Decimal, model.OpenAveragePrice);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(false);
}
model.AccountHoldLogoId = result;
return(true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void AddUpdate(QH_HoldAccountTableInfo_Delta model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update QH_HoldAccountTable set ");
strSql.Append("HistoryHoldAmount=HistoryHoldAmount+@HistoryHoldAmount,");
strSql.Append("HistoryFreezeAmount=HistoryFreezeAmount+@HistoryFreezeAmount,");
strSql.Append("TodayHoldAmount=TodayHoldAmount+@TodayHoldAmount,");
strSql.Append("TodayFreezeAmount=TodayFreezeAmount+@TodayFreezeAmount,");
strSql.Append("Margin=Margin+@Margin");
strSql.Append(" where AccountHoldLogoId=@AccountHoldLogoId ");
Database db = tm.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "AccountHoldLogoId", DbType.Int32, model.AccountHoldLogoId);
db.AddInParameter(dbCommand, "HistoryHoldAmount", DbType.Decimal, model.HistoryHoldAmountDelta);
db.AddInParameter(dbCommand, "HistoryFreezeAmount", DbType.Decimal, model.HistoryFreezeAmountDelta);
db.AddInParameter(dbCommand, "TodayHoldAmount", DbType.Decimal, model.TodayHoldAmountDelta);
db.AddInParameter(dbCommand, "TodayFreezeAmount", DbType.Decimal, model.TodayFreezeAmountDelta);
db.AddInParameter(dbCommand, "Margin", DbType.Decimal, model.MarginDelta);
db.ExecuteNonQuery(dbCommand, tm.Transaction);
}
/// <summary>
/// 执行多表事务的帮助方法,外部调用需要捕获异常
/// 使用方法如下
/// try
/// {
/// DataManager.ExecuteInTransaction((tm) =>
/// {
/// Database database = tm.Database;
/// DbTransaction transaction = tm.Transaction;
/// database.ExecuteNonQuery(dbCommand1, transaction);
/// database.ExecuteNonQuery(dbCommand2, transaction);
///
/// //或者直接传入下一层
/// MyDataLogic.Update(tm);
/// });
/// }
/// catch (Exception ex)
/// {
/// //做异常处理
/// }
/// </summary>
/// <param name="actionInTrans2"></param>
public static void ExecuteInTransaction(ActionInTrans2 actionInTrans2)
{
Database database = DatabaseFactory.CreateDatabase();
using (DbConnection connection = database.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
ReckoningTransaction reckoningTransaction = new ReckoningTransaction();
reckoningTransaction.Database = database;
reckoningTransaction.Transaction = transaction;
actionInTrans2(reckoningTransaction);
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <XH_CapitalAccountFreezeTableInfo> GetListArray(string strWhere, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(
"select FreezeTime,FreezeCapitalAmount,CapitalFreezeLogoId,ThawTime,FreezeTypeLogo,EntrustNumber,CapitalAccountLogo,OweCosting,FreezeCost ");
strSql.Append(" FROM XH_CapitalAccountFreezeTable ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
List <XH_CapitalAccountFreezeTableInfo> list = new List <XH_CapitalAccountFreezeTableInfo>();
Database db = tm.Database;
using (IDataReader dataReader = db.ExecuteReader(tm.Transaction, CommandType.Text, strSql.ToString()))
{
while (dataReader.Read())
{
list.Add(ReaderBind(dataReader));
}
}
return(list);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <QH_HoldAccountTableInfo> GetListArray(string strWhere, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(
"select AccountHoldLogoId,HistoryHoldAmount,HistoryFreezeAmount,HoldAveragePrice,TodayHoldAmount,TradeCurrencyType,TodayHoldAveragePrice,UserAccountDistributeLogo,BuySellTypeId,TodayFreezeAmount,Contract,CostPrice,BreakevenPrice,Margin,ProfitLoss,OpenAveragePrice ");
strSql.Append(" FROM QH_HoldAccountTable ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
List <QH_HoldAccountTableInfo> list = new List <QH_HoldAccountTableInfo>();
Database db = tm.Database;
using (IDataReader dataReader = db.ExecuteReader(tm.Transaction, CommandType.Text, strSql.ToString()))
{
while (dataReader.Read())
{
list.Add(ReaderBind(dataReader));
}
}
return(list);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(XH_TodayTradeTableInfo model, ReckoningTransaction tm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into XH_TodayTradeTable(");
strSql.Append("TradeNumber,EntrustNumber,PortfolioLogo,TradePrice,TradeAmount,EntrustPrice,StampTax,Commission,TransferAccountFee,TradeProceduresFee,MonitoringFee,TradingSystemUseFee,TradeCapitalAmount,ClearingFee,StockAccount,CapitalAccount,SpotCode,TradeTypeId,TradeUnitId,BuySellTypeId,CurrencyTypeId,TradeTime)");
strSql.Append(" values (");
strSql.Append("@TradeNumber,@EntrustNumber,@PortfolioLogo,@TradePrice,@TradeAmount,@EntrustPrice,@StampTax,@Commission,@TransferAccountFee,@TradeProceduresFee,@MonitoringFee,@TradingSystemUseFee,@TradeCapitalAmount,@ClearingFee,@StockAccount,@CapitalAccount,@SpotCode,@TradeTypeId,@TradeUnitId,@BuySellTypeId,@CurrencyTypeId,@TradeTime)");
Database db = tm.Database;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "TradeNumber", DbType.AnsiString, model.TradeNumber);
db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber);
db.AddInParameter(dbCommand, "PortfolioLogo", DbType.AnsiString, model.PortfolioLogo);
db.AddInParameter(dbCommand, "TradePrice", DbType.Decimal, model.TradePrice);
db.AddInParameter(dbCommand, "TradeAmount", DbType.Int32, model.TradeAmount);
db.AddInParameter(dbCommand, "EntrustPrice", DbType.Decimal, model.EntrustPrice);
db.AddInParameter(dbCommand, "StampTax", DbType.Decimal, model.StampTax);
db.AddInParameter(dbCommand, "Commission", DbType.Decimal, model.Commission);
db.AddInParameter(dbCommand, "TransferAccountFee", DbType.Decimal, model.TransferAccountFee);
db.AddInParameter(dbCommand, "TradeProceduresFee", DbType.Decimal, model.TradeProceduresFee);
db.AddInParameter(dbCommand, "MonitoringFee", DbType.Decimal, model.MonitoringFee);
db.AddInParameter(dbCommand, "TradingSystemUseFee", DbType.Decimal, model.TradingSystemUseFee);
db.AddInParameter(dbCommand, "TradeCapitalAmount", DbType.Decimal, model.TradeCapitalAmount);
db.AddInParameter(dbCommand, "ClearingFee", DbType.Decimal, model.ClearingFee);
db.AddInParameter(dbCommand, "StockAccount", DbType.AnsiString, model.StockAccount);
db.AddInParameter(dbCommand, "CapitalAccount", DbType.AnsiString, model.CapitalAccount);
db.AddInParameter(dbCommand, "SpotCode", DbType.AnsiString, model.SpotCode);
db.AddInParameter(dbCommand, "TradeTypeId", DbType.Int32, model.TradeTypeId);
db.AddInParameter(dbCommand, "TradeUnitId", DbType.Int32, model.TradeUnitId);
db.AddInParameter(dbCommand, "BuySellTypeId", DbType.Int32, model.BuySellTypeId);
db.AddInParameter(dbCommand, "CurrencyTypeId", DbType.Int32, model.CurrencyTypeId);
db.AddInParameter(dbCommand, "TradeTime", DbType.DateTime, model.TradeTime);
db.ExecuteNonQuery(dbCommand, tm.Transaction);
}
