newsclassmanager.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.Data.SqlClient;
/// <summary>
/// NewsClassManager 的摘要说明









/// </summary>
public class NewsClassManager
{
	public NewsClassManager()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public static DataSet FindNewsClass()
    {
        SqlConnection con = DataAccess.CreateConnection();
        string sql = "Select c.ClassID,c.ClassName,i.ItemName,c.ClassDesc,c.ClassOrder from t_Class as c t_Item as i ";
        SqlDataAdapter sda = new SqlDataAdapter(sql,con);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        return ds;
    }
    public static DataSet FindItemName()
    {
        SqlConnection con = DataAccess.CreateConnection();
        string sql = "Select ItemID,ItemName from t_Item";
        SqlDataAdapter sda = new SqlDataAdapter(sql,con);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        return ds;
    }
    public static int AddNewsClass(string className,int itemID,string classDesc,int classOrder)
    {
        int effectRows = 0;
        SqlConnection con = DataAccess.CreateConnection();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "insert into t_Class (ClassName,ClassDesc,ClassOrder,ItemID) values (@className,@classDesc,@classOrder,@itemID)";
        cmd.Parameters.Add("@className", SqlDbType.VarChar, 50).Value = className;
        cmd.Parameters.Add("@classDesc", SqlDbType.VarChar, 200).Value = classDesc;
        cmd.Parameters.Add("@classOrder", SqlDbType.Int).Value = classOrder;
        cmd.Parameters.Add("@itemID", SqlDbType.Int).Value = itemID;
        try
        {
            if (cmd.Connection.State == ConnectionState.Closed)
            {
                //打开连接
                cmd.Connection.Open();
            }
            effectRows = cmd.ExecuteNonQuery();
        }
        catch
        {
            // 捕获错误
        }
        
        finally
        {

            //释放资源
            if (con.State == ConnectionState.Open)
            {
                //关闭连接
                con.Close();
            }
            con.Dispose();
            cmd.Dispose();
        }
        //返回所影响的行数


        return effectRows;
    }
    
}