public System.Data.DataSet GetPkgsByClubCardID(int clubCardID) { StringBuilder strSql = new StringBuilder(); string strWhere = ""; strSql.AppendFormat(" ClubCardID = {0} ", clubCardID); strWhere = strSql.ToString(); return(_daoClubCardPackage.GetList(strWhere)); }
public System.Data.DataSet GetUnavailablePkgs(int clubCardID) { ClubCardPackage _daoClubCardPkg = new ClubCardPackage(); StringBuilder strSql = new StringBuilder(); string strWhere = ""; strSql.AppendFormat(" ClubCardID = '{0}' AND PackageStatus = {1} ", clubCardID, CardSPackageStatus.Unavailable); strWhere = strSql.ToString(); return(_daoClubCardPkg.GetList(strWhere)); }