public LocationInfo LocationInfoIDataReader(IDataReader dr)
{
LocationInfo obj = new DataAccess.LocationInfo();
obj.LocationID = (dr["LocationID"] is DBNull) ? string.Empty : dr["LocationID"].ToString();
obj.xcoor = (dr["xcoor"] is DBNull) ? string.Empty : dr["xcoor"].ToString();
obj.ycoor = (dr["ycoor"] is DBNull) ? string.Empty : dr["ycoor"].ToString();
return(obj);
}
public List <LocationInfo> LocationInfo_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.LocationInfo> list = new List <DataAccess.LocationInfo>();
DataAccess.LocationInfo obj = new DataAccess.LocationInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_LocationInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LocationInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <LocationInfo> LocationInfo_GetByAll()
{
List <DataAccess.LocationInfo> list = new List <DataAccess.LocationInfo>();
DataAccess.LocationInfo obj = new DataAccess.LocationInfo();
DbCommand cmd = db.GetStoredProcCommand("Links_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LocationInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <LocationInfo> LocationInfo_Paging(string CurentLocationInfo, string LocationInfoSize)
{
List <DataAccess.LocationInfo> list = new List <DataAccess.LocationInfo>();
DataAccess.LocationInfo obj = new DataAccess.LocationInfo();
DbCommand cmd = db.GetStoredProcCommand("Links_SelectPage", CurentLocationInfo, LocationInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LocationInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
