newsclassobj.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>
/// NewsClassObj 的摘要说明



/// </summary>
public class NewsClassObj
{
	public NewsClassObj()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public static List<NewsClass> FindNewsClass()
    {
        List<NewsClass> newsClass = new List<NewsClass>();
        DataSet ds = NewsClassManager.FindNewsClass();
        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            newsClass.Add(new NewsClass((int)dr["ClassID"],(string)dr["ClassName"],(string)dr["ClassDesc"],(int)dr["ClassOrder"],(int)dr["ItemID"],(string)dr["ItemName"]));  
        }
        return newsClass;
    }
    public static List<NewsClass> GetItem()
    {
        List<NewsClass> itemID_Name = new List<NewsClass>();
        DataSet ds = NewsClassManager.FindItemName();
        NewsClass item = new NewsClass();
        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            item.ItemID = (int)dr["ItemID"];
            item.ItemName = (string)dr["ItemName"];
            itemID_Name.Add(item);
        }
        return itemID_Name;
    }
    public static void DeleteNewsClass(int classID)
    {

        SqlConnection con = DataAccess.CreateConnection();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "delete from t_class where ClassID=@classID";
        cmd.Parameters.AddWithValue("@classID", classID);
        try
        {
            if (cmd.Connection.State == ConnectionState.Closed)
            {
                cmd.Connection.Open();
            }
             cmd.ExecuteNonQuery();
        }
        finally
        {

            //释放资源
            if (con.State == ConnectionState.Open)
            {
                con.Close();
            }
            con.Dispose();
            cmd.Dispose();
        }
    }
    public static void UpdateNewsClass(int classID, string className, int itemID, string classDesc, int classOrder)
    {

        SqlConnection con = DataAccess.CreateConnection();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "Update t_Class Set classID=@classID, className=@className,classDesc=@classOrder,itemID=@itemID WHERE classID=@classID ";
        cmd.Parameters.AddWithValue("@className", className);
        cmd.Parameters.AddWithValue("@classOrder", classOrder);
        cmd.Parameters.AddWithValue("@classID", classID);
        cmd.Parameters.AddWithValue("@classDesc", classDesc);
        cmd.Parameters.AddWithValue("@itemID", itemID);
        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();
        }

    }
}