friend.cs

最好用的站点内容管理系统 全部源代码都有

//======================================================
//==     (c)2008 aspxcms inc by NeTCMS v1.0              ==
//==          Forum:bbs.aspxcms.com                   ==
//==         Website:www.aspxcms.com                  ==
//======================================================
using System;
using System.Data;
using System.Data.SqlClient;
using NetCMS.DALFactory;
using NetCMS.Model;
using NetCMS.Common;
using System.Text.RegularExpressions;
using System.Text;
using System.Reflection;
using NetCMS.DALProfile;
using NetCMS.Config;

namespace NetCMS.DALSQLServer
{
    public class Friend : DbBase, IFriend
    {
        public DataTable sel_friendInfo(string UserNum,int flag)
        {
            #region
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string Sql = null;
            if (flag == 0)//friend_add.aspx
            {
                Sql = "Select FriendName,HailFellow From " + Pre + "User_FriendClass where UserNum=@UserNum or gdfz='1'";
            }
            else if (flag == 1)
            {
                Sql = "Select Addfriendbs,UserNum,UserName From " + Pre + "sys_User where UserName=@UserNum";
            }
            else if (flag == 2)
            {
                Sql = "Select top 15 UserName From " + Pre + "User_Friend where UserNum=@UserNum";
            }
            else if (flag == 3)
            {
                Sql = "Select UserName,UserGroupNumber From " + Pre + "sys_user where UserNum=@UserNum";
            }
             return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
            #endregion
         }

        public string sel_userInfo(string UserNum,int flag)
        {
            #region
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string Sql = null;
            if (flag == 0)
            {
                Sql = "select ReadUser from " + Pre + "user_Group where GroupNumber=@UserNum";
            }
            else if (flag == 1)
            {
                Sql = "select qUsername from " + Pre + "User_Requestinformation where bUsername=@UserNum and ischick=1  order by id desc";
            }
            else if (flag == 2)//Requestinformation.aspx
            {
                Sql = "select Content from " + Pre + "User_Requestinformation where bUsername=@UserNum";
            }
            return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
            #endregion
        }

        public int sel_friendClass(string UserNum,int flag)
        {
            #region
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string Sql = null;
            if (flag == 0)
            {
                Sql="select count(*) from " + Pre + "User_FriendClass where UserNum=@UserNum";
            }
            else if (flag == 1)
            {
                Sql = "Select count(*) From " + Pre + "sys_user where UserName=@UserNum";
            }
            return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
            #endregion
        }

        public int add_Reformation(STRequestinformation Req, int flag)
        {
            #region
            string Sql = null;
            if (flag == 0)
            {
                Sql = "insert into " + Pre + "User_Requestinformation (qUsername,bUsername,datatime,Content,ischick) values(@qUserName,@bUserName,@CreatTime,@Content,1)";
            }
            else if (flag == 1)
            {
                Sql = "insert into " + Pre + "User_Requestinformation (qUsername,bUsername,datatime,Content,ischick) values(@qUserName,@bUserName,@CreatTime,@Content,0)";
            }
            SqlParameter[] parm = GetRequestinformation(Req);
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
            #endregion
        }

        public int add_Friend(STFriend Fri, string UserNum,int flag)
        {
            #region
            string Sql = null;
            if (flag == 0)
            {
                Sql = "insert into " + Pre + "User_Friend (FriendUserNum,UserNum,UserName,bUserNum,HailFellow,CreatTime,hyyz) values(@FriendUserNum,@UserNum,@bUserName,@bdUserName,@HailFellow,@CreatTime,1)";
            }
            else if (flag == 1)
            {
                Sql = "insert into " + Pre + "User_Friend (FriendUserNum,UserNum,UserName,bUserNum,HailFellow,CreatTime,hyyz) values(@FriendUserNum,@UserNum,@bUserName,@bdUserName,@HailFellow,@CreatTime,0)";
            }
            SqlParameter[] parm = GetFriend(Fri);
            int i_length = parm.Length;
            Array.Resize<SqlParameter>(ref parm, i_length + 1);
            parm[i_length] = new SqlParameter("@UserNum", UserNum);
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
            #endregion
        }

        public int del_Friend(string FriendUserNum,int flag)
        {
            #region
            SqlParameter param = new SqlParameter("@FriendUserNum", FriendUserNum);
            string Sql = null;
            if (flag == 0)//friendList.aspx
            {
                Sql = "Delete  " + Pre + "User_Friend where FriendUserNum=@FriendUserNum";
            }
            else if (flag == 1)//friendmanage.aspx
            {
                Sql = "Delete  " + Pre + "User_FriendClass where HailFellow=@FriendUserNum";
            }
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            #endregion
        }

        public int update_Information(string bUsername, string qUsername,int flag)
        {
            #region
            SqlParameter[] param = new SqlParameter[] { new SqlParameter("@bUserName", bUsername), new SqlParameter("@qUsername", qUsername) };
            string Sql = null;
            if (flag == 0)
            {
                Sql = "update " + Pre + "User_Requestinformation set ischick=0 where bUsername=@bUserName and qUsername=@qUsername";
            }
            else if (flag == 1)
            {
                Sql = "update " + Pre + "User_Friend set hyyz='0' where bUserNum=@bUserName and UserNum=@qUsername";
            }
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            #endregion
        }

