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

/// <summary>
/// Summary description for DGroup
/// </summary>
public class DGroup
{
    static AConn _handle = new AConn();
	public DGroup()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    /// <summary>
    /// 添加组
    /// </summary>
    /// <param name="name"></param>
    /// <returns></returns>
    public static int Add(string name)
    {
        string sql = "insert into [Group](Name) values('"+name+"')";
        return _handle.GetCount(sql);
    }
    public static DataTable GetList()
    {
        return _handle.GetDataSet("select * from [Group] ").Tables[0];
    }
    /// <summary>
    /// 重命名
    /// </summary>
    /// <param name="ID"></param>
    /// <param name="name"></param>
    /// <returns></returns>
    public static int ReName(int ID, string name)
    {
        string sql = "update [Group] set Name='" + name + "' where ID="+ID.ToString();
        return _handle.GetCount(sql);
    }
    /// <summary>
    /// 删除
    /// </summary>
    /// <param name="id"></param>
    /// <returns></returns>
    public static int Delete(int id)
    {
        string sql = "delete from  [Group]  where ID=" + id.ToString();
        return _handle.GetCount(sql);
    }
    public static void BindControl(ref DropDownList ddl, string val)
    {
        ddl.DataSource = GetList();
        ddl.DataTextField = "Name";
        ddl.DataValueField = "ID";
        ddl.DataBind();
        ddl.Items.Insert(0, new ListItem("默认","0"));
        if (ddl.Items.FindByValue(val) != null)
        {
            ddl.SelectedValue = val;
        }
    }
    ///ListBox
    public static void BindControl(ref ListBox lb, string val)
    {
        lb.DataSource = GetList();
        lb.DataTextField = "Name";
        lb.DataValueField = "ID";
        lb.DataBind();
        lb.Items.Insert(0, new ListItem("默认", "0"));
        if (lb.Items.FindByValue(val) != null)
        {
            lb.SelectedValue = val;
        }
    }
}