newsmanager.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>
/// Newsmanage 的摘要说明


/// </summary>
public class Newsmanager
{
	public Newsmanager()
	{
	}
  
    public static DataSet FindNewsInfo()
    {
        SqlConnection con = DataAccess.CreateConnection();
        string sql = "Select * from t_news";
        SqlDataAdapter sda = new SqlDataAdapter(sql, con);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        return ds;
    }
    public static DataSet GetClass()
    {
        SqlConnection con = DataAccess.CreateConnection();
        string sql = "Select ClassID,ClassName  from t_Class";
        SqlDataAdapter sda = new SqlDataAdapter(sql, con);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        return ds;
    }
    //public static int AddNewsInfo(string newsTitle,int classID,string userName,int userID,string newsDate,string newsKey,string newsSource,string newsConten)
    //{
    //    //因为发布人填写的是发布人的userName,所以在这里应该检测一下是否有这个发布人，具体实现好好想想。



    //    SqlConnection con = DataAccess.CreateConnection();
    //    SqlCommand cmd = new SqlCommand();
    //    cmd.Connection = con;
    //    cmd.CommandText = "Select userID from t_newsUser where UserName=@userName";
    //    cmd.Parameters.AddWithValue("@userName", userName);
    //    string userID = null;//定义一个userName变量记录这



    //    try 
    //    {
    //        if (cmd.Connection.State == ConnectionState.Closed)
    //        {
    //            cmd.Connection.Open();
    //        }
    //        cmd.ExecuteScalar();
    //    }
    //}
   
}