/// <summary> /// 重写application的内容 /// </summary> public static void reWriteApplication() { ListItem li; BulletedList fulllist = new BulletedList(); newClasses.superConn scnn = new newClasses.superConn("DATA.MDB"); scnn.open(); string _sql = "SELECT * FROM T_SUBMENU WHERE MENU_ENABLE=TRUE ORDER BY MENU_CLASSID,MENU_ORDER DESC"; System.Data.OleDb.OleDbDataReader dr = scnn.GetDataReader(_sql); while (dr.Read()) { li = new ListItem(); li.Text = dr["menu_ttl"].ToString(); li.Value = dr["menu_url"].ToString(); li.Attributes.Add("classid", dr["menu_classid"].ToString());//增加一个classid属性 fulllist.Items.Add(li); } scnn.close(); HttpContext.Current.Application.Lock(); HttpContext.Current.Application["submenu"] = fulllist; HttpContext.Current.Application.UnLock(); }
/// <summary> /// 根据新闻的ID,从数据库获取新闻和相关信息; /// </summary> /// <param name="newsid"></param> public superNewsItem(int newsid) { superConn scnn = new superConn("DATA.mdb"); scnn.open(); string _sql = "SELECT T_NEWS.*, T_imgMng.img_url, List_newsClass.nc_ttl FROM List_newsClass INNER JOIN (T_imgMng INNER JOIN T_NEWS ON T_imgMng.img_id = T_NEWS.news_imgid) ON List_newsClass.nc_id = T_NEWS.news_ncid WHERE news_id=" + newsid; OleDbDataReader dr = scnn.GetDataReader(_sql); if (dr.Read()) { news_id = int.Parse(dr["news_id"].ToString()); news_ncid = int.Parse(dr["news_ncid"].ToString()); nc_ttl = dr["nc_ttl"].ToString(); news_ttl = dr["news_ttl"].ToString(); news_guide = dr["news_guide"].ToString(); news_date = (DateTime)dr["news_date"]; news_imgid = int.Parse(dr["news_imgid"].ToString()); img_url = dr["img_url"].ToString(); news_content = dr["news_content"].ToString(); news_order = int.Parse(dr["news_order"] is DBNull ? "0" : dr["new_order"].ToString()); news_enable = (Boolean)dr["news_enable"]; news_home = (Boolean)dr["news_home"]; } scnn.close(); }
/// <summary> /// 以类别ID来设置新闻所属类别 /// </summary> /// <param name="classID"></param> public void setClass(int classID) { superConn scnn = new superConn("DATA.mdb"); scnn.open(); string _sql = "SELECT * FROM List_newsClass WHERE nc_id=" + classID; OleDbDataReader dr = scnn.GetDataReader(_sql); if (dr.Read()) { news_ncid = int.Parse(dr["nc_id"].ToString()); nc_ttl = dr["nc_ttl"].ToString(); } scnn.close(); }
//2 public superFile(int _id) { _fileName = _fileTitle = ""; superConn sconn = new superConn("fileMNG.mdb"); sconn.open(); string _sql = "SELECT * FROM T_FILES WHERE f_id=" + _id; OleDbDataReader dr = sconn.GetDataReader(_sql); if (dr.Read()) { _fileTitle = dr["f_title"].ToString(); _fileName = dr["f_name"].ToString(); } sconn.close(); }
/// <summary> /// 通过ID从数据库获取对应ID的文章 /// </summary> /// <param name="artID"></param> public superArtReader(string artID) { ArtID = artID; ArtTitle = ""; ArtContent = ""; superConn scnn = new superConn("DATA.mdb"); scnn.open(); string _sql = "select * from T_article WHERE art_id=" + artID; OleDbDataReader dr = scnn.GetDataReader(_sql); if (dr.Read()) { ArtTitle = dr["art_ttl"].ToString(); ArtContent = dr["art_content"].ToString(); } scnn.close(); }