        #region friend_add.aspx
        public int sel_userFriend(string UserNum, string bUserName)
        {
            SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserNum", UserNum), new SqlParameter("@bUserName", bUserName) };
            string Sql = "Select count(*) From " + Pre + "User_Friend where UserNum=@UserNum and UserName=@bUserName";
            return (int)DbHelper.ExecuteScalar(CommandType.Text, Sql, param);
        }
        private SqlParameter[] GetRequestinformation(STRequestinformation Req)
        {
            #region
            SqlParameter[] parm = new SqlParameter[4];
            parm[0] = new SqlParameter("@qUserName", SqlDbType.NVarChar, 50);
            parm[0].Value = Req.qUsername;
            parm[1] = new SqlParameter("@bUserName", SqlDbType.NVarChar, 50);
            parm[1].Value = Req.bUsername;
            parm[2] = new SqlParameter("@Content", SqlDbType.NVarChar, 50);
            parm[2].Value = Req.Content;
            parm[3] = new SqlParameter("@CreatTime", SqlDbType.DateTime);
            parm[3].Value = DateTime.Now;
            return parm;
            #endregion
        }
        private SqlParameter[] GetFriend(STFriend Fri)
        {
            #region
            SqlParameter[] parm = new SqlParameter[5];
            parm[0] = new SqlParameter("@bUserName", SqlDbType.NVarChar, 50);
            parm[0].Value = Fri.UserName;
            parm[1] = new SqlParameter("@bdUserName", SqlDbType.NVarChar, 50);
            parm[1].Value = Fri.bUserNum;
            parm[2] = new SqlParameter("@HailFellow", SqlDbType.NVarChar, 50);
            parm[2].Value = Fri.HailFellow;
            parm[3] = new SqlParameter("@CreatTime", SqlDbType.DateTime);
            parm[3].Value = DateTime.Now;
            parm[4] = new SqlParameter("@FriendUserNum", SqlDbType.NVarChar, 50);
            parm[4].Value = Rand.Number(12);
            return parm;
            #endregion
        }
        #endregion

        #region friend_Establishment.aspx
        public string sel_sysUser(string UserNum)
        {
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string Sql = "Select Addfriendbs From " + Pre + "sys_user where UserNum=@UserNum";
            string ret = Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
            if (ret == null && ret == "")
                throw new Exception("对不起,数据错误!");
            else
                return ret;
        }
        public int Update(int FE, string UserNum)
        {
            SqlParameter param = new SqlParameter("@UserNum", UserNum);
            string Sql = "update " + Pre + "sys_user set Addfriendbs='" + FE + "'where UserNum=@UserNum";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        #endregion

        #region friendmanage_add.aspx
        public string sel_friendClass()
        {
            string Sql = "select HailFellow from " + Pre + "User_FriendClass";
            return (string)DbHelper.ExecuteScalar(CommandType.Text, Sql, null);
        }
        public int add_friendClass(STFriendClass FCl, string UserNum)
        {
            string Sql = "insert into " + Pre + "User_FriendClass(UserNum,FriendName,Content,CreatTime,HailFellow)values(@UserNum,@FriendName,@Contents,@CreatTime,@HailFellow)";
            SqlParameter[] parm = GetFriendClass(FCl);
            int i_length = parm.Length;
            Array.Resize<SqlParameter>(ref parm, i_length + 1);
            parm[i_length] = new SqlParameter("@UserNum", UserNum);
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
        }
        private SqlParameter[] GetFriendClass(STFriendClass FCl)
        {
            #region
            SqlParameter[] parm = new SqlParameter[4];
            parm[0] = new SqlParameter("@FriendName", SqlDbType.NVarChar, 50);
            parm[0].Value = FCl.FriendName;
            parm[1] = new SqlParameter("@Contents", SqlDbType.NVarChar, 50);
            parm[1].Value = FCl.Content;
            parm[2] = new SqlParameter("@HailFellow", SqlDbType.NVarChar, 50);
            parm[2].Value = FCl.HailFellow;
            parm[3] = new SqlParameter("@CreatTime", SqlDbType.DateTime);
            parm[3].Value = DateTime.Now;
            return parm;
            #endregion
        }
        #endregion

        #region Requestinformation.aspx

        public int add_userFriend(string FriendUserNum, string UserNum, string bUserName, string bdUserName, string Hail_Fellow, DateTime CreatTime)
        {
            SqlParameter[] param = new SqlParameter[] { new SqlParameter("@FriendUserNum", FriendUserNum), new SqlParameter("@UserNum", UserNum), new SqlParameter("@bUserName", bUserName), new SqlParameter("@bdUserName", bdUserName), new SqlParameter("@Hail_Fellow", Hail_Fellow), new SqlParameter("@CreatTime", CreatTime) };
            string Sql = "insert into " + Pre + "User_Friend (FriendUserNum,UserNum,UserName,bUserNum,HailFellow,CreatTime,hyyz) values(@FriendUserNum,@UserNum,@bUserName,@bdUserName,@Hail_Fellow,@CreatTime,0)";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        public int del_userInfo(string UserName, int ID)
        {
            SqlParameter param = new SqlParameter("@UserName", UserName);
            string Sql = "delete " + Pre + "User_Requestinformation where bUserName=@UserName and ID=" + ID + "";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        #endregion
    }
}