新聞發(fā)布系統(tǒng)設(shè)計源碼

/**說明：數(shù)據(jù)庫助手類*/usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Configuration;namespaceDAL{publicclassSQLHelper{privateSqlConnectionconn=null;privateSqlCommandcmd=null;privateSqlDataReadersdr=null;publicSQLHelper(){stringconnStr=ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;conn=newSqlConnection(connStr);}privateSqlConnectionGetConn(){if(conn.State==ConnectionState.Closed){conn.Open();}returnconn;}///<summary>///執(zhí)行不帶參數(shù)的增刪改SQL語句或存儲過程///</summary>///<paramname="cmdText">增刪改SQL語句或存儲過程</param>///<paramname="ct">命令類型</param>///<returns></returns>publicintExecuteNonQuery(stringcmdText,CommandTypect){intres;try{cmd=newSqlCommand(cmdText,GetConn());cmd.CommandType=ct;res=cmd.ExecuteNonQuery();}catch(Exceptionex){throwex;}finally{if(conn.State==ConnectionState.Open){conn.Close();}}returnres;}///<summary>///執(zhí)行帶參數(shù)的增刪改SQL語句或存儲過程///</summary>///<paramname="cmdText">增刪改SQL語句或存儲過程</param>///<paramname="ct">命令類型</param>///<returns></returns>publicintExecuteNonQuery(stringcmdText,SqlParameter[]paras,CommandTypect){intres;using(cmd=newSqlCommand(cmdText,GetConn())){cmd.CommandType=ct;cmd.Parameters.AddRange(paras);res=cmd.ExecuteNonQuery();}returnres;}///<summary>///執(zhí)行查詢SQL語句或存儲過程///</summary>///<paramname="cmdText">查詢SQL語句或存儲過程</param>///<paramname="ct">命令類型</param>///<returns></returns>publicDataTableExecuteQuery(stringcmdText,CommandTypect){DataTabledt=newDataTable();cmd=newSqlCommand(cmdText,GetConn());cmd.CommandType=ct;using(sdr=cmd.ExecuteReader(CommandBehavior.CloseConnection)){dt.Load(sdr);}returndt;}///<summary>///執(zhí)行帶參數(shù)的查詢SQL語句或存儲過程///</summary>///<paramname="cmdText">查詢SQL語句或存儲過程</param>///<paramname="paras">參數(shù)集合</param>///<paramname="ct">命令類型</param>///<returns></returns>publicDataTableExecuteQuery(stringcmdText,SqlParameter[]paras,CommandTypect){DataTabledt=newDataTable();cmd=newSqlCommand(cmdText,GetConn());cmd.CommandType=ct;cmd.Parameters.AddRange(paras);using(sdr=cmd.ExecuteReader(CommandBehavior.CloseConnection)){dt.Load(sdr);}returndt;}}}/**類說明：新聞類別實體類*/namespaceModel{///<summary>///新聞類別實體類///</summary>publicclassCategory{privatestringid;///<summary>///主鍵,自增///</summary>publicstringId{get{returnid;}set{id=value;}}privatestringname;///<summary>///類別名稱///</summary>publicstringName{get{returnname;}set{name=value;}}publicCategory(stringid,stringname){this.id=id;=name;}}}/**類說明：新聞評論實體類*/namespaceModel{///<summary>///新聞評論實體類///</summary>publicclassComment{privatestringid;///<summary>///主鍵，自增///</summary>publicstringId{get{returnid;}set{id=value;}}privatestringcontent;///<summary>///評論內(nèi)容///</summary>publicstringContent{get{returncontent;}set{content=value;}}privatestringuserIp;///<summary>///評論人IP///</summary>publicstringUserIp{get{returnuserIp;}set{userIp=value;}}privatestringcreateTime;///<summary>///評論發(fā)表時間///</summary>publicstringCreateTime{get{returncreateTime;}set{createTime=value;}}privatestringnewsId;///<summary>///所屬新聞ID///</summary>publicstringNewsId{get{returnnewsId;}set{newsId=value;}}publicComment(){}publicComment(stringcontent,stringuserIp,stringnewsId){this.content=content;this.userIp=userIp;this.newsId=newsId;}}}/**類說明：新聞實體類*/namespaceModel{///<summary>///新聞實體類///</summary>publicclassNews{privatestringid;///<summary>///主鍵，自增///</summary>publicstringId{get{returnid;}set{id=value;}}privatestringtitle;///<summary>///新聞標題///</summary>publicstringTitle{get{returntitle;}set{title=value;}}privatestringcontent;///<summary>///新聞內(nèi)容///</summary>publicstringContent{get{returncontent;}set{content=value;}}privatestringcreateTime;///<summary>///新聞發(fā)表時間///</summary>publicstringCreateTime{get{returncreateTime;}set{createTime=value;}}privatestringcaId;///<summary>///新聞所屬類別ID///</summary>publicstringCaId{get{returncaId;}set{caId=value;}}publicNews(){}publicNews(stringtitle,stringcontent,stringcaid){this.title=title;this.content=content;this.caId=caid;}publicNews(stringid,stringtitle,stringcontent,stringcaid){this.id=id;this.title=title;this.content=content;this.caId=caid;}}}/**說明：新聞類別表操作類*/usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingModel;namespaceDAL{///<summary>///新聞類別表操作類///</summary>publicclassCategoryDAO{privateSQLHelpersqlhelper=null;publicCategoryDAO(){sqlhelper=newSQLHelper();}///<summary>///取出當前所有新聞分類///</summary>///<returns></returns>publicDataTableSelectAll(){DataTabledt=newDataTable();stringsql="select*fromcategory";dt=sqlhelper.ExecuteQuery(sql,CommandType.Text);returndt;}///<summary>///增加類別///</summary>///<paramname="caName">類別名稱</param>///<returns></returns>publicboolInsert(stringcaName){boolflag=false;stringsql="insertintocategory(name)values(@caName)";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@caName",caName)};intres=sqlhelper.ExecuteNonQuery(sql,paras,CommandType.Text);if(res>0){flag=true;}returnflag;}///<summary>///修改類別///</summary>///<paramname="id">類別ID</param>///<paramname="caName">類別名稱</param>///<returns></returns>publicboolUpdate(Categoryca){boolflag=false;stringsql="updatecategoryset[name]=@caNamewhereid=@id";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@id",ca.Id),newSqlParameter("@caName",ca.Name)};intres=sqlhelper.ExecuteNonQuery(sql,paras,CommandType.Text);if(res>0){flag=true;}returnflag;}///<summary>///刪除類別（連同其下的新聞及新聞評論一起刪除）///</summary>///<paramname="id">類別ID</param>///<returns></returns>publicboolDelete(stringid){boolflag=false;stringsql="deletefromcategorywhereid=@id";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@id",id)};intres=sqlhelper.ExecuteNonQuery(sql,paras,CommandType.Text);if(res>0){flag=true;}returnflag;}///<summary>///判斷類別名稱是否已存在///</summary>///<paramname="caName">類別名稱</param>///<returns></returns>publicboolIsExists(stringcaName){boolflag=false;stringsql="select*fromcategorywhere[name]='"+caName+"'";DataTabledt=sqlhelper.ExecuteQuery(sql,CommandType.Text);if(dt.Rows.Count>0){flag=true;}returnflag;}}}/**說明：評論表操作類*/usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingModel;namespaceDAL{publicclassCommentDAO{privateSQLHelpersqlhelper;publicCommentDAO(){sqlhelper=newSQLHelper();}///<summary>///根據(jù)新聞ID取出該新聞的所有評論///</summary>///<paramname="newsId">新聞ID</param>///<returns></returns>publicDataTableSelectByNewsId(stringnewsId){DataTabledt=newDataTable();stringsql="select*fromcommentwherenewsId=@newsIdorderbycreateTimedesc";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@newsId",newsId)};dt=sqlhelper.ExecuteQuery(sql,paras,CommandType.Text);returndt;}///<summary>///添加評論///</summary>///<paramname="c">評論實體類</param>///<returns></returns>publicboolInsert(Commentc){boolflag=false;stringsql="insertintocomment([content],userIp,newsId)values(@content,@userIp,@newsId)";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@content",c.Content),newSqlParameter("@userIp",c.UserIp),newSqlParameter("@newsId",c.NewsId)};intres=sqlhelper.ExecuteNonQuery(sql,paras,CommandType.Text);if(res>0){flag=true;}returnflag;}///<summary>///刪除評論///</summary>///<paramname="id">評論ID</param>///<returns></returns>publicboolDelete(stringid){boolflag=false;stringsql="deletecommentwhereid=@id";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@id",id)};intres=sqlhelper.ExecuteNonQuery(sql,paras,CommandType.Text);if(res>0){flag=true;}returnflag;}}}/**說明：新聞表操作類*/usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingModel;namespaceDAL{publicclassNewsDAO{privateSQLHelpersqlhelper;publicNewsDAO(){sqlhelper=newSQLHelper();}#region選擇全部新聞///<summary>///選擇全部新聞///</summary>///<returns></returns>publicDataTableSelectAll(){DataTabledt=newDataTable();stringsql="select*fromnews";dt=newSQLHelper().ExecuteQuery(sql,CommandType.Text);returndt;}#endregion#region通過類別ID選擇新聞///<summary>///根據(jù)類別ID取出該類別下的所有新聞///</summary>///<paramname="caid">類別ID</param>///<returns></returns>publicDataTableSelectByCaId(stringcaid){//TODO:根據(jù)類別ID取出該類別下的所有新聞DataTabledt=newDataTable();stringcmdText="news_selectByCaId";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@caid",caid)};dt=sqlhelper.ExecuteQuery(cmdText,paras,CommandType.StoredProcedure);returndt;}#endregion#region通過新聞ID查看新聞///<summary>///根據(jù)新聞ID取出該條新聞主體內(nèi)容///</summary>///<paramname="id">新聞ID</param>///<returns></returns>publicNewsSelectById(stringid){//TODO:根據(jù)新聞ID取出該條新聞主體內(nèi)容Newsn=newNews();DataTabledt=newDataTable();stringcmdText="news_selectById";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@id",id)};dt=sqlhelper.ExecuteQuery(cmdText,paras,CommandType.StoredProcedure);n.Id=id;n.Title=dt.Rows[0]["title"].ToString();n.Content=dt.Rows[0]["content"].ToString();n.CreateTime=dt.Rows[0]["createTime"].ToString();n.CaId=dt.Rows[0]["caId"].ToString();returnn;}#endregion#region通過標題查找新聞///<summary>///根據(jù)標題搜索新聞///</summary>///<paramname="title">新聞標題關(guān)鍵字</param>///<returns></returns>publicDataTableSelectByTitle(stringtitle){//TODO:根據(jù)標題搜索新聞DataTabledt=newDataTable();stringcmdText="news_selectByTitle";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@title",title)};dt=sqlhelper.ExecuteQuery(cmdText,paras,CommandType.StoredProcedure);returndt;}#endregion#region通過內(nèi)容查找新聞///<summary>///根據(jù)內(nèi)容搜索新聞///</summary>///<paramname="content">新聞內(nèi)容關(guān)鍵字</param>///<returns></returns>publicDataTableSelectByContent(stringcontent){//TODO:根據(jù)內(nèi)容搜索新聞DataTabledt=newDataTable();stringcmdText="news_selectByContent";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@content",content)};dt=sqlhelper.ExecuteQuery(cmdText,paras,CommandType.StoredProcedure);returndt;}#endregion#region增加新聞///<summary>///增加新聞///</summary>///<paramname="n">新聞實體現(xiàn)</param>///<returns></returns>publicboolInsert(Newsn){//TODO:增加新聞boolflag=false;stringcmdText="news_insert";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@title",n.Title),newSqlParameter("@content",n.Content),newSqlParameter("@caid",n.CaId)};intres=sqlhelper.ExecuteNonQuery(cmdText,paras,CommandType.StoredProcedure);if(res>0){flag=true;}returnflag;}#endregion#region修改新聞///<summary>///修改新聞///</summary>///<paramname="n">新聞實體類</param>///<returns></returns>publicboolUpdate(Newsn){//TODO:修改新聞boolflag=false;stringcmdText="news_update";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@id",n.Id),newSqlParameter("@title",n.Title),newSqlParameter("@content",n.Content),newSqlParameter("@caid",n.CaId)};intres=sqlhelper.ExecuteNonQuery(cmdText,paras,CommandType.StoredProcedure);if(res>0){flag=true;}returnflag;}#endregion#region刪除新聞///<summary>///刪除新聞（連同其下新聞評論一起刪除）///</summary>///<paramname="id">新聞ID</param>///<returns></returns>publicboolDelete(stringid){//TODO:刪除新聞boolflag=false;stringcmdText="news_delete";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@id",id)};intres=sqlhelper.ExecuteNonQuery(cmdText,paras,CommandType.StoredProcedure);if(res>0){flag=true;}returnflag;}#endregion}}/**說明：新聞類別表的業(yè)務(wù)類*/usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingDAL;usingModel;usingSystem.Data;usingSystem.Data.SqlClient;namespaceBLL{publicclassCategoryManager{privateCategoryDAOcdao=null;publicCategoryManager(){cdao=newCategoryDAO();}#region取出當前所有新聞分類///<summary>///取出當前所有新聞分類///</summary>///<returns></returns>publicDataTableSelectAll(){returncdao.SelectAll();}#endregion#region增加類別///<summary>///增加類別///</summary>///<paramname="caName">類別名稱</param>///<returns></returns>publicboolInsert(stringcaName){returncdao.Insert(caName);}#endregion#region修改類別///<summary>///修改類別///</summary>///<paramname="id">類別ID</param>///<paramname="caName">類別名稱</param>///<returns></returns>publicboolUpdate(Categoryca){returncdao.Update(ca);}#endregion#region刪除類別///<summary>///刪除類別（連同其下的新聞及新聞評論一起刪除）///</summary>///<paramname="id">類別ID</param>///<returns></returns>publicboolDelete(stringid){returncdao.Delete(id);}#endregion#region判斷類別名稱是否已存在///<summary>///判斷類別名稱是否已存在///</summary>///<paramname="caName">類別名稱</param>///<returns></returns>publicboolIsExists(stringcaName){returncdao.IsExists(caName);}#endregion}}usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingDAL;usingModel;usingSystem.Data;usingSystem.Data.SqlClient;namespaceBLL{publicclassCommentManager{privateCommentDAOcdao=null;publicCommentManager(){cdao=newCommentDAO();}#region根據(jù)新聞ID取出該新聞的所有評論///<summary>///根據(jù)新聞ID取出該新聞的所有評論///</summary>///<paramname="newsId">新聞ID</param>///<returns></returns>publicDataTableSelectByNewsId(stringnewsId){returncdao.SelectByNewsId(newsId);}#endregion#region添加評論///<summary>///添加評論///</summary>///<paramname="c">評論實體類</param>///<returns></returns>publicboolInsert(Commentc){returncdao.Insert(c);}#endregion#region刪除評論///<summary>///刪除評論///</summary>///<paramname="id">評論ID</param>///<returns></returns>publicboolDelete(stringid){returncdao.Delete(id);}#endregion}}/**說明：登陸的業(yè)務(wù)邏輯類*/usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;namespaceBLL{publicclassLoginManager{#region用戶登陸是否成功///<summary>///用戶登陸是否成功///</summary>///<paramname="name">用戶名</param>///<paramname="pwd">密碼</param>///<returns></returns>publicstaticboolLogin(stringname,stringpwd){boolflag=false;if("login"==name&&"9CE853EB7EE8E362E1D121EB4DF2DC91"==pwd){flag=true;}returnflag;}#endregion}}usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;publicpartialclassManger_Top:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){}}usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;publicpartialclassAdminManage_Login:System.Web.UI.Page{CommonClassCC=newCommonClass();protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){this.labCode.Text=CC.RandomNum(4);//產(chǎn)生驗證碼}}protectedvoidbtnLogin_Click(objectsender,EventArgse){if(txtAdminName.Text.Trim()==""||txtAdminPwd.Text.Trim()==""){Response.Write(CC.MessageBox("登錄名和密碼不能為空！","Login.aspx"));//Response.Write("<script>alert('登錄名和密碼不能為空！');location='javascript:history.go(-1)';</script>");}else{//判斷用戶輸入的驗證碼是否正確if(txtAdminCode.Text.Trim()==labCode.Text.Trim()){//調(diào)用CommonClass類中的checkLogin方法，判斷用戶是否為合法用戶intIntUserIn=CC.checkLogin(txtAdminName.Text.Trim(),txtAdminPwd.Text.Trim());if(IntUserIn>0){//該用戶為合法用戶，跳轉(zhuǎn)到后臺首頁（AdminIndex.aspx）中Response.Write("<scriptlanguage=javascript>window.open('AdminIndex.aspx');window.close();</script>");}else{//該用戶不是合法用戶，調(diào)用CommonClass類中的MassageBox方法，彈出提示框Response.Write(CC.MessageBox("您輸入的用戶名或密碼錯誤，請重新輸入！","Login.aspx"));}}else{Response.Write(CC.MessageBox("驗證碼輸入有誤，請重新輸入！","Login.aspx"));}}}protectedvoidbtnCancel_Click(objectsender,EventArgse){Response.Write("<script>window.close();location='javascript:history.go(-1)';</script>");}}usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;publicpartialclassmanage_list:System.Web.UI.Page{CommonClassCC=newCommonClass();//定義一個靜態(tài)的全局變量，用于標識是否已單擊站內(nèi)搜索控鈕publicstaticintIntSearch;protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){//頁面初始化時，指定IntSearch=0IntSearch=0;//使用Request對象獲取頁面?zhèn)鬟f的值intn=Convert.ToInt32(Request.QueryString["id"]);//指定新聞類別名this.ddlNewsStyle.SelectedIndex=(n-1);this.bind();}}protectedvoidbind(){//調(diào)用CommonClass類的GetDataSet方法，查詢需要管理的新聞信息，并綁定GridView控件上this.gvNewsList.DataSource=CC.GetDataSet("select*fromtb_Newswherestyle='"+this.ddlNewsStyle.SelectedValue.Trim()+"'orderbyid","tbNews");this.gvNewsList.DataKeyNames=newstring[]{"id"};this.gvNewsList.DataBind();}protectedvoidsearchBind(){//使用Like運算符，定義一個查詢字符串stringstrSql="select*fromtb_Newswherestyle='"+this.ddlNewsStyle.SelectedValue.ToString()+"'";strSql+="and((contentlike'%"+this.txtKey.Text+"%')";strSql+="or(Titlelike'%"+this.txtKey.Text+"%'))";//調(diào)用CommonClass類的GetDataSet方法，獲取符合條件的新聞信息//將獲取的新聞信息綁定到數(shù)據(jù)控件GridView控件中g(shù)vNewsList.DataSource=CC.GetDataSet(strSql,"tbNews");gvNewsList.DataKeyNames=newstring[]{"id"};gvNewsList.DataBind();}protectedvoidgvNewsList_RowDeleting(objectsender,GridViewDeleteEventArgse){//調(diào)用CommonClass類的ExecSQL方法，刪除指定的新聞CC.ExecSQL("deletefromtb_Newswhereid='"+this.gvNewsList.DataKeys[e.RowIndex].Value.ToString()+"'");if(IntSearch==1){this.searchBind();}else{bind();}}protectedvoidbtnSearch_Click(objectsender,EventArgse){//單擊站內(nèi)搜索按鈕時，IntSearch=1;IntSearch=1;this.searchBind();}protectedvoidgvNewsList_PageIndexChanging(objectsender,GridViewPageEventArgse){gvNewsList.PageIndex=e.NewPageIndex;if(IntSearch==1){this.searchBind();}else{bind();}}protectedvoidgvNewsList_RowDataBound(objectsender,GridViewRowEventArgse){if(e.Row.RowType==DataControlRowType.DataRow){e.Row.Cells[3].Text=Convert.ToDateTime(e.Row.Cells[3].Text).ToShortDateString();}}}usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclassManger_MemberAdd:System.Web.UI.Page{CommonClassCC=newCommonClass();protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidbtnCancel_Click(objectsender,EventArgse){txtName.Text="";txtPass.Text="";}protectedvoidbtnSave_Click(objectsender,EventArgse){if(txtName.Text==""){