public RealEstateNewsInfo RealEstateNewsInfoIDataReader(IDataReader dr)
{
DataAccess.RealEstateNewsInfo obj = new DataAccess.RealEstateNewsInfo();
obj.RealEstateNewsID = (dr["RealEstateNewsID"] is DBNull) ? string.Empty : dr["RealEstateNewsID"].ToString();
obj.RealEstateID = (dr["RealEstateID"] is DBNull) ? string.Empty : dr["RealEstateID"].ToString();
obj.Title = (dr["Title"] is DBNull) ? string.Empty : dr["Title"].ToString();
obj.Content = (dr["Content"] is DBNull) ? string.Empty : dr["Content"].ToString();
obj.Position = (dr["Position"] is DBNull) ? string.Empty : dr["Position"].ToString();
obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString();
obj.CategoryID = (dr["CategoryID"] is DBNull) ? string.Empty : dr["CategoryID"].ToString();
obj.Images = (dr["Images"] is DBNull) ? string.Empty : dr["Images"].ToString();
obj.CreateBy = (dr["CreateBy"] is DBNull) ? string.Empty : dr["CreateBy"].ToString();
obj.CreateDate = (dr["CreateDate"] is DBNull) ? string.Empty : dr["CreateDate"].ToString();
obj.Source = (dr["Source"] is DBNull) ? string.Empty : dr["Source"].ToString();
obj.Lang = (dr["Lang"] is DBNull) ? string.Empty : dr["Lang"].ToString();
return(obj);
}
public List <RealEstateNewsInfo> RealEstateNewsInfo_GetByAll()
{
List <DataAccess.RealEstateNewsInfo> list = new List <DataAccess.RealEstateNewsInfo>();
DataAccess.RealEstateNewsInfo obj = new DataAccess.RealEstateNewsInfo();
DbCommand cmd = db.GetStoredProcCommand("RealEstateNews_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateNewsInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <RealEstateNewsInfo> RealEstateNewsInfo_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.RealEstateNewsInfo> list = new List <DataAccess.RealEstateNewsInfo>();
DataAccess.RealEstateNewsInfo obj = new DataAccess.RealEstateNewsInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_RealEstateNewsInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateNewsInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <RealEstateNewsInfo> RealEstateNewsInfo_Paging(string CurentRealEstateNewsInfo, string RealEstateNewsInfoSize)
{
List <DataAccess.RealEstateNewsInfo> list = new List <DataAccess.RealEstateNewsInfo>();
DataAccess.RealEstateNewsInfo obj = new DataAccess.RealEstateNewsInfo();
DbCommand cmd = db.GetStoredProcCommand("RealEstateNews_SelectPage", CurentRealEstateNewsInfo, RealEstateNewsInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateNewsInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
