public LandTypeInfo LandTypeInfoIDataReader(IDataReader dr)
{
LandTypeInfo obj = new DataAccess.LandTypeInfo();
obj.LandTypeID = (dr["LandTypeID"] is DBNull) ? string.Empty : dr["LandTypeID"].ToString();
obj.LandTypeName = (dr["LandTypeName"] is DBNull) ? string.Empty : dr["LandTypeName"].ToString();
return(obj);
}
public List <LandTypeInfo> LandTypeInfo_GetByAll()
{
List <DataAccess.LandTypeInfo> list = new List <DataAccess.LandTypeInfo>();
DataAccess.LandTypeInfo obj = new DataAccess.LandTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("Group_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LandTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <LandTypeInfo> LandTypeInfo_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.LandTypeInfo> list = new List <DataAccess.LandTypeInfo>();
DataAccess.LandTypeInfo obj = new DataAccess.LandTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_LandTypeInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LandTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <LandTypeInfo> LandTypeInfo_Paging(string CurentLandTypeInfo, string LandTypeInfoSize)
{
List <DataAccess.LandTypeInfo> list = new List <DataAccess.LandTypeInfo>();
DataAccess.LandTypeInfo obj = new DataAccess.LandTypeInfo();
DbCommand cmd = db.GetStoredProcCommand("Group_SelectPage", CurentLandTypeInfo, LandTypeInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LandTypeInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
