public Link LinkIDataReader(IDataReader dr)
{
DataAccess.Link obj = new DataAccess.Link();
obj.ID = (dr["ID"] is DBNull) ? string.Empty : dr["ID"].ToString();
obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString();
obj.Line1 = (dr["Line1"] is DBNull) ? string.Empty : dr["Line1"].ToString();
obj.Line2 = (dr["Line2"] is DBNull) ? string.Empty : dr["Line2"].ToString();
obj.Link1 = (dr["Link1"] is DBNull) ? string.Empty : dr["Link1"].ToString();
obj.Link2 = (dr["Link2"] is DBNull) ? string.Empty : dr["Link2"].ToString();
obj.Position = (dr["Position"] is DBNull) ? string.Empty : dr["Position"].ToString();
obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString();
obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString();
obj.Lang = (dr["Lang"] is DBNull) ? string.Empty : dr["Lang"].ToString();
return(obj);
}
public List <Link> Link_Paging(string CurentPage, string PageSize, string Lang)
{
List <DataAccess.Link> list = new List <DataAccess.Link>();
DataAccess.Link obj = new DataAccess.Link();
DbCommand cmd = db.GetStoredProcCommand("Links_SelectPage", CurentPage, PageSize, Lang);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LinkIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <Link> Link_GetByTop(string Top, string Where, string Order)
{
List <DataAccess.Link> list = new List <DataAccess.Link>();
DataAccess.Link obj = new DataAccess.Link();
DbCommand cmd = db.GetStoredProcCommand("Links_SelectTop", Top, Where, Order);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LinkIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
