/// <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));
}
