frindlink.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 System.Text.RegularExpressions;
using System.Text;
using System.Reflection;
using NetCMS.Common;
using NetCMS.DALProfile;
using NetCMS.Config;

namespace NetCMS.DALSQLServer
{
    public class FrindLink : DbBase, IFrindLink
    {
        public DataTable GetClass()//取连接的分类
        {
            string Sql = "Select ClassID,ClassCName,ParentID From " + Pre + "friend_class where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
        }
        public DataTable ParamStart()//取友情连接参数设置情况
        {
            string Str_StartSql = "Select * From " + Pre + "friend_pram";//从参数设置表中读出数据并初始化赋值
            return DbHelper.ExecuteTable(CommandType.Text, Str_StartSql, null);
        }
        public int Update_Pram(int open, int IsReg, int isLok, string Str_ArrSize, string Str_Content)//修改参数设置
        {
            SqlParameter[] param = new SqlParameter[2];
            param[0] = new SqlParameter("@ArrSize", SqlDbType.NVarChar, 10);
            param[0].Value = Str_ArrSize;
            param[1] = new SqlParameter("@Content", SqlDbType.NText);
            param[1].Value = Str_Content;
            string Str_InSql = "Update " + Pre + "friend_pram Set IsOpen=" + open + ",IsRegister=" + IsReg + ",isLock = " + isLok + ",ArrSize=@ArrSize,Content=@Content,SiteID=" + NetCMS.Global.Current.SiteID + "";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_InSql, param);
        }
        //----------------分类分页-------------------
        //------递归---------------------------------
        public DataTable GetChildClassList(string classid)
        {
            SqlParameter param = new SqlParameter("@classid", classid);
            string Str = "Select id,ClassID,ClassCName,Content,ParentID From " + Pre + "friend_class Where ParentID=@classid and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Str, param);
        }
        //-------------------------------------------
        public int IsExitClassName(string Str_ClassID)
        {
            SqlParameter param = new SqlParameter("@ClassID", Str_ClassID);
            string Str = " Select count(ClassID) From " + Pre + "friend_class where ClassID=@ClassID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return (int)DbHelper.ExecuteScalar(CommandType.Text, Str, param);
        }
        public int ISExitNam(string name)
        {
            SqlParameter param = new SqlParameter("@ClassCName", name);
            string Str_CheckSql = "Select count(ClassCName) From " + Pre + "friend_class Where ClassCName=@ClassCName and SiteID='" + NetCMS.Global.Current.SiteID + "'"; ;
            return (int)DbHelper.ExecuteScalar(CommandType.Text, Str_CheckSql, param);
        }
        public int Insert_Class(string Str_ClassID, string Str_ClassCName, string Str_ClassEName, string Str_Description, string parentid)
        {
            SqlParameter[] param = new SqlParameter[5];
            param[0] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 10);
            param[0].Value = Str_ClassID;
            param[1] = new SqlParameter("@ClassCName", SqlDbType.NText);
            param[1].Value = Str_ClassCName;
            param[2] = new SqlParameter("@ClassEName", SqlDbType.NText);
            param[2].Value = Str_ClassEName;
            param[3] = new SqlParameter("@Content", SqlDbType.NText);
            param[3].Value = Str_Description;
            param[4] = new SqlParameter("@ParentID", SqlDbType.NText);
            param[4].Value = parentid;

            string Str_InSql = "Insert into " + Pre + "friend_class (ClassID,ClassCName,ClassEName,Content,ParentID,SiteID) Values(@ClassID,@ClassCName,@ClassEName,@Content,@ParentID,'" + NetCMS.Global.Current.SiteID + "')";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_InSql, param);

        }
        public int del_oneClass_1(string fid)
        {
            SqlParameter param = new SqlParameter("@ClassID", fid);
            string Str_FriSql = "Delete From " + Pre + "friend_class where ClassID=@ClassID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_FriSql, param);
        }
        public int del_oneClass_2(string fid)
        {
            SqlParameter param = new SqlParameter("@ParentID", fid);
            string Str_Fri_child_Sql = "Delete From " + Pre + "friend_class where ParentID=@ParentID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_Fri_child_Sql, param);
        }
        public int del_onelink(int fid)
        {
            SqlParameter param = new SqlParameter("@ID", fid);
            string Str_FriSql = "Delete From " + Pre + "friend_link where ID=@ID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_FriSql, param);
        }
        public int suo_onelink(int fid)
        {
            SqlParameter param = new SqlParameter("@id", fid);
            string Str_FriSql = "Update " + Pre + "friend_link Set Lock = 1 where id=@id and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_FriSql, param);
        }
        public int unsuo_onelink(int fid)
        {
            SqlParameter param = new SqlParameter("@id", fid);
            string Str_FriSql = "Update " + Pre + "friend_link Set Lock = 0 where id=@@id and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_FriSql, param);
        }
        public DataTable EditClass(string classid)
        {
            SqlParameter param = new SqlParameter("@ClassID", classid);
            string Str_FriSql = "Select id,ClassID,ClassCName,ClassEName,Content,ParentID From " + Pre + "friend_class where ClassID=@ClassID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Str_FriSql, param);
        }
        public int EditClick(string FID, string Str_ClassNameE, string Str_EnglishE, string Str_Descript)
        {
            SqlParameter[] param = new SqlParameter[4];
            param[0] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 12);
            param[0].Value = FID;
            param[1] = new SqlParameter("@ClassCName", SqlDbType.NVarChar, 12);
            param[1].Value = Str_ClassNameE;
            param[2] = new SqlParameter("@ClassEName", SqlDbType.NVarChar, 50);
            param[2].Value = Str_EnglishE;
            param[3] = new SqlParameter("@Content", SqlDbType.NText);
            param[3].Value = Str_Descript;

            string Str_UpdateSql = "Update " + Pre + "friend_class Set ClassCName=@ClassCName,ClassEName=@ClassEName,Content=@Content where ClassID=@ClassID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_UpdateSql, param);
        }
        public int _DelPClass(string boxs)
        {
            string Fri_Sql = "Delete From " + Pre + "friend_class where ClassID in('" + boxs + "') and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Fri_Sql, null);