基于WEB的新聞發(fā)布系統(tǒng)

#4管理員查看,刪除用戶頁(yè)面：管理員可以搜索相關(guān)用戶查看或者刪除該用戶。首頁(yè)管理新聞悴理用產(chǎn)懺排髀并用「宜世：|系統(tǒng)ah?二fl用「宜世：|系統(tǒng)ah?二flIB■^-^133TiM,制厚口國(guó)23a-Z-dlkti-F-3BmsDED■1^4tf]i]5LTi4.>24*HI味O國(guó)2:10.141*2^1M-|H>13D]I克我年齡 時(shí)落謝阪遙中用戶管理用戶：管理員進(jìn)行用戶的搜索和用戶信息的刪除//查看普通用戶信息publicDataSetGetUsersInfo(){using(SqlConnectionconn=newSqlConnection(connString)){DataSetds=newDataSet();try{SqlCommandsqlCmd=newSqlCommand();sqlCmd.Connection=conn;SqlDataAdapterda=newSqlDataAdapter(sqlCmd);sqlCmd.CommandText="proc_usersInfo";//存儲(chǔ)過(guò)程名sqlCmd.CommandType=CommandType.StoredProcedure;conn.Open();da.Fill(ds,"users");returnds;}catch{returnds;}finally{conn.Close();}}}//根據(jù)用戶名查找用戶信息publicDataSetFindUsersInfo(stringuserName){using(SqlConnectionconn=newSqlConnection(connString)){DataSetds=newDataSet();StringBuildersbSql=newStringBuilder();sbSql.Append("select*fromusers");sbSql.Append("where");sbSql.Append("username=@UserName");SqlParameter[]para=newSqlParameter[]{newSqlParameter("@UserName",userName)};SqlCommandsqlCmd=newSqlCommand(sbSql.ToString(),conn);sqlCmd.Parameters.AddRange(para);SqlDataAdapterda=newSqlDataAdapter(sqlCmd);try{conn.Open();da.Fill(ds,"users");returnds;}catch{returnds;}finally{conn.Close();}}}//刪除普通用戶publicvoidDeleteUsersInfo(stringuserName){StringBuildersbSql=newStringBuilder();//從用戶表中刪除sbSql.Append("deletefromusers");sbSql.Append("where");sbSql.Append("username=@UserName");//從收藏夾表中刪除sbSql.Append("deletefromcollection");sbSql.Append("where");sbSql.Append("username=@UserName");//從留言表中刪除sbSql.Append("deletefromleave_word");sbSql.Append("where");sbSql.Append("username=@UserName");SqlParameter[]para=newSqlParameter[]{newSqlParameter("@UserName",userName)};using(SqlConnectionconn=newSqlConnection(connString)){using(SqlCommandsqlCmd=newSqlCommand(sbSql.ToString(),conn)){sqlCmd.Parameters.AddRange(para);sqlCmd.Connection.Open();intresult=sqlCmd.ExecuteNonQuery();sqlCmd.Connection.Close();Convert.ToString(result);}}}4管理員查看,刪除留言頁(yè)面所有雷吉所有雷吉內(nèi)百用尸卷布B才同林巾aao23：S3：S2o這是利EaDDfzojsjj/r-23睥應(yīng)力Btmo1國(guó)送中冒*管理留言：管理員進(jìn)行留言查看和刪除〃根據(jù)NewsId獲取留言，返回DataSetpublicDataSetGetLeaveWordInfo(stringnewsId){using(SqlConnectionconn=newSqlConnection(connString)){DataSetds=newDataSet();StringBuildersbSql=newStringBuilder();sbSql.Append("select*fromleave_word");sbSql.Append("where");sbSql.Append("newsid=@NewsId");sbSql.Append("orderbyposttimeDESC");SqlParameter口para=newSqlParameter口{newSqlParameter("@NewsId",newsId)}；SqlCommandsqlCmd=newSqlCommand(sbSql.ToString(),conn);sqlCmd.Parameters.AddRange(para);SqlDataAdapterda=newSqlDataAdapter(sqlCmd);try{conn.Open();da.Fill(ds,"leave_word");returnds;catch(Exceptionex)throwex;finallyconn.Close();//根據(jù)留言編號(hào)刪除留言publicvoidDeleteLwInfo(stringlwId){StringBuildersbSql=newStringBuilder();sbSql.Append("deletefromleave_word");sbSql.Append("where");sbSql.Append("lwid=@lwId");SqlParameter[]para=newSqlParameter[]{newSqlParameter("@lwId",lwId)};using(SqlConnectionconn=newSqlConnection(connString)){using(SqlCommandsqlCmd=newSqlCommand(sbSql.ToString(),conn)){sqlCmd.Parameters.AddRange(para);sqlCmd.Connection.Open();intresult=sqlCmd.ExecuteNonQuery();sqlCmd.Connection.Close();Convert.ToString(result);存儲(chǔ)過(guò)程pro_allNewsInfo：select*fromnewsorderbysysdateDESCpro_chinaNewsInfo：selecttop5*fromnewswheretype=1orderbysysdateDESCpro_Collection：select*fromnewspro_hotNewsInfo：selecttop10*fromnewsord