Example #1
0
        public System.Data.DataSet GetAvailablePkgs(int clubCardID)
        {
            ClubCardPackage _daoClubCardPkg = new ClubCardPackage();
            StringBuilder strSql = new StringBuilder();
            string strWhere = "";

            strSql.AppendFormat(" ClubCardID = '{0}' AND  PackageStatus = {1} ", clubCardID, (int)CardSPackageStatus.Available);
            strWhere = strSql.ToString();

            return _daoClubCardPkg.GetList(strWhere);
        }