/// <summary> /// 获取持仓内存表,如果内存中不存在,那么再到数据库查找 /// </summary> /// <param name="accountHoldLogoId">持仓id</param> /// <returns></returns> public static XHHoldMemoryTable GetHoldMemoryTable(int accountHoldLogoId) { XHHoldMemoryTable holdMemory = null; try { holdMemory = MemoryDataManager.XHHoldMemoryList.GetByAccountHoldLogoId(accountHoldLogoId); //如果持仓为空,那么先从数据库加载,看是不是内存表没有加载 if (holdMemory == null) { XH_AccountHoldTableDal dal = new XH_AccountHoldTableDal(); var hold = dal.GetModel(accountHoldLogoId); //如果数据库有,那么直接加载到内存表中 if (hold != null) { MemoryDataManager.XHHoldMemoryList.AddXHAccountHoldTableToMemory(hold); } else { //如果数据库也没有,那么代表无持仓 return(null); } holdMemory = MemoryDataManager.XHHoldMemoryList.GetByAccountHoldLogoId(accountHoldLogoId); } } catch (Exception ex) { LogHelper.WriteError("XHCommonLogic.GetHoldMemoryTable-" + ex.Message, ex); } return(holdMemory); }
/// <summary> /// 一个持仓id多线程插入(带检查) /// </summary> public static void Test222() { MemoryDataManager.Start(); XHHoldMemoryTable table = MemoryDataManager.XHHoldMemoryList.GetByAccountHoldLogoId(1375); for (int i = 0; i < 5; i++) { Thread t = new Thread(Target33); TableObj <XHHoldMemoryTable> obj = new TableObj <XHHoldMemoryTable>(); obj.Table = table; obj.val = 200; t.Start(obj); } ExitConsole(); MemoryDataManager.End(); }
/// <summary> /// 获取持仓内存表,如果内存中不存在,那么再到数据库查找 /// </summary> /// <param name="holdAccount">持仓账户</param> /// <param name="code">代码</param> /// <param name="tradeCurrencyType">币种</param> /// <returns>内存表</returns> public static XHHoldMemoryTable GetHoldMemoryTable(string holdAccount, string code, int tradeCurrencyType) { XHHoldMemoryTable holdMemory = null; try { holdMemory = MemoryDataManager.XHHoldMemoryList.GetByHoldAccountAndCurrencyType(holdAccount, code, tradeCurrencyType); //holdMemory = MemoryDataManager.XHHoldMemoryList.GetByAccountHoldLogoId(HoldingAccountId); //如果持仓为空,那么先从数据库加载,看是不是内存表没有加载 if (holdMemory == null) { XH_AccountHoldTableDal dal = new XH_AccountHoldTableDal(); var hold = dal.GetXhAccountHoldTable(holdAccount, code, tradeCurrencyType); //如果数据库有,那么直接加载到内存表中 if (hold != null) { MemoryDataManager.XHHoldMemoryList.AddXHAccountHoldTableToMemory(hold); } else { //如果数据库也没有,那么代表无持仓 return(null); } holdMemory = MemoryDataManager.XHHoldMemoryList.GetByHoldAccountAndCurrencyType(holdAccount, code, tradeCurrencyType); } } catch (Exception ex) { LogHelper.WriteError("XHCommonLogic.GetHoldMemoryTable-" + ex.Message, ex); } return(holdMemory); }
/// <summary> /// 检验并持久化柜台委托单 /// </summary> /// <param name="strMessage">错误消息</param> /// <param name="outEntity">柜台持久化后的对象</param> /// <returns>是否成功</returns> private bool PersistentOrder(ref XH_TodayEntrustTableInfo outEntity, ref string strMessage) { #region 初始化参数 //取代码对应品种的交易币种 if (!GetCurrencyType()) { strMessage = "GT-2226:[现货委托持久化]无法获取交易币种"; return(false); } if (CurrencyType == -1) { strMessage = "GT-2226:[现货委托持久化]无法获取交易币种"; return(false); } //预成交金额 decimal predealCapital = 0; //预成交费用 decimal predealCost = 0; //预成交总金额(根据买卖的不同,不一定=predealCapital+predealCost) decimal preDealSum = 0; //资金及持仓帐户 string strHoldingAccount; string strCapitalAccount; //依据交易员及委托信息取对应资金及持仓帐户 if (!CheckAccount(out strCapitalAccount, out strHoldingAccount, out strMessage)) { return(false); } GetAccountId(strCapitalAccount, strHoldingAccount); if (CapitalAccountId == -1) { strMessage = "GT-2227:[现货委托持久化]无法获取资金帐号ID"; return(false); } #endregion #region 检查 try { //计算预成交金额和预成交费用 if (!this.PO_ComputePreCapital(ref strMessage, ref predealCapital, ref predealCost)) { PO_ValidateFailureProcess(ref strMessage); return(false); } //四舍五入 predealCapital = Utils.Round(predealCapital); predealCost = Utils.Round(predealCost); //1.资金检查 if ( !this.PO_CapitalValidate(predealCost, predealCapital, ref strMessage)) { PO_ValidateFailureProcess(ref strMessage); return(false); } //2.持仓检查 if (!PO_HoldValidate(ref strMessage)) { PO_ValidateFailureProcess(ref strMessage); return(false); } } catch (Exception ex) { strMessage = ex.Message; PO_ValidateFailureProcess(ref strMessage); return(false); } #endregion #region 创建委托(处理失败时要删除此条委托) try { EntrustNumber = XHCommonLogic.BuildXhOrder(ref outEntity, Request, HoldingAccount, CapitalAccount, CurrencyType, ref strMessage); } catch (Exception ex) { DeleteEntrust(EntrustNumber); LogHelper.WriteError(ex.Message, ex); strMessage = "GT-2225:[现货委托持久化]无法创建委托"; LogHelper.WriteDebug(strMessage + ":" + outEntity); return(false); } #endregion #region Persist流程 //persistent流程 //1.资金处理,可用资金减去预成交总金额,总冻结资金加上预成交总金额 //2.冻结资金处理,生成一条冻结记录 //3.持仓处理:只有卖出时才会有持仓处理,可用持仓减少委托量,总冻结持仓增加委托量 //4.持仓冻结处理:只有卖出时才会有持仓冻结处理,生成一条冻结记录 //实际处理: //2.4放在一个事务中进行,当成功后再进行1.3的处理 bool isSuccess = false; #region 资金预处理 var caMemory = MemoryDataManager.XHCapitalMemoryList.GetByCapitalAccountLogo(CapitalAccountId); if (caMemory == null) { strMessage = "GT-2211:[现货委托持久化]资金帐户不存在:" + CapitalAccount; return(false); } if (Request.BuySell == GTA.VTS.Common.CommonObject.Types.TransactionDirection.Buying) { //预成交总金额 = 预成交金额 + 预成交费用 preDealSum = predealCapital + predealCost; } else { //预成交总金额 = 预成交费用(卖不需要加金额) preDealSum = predealCost; } XH_CapitalAccountTable_DeltaInfo capitalDelta = new XH_CapitalAccountTable_DeltaInfo(); capitalDelta.CapitalAccountLogo = caMemory.Data.CapitalAccountLogo; capitalDelta.AvailableCapitalDelta = -preDealSum; capitalDelta.FreezeCapitalTotalDelta = preDealSum; //return caMemory.AddDelta(-preDealCapitalAmount, preDealCapitalAmount, 0, 0); //return caMemory.AddDelta(capitalDelta); #endregion #region 持仓预处理(买入不处理) decimal orderAmount = Convert.ToDecimal(Request.OrderAmount); XHHoldMemoryTable ahtMemory = null; XH_AccountHoldTableInfo_Delta holdDelta = null; if (Request.BuySell == GTA.VTS.Common.CommonObject.Types.TransactionDirection.Selling) { ahtMemory = MemoryDataManager.XHHoldMemoryList.GetByAccountHoldLogoId(HoldingAccountId); if (ahtMemory == null) { ahtMemory = XHCommonLogic.GetHoldMemoryTable(HoldingAccount, Code, CurrencyType); } if (ahtMemory == null) { strMessage = "GT-2212:[现货委托持久化]持仓帐户不存在:" + HoldingAccount; return(false); } holdDelta = new XH_AccountHoldTableInfo_Delta(); var holdData = ahtMemory.Data; holdDelta.AccountHoldLogoId = holdData.AccountHoldLogoId; holdDelta.AvailableAmountDelta = -orderAmount; holdDelta.FreezeAmountDelta = orderAmount; holdDelta.Data = holdData; } #endregion #region 数据库提交动作 bool isCapitalSuccess = false; bool isHoldingSuccess = false; Database database = DatabaseFactory.CreateDatabase(); try { using (DbConnection connection = database.CreateConnection()) { connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { ReckoningTransaction tm = new ReckoningTransaction(); tm.Database = database; tm.Transaction = transaction; //1.资金处理 //首先提交资金到数据库 isCapitalSuccess = caMemory.CheckAndAddDelta(CapitalCheck, capitalDelta, database, transaction); if (!isCapitalSuccess) { strMessage = "GT-2218:[现货委托持久化]资金检查,无足够可用资金"; throw new CheckException("XHCapitalMemoryTable.CheckAddAddDelta失败"); } //2.冻结资金处理,生成一条冻结记录 PO_BuildCapitalFreezeRecord(predealCapital, predealCost, Request.BuySell, tm); //3.持仓冻结处理:只有卖出是才会有持仓处理 if (Request.BuySell == GTA.VTS.Common.CommonObject.Types.TransactionDirection.Selling) { //持仓冻结处理,生成一条冻结记录 PO_BuildHoldFreezeRecord(tm); } //4.持仓处理 if (Request.BuySell == GTA.VTS.Common.CommonObject.Types.TransactionDirection.Selling) { isHoldingSuccess = ahtMemory.CheckAndAddDelta(HodingCheck, holdDelta, tm.Database, tm.Transaction); if (!isHoldingSuccess) { strMessage = holdMessage; holdMessage = ""; throw new CheckException("XHHoldingMemoryTable.CheckAddAddDelta失败"); } } transaction.Commit(); isSuccess = true; } catch (Exception ex) { transaction.Rollback(); LogHelper.WriteError(ex.Message, ex); if (!(ex is CheckException)) { strMessage = "GT-2213:[现货委托持久化]持久化失败,无法提交到数据库"; } isSuccess = false; } } } catch (Exception ex) { strMessage = "GT-2214:[现货委托持久化]持久化失败"; LogHelper.WriteError(ex.Message, ex); } //事务失败 if (!isSuccess) { DeleteEntrust(EntrustNumber); if (isCapitalSuccess) { caMemory.RollBackMemory(capitalDelta); } if (Request.BuySell == GTA.VTS.Common.CommonObject.Types.TransactionDirection.Selling) { if (isHoldingSuccess) { ahtMemory.RollBackMemory(holdDelta); } } return(false); } //if(isSuccess) //{ // //当提交资金、持仓 到数据库成功后,同步到内存 // caMemory.AddDeltaToMemory(capitalDelta); // if (Request.BuySell == CommonObject.Types.TransactionDirection.Selling) // { // ahtMemory.AddDeltaToMemory(holdDelta); // } //} //else //{ // DeleteEntrust(EntrustNumber); // return false; //} #endregion #endregion return(true); }