/// <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); }