dmaillist.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.Collections;
/// <summary>
/// Summary description for MailList
/// </summary>
public class DMailList
{
   static AConn _handle = new AConn();
	public DMailList()
	{
		//
		// TODO: Add constructor logic here
		//
        
	}
    /// <summary>
    /// 添加信息
    /// </summary>
    /// <param name="mail"></param>
    /// <param name="groupID"></param>
    public static void Add(string mail,int groupID)
    {
        if (!chkExit(mail)) //检测重复
        {
            string sql = " INSERT INTO EmailList(EMAIL,groupID)  Values('" + mail + "'," + groupID + ");";
            _handle.GetCount(sql);
        }

    }
    /// <summary>
    /// 修改
    /// </summary>
    /// <param name="name"></param>
    /// <param name="groupID"></param>
    /// <param name="ID"></param>
    public static void Edit(string name,int groupID,int ID)
    {
        string sql = " Update EmailList  set EMAIL='" + name + "',groupID=" + groupID + " where ID=" + ID.ToString();
        _handle.GetCount(sql);
    }
    /// <summary>
    /// 删除
    /// </summary>
    /// <param name="id"></param>
    public static void Delete(int id)
    {
        string sql = "Delete from EmailList where ID="+id.ToString();
        _handle.GetCount(sql);
    }
    private static bool chkExit(string mail)
    {
        string sql = "select count(*) from EmailList where Email='"+mail+"'";
        object o = _handle.GetScalar(sql);
        if (Convert.ToInt32(o) > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }

    /// <summary>
    /// 获取邮件列表[联表数据]
    /// </summary>
    /// <param name="groupID"></param>
    /// <returns></returns>
    public static DataTable GetList(int groupID)
    {
        string sql = " select A.*,B.Name from EmailList A LEFT JOIN [GROUP] B ON A.GroupID=B.ID ";
        if (groupID > 0)
        {
            sql += " where GroupID="+groupID;
        }
        sql += " order by A.Id desc";
        return _handle.GetDataSet(sql).Tables[0];
    }
    public static int GetCount(int groupID)
    {
        string sql = " select Count(*) from EmailList  ";
        if (groupID > 0)
        {
            sql += " where GroupID=" + groupID;
        }
        int n=Convert.ToInt32(_handle.GetScalar(sql));
        return n;
    }
    /// <summary>
    /// 非联表数据
    /// </summary>
    /// <param name="groupID"></param>
    /// <returns></returns>
    public static DataTable GetEmailList(int groupID)
    {
        string sql = " select  *  from EmailList A   ";
        if (groupID > 0)
        {
            sql += " where GroupID=" + groupID;
        }
        sql += " order by A.Id desc";
        return _handle.GetDataSet(sql).Tables[0];
    }
    public static ArrayList MailList(int groupID)
    {
        DataTable dt = GetEmailList(groupID);
        int n=dt.Rows.Count;
        if (n > 0)
        {
            ArrayList al = new ArrayList(n);
            for (int i = 0; i < n; i++)
            {
                al.Add(dt.Rows[i]["email"]);
            }
            return al;
        }
        else
            return new ArrayList();
    }
}