C# (CSharp) DbFacade.SQLQueryObjectById Examples

Example #1

File: UserOrgDAO.cs Project: aaronuhmgmailcom/HaiHong-Consumables-Buyer

 /// <summary>
 /// Gets the user org by id.
 /// </summary>
 /// <param name="id">The id.</param>
 /// <returns></returns>
 public UserOrg GetUserOrgById(string id)
 {
     return(DbFacade.SQLQueryObjectById(getSelectOneByIdSql(), id, new MapRow(Map_USR_ORG)) as UserOrg);
 }

Example #2

File: UserModuleDAO.cs Project: aaronuhmgmailcom/HaiHong-Consumables-Buyer

 /// <summary>
 /// Gets the user key by id.
 /// </summary>
 /// <param name="id">The id.</param>
 /// <returns></returns>
 public UserModule GetUserKeyById(string id)
 {
     return(DbFacade.SQLQueryObjectById(getSelectOneByIdSql(), id, new MapRow(MapGPO_USR_MODULE)) as UserModule);
 }

Example #3

File: UserRegionRangeDAO.cs Project: aaronuhmgmailcom/HaiHong-Consumables-Buyer

 /// <summary>
 /// Gets the user region range by region id.
 /// </summary>
 /// <param name="regionId">The region id.</param>
 /// <returns></returns>
 public UserRegionRange GetUserRegionRangeByRegionId(string regionId)
 {
     return(DbFacade.SQLQueryObjectById(getSelectOneByRegionIdSql(), regionId, new MapRow(MapGPO_USR_REGION_RANGE)) as UserRegionRange);
 }

Example #4

 /// <summary>
 /// Gets the user key.
 /// </summary>
 /// <param name="id">The id.</param>
 public UserKey GetUserKeyById(string id)
 {
     return(DbFacade.SQLQueryObjectById(getSelectOneByIdSql(), id, new MapRow(MapGPO_USR_USER_KEY)) as UserKey);
 }

Example #5

 /// <summary>
 /// Gets the user region by id.
 /// </summary>
 /// <param name="id">The id.</param>
 /// <returns></returns>
 public UserRegion GetUserRegionById(string id)
 {
     return(DbFacade.SQLQueryObjectById(getSelectOneByIdSql(), id, new MapRow(MapGPO_USR_REGION)) as UserRegion);
 }

Example #6

File: LoginUserOfflineDao.cs Project: aaronuhmgmailcom/HaiHong-Consumables-Buyer

 /// <summary>
 /// Gets the user region range by userid.
 /// </summary>
 /// <param name="userId">The id.</param>
 /// <returns></returns>
 public UserArea GetUserAreaByUserId(string userId)
 {
     return(DbFacade.SQLQueryObjectById(getAreaByIdSql(), userId, new MapRow(MapGPO_USR_USER_AREA)) as UserArea);
 }

Example #7

File: LoginUserOfflineDao.cs Project: aaronuhmgmailcom/HaiHong-Consumables-Buyer

 /// <summary>
 /// Gets the user role by id.
 /// </summary>
 /// <param name="id">The id.</param>
 /// <returns></returns>
 public UserRole GetUserRoleById(string id)
 {
     return(DbFacade.SQLQueryObjectById(getRoleByIdSql(), id, new MapRow(MapGPO_USR_ROLE)) as UserRole);
 }

Example #8

File: LoginUserOfflineDao.cs Project: aaronuhmgmailcom/HaiHong-Consumables-Buyer

 /// <summary>
 /// Gets the user info.
 /// </summary>
 /// <param name="code">The code.</param>
 /// <returns></returns>
 public Emedchina.TradeAssistant.Model.User.UserInfo GetUserInfoByCode(string code)
 {
     return(DbFacade.SQLQueryObjectById(getSelectOneByCodeSql(), code, new MapRow(Map_USR_USER)) as UserInfo);
 }

Example #9

File: UserOrgTypeDAO.cs Project: aaronuhmgmailcom/HaiHong-Consumables-Buyer

 /// <summary>
 /// Gets the user org type by id.
 /// </summary>
 /// <param name="id">The id.</param>
 /// <returns></returns>
 public UserOrgType GetUserOrgTypeById(string id)
 {
     return(DbFacade.SQLQueryObjectById(getSelectOneByIdSql(), id, new MapRow(MapGPO_USR_ORG_TYPE)) as UserOrgType);
 }