dcontent.cs

搜索网上电子邮件,加入url就可搜索,用c#编写

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.OleDb;

/// <summary>
/// Summary description for DContent
/// </summary>
public class DContent
{

    static AConn _handle = new AConn();
	public DContent()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    /// <summary>
    /// 添加EMAIL
    /// </summary>
    public static void Add(string title,string body)
    {
        string sql = "INSERT INTO Email(title,content) values('"+title+"','"+body+"')";
        _handle.GetCount(sql);
    }
    /// <summary>
    /// 删除信息
    /// </summary>
    /// <param name="id"></param>
    public static void Delete(int id)
    {
        string sql = "DELETE FROM email WHERE id="+id.ToString();
        _handle.GetCount(sql);
    }
    /// <summary>
    /// 修改EMAIL信息
    /// </summary>
    /// <param name="title"></param>
    /// <param name="body"></param>
    /// <param name="id"></param>
    public static void Edit(string title, string body,int id)
    {
        string sql = "UPDATE email SET title='" + title + "',content='" + body + "'  WHERE id=" + id.ToString();
        _handle.GetCount(sql);
    }
    /// <summary>
    /// 获取邮件标题列表
    /// </summary>
    /// <returns></returns>
    public static DataTable GetList()
    {
        string sql = "select ID,title,AddTime from email order by ID desc";
        return _handle.GetDataSet(sql).Tables[0];
    }
    /// <summary>
    /// 获取一个MAIL信息
    /// </summary>
    /// <param name="id"></param>
    /// <returns></returns>
    public static DataTable GetMail(int id)
    {
        string sql = "select * from email WHERE id="+id.ToString();
        return _handle.GetDataSet(sql).Tables[0];
    }
}