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