public static BinhLuanCollection SelectAll() { var c = HttpRuntime.Cache; var obj = c[CacheKeyAll]; if (obj == null) { var list = new BinhLuanCollection(); using (var rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssBinhLuan_Select_SelectAll_linhnx")) { while (rd.Read()) { list.Add(getFromReader(rd)); } } c.Insert(CacheKeyAll, list); return(list); } return((BinhLuanCollection)obj); }
public static BinhLuanCollection SelectByTinId(string T_ID, string Active) { BinhLuanCollection List = new BinhLuanCollection(); SqlParameter[] obj = new SqlParameter[2]; obj[0] = new SqlParameter("T_ID", T_ID); if (string.IsNullOrEmpty(Active)) { obj[1] = new SqlParameter("Active", DBNull.Value); } else { obj[1] = new SqlParameter("Active", Active); } using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssBinhLuan_Select_SelectByTinId_linhnx", obj)) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }