public LandInfo LandInfoIDataReader(IDataReader dr)
{
LandInfo obj = new DataAccess.LandInfo();
obj.LandID = (dr["LandID"] is DBNull) ? string.Empty : dr["LandID"].ToString();
obj.LandTypeID = (dr["LandTypeID"] is DBNull) ? string.Empty : dr["LandTypeID"].ToString();
obj.RealEstateOwnersID = (dr["RealEstateOwnersID"] is DBNull) ? string.Empty : dr["RealEstateOwnersID"].ToString();
obj.RealEstateOwnersTypeID = (dr["RealEstateOwnersTypeID"] is DBNull) ? string.Empty : dr["RealEstateOwnersTypeID"].ToString();
obj.RealEstateID = (dr["RealEstateID"] is DBNull) ? string.Empty : dr["RealEstateID"].ToString();
obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString();
obj.Title = (dr["Title"] is DBNull) ? string.Empty : dr["Title"].ToString();
obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString();
obj.RealEstateOwnersName = (dr["RealEstateOwnersName"] is DBNull) ? string.Empty : dr["RealEstateOwnersName"].ToString();
obj.TransactionType = (dr["TransactionType"] is DBNull) ? string.Empty : dr["TransactionType"].ToString();
obj.Tag = (dr["Tag"] is DBNull) ? string.Empty : dr["Tag"].ToString();
obj.Address = (dr["Address"] is DBNull) ? string.Empty : dr["Address"].ToString();
obj.CreateDate = (dr["CreateDate"] is DBNull) ? string.Empty : dr["CreateDate"].ToString();
obj.CreateBy = (dr["CreateBy"] is DBNull) ? string.Empty : dr["CreateBy"].ToString();
obj.CityID = (dr["CityID"] is DBNull) ? string.Empty : dr["CityID"].ToString();
obj.DistrictID = (dr["DistrictID"] is DBNull) ? string.Empty : dr["DistrictID"].ToString();
obj.LocationID = (dr["LocationID"] is DBNull) ? string.Empty : dr["LocationID"].ToString();
obj.Price = (dr["Price"] is DBNull) ? string.Empty : dr["Price"].ToString();
obj.TotalArea = (dr["TotalArea"] is DBNull) ? string.Empty : dr["TotalArea"].ToString();
obj.Image1 = (dr["Image1"] is DBNull) ? string.Empty : dr["Image1"].ToString();
obj.Image2 = (dr["Image2"] is DBNull) ? string.Empty : dr["Image2"].ToString();
obj.Image3 = (dr["Image3"] is DBNull) ? string.Empty : dr["Image3"].ToString();
obj.Image4 = (dr["Image4"] is DBNull) ? string.Empty : dr["Image4"].ToString();
obj.Image5 = (dr["Image5"] is DBNull) ? string.Empty : dr["Image5"].ToString();
obj.Image6 = (dr["Image6"] is DBNull) ? string.Empty : dr["Image6"].ToString();
return(obj);
}
public List <LandInfo> LandInfo_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.LandInfo> list = new List <DataAccess.LandInfo>();
DataAccess.LandInfo obj = new DataAccess.LandInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_LandInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LandInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <LandInfo> LandInfo_GetByAll()
{
List <DataAccess.LandInfo> list = new List <DataAccess.LandInfo>();
DataAccess.LandInfo obj = new DataAccess.LandInfo();
DbCommand cmd = db.GetStoredProcCommand("Group_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LandInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <LandInfo> LandInfo_Paging(string CurentLandInfo, string LandInfoSize)
{
List <DataAccess.LandInfo> list = new List <DataAccess.LandInfo>();
DataAccess.LandInfo obj = new DataAccess.LandInfo();
DbCommand cmd = db.GetStoredProcCommand("Group_SelectPage", CurentLandInfo, LandInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LandInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
