public RealEstateInfo RealEstateInfoIDataReader(IDataReader dr) { DataAccess.RealEstateInfo obj = new DataAccess.RealEstateInfo(); obj.RealEstateID = (dr["RealEstateID"] is DBNull) ? string.Empty : dr["RealEstateID"].ToString(); obj.RealEstateName = (dr["RealEstateName"] is DBNull) ? string.Empty : dr["RealEstateName"].ToString(); obj.RealEstateTypeID = (dr["RealEstateTypeID"] is DBNull) ? string.Empty : dr["RealEstateTypeID"].ToString(); obj.LocationID = (dr["LocationID"] is DBNull) ? string.Empty : dr["LocationID"].ToString(); obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString(); obj.CityID = (dr["CityID"] is DBNull) ? string.Empty : dr["CityID"].ToString(); obj.CreateBy = (dr["CreateBy"] is DBNull) ? string.Empty : dr["CreateBy"].ToString(); obj.CreateDate = (dr["CreateDate"] is DBNull) ? string.Empty : dr["CreateDate"].ToString(); obj.DistrictID = (dr["DistrictID"] is DBNull) ? string.Empty : dr["DistrictID"].ToString(); obj.RealEstateOwnersID = (dr["RealEstateOwnersID"] is DBNull) ? string.Empty : dr["RealEstateOwnersID"].ToString(); obj.Address = (dr["Address"] is DBNull) ? string.Empty : dr["Address"].ToString(); obj.Price = (dr["Price"] is DBNull) ? string.Empty : dr["Price"].ToString(); obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString(); obj.Area = (dr["Area"] is DBNull) ? string.Empty : dr["Area"].ToString(); obj.Lengh = (dr["Lengh"] is DBNull) ? string.Empty : dr["Lengh"].ToString(); obj.Width = (dr["Width"] is DBNull) ? string.Empty : dr["Width"].ToString(); obj.Height = (dr["Height"] is DBNull) ? string.Empty : dr["Height"].ToString(); obj.Images = (dr["Images"] is DBNull) ? string.Empty : dr["Images"].ToString(); obj.Status = (dr["Status"] is DBNull) ? string.Empty : dr["Status"].ToString(); obj.IsVip = (dr["IsVip"] is DBNull) ? string.Empty : dr["IsVip"].ToString(); obj.Period = (dr["Period"] is DBNull) ? string.Empty : dr["Period"].ToString(); return(obj); }
public List <RealEstateInfo> RealEstateInfo_GetByAll() { List <DataAccess.RealEstateInfo> list = new List <DataAccess.RealEstateInfo>(); DataAccess.RealEstateInfo obj = new DataAccess.RealEstateInfo(); DbCommand cmd = db.GetStoredProcCommand("RealEstates_SelectAll"); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <RealEstateInfo> RealEstateInfo_GetByLevel(string Level, int LevelLength) { List <DataAccess.RealEstateInfo> list = new List <DataAccess.RealEstateInfo>(); DataAccess.RealEstateInfo obj = new DataAccess.RealEstateInfo(); DbCommand cmd = db.GetStoredProcCommand("sp_RealEstateInfo_GetByLevel", Level, LevelLength); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <RealEstateInfo> RealEstateInfo_Paging(string CurentRealEstateInfo, string RealEstateInfoSize) { List <DataAccess.RealEstateInfo> list = new List <DataAccess.RealEstateInfo>(); DataAccess.RealEstateInfo obj = new DataAccess.RealEstateInfo(); DbCommand cmd = db.GetStoredProcCommand("RealEstates_SelectPage", CurentRealEstateInfo, RealEstateInfoSize); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.RealEstateInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }