/// <summary> /// 添加新闻 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_NewsTableData(News_Table obj) { return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"), CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@News_Content", obj.News_Content), new SqlParameter("@News_Date", obj.News_Date), new SqlParameter("@News_Anthor", obj.News_Anthor), new SqlParameter("@News_Name", obj.News_Name) })); }
/// <summary> /// 获取全部的新闻 /// </summary> /// <returns></returns> public List <News_Table> GetNewsTableAll() { List <News_Table> list = new List <News_Table>(); SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"), CommandType.StoredProcedure); while (dr.Read()) { News_Table obj = new News_Table() { News_id = Convert.ToInt32(dr["News_id"]), News_Content = dr["News_Content"].ToString(), News_Date = dr["News_Date"].ToString(), News_Anthor = dr["News_Anthor"].ToString(), News_Name = dr["News_Name"].ToString() }; list.Add(obj); } dr.Close(); return(list); }
/// <summary> /// 根据ID查询新闻信息 /// </summary> /// <param name="con"></param> /// <returns></returns> public News_Table GetNewsTableByConn(string con) { News_Table obj = null; SqlDataReader dr = DBHerlper.ExecuteReader( "Select * from News_Table where News_id=@News_id", CommandType.Text, new SqlParameter[] { new SqlParameter("@News_id", con) }); if (dr.Read()) { obj = new News_Table() { News_id = Convert.ToInt32(dr["News_id"]), News_Content = dr["News_Content"].ToString(), News_Date = dr["News_Date"].ToString(), News_Anthor = dr["News_Anthor"].ToString(), News_Name = dr["News_Name"].ToString() }; } dr.Close(); return(obj); }
/// <summary> /// 更改新闻信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Update_NewsTableData(News_Table obj) { return(relevanceClass.Update_NewsTableData(obj)); }
/// <summary> /// 添加新闻信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_NewsTableData(News_Table obj) { return(relevanceClass.Insert_NewsTableData(obj)); }