private void InternalDoCheck(HK_CapitalAccountFreezeSum freezeSum) { int capitalAccountId = freezeSum.CapitalAccountLogo; decimal sum = freezeSum.FreezeCapitalSum; var capMemory = MemoryDataManager.HKCapitalMemoryList.GetByCapitalAccountLogo(capitalAccountId); if (capMemory == null) { return; } var capital = capMemory.Data; if (capital.FreezeCapitalTotal != sum) { decimal oldSum = capital.FreezeCapitalTotal; HK_CapitalAccount_DeltaInfo deltaInfo = new HK_CapitalAccount_DeltaInfo(); deltaInfo.CapitalAccountLogo = capitalAccountId; deltaInfo.FreezeCapitalTotalDelta = sum - oldSum; capMemory.AddDelta(deltaInfo); string format2 = "HKReckonUnitManager.DoCapitalFreezeCheck修正现货总冻结资金[初始总冻结资金={0},实际总冻结资金={1},资金账户ID={2}]"; string desc = string.Format(format2, oldSum, sum, capitalAccountId); LogHelper.WriteDebug(desc); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(HK_CapitalAccount_DeltaInfo model, Database db, DbTransaction transaction) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into HK_CapitalAccount_Delta("); strSql.Append("CapitalAccountLogo,AvailableCapitalDelta,FreezeCapitalTotalDelta,TodayOutInCapital,HasDoneProfitLossTotalDelta,DeltaTime)"); strSql.Append(" values ("); strSql.Append("@CapitalAccountLogo,@AvailableCapitalDelta,@FreezeCapitalTotalDelta,@TodayOutInCapital,@HasDoneProfitLossTotalDelta,@DeltaTime)"); strSql.Append(";select @@IDENTITY"); //Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "CapitalAccountLogo", DbType.Int32, model.CapitalAccountLogo); db.AddInParameter(dbCommand, "AvailableCapitalDelta", DbType.Decimal, model.AvailableCapitalDelta); db.AddInParameter(dbCommand, "FreezeCapitalTotalDelta", DbType.Decimal, model.FreezeCapitalTotalDelta); db.AddInParameter(dbCommand, "TodayOutInCapital", DbType.Decimal, model.TodayOutInCapital); db.AddInParameter(dbCommand, "HasDoneProfitLossTotalDelta", DbType.Decimal, model.HasDoneProfitLossTotalDelta); db.AddInParameter(dbCommand, "DeltaTime", DbType.DateTime, model.DeltaTime); int result; object obj = db.ExecuteScalar(dbCommand, transaction); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 写现货资金增量调试信息 /// </summary> public static void WriteHKCapitalInfo(HK_CapitalAccount_DeltaInfo deltaInfo) { string format = "港股capitalAccountLogo={0},可用资金增量={1},冻结资金增量={2},当日出入金增量={3},已实现盈亏增量={4}"; string msg = string.Format(format, deltaInfo.CapitalAccountLogo, deltaInfo.AvailableCapitalDelta, deltaInfo.FreezeCapitalTotalDelta, deltaInfo.TodayOutInCapital, deltaInfo.HasDoneProfitLossTotalDelta); capitalLog.Debug(msg); }
private bool CapitalCheck(HK_CapitalAccountInfo capital, HK_CapitalAccount_DeltaInfo change) { //只有买时才检查 if (Request.BuySell == Types.TransactionDirection.Buying) { if (capital.AvailableCapital <= 0) { return(false); } return(capital.AvailableCapital + change.AvailableCapitalDelta >= 0); } //卖时只要成交额大于费用即可,前面已经检查过,此处不再检查 return(true); }
/// <summary> /// 对象实体绑定数据 /// </summary> public HK_CapitalAccount_DeltaInfo ReaderBind2(IDataReader dataReader) { HK_CapitalAccount_DeltaInfo model = new HK_CapitalAccount_DeltaInfo(); object ojb; //ojb = dataReader["ID"]; //if (ojb != null && ojb != DBNull.Value) //{ // model.ID = (int)ojb; //} ojb = dataReader["CapitalAccountLogo"]; if (ojb != null && ojb != DBNull.Value) { model.CapitalAccountLogo = (int)ojb; } ojb = dataReader["AvailableCapitalDelta"]; if (ojb != null && ojb != DBNull.Value) { model.AvailableCapitalDelta = (decimal)ojb; } ojb = dataReader["FreezeCapitalTotalDelta"]; if (ojb != null && ojb != DBNull.Value) { model.FreezeCapitalTotalDelta = (decimal)ojb; } ojb = dataReader["TodayOutInCapital"]; if (ojb != null && ojb != DBNull.Value) { model.TodayOutInCapital = (decimal)ojb; } ojb = dataReader["HasDoneProfitLossTotalDelta"]; if (ojb != null && ojb != DBNull.Value) { model.HasDoneProfitLossTotalDelta = (decimal)ojb; } //ojb = dataReader["DeltaTime"]; //if (ojb != null && ojb != DBNull.Value) //{ // model.DeltaTime = (DateTime)ojb; //} return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public HK_CapitalAccount_DeltaInfo GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append( "select ID,CapitalAccountLogo,AvailableCapitalDelta,FreezeCapitalTotalDelta,TodayOutInCapital,HasDoneProfitLossTotalDelta,DeltaTime from HK_CapitalAccount_Delta "); strSql.Append(" where ID=@ID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ID", DbType.Int32, ID); HK_CapitalAccount_DeltaInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 得到某个资金帐号的汇总增量 /// </summary> public HK_CapitalAccount_DeltaInfo GetSum(int capitalAccountLogo) { StringBuilder strSql = new StringBuilder(); strSql.Append( "select CapitalAccountLogo,sum(AvailableCapitalDelta) AvailableCapitalDelta,sum(FreezeCapitalTotalDelta) FreezeCapitalTotalDelta,sum(TodayOutInCapital) TodayOutInCapital,sum(HasDoneProfitLossTotalDelta) HasDoneProfitLossTotalDelta from HK_CapitalAccount_Delta "); strSql.Append(" where CapitalAccountLogo=@CapitalAccountLogo "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "CapitalAccountLogo", DbType.Int32, capitalAccountLogo); HK_CapitalAccount_DeltaInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind2(dataReader); } } return(model); }
/// <summary> /// 检验并持久化柜台委托单 /// </summary> /// <param name="strMessage">错误消息</param> /// <param name="outEntity">柜台持久化后的对象</param> /// <returns>是否成功</returns> private bool PersistentOrder(ref HK_TodayEntrustInfo outEntity, ref string strMessage) { #region 初始化参数 //取代码对应品种的交易币种 if (!GetCurrencyType()) { strMessage = "GT-2426:[港股委托持久化]无法获取交易币种"; return(false); } if (CurrencyType == -1) { strMessage = "GT-2426:[港股委托持久化]无法获取交易币种"; 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-2427:[港股委托持久化]无法获取资金帐号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 = HKCommonLogic.BuildHKOrder(ref outEntity, Request, HoldingAccount, CapitalAccount, CurrencyType, ref strMessage); } catch (Exception ex) { DeleteEntrust(EntrustNumber); LogHelper.WriteError(ex.Message, ex); strMessage = "GT-2425:[港股委托持久化]无法创建委托"; 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.HKCapitalMemoryList.GetByCapitalAccountLogo(CapitalAccountId); if (caMemory == null) { strMessage = "GT-2411:[港股委托持久化]资金帐户不存在:" + CapitalAccount; return(false); } if (Request.BuySell == Types.TransactionDirection.Buying) { //预成交总金额 = 预成交金额 + 预成交费用 preDealSum = predealCapital + predealCost; } else { //预成交总金额 = 预成交费用(卖不需要加金额) preDealSum = predealCost; } HK_CapitalAccount_DeltaInfo capitalDelta = new HK_CapitalAccount_DeltaInfo(); capitalDelta.CapitalAccountLogo = caMemory.Data.CapitalAccountLogo; capitalDelta.AvailableCapitalDelta = -preDealSum; capitalDelta.FreezeCapitalTotalDelta = preDealSum; #endregion #region 持仓预处理(买入不处理) decimal orderAmount = Convert.ToDecimal(Request.OrderAmount); HKHoldMemoryTable ahtMemory = null; HK_AccountHoldInfo_Delta holdDelta = null; if (Request.BuySell == Types.TransactionDirection.Selling) { ahtMemory = MemoryDataManager.HKHoldMemoryList.GetByAccountHoldLogoId(HoldingAccountId); if (ahtMemory == null) { ahtMemory = HKCommonLogic.GetHoldMemoryTable(HoldingAccount, Code, CurrencyType); } if (ahtMemory == null) { strMessage = "GT-2412:[港股委托持久化]持仓帐户不存在:" + HoldingAccount; return(false); } holdDelta = new HK_AccountHoldInfo_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-2418:[港股委托持久化]资金检查,无足够可用资金"; throw new CheckException("XHCapitalMemoryTable.CheckAddAddDelta失败"); } //2.冻结资金处理,生成一条冻结记录 PO_BuildCapitalFreezeRecord(predealCapital, predealCost, Request.BuySell, tm); //3.持仓冻结处理:只有卖出是才会有持仓处理 if (Request.BuySell == Types.TransactionDirection.Selling) { //持仓冻结处理,生成一条冻结记录 PO_BuildHoldFreezeRecord(tm); } //4.持仓处理 if (Request.BuySell == 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-2413:[港股委托持久化]持久化失败,无法提交到数据库"; } isSuccess = false; } } } catch (Exception ex) { strMessage = "GT-2414:[港股委托持久化]持久化失败"; LogHelper.WriteError(ex.Message, ex); } //事务失败 if (!isSuccess) { DeleteEntrust(EntrustNumber); if (isCapitalSuccess) { //caMemory.RollBackMemory(capitalDelta); } if (Request.BuySell == Types.TransactionDirection.Selling) { if (isHoldingSuccess) { //ahtMemory.RollBackMemory(holdDelta); } } return(false); } #endregion #endregion return(true); }