/// <summary> /// 获取角色实体 /// </summary> /// <param name="roleID"></param> /// <returns></returns> public Base_Roles GetRoleInfo(int roleID) { string sqlQuery = string.Format("(NOLOCK) WHERE RoleID= {0}", roleID); Base_Roles role = aideRoleProvider.GetObject <Base_Roles>(sqlQuery); return(role); }
/// <summary> /// 获取实卡实体,根据CardID /// </summary> /// <param name="cardID"></param> /// <returns></returns> public LivcardAssociator GetLivcardAssociatorInfo(int cardID) { string sqlQuery = string.Format("(NOLOCK) WHERE CardID= '{0}'", cardID); LivcardAssociator livcardAssociator = aideLivcardAssociatorProvider.GetObject <LivcardAssociator>(sqlQuery); return(livcardAssociator); }
/// <summary> /// 获取用户密保信息 /// </summary> /// <param name="pid">密保ProtectID</param> /// <returns></returns> public AccountsProtect GetAccountsProtectByPID(int pid) { string sqlQuery = string.Format("(NOLOCK) WHERE ProtectID= N'{0}'", pid); AccountsProtect model = aideAccountsProtectProvider.GetObject <AccountsProtect>(sqlQuery); return(model); }
/// <summary> /// 获取规则实体 /// </summary> /// <param name="kindID"></param> /// <returns></returns> public GameRulesInfo GetGameRulesInfo(int kindID) { string sqlQuery = string.Format("(NOLOCK) WHERE KindID= {0}", kindID); GameRulesInfo gameRules = aideGameRulesProvider.GetObject <GameRulesInfo>(sqlQuery); return(gameRules); }
/// <summary> /// 获取机器实体 /// </summary> /// <param name="dBInfoID"></param> /// <returns></returns> public DataBaseInfo GetDataBaseInfo(int dBInfoID) { string sqlQuery = string.Format("(NOLOCK) WHERE DBInfoID= {0}", dBInfoID); DataBaseInfo dataBase = aideDataBaseInfoProvider.GetObject <DataBaseInfo>(sqlQuery); return(dataBase); }
/// <summary> /// 获取用户对象 by userName /// </summary> /// <param name="accounts"></param> /// <returns></returns> public Base_Users GetUserByAccounts(string userName) { string sqlQuery = string.Format("(NOLOCK) WHERE UserName= N'{0}'", userName); Base_Users user = aideUserProvider.GetObject <Base_Users>(sqlQuery); return(user); }
/// <summary> /// 获取用户基本信息 /// </summary> /// <param name="userID">用户UserID</param> /// <returns></returns> public AccountsInfo GetAccountInfoByUserID(int userID) { string sqlQuery = string.Format("(NOLOCK) WHERE UserID= N'{0}'", userID); AccountsInfo model = aideAccountsProvider.GetObject <AccountsInfo>(sqlQuery); if (model != null) { return(model); } else { return(new AccountsInfo()); } }
/// <summary> /// 获取密码修改记录 /// </summary> /// <param name="rid">记录ID</param> /// <returns></returns> public RecordPasswdExpend GetRecordPasswdExpendByRid(int rid) { string sqlQuery = string.Format("(NOLOCK) WHERE RecordID= N'{0}'", rid); RecordPasswdExpend model = aideRecordPasswdExpendProvider.GetObject <RecordPasswdExpend>(sqlQuery); return(model); }
/// <summary> /// 获取消息实体 /// </summary> /// <param name="id"></param> /// <returns></returns> public SystemMessage GetSystemMessageInfo(int id) { string sqlQuery = string.Format("(NOLOCK) WHERE ID= {0}", id); SystemMessage systemMessage = aideSystemMessageProvider.GetObject <SystemMessage>(sqlQuery); return(systemMessage); }
/// <summary> /// 获取游戏房间实体 /// </summary> /// <param name="gameID"></param> /// <returns></returns> public GameRoomInfo GetGameRoomInfoInfo(int serverID) { string sqlQuery = string.Format("(NOLOCK) WHERE ServerID= {0}", serverID); GameRoomInfo gameRoomInfo = aideGameRoomInfoProvider.GetObject <GameRoomInfo>(sqlQuery); return(gameRoomInfo); }
/// <summary> /// 获取用户卡线信息 /// </summary> /// <param name="userID">用户UserID</param> /// <returns></returns> public GameScoreLocker GetGameScoreLockerByUserID(int userID) { string sqlQuery = string.Format("(NOLOCK) WHERE UserID= N'{0}'", userID); GameScoreLocker model = aideGameScoreLocker.GetObject <GameScoreLocker>(sqlQuery); return(model); }
/// <summary> /// 获取新闻实体 /// </summary> /// <param name="newsID"></param> /// <returns></returns> public News GetNewsInfo(int newsID) { string sqlQuery = string.Format("(NOLOCK) WHERE NewsID= {0}", newsID); News news = aideNewsProvider.GetObject <News>(sqlQuery); return(news); }
/// <summary> /// 获取公告实体 /// </summary> /// <param name="noticeID"></param> /// <returns></returns> public Notice GetNoticeInfo(int noticeID) { string sqlQuery = string.Format("(NOLOCK) WHERE NoticeID= {0}", noticeID); Notice notice = aideNoticeProvider.GetObject <Notice>(sqlQuery); return(notice); }
/// <summary> /// 获取问题实体 /// </summary> /// <param name="issueID"></param> /// <returns></returns> public GameIssueInfo GetGameIssueInfo(int issueID) { string sqlQuery = string.Format("(NOLOCK) WHERE IssueID= {0}", issueID); GameIssueInfo gameIssue = aideGameIssueProvider.GetObject <GameIssueInfo>(sqlQuery); return(gameIssue); }
/// <summary> /// 获取用户详细信息 /// </summary> /// <param name="userID">用户UserID</param> /// <returns></returns> public IndividualDatum GetAccountDetailByUserID(int userID) { string sqlQuery = string.Format("(NOLOCK) WHERE UserID= N'{0}'", userID); IndividualDatum model = aideIndividualDatumProvider.GetObject <IndividualDatum>(sqlQuery); return(model); }
/// <summary> /// 获取限制机器码 /// </summary> /// <param name="strSerial">限制机器码表主健</param> /// <returns></returns> public ConfineMachine GetConfineMachineBySerial(string strSerial) { string sqlQuery = string.Format("(NOLOCK) WHERE MachineSerial= N'{0}'", strSerial); ConfineMachine model = aideConfineMachineProvider.GetObject <ConfineMachine>(sqlQuery); return(model); }
/// <summary> /// 获取 /// </summary> /// <param name="newsID"></param> /// <returns></returns> public Contents GetContentInfo(int id) { string sqlQuery = string.Format("(NOLOCK) WHERE id= {0}", id); Contents info = aidContent.GetObject <Contents>(sqlQuery); return(info); }
/// <summary> /// 根据用户ID获取积分实体 /// </summary> /// <param name="userId">用户ID</param> /// <returns></returns> public GameScoreInfo GetSocreInfoByUserId(int userId) { string sqlQuery = string.Format("(NOLOCK) WHERE UserID= N'{0}'", userId); GameScoreInfo model = aideGameScoreInfo.GetObject <GameScoreInfo>(sqlQuery); return(model); }
/// <summary> /// 获取实卡类型实体 /// </summary> /// <param name="cardTypeID"></param> /// <returns></returns> public GlobalLivcard GetGlobalLivcardInfo(int cardTypeID) { string sqlQuery = string.Format("(NOLOCK) WHERE CardTypeID= '{0}'", cardTypeID); GlobalLivcard globalLivcard = aideGlobalLivcardProvider.GetObject <GlobalLivcard>(sqlQuery); return(globalLivcard); }
/// <summary> /// 获取机器人实体 /// </summary> /// <param name="userID"></param> /// <returns></returns> public AndroidManager GetAndroidInfo(int userID) { string sqlQuery = string.Format("(NOLOCK) WHERE UserID= {0}", userID); AndroidManager android = aideAndroidProvider.GetObject <AndroidManager>(sqlQuery); return(android); }
/// <summary> /// 获取反馈实体 /// </summary> /// <param name="feedbackID"></param> /// <returns></returns> public GameFeedbackInfo GetGameFeedbackInfo(int feedbackID) { string sqlQuery = string.Format("(NOLOCK) WHERE FeedbackID= {0}", feedbackID); GameFeedbackInfo gameFeedback = aideGameFeedbackProvider.GetObject <GameFeedbackInfo>(sqlQuery); return(gameFeedback); }
/// <summary> /// 获取限制地址 /// </summary> /// <param name="strAddress">限制地址表主健</param> /// <returns></returns> public ConfineAddress GetConfineAddressByAddress(string strAddress) { string sqlQuery = string.Format("(NOLOCK) WHERE AddrString= N'{0}'", strAddress); ConfineAddress model = aideConfineAddressProvider.GetObject <ConfineAddress>(sqlQuery); return(model); }
/// <summary> /// 获取比赛实体 /// </summary> /// <param name="matchID"></param> /// <returns></returns> public GameMatchInfo GetGameMatchInfo(int matchID) { string sqlQuery = string.Format("(NOLOCK) WHERE MatchID= {0}", matchID); GameMatchInfo match = aideGameMatchInfoProvider.GetObject <GameMatchInfo>(sqlQuery); return(match); }
/// <summary> /// 获取系统配置信息 /// </summary> /// <param name="siteID"></param> /// <returns></returns> public QPAdminSiteInfo GetQPAdminSiteInfo(int siteID) { string sqlQuery = string.Format("(NOLOCK) WHERE SiteID= {0}", siteID); QPAdminSiteInfo site = aideQPAdminSiteInfoProvider.GetObject <QPAdminSiteInfo>(sqlQuery); return(site); }
/// <summary> /// 获取广告实体 /// </summary> /// <param name="ID">广告ID</param> /// <returns>广告实体</returns> public Ads GetAds(int ID) { string sqlQuery = string.Format(" WHERE ID={0}", ID); Ads ads = aideAdsProvider.GetObject <Ads>(sqlQuery); return(ads); }
/// <summary> /// 获取充值服务类型 /// </summary> /// <param name="shareID"></param> /// <returns></returns> public GlobalShareInfo GetGlobalShareByShareID(int shareID) { string sqlQuery = string.Format("(NOLOCK) WHERE ShareID= N'{0}'", shareID); GlobalShareInfo globalShare = aideGlobalShareProvider.GetObject <GlobalShareInfo>(sqlQuery); return(globalShare); }
/// <summary> /// 获取泡点规则实体 /// </summary> /// <param name="serverID"></param> /// <returns></returns> public GlobalPlayPresent GetGlobalPlayPresentInfo(int serverID) { string sqlQuery = string.Format("(NOLOCK) WHERE ServerID= {0}", serverID); GlobalPlayPresent globalPlayPresent = aideGlobalPlayPresentProvider.GetObject <GlobalPlayPresent>(sqlQuery); return(globalPlayPresent); }
/// <summary> /// 获取用户金币信息 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public GameScoreInfo GetGameScoreInfoByUserID(int UserID) { string sqlQuery = string.Format("(NOLOCK) WHERE UserID= N'{0}'", UserID); GameScoreInfo gameScoreInfo = aideGameScoreInfoProvider.GetObject <GameScoreInfo>(sqlQuery); return(gameScoreInfo); }
/// <summary> /// 获取配置信息实体 /// </summary> /// <param name="statusName"></param> /// <returns></returns> public SystemStatusInfo GetSystemStatusInfo(string statusName) { string sqlQuery = string.Format("(NOLOCK) WHERE StatusName= '{0}'", statusName); SystemStatusInfo systemStatusInfo = aideSystemStatusInfoProvider.GetObject <SystemStatusInfo>(sqlQuery); return(systemStatusInfo); }
/// <summary> /// 获取游戏实体 /// </summary> /// <param name="gameID"></param> /// <returns></returns> public GameKindItem GetGameKindItemInfo(int kindID) { string sqlQuery = string.Format("(NOLOCK) WHERE KindID= {0}", kindID); GameKindItem gameKindItem = aideGameKindItemProvider.GetObject <GameKindItem>(sqlQuery); return(gameKindItem); }