新闻发布系统设计源码

/**说明：数据库助手类*/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>///执行不带参数的增删改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>///执行带参数的增删改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>///执行查询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>///执行带参数的查询SQL语句或存储过程///</summary>///<paramname="cmdText">查询SQL语句或存储过程</param>///<paramname="paras">参数集合</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>///评论内容///</summary>publicstringContent{get{returncontent;}set{content=value;}}privatestringuserIp;///<summary>///评论人IP///</summary>publicstringUserIp{get{returnuserIp;}set{userIp=value;}}privatestringcreateTime;///<summary>///评论发表时间///</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>///新闻内容///</summary>publicstringContent{get{returncontent;}set{content=value;}}privatestringcreateTime;///<summary>///新闻发表时间///</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>///根据新闻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>///根据类别ID取出该类别下的所有新闻///</summary>///<paramname="caid">类别ID</param>///<returns></returns>publicDataTableSelectByCaId(stringcaid){//TODO:根据类别ID取出该类别下的所有新闻DataTabledt=newDataTable();stringcmdText="news_selectByCaId";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@caid",caid)};dt=sqlhelper.ExecuteQuery(cmdText,paras,CommandType.StoredProcedure);returndt;}#endregion#region通过新闻ID查看新闻///<summary>///根据新闻ID取出该条新闻主体内容///</summary>///<paramname="id">新闻ID</param>///<returns></returns>publicNewsSelectById(stringid){//TODO:根据新闻ID取出该条新闻主体内容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>///根据标题搜索新闻///</summary>///<paramname="title">新闻标题关键字</param>///<returns></returns>publicDataTableSelectByTitle(stringtitle){//TODO:根据标题搜索新闻DataTabledt=newDataTable();stringcmdText="news_selectByTitle";SqlParameter[]paras=newSqlParameter[]{newSqlParameter("@title",title)};dt=sqlhelper.ExecuteQuery(cmdText,paras,CommandType.StoredProcedure);returndt;}#endregion#region通过内容查找新闻///<summary>///根据内容搜索新闻///</summary>///<paramname="content">新闻内容关键字</param>///<returns></returns>publicDataTableSelectByContent(stringcontent){//TODO:根据内容搜索新闻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">新闻实体现</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}}/**说明：新闻类别表的业务类*/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根据新闻ID取出该新闻的所有评论///<summary>///根据新闻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}}/**说明：登陆的业务逻辑类*/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);//产生验证码}}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()){//调用CommonClass类中的checkLogin方法，判断用户是否为合法用户intIntUserIn=CC.checkLogin(txtAdminName.Text.Trim(),txtAdminPwd.Text.Trim());if(IntUserIn>0){//该用户为合法用户，跳转到后台首页（AdminIndex.aspx）中Response.Write("<scriptlanguage=javascript>window.open('AdminIndex.aspx');window.close();</script>");}else{//该用户不是合法用户，调用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();//定义一个静态的全局变量，用于标识是否已单击站内搜索控钮publicstaticintIntSearch;protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){//页面初始化时，指定IntSearch=0IntSearch=0;//使用Request对象获取页面传递的值intn=Convert.ToInt32(Request.QueryString["id"]);//指定新闻类别名this.ddlNewsStyle.SelectedIndex=(n-1);this.bind();}}protectedvoidbind(){//调用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+"%'))";//调用CommonClass类的GetDataSet方法，获取符合条件的新闻信息//将获取的新闻信息绑定到数据控件GridView控件中gvNewsList.DataSource=CC.GetDataSet(strSql,"tbNews");gvNewsList.DataKeyNames=newstring[]{"id"};gvNewsList.DataBind();}protectedvoidgvNewsList_RowDeleting(objectsender,GridViewDeleteEventArgse){//调用CommonClass类的ExecSQL方法，删除指定的新闻CC.ExecSQL("deletefromtb_Newswhereid='"+this.gvNewsList.DataKeys[e.RowIndex].Value.ToString()+"'");if(IntSearch==1){this.searchBind();}else{bind();}}protectedvoidbtnSearch_Click(objectsender,EventArgse){//单击站内搜索按钮时，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==""){