dsender.cs

来自「搜索网上电子邮件,加入url就可搜索,用c#编写」· CS 代码 · 共 83 行

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;

/// <summary>
/// Summary description for DSender
/// </summary>
public class DSender
{
    static AConn _handle = new AConn();
	public DSender()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    /// <summary>
    /// 添加EMAIL
    /// </summary>
    public static void Add(string email, string password,string smtp)
    {
        string sql = "INSERT INTO Sender(email,[password],smtp) values('" + email + "','" + password + "','"+smtp+"')";
        _handle.GetCount(sql);
    }
    /// <summary>
    /// 删除信息
    /// </summary>
    /// <param name="id"></param>
    public static void Delete(int id)
    {
        string sql = "DELETE FROM Sender 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 email, string password, string smtp, int id)
    {
        string sql = "UPDATE Sender SET email='" + email + "',[password]='" + password + "',Smtp='" + smtp + "'  WHERE id=" + id.ToString();
        _handle.GetCount(sql);
    }
    /// <summary>
    /// 获取邮件标题列表
    /// </summary>
    /// <returns></returns>
    public static DataTable GetList()
    {
        string sql = "select * from Sender order by ID desc";
        return _handle.GetDataSet(sql).Tables[0];
    }
    public static DataTable GetList(string ids)
    {
        if(string.IsNullOrEmpty(ids))
        {
            return GetList();
        }
        else
        {
            string sql = "select * from Sender where ID in ("+ids+") order by ID desc";
            return _handle.GetDataSet(sql).Tables[0];
        }
    }
    /// <summary>
    /// 获取一个MAIL信息
    /// </summary>
    /// <param name="id"></param>
    /// <returns></returns>
    public static DataTable GetInfo(int id)
    {
        string sql = "select * from Sender WHERE id=" + id.ToString();
        return _handle.GetDataSet(sql).Tables[0];
    }
}