newsobj.cs

一个简单的新闻后台管理系统

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Data.SqlClient;
/// <summary>
/// NewsObj 的摘要说明


/// </summary>
public class NewsObj
{
	public NewsObj()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public static List<News> FindNewsInfo()
    {
        //定义一个新闻类集合
        List<News> news = new List<News>();
        DataSet ds = Newsmanager.FindNewsInfo();
        News newses = new News();
        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            //定义一个新闻类
            
            newses.NewsID = (int)dr["NewsID"];
            newses.NewsTitle = (string)dr["NewsTitle"];
            newses.NewsDate = (string)dr["NewsDate"];
            //数据实体当中并不包含className值，如果将classID先放进去，


            //然后再修改所属类别的模版，添加一个DropDownList再绑定一个数据源(不知道行不行)
            newses.ClassID = (int)dr["ClassID"];
            newses.NewsSource = (string)dr["NewSource"];
            news.Add(newses);
        }
        return news;
    }
    public static List<NewsClass> GetClass()
    {
        List<NewsClass> classID_Name = new List<NewsClass>();
        DataSet ds = Newsmanager.GetClass();
        NewsClass newsClass = new NewsClass();
        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            newsClass.ClassID=(int)dr["ClassID"];
            newsClass.ClassName=(string)dr["ClassName"];
            classID_Name.Add(newsClass);
        }
        return classID_Name;
        
    }
    public static void DeleteNews(int newsID)
    {
        SqlConnection con = DataAccess.CreateConnection();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "delete from t_News where NewsID=@newsID";
        cmd.Parameters.AddWithValue("@newsID", newsID);
        try
        {
            if (cmd.Connection.State == ConnectionState.Closed)
            {
                cmd.Connection.Open();
            }
            cmd.ExecuteNonQuery();
        }
        finally
        {
            if (cmd.Connection.State == ConnectionState.Open)
            {
                cmd.Connection.Close();
            }
            cmd.Dispose();
            con.Dispose();
        }
    }
}