/// <summary> /// 创建一个今日成交记录 /// </summary> /// <param name="registerTable">登记表实体</param> /// <param name="intNum">分红过户量</param>里 /// <returns>今日成交实体</returns> private static XH_TodayTradeTableInfo GetTodayTradeTable(XH_MelonCutRegisterTableInfo registerTable, int intNum) { XH_TodayTradeTableInfo todayTradeTable = new XH_TodayTradeTableInfo(); todayTradeTable.TradeNumber = Guid.NewGuid().ToString(); todayTradeTable.BuySellTypeId = (int)GTA.VTS.Common.CommonObject.Types.TransactionDirection.Buying; todayTradeTable.StockAccount = registerTable.UserAccountDistributeLogo; todayTradeTable.TradeTypeId = (int)Types.DealRptType.DRTTransfer; todayTradeTable.CurrencyTypeId = registerTable.TradeCurrencyType; todayTradeTable.TradeUnitId = MCService.GetPriceUnit(registerTable.Code); todayTradeTable.TradeAmount = intNum; todayTradeTable.TradeTime = DateTime.Now; CM_BourseType bourseType = MCService.CommonPara.GetBourseTypeByCommodityCode(registerTable.Code); if (bourseType != null) { } CM_Commodity commodity = MCService.CommonPara.GetCommodityByCommodityCode(registerTable.Code); todayTradeTable.SpotCode = registerTable.Code; if (commodity != null) { } CM_BreedClass breedClass = MCService.CommonPara.GetBreedClassByCommodityCode(registerTable.Code); if (breedClass != null) { } return(todayTradeTable); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(XH_TodayTradeTableInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update XH_TodayTradeTable set "); strSql.Append("EntrustNumber=@EntrustNumber,"); strSql.Append("PortfolioLogo=@PortfolioLogo,"); strSql.Append("TradePrice=@TradePrice,"); strSql.Append("TradeAmount=@TradeAmount,"); strSql.Append("EntrustPrice=@EntrustPrice,"); strSql.Append("StampTax=@StampTax,"); strSql.Append("Commission=@Commission,"); strSql.Append("TransferAccountFee=@TransferAccountFee,"); strSql.Append("TradeProceduresFee=@TradeProceduresFee,"); strSql.Append("MonitoringFee=@MonitoringFee,"); strSql.Append("TradingSystemUseFee=@TradingSystemUseFee,"); strSql.Append("TradeCapitalAmount=@TradeCapitalAmount,"); strSql.Append("ClearingFee=@ClearingFee,"); strSql.Append("StockAccount=@StockAccount,"); strSql.Append("CapitalAccount=@CapitalAccount,"); strSql.Append("SpotCode=@SpotCode,"); strSql.Append("TradeTypeId=@TradeTypeId,"); strSql.Append("TradeUnitId=@TradeUnitId,"); strSql.Append("BuySellTypeId=@BuySellTypeId,"); strSql.Append("CurrencyTypeId=@CurrencyTypeId,"); strSql.Append("TradeTime=@TradeTime"); strSql.Append(" where TradeNumber=@TradeNumber "); Database db = DatabaseFactory.CreateDatabase(); 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); }
/// <summary> /// 双击现货单元个事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void daXHTodayTrade_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { foreach (DataGridViewRow row in this.daXHTodayTrade.SelectedRows) { XH_TodayTradeTableInfo TodayTrade = row.DataBoundItem as XH_TodayTradeTableInfo; if (TodayTrade == null) { return; } this.txtQueryXHTradeNo.Text = TodayTrade.EntrustNumber; } }
/// <summary> /// 得到一个对象实体 /// </summary> public XH_TodayTradeTableInfo GetModel(string TradeNumber) { StringBuilder strSql = new StringBuilder(); strSql.Append("select TradeNumber,EntrustNumber,PortfolioLogo,TradePrice,TradeAmount,EntrustPrice,StampTax,Commission,TransferAccountFee,TradeProceduresFee,MonitoringFee,TradingSystemUseFee,TradeCapitalAmount,ClearingFee,StockAccount,CapitalAccount,SpotCode,TradeTypeId,TradeUnitId,BuySellTypeId,CurrencyTypeId,TradeTime from XH_TodayTradeTable "); strSql.Append(" where TradeNumber=@TradeNumber "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "TradeNumber", DbType.AnsiString, TradeNumber); XH_TodayTradeTableInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <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); }
/// <summary> /// 更新过户记录 /// </summary> /// <param name="tm">TransactionManager</param> /// <param name="cash">分红信息</param> /// <param name="tables">登记列表</param> private static bool UpdateStockCut(ReckoningTransaction tm, List <XH_MelonCutRegisterTableInfo> tables) { #region old code 李健华 2010-06-11 改为因为在每天开市时处理那么生成为当日委托我成交 //List<XH_AccountHoldTableInfo> accountHoldList = new List<XH_AccountHoldTableInfo>(); //List<XH_HistoryTradeTableInfo> historyTradeList = new List<XH_HistoryTradeTableInfo>(); ////add 2010-1-15 因为数据库表有的成交记录是根据委托编号有外键关系,所以这里要生成委托记录 //List<XH_HistoryEntrustTableInfo> historyEntrustList = new List<XH_HistoryEntrustTableInfo>(); ////======== //foreach (XH_MelonCutRegisterTableInfo registerTable in tables) //{ // //更新持仓表 // List<XH_AccountHoldTableInfo> accountHoldTables = GetAccountHoldList( // registerTable.UserAccountDistributeLogo, // registerTable.TradeCurrencyType, registerTable.Code); // if (Utils.IsNullOrEmpty(accountHoldTables)) // continue; // //过户的量 // decimal num = registerTable.RegisterAmount; // //四舍五入 // num = Math.Round(num); // int intNum = decimal.ToInt32(num); // XH_AccountHoldTableInfo accountTable = accountHoldTables[0]; // SetAccountTable(accountTable, intNum); // accountHoldList.Add(accountTable); // //更新委托记录表 // XH_HistoryEntrustTableInfo historyEntrustTable = GetHistoryEntrustTable(registerTable, intNum); // historyEntrustList.Add(historyEntrustTable); // //更新历史成交表 // XH_HistoryTradeTableInfo historyTradeTable = GetHistoryTradeTable(registerTable, intNum); // historyTradeTable.EntrustNumber = historyEntrustTable.EntrustNumber; // historyTradeTable.CapitalAccount = historyEntrustTable.CapitalAccount; // historyTradeList.Add(historyTradeTable); // string format = "MelonCutService.UpdateStockCut进行股票分红[商品代码={0},持仓帐号={1},分红金额={2}]"; // string desc = string.Format(format, registerTable.Code, registerTable.UserAccountDistributeLogo, num); // LogHelper.WriteDebug(desc); //} //XH_AccountHoldTableDal xh_AccountHoldTableDal = new XH_AccountHoldTableDal(); //if (accountHoldList.Count > 0) //{ // foreach (var holdTableInfo in accountHoldList) // { // xh_AccountHoldTableDal.Update(holdTableInfo, tm.Database, tm.Transaction); // } //} ////先添加委托记录 //XH_HistoryEntrustTableDal xh_HistoryEntrustTableDal = new XH_HistoryEntrustTableDal(); //if (historyEntrustList.Count > 0) //{ // foreach (XH_HistoryEntrustTableInfo item in historyEntrustList) // { // xh_HistoryEntrustTableDal.Add(item, tm.Database, tm.Transaction); // } //} ////添加成交记录 ////DataRepository.XhAccountHoldTableProvider.Update(tm, accountHoldList); ////DataRepository.XhHistoryTradeTableProvider.BulkInsert(historyTradeList); //XH_HistoryTradeTableDal xh_HistoryTradeTableDal = new XH_HistoryTradeTableDal(); //if (historyTradeList.Count > 0) //{ // foreach (XH_HistoryTradeTableInfo historyTradeTable in historyTradeList) // { // //DataRepository.XhHistoryTradeTableProvider.Insert(tm, historyTradeTable); // xh_HistoryTradeTableDal.Add(historyTradeTable, tm.Database, tm.Transaction); // } //} ////删除对应的登记记录 ////DataRepository.XhMelonCutRegisterTableProvider.Delete(tm, tables); //XH_MelonCutRegisterTableDal xh_MelonCutRegisterTableDal = new XH_MelonCutRegisterTableDal(); //if (tables.Count > 0) //{ // foreach (var data in tables) // { // xh_MelonCutRegisterTableDal.Delete(data, tm.Database, tm.Transaction); // } //} #endregion #region new code 李健华 2010-06-11 改为因为在每天开市时处理那么生成为当日委托我成交 bool issuc = true; try { List <XH_AccountHoldTableInfo> accountHoldList = new List <XH_AccountHoldTableInfo>(); List <XH_TodayTradeTableInfo> todayTradeList = new List <XH_TodayTradeTableInfo>(); //add 2010-1-15 因为数据库表有的成交记录是根据委托编号有外键关系,所以这里要生成委托记录 List <XH_TodayEntrustTableInfo> todayEntrustList = new List <XH_TodayEntrustTableInfo>(); UA_UserAccountAllocationTableDal dal = new UA_UserAccountAllocationTableDal(); //======== foreach (XH_MelonCutRegisterTableInfo registerTable in tables) { //更新持仓表 List <XH_AccountHoldTableInfo> accountHoldTables = GetAccountHoldList(registerTable.UserAccountDistributeLogo, registerTable.TradeCurrencyType, registerTable.Code); if (Utils.IsNullOrEmpty(accountHoldTables)) { continue; } //过户的量 decimal num = registerTable.RegisterAmount; //四舍五入 num = Math.Round(num); int intNum = decimal.ToInt32(num); XH_AccountHoldTableInfo accountTable = accountHoldTables[0]; SetAccountTable(accountTable, intNum); accountHoldList.Add(accountTable); //更新委托记录表 XH_TodayEntrustTableInfo todayEntrustTable = GetHistoryEntrustTable(registerTable, intNum); todayEntrustList.Add(todayEntrustTable); //更新历史成交表 XH_TodayTradeTableInfo todayTradeTable = GetTodayTradeTable(registerTable, intNum); todayTradeTable.EntrustNumber = todayEntrustTable.EntrustNumber; todayTradeTable.CapitalAccount = todayEntrustTable.CapitalAccount; todayTradeList.Add(todayTradeTable); UA_UserAccountAllocationTableInfo userModel = dal.GetModel(registerTable.UserAccountDistributeLogo); #region 回推相关成交记录信息 ReckonEndObject <XH_TodayEntrustTableInfo, XH_TodayTradeTableInfo> reckonEndObject = new ReckonEndObject <XH_TodayEntrustTableInfo, XH_TodayTradeTableInfo>(); reckonEndObject.IsSuccess = true; reckonEndObject.EntrustTable = todayEntrustTable; List <XH_TodayTradeTableInfo> tradeModels = new List <XH_TodayTradeTableInfo>(); tradeModels.Add(todayTradeTable); reckonEndObject.TradeTableList = tradeModels; if (userModel != null) { reckonEndObject.TradeID = userModel.UserID; } reckonEndObject.Message = "分红委托成交"; CounterOrderService.Instance.AcceptStockDealOrder(reckonEndObject); #endregion string format = "MelonCutService.UpdateStockCut进行股票分红[商品代码={0},持仓帐号={1},分红金额={2}]"; string desc = string.Format(format, registerTable.Code, registerTable.UserAccountDistributeLogo, num); LogHelper.WriteDebug(desc); } XH_AccountHoldTableDal xh_AccountHoldTableDal = new XH_AccountHoldTableDal(); if (accountHoldList.Count > 0) { foreach (var holdTableInfo in accountHoldList) { xh_AccountHoldTableDal.Update(holdTableInfo, tm.Database, tm.Transaction); } } //先添加委托记录 XH_TodayEntrustTableDal xh_HistoryEntrustTableDal = new XH_TodayEntrustTableDal(); if (todayEntrustList.Count > 0) { foreach (XH_TodayEntrustTableInfo item in todayEntrustList) { xh_HistoryEntrustTableDal.Add(item, tm.Database, tm.Transaction); } } //添加成交记录 //DataRepository.XhAccountHoldTableProvider.Update(tm, accountHoldList); //DataRepository.XhHistoryTradeTableProvider.BulkInsert(historyTradeList); XH_TodayTradeTableDal xh_todayTradeTableDal = new XH_TodayTradeTableDal(); if (todayTradeList.Count > 0) { foreach (XH_TodayTradeTableInfo todayTradeTable in todayTradeList) { //DataRepository.XhHistoryTradeTableProvider.Insert(tm, historyTradeTable); xh_todayTradeTableDal.Add(todayTradeTable, tm); } } //删除对应的登记记录 //DataRepository.XhMelonCutRegisterTableProvider.Delete(tm, tables); XH_MelonCutRegisterTableDal xh_MelonCutRegisterTableDal = new XH_MelonCutRegisterTableDal(); if (tables.Count > 0) { foreach (var data in tables) { xh_MelonCutRegisterTableDal.Delete(data, tm.Database, tm.Transaction); } } } catch (Exception ex) { LogHelper.WriteError("过户分红异常" + ex.Message, ex); issuc = false; } return(issuc); #endregion }
/// <summary> /// 对象实体绑定数据 /// </summary> public XH_TodayTradeTableInfo ReaderBind(IDataReader dataReader) { XH_TodayTradeTableInfo model = new XH_TodayTradeTableInfo(); object ojb; model.TradeNumber = dataReader["TradeNumber"].ToString(); model.EntrustNumber = dataReader["EntrustNumber"].ToString(); model.PortfolioLogo = dataReader["PortfolioLogo"].ToString(); ojb = dataReader["TradePrice"]; if (ojb != null && ojb != DBNull.Value) { model.TradePrice = (decimal)ojb; } ojb = dataReader["TradeAmount"]; if (ojb != null && ojb != DBNull.Value) { model.TradeAmount = (int)ojb; } ojb = dataReader["EntrustPrice"]; if (ojb != null && ojb != DBNull.Value) { model.EntrustPrice = (decimal)ojb; } ojb = dataReader["StampTax"]; if (ojb != null && ojb != DBNull.Value) { model.StampTax = (decimal)ojb; } ojb = dataReader["Commission"]; if (ojb != null && ojb != DBNull.Value) { model.Commission = (decimal)ojb; } ojb = dataReader["TransferAccountFee"]; if (ojb != null && ojb != DBNull.Value) { model.TransferAccountFee = (decimal)ojb; } ojb = dataReader["TradeProceduresFee"]; if (ojb != null && ojb != DBNull.Value) { model.TradeProceduresFee = (decimal)ojb; } ojb = dataReader["MonitoringFee"]; if (ojb != null && ojb != DBNull.Value) { model.MonitoringFee = (decimal)ojb; } ojb = dataReader["TradingSystemUseFee"]; if (ojb != null && ojb != DBNull.Value) { model.TradingSystemUseFee = (decimal)ojb; } ojb = dataReader["TradeCapitalAmount"]; if (ojb != null && ojb != DBNull.Value) { model.TradeCapitalAmount = (decimal)ojb; } ojb = dataReader["ClearingFee"]; if (ojb != null && ojb != DBNull.Value) { model.ClearingFee = (decimal)ojb; } model.StockAccount = dataReader["StockAccount"].ToString(); model.CapitalAccount = dataReader["CapitalAccount"].ToString(); model.SpotCode = dataReader["SpotCode"].ToString(); ojb = dataReader["TradeTypeId"]; if (ojb != null && ojb != DBNull.Value) { model.TradeTypeId = (int)ojb; } ojb = dataReader["TradeUnitId"]; if (ojb != null && ojb != DBNull.Value) { model.TradeUnitId = (int)ojb; } ojb = dataReader["BuySellTypeId"]; if (ojb != null && ojb != DBNull.Value) { model.BuySellTypeId = (int)ojb; } ojb = dataReader["CurrencyTypeId"]; if (ojb != null && ojb != DBNull.Value) { model.CurrencyTypeId = (int)ojb; } ojb = dataReader["TradeTime"]; if (ojb != null && ojb != DBNull.Value) { model.TradeTime = (DateTime)ojb; } return(model); }
/// <summary> /// 构建现货成交回报 /// </summary> /// <param name="tet"></param> /// <param name="sdbe"></param> /// <param name="xhcr"></param> /// <param name="dealCapital"></param> /// <param name="tm"></param> /// <returns></returns> public static XH_TodayTradeTableInfo BuildXHDealRpt(XH_TodayEntrustTableInfo tet, StockDealBackEntity sdbe, XHCostResult xhcr, decimal dealCapital, ReckoningTransaction tm) { string result = string.Empty; //成交回报实体 var xhDealrpt = new XH_TodayTradeTableInfo(); //xhDealrpt.TradeNumber = this.BuildXHDealOrderNo(); xhDealrpt.TradeNumber = sdbe.Id; //不再自己构建id,使用成交回报的id,一一对应 //成交时间 xhDealrpt.TradeTime = sdbe.DealTime; //成交价 xhDealrpt.TradePrice = sdbe.DealPrice; //成交单位 xhDealrpt.TradeUnitId = tet.TradeUnitId; //成交量 xhDealrpt.TradeAmount = Convert.ToInt32(sdbe.DealAmount); //股东代码 xhDealrpt.StockAccount = tet.StockAccount; //资金帐户 xhDealrpt.CapitalAccount = tet.CapitalAccount; //成交回报类型 xhDealrpt.TradeTypeId = (int)Types.DealRptType.DRTDealed; //现货名称 xhDealrpt.SpotCode = tet.SpotCode; //印花税 xhDealrpt.StampTax = xhcr.StampDuty; //佣金 xhDealrpt.Commission = xhcr.Commision; //过户费 xhDealrpt.TransferAccountFee = xhcr.TransferToll; //交易系统使用费 xhDealrpt.TradingSystemUseFee = xhcr.TradeSystemFees; //监管费 xhDealrpt.MonitoringFee = xhcr.MonitoringFee; //结算费 xhDealrpt.ClearingFee = xhcr.ClearingFees; //委托价格 xhDealrpt.EntrustPrice = tet.EntrustPrice; //成交金额 xhDealrpt.TradeCapitalAmount = dealCapital; // xhDealrpt.TradePrice*xhDealrpt.TradeAmount;//TODO:是否正确?没有算比例 //投组标识 xhDealrpt.PortfolioLogo = tet.PortfolioLogo; //货币类型 xhDealrpt.CurrencyTypeId = tet.CurrencyTypeId; //买卖方向 xhDealrpt.BuySellTypeId = tet.BuySellTypeId; xhDealrpt.EntrustNumber = tet.EntrustNumber; XH_TodayTradeTableDal xhTodayTradeTableDal = new XH_TodayTradeTableDal(); if (xhTodayTradeTableDal.Exists(xhDealrpt.TradeNumber)) { string format = "BuildXHDealRpt数据库已经存在TradeNumber={0}"; string desc = string.Format(format, xhDealrpt.TradeNumber); LogHelper.WriteDebug(desc); //xhDealrpt = xhTodayTradeTableDal.GetModel(xhDealrpt.TradeNumber); return(null); } try { xhTodayTradeTableDal.Add(xhDealrpt, tm); } catch (Exception ex) { LogHelper.WriteError(ex.Message, ex); xhDealrpt = null; } return(xhDealrpt); }
/// <summary> /// 构建现货撤单成交回报 /// </summary> /// <param name="tet"></param> /// <param name="rde"></param> /// <param name="tm"></param> /// <param name="trade"></param> /// <param name="isInternalCancel"></param> /// <returns></returns> public static string BuildXHCancelRpt(XH_TodayEntrustTableInfo tet, CancelOrderEntity rde, ReckoningTransaction tm, out XH_TodayTradeTableInfo trade, bool isInternalCancel) { string result = string.Empty; //当为价格错误的撤单时,直接作为废单,不记录到数据库中。 if (rde.OrderVolume == -1) { trade = null; return(result); } //成交回报实体 var xhDealrpt = new XH_TodayTradeTableInfo(); //xhDealrpt.TradeNumber = this.BuildXHDealOrderNo(); xhDealrpt.TradeNumber = rde.Id; //不再自己构建id,使用撤单回报的id,一一对应 //成交时间 xhDealrpt.TradeTime = DateTime.Now; //成交价 xhDealrpt.TradePrice = 0; //成交单位 xhDealrpt.TradeUnitId = tet.TradeUnitId; //成交量 xhDealrpt.TradeAmount = Convert.ToInt32(rde.OrderVolume); //股东代码 xhDealrpt.StockAccount = tet.StockAccount; //资金帐户 xhDealrpt.CapitalAccount = tet.CapitalAccount; //成交回报类型 if (isInternalCancel) { xhDealrpt.TradeTypeId = (int)Types.DealRptType.DRTInternalCanceled; } else { xhDealrpt.TradeTypeId = (int)Types.DealRptType.DRTCanceled; } //现货名称 xhDealrpt.SpotCode = tet.SpotCode; //印花税 xhDealrpt.StampTax = 0; //佣金 xhDealrpt.Commission = 0; //过户费 xhDealrpt.TransferAccountFee = 0; //交易系统使用费 xhDealrpt.TradingSystemUseFee = 0; //监管费 xhDealrpt.MonitoringFee = 0; xhDealrpt.ClearingFee = 0; //委托价格 xhDealrpt.EntrustPrice = tet.EntrustPrice; //成交金额 xhDealrpt.TradeCapitalAmount = xhDealrpt.TradePrice * xhDealrpt.TradeAmount; //投组标识 xhDealrpt.PortfolioLogo = tet.PortfolioLogo; //货币类型 xhDealrpt.CurrencyTypeId = tet.CurrencyTypeId; //买卖方向 xhDealrpt.BuySellTypeId = tet.BuySellTypeId; xhDealrpt.EntrustNumber = tet.EntrustNumber; XH_TodayTradeTableDal xhTodayTradeTableDal = new XH_TodayTradeTableDal(); xhTodayTradeTableDal.Add(xhDealrpt, tm); result = xhDealrpt.TradeNumber; trade = xhDealrpt; return(result); }