/// <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);
}
