PageContent 这个字段没选择，请测试。public IList<PubClassInfo> GetClassList()
{
IList<PubClassInfo> list = new List<PubClassInfo>();
string Sql = "select Id,ClassID,ClassCName,ClassEName,ParentID,IsURL,URLaddress,ClassTemplet,SavePath,SaveClassframe,ClassSaveRule";
Sql += ",ClassIndexRule,SiteID,NaviPIC,NaviContent,MetaKeywords,MetaDescript,isDelPoint,Gpoint,iPoint,GroupNumber,NaviShowtf,NaviPosition,NewsPosition,isPage,
PageContent";
Sql += " from " + Pre + "news_Class where isRecyle=0 and isLock=0";
IDataReader rd = DbHelper.ExecuteReader(CommandType.Text, Sql, null);
while (rd.Read())
{
PubClassInfo info = new PubClassInfo();
info.Id = (int)rd["Id"];
info.ClassID = rd["ClassID"].ToString();
if (rd["ClassCName"] != DBNull.Value) info.ClassCName = rd["ClassCName"].ToString();
if (rd["ClassEName"] != DBNull.Value) info.ClassEName = rd["ClassEName"].ToString();
if (rd["ParentID"] != DBNull.Value) info.ParentID = rd["ParentID"].ToString();
if (rd["IsURL"] != DBNull.Value) info.IsURL = Convert.ToInt32(rd["IsURL"].ToString());
if (rd["URLaddress"] != DBNull.Value) info.URLaddress = rd["URLaddress"].ToString();
if (rd["ClassTemplet"] != DBNull.Value) info.ClassTemplet = rd["ClassTemplet"].ToString();
if (rd["SavePath"] != DBNull.Value) info.SavePath = rd["SavePath"].ToString();
if (rd["SaveClassframe"] != DBNull.Value) info.SaveClassframe = rd["SaveClassframe"].ToString();
if (rd["ClassSaveRule"] != DBNull.Value) info.ClassSaveRule = rd["ClassSaveRule"].ToString();
if (rd["ClassIndexRule"] != DBNull.Value) info.ClassIndexRule = rd["ClassIndexRule"].ToString();
if (rd["SiteID"] != DBNull.Value) info.SiteID = rd["SiteID"].ToString();
if (rd["NaviPIC"] != DBNull.Value) info.NaviPIC = rd["NaviPIC"].ToString();
if (rd["NaviContent"] != DBNull.Value) info.NaviContent = rd["NaviContent"].ToString();
if (rd["MetaKeywords"] != DBNull.Value) info.MetaKeywords = rd["MetaKeywords"].ToString();
if (rd["MetaDescript"] != DBNull.Value) info.MetaDescript = rd["MetaDescript"].ToString();
if (rd["isDelPoint"] != DBNull.Value) info.isDelPoint = Convert.ToInt32(rd["isDelPoint"].ToString());
if (rd["Gpoint"] != DBNull.Value) info.Gpoint = Convert.ToInt32(rd["Gpoint"].ToString());
if (rd["iPoint"] != DBNull.Value) info.iPoint = Convert.ToInt32(rd["iPoint"].ToString());
if (rd["GroupNumber"] != DBNull.Value) info.GroupNumber = rd["GroupNumber"].ToString();
if (rd["NaviPosition"] != DBNull.Value) info.NaviPosition = rd["NaviPosition"].ToString();
if (rd["NewsPosition"] != DBNull.Value) info.NewsPosition = rd["NewsPosition"].ToString();
if (rd["isPage"] != DBNull.Value) info.isPage = Convert.ToInt32(rd["isPage"].ToString());
if (rd["NaviShowtf"] != DBNull.Value) info.NaviShowtf = Convert.ToInt32(rd["NaviShowtf"].ToString());
if (rd["PageContent"] != DBNull.Value) info.PageContent = rd["PageContent"].ToString();
list.Add(info);
}
rd.Close();
return list;
}
