public static int GetTotalOfAdvertisements(int zoneId, ADSearchType listType, string keyword) { return(dal.GetTotalOfAdvertisements()); }
public IList <AdvertisementInfo> GetAdvertisementList(int startRowIndexId, int maxNumberRows, int zoneId, ADSearchType listType, string keyword) { string str2; Database database = DatabaseFactory.CreateDatabase(); IList <AdvertisementInfo> list = new List <AdvertisementInfo>(); string storedProcedureName = "PR_Common_GetList"; DbCommand storedProcCommand = database.GetStoredProcCommand(storedProcedureName); switch (listType) { case ADSearchType.ADName: str2 = " ADName LIKE '%" + DBHelper.FilterBadChar(keyword) + "%' "; break; case ADSearchType.Intro: str2 = "ADIntro LIKE '%" + DBHelper.FilterBadChar(keyword) + "%' "; break; case ADSearchType.Zone: str2 = " AdId IN (SELECT ADID FROM PE_Zone_Advertisement WHERE ZoneId = " + zoneId + ") "; break; default: str2 = null; break; } database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId); database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows); database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "ADId"); database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "*"); database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC"); database.AddInParameter(storedProcCommand, "@Filter", DbType.String, str2); database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_Advertisement"); database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows); using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand))) { while (reader.Read()) { list.Add(AdvertisementFromrdr(reader)); } } this.m_NumAdvertisements = (int)database.GetParameterValue(storedProcCommand, "@Total"); return(list); }
public static IList <AdvertisementInfo> GetAdvertisementList(int startRowIndex, int maximumRows, int zoneId, ADSearchType listType, string keyword) { return(dal.GetAdvertisementList(startRowIndex, maximumRows, zoneId, listType, keyword)); }