public List <Page> Page_GetByAll(string Lang) { List <DataAccess.Page> list = new List <DataAccess.Page>(); DataAccess.Page obj = new DataAccess.Page(); DbCommand cmd = db.GetStoredProcCommand("Pages_SelectAll", Lang); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.PageIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <Page> Page_GetByLevel(string Level, string Lang, int LevelLength) { List <DataAccess.Page> list = new List <DataAccess.Page>(); DataAccess.Page obj = new DataAccess.Page(); DbCommand cmd = db.GetStoredProcCommand("sp_Page_GetByLevel", Level, Lang, LevelLength); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.PageIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <Page> Page_GetByTop(string Top, string Where, string Order) { List <DataAccess.Page> list = new List <DataAccess.Page>(); DataAccess.Page obj = new DataAccess.Page(); DbCommand cmd = db.GetStoredProcCommand("Pages_SelectTop", Top, Where, Order); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.PageIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public Page PageIDataReader(IDataReader dr) { DataAccess.Page obj = new DataAccess.Page(); obj.PageID = (dr["PageID"] is DBNull) ? string.Empty : dr["PageID"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Tag = (dr["Tag"] is DBNull) ? string.Empty : dr["Tag"].ToString(); obj.Content = (dr["Content"] is DBNull) ? string.Empty : dr["Content"].ToString(); obj.Detail = (dr["Detail"] is DBNull) ? string.Empty : dr["Detail"].ToString(); obj.Level = (dr["Level"] is DBNull) ? string.Empty : dr["Level"].ToString(); obj.Title = (dr["Title"] is DBNull) ? string.Empty : dr["Title"].ToString(); obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString(); obj.Keyword = (dr["Keyword"] is DBNull) ? string.Empty : dr["Keyword"].ToString(); obj.Type = (dr["Type"] is DBNull) ? string.Empty : dr["Type"].ToString(); obj.Link = (dr["Link"] is DBNull) ? string.Empty : dr["Link"].ToString(); obj.Target = (dr["Target"] is DBNull) ? string.Empty : dr["Target"].ToString(); obj.Position = (dr["Position"] is DBNull) ? string.Empty : dr["Position"].ToString(); obj.Index = (dr["Index"] is DBNull) ? string.Empty : dr["Index"].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); }