/// <summary> /// 根据委托单号获取历史委托 /// </summary> /// <param name="entrustNumber">委托单号</param> /// <returns>今日委托</returns> public static HK_HistoryEntrustInfo GetHistoryEntrustTable(string entrustNumber) { HK_HistoryEntrustInfo tet = null; HK_HistoryEntrustDal dal = new HK_HistoryEntrustDal(); try { tet = dal.GetModel(entrustNumber); } catch (Exception ex) { LogHelper.WriteError(ex.Message, ex); } return(tet); }
/// <summary> /// Title:根据用户和密码查询该用户所拥有的港股资金帐户历史期货委托信息 /// Des.:此方法因为一个用户(交易员)可能拥有多个港股资金账号(如:-商品港股资金帐号,-股指港股资金帐号) /// 所以返回的数据会回多个资金账号的数据 /// </summary> /// <param name="userID">用户(交易员)ID</param> /// <param name="pwd">用户(交易员)密码--如果密码为空时不验证密码</param> /// <param name="accountType">账号类型(数据库中BD_AccountType的九种) 如果传为0时查询对应的港股持仓账号类别(3--证券股东代码,9--港股股东代码)</param> /// <param name="filter">过滤条件数据</param> /// <param name="pageInfo">分页信息</param> /// <param name="total">返回数页数</param> /// <param name="errorMsg">异常信息</param> /// <returns>返回当日期货委托信息</returns> public List <HK_HistoryEntrustInfo> PagingHK_HistoryEntrustByFilter(string userID, string pwd, int accountType, HKEntrustConditionFindEntity filter, PagingInfo pageInfo, out int total, out string errorMsg) { List <HK_HistoryEntrustInfo> list = null; HK_HistoryEntrustDal dal = new HK_HistoryEntrustDal(); errorMsg = ""; total = 0; #region 密码不为空时先验证用户 if (string.IsNullOrEmpty(userID)) { errorMsg = "查询失败!失败原因为:交易员ID不能为空!"; return(list); } if (!string.IsNullOrEmpty(pwd)) { #region 从数据库中判断 //UA_UserBasicInformationTableDal usDal = new UA_UserBasicInformationTableDal(); //if (!usDal.Exists(userID, pwd)) //{ // errorMsg = "查询失败!失败原因为:交易员ID或密码输入错误 !"; // return list; //} #endregion #region 从缓存中判断 UA_UserBasicInformationTableInfo userInfo = AccountManager.Instance.GetBasicUserByUserId(userID); if (userInfo == null) { errorMsg = "交易员对应类型的帐号不存在"; return(list); } if (userInfo.Password != pwd) { errorMsg = "交易员密码错误"; return(list); } #endregion } #endregion if (filter != null && !string.IsNullOrEmpty(filter.EntrustNumber)) //委托单号(当只根据委托单号查询时) { #region 如果有委托单号直接查询唯一记录 list = dal.GetListArray(" EntrustNumber='" + filter.EntrustNumber + "'"); if (!Utils.IsNullOrEmpty(list)) { total = 1; } #endregion } else //当不带委托单号时 { #region 如果分页信息为空返回异常 if (pageInfo == null) { errorMsg = "分页信息不能为空!"; return(null); } #endregion #region 分页存储过程相关信息组装 PagingProceduresInfo ppInfo = new PagingProceduresInfo(); ppInfo.IsCount = pageInfo.IsCount; ppInfo.PageNumber = pageInfo.CurrentPage; ppInfo.PageSize = pageInfo.PageLength; ppInfo.Fields = " EntrustNumber,PortfolioLogo,EntrustPrice,EntrustMount,Code,TradeAmount,TradeAveragePrice,OrderPriceType,CancelAmount,BuySellTypeID,HoldAccount,CapitalAccount,CurrencyTypeID,TradeUnitID,OrderStatusID,OrderMessage,McOrderID,HasDoneProfit,OfferTime,EntrustTime,IsModifyOrder,ModifyOrderNumber "; ppInfo.PK = "EntrustNumber"; if (pageInfo.Sort == 0) { ppInfo.Sort = " EntrustTime asc "; } else { ppInfo.Sort = " EntrustTime desc "; } ppInfo.Tables = "HK_HistoryEntrust"; #endregion #region 过滤条件组装 ppInfo.Filter = BuildHKEntrustQueryWhere(filter, userID, accountType, false); #endregion #region 执行查询 try { CommonDALOperate <HK_HistoryEntrustInfo> com = new CommonDALOperate <HK_HistoryEntrustInfo>(); list = com.PagingQueryProcedures(ppInfo, out total, dal.ReaderBind); } catch (Exception ex) { errorMsg = ex.Message; LogHelper.WriteError(ex.ToString(), ex); } #endregion } return(list); }