newsitemobj.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;
using System.Collections;

/// <summary>
/// NewsItemObj 的摘要说明

/// </summary>
public class NewsItemObj
{
	public NewsItemObj()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public static List<NewsItem> FindNewsItem()
    {
        List<NewsItem> newsItem = new List<NewsItem>();
        DataSet ds = NewsItemManager.FindNewsItem();
        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            newsItem.Add(new NewsItem((int)dr["ItemID"],(string)dr["ItemName"],(string)dr["ItemDesc"],(int)dr["ItemOrder"])) ;
        }
        return newsItem;
    }

    public static void UpdateNewsItem(int itemID, string itemName, string itemDesc, int itemOrder)
    {
        
        SqlConnection con = DataAccess.CreateConnection();
        SqlCommand com = new SqlCommand();
        com.Connection = con;
        com.CommandText = "Update t_Item set  ItemName=@itemName , ItemDesc=@itemDesc , ItemOrder=@itemOrder where ItemID=@itemID";
        com.Parameters.AddWithValue("@itemID", itemID);
        com.Parameters.AddWithValue("@itemName", itemName);
        com.Parameters.AddWithValue("@itemDesc", itemDesc);
        com.Parameters.AddWithValue("@itemOrder", itemOrder);
        try
        {
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            com.ExecuteNonQuery();
        }
        catch(Exception err)
        {            
            //Console.WriteLine(err.Message);
        }

        finally
        {
            //释放资源
            if (con.State == ConnectionState.Open)
            {
                con.Close();
            }
            con.Dispose();
            com.Dispose();
        }
    }
    public static void DelNewsItem(int itemID)
    {
        SqlConnection con = DataAccess.CreateConnection();
        SqlCommand com = new SqlCommand();
        com.Connection = con;
        try
        {
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            com.CommandText = "select classID from t_Class where itemID=@itemID";
            com.Parameters.AddWithValue("@itemID", itemID);
            SqlDataReader dr = com.ExecuteReader();

            com.Parameters.Clear();

            ArrayList classID = new ArrayList();
            while (dr.Read())
            {

                classID.Add(dr.GetValue(0));

            }
            dr.Close();
            dr.Dispose();
            for (int i = 0; i < classID.Count; i++)
            {
                com.CommandText = "delete from t_News where ClassID='" + classID[i].ToString() + "'";
                com.ExecuteNonQuery();
                com.CommandText = "delete from t_Popedom where ClassID='" + classID[i].ToString() + "'";
                com.ExecuteNonQuery();

            }

            com.CommandText = "delete from t_Class where itemID=@itemID";
            com.Parameters.AddWithValue("@itemID", itemID);
            com.ExecuteNonQuery();
            com.Parameters.Clear();

            //为com对象指定sql命令删除表中的数据，条件是获取的主键值

            com.CommandText = "delete from t_Item where itemid=@itemID ";

            //添加参数ItemID
            com.Parameters.AddWithValue("@itemID", itemID);            
            com.ExecuteNonQuery();
            //throw new NullReferenceException();
        }
        catch (Exception err)
        {
            throw err;
        }
        finally
        {
            //释放资源
            if (con.State == ConnectionState.Open)
            {
                con.Close();
            }
            con.Dispose();
            com.Dispose();
        }
      
    }
    
   
}