public List <RealEstateTypeInfo> RealEstateTypeInfo_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.RealEstateTypeInfo> list = new List <DataAccess.RealEstateTypeInfo>();
DataAccess.RealEstateTypeInfo obj = new DataAccess.RealEstateTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_RealEstateTypeInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <RealEstateTypeInfo> RealEstateTypeInfo_GetByAll()
{
List <DataAccess.RealEstateTypeInfo> list = new List <DataAccess.RealEstateTypeInfo>();
DataAccess.RealEstateTypeInfo obj = new DataAccess.RealEstateTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("RealEstateType_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <RealEstateTypeInfo> RealEstateTypeInfo_Paging(string CurentRealEstateTypeInfo, string RealEstateTypeInfoSize)
{
List <DataAccess.RealEstateTypeInfo> list = new List <DataAccess.RealEstateTypeInfo>();
DataAccess.RealEstateTypeInfo obj = new DataAccess.RealEstateTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("RealEstateType_SelectPage", CurentRealEstateTypeInfo, RealEstateTypeInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.RealEstateTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
