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);
}