sys.cs

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

//======================================================
//==     (c)2008 aspxcms inc by NeTCMS v1.0              ==
//==          Forum:bbs.aspxcms.com                   ==
//==         Website:www.aspxcms.com                  ==
//======================================================
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.DALProfile;
using NetCMS.Config;

namespace NetCMS.DALSQLServer
{
    public class Sys : DbBase, ISys
    {
        /// <summary>
        /// 检查新闻表数量
        /// </summary>
        /// <returns></returns>
        public DataTable GetTableRecord()
        {
            string Sql = "Select id From " + Pre + "sys_NewsIndex";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            return rdr;
        }

        /// <summary>
        /// 检查新闻表是否存在
        /// </summary>
        /// <param name="TableName"></param>
        /// <returns></returns>
        public DataTable GetTableExsit(string TableName)
        {
            string Sql = "Select tableName From " + Pre + "sys_NewsIndex Where tableName='" + TableName + "'";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            return rdr;
        }

        /// <summary>
        /// 插入表记录
        /// </summary>
        /// <param name="TableName"></param>
        public void InsertTableLab(string TableName)
        {
            string Sql = "Insert Into " + Pre + "sys_NewsIndex(TableName,CreatTime)Values('" + TableName + "','" + System.DateTime.Now + "')";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
        }

        /// <summary>
        /// 创建新表数据结构
        /// </summary>
        /// <param name="TableName"></param>
        public void CreatTableData(string TableName)
        {
            string Sql = " CREATE TABLE [dbo].[" + TableName + "](" +
                        "[Id] [int] IDENTITY (1, 1) NOT NULL ," +
                        "[NewsID] [nvarchar] (12) NOT NULL ," +
                        "[NewsType] [tinyint] NOT NULL ," +
                        "[OrderID] [tinyint] NOT NULL ," +
                        "[NewsTitle] [nvarchar] (100) NOT NULL ," +
                        "[sNewsTitle] [nvarchar] (100) NULL ," +
                        "[TitleColor] [nvarchar] (10) NULL ," +
                        "[TitleITF] [tinyint] NULL ," +
                        "[TitleBTF] [tinyint] NULL ," +
                        "[CommLinkTF] [tinyint] NULL ," +
                        "[SubNewsTF] [tinyint] NULL ," +
                        "[URLaddress] [nvarchar] (200) NULL ," +
                        "[PicURL] [nvarchar] (200) NULL ," +
                        "[SPicURL] [nvarchar] (200) NULL ," +
                        "[ClassID] [nvarchar] (12) NULL ," +
                        "[SpecialID] [nvarchar] (20) NULL ," +
                        "[Author] [nvarchar] (100) NULL ," +
                        "[Souce] [nvarchar] (100) NULL ," +
                        "[Tags] [nvarchar] (100) NULL ," +
                        "[NewsProperty] [nvarchar] (30) NULL ," +
                        "[NewsPicTopline] [tinyint] NULL ," +
                        "[Templet] [nvarchar] (200) NULL ," +
                        "[Content] [ntext] NULL ," +
                        "[Metakeywords] [nvarchar] (200) NULL ," +
                        "[Metadesc] [nvarchar] (200) NULL ," +
                        "[naviContent] [nvarchar](255) NULL ," +
                        "[Click] [int] NULL ," +
                        "[CreatTime] [datetime] NULL ," +
                        "[EditTime] [datetime] NULL ," +
                        "[SavePath] [nvarchar] (200) NULL ," +
                        "[FileName] [nvarchar] (100) NULL ," +
                        "[FileEXName] [nvarchar] (6) NULL ," +
                        "[isDelPoint] [tinyint] NULL ," +
                        "[Gpoint] [int] NULL ," +
                        "[iPoint] [int] NULL ," +
                        "[GroupNumber] [ntext] NULL ," +
                        "[ContentPicTF] [tinyint] NULL ," +
                        "[ContentPicURL] [nvarchar] (200) NULL ," +
                        "[ContentPicSize] [nvarchar] (10) NULL ," +
                        "[CommTF] [tinyint] NULL ," +
                        "[DiscussTF] [tinyint] NULL ," +
                        "[TopNum] [int] NULL ," +
                        "[VoteTF] [tinyint] NULL ," +
                        "[CheckStat] [nvarchar] (10) NULL ," +
                        "[isLock] [tinyint] NULL ," +
                        "[isRecyle] [tinyint] NULL ," +
                        "[SiteID] [nvarchar] (12) NULL ," +
                        "[DataLib] [nvarchar] (20) NULL ," +
                        "[DefineID] [tinyint] NULL ," +
                        "[isVoteTF] [tinyint] NULL ," +
                        "[Editor] [nvarchar] (18) NULL ," +
                        "[isConstr] [tinyint] NULL ," +
                        "[vURL] [nvarchar] (200) NULL ," +//视频地址
                        "[isFiles] [tinyint] NULL ," +
                        "[isHtml] [tinyint] NULL " +
                        ") ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]";
            Sql += "ALTER TABLE [dbo].[" + TableName + "] WITH NOCHECK ADD CONSTRAINT [PK_" + TableName + "] PRIMARY KEY  CLUSTERED([Id])  ON [PRIMARY] ";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
        }

