friend.cs

oa办公系统

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;
using System.Collections;

/// <summary>
/// friend 的摘要说明
/// </summary>
public class friend
{
	public friend()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    //查询通讯录类型
    public DataView Select_FriendType(int u_id)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("Select_friendtype", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        sda.SelectCommand.Parameters.Add("@s_id", SqlDbType.Int).Value = u_id;
        DataSet ds = new DataSet();
        try
        {
            sda.Fill(ds, "selfriend");
            DataView dv = ds.Tables["selfriend"].DefaultView;
            return dv;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }
    //添加通讯录分类名称
    public void AddFriendType(int u_id,string typename)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("add_friendtype", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = u_id;
        cmd.Parameters.Add("@t_name", SqlDbType.VarChar, 100).Value = typename;
        try
        {
            cmd.ExecuteNonQuery();
            con.Close();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    //修改通讯录名称
    public void updateFriendType(int u_id, string typename)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("update_friendtype", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@t_id", SqlDbType.Int).Value = u_id;
        cmd.Parameters.Add("@t_name", SqlDbType.VarChar, 100).Value = typename;
        try
        {
            cmd.ExecuteNonQuery();
            con.Close();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    //删除通讯录名称
    public void deleteFriendType(string u_id)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("delete_friendtype", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@t_id", SqlDbType.Int).Value = u_id;
        try
        {
            cmd.ExecuteNonQuery();
            con.Close();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    

    //添加通信录信息
    public void Addfriend(ArrayList arr)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("insert_friend", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@s_id", SqlDbType.Int).Value = arr[0];
        cmd.Parameters.Add("@f_type", SqlDbType.VarChar, 5).Value = arr[1];
        cmd.Parameters.Add("@t_id", SqlDbType.Int).Value = arr[2];
        cmd.Parameters.Add("@f_name", SqlDbType.VarChar, 50).Value = arr[3];
        cmd.Parameters.Add("@f_mobile", SqlDbType.VarChar, 20).Value = arr[4];
        cmd.Parameters.Add("@f_cphome", SqlDbType.VarChar, 20).Value = arr[5];
        cmd.Parameters.Add("@f_hphome", SqlDbType.VarChar, 20).Value = arr[6];
        cmd.Parameters.Add("@f_email", SqlDbType.VarChar, 20).Value = arr[7];
        cmd.Parameters.Add("@f_haddress", SqlDbType.Text).Value = arr[8];
        cmd.Parameters.Add("@f_caddress", SqlDbType.Text).Value = arr[9];
        cmd.Parameters.Add("@f_num",SqlDbType.VarChar,20).Value = arr[10];
        cmd.Parameters.Add("@f_message", SqlDbType.Text).Value = arr[11];
        try
        {
            cmd.ExecuteNonQuery();
            con.Close();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    //更新通信录记录
    public void UpdateFriend(ArrayList UpFriend)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("update_friend", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@f_id", SqlDbType.Int).Value = UpFriend[0];
        cmd.Parameters.Add("@f_type", SqlDbType.VarChar, 5).Value = UpFriend[1];
        cmd.Parameters.Add("@t_id", SqlDbType.Int).Value = UpFriend[2];
        cmd.Parameters.Add("@f_name", SqlDbType.VarChar, 50).Value = UpFriend[3];
        cmd.Parameters.Add("@f_mobile", SqlDbType.VarChar, 20).Value = UpFriend[4];
        cmd.Parameters.Add("@f_cphome", SqlDbType.VarChar, 20).Value = UpFriend[5];
        cmd.Parameters.Add("@f_hphome", SqlDbType.VarChar, 20).Value = UpFriend[6];
        cmd.Parameters.Add("@f_email", SqlDbType.VarChar, 20).Value = UpFriend[7];
        cmd.Parameters.Add("@f_haddress", SqlDbType.Text).Value = UpFriend[8];
        cmd.Parameters.Add("@f_caddress", SqlDbType.Text).Value = UpFriend[9];
        cmd.Parameters.Add("@f_num", SqlDbType.VarChar, 20).Value = UpFriend[10];
        cmd.Parameters.Add("@f_message", SqlDbType.Text).Value = UpFriend[11];
        try
        {
            cmd.ExecuteNonQuery();
            con.Close();
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    //查询通讯录信息（全部）
    public DataView Select_MyFriend(string u_id)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("select_friend", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        sda.SelectCommand.Parameters.Add("@s_id", SqlDbType.Int).Value = u_id;
        DataSet ds = new DataSet();
        try
        {
            sda.Fill(ds, "selfriends");
            DataView dv = ds.Tables["selfriends"].DefaultView;
            return dv;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }

    //根据分类查询通讯录信息
    public DataView Select_TypeFriend(string t_name)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("Selete_TypeFriend", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        sda.SelectCommand.Parameters.Add("@f_type", SqlDbType.VarChar,50).Value = t_name;
        DataSet ds = new DataSet();
        try
        {
            sda.Fill(ds, "selfriends");
            DataView dv = ds.Tables["selfriends"].DefaultView;
            return dv;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }
    //根据姓名迷糊查询通讯录信息
    public DataView Select_NameFriend(string f_name)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("select_NameFriend", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        sda.SelectCommand.Parameters.Add("@f_name", SqlDbType.VarChar, 50).Value = f_name;
        DataSet ds = new DataSet();
        try
        {
            sda.Fill(ds, "selfriends");
            DataView dv = ds.Tables["selfriends"].DefaultView;
            return dv;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }
    //根据通讯录ID号查询通讯录信息信息
    public SqlDataReader Select_IdFriendInfo(string f_id)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["office"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("select_IdFriend", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@f_id", SqlDbType.Int).Value =f_id;
        try
        {
            SqlDataReader dr = cmd.ExecuteReader();
            return dr;
        }
        catch (Exception err)
        {
            throw new System.Exception(err.Message);
        }
    }
}