        /// <summary>
        /// 检查新闻表是否存在
        /// </summary>
        /// <param name="TableName"></param>
        /// <returns></returns>
        public DataTable GetTableList()
        {
            string Sql = "select id,TableName,creattime From " + Pre + "sys_NewsIndex order by id desc";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            return rdr;
        }

        #region 常规管
        /// <summary>
        /// 删除单个记录
        /// </summary>
        /// <param name="TableName"></param>
        public void General_M_Del(int Gid)
        {
            string Sql = "Delete From " + Pre + "News_Gen where id=" + Gid + " " + NetCMS.Common.Public.getSessionStr() + "";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
        }
        /// <summary>
        /// 锁定单个记录
        /// </summary>
        /// <param name="TableName"></param>
        public void General_M_Suo(int Gid)
        {
            string Sql = "Update " + Pre + "News_Gen Set isLock=1 where id=" + Gid + " " + NetCMS.Common.Public.getSessionStr() + "";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
        }

        /// <summary>
        /// 解锁单个记录
        /// </summary>
        /// <param name="TableName"></param>
        public void General_M_UnSuo(int Gid)
        {
            string Sql = "Update " + Pre + "News_Gen Set isLock=0 where id=" + Gid + " " + NetCMS.Common.Public.getSessionStr() + "";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
        }

        /// <summary>
        /// 删除单个记录
        /// </summary>
        /// <param name="TableName"></param>
        public void General_DelAll()
        {
            string Sql = "Delete From " + Pre + "News_Gen where 1=1 " + NetCMS.Common.Public.getSessionStr() + "";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
        }

        public DataTable GetGeneralRecord(string Cname)
        {
            SqlParameter param = new SqlParameter("@Cname",Cname);
            string Sql = "Select Cname From " + Pre + "News_Gen Where Cname=@Cname " + NetCMS.Common.Public.getSessionStr() + "";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql,param);
            return rdr;
        }

        /// <summary>
        /// 插入表记录
        /// </summary>
        /// <param name="TableName"></param>
        public void insertGeneral(string _Sel_Type, string _Name, string _LinkUrl, string _Email)
        {
            SqlParameter[] parm = new SqlParameter[5];
            parm[0] = new SqlParameter("@_Sel_Type", SqlDbType.TinyInt,1);
            parm[0].Value =_Sel_Type;
            parm[1] = new SqlParameter("@_Name", SqlDbType.NVarChar,100);
            parm[1].Value = _Name;
            parm[2] = new SqlParameter("@_LinkUrl", SqlDbType.NVarChar,200);
            parm[2].Value = _LinkUrl;
            parm[3] = new SqlParameter("@_Email", SqlDbType.NVarChar,200);
            parm[3].Value = _Email;
            parm[4] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
            parm[4].Value = NetCMS.Global.Current.SiteID;
            string Sql = "Insert Into " + Pre + "news_Gen(gType,Cname,URL,EmailURL,SiteID) Values(@_Sel_Type,@_Name,@_LinkUrl,@_Email,@SiteID)";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
        }

        /// <summary>
        /// 修改表记录
        /// </summary>
        /// <param name="TableName"></param>
        public void UpdateGeneral(string _Sel_Type, string _Name, string _LinkUrl, string _Email, int GID)
        {

            SqlParameter[] parm = new SqlParameter[5];
            parm[0] = new SqlParameter("@_Sel_Type", SqlDbType.TinyInt, 1);
            parm[0].Value = _Sel_Type;
            parm[1] = new SqlParameter("@_Name", SqlDbType.NVarChar, 100);
            parm[1].Value = _Name;
            parm[2] = new SqlParameter("@_LinkUrl", SqlDbType.NVarChar, 200);
            parm[2].Value = _LinkUrl;
            parm[3] = new SqlParameter("@_Email", SqlDbType.NVarChar, 200);
            parm[3].Value = _Email;
            parm[4] = new SqlParameter("@GID", SqlDbType.Int,